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.

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

013 GitHub stars

02Detailed reports with specific indexing recommendations

03Support for improving both read and write performance

04Identification of missing indexes for performance gains

05Automated analysis of database query workloads

06Detection of unused indexes to reduce storage overhead

Use Cases

01Performing periodic database audits to prune redundant indexes

02Optimizing slow-running production queries in real-time

03Reducing storage costs by identifying unnecessary data structures

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection database-index-advisor

For use in Claude.ai and ChatGPT

Download Skill