migration-agent

Generate reversible Rails migrations with zero-downtime schema change strategies.

Updated Nov 1, 2025

Search Tags:#database #postgresql #migrations #schema #best-practices #rails #reversible

Ready to run

npx skills add https://github.com/nschneble/rails-superstack --skill migration-agent-nschneble

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: migration-agent
Source: https://github.com/nschneble/rails-superstack/tree/main/.agents/skills/migration-agent
Command: npx skills add https://github.com/nschneble/rails-superstack --skill migration-agent-nschneble

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Rails teams often need to create safe, reversible migrations that preserve data integrity while changing schema. This Skill provides best practices for generating migrations with proper indexes, constraints, and zero-downtime strategies.

Core Features & Use Cases

Safe, reversible migrations with up/down support and transactional guarantees.
Zero-downtime strategies for adding columns and creating indexes.
Guidance on constraints, indexes, checks, and foreign keys for production safety.

Quick Start

Create a safe, reversible migration to add a new users table with an index on email.

Frequently Asked Questions about migration-agent

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I create reversible Rails migrations that are safe for production?▼

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.

What is a zero-downtime database migration in PostgreSQL?▼

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.

How do I add a database index safely in a Rails migration?▼

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.

Can I use this to generate Rails migrations for PostgreSQL specifically?▼

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.

What's the best way to structure Rails schema changes with foreign keys?▼

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.

How do I test Rails migrations before deploying to production?▼

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.