Is it safe to use on production databases?

Yes, the advisor primarily analyzes query logs and schema metadata to provide recommendations without modifying your data directly.

Does it automatically apply changes to my database?

No, it provides a detailed report and recommendations for you to review and apply, ensuring you maintain full control over your database schema.

How does this skill help with slow queries?

It analyzes specific query patterns and table structures to recommend missing indexes that can significantly reduce query execution time.

Can it help reduce database storage costs?

Yes, by identifying and recommending the removal of unused or redundant indexes that consume unnecessary disk space.

Database Index Advisor

Name: Database Index Advisor
Author: intent-solutions-io

byintent-solutions-io

データベース管理

Analyzes database query patterns and workloads to provide actionable recommendations for index optimization and performance tuning.

概要

The Database Index Advisor skill empowers Claude to identify and resolve performance bottlenecks within your database systems. By leveraging the database-index-advisor plugin, it scrutinizes query workloads to detect missing indexes that could accelerate slow queries and identifies redundant or unused indexes that consume unnecessary storage. This skill is essential for developers and DBAs looking to automate the complex task of performance tuning, ensuring optimal read/write efficiency and resource utilization across SQL environments.

主な機能

Storage optimization recommendations for large datasets
Automated query workload and pattern analysis
Actionable reporting on database indexing strategies
Detection of missing indexes to accelerate slow queries
Identification of unused indexes to improve write performance
0 GitHub stars

ユースケース

Generating indexing strategies during database migrations or scaling
Optimizing slow-running SQL queries on large production tables
Auditing database schemas to remove bloat and reduce storage costs

概要

主な機能

Storage optimization recommendations for large datasets
Automated query workload and pattern analysis
Actionable reporting on database indexing strategies
Detection of missing indexes to accelerate slow queries
Identification of unused indexes to improve write performance
0 GitHub stars

ユースケース

Generating indexing strategies during database migrations or scaling
Optimizing slow-running SQL queries on large production tables
Auditing database schemas to remove bloat and reduce storage costs