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
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