mysql-query-mcp-server
4
The MySQL Query MCP Server is a Model Context Protocol server that enables read-only MySQL database queries for AI assistants. It supports data exploration and investigation without modifying the database, focusing on environments like local, development, staging, and production.
MySQL Query MCP Server
A Model Context Protocol (MCP) server providing read-only MySQL database queries for AI assistants. Key features include executing read-only MySQL queries, working with predefined environments, providing database information, and supporting SSL connections. It is designed for data investigation and exploration without write operations or schema management capabilities.
Supported AI Tools
- Cursor IDE: Set up in
.cursor/mcp.json - Anthropic Claude: Use with a compatible MCP client
- Other MCP-compatible AI assistants
Features & Limitations
What It Does
- Execute read-only MySQL queries (SELECT, SHOW, DESCRIBE only)
- Work with predefined environments (local, development, staging, production)
- Provide database information and metadata
- Support SSL connections for secure access
What It Doesn't Do
- Execute write operations
- Support custom environment names
- Provide database design capabilities
- Function as a full database management tool
Security Considerations
- Only read-only queries allowed
- Each environment has an isolated connection pool
- SSL connections are supported
- Query timeouts prevent runaway operations