Can this skill help resolve N+1 query problems?

Yes, it provides specific implementation patterns for transforming N+1 query anti-patterns into efficient JOINs or batch loading operations to reduce database round-trips.

How does this skill help with slow SQL queries?

It enables Claude to analyze database execution plans (EXPLAIN), identify bottlenecks like sequential table scans, and suggest specific indexing or query rewrites to significantly improve execution speed.

Does it support databases other than PostgreSQL?

While many examples focus on PostgreSQL, the core optimization principles, indexing strategies, and query patterns are applicable to MySQL, SQL Server, and most relational databases.

What kind of indexing strategies does this skill cover?

It covers a wide range of strategies including B-Tree for standard lookups, GIN for JSONB and full-text search, composite indexes for multi-column filters, and partial indexes for specific data subsets.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: gwickman

bygwickman

0•

Database Management

Optimizes SQL query performance through systematic indexing, EXPLAIN plan analysis, and efficient query refactoring patterns.

This skill equips Claude with advanced database performance tuning expertise, allowing it to transform slow, resource-heavy queries into high-performance operations. It provides deep guidance on interpreting execution plans, implementing sophisticated indexing strategies—such as composite, partial, and covering indexes—and resolving common architectural bottlenecks like the N+1 query problem. Whether you are designing a new schema for scale or debugging production latency, this skill ensures your database layer remains cost-effective and lightning-fast.

Key Features

01In-depth analysis of EXPLAIN and EXPLAIN ANALYZE query plans

02Query refactoring to eliminate N+1 patterns and inefficient JOINs

03Performance-first pagination techniques using cursor-based logic

04Advanced optimization via Materialized Views and Table Partitioning

050 GitHub stars

06Strategic indexing guidance for B-Tree, GIN, GiST, and BRIN types

Use Cases

01Debugging and fixing slow-running production database queries

02Designing high-performance database schemas for new applications

03Refactoring ORM-generated queries to reduce database load and costs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add gwickman/auto-dev-test-target-1 sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill