What is required to use this skill?

You need the database-index-advisor plugin configured with the necessary permissions to access your database metadata and query logs.

Does this skill automatically modify my database?

No, the skill generates reports and actionable recommendations that you can review and apply manually to ensure total control over your schema.

How does the Database Index Advisor work?

It analyzes your database's query patterns and current indexing configuration to identify performance gaps and provide specific optimization recommendations.

Can I use this for both SQL and NoSQL databases?

This skill is primarily designed for relational databases where indexing strategies significantly impact query execution plans and performance.

Can it help reduce database storage costs?

Yes, it identifies redundant or unused indexes that consume unnecessary disk space, allowing you to safely remove them.

Database Index Advisor

Name: Database Index Advisor
Author: intent-solutions-io

byintent-solutions-io

Database Management

Analyzes query workloads and provides actionable recommendations to optimize database indexing strategies for improved performance.

About

The Database Index Advisor skill empowers developers to fine-tune database performance by automating the analysis of query patterns and existing index structures. It detects performance bottlenecks caused by missing indexes and identifies redundant or unused indexes that bloat storage and slow down write operations, providing clear guidance on how to optimize database schemas for both speed and efficiency within the Claude Code environment.

Key Features

Storage reclamation through index cleanup guidance
0 GitHub stars
Automated query workload and pattern analysis
Detection of missing index opportunities
Identification of unused or redundant indexes
Actionable reports for indexing strategy improvement

Use Cases

Optimizing slow-running database queries and bottlenecks
Reducing database storage costs by removing obsolete indexes
Auditing database health during migrations or scaling phases

About

Key Features

Storage reclamation through index cleanup guidance
0 GitHub stars
Automated query workload and pattern analysis
Detection of missing index opportunities
Identification of unused or redundant indexes
Actionable reports for indexing strategy improvement

Use Cases

Optimizing slow-running database queries and bottlenecks
Reducing database storage costs by removing obsolete indexes
Auditing database health during migrations or scaling phases