Why should transactions avoid external API calls?

Holding a transaction open during an external network call keeps database locks active longer than necessary, which can lead to connection pool exhaustion and system-wide latency.

How does this skill help with N+1 queries?

It provides implementation patterns for eager loading related entities using ORM features like joinedload, preventing the performance hit of executing multiple queries inside loops.

What are forward-only migrations?

Forward-only migrations prioritize creating new migrations to undo changes rather than relying on rollbacks, ensuring better backward compatibility and safer deployment pipelines.

How does the skill handle query optimization?

The skill enforces a 'measure first' approach, using EXPLAIN ANALYZE to verify execution plans before suggesting composite or partial indexes based on actual data access patterns.

Database Patterns & Optimization

Name: Database Patterns & Optimization
Author: phrazzld

byphrazzld

•

データベース管理

Implements high-performance database migrations, query optimizations, and transaction management patterns for robust data layers.

概要

The Database Patterns skill provides a standardized framework for managing complex database operations within Claude Code. It focuses on production-grade best practices, including forward-only migrations for backward compatibility, N+1 query prevention through eager loading, and strict transaction scoping to minimize resource contention. By leveraging execution plan analysis and intelligent indexing strategies, this skill enables developers to build scalable data architectures while maintaining strict integrity through multi-boundary validation and immutable audit logging.

主な機能

Forward-only migration patterns to ensure zero-downtime schema changes.
Production-ready connection pooling and monitoring configurations.
N+1 query detection and prevention via eager loading techniques.
2 GitHub stars
Strict transaction scoping to prevent deadlocks and connection exhaustion.
Query optimization using EXPLAIN ANALYZE and strategic indexing.

ユースケース

Configuring resilient database connection pools for high-concurrency applications.
Designing and executing backward-compatible SQL migrations for production environments.
Refactoring inefficient ORM queries to improve application throughput and response times.

概要

主な機能

Forward-only migration patterns to ensure zero-downtime schema changes.
Production-ready connection pooling and monitoring configurations.
N+1 query detection and prevention via eager loading techniques.
2 GitHub stars
Strict transaction scoping to prevent deadlocks and connection exhaustion.
Query optimization using EXPLAIN ANALYZE and strategic indexing.

ユースケース

Configuring resilient database connection pools for high-concurrency applications.
Designing and executing backward-compatible SQL migrations for production environments.
Refactoring inefficient ORM queries to improve application throughput and response times.