How does this help with N+1 query problems?

It provides specific refactoring patterns using JOINs and batch loading to replace multiple database roundtrips with single, efficient operations.

What databases does this skill support?

While many examples focus on PostgreSQL, the core optimization concepts and patterns apply to most relational databases including MySQL, SQLite, and SQL Server.

Can it help with large-scale data migration?

Yes, it includes batch operation patterns and COPY command strategies to handle large volumes of data efficiently without locking tables.

Does this skill cover advanced features like partitioning?

Yes, it provides guidance on range partitioning and materialized views to handle very large datasets that outgrow standard table structures.

SQL Optimization Patterns

Name: SQL Optimization Patterns
Author: amurata

byamurata

•

データベース管理

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

This skill empowers Claude to act as a database performance engineer, identifying and resolving bottlenecks in SQL-based applications. It provides comprehensive patterns for analyzing execution plans, implementing efficient indexing strategies like composite and partial indexes, and refactoring slow queries to eliminate anti-patterns such as N+1 issues and inefficient offsets. Whether you are designing a high-scale schema or debugging a slow production query, these patterns provide the systematic guidance needed to reduce database load, minimize costs, and significantly improve application response times.

主な機能

01Execution plan analysis (EXPLAIN/ANALYZE) for deep bottleneck identification

02Batch operation techniques to optimize bulk inserts and updates

033 GitHub stars

04Comprehensive indexing strategies including B-Tree, GIN, and partial indexes

05Query refactoring patterns to eliminate N+1 problems and slow offsets

06Advanced database features like Materialized Views and Table Partitioning

ユースケース

01Accelerating slow-running reports and complex analytical queries

02Refactoring application code to prevent database connection exhaustion

03Designing scalable database schemas for high-traffic applications

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