Featured

analyzing-database-indexes

Name: analyzing-database-indexes
Rating: 5 (621 reviews)
Author: jeremylongshore

This skill uses the database-index-advisor plugin to analyze query patterns and recommend optimal database indexes. It identifies missing indexes to improve query performance and unused indexes that can be removed to save storage and improve write performance. Use this skill when the user asks to "analyze database indexes", "optimize slow queries", "find missing indexes", "remove unused indexes", or requests help with "database index optimization". The plugin analyzes database workloads, detects potential indexing issues, and provides actionable recommendations for indexing strategies.

TL;DR

Analyzes database workloads to recommend index improvements and removal of unused indexes.

What Is It

Identifies missing indexes to improve query performance.
Detects unused indexes for removal to save storage.
Provides actionable recommendations for index optimization.
Leverages a plugin to analyze query patterns and index usage.

Key Features

Analyzes query workload and index configurations.
Identifies missing indexes and unused indexes.
Generates actionable recommendations for index changes.
Supports performance optimization and storage space recovery.
Integrates with monitoring tools for performance tracking.
Provides clear reports on index usage and recommendations.

How to Use

1.Ensure proper database connection and permissions.
2.Request optimization for slow queries or unused indexes.
3.The skill activates the database-index-advisor plugin.
4.Analyze query patterns and existing indexes.
5.Review and apply recommended index changes.
6.Monitor performance impact post-implementation.

Guardrails & Gotchas

MUST review recommended changes for potential impact on other queries.
FORBIDDEN to apply changes without assessing performance impact.
MUST ensure proper plugin permissions and database access.

Explore More Skills

move-code-quality

@davila7

Analyzes Move language packages against the official Move Book Code Quality Checklist. Use this skill when reviewing Move code, checking Move 2024 Edition compliance, or analyzing Move packages for best practices. Activates automatically when working with .move files or Move.toml manifests.

12.4k

1.1k

1w ago