Go MCP MySQL

What it does

Go MCP MySQL provides a high-performance bridge between AI models and MySQL databases. It allows LLMs to perform schema discovery, manage tables, and execute data queries directly on a MySQL instance. It is written in Go, meaning it can be distributed as a standalone binary without requiring a heavy runtime environment.

Tools

• list_database: Lists all available databases on the server.
• list_table: Searches for and lists tables within the database.
• create_table: Executes SQL to create new tables.
• alter_table: Modifies existing table structures safely.
• desc_table: Retrieves the structure and column definitions of a specific table.
• read_query: Executes read-only SQL queries for data retrieval.
• write_query: Executes SQL commands that modify data.
• update_query: Performs targeted data updates.
• delete_query: Removes records from the database.

Installation

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "mysql": {
      "command": "go-mcp-mysql",
      "args": [
        "--host", "localhost",
        "--user", "root",
        "--pass", "password",
        "--port", "3306",
        "--db", "mydb"
      ]
    }
  }
}

Supported hosts

• claude