data-migration

Automate EF Core, MongoDB, and SQL data migrations with rollback planning.

7|1|Updated Jun 17, 2021
One-click install
npx skills add https://github.com/duc01226/EasyPlatform --skill data-migration
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-migration
Source: https://github.com/duc01226/EasyPlatform/tree/main/.claude/skills/backend-data-migration
Command: npx skills add https://github.com/duc01226/EasyPlatform --skill data-migration

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps design EF migrations or data migrations for SQL, PostgreSQL, or MongoDB.

Core Features & Use Cases

  • EF Core migrations
  • Data backfills and transformation scripts
  • Migration risk and rollback planning

Quick Start

Create a migration for adding a new field in the User table.

Frequently Asked Questions about data-migration

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

FAQPage Schema
How do I create and execute data migrations for SQL Server or PostgreSQL databases?

Data migrations automate schema changes and data transformations using EF Core. Create migration files with your desired changes, then execute them through PlatformDataMigrationExecutor<TDbContext> to apply updates, backfills, or format conversions across your database.

Can I use data migrations with MongoDB?

Yes. MongoDB migrations are executed through PlatformMongoMigrationExecutor<TDbContext>, enabling schema changes, data transformation, and cross-database synchronization for MongoDB alongside SQL and PostgreSQL platforms.

What's the best way to plan and execute a data backfill or transformation?

Design your migration with clear schema and data transformation logic, then use the appropriate executor—PlatformDataMigrationExecutor for SQL/PostgreSQL or PlatformMongoMigrationExecutor for MongoDB—following the provided file structure and code patterns to apply changes safely.

How do I handle rollback and mitigate risk when running migrations?

Plan rollback strategies during migration design by documenting reversible steps and dependencies. The Skill covers migration risk assessment and rollback planning to help you prepare contingency paths before executing changes.

Does EF Core support migrations across multiple database platforms?

EF Core migrations work with SQL Server and PostgreSQL. For cross-database synchronization or mixed-platform scenarios, combine EF Core migrations with PlatformDataMigrationExecutor and PlatformMongoMigrationExecutor to handle SQL, PostgreSQL, and MongoDB in the same workflow.

What file structure and code patterns should I follow for migrations?

The Skill provides guidance on file organization, code patterns, and example commands for setting up EF Core, MongoDB, and SQL/PostgreSQL migrations consistently. Follow these patterns to maintain clarity and reduce execution errors across your migration suite.