get_index_recommendations

Analyze MySQL query patterns to identify full table scans and inefficient queries, then generate prioritized index recommendations that improve database performance based on performance_schema statistics.

Instructions

Get AI-powered index recommendations for MySQL user tables.

Analyzes query patterns from performance_schema to recommend indexes:

Identifies queries with full table scans
Finds queries not using indexes efficiently
Suggests composite indexes for multi-column filters
Prioritizes recommendations by potential impact

Note: This tool only analyzes user/custom tables and excludes MySQL system tables (mysql, information_schema, performance_schema, sys).

Based on MySQL performance_schema statistics and query patterns. Similar to MySQLTuner's index analysis but with more detailed recommendations.

Input Schema

Name	Required	Description
`schema_name`	No	Schema/database to analyze
`max_recommendations`	No	Maximum number of recommendations (default: 10)
`min_improvement_percent`	No	Minimum expected improvement percentage (default: 10)
`include_query_analysis`	No	Include analysis of specific queries

Input Schema (JSON Schema)

{ "properties": { "include_query_analysis": { "default": true, "description": "Include analysis of specific queries", "type": "boolean" }, "max_recommendations": { "default": 10, "description": "Maximum number of recommendations (default: 10)", "maximum": 50, "minimum": 1, "type": "integer" }, "min_improvement_percent": { "default": 10, "description": "Minimum expected improvement percentage (default: 10)", "type": "number" }, "schema_name": { "description": "Schema/database to analyze", "type": "string" } }, "required": [], "type": "object" }

MySQL-Performance-Tuner-Mcp