mcp-mysql
If you are the rightful owner of mcp-mysql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
MCP MySQL Server is a Go-based MCP server implementation that provides MySQL database interaction functionality, allowing MCP clients to perform database operations.
MCP MySQL Server is a robust server implementation written in Go, designed to facilitate MySQL database interactions through the Model Context Protocol (MCP). It provides a JSON-RPC based interface for executing database operations, making it compatible with MCP clients like Claude Desktop. The server supports a variety of MySQL operations, including querying, schema inspection, and data manipulation, with an optional read-only mode to restrict data modifications. It also offers query plan verification through EXPLAIN analysis to ensure query safety. The server supports URL-style connection strings for ease of configuration and is built using Google's distroless container images, ensuring a minimal and secure deployment footprint. The server can be run using Docker for ease of deployment or as a Go binary for more direct integration.
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.
Tools
greeting/hello
Generate greeting messages, support optional name parameters for personalized customization
