-
securityA
license-
qualityA Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
Last updated -
1,219
133
TypeScript
MIT License
Integrations
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
Copy
Installing via Smithery
To install MySQL Database Server for Claude Desktop automatically via Smithery:
Copy
Usage
With Claude Desktop
Add the following configuration to your claude_desktop_config.json:
Copy
Note: When using Docker on macOS, use host.docker.internal if the MySQL server is running on the host network.
Connection URL Format
Copy
Replace /database with your database name.
Development
Copy
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.
This server cannot be installed
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Enables LLMs to interact with MySQL databases by inspecting schemas and executing safe, read-only queries within transactions.
Related Resources
Related MCP Servers
- -securityAlicense-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,219TypeScriptMIT License
- -securityAlicense-qualityA Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.Last updated -1,219MIT License
- -securityFlicense-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 -19,917JavaScript