Provides read-only access to MySQL databases with tools for executing SELECT queries and automatic discovery of table schemas, columns, types, keys, and constraints.
MySQL MCP Server
A Model Context Protocol server that provides read-only access to MySQL databases.
Features
Tools
query - Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)
All queries run within READ ONLY transactions
Resources
Table schemas - Automatic discovery of tables and columns with their types, keys, and constraints
Installation
Docker
NPM
NPX
Usage with Claude Desktop
Add to claude_desktop_config.json:
Using Docker
Using NPX
Note: When using Docker to connect to a MySQL server on your host machine, use host.docker.internal instead of localhost.
Connection String Format
Development
License
MIT
This server cannot be installed
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
Enables read-only access to MySQL databases through natural language queries. Provides automatic table schema discovery and executes SELECT, SHOW, DESCRIBE, and EXPLAIN statements within secure read-only transactions.