wenb1n-dev/mysql_mcp_server_pro
Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼!更加好用!不仅止于mysql的增删改查功能; 还包含了数据库异常分析能力;且便于开发者们进行个性化的工具扩展
Overview
wenb1n-dev/mysql_mcp_server_pro is a Python MCP server licensed under MIT. Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼!更加好用!不仅止于mysql的增删改查功能; 还包含了数据库异常分析能力;且便于开发者们进行个性化的工具扩展 Topics: mcp-server, ai, model-context-protocol, mysql, oauth2.
Ranked #2848 out of 25632 indexed tools.
Ecosystem
Python MIT
mcp-serveraimodel-context-protocolmysqloauth2
Signal Breakdown
Stars 290
Freshness 6mo ago
Issue Health 69%
Contributors 2
Dependents 0
Forks 39
Description Detailed
License MIT
How to Improve
Freshness high impact
Dependents medium impact
Matched Queries
From the README
# mcp_mysql_server_pro
## Introduction
mcp_mysql_server_pro is not just about MySQL CRUD operations, but also includes database anomaly analysis capabilities and makes it easy for developers to extend with custom tools.
- Supports all Model Context Protocol (MCP) transfer modes (STDIO, SSE, Streamable Http)
- Supports OAuth2.0
- Supports multiple SQL execution, separated by ";"
- Supports querying database table names and fields based on table comments
- Supports SQL execution plan analysis
- Supports Chinese field to pinyin conversion
- Supports table lock analysis
- Supports database health status analysis
- Supports permission control with three roles: readonly, writer, and admin
```
"readonly": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN"], # Read-only permissions
"writer": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE"], # Read-write permissions
"admin": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE",
"C Read full README on GitHub →
Are you the maintainer? Claim this listing