analyzing-database-indexes
CommunityOptimize database queries with smart index recommendations.
Authorjeremylongshore
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This skill empowers Claude to analyze database workloads, identify suboptimal or missing indexes, and suggest improvements to enhance database performance. It leverages the database-index-advisor plugin to provide concrete recommendations for indexing strategies, including identifying unused indexes for removal.
Core Features & Use Cases
- Query Performance Optimization: Identify and recommend missing indexes for slow queries.
- Unused Index Detection: Reclaim storage and improve write performance by identifying and suggesting removal of unused indexes.
- Workload Analysis: Analyze database query patterns to provide actionable indexing strategies.
- Use Case: Optimize a slow-running query on your
orderstable by getting a recommendation for a new, optimal index.
Quick Start
User request: "My orders table query is running slowly. Can you help optimize it?"
The skill will:
- Activate the
database-index-advisorplugin. - Analyze the query patterns against the orders table.
- Recommend creating a specific index on the orders table to improve query performance.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: analyzing-database-indexes Download link: https://github.com/jeremylongshore/claude-code-plugins-plus/archive/main.zip#analyzing-database-indexes Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.