database-performance

Name: database-performance
Availability: InStock
Author: Hieubkav

Analyze database indexes and query execution plans to recommend optimizations.

Updated Oct 26, 2025

Search Tags:#performance #indexing #sql #explain #query profiling

Ready to run

npx skills add https://github.com/Hieubkav/wincellarCloneBackend --skill database-performance-hieubkav

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-performance
Source: https://github.com/Hieubkav/wincellarCloneBackend/tree/main/.claude/skills/database/database-performance
Command: npx skills add https://github.com/Hieubkav/wincellarCloneBackend --skill database-performance-hieubkav

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill analyzes database indexes and query performance to optimize speed and resource usage.

Core Features & Use Cases

Index analysis: discover missing/unused indexes
Query profiling: interpret EXPLAIN plans and bottlenecks
Actionable optimization recommendations

Quick Start

Review a slow query and generate recommended index strategies.

Frequently Asked Questions about database-performance

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

FAQPage Schema

How do I identify and fix slow database queries?▼

Slow queries can be identified and optimized by analyzing EXPLAIN plans to reveal execution bottlenecks, then creating missing indexes or rewriting the query logic. This Skill interprets query plans and recommends specific index strategies and rewrites tailored to your workload.

What does an EXPLAIN plan tell me about query performance?▼

EXPLAIN plans show how the database executes a query, revealing which indexes are used, table scan costs, and join operations. Interpreting these plans identifies bottlenecks like missing indexes or inefficient join orders, guiding targeted optimization.

How do I know which database indexes are actually being used?▼

Index analysis through query profiling and workload review reveals which indexes are accessed and which remain unused. This Skill discovers missing indexes that would speed up queries and identifies unused indexes candidates for removal to reduce storage and write overhead.

Can I optimize complex queries across evolving database schemas?▼

Yes. Query profiling adapts to schema changes by re-analyzing workloads and execution plans as tables and columns evolve. This Skill detects performance regressions from schema modifications and recommends index adjustments and query rewrites for the updated structure.

What's the best way to handle multiple slow queries at once?▼

Workload analysis prioritizes optimization by profiling all slow queries together, identifying common bottlenecks and missing indexes across the set. This Skill generates a ranked list of index creation and removal suggestions that improve overall system performance.

Do I need to rewrite my queries to improve performance?▼

Not always. Index optimization alone often resolves slow queries, but some cases benefit from query rewrites. This Skill recommends both approaches: practical index strategies first, with rewrite suggestions when indexing alone cannot eliminate bottlenecks.