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
How to use it
get_db_health_index_usage is exposed by the Mysql MCP Server Pro MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the get_db_health_index_usage tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install Mysql MCP Server Pro
pip install mysql_mcp_server_proOther tools in Mysql MCP Server Pro (9)
SQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands based on permission configuration
Convert Chinese field names to pinyin initials
Analyze MySQL health status (connection status, transaction status, running status, lock status detection)
Search for table structures in the database based on table names, supporting multi-table queries
Search for table indexes in the database based on table names, supporting multi-table queries
Check if there are row-level locks or table-level locks in the current MySQL server
Search for table names in the database based on table comments and descriptions
Professional SQL performance optimization tool, providing expert optimization suggestions based on MySQL execution plans, table structure information, table data volume, and table indexes.
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, see this class for details)