What is the SQL Optimization Patterns skill?

It is a specialized capability for Claude Code that provides expert guidance on making SQL queries faster and more efficient through systematic analysis and proven coding patterns.

Which databases does this skill support?

While most optimization patterns are universal, the skill provides specific syntax and detailed strategies for PostgreSQL and MySQL.

How do I use this skill to debug a slow query?

Simply provide the slow-running query or its EXPLAIN output to Claude, and this skill will guide the AI to provide a step-by-step optimization plan.

Does it cover advanced features like partitioning?

Yes, the skill includes documentation and implementation patterns for advanced techniques such as table partitioning, materialized views, and specialized index types like BRIN and GIN.

Can it help with N+1 query problems?

Yes, it offers specific architectural solutions and SQL join patterns to identify and resolve N+1 query anti-patterns in application code.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: HermeticOrmus

byHermeticOrmus

0•

Database Management

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient SQL patterns.

The SQL Optimization Patterns skill equips developers with the expert knowledge required to transform slow database queries into high-performance operations. It provides systematic guidance on interpreting EXPLAIN query plans, selecting the right index types for specific workloads, and applying proven patterns to resolve common bottlenecks like the N+1 query problem and inefficient pagination. By integrating these practices, developers can significantly reduce database load, lower infrastructure costs, and ensure application scalability even as datasets grow.

Key Features

01Guidance on materialized views and horizontal table partitioning

02Patterns for eliminating N+1 query performance bottlenecks

030 GitHub stars

04Implementation of advanced indexing including Partial, GIN, and Covering indexes

05Deep analysis of EXPLAIN and EXPLAIN ANALYZE query plans

06Optimized cursor-based pagination and batch operation strategies

Use Cases

01Reducing database resource consumption and infrastructure costs

02Debugging and accelerating slow-running production database queries

03Designing performant database schemas for data-intensive applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/after-the-third-cup sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill