mysql-mcp-server
This project is an MCP server that offers secure, read-only access to MySQL databases, supporting operations such as listing databases, tables, and executing read-only queries. It emphasizes security and efficiency with features like query validation and timeout settings.
What types of SQL statements are allowed?
Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are permitted to ensure read-only access.
How can I prevent long-running queries?
The server includes a query timeout feature that limits the duration of queries to prevent excessive resource usage.
Can I modify data using this server?
No, the server is designed for read-only access and does not allow any data modification operations.
What should I do if I encounter connection issues?
Check the server logs for error messages, verify your MySQL credentials, and ensure your MySQL user has the necessary permissions.
Is there a way to limit the amount of data returned?
Yes, the server has a row limit feature to control the amount of data returned in response to queries.