Create safe, reversible Rails database migrations with zero-downtime patterns.
npx skills add https://github.com/pelletencate/iron-horse --skill migrations-pelletencate
Please help me install this Agent Skill. Skill: migrations Source: https://github.com/pelletencate/iron-horse/tree/main/skills/migrations Command: npx skills add https://github.com/pelletencate/iron-horse --skill migrations-pelletencate
Migrations can cause downtime or data integrity issues in production. This skill provides guidance and patterns to create safe, reversible Rails migrations with zero-downtime strategies and strong_migrations checks.
Follow the guide to implement a safe, reversible migration in your Rails app.
High-intent search queries and answers about installing and using this skill.
Zero-downtime database migrations in Rails require concurrency-friendly indexing, two-step NOT NULL constraints, and staged data backfills to minimize locking during production deploys. This approach ensures non-blocking schema changes and graceful data backfills.
Separating schema and data migrations in Rails involves isolating structural changes from data transformations, applying batching and safety checks to the latter. This prevents long-running locks and maintains data integrity during production updates.
Reversible Rails migrations are ensured by using the change method when possible, or providing explicit up and down paths with rollback guidance. This guarantees that schema changes can be safely undone if production deployment fails.
Yes, strong_migrations enforces safe indexing with concurrency checks to prevent locking issues when adding indexes. It detects risky operations and guides you toward concurrency-friendly patterns required for zero-downtime changes.
Adding NOT NULL constraints causes downtime because the database acquires a long-running lock to validate existing rows. Using a two-step constraint pattern backfills data first, then enforces the constraint safely without blocking production traffic.
mlbrightCreate safe, reversible Rails database migrations with strong_migrations validation.
somachakPlan reversible database migrations with backfill and rollback steps.
EIS-ITSDefine database models and ORM entities with relationships and constraints.
Rune-kitGenerate and validate database schema migrations for ORMs and raw SQL.
