Does it include migration safety tips?

Yes, it provides patterns for safe migrations, including adding indexes concurrently and using safety_assured blocks for column removals in high-traffic environments.

What are Query Objects in this context?

It introduces patterns for extracting complex query logic from models into dedicated, testable Query Objects to improve code maintainability and separation of concerns.

How does this skill help with N+1 queries?

It provides clear patterns for eager loading using includes, preload, and eager_load, along with guidance on when to use each specific loading strategy to minimize database hits.

Is this skill compatible with all databases?

While it covers general ActiveRecord patterns, it includes specific optimizations and syntax tailored for PostgreSQL, such as JSONB queries and GIN index handling.

ActiveRecord Patterns & Optimization

Name: ActiveRecord Patterns & Optimization
Author: Kaakati

byKaakati

•

データベース管理

Optimizes database interactions by providing enterprise-grade ActiveRecord query patterns, association designs, and PostgreSQL-specific performance strategies.

概要

ActiveRecord Query Patterns is a specialized skill for Ruby on Rails developers looking to build scalable, high-performance database layers. It offers a comprehensive library of best practices for model structuring, complex associations, and efficient querying while specifically addressing common PostgreSQL challenges. Whether you are debugging N+1 queries, implementing sophisticated scopes, or managing complex JSONB migrations, this skill provides the implementation patterns and quality gates necessary for enterprise-level Rails development and multi-agent orchestration.

主な機能

N+1 query detection and resolution strategies
Chainable scopes and Query Object implementation guides
Advanced association and model structure templates
PostgreSQL-optimized GROUP BY and JSONB query patterns
1 GitHub stars
Safe migration patterns for high-traffic production databases

ユースケース

Refactoring complex legacy queries for better performance and readability
Designing robust database schemas and associations for new enterprise features
Optimizing slow PostgreSQL operations using batch processing and strategic indexing

概要

主な機能

N+1 query detection and resolution strategies
Chainable scopes and Query Object implementation guides
Advanced association and model structure templates
PostgreSQL-optimized GROUP BY and JSONB query patterns
1 GitHub stars
Safe migration patterns for high-traffic production databases

ユースケース

Refactoring complex legacy queries for better performance and readability
Designing robust database schemas and associations for new enterprise features
Optimizing slow PostgreSQL operations using batch processing and strategic indexing