Go MCP Mysql

@Zhwt

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

Zhwt

关于 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 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

Go MCP Mysql 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.

常见问题

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.

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.

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.

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.

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`.

数据库分类下的更多 MCP 服务器

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

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

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.