SQL Optimization Patterns

关于

This skill empowers developers to transform sluggish database queries into high-performance operations by applying systematic optimization techniques. It provides deep guidance on interpreting EXPLAIN plans, selecting the correct index types (such as B-Tree, GIN, and BRIN), and refactoring common anti-patterns like N+1 queries and inefficient OFFSET pagination. Whether you are designing a new schema or troubleshooting a production bottleneck, this skill offers the implementation patterns and best practices needed to scale database-driven applications effectively while reducing infrastructure costs.

主要功能

• Systematic patterns for eliminating N+1 query anti-patterns
• 0 GitHub stars
• Advanced batch operation patterns for large-scale data updates
• High-performance cursor-based pagination strategies
• Deep EXPLAIN and EXPLAIN ANALYZE query plan interpretation
• Implementation of specialized index types including GIN, GiST, and BRIN

使用场景

• Identifying and fixing performance bottlenecks in slow-running production queries
• Designing scalable database schemas for applications with high data volume
• Refactoring legacy SQL queries to reduce database server load and cloud costs