cck-migration-workflow

What problem does it solve?

This Skill provides a safe, repeatable workflow to create, review, apply, and roll back EF Core database migrations, update NuGet dependencies, and upgrade .NET versions without causing data loss or production downtime.

Core Features & Use Cases

• Migration safety: Generate and review SQL scripts, detect data-loss operations, and apply staged schema changes to preserve data.
• Rollback & verification: Define rollback plans, run full unit and integration tests after changes, and remove failed migrations from code if necessary.
• Incremental dependency and framework upgrades: Audit packages, update incrementally by semantic version category, and migrate target frameworks with centralized configuration and checklist guidance.
• Use Case: Prepare and apply a schema change plus a package upgrade in a service migrating to .NET 10 while ensuring automatic verification and a clear rollback path.

Quick Start

Create a descriptive EF Core migration, generate and review the SQL script for potential data loss, and prepare a rollback plan before applying the migration and running the full test suite.