AgentHubAgentHub

read-only-mysql MCP Setup & Guide

MCP ServerMCP RegistryOfficial

capital.hove/read-only-mysql-mcp-server · v0.1.0

MCP server for read-only MySQL database queries in Claude Desktop

Overview

MCP server for read-only MySQL database queries in Claude Desktop read-only-mysql-mcp-server 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

Database tools

AgentHub Verified AvailabilityTested & Ready

Automated pipeline validated install commands, protocol & client compatibility

Verified At2026-10-04
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 read-only-mysql-mcp-server

Getting 'connection closed' or exit code 1 in Cursor / Claude Code for read-only-mysql-mcp-server?

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.

Still not connecting? Read the MCP troubleshooting guide →

Tool Mock Playground

Sandbox

read-only-mysql-mcp-server 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

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: read-only-mysql-mcp-server
HTML
<a href="https://myagenthub.cn/p/capital.hove/read-only-mysql-mcp-server" title="Listed on AgentHub: read-only-mysql-mcp-server" target="_blank" rel="noopener">
  <img src="https://myagenthub.cn/badge/capital.hove/read-only-mysql-mcp-server?lang=en" alt="Listed on AgentHub: read-only-mysql-mcp-server" height="20" style="border:0"/>
</a>
Markdown (GitHub README)
[![Listed on AgentHub: read-only-mysql-mcp-server](https://myagenthub.cn/badge/capital.hove/read-only-mysql-mcp-server?lang=en)](https://myagenthub.cn/p/capital.hove/read-only-mysql-mcp-server)

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": "capital.hove/read-only-mysql-mcp-server",
  "type": "mcp-server",
  "version": "0.1.0",
  "displayName": "read-only-mysql-mcp-server",
  "description": "MCP server for read-only MySQL database queries in Claude Desktop",
  "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": "capital.hove/read-only-mysql-mcp-server",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/capital.hove%2Fread-only-mysql-mcp-server/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}
read-only-mysql MCP Setup & Guide - AgentHub