optimize-queries

Query optimization analyzes EXPLAIN ANALYZE output to identify bottlenecks, then applies targeted fixes like indexing, RLS policy improvements, and query restructuring. This Skill automates the analysis and recommends concrete optimizations to improve performance across development, staging, and production environments.

Index recommendations identify which columns or compound indexes eliminate sequential scans and reduce query cost. This Skill proposes targeted indexes based on EXPLAIN ANALYZE output, creates migration scripts, and verifies performance gains using index usage metrics.

Row-level security policies can impact query execution plans. This Skill analyzes policy structure alongside query patterns, recommends restructuring to maintain security while reducing overhead, and tests changes across environments before production deployment.

Performance measurement compares EXPLAIN ANALYZE metrics and index usage before and after optimization. This Skill executes queries, captures execution plans, and reports quantified improvements to verify that recommended changes actually reduce query cost.

This Skill handles testing automatically across development, staging, and production environments. It creates migration scripts, validates changes against current workloads, and measures performance impact before committing optimizations to production.