AgentHubAgentHub

mysql MCP Setup & Guide

MCP ServerMCP RegistryOfficial

io.github.codeChap/mysql · v0.2.0

MCP server for MySQL/MariaDB — pooled async queries with destructive-query safety

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

Overview

MCP server for MySQL/MariaDB — pooled async queries with destructive-query safety mysql is a MCP Server listed from MCP Registry. This page includes an overview, setup tutorial, install commands, and use cases for Trae, Tongyi Lingma, Cursor, Claude Code, and VS Code.

Use cases

AgentHub Verified AvailabilityTested & Ready

Automated pipeline validated install commands, protocol & client compatibility

Verified At2026-11-15
Install Snippets TestedCLI & JSON config syntax verified
Protocol Handshake ReadyComplies with JSON-RPC 2.0 specifications
Origin Registry ActiveSourced from official-mcp-registry
Verified ClientsClaude Code、Claude Desktop、Cursor 等
Security Tier: A+ 级 · 官方认证推荐 (A+)·Maintained by official/verified teams, audited for standard MCP protocol compliance.
No auto-generated install guide — see the source repository README.

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

Tool calls timing out or failing to download packages?

First-time package downloading might be slow or timeout due to network limits. Configure a reliable mirror or check outbound proxy settings.

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

insurance-advisor-china

v2.4.21

SkillClawHub7410.3k

io.clawhub.mnetfairy/insurance-advisor-china

中国大陆AI保险顾问。为个人和家庭提供全方位的保险咨询、产品对比、方案设计、投保指导。当用户询问保险配置、保险方案、产品对比、重疾险/医疗险/寿险/意外险/储蓄险推荐、保费计算、保障缺口分析、需求分析、核保合规、理赔等问题时使用。发布产物仅含 SKILL.md + 3 个只读参考文件(references/products.json、insurance-knowledge.md、compliance.md)+ 3 个运行时脚本(needs_analyzer / premium_calculator / plan_designer);数据清洗脚本与回归测试脚本是本地维护工具,不随发布产物分发。

source

ai-insurance-advisor

v2.4.21

SkillClawHub8110.4k

io.clawhub.mnetfairy/ai-insurance-advisor

中国大陆保险顾问。本 skill 覆盖 8 项能力:保险需求分析(needs_analyzer.py)、产品对比(premium_calculator.py + 本地 products.json)、保费计算(premium_calculator.py)、方案设计(plan_designer.py)、保险知识问答(insurance-knowledge.md)、合规要点提示(compliance.md)、朋友圈/社交营销文案生成(agent LLM 生成,无专属脚本)、培训话术支持(agent LLM 生成,无专属脚本)。不提供核保预审、理赔代办、代理人展业工具等能力——这些场景请转人工或调用专业服务。发布产物仅含 SKILL.md + 3 个只读参考文件 + 3 个运行时脚本(needs_analyzer / premium_calculator / plan_designer);数据清洗与回归测试脚本为本地维护工具,不随发布产物分发。

source

中文公文写作

v2.0.63

SkillClawHub7412k

io.clawhub.gongyu0918-debug/chinese-official-writing

用于中文公文、事务性材料和新闻稿件的起草、改写、压缩、润色、审校、文种核对、去口语化、降 AI 味及 Word 格式处理,适用于机关、企事业单位、学校和新闻机构。涵盖申请、请示、报告、通知、通告、意见、决定、决议、议案、公报、命令、函、复函、批复、说明、方案、纪要、公告、公示、通报、制度、规定、办法、细则、操作规程、工作要点、总结、调研、讲话、致辞、主持词、述职、可研、审查材料、技术需求、新闻消息、编者按、新闻评论,以及采购、整改、反馈和 AI 算力等场景。

source

Keep exploring AgentHub

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

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.github.codeChap/mysql" title="Listed on AgentHub: mysql" target="_blank" rel="noopener">
  <img src="https://myagenthub.cn/badge/io.github.codeChap/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.github.codeChap/mysql?lang=en)](https://myagenthub.cn/p/io.github.codeChap/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.github.codeChap/mysql",
  "type": "mcp-server",
  "version": "0.2.0",
  "displayName": "mysql",
  "description": "MCP server for MySQL/MariaDB — pooled async queries with destructive-query safety",
  "repository": {
    "url": "https://github.com/codeChap/mcp-server-mysql",
    "source": "github"
  },
  "distribution": {
    "packages": [],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode",
    "trae",
    "cherry-studio",
    "lingma",
    "windsurf",
    "cline",
    "workbuddy"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.codeChap/mysql",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.codeChap%2Fmysql/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}
mysql MCP Setup & Guide - AgentHub