📊
Mysqlmcp
高性能、企业级MySQL数据库操作服务器。基于FastMCP v2.0+框架,提供29个专业数据库工具,集成了三级智能缓存、双层性能监控、增强的连接池管理、RBAC权限控制和全面的安全保护机制。
0 installs
Trust: 53 — Fair
Data
Installation
npx mysqlmcpAsk AI about Mysqlmcp
Powered by Claude · Grounded in docs
I know everything about Mysqlmcp. Ask me about installation, configuration, usage, or troubleshooting.
0/500
Loading tools...
Reviews
Documentation
mysqlmcp
A minimal Model Context Protocol (MCP) server for read-only MySQL queries.
Setup
- Copy the config template and edit it:
cp config.example.toml config.toml
- Ensure
mysql.dsnuses a read-only MySQL account.
Run
go run . -config config.toml
Tool
mysql_query- Input:
{ "query": "SELECT ..." } - Output:
{ "columns": [...], "rows": [...], "rowCount": 3, "truncated": false }
- Input:
Notes
- Only
SELECT,SHOW,DESCRIBE, andEXPLAINstatements are allowed by default. - The server enforces a read-only transaction and rejects queries containing semicolons.
- Use
deny_substringsin TOML to block edge-case write/lock clauses. - Configure row limits and timeouts via TOML.
