MySQL 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)