Is it suitable for initial database schema design?

Yes, it provides best practices for choosing data types and index strategies during the design phase to ensure long-term scalability and prevent performance debt.

Does it support databases other than PostgreSQL?

While many examples use PostgreSQL syntax, the core optimization concepts and patterns are applicable to MySQL, MariaDB, and other SQL-based relational systems.

Does this cover advanced features like partitioning and materialized views?

Absolutely, the skill includes guidance on range partitioning, materialized views, and batch processing for handling extremely large datasets.

Can it help with N+1 query problems?

Yes, it includes specific patterns for identifying N+1 issues and replacing them with efficient JOINs or batch loading techniques to minimize database round-trips.

How does this skill help with slow database queries?

It provides patterns for analyzing execution plans with EXPLAIN and suggests specific indexing or refactoring strategies to eliminate bottlenecks like sequential scans.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: HermeticOrmus

byHermeticOrmus

0•

数据库管理

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

This skill empowers developers to transform sluggish database queries into high-performance operations by applying systematic optimization techniques. It provides deep guidance on interpreting EXPLAIN plans, selecting the correct index types (such as B-Tree, GIN, and BRIN), and refactoring common anti-patterns like N+1 queries and inefficient OFFSET pagination. Whether you are designing a new schema or troubleshooting a production bottleneck, this skill offers the implementation patterns and best practices needed to scale database-driven applications effectively while reducing infrastructure costs.

主要功能

01Systematic patterns for eliminating N+1 query anti-patterns

020 GitHub stars

03Advanced batch operation patterns for large-scale data updates

04High-performance cursor-based pagination strategies

05Deep EXPLAIN and EXPLAIN ANALYZE query plan interpretation

06Implementation of specialized index types including GIN, GiST, and BRIN

使用场景

01Identifying and fixing performance bottlenecks in slow-running production queries

02Designing scalable database schemas for applications with high data volume

03Refactoring legacy SQL queries to reduce database server load and cloud costs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/hermetic-line sql-optimization-patterns

For use in Claude.ai and ChatGPT

主要功能

01Systematic patterns for eliminating N+1 query anti-patterns

020 GitHub stars

03Advanced batch operation patterns for large-scale data updates

04High-performance cursor-based pagination strategies

05Deep EXPLAIN and EXPLAIN ANALYZE query plan interpretation

06Implementation of specialized index types including GIN, GiST, and BRIN

使用场景

01Identifying and fixing performance bottlenecks in slow-running production queries

02Designing scalable database schemas for applications with high data volume

03Refactoring legacy SQL queries to reduce database server load and cloud costs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/hermetic-line sql-optimization-patterns

For use in Claude.ai and ChatGPT