database-change-management

Safe schema changes add nullable columns with defaults, then backfill data in stages. This Skill applies reversible migration patterns—including down methods—to ensure zero-downtime deployments in Laravel applications using php artisan migrate commands.

Design migrations with both up and down methods to enable reversibility. This Skill validates every migration by executing migrate, rollback, and migrate again, plus composer test, ensuring your schema changes can be safely undone if needed.

Backfill strategies execute data updates in phases tied to your migration lifecycle. This Skill documents dependencies and relationships for schema changes, applying proven patterns that prevent data loss and maintain application availability during backfills.

Zero-downtime index creation uses Laravel migrations with concurrent index strategies. This Skill enforces validation loops to confirm indexes are created safely and migrations remain reversible without disrupting live traffic.

The mandatory validation loop in this Skill tests rollback by executing migrate:rollback after each migration, confirming your down method works. This ensures you can revert failed changes without data corruption or schema inconsistency.