Allows Language Learning Models (LLMs) to inspect database schemas and execute read-only queries on MySQL databases
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MCP MySQL Servershow me the schema for the orders table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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
Related MCP server: PostgreSQL MCP Server
Installation
Using Docker
Installing via Smithery
To install MySQL Database Server for Claude Desktop automatically via Smithery:
Usage
With Claude Desktop
Add the following configuration to your claude_desktop_config.json:
Note: When using Docker on macOS, use host.docker.internal if the MySQL server is running on the host network.
Connection URL Format
Replace /database with your database name.
Development
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.