How does the Database Index Advisor find missing indexes?

The skill analyzes your database's query workload and execution patterns to identify specific columns and tables that would benefit from new indexing to reduce latency.

Is it safe to use this skill on production databases?

Yes, the advisor focuses on analysis and reporting. While it provides recommendations, it is best practice to review these suggestions in a staging environment before applying them to production.

Will this skill help reduce my database storage costs?

Yes, by identifying unused or redundant indexes that are consuming disk space and slowing down write operations, it helps you safely reclaim storage.

What databases does the Index Advisor support?

It is designed to work with standard relational database management systems (RDBMS) where indexing strategies are a primary factor in query performance.

Can this skill automatically delete my indexes?

No, it generates a detailed report and actionable recommendations. You maintain full control over reviewing and applying the suggested changes to your database schema.

Database Index Advisor

Name: Database Index Advisor
Author: jeremylongshore

byjeremylongshore

•

883

Database Management

Optimizes database performance by analyzing query workloads to recommend missing indexes and identify redundant ones.

About

The Database Index Advisor skill empowers Claude to diagnose and resolve database performance bottlenecks by leveraging the database-index-advisor plugin. It systematically evaluates query patterns and existing index configurations to provide actionable insights, such as suggesting new indexes for slow-running queries or identifying unused indexes to reclaim storage and improve write throughput. This skill is essential for developers and database administrators who need to maintain efficient, high-performance database environments without the overhead of manual profiling.

Key Features

Integration with database management workflows for seamless optimization
883 GitHub stars
Automated query pattern analysis for performance bottlenecks
Detection of missing indexes based on real-world workload data
Identification of unused or redundant indexes to reduce storage overhead
Generation of actionable reports with specific indexing strategies

Use Cases

Optimizing slow-running SQL queries in production or development environments
Tuning database performance during the scaling or migration phase of an application
Performing routine database maintenance to remove bloated or unnecessary indexes

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