Analyzes database query workloads to identify missing indexes and recommend optimizations for peak performance.
The Database Index Advisor skill empowers Claude to proactively manage and optimize database health by analyzing query patterns and existing index configurations. It identifies performance bottlenecks caused by missing indexes and flags redundant, unused indexes that waste storage and slow down write operations. By providing actionable, data-driven indexing strategies, this skill helps developers and DBAs maintain high-efficiency databases as application workloads evolve and scale.
Key Features
01Automated analysis of database query patterns
02Detection of missing indexes to resolve slow queries
03Performance impact reporting for read and write operations
04Actionable recommendations for indexing strategies
050 GitHub stars
06Identification of unused indexes to reclaim storage
Use Cases
01Optimizing slow-running SQL queries on large production tables
02Pre-emptive indexing analysis for new application features
03Cleaning up legacy databases by removing redundant indexes
