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

•

Database Management

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.

Key Features

01N+1 query detection and resolution strategies

02Chainable scopes and Query Object implementation guides

03Advanced association and model structure templates

04PostgreSQL-optimized GROUP BY and JSONB query patterns

051 GitHub stars

06Safe migration patterns for high-traffic production databases

Use Cases

01Refactoring complex legacy queries for better performance and readability

02Designing robust database schemas and associations for new enterprise features

03Optimizing slow PostgreSQL operations using batch processing and strategic indexing

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add kaakati/rails-enterprise-dev activerecord-patterns

For use in Claude.ai and ChatGPT

Download Skill