How does this skill help with slow queries?

It guides you through analyzing execution plans (EXPLAIN) to identify bottlenecks and suggests specific indexing or query restructuring patterns to fix them.

Does it support multiple database engines?

Yes, while focusing heavily on PostgreSQL, it covers universal SQL optimization concepts applicable to MySQL, MariaDB, and other relational databases.

Can it help with ORM performance issues?

Absolutely; it provides patterns to solve common ORM problems like the N+1 query anti-pattern and inefficient offset-based pagination.

What indexing strategies are included?

It covers B-Tree, GIN, GiST, BRIN, composite indexes, partial indexes, and covering indexes to ensure the most efficient data retrieval.

Is it suitable for large-scale data?

Yes, it includes advanced techniques like table partitioning and materialized views specifically designed for managing and querying large datasets efficiently.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: nguyendinhquocx

bynguyendinhquocx

0•

Database Management

Optimizes database performance through systematic query analysis, advanced indexing strategies, and efficient execution patterns.

This Claude Code skill empowers developers to transform slow-running database operations into high-performance queries by applying industry-standard optimization techniques. It provides expert guidance on interpreting EXPLAIN plans, selecting the correct index types (B-Tree, GIN, BRIN), resolving N+1 query bottlenecks, and implementing advanced features like materialized views and table partitioning. Whether you are debugging production performance issues or designing scalable database schemas from scratch, this skill offers the specific patterns and best practices needed to minimize database load and improve application response times.

Key Features

01Deep analysis of EXPLAIN and EXPLAIN ANALYZE query plans

02Implementation of advanced indexing including Composite, Partial, GIN, and Covering indexes

03Standardized patterns for resolving N+1 query anti-patterns

04Cursor-based pagination strategies for high-performance data retrieval

05Optimization of complex JOINs, subqueries, and aggregate operations

060 GitHub stars

Use Cases

01Debugging and fixing slow-running production database queries

02Designing high-performance database schemas for new applications

03Scaling existing databases using partitioning and materialized views

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nguyendinhquocx/code-ai sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill