What databases does this skill support?

While many patterns are universal to SQL, it provides specific optimization techniques and syntax for PostgreSQL and MySQL, including detailed EXPLAIN plan analysis.

Does this skill cover advanced indexing?

Absolutely. It covers standard B-Tree indexes as well as specialized types like GIN, GiST, and BRIN, along with functional, partial, and covering index strategies.

Can I use it for database schema design?

Yes, the skill includes patterns for table partitioning and materialized views to help you design performant and scalable schemas from the beginning.

Does it explain how to interpret query costs?

Yes, it provides a breakdown of key metrics in execution plans such as Seq Scans, Index Scans, and estimated vs. actual row counts to help identify bottlenecks.

Can it help with the N+1 query problem?

Yes, it identifies N+1 anti-patterns and provides refactoring strategies using JOINs, window functions, or batch loading to minimize database round trips.

SQL Performance Optimizer

Name: SQL Performance Optimizer
Author: Microck

byMicrock

•

Gestión de Bases de Datos

Optimizes SQL queries and database schemas using advanced indexing strategies and execution plan analysis.

This skill empowers Claude to transform slow database operations into high-performance queries by applying systematic optimization patterns. It provides expert guidance on interpreting EXPLAIN plans, implementing complex indexing strategies—including composite, partial, and covering indexes—and resolving common bottlenecks like N+1 queries and inefficient pagination. Whether you are designing a new schema from scratch or debugging legacy production queries, this skill helps reduce latency, lower infrastructure costs, and ensure your application scales effectively as data grows.

Características Principales

01Advanced EXPLAIN and EXPLAIN ANALYZE output interpretation

02Implementation of diverse indexing strategies (B-Tree, GIN, GiST, BRIN)

03Optimized pagination techniques using cursor-based logic instead of OFFSET

0489 GitHub stars

05Query refactoring to eliminate N+1 anti-patterns and Cartesian products

06Advanced schema optimization using Materialized Views and Table Partitioning

Casos de Uso

01Designing high-performance database schemas for scalable applications

02Debugging and fixing slow-running production database queries

03Reducing database CPU load and cloud costs through query efficiency

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill