AI导哈

MySQL 查询 MCP 服务器

一个轻量级只读 MySQL MCP 服务器，通过 MySQL_URL 将 AI 代理连接到 MySQL 数据库，支持 SELECT、SHOW、DESCRIBE、EXPLAIN 和 WITH 查询。

  • by drago1520
  • TypeScript
  • 本地部署
  • 更新于
在 GitHub 查看 drago1520/mysql-mcp

使用说明

mysql-mcp

Minimal read-only MySQL MCP server.

This repository is the simplest and fastest way to connect MySQL to your AI agent:

Everything is local and private: your agent talks to this MCP server on your machine.

  1. Provide a MYSQL_URL connection string (with or without a specific database).
  2. Run one command to add it to your agent.

It exposes one tool:

  • mysql_query

Allowed queries start with SELECT, SHOW, DESCRIBE, EXPLAIN, or WITH.

Get started

1) Pick your MySQL host

If MySQL runs on your machine:

MYSQL_URL=mysql://USER:PASSWORD@HOST:PORT

If MySQL runs in Docker (default host network from your MCP container):

MYSQL_URL=mysql://USER:PASSWORD@host.docker.internal:PORT

2) Add it to your agent

Replace HOST with host.docker.internal if your MySQL runs in Docker.

GitHub Copilot Connect (VS Code)

.vscode/mcp.json

{
  "servers": {
    "mysql": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "-e",
        "MYSQL_URL=mysql://USER:PASSWORD@HOST:PORT",
        "ghcr.io/drago1520/mysql-mcp:latest"
      ]
    }
  }
}
Codex 
codex mcp add mysql -- docker run --rm -i -e MYSQL_URL=mysql://USER:PASSWORD@HOST:PORT ghcr.io/drago1520/mysql-mcp:latest
Claude Code 
claude mcp add NAME --transport stdio \
  --env "MYSQL_URL=mysql://USER:PASS@HOST:PORT" \
  -- docker run --rm -i \
  -e "MYSQL_URL=mysql://USER:PASS@HOST:PORT" \
  ghcr.io/drago1520/mysql-mcp:latest

with Infisical for env injection:

claude mcp add MCP-NAME --transport stdio -- \
  infisical.exe run --projectId PROJECT_ID --domain DOMAIN_IF_SELF_HOST --path PATH --env=prod -- \
  docker run --rm -i -e MYSQL_URL ghcr.io/drago1520/mysql-mcp:latest

*will fail once infisical login expires.

Google AI (Gemini CLI)

~/.gemini/settings.json

{
  "mcpServers": {
    "mysql": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "-e",
        "MYSQL_URL=mysql://USER:PASSWORD@HOST:PORT",
        "ghcr.io/drago1520/mysql-mcp:latest"
      ]
    }
  }
}

MYSQL_URL

MYSQL_URL is used exactly as provided, so you can connect either:

Without a database name:

mysql://USER:PASSWORD@HOST:3306

there is no default schema, so query fully qualified tables like my_db.users.

With a database name:

mysql://USER:PASSWORD@HOST:3306/my_db

相关 MCP