Generate safe, reversible Active Record database migrations in Ruby on Rails.
npx skills add https://github.com/ThinkOodle/rails-skills --skill migrations-thinkoodle
Please help me install this Agent Skill. Skill: migrations Source: https://github.com/ThinkOodle/rails-skills/tree/main/skills/migrations Command: npx skills add https://github.com/ThinkOodle/rails-skills --skill migrations-thinkoodle
This Skill provides expert guidance for creating database schema changes in Rails applications that are safe, reversible, and maintainable, preventing common production issues.
change or up/down methods.status column to your posts table, ensuring it has a default value and can be safely rolled back if necessary.Generate a new migration to add a status column to the posts table with a default value of 'draft'.
High-intent search queries and answers about installing and using this skill.
Write reversible Rails migrations using the `change` method or defining explicit `up` and `down` methods to ensure schema modifications can be safely rolled back. This approach handles column additions, removals, and indexing automatically.
Handle large data migrations in Ruby on Rails by separating them into dedicated tasks rather than inline schema changes. This prevents locking issues and keeps your Active Record schema migrations fast and safe.
Avoid referencing Active Record models inside migrations because model classes can change or be deleted over time, causing migrations to fail. Instead, use raw SQL queries or define migration-specific classes to maintain stability.
Editing committed database migrations in a Rails application creates inconsistencies between environments because the schema changes have already been executed. Always create new forward-only migrations to alter existing schema states safely.
Safely add a database column with a default value in Rails by generating a new migration and specifying the default parameter. This ensures existing records update correctly and the schema change remains reversible.
praburajasekaranCompare schema.rb changes against migrations to detect unrelated modifications in pull requests.
enbyaugustAutomate staged Supabase database migrations with pgTAP tests and approvals.
JuanMS20Analyze SQL database migration scripts for safety and rollback strategies.
4lermanGenerate SQL queries, introspect schemas, optimize performance, and create migration scripts.