skills.rest
jeremylongshore
jeremylongshoreCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

analyzing-database-indexes

Analyze database workloads and recommend index creation, modification, or removal.

2.6k|379|Updated Oct 10, 2025
Search Tags:#performance#query optimization#SQL#database#analysis#indexes#bottlenecks
One-click install
npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill analyzing-database-indexes
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: analyzing-database-indexes
Source: https://github.com/jeremylongshore/claude-code-plugins-plus/tree/main/plugins/database/database-index-advisor/skills/database-index-advisor
Command: npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill analyzing-database-indexes

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

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 orders table 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:

  1. Activate the database-index-advisor plugin.
  2. Analyze the query patterns against the orders table.
  3. Recommend creating a specific index on the orders table to improve query performance.

Frequently Asked Questions about analyzing-database-indexes

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow database queries with index analysis?▼

Database index analysis identifies missing or suboptimal indexes causing slow queries. The skill analyzes your query patterns and workload against relational databases, then recommends specific indexes to create or modify for faster performance, complete with impact considerations for implementation.

What's the best way to find unused indexes in my database?▼

Unused index detection scans your database workload to flag indexes that aren't contributing to query performance. Removing unused indexes reclaims storage space and improves write performance on tables, reducing overhead from maintenance operations.

Can I analyze database query performance across production and development environments?▼

Yes, the skill analyzes database indexes and query workloads in both production and development environments. It requires a configured database connection with appropriate permissions to examine query patterns and recommend indexing strategies tailored to each environment.

How does database index optimization improve query performance?▼

Indexes accelerate queries by enabling faster data lookup and filtering. Index optimization identifies which columns should be indexed based on your specific query patterns, eliminating sequential table scans and reducing execution time for slow-running queries.

What database systems does index analysis work with?▼

Index analysis works with relational databases in production and development environments. The skill relies on the database-index-advisor plugin to provide recommendations across standard SQL database platforms for queries experiencing performance issues.

What do I need before running index analysis on my database?▼

You need a configured database connection, appropriate database permissions to read query metadata and index statistics, and access to the database-index-advisor plugin. The skill then outputs actionable recommendations for index creation, modification, or removal.

Related Skills

Explore More Software Engineering Skills→
Spectra29115Spectra29115

database

Manage PostgreSQL databases and execute read-only SQL queries safely.

Community
Intermediate
lazyFrogLOLlazyFrogLOL
127

query-optimize

Optimize slow SQL queries with plan analysis and index recommendations.

Community
Intermediate
AutumnsGroveAutumnsGrove
5

fox-optimize

Profile applications and apply targeted performance fixes like code splitting and caching.

Community
Advanced
HieubkavHieubkav

database-performance

Analyze database indexes and query execution plans to recommend optimizations.

Community
Advanced