indexing-query-optimization

What problem does it solve?

This Skill prevents slow or risky database changes by replacing blind index addition with index designs driven by actual predicates, sort requirements, cardinality, and execution plan evidence.

Core Features & Use Cases

• Named-Query-First Index Design: Forces every index to be tied to a specific beneficiary query so usefulness can be validated.
• Execution Plan Validation (Before/After): Requires representative EXPLAIN (ANALYZE, BUFFERS) evidence to confirm plan changes and real-row behavior.
• Write- and Migration-Safe Guardrails: Calculates write amplification, mandates online build strategy for large tables, and blocks unsafe pagination patterns on big datasets.

Quick Start

Ask for an indexing-query-optimization plan that names the target SQL query, lists its predicates and ORDER BY, and proposes only the minimal composite/covering indexes validated by EXPLAIN (ANALYZE, BUFFERS) before and after.