dpflucas_mysql-mcp-server
If you are the rightful owner of dpflucas_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 or by building from source, and the server requires specific environment variables for configuration. The server also includes tools for testing and troubleshooting to ensure seamless integration and operation.
Features
- Read-only access: Only allows SELECT, SHOW, DESCRIBE, and EXPLAIN statements.
- Query validation: Prevents SQL injection and blocks data modification attempts.
- Query timeout: Limits the duration of queries to prevent resource overuse.
- 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.
