How does this skill identify missing indexes?

The skill uses the database-index-advisor plugin to analyze your specific query patterns and database schema, identifying frequent or slow operations that would benefit from new indexes.

Can it help reduce database storage costs?

Yes, by identifying unused or redundant indexes, the skill helps you reclaim storage space and improve write performance by removing unnecessary overhead.

Is it safe to use on production databases?

The skill provides recommendations and reports rather than making direct changes, allowing you to review the impact assessment before applying any indexing strategies manually.

What permissions are required for this skill?

The underlying plugin requires read-level permissions to analyze query patterns, metadata, and existing index configurations within your database environment.

Database Index Advisor

Name: Database Index Advisor
Author: jeremylongshore

byjeremylongshore

•

884

Database Management

Analyzes database query patterns and workloads to provide actionable recommendations for index optimization and storage efficiency.

About

The Database Index Advisor skill empowers Claude to perform deep audits of database performance by identifying suboptimal indexing strategies. It analyzes active query workloads to detect missing indexes that could accelerate slow-running queries and pinpoints redundant or unused indexes that consume unnecessary storage and degrade write performance. This skill is essential for developers and database administrators seeking to automate performance tuning, reduce cloud storage costs, and maintain a lean, high-performance database infrastructure through data-driven recommendations.

Key Features

Missing index identification for slow queries
Detection of redundant or unused indexes
Storage and write-performance optimization
Detailed performance improvement reports
884 GitHub stars
Automated query workload analysis

Use Cases

Reducing database storage overhead by purging obsolete indexes
Optimizing slow-running SQL queries on large production tables
Pre-release database schema auditing for performance bottlenecks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills database-index-advisor

For use in Claude.ai and ChatGPT

Download Skill

GitHub