Database Index Advisor

About

The Database Index Advisor skill enables Claude to evaluate database workloads and identify performance bottlenecks caused by suboptimal indexing. By analyzing query patterns, it provides concrete recommendations for adding missing indexes to speed up slow queries and removing redundant or unused indexes to reclaim storage and improve write performance. This is an essential tool for developers and DBAs looking to automate database performance tuning and maintain a lean, efficient data architecture.

Key Features

• Actionable reports with specific indexing strategy recommendations
• Automated database workload and query analysis
• Identification of unused indexes to reduce storage and improve write speed
• 3 GitHub stars
• Detection of missing indexes to resolve slow queries
• Integration with existing database management workflows

Use Cases

• Optimizing slow-running SQL queries in production or development environments
• Audit of existing database schemas to reclaim storage by removing redundant indexes
• Performance tuning during database migrations or schema updates