What advanced scaling techniques are included?

The skill includes guidance on advanced techniques such as table partitioning, materialized views, and using cursor-based pagination for large datasets.

Which database systems are supported by this skill?

While the core optimization concepts are universal, the skill provides specific implementation patterns and syntax for PostgreSQL and MySQL.

How does it help identify the cause of a slow query?

It provides a framework for analyzing EXPLAIN and EXPLAIN ANALYZE output to identify sequential scans, high-cost nodes, and inefficient join methods.

Can this skill help with ORM performance issues?

Yes, it provides specific patterns for identifying and resolving the N+1 query problem often introduced by ORMs through batch loading and JOIN strategies.

Does it provide advice on index maintenance?

Yes, it covers best practices for indexing selectively to avoid write-performance degradation and includes maintenance commands like VACUUM and ANALYZE.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: amurata

byamurata

•

数据库管理

Optimizes database performance through systematic query analysis, advanced indexing strategies, and execution plan debugging.

The SQL Optimization Patterns skill empowers Claude to transform sluggish database queries into high-performance operations by applying industry-standard optimization techniques. It provides comprehensive guidance on interpreting execution plans (EXPLAIN), implementing sophisticated indexing strategies—including composite, partial, and covering indexes—and resolving common bottlenecks like the N+1 query problem. Whether you are debugging slow production queries or designing a schema for a high-traffic application, this skill provides the patterns needed to reduce latency, scale datasets, and minimize database infrastructure costs.

主要功能

01High-performance pagination and cursor-based strategy implementation

023 GitHub stars

03Deep EXPLAIN plan analysis and performance metric interpretation

04Systematic elimination of N+1 query anti-patterns and join optimization

05Batch operation patterns and materialized view management

06Advanced indexing strategies including B-Tree, GIN, and Partial indexes

使用场景

01Designing performant schemas for data-heavy applications

02Debugging and fixing slow-running production database queries

03Reducing cloud database costs by optimizing query efficiency and load

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add amurata/cc-tools sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill