mysql-mcp-pro
About
A production-grade MySQL MCP server with connection pooling, transactions, EXPLAIN analysis, CSV/JSON export, ER graph, audit log, and prompt templates. 25 tools included.
Details
- Author
- CCCT173
- GitHub stars
- 1
- Downloads
- 192
- Categories
- Search
Jump to
- ping — Test MySQL connection; returns server version and connection-pool stats
- get_server_status — Key MySQL status metrics (connections, QPS, slow queries, InnoDB rows, traffic)
- list_databases — List all databases (system vs user)
- list_tables — List tables with engine, row count, size, comment. Optional database argument
- list_views — List views in the database
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
mysql-mcp-proCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Follow the repository README to install the server and add its MCP configuration to your client.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mysql-mcp-pro": {
"mysql-mcp-pro": {
"command": "python",
"args": [
"scripts/setup_test_db.py"
]
}
}
}
}McpServers
{
"mysql-mcp-pro": {
"command": "python",
"args": [
"scripts/setup_test_db.py"
]
}
}A production-grade MySQL MCP server with connection pooling, transactions, EXPLAIN analysis, CSV/JSON export, ER graph, audit log, and prompt templates. 25 tools included.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
