MCP.so
登录

MCP MySQL Server

@cnosuke

代码仓库

关于 MCP MySQL Server

MCP server that acts as a MySQL Client implemented in Go language

基本信息

分类

数据库

运行时

go

传输方式

stdio

发布者

cnosuke

配置

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

{
  "mcpServers": {
    "mcp-mysql-cnosuke": {
      "command": "docker",
      "args": [
        "pull",
        "cnosuke/mcp-mysql:latest"
      ]
    }
  }
}

工具

未检测到工具

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

概览

What is MCP MySQL Server?

MCP MySQL Server is a Go-based MCP (Model Context Protocol) server implementation that provides MySQL database interaction functionality, allowing MCP clients such as Claude Desktop to perform database operations.

How to use MCP MySQL Server?

Run the server via Docker (docker pull cnosuke/mcp-mysql:latest and appropriate environment variables) or build and run the Go binary (./bin/mcp-mysql server --config=config.yml). Integrate with Claude Desktop by adding an entry to claude_desktop_config.json using either the Docker command or the Go binary path, and configure MySQL connection settings via environment variables or a YAML config file.

Key features of MCP MySQL Server

  • JSON‑RPC based MCP-compliant interface.
  • Supports querying, schema inspection, and data manipulation.
  • Optional read‑only mode to prevent data modification.
  • Optional EXPLAIN query plan verification.
  • Accepts URL-style connection strings (mysql://user:pass@host:port/dbname).
  • Minimal Docker image built with Google's distroless base.

Use cases of MCP MySQL Server

  • Query a MySQL database through an AI assistant like Claude Desktop.
  • Inspect database schemas and list tables without writing custom code.
  • Safely explore production data using read‑only mode.
  • Perform controlled data updates or inserts via an MCP client.

FAQ from MCP MySQL Server

How do I enable read‑only mode?

Set the environment variable MYSQL_READ_ONLY=true or set mysql.read_only: true in the configuration file. In read‑only mode, only tools starting with list_, read_, and desc_ are available.

What connection methods are supported?

You can provide connection details via tool parameter (dsn), DSN in config (mysql.dsn), or individual config parameters (host, user, password, port, database). The server uses URL-style or native MySQL DSN formats.

What runtime does the server require?

For Docker deployment no additional runtime is needed. For local development, Go 1.24 or later and a MySQL server are required.

Can I use environment variables for configuration?

Yes. Environment variables such as MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, MYSQL_DSN, MYSQL_READ_ONLY, and MYSQL_EXPLAIN_CHECK override corresponding YAML settings.

Is the server available for MariaDB connections?

The server supports URL schemes mysql:// and mariadb://. The MySQL DSN format used is compatible with both MySQL and MariaDB servers.

评论

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

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

mcp-server-duckdb

ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

177

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245