mysql-mcp-server
27
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.
MySQL Database Access MCP Server
This MCP server provides read-only access to MySQL databases. It allows you to:
- List available databases
- List tables in a database
- Describe table schemas
- Execute read-only SQL queries
Security Features
- Read-only access: Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed
- Query validation: Prevents SQL injection and blocks any data modification attempts
- Query timeout: Prevents long-running queries from consuming resources
- Row limit: Prevents excessive data return