MySQL MCP Server

MySQL MCP servers enable AI models to interact with MySQL databases, providing capabilities for structured data operations, SQL queries, transaction management, and relational data management.

{
  "mcpServers": {
    "mysql": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "--add-host=host.docker.internal:host-gateway",
        "--env-file",
        "/Users/username/.mcp/.env",
        "ghcr.io/xiangma9712/mcp/mysql"
      ]
    }
  }
}

Overview

The MCP MySQL Server enables AI models to interact with MySQL databases, providing a standardized interface for working with this popular relational database management system. MySQL is widely used for web applications, enterprise software, and data-driven applications, making it essential for AI integrations. 1

Key features include:

  • View and understand database structures
  • Convert natural language to SQL queries
  • Handle query results effectively
  • Format data for easy reading
  • Manage database transactions

Tools

Sources

Footnotes

  1. https://github.com/modelcontextprotocol/mcp-mysql-server