mysql-mcp-server-pro
A Python MCP server for MySQL that adds diagnostics to ordinary queries.
What it does
A Python MCP server for MySQL that adds diagnostics to ordinary queries. Besides running SQL, including several statements at once, it finds tables from their comments, describes table structures and indexes, checks for row and table locks, reports on database health and index usage, and suggests SQL optimisations from execution plans. One tool converts Chinese field names to pinyin initials. Access is controlled by a role setting: read-only, writer, or admin, which also allows creating, altering and dropping tables. It supports stdio, SSE and Streamable HTTP, optionally with OAuth 2.0, and developers can add their own tools.
Capabilities
- Run SQL with read-only, writer or admin permissions
- Describe tables and indexes
- Detect row and table locks
- Analyse database health and index usage
- Suggest SQL optimisations from execution plans
About
- Publisher
- wenb1n-dev
- Tool
- MySQL
Install
- Run this to add it to Any client:
pip install mysql_mcp_server_pro
MCP servers and skills can run code on your computer and act on your data. Review the source before installing.
Details
| Fact | Value | Source |
|---|---|---|
| Type | MCP server | |
| Tool | MySQL | |
| Publisher | wenb1n-dev | source |
| Official status | Community (not published by the tool's vendor) | source |
| Connection | Local (runs on your computer) | source |
| Can change data | Yes | source |
| Needs an API key or sign-in | Yes | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | MIT | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Aug 28, 2025Version 0.2.1249 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository pypi: mysql-mcp-server-pro |
Badge for your README
Maintain this project? Add a badge that links to this page.
[](https://kitbay.app/servers/wenb1n-dev-mysql-mcp-server-pro/)
Sources
- README (README.md)github.com/wenb1n-dev/mysql_mcp_server_pro · Backs: Can change data, Connection, Needs an API key or sign-inNov 12, 2026
- Licence file (LICENSE)github.com/wenb1n-dev/mysql_mcp_server_pro · Backs: LicenceNov 12, 2026
- GitHub repositorygithub.com/wenb1n-dev/mysql_mcp_server_pro · Backs: Official status, Publisher, Activity, LicenceNov 11, 2026
- PyPI package recordpypi.org/project/mysql-mcp-server-proNov 10, 2026