mysql-mcp-server
If you are the rightful owner of mysql-mcp-server 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.
The MySQL Database Access MCP Server provides read-only access to MySQL databases, allowing users to list databases, tables, describe schemas, and execute read-only SQL queries.
The MySQL Database Access MCP Server is designed to facilitate secure and efficient read-only interactions with MySQL databases. It supports operations such as listing available databases, listing tables within a database, describing table schemas, and executing read-only SQL queries. The server is equipped with robust security features, including query validation to prevent SQL injection, query timeouts to manage resource consumption, and row limits to control data output. Installation can be done via npm, building from source, or using Smithery for integration with Claude AI. Configuration requires setting environment variables for database connection details. The server also supports advanced connection pool configurations for optimized performance. Testing scripts are provided to ensure proper setup and functionality.
Features
- Read-only access: Only allows SELECT, SHOW, DESCRIBE, and EXPLAIN statements.
- Query validation: Prevents SQL injection and data modification attempts.
- Query timeout: Limits the duration of queries to conserve resources.
- Row limit: Controls the amount of data returned to prevent excessive output.
Tools
list_databases
Lists all accessible databases on the MySQL server.
list_tables
Lists all tables in a specified database.
describe_table
Shows the schema for a specific table.
execute_query
Executes a read-only SQL query.
