What information does the advisor need to work?

The skill requires access to your database schema and query workload logs to accurately identify usage patterns and performance bottlenecks.

How does this skill improve query performance?

It analyzes your specific query patterns and identifies where the database is missing indexes that could accelerate data retrieval and reduce execution time.

Can it help reduce database storage costs?

Yes, by identifying unused or redundant indexes that can be safely removed to reclaim disk space and reduce the overhead on write operations.

Does it automatically apply changes to my database?

No, it generates detailed reports and recommendations so you can review the impact and apply changes manually or via your standard migration process.

Database Index Advisor

Name: Database Index Advisor
Author: jeremylongshore

byjeremylongshore

•

884

データベース管理

Analyzes database workloads and query patterns to provide actionable recommendations for optimizing and managing indexes.

概要

This skill empowers Claude to significantly enhance database performance by analyzing query execution patterns and existing index configurations. It automatically identifies performance bottlenecks caused by missing indexes and uncovers redundant or unused indexes that consume storage and slow down write operations, providing a comprehensive report with concrete strategies for database optimization and storage reclamation.

主な機能

Detection of missing index opportunities to fix slow queries
Automated workload and query pattern analysis
Integration with existing database monitoring workflows
Identification of unused or redundant indexes for removal
884 GitHub stars
Actionable recommendations for indexing strategies

ユースケース

Performing routine database health checks and index audits
Optimizing slow-running production queries in real-time
Reducing database storage costs and improving write performance

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

概要