How does this skill improve slow SQL queries?

It provides systematic patterns for analyzing execution plans with EXPLAIN ANALYZE and suggests specific indexing or refactoring strategies to reduce query cost and execution time.

What database systems are supported?

While many examples are tailored for PostgreSQL, the core concepts of indexing, execution plans, and query refactoring apply to MySQL, MariaDB, and other relational databases.

Does it provide guidance on large-scale data management?

Yes, it covers advanced techniques such as table partitioning and materialized views which are essential for maintaining performance with very large datasets.

How do I use this skill for schema design?

The skill provides best practices for data types, normalization, and proactive index placement to ensure your database is performant from the start.

Can it help resolve N+1 query issues?

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

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: yusoofsh

byyusoofsh

0•

Gestión de Bases de Datos

Optimizes database performance through advanced indexing, EXPLAIN plan analysis, and efficient query implementation patterns.

SQL Optimization Patterns provides a comprehensive framework for transforming sluggish database operations into high-performance queries. This skill guides developers through systematic optimization techniques, including the interpretation of complex EXPLAIN plans, the application of specialized index types like GIN and BRIN, and the resolution of common performance bottlenecks such as the N+1 query problem. It is an essential tool for developers looking to reduce database load, lower infrastructure costs, and ensure application scalability by applying industry-standard best practices to their data access layers.

Características Principales

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

02Comprehensive indexing strategies including composite, partial, and covering indexes

030 GitHub stars

04Advanced performance features including materialized views and table partitioning

05Patterns for eliminating N+1 query anti-patterns through JOINs and batch loading

06Expert analysis of EXPLAIN and EXPLAIN ANALYZE query execution plans

Casos de Uso

01Designing performant database schemas for data-intensive applications

02Identifying and fixing performance bottlenecks in production database queries

03Optimizing backend API response times by reducing database latency

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add yusoofsh/dotfiles sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill