migration-agent

Reversible Rails migrations ensure schema changes like adding columns or creating indexes have full up and down support. This Skill automates safe migration generation with transactional guarantees, proper constraints, and zero-downtime strategies to preserve data integrity in production.

A zero-downtime database migration applies schema changes without locking the database or interrupting active traffic. This Skill generates Rails migrations using strategies that safely add columns and create indexes concurrently on PostgreSQL.

To add a database index safely in a Rails migration, you need a zero-downtime strategy that prevents table locks. This Skill automates creating reversible migrations with proper indexes, constraints, and checks for production safety.

Yes, you can generate Rails migrations tailored for PostgreSQL. This Skill provides best practices for schema changes, ensuring migrations include proper foreign keys, constraints, and reversible syntax specific to your database setup.

The best way to structure Rails schema changes with foreign keys is to use reversible migrations with explicit constraints. This Skill automates adding foreign keys and checks using zero-downtime strategies to ensure production safety.

To test Rails migrations before production, you must verify both up and down paths execute cleanly and preserve data. This Skill generates fully reversible migrations with transactional guarantees, ensuring schema changes are tested and production-safe.