Generates reversible PostgreSQL migrations for Rails ActiveRecord applications.
npx skills add https://github.com/mlbright/notes --skill migration-agent-mlbright
Please help me install this Agent Skill. Skill: migration-agent Source: https://github.com/mlbright/notes/tree/main/.github/skills/migration-agent Command: npx skills add https://github.com/mlbright/notes --skill migration-agent-mlbright
This Skill ensures that database schema changes in Rails applications are performed safely, reversibly, and with production performance in mind, preventing downtime and data loss.
email column to a users table with millions of records, this Skill will generate a migration that adds the column concurrently and safely, ensuring the application remains available throughout the process.Generate a new migration to add a status column of type string to the orders table.
High-intent search queries and answers about installing and using this skill.
To add a column without locking a large PostgreSQL table, you need safe Rails migrations that use concurrent indexes and multi-step updates for zero-downtime deployments. This approach prevents table locks and keeps your application available during schema changes on massive datasets.
A reversible Rails migration allows schema changes to be safely rolled back, preventing data loss and downtime in production. It is needed because production databases require zero-downtime strategies and guaranteed rollback paths if a deployment introduces data integrity issues.
You generate zero-downtime ActiveRecord migrations by applying PostgreSQL-specific strategies like concurrent index creation and multi-step column updates. This ensures complex schema modifications and data integrity constraints are applied without locking tables or disrupting large datasets.
Yes, you can use this approach for complex data integrity constraints on large datasets. The generated migrations handle schema modifications and enforce constraints using production-optimized strategies that maintain zero-downtime and prevent locking issues on massive PostgreSQL tables.
The best way to handle schema modifications without causing downtime is using production-optimized Rails migrations. They implement concurrent indexes and multi-step column updates, ensuring zero-downtime deployments and preventing table locks when modifying large PostgreSQL datasets.
reckerswartzGenerate reversible Rails database migrations for PostgreSQL schema changes.
layeddiePlan and execute zero-downtime Elixir/Phoenix database migrations with reversible rollbacks.
lekemulaAnalyzes ActiveRecord queries for performance issues and suggests optimizations.
sandeepmvlMigrate Ruby on Rails applications from MySQL to PostgreSQL with pgloader and zero-downtime cutover.