🇺🇸 English version available here
mysql-mcp-pro is an MCP project maintained in the ccct173/mysql-mcp-pro repository. The maintainer describes its purpose as “🇺🇸 English version available here”. Read the project documentation for the complete scope.
The project provides a local client configuration using python. Follow the repository’s build and installation steps before copying it, and replace example paths with the paths on your own computer.
The example declares MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE. Secret-looking values have been replaced with placeholders. Required and optional labels are shown only when the documentation states them.
Project documentation · Repository · Discovery listing. This profile records the public documentation checked on 2026-10-08.
Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.
| Tool | What it does |
|---|---|
| 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. |
| describe_table | Show table schema: columns, primary key, indexes, foreign keys, CREATE SQL. Arguments: table (required), database (optional). |
| list_views | List views in the database. |
| list_routines | List stored procedures or functions. Arguments: routine_type (PROCEDURE/FUNCTION), database. |
| list_triggers | List triggers in the database. |
| er_graph | Cross-table foreign-key graph as nodes + edges, ready for ER diagrams. |
| execute_query | Execute any SQL (read/write/DDL, safety-guarded), parameterized. Arguments: sql, database, params, session_id. |
| execute_select | Read-only SELECT/SHOW/DESCRIBE/EXPLAIN with extra safety layer. Arguments: sql, database, params, limit. |
| get_table_data | Quick paginated table fetch. Arguments: table, columns, where, order_by, limit, offset. |
| count_rows | Count rows in a table with optional WHERE. Arguments: table, database, where. |
| explain_query | Run EXPLAIN on a query and return plain-language performance insights. Arguments: sql, database, params, format. |
| export_query | Export SELECT results to a CSV (UTF-8 BOM, Excel-friendly) or JSON file. Arguments: sql, filename, format (csv/json), database, params. |
| list_query_history | Recent SQL executed in this session (duration, row count, errors). Argument: limit. |
| begin_transaction | Start a new transaction; returns a session_id for chained calls. Argument: database. |
| commit_transaction | Commit an open transaction. Argument: session_id. |
| rollback_transaction | Rollback an open transaction. Argument: session_id. |
| show_processlist | Show the current MySQL process list (SHOW FULL PROCESSLIST). |
| kill_query | Kill a MySQL process (requires SUPER privilege). Argument: process_id. |
{
"mcpServers": {
"mysql": {
"command": "python",
"args": [
"-m",
"server"
],
"cwd": "D:/path/to/mysql-mcp-pro",
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASSWORD": "YOUR_MYSQL_PASSWORD",
"MYSQL_DATABASE": "your_database"
}
}
}
}From the project documentation. Replace placeholders and example paths before connecting.
| Variable | Description | Required |
|---|---|---|
| MYSQL_HOST | Declared in the maintainer’s client configuration. | Check documentation |
| MYSQL_PORT | Declared in the maintainer’s client configuration. | Check documentation |
| MYSQL_USER | Declared in the maintainer’s client configuration. | Check documentation |
| MYSQL_PASSWORD | Declared in the maintainer’s client configuration. | Check documentation |
| MYSQL_DATABASE | Declared in the maintainer’s client configuration. | Check documentation |
Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.
Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.
Use the Supabase MCP server to inspect database schemas, query project data and retrieve docs through a project-scoped connection.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.