Advertise
MCP.so
Sign In

Go MCP Mysql

@Zhwt

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

Zhwt

About Go MCP Mysql

Zero burden, ready-to-use Model Context Protocol (MCP) server for interacting with MySQL and automation. No Node.js or Python environment needed.

#mysql#mcp#model-context-protocol#mcp-server

Go MCP Mysql config

Add this server to your MCP-compatible client using the configuration below.

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

Go MCP Mysql tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is go-mcp-mysql?

go-mcp-mysql is a zero-burden, ready-to-use Model Context Protocol (MCP) server for interacting with MySQL databases and automation. It requires no Node.js or Python environment. The server provides tools for CRUD operations on MySQL databases and tables, a read-only mode to prevent surprise writes, and optional EXPLAIN‑checking before queries. It is a work in progress and may not be production‑ready.

How to use go-mcp-mysql?

Download the latest binary from GitHub releases and place it in your $PATH (or build from source with go install). Configure your MCP client (e.g., Claude Desktop) with a JSON entry specifying the binary path and connection parameters either via --host, --user, --pass, --port, --db or via a DSN string using --dsn. Optional flags --read-only (restricts tools to list_, read_, and desc_ only) and --with-explain-check (disables the default EXPLAIN plan check) can be added.

Key features of go-mcp-mysql

  • No Node.js or Python runtime required (Go binary).
  • CRUD operations on databases and tables.
  • Read-only mode prevents accidental write operations.
  • Optional EXPLAIN plan check before query execution.
  • Schema tools: list, create, alter, and describe tables.
  • Data tools: read, write, update, and delete queries.

Use cases of go-mcp-mysql

  • Query MySQL databases via natural language through an LLM.
  • Explore database schemas and table structures.
  • Perform controlled CRUD operations under LLM guidance.
  • Safely analyse query plans with automatic EXPLAIN checks.
  • Isolate read‑only tasks to avoid unintended writes.

Frequently asked questions

1

What runtime do I need to run go-mcp-mysql?

No Node.js or Python is required. The server is a single Go binary that works on Windows, macOS, and Linux.

2

How do I enable read-only mode?

Add the `--read-only` flag to the server arguments. In this mode only tools starting with `list_`, `read_` or `desc_` are available.

3

How can I disable the default EXPLAIN plan check?

By default every write query is preceded by an EXPLAIN check. To disable this, add the `--with-explain-check` flag.

4

Is go-mcp-mysql ready for production?

No, the README states that it is a work in progress and may not yet be ready for production use.

5

Where can I download the binary?

Binaries are available on the [GitHub releases page](https://github.com/Zhwt/go-mcp-mysql/releases). You can also build from source using `go install -v github.com/Zhwt/go-mcp-mysql@latest`.

Comments

More Databases MCP servers

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Advertise