How does this skill help with slow queries?

It provides systematic patterns for analyzing EXPLAIN plans and suggests specific indexing or refactoring techniques to dramatically reduce query execution time.

Is cursor-based pagination included?

Absolutely. The skill provides patterns to move away from slow OFFSET-based pagination toward high-performance cursor-based navigation for large tables.

Which databases are supported by these patterns?

While many examples focus on PostgreSQL and MySQL, the core optimization concepts like index selection and join optimization apply to most relational database systems.

Can it help solve the N+1 query problem?

Yes, it includes specific strategies for identifying N+1 anti-patterns and converting them into efficient JOINs or batch loading operations.

Does it cover advanced indexing beyond basic B-Trees?

Yes, it includes guidance on GIN, GiST, and BRIN indexes, as well as functional, partial, and covering indexes for specialized performance needs.

SQL Performance Optimization Patterns

Name: SQL Performance Optimization Patterns
Author: Activer007

byActiver007

•

데이터베이스 관리

Optimizes database performance through advanced SQL query patterns, strategic indexing, and detailed execution plan analysis.

This skill empowers developers to transform sluggish database operations into high-performance queries by applying systematic optimization techniques. It provides comprehensive guidance on interpreting EXPLAIN outputs, implementing advanced indexing strategies like GIN and BRIN, and refactoring common performance bottlenecks such as N+1 queries and inefficient pagination. Whether you are designing a new schema for scale or debugging production bottlenecks, these patterns help reduce database load and improve application responsiveness across PostgreSQL, MySQL, and other relational systems.

주요 기능

01Deep EXPLAIN and EXPLAIN ANALYZE plan interpretation

02Refactoring patterns for N+1 queries and subquery optimization

03Batch operation patterns for efficient bulk inserts and updates

04Advanced indexing strategies including composite, partial, and covering indexes

05High-performance pagination techniques using cursor-based logic

061 GitHub stars

사용 사례

01Reducing cloud infrastructure costs by minimizing database CPU and I/O usage

02Debugging and fixing slow-running production database queries

03Designing performant schemas for applications with large datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add activer007/ordinary-claude-skills sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill