How does it help with large dataset pagination?

The skill provides patterns for implementing cursor-based pagination, which avoids the severe performance degradation seen when using large OFFSET values in standard SQL.

Does it provide advice on when to use specific indexes?

Yes, it covers when to use B-Tree, Hash, GIN, GiST, and BRIN indexes, as well as the performance benefits of partial and expression-based indexes.

Can this skill help with ORM performance issues?

Yes, it specifically addresses common ORM pitfalls like the N+1 query problem and provides strategies for batch loading and efficient JOIN usage.

What database systems does this skill support?

While the core optimization patterns are universal to SQL, this skill provides specific, detailed examples for PostgreSQL and MySQL execution plans and index types.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: Microck

byMicrock

•

Database Management

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient data access patterns.

This skill provides Claude with expert-level knowledge in database performance tuning, enabling it to transform slow, inefficient SQL queries into high-performance operations. It covers critical concepts like EXPLAIN plan interpretation, strategic index creation (including B-Tree, GIN, and GiST), and the resolution of common anti-patterns such as N+1 queries and inefficient pagination. By using this skill, developers can reduce database load, improve application response times, and design schemas that scale effectively with growing datasets.

Key Features

01High-performance pagination using cursor-based techniques

02Optimization of batch operations, CTEs, and materialized views

03Advanced indexing strategies including composite, partial, and covering indexes

04Identification and resolution of N+1 query anti-patterns

05Expert interpretation of EXPLAIN and EXPLAIN ANALYZE query plans

0681 GitHub stars

Use Cases

01Refactoring legacy SQL code to improve resource utilization and reduce costs

02Debugging slow-running production database queries to reduce latency

03Designing performant schemas for applications handling large-scale datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microck/ordinary-claude-skills sql-optimization-patterns

For use in Claude.ai and ChatGPT

Download Skill