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

•

数据库管理

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

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.

主要功能

01Integration with database management workflows for seamless optimization

02883 GitHub stars

03Automated query pattern analysis for performance bottlenecks

04Detection of missing indexes based on real-world workload data

05Identification of unused or redundant indexes to reduce storage overhead

06Generation of actionable reports with specific indexing strategies

使用场景

01Optimizing slow-running SQL queries in production or development environments

02Tuning database performance during the scaling or migration phase of an application

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

主要功能

01Integration with database management workflows for seamless optimization

02883 GitHub stars

03Automated query pattern analysis for performance bottlenecks

04Detection of missing indexes based on real-world workload data

05Identification of unused or redundant indexes to reduce storage overhead

06Generation of actionable reports with specific indexing strategies

使用场景

01Optimizing slow-running SQL queries in production or development environments

02Tuning database performance during the scaling or migration phase of an application

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