Does it provide advice on safe database migrations?

Yes, it includes patterns for concurrent indexing and multi-step column removal to ensure migrations don't lock tables or cause downtime in production.

Does this skill support older versions of Ruby on Rails?

The patterns are optimized for Rails 7+, but many of the core ActiveRecord concepts and optimization techniques are backward compatible with Rails 6.x and 5.x.

Does it cover complex SQL needs?

Yes, it includes guidance on using Arel for complex query building that exceeds the standard ActiveRecord interface.

How does this help with N+1 query problems?

It provides clear code examples and logic for when to use includes, preload, or eager_load to ensure your application fetches data efficiently in a single trip to the database.

Can it help me move logic out of ActiveRecord callbacks?

Absolutely. It promotes the use of service objects and explicit transaction management to keep your models lean and your business logic maintainable.

Rails ActiveRecord Optimization Patterns

Name: Rails ActiveRecord Optimization Patterns
Author: betamatt

bybetamatt

0•

Database Management

Optimizes Ruby on Rails database interactions with production-grade ActiveRecord patterns and performance best practices.

This skill provides expert guidance for Rails 7+ developers to write efficient, scalable, and safe database queries. It covers critical areas such as solving N+1 query problems through eager loading, implementing safe zero-downtime migrations, managing complex associations, and utilizing performance-oriented features like counter caches and batch processing. It is an essential resource for refactoring legacy code for performance or designing new database schemas intended for high-traffic production environments.

Key Features

01Guidance on safe callback patterns and robust transaction management

02Production-safe migration patterns for zero-downtime deployments

03Advanced association management including counter caches and polymorphic links

04Efficient batch processing techniques for large dataset manipulation

05Comprehensive N+1 query detection and resolution strategies

060 GitHub stars

Use Cases

01Implementing complex database queries using Arel and composable scopes

02Diagnosing and fixing performance bottlenecks in existing Rails applications

03Refactoring business logic from model callbacks into explicit service objects

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add betamatt/claude-plugins activerecord-patterns

For use in Claude.ai and ChatGPT

Download Skill