Can this skill help with ORM-related performance issues?

Yes, it specifically addresses common ORM problems like the N+1 query anti-pattern and provides strategies to refactor them into efficient JOINs or batch loads.

Does this skill help with managing very large datasets?

Absolutely. It includes advanced techniques like table partitioning, materialized views, and BRIN indexes specifically designed for handling and querying massive data volumes.

How does it help with debugging slow queries?

It guides you through interpreting EXPLAIN and EXPLAIN ANALYZE output to identify sequential scans, high-cost nodes, and join bottlenecks within your query execution plans.

What database systems does this skill support?

While many patterns are universal to SQL, this skill provides specific implementation examples for PostgreSQL and MySQL, covering engine-specific query hints and specialized index types.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: HermeticOrmus

byHermeticOrmus

0•

데이터베이스 관리

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

This skill provides a comprehensive toolkit for identifying and resolving database performance bottlenecks by mastering SQL execution plans, indexing strategies, and query optimization patterns. It enables developers to transform slow-running queries into efficient operations using techniques like cursor-based pagination, materialized views, and partition management. Whether you are debugging N+1 query problems in an ORM or designing a scalable schema for large datasets, this skill offers the specific implementation patterns and best practices needed to minimize database load and dramatically improve application response times.

주요 기능

01Deep analysis of SQL execution plans using EXPLAIN and EXPLAIN ANALYZE

02Optimization of complex JOINs, subqueries, and aggregation operations

030 GitHub stars

04Resolution of common performance anti-patterns like N+1 queries and OFFSET pagination

05Implementation of advanced indexing including B-Tree, GIN, Partial, and Covering indexes

06Advanced data scaling techniques including table partitioning and materialized views

사용 사례

01Refactoring slow legacy queries to reduce database CPU and memory consumption

02Designing high-performance database schemas for applications with rapidly growing datasets

03Optimizing batch data operations and bulk inserts to improve system throughput

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/floraheritage sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill