hkk101_mcp-server-mysql
If you are the rightful owner of hkk101_mcp-server-mysql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
The MCP Server for MySQL based on NodeJS is designed to facilitate read-only interactions with MySQL databases. It allows Language Model Machines (LLMs) to access and inspect database schemas, as well as execute read-only SQL queries. This server is particularly useful for applications that require database schema information without the need for data modification. The server operates by connecting to a specified MySQL database and providing JSON schema information for each table, including column names and data types. All SQL queries are executed within a read-only transaction to ensure data integrity and security. The server is easy to integrate with various platforms, such as the Claude Desktop app, by configuring the necessary environment variables and command-line arguments.
Features
- Read-only access to MySQL databases
- Automatic discovery of table schemas
- Execution of read-only SQL queries
- Integration with LLMs for schema inspection
- Secure transactions with read-only permissions
Tools
mysql_query
Execute read-only SQL queries against the connected database. Input:
sql(string): The SQL query to execute. All queries are executed within a READ ONLY transaction.
