Provides read-only access to MySQL databases with tools for executing SELECT, SHOW, DESCRIBE, and EXPLAIN queries, along with automatic discovery of table schemas including 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
docker build -t mcp/mysql .
docker run -i --rm mcp/mysql mysql://user:password@host:3306/database
NPM
npm install -g @modelcontextprotocol/server-mysql
NPX
npx -y @modelcontextprotocol/server-mysql mysql://user:password@localhost:3306/database
Usage
Add to your MCP's config:
Using Docker image (recommended)
docker pull guidomarinho/mcp-mysql
{
"mcpServers": {
"your_mcp": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"guidomarinho/mcp-mysql:latest",
"mysql://root:password@host.docker.internal:3306/you_db"
],
"env": {}
}
}
}
Using local Docker
{
"mcpServers": {
"mysql": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/mysql",
"mysql://root:password@host.docker.internal:3306/database"
]
}
}
}
Using NPX
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mysql",
"mysql://user:password@localhost:3306/database"
]
}
}
}
Note: When using Docker to connect to a MySQL server on your host machine, use host.docker.internal instead of localhost.
Connection String Format
mysql://username:password@host:port/database
Development
npm install
npm run build
node dist/index.js mysql://user:password@localhost:3306/database
License
MIT
This server cannot be installed