MySQL Server Pro
JSON →A MySQL server with CRUD operations, database anomaly analysis, and support for SSE and STDIO.
Install
pip install mysql_mcp_server_pro Tools · 10
- execute_sql SQL execution tool that can execute SELECT, SHOW, DESCRIBE, EXPLAIN, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, TRUNCATE commands based on permission configuration
- get_chinese_initials Convert Chinese field names to pinyin initials
- get_db_health_running Analyze MySQL health status (connection status, transaction status, running status, lock status detection)
- get_table_desc Search for table structures in the database based on table names, supporting multi-table queries
- get_table_index Search for table indexes in the database based on table names, supporting multi-table queries
- get_table_lock Check if there are row-level locks or table-level locks in the current MySQL server
- get_table_name Search for table names in the database based on table comments and descriptions
- get_db_health_index_usage Get the index usage of the currently connected mysql database, including redundant index situations, poorly performing index situations, and the top 5 unused index situations with query times greater than 30 seconds
- optimize_sql Professional SQL performance optimization tool, providing expert optimization suggestions based on MySQL execution plans, table structure information, table data volume, and table indexes
- use_prompt_queryTableData Use built-in prompts to let the model construct a chain call of tools in mcp (not a commonly used fixed tool, you need to modify the code to enable it)
Environment variables
MYSQL_HOSTMYSQL_PORT
Links
★ 244 GitHub stars