Does it require direct database access?

Yes, the skill requires a properly configured database connection with permissions to analyze query patterns and retrieve index metadata.

Can it help reduce database storage costs?

Yes, it identifies unused indexes that consume unnecessary disk space and can be safely removed to reclaim storage.

How does this skill help with slow queries?

The skill analyzes your database workload to identify missing indexes that would speed up data retrieval for specific query patterns.

Are the recommendations applied automatically?

No, the skill provides actionable recommendations that you can review and apply manually or through database management tools.

Will removing indexes improve write performance?

Yes, reducing the number of redundant indexes decreases the overhead required for INSERT, UPDATE, and DELETE operations.

Database Index Advisor

Name: Database Index Advisor
Author: BbgnsurfTech

byBbgnsurfTech

•

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 act as an automated database administrator, leveraging the database-index-advisor plugin to scan query patterns and existing configurations. It provides actionable insights to resolve performance bottlenecks by identifying where new indexes are needed and where unused indexes are wasting storage and slowing down write operations. This is an essential tool for developers looking to maintain high-performance, efficient database environments without manual profiling.

Key Features

3 GitHub stars
Detailed reports with specific indexing recommendations
Support for improving both read and write performance
Identification of missing indexes for performance gains
Automated analysis of database query workloads
Detection of unused indexes to reduce storage overhead

Use Cases

Performing periodic database audits to prune redundant indexes
Optimizing slow-running production queries in real-time
Reducing storage costs by identifying unnecessary data structures

About

Key Features

3 GitHub stars
Detailed reports with specific indexing recommendations
Support for improving both read and write performance
Identification of missing indexes for performance gains
Automated analysis of database query workloads
Detection of unused indexes to reduce storage overhead

Use Cases

Performing periodic database audits to prune redundant indexes
Optimizing slow-running production queries in real-time
Reducing storage costs by identifying unnecessary data structures