SQL Optimization Patterns

About

This skill empowers Claude to transform sluggish database operations into high-performance queries by applying systematic optimization techniques. It covers everything from interpreting EXPLAIN execution plans and implementing sophisticated indexing (B-Tree, GIN, Partial) to resolving common anti-patterns like N+1 queries and inefficient pagination. Whether you are designing a new schema or debugging a production performance bottleneck, this skill provides the domain-specific logic needed to reduce database load, improve application response times, and ensure scalability for growing datasets.

Key Features

• Deep analysis of SQL execution plans using EXPLAIN and EXPLAIN ANALYZE
• Advanced database scaling techniques like table partitioning and materialized views
• Optimization of complex JOINs, subqueries, and window functions for maximum efficiency
• Implementation of advanced indexing strategies including Composite, GIN, and Partial indexes
• Automated resolution of N+1 query anti-patterns and pagination bottlenecks
• 0 GitHub stars

Use Cases

• Reducing cloud database costs by optimizing query efficiency and reducing CPU/IO usage
• Designing high-performance database schemas for data-intensive applications
• Refactoring slow-running legacy queries to drastically improve application latency