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 queries.
The MySQL Database Access MCP Server is designed to facilitate secure, 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 security features to ensure that only non-destructive queries are executed, preventing SQL injection and data modification attempts. It also includes mechanisms to limit query execution time and the number of rows returned, ensuring efficient resource usage. The server can be installed via npm or built from source, and requires configuration of environment variables for database connection.
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 query execution to conserve resources.
- Row limit: Restricts the number of rows returned to prevent excessive data retrieval.
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.
