MCP MySQL Server
About
MCP server that acts as a MySQL Client implemented in Go language
Details
- Author
- cnosuke
- GitHub stars
- 1
- Downloads
- 242
- Categories
- Database
Jump to
- JSON‑RPC based MCP-compliant interface.
- Supports querying, schema inspection, and data manipulation.
- Optional read‑only mode to prevent data modification.
- Optional EXPLAIN query plan verification.
- Accepts URL-style connection strings (mysql://user:pass@host:port/dbname).
- Minimal Docker image built with Google's distroless base.
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MCP MySQL ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Run the server via Docker (docker pull cnosuke/mcp-mysql:latest and appropriate environment variables) or build and run the Go binary (./bin/mcp-mysql server --config=config.yml). Integrate with Claude Desktop by adding an entry to claude_desktop_config.json using either the Docker command or the Go binary path, and configure MySQL connection settings via environment variables or a YAML config file.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mcp mysql server": {
"mcp-mysql-cnosuke": {
"command": "docker",
"args": [
"pull",
"cnosuke/mcp-mysql:latest"
]
}
}
}
}McpServers
{
"mcp-mysql-cnosuke": {
"command": "docker",
"args": [
"pull",
"cnosuke/mcp-mysql:latest"
]
}
}MCP MySQL Server
MCP MySQL Server is a Go-based MCP server implementation that provides MySQL database interaction functionality, allowing MCP clients (e.g., Claude Desktop) to perform database operations.
Features
- MCP Compliance: Provides a JSON‐RPC based interface for tool execution according to the MCP specification.
- MySQL Operations: Supports database operations such as querying, schema inspection, and (optionally) data manipulation.
- Read-Only Mode: Optional restriction to prevent data modification operations.
- Query Plan Verification: Optional EXPLAIN analysis to verify query safety.
- URL-Style Connection Strings: Supports standard URL-style database connection strings like mysql://user:pass@host:port/dbname.
- Minimal Container: Built with Google's distroless for improved security and smaller image size.
Requirements
- Docker (recommended)
For local development:
- Go 1.24 or later
- MySQL server (local or remote)
Using with Docker (Recommended)
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
