migration-workflow

What problem does it solve?

This Skill provides a consistent, safety-first process for applying EF Core database migrations, updating NuGet dependencies, and upgrading .NET versions to minimize data loss, downtime, and regressions.

Core Features & Use Cases

• Review before apply: Emphasizes generating and auditing idempotent SQL scripts and checking for data-loss or long-lock operations before applying migrations.
• Rollback planning: Documents explicit rollback steps for migrations, package updates, and framework upgrades so teams can recover quickly from failures.
• Incremental updates & verification: Encourages one-change-per-migration, one-package-at-a-time updates, and build-and-test validation including integration tests to catch real-world issues.
• .NET upgrade checklist: Guides updating global.json, target frameworks, package compatibility, and adopting new runtime features with a phased verification strategy.
• Use Case: Safely add a new nullable-to-non-nullable column by creating a migration that adds a nullable column, backfills data, then flips the column and removes the old one while preserving rollback and test steps.

Quick Start

Create an EF Core migration named AddOrderShippingAddress, generate the idempotent SQL script for review, run the full test suite including integration tests, and produce a clear rollback plan.