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

•

Database Management

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.

Key Features

01Forward-only migration patterns to ensure zero-downtime schema changes.

02Production-ready connection pooling and monitoring configurations.

03N+1 query detection and prevention via eager loading techniques.

042 GitHub stars

05Strict transaction scoping to prevent deadlocks and connection exhaustion.

06Query optimization using EXPLAIN ANALYZE and strategic indexing.

Use Cases

01Configuring resilient database connection pools for high-concurrency applications.

02Designing and executing backward-compatible SQL migrations for production environments.

03Refactoring inefficient ORM queries to improve application throughput and response times.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add phrazzld/claude-config database-patterns

For use in Claude.ai and ChatGPT

Download Skill