AgentHubAgentHub
MySQL icon

MySQL MCP Setup & Guide

MCP ServerMCP Hub 中国

io.mcp-cn.benborla29/mcp-server-mysql

MySQL数据库的MCP服务器，支持数据库操作和管理

View on MCP Hub 中国 ↗

Copy the install config on this page first, then verify docs and permissions upstream.

Popularity

Uses46k

Overview

MySQL数据库的MCP服务器，支持数据库操作和管理 MySQL is a MCP Server listed from MCP Hub China. Transports: stdio. This page includes an overview, setup tutorial, install commands, and use cases for Trae, Tongyi Lingma, Cursor, Claude Code, and VS Code.

数据库MySQL数据管理SQL

Use cases

Database toolsChina services

AgentHub Verified AvailabilityTested & Ready

Automated pipeline validated install commands, protocol & client compatibility

Verified At2026-09-29
Install Snippets TestedCLI & JSON config syntax verified
Protocol Handshake ReadyComplies with JSON-RPC 2.0 specifications
Origin Registry ActiveSourced from mcp-cn
Verified ClientsClaude Code、Claude Desktop、Cursor 等
Security Tier: A 级 · 源码开放合规 (A)·Scanned for high-risk vulnerabilities. Recommended to run with project-scoped permissions.

Copy by platform

Choose your platform

  1. Open or create .cursor/mcp.json in your project root
  2. Click Copy config and paste; merge only this mcpServers entry if others exist
  3. Replace <placeholders> in env with real secrets (see Environment variables below)
  4. Save, then Cmd+Shift+P → Reload Window

Pre-fill Environment Variables (Optional)

Required
Required
Required
Required
Required
Required
Required
Required
Required
Required
Privacy Guarantee: Keys are replaced 100% locally in your browser memory and are NEVER uploaded or stored on any server.
Click to copy snippet
{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

Setup tutorial

  1. Open the MySQL page and confirm this MCP Server (source: MCP Hub China).
  2. Copy the Cursor, Claude Code, or VS Code snippet.
  3. Merge it into mcpServers and replace env placeholders with real secrets.
  4. Reload the window, then call the MCP tools from your agent chat.

Install commands

Install commands and setup steps are in the HTML so search engines and no-JS browsers can read them without running client JavaScript.

Claude Code (local)

  1. Install Claude Code CLI
  2. Copy the command below, replace <placeholders> with real env values, then run in terminal
  3. See Environment variables below if listed
claude mcp add mcp-server-mysql --env MYSQL_HOST=<MYSQL_HOST> --env MYSQL_PORT=<MYSQL_PORT> --env MYSQL_USER=<MYSQL_USER> --env MYSQL_PASS=<MYSQL_PASS> --env MYSQL_DB=<MYSQL_DB> --env ALLOW_INSERT_OPERATION=<ALLOW_INSERT_OPERATION> --env ALLOW_UPDATE_OPERATION=<ALLOW_UPDATE_OPERATION> --env ALLOW_DELETE_OPERATION=<ALLOW_DELETE_OPERATION> --env PATH=<PATH> --env NODE_PATH=<NODE_PATH> -- npx -y @benborla29/mcp-server-mysql

Cursor — .cursor/mcp.json (local)

  1. Open or create .cursor/mcp.json in your project root
  2. Click Copy config and paste; merge only this mcpServers entry if others exist
  3. Replace <placeholders> in env with real secrets (see Environment variables below)
  4. Save, then Cmd+Shift+P → Reload Window
{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

VS Code — .vscode/mcp.json (local)

  1. Install GitHub Copilot in VS Code with MCP support
  2. Open or create .vscode/mcp.json in your project root
  3. Click Copy config and paste; merge only this mcpServers entry if others exist
  4. Replace <placeholders> in env with real secrets
  5. Save and Developer: Reload Window
{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

Claude Desktop — claude_desktop_config.json (local)

  1. Open Claude Desktop claude_desktop_config.json (see remote guide for paths)
  2. Click Copy config and merge under mcpServers
  3. Replace <placeholders> in env with real secrets
  4. Fully quit and restart Claude Desktop
{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

Trae — .trae/mcp.json (local)

  1. Trae → Settings → MCP, or edit .trae/mcp.json / global mcp.json
  2. Click Copy config and merge mcpServers
  3. Replace <placeholders> in env with real secrets
  4. Save and reload Trae
{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

Cherry Studio — MCP settings (local)

  1. Cherry Studio → Settings → MCP Servers → Add (STDIO)
  2. Or import JSON: click Copy config and merge mcpServers
  3. Replace <placeholders> in env; ensure Node.js / uv (npx, uvx) are installed
  4. Enable the server and check tools load
{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

Tongyi Lingma — MCP config (local)

  1. Lingma Settings → MCP → + → STDIO or config file
  2. Click Copy config and merge mcpServers
  3. Replace <placeholders> in env; need Node.js 18+ (npx) or uv (uvx)
  4. Confirm connected before using tools in agent chat
{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

Windsurf — mcp_config.json (local)

  1. Edit ~/.codeium/windsurf/mcp_config.json
  2. Click Copy config and merge mcpServers (stdio same as Cursor)
  3. Replace <placeholders> in env, save, refresh Cascade
{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

Cline — MCP Servers (local)

  1. Cline panel → Settings → MCP Servers
  2. Click Copy config and merge
  3. Replace <placeholders> in env, then save
{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

WorkBuddy — .workbuddy/mcp.json (local)

  1. Edit ~/.workbuddy/mcp.json (user) or project .workbuddy/mcp.json
  2. Or Plugins → MCP Servers → Configure MCP and paste the JSON below
  3. Replace <placeholders> in env; on Windows prefer absolute paths for command/scripts
  4. Save, restart WorkBuddy, confirm connector status is green
{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

Troubleshooting & Common ErrorsFAQ

Common connection errors and verified fixes for MySQL

Getting 'connection closed' or exit code 1 in Cursor / Claude Code for MySQL?

Usually caused by missing runtime paths or IDE environment inheritance. Fix steps: 1. Verify Node.js 18+ (npx) or Python 3.10+ (uvx) is installed; 2. Run 'which npx' or 'which uvx' in terminal, and replace 'command' with absolute path; 3. Reload or restart the client window after modifying config.

Fix Snippet
# Check binary path in terminal:
which npx
node -v
Getting 'spawn npx ENOENT' or 'command not found'?

The editor background process does not inherit your full terminal PATH. Solution: Globally install the package, or set the absolute binary path (e.g. C:\Program Files\nodejs\npx.cmd on Windows, or /usr/local/bin/npx on macOS).

Missing required environment variable or authentication failure?

MySQL requires environment variables (MYSQL_HOST、MYSQL_PORT、MYSQL_USER、MYSQL_PASS、MYSQL_DB、ALLOW_INSERT_OPERATION、ALLOW_UPDATE_OPERATION、ALLOW_DELETE_OPERATION、PATH、NODE_PATH). Ensure you have added valid keys under the 'env' object in your config file without trailing whitespace.

Fix Snippet
// .cursor/mcp.json 或 claude_desktop_config.json
{
  "env": {
    "MYSQL_HOST": "your_actual_key_here"
  }
}
Still not connecting? Read the MCP troubleshooting guide →

Tool Mock Playground

Sandbox

MySQL Database Query Simulator · Preview tool schema & outputs without local runtime

Sandbox Ready
fn: execute_read_queryExecute SQL query and format rows safely
Request ArgumentsJSON Schema
{
  "query": "SELECT id, name, status, created_at FROM records WHERE status = 'active' LIMIT 3;"
}
💡Parameters generated dynamically by Agent runtime
Agent Tool Output

Click 'Run Mock' above

to preview the raw response returned to the LLM

Env: AgentHub Virtual SandboxJSON-RPC 2.0

Decision Guide: Why & When to Use

Assess suitability before installing to save trial-and-error time

Best Suited For
  • Dev data exploration
  • Read-only analytics SQL
  • Schema documentation
When NOT to Use
  • Unrestricted writes on production
  • Exposing raw PII to AI
Recommended Workflow Pairing:View Scenario →

Postgres MCP + SQL skill → conversational BI

MCP hands-on: install to visible results

Follow the full lab (expected UI/output + contrast checks). After installing this item, verify with the tutorial prompts.

Open tutorial →

Related resources

Often paired with

腾讯云 CloudBase · Tencent CloudBase

v1.92.120

SkillClawHub9k

io.clawhub.binggg/cloudbase

Use this skill when you develop, design, build, deploy, debug, migrate, or troubleshoot CloudBase (腾讯云开发, 云开发, TCB, 微信云开发) projects — Web, 微信小程序, 小程序, uni-app, mobile (iOS, Android, Flutter, React Native). Covers UI (页面, 界面, 表单, dashboard, prototype, 原型); auth (登录, 注册, OAuth, publishable key); databases (NoSQL 文档数据库, MySQL 关系型数据库, PostgreSQL/CloudBase PG, app.rdb(), queryPgDatabase/managePgDatabase, CRUD, security rules); 云函数/cloud functions (serverless, scf_bootstrap); CloudRun (云托管, Dockerfile); 云存储; built-in AI (内置大模型, AI 对话, streaming, 流式输出, 图片生成, generateText, streamText, createModel, generateImage, TokenHub, Hunyuan, DeepSeek, GLM, Kimi, Token Credits 资源包, 小程序成长计划); third-party/custom model onboarding (第三方大模型接入, 大模型调用, LLM API); AI agent (智能体, AG-UI, LangGraph); ops troubleshooting (巡检, 诊断, 日志); spec workflow (需求文档, 技术方案, requirements, tasks.md). Do NOT use for non-CloudBase projects, pure frontend without CloudBase, or self-hosted backends without CloudBase.

source
View on ClawHub

WP Multitool — WordPress Optimization Toolkit

v1.9.9

SkillClawHub5.8k

io.clawhub.marcindudekdev/wp-multi-tool

WordPress site health audit, performance optimization, database cleanup, autoload tuning, slow query detection, wp-config management, image size control, frontend speed fixes, and server diagnostics. Combines 19 optimization and control modules into a single paid plugin (Pro $79/year single-site, $199/year or $499 lifetime unlimited). The diagnostic commands in this skill work on any WordPress 5.8+ site without the plugin.

source
View on ClawHub

PlanetScale CLI Skills

v1.0.31

SkillClawHub3.5k

io.clawhub.vince-winkintel/planetscale-cli-skills

PlanetScale CLI command reference and workflows. Use for authentication; org, SSO, teams, and billing; databases, branches, Neki, internal or external keyspaces, logs, maintenance, extensions, metrics, insights, inspect, and SQL; deploy requests, schema migrations, MoveTables, throttlers, rollout concurrency, disk-storage settings, and Traffic Control; PgBouncers, read-only replicas, roles, passwords, backups, webhooks, audit logs, service tokens, D1 imports, and automation. Routes to focused pscale sub-skills. Triggers on PlanetScale CLI, pscale, pscale --skill, database, branch, Neki, keyspace, create-external, external keyspace, deploy request, move-tables, vtctl, vtctld, max rollout, disk scaling, max storage, throttler, traffic-control, metrics, insights, inspect, SQL, role, password, pgbouncer, read-only replica, backup, webhook, audit-log, billing, org, SSO, service token, import d1.

source
View on ClawHub

Keep exploring AgentHub

Most people compare similar tools or check scenario guides before installing—start here.

Browse more like thisSearch similarPick by scenarioPrompt playbooksMCP hands-onReviews & comparisons

Listing badge: put AgentHub on your site

Copy either snippet into your project homepage, docs, or GitHub README. The badge is a hotlinked SVG — nothing to host — and it links back to this page so visitors can find the install steps.

PreviewListed on AgentHub: MySQL
HTML
<a href="https://myagenthub.cn/p/io.mcp-cn.benborla29/mcp-server-mysql" title="Listed on AgentHub: MySQL" target="_blank" rel="noopener">
  <img src="https://myagenthub.cn/badge/io.mcp-cn.benborla29/mcp-server-mysql?lang=en" alt="Listed on AgentHub: MySQL" height="20" style="border:0"/>
</a>
Markdown (GitHub README)
[![Listed on AgentHub: MySQL](https://myagenthub.cn/badge/io.mcp-cn.benborla29/mcp-server-mysql?lang=en)](https://myagenthub.cn/p/io.mcp-cn.benborla29/mcp-server-mysql)

Badges are generated on the fly from /badge/<package-id>, so name and listing changes propagate automatically. Keep the link target unchanged — it is what counts as the referral.

Unified Manifest

{
  "id": "io.mcp-cn.benborla29/mcp-server-mysql",
  "type": "mcp-server",
  "version": "latest",
  "displayName": "MySQL",
  "description": "MySQL数据库的MCP服务器，支持数据库操作和管理",
  "author": {
    "name": "Ben Borla"
  },
  "iconUrl": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTFPLXqRyw5PEl4ETnuzYuP5XhUI51sUdQzcg&s",
  "homepage": "https://mcp-cn.com/server/90",
  "distribution": {
    "packages": [
      {
        "registryType": "npm",
        "identifier": "@benborla29/mcp-server-mysql",
        "runtimeHint": "npx",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "MYSQL_HOST",
            "description": "<YOUR_MYSQL_HOST>",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "MYSQL_PORT",
            "description": "3306",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "MYSQL_USER",
            "description": "<YOUR_MYSQL_USER>",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "MYSQL_PASS",
            "description": "<YOUR_MYSQL_PASSWORD>",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "MYSQL_DB",
            "description": "<YOUR_MYSQL_DATABASE>",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "ALLOW_INSERT_OPERATION",
            "description": "false",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "ALLOW_UPDATE_OPERATION",
            "description": "false",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "ALLOW_DELETE_OPERATION",
            "description": "false",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "PATH",
            "description": "<YOUR_PATH>",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "NODE_PATH",
            "description": "<YOUR_NODE_PATH>",
            "isRequired": true,
            "isSecret": false
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode",
    "trae",
    "cherry-studio",
    "lingma",
    "windsurf",
    "cline",
    "workbuddy"
  ],
  "keywords": [
    "use_count:45963",
    "数据库",
    "MySQL",
    "数据管理",
    "SQL"
  ],
  "provenance": {
    "origin": "mcp-cn",
    "originalId": "@benborla29/mcp-server-mysql",
    "originalUrl": "https://mcp-cn.com/server/90",
    "isOfficial": false,
    "status": "active"
  }
}