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.

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

01Missing index identification for slow queries

02Detection of redundant or unused indexes

03Storage and write-performance optimization

04Detailed performance improvement reports

05884 GitHub stars

06Automated query workload analysis

Use Cases

01Reducing database storage overhead by purging obsolete indexes

02Optimizing slow-running SQL queries on large production tables

03Pre-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

Key Features

01Missing index identification for slow queries

02Detection of redundant or unused indexes

03Storage and write-performance optimization

04Detailed performance improvement reports

05884 GitHub stars

06Automated query workload analysis

Use Cases

01Reducing database storage overhead by purging obsolete indexes

02Optimizing slow-running SQL queries on large production tables

03Pre-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