-
security-
license-
qualityA Model Context Protocol server providing read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
Last updated -
1
1
MIT License
Allows Language Learning Models (LLMs) to inspect database schemas and execute read-only queries on MySQL databases
mcp-server-mysql
Model Context Protocol Server for MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Features
Read-only access to MySQL databases
Schema inspection capabilities
Safe query execution within READ ONLY transactions
Docker support
NPM package available
Installation
Using Docker
# Build the Docker image
make docker
# Run with Docker
docker run -i --rm mcp/mysql mysql://host:port/dbname
Installing via Smithery
To install MySQL Database Server for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @yuru-sha/mcp-server-mysql --client claude
Usage
With Claude Desktop
Add the following configuration to your claude_desktop_config.json:
{
"mcpServers": {
"mysql": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/mysql",
"mysql://host:port/dbname"
]
}
}
}
Note: When using Docker on macOS, use host.docker.internal if the MySQL server is running on the host network.
Connection URL Format
mysql://[user][:password]@host[:port]/database
Replace /database with your database name.
Development
# Initial setup
make setup
# Build the project
make build
# Format code
make format
# Run linter
make lint
License
This project is released under the MIT License.
Security
This server enforces read-only access to protect your database. All queries are executed within READ ONLY transactions.
For enhanced security, we recommend creating a read-only user.
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
Related MCP Servers
- -security-license-qualityProvides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries within a secure transaction context.Last updated -22,3041
- -security-license-qualityA Model Context Protocol server providing read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.Last updated -5601
- -security-license-qualityA server that provides LLMs with read-only access to MySQL databases, allowing them to inspect database schemas and execute read-only queries.Last updated -209MIT License