What information does the advisor need to work?

The skill requires access to your database schema and query workload logs to accurately identify usage patterns and performance bottlenecks.

How does this skill improve query performance?

It analyzes your specific query patterns and identifies where the database is missing indexes that could accelerate data retrieval and reduce execution time.

Can it help reduce database storage costs?

Yes, by identifying unused or redundant indexes that can be safely removed to reclaim disk space and reduce the overhead on write operations.

Does it automatically apply changes to my database?

No, it generates detailed reports and recommendations so you can review the impact and apply changes manually or via your standard migration process.

Database Index Advisor

Name: Database Index Advisor
Author: jeremylongshore

byjeremylongshore

•

884

•

データベース管理

Analyzes database workloads and query patterns to provide actionable recommendations for optimizing and managing indexes.

This skill empowers Claude to significantly enhance database performance by analyzing query execution patterns and existing index configurations. It automatically identifies performance bottlenecks caused by missing indexes and uncovers redundant or unused indexes that consume storage and slow down write operations, providing a comprehensive report with concrete strategies for database optimization and storage reclamation.

主な機能

01Detection of missing index opportunities to fix slow queries

02Automated workload and query pattern analysis

03Integration with existing database monitoring workflows

04Identification of unused or redundant indexes for removal

05884 GitHub stars

06Actionable recommendations for indexing strategies

ユースケース

01Performing routine database health checks and index audits

02Optimizing slow-running production queries in real-time

03Reducing database storage costs and improving write performance

主な機能

01Detection of missing index opportunities to fix slow queries

02Automated workload and query pattern analysis

03Integration with existing database monitoring workflows

04Identification of unused or redundant indexes for removal

05884 GitHub stars

06Actionable recommendations for indexing strategies

ユースケース

01Performing routine database health checks and index audits

02Optimizing slow-running production queries in real-time

03Reducing database storage costs and improving write performance