rails-migration-review

To review Rails database migrations for production safety, this Skill analyzes migration files to flag potential table locking, data loss, and reversibility issues before merging. It checks for lock safety, data backfills, and index coverage.

Common unsafe Rails migration patterns include adding non-nullable columns without a default strategy and failing to ensure reversibility. This Skill detects these risks by enforcing best practices around NOT NULL constraints, foreign keys, and default values.

Yes, this migration review supports strong_migrations gem rules. It enforces adherence to common Rails database migration guidelines and gem usage, specifically analyzing your migrations against strong_migrations configurations.

To check if a Rails migration will lock a large database table, submit your migration file for analysis. The Skill audits for lock safety, concurrent index creation, and potential table locking issues to prevent production incidents.

The best way to ensure Rails database migration reversibility is to audit the migration file before merging. This Skill analyzes for reversibility issues, verifying that up and down methods are properly structured to prevent data loss.

You need to use concurrent index creation in Rails migrations when adding indexes to large tables to avoid locking. This Skill analyzes your migration to ensure concurrent index creation is used appropriately and adheres to safety best practices.