赞助商 — Bloome

使用 mcp-server-mysql 让你的 AI 查询 MySQL？Bloome 为你整个团队带来这种体验——一个 AI 代理即时通讯平台，AI 代理成为聊天的成员。连接你的 MCP 工具，让代理在一个线程中检查模式、运行查询并回答所有人的数据问题。零本地设置，运行于云端、网页端和移动端。

---

MCP服务器允许Claude和其他LLM访问MySQL——通过模型上下文协议检查模式、运行查询，并可选地写入数据。

主要特色

• 默认只读 — 写操作通过环境标志选择加入
• Claude Code 集成 — 为 Anthropic 的 Claude Code CLI 优化
• SSH 隧道支持 — 内置支持远程数据库
• 多数据库模式 — 跨多个数据库查询而不重新连接
• 模式特定权限 — 每个数据库的读写控制
• PII编辑 — 结果中敏感数据的自动掩蔽
• 远程模式 — 带有持有令牌认证的HTTP传输
• SSL/TLS 支持 — 带有 mTLS 选项的加密连接

要求

• Node.js v20+
• MySQL 5.7+（推荐8.0+）
• 拥有适当权限的MySQL用户

MCP Server for MySQL

Sponsor — Bloome

Using mcp-server-mysql to let your AI query MySQL? Bloome brings that to your whole team — an AI-agent IM platform where AI agents are members of the chat. Connect your MCP tools and have agents inspect schemas, run queries, and answer data questions for everyone in one thread. Zero local setup, runs in the cloud, on web and mobile.

---

MCP server that gives Claude and other LLMs access to MySQL — inspect schemas, run queries, and optionally write data, all through the Model Context Protocol.

Key Features

• Read-only by default — write operations opt-in via env flags
• Claude Code integration — optimized for Anthropic’s Claude Code CLI
• SSH tunnel support — built-in support for remote databases
• Multi-DB mode — query across multiple databases without reconnecting
• Schema-specific permissions — per-database read/write control
• PII redaction — automatic masking of sensitive data in results
• Remote mode — HTTP transport with bearer token auth
• SSL/TLS support — encrypted connections with mTLS option

Requirements

• Node.js v20+
• MySQL 5.7+ (8.0+ recommended)
• MySQL user with appropriate privileges

Quick Install

Claude Code (simplest):

claude mcp add mcp_server_mysql \
  -e MYSQL_HOST="127.0.0.1" \
  -e MYSQL_PORT="3306" \
  -e MYSQL_USER="root" \
  -e MYSQL_PASS="your_password" \
  -e MYSQL_DB="your_database" \
  -- npx @benborla29/mcp-server-mysql

Claude Desktop / other clients:

{
  "mcpServers": {
    "mcp_server_mysql": {
      "command": "npx",
      "args": ["-y", "@benborla29/mcp-server-mysql"],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "your_password",
        "MYSQL_DB": "your_database"
      }
    }
  }
}

All write operations are disabled by default. Enable with ALLOW_INSERT_OPERATION=true, ALLOW_UPDATE_OPERATION=true, ALLOW_DELETE_OPERATION=true.

Documentation

• Installation Guide — Smithery, Cursor, Codex, Claude Code, local repo, remote mode
• Configuration & Environment Variables — all env vars, advanced config
• Multi-DB Mode — querying multiple databases
• PII Redaction — automatic data masking
• Testing — test setup and running
• Troubleshooting — common issues and fixes
• Changelog

Tools & Resources