Can this skill help resolve N+1 query problems?

Yes, it provides clear patterns for transforming N+1 query loops into efficient batch loads or JOIN-based queries to minimize database round-trips.

What types of indexing strategies are included?

The skill covers a wide range of strategies including B-Tree, GIN for JSONB/Search, BRIN for large tables, and partial indexes for specific data subsets.

How does this skill help with slow database queries?

It provides systematic patterns for analyzing EXPLAIN plans to identify bottlenecks like sequential scans and recommends specific indexing or query refactoring to improve speed.

Which database engines are supported?

While the core optimization concepts apply to most SQL databases, the skill includes specific implementation examples and syntax for PostgreSQL and MySQL.

Is this skill useful for high-scale pagination?

Absolutely. It demonstrates why OFFSET-based pagination fails at scale and provides patterns for implementing efficient cursor-based pagination.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: HermeticOrmus

byHermeticOrmus

0•

Database Management

Optimizes SQL query performance through systematic indexing strategies, execution plan analysis, and efficient query patterns.

This skill provides specialized knowledge for diagnosing and resolving database bottlenecks by analyzing execution plans and implementing high-performance SQL patterns. It enables developers to transform slow operations into lightning-fast queries using advanced indexing strategies, cursor-based pagination, and batch processing techniques. Whether you are debugging production performance issues or designing scalable database schemas, this skill offers the domain-specific guidance needed to eliminate N+1 queries and minimize database load.

Key Features

01Proven patterns to eliminate N+1 query anti-patterns

02Advanced indexing techniques including GIN, BRIN, and covering indexes

03High-performance pagination strategies using cursor-based logic

040 GitHub stars

05In-depth EXPLAIN and EXPLAIN ANALYZE plan interpretation

06Optimization of complex JOINs, CTEs, and window functions

Use Cases

01Designing high-performance database schemas for large-scale datasets

02Refactoring legacy application code to reduce database overhead and costs

03Diagnosing and fixing slow-running production database queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/hermetic-academy sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill