sql-optimization-patterns

Use this Skill to interpret execution plans and identify bottlenecks like sequential scans or inefficient joins. It guides you through indexing strategies and query rewriting patterns to reduce slow query latency.

The best way is to apply an indexing playbook that builds and tunes B-tree, partial, and composite indexes. This Skill helps you select the right index types to accelerate critical queries and improve database throughput.

Resolve N+1 query problems and optimize SQL aggregates by applying proven query rewriting patterns from a pattern library. This Skill targets N+1 queries, pagination, and subqueries to improve database throughput.

Yes, this approach works with MySQL and PostgreSQL. It optimizes SQL queries across relational databases to debug slow queries, design scalable schemas, and improve runtime performance.

Use partial or composite indexes when facing slow transactional or warehouse queries that require targeted data access. This Skill helps you build and tune specialized indexes to accelerate critical queries and reduce resource usage.

To debug slow SQL queries, you need to provide EXPLAIN plans, available indexing options, and schema details. This Skill requires these inputs to reason about query plans and apply effective optimization patterns.