Can it handle different database types?

While many examples focus on PostgreSQL, the core concepts of indexing, query planning, and join optimization are applicable across most major relational databases like MySQL and SQL Server.

How does this skill help with slow SQL queries?

It provides systematic patterns for analyzing EXPLAIN plans, identifying bottlenecks, and suggesting specific indexing or query refactoring strategies to improve execution speed.

Is this useful for schema design?

Absolutely; it provides best practices for choosing data types and index strategies during the initial design phase to ensure long-term scalability.

Does it help with N+1 query problems?

Yes, it includes specific implementation patterns for transforming N+1 query loops into efficient batch loads or JOIN-based operations.

What advanced database features are covered?

It covers advanced topics such as materialized views, table partitioning, GIN/GiST indexes for JSONB and full-text search, and cursor-based pagination.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: HermeticOrmus

byHermeticOrmus

0•

Database Management

Optimizes SQL queries and database schemas using advanced indexing, EXPLAIN analysis, and performance-tuning patterns.

This skill empowers Claude to act as a database performance expert, providing systematic guidance on transforming slow database operations into high-performance queries. It covers critical concepts like interpreting EXPLAIN plans, implementing sophisticated indexing strategies (including composite, partial, and covering indexes), and resolving common anti-patterns such as N+1 queries and inefficient pagination. Whether you are designing a new schema or debugging a production performance bottleneck, this skill provides the implementation patterns needed to reduce database load, minimize costs, and improve application scalability.

Key Features

01Scaling strategies through partitioning and materialized views

02High-performance pagination techniques using cursor-based logic

03Advanced indexing strategies including B-Tree, GIN, and BRIN

04Deep EXPLAIN and EXPLAIN ANALYZE plan interpretation

05Refactoring patterns for N+1 queries and complex subqueries

060 GitHub stars

Use Cases

01Optimizing application response times by reducing database latency

02Designing performant database schemas for high-traffic applications

03Refactoring slow-running production queries identified in database logs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/alqvimia-contador sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill