AgentSkillsCN

migrate

创建或应用 EF Core 数据库迁移

SKILL.md
--- frontmatter
name: migrate
description: Create or apply EF Core database migrations
disable-model-invocation: true
allowed-tools: Bash(cd * && dotnet *), Bash(dotnet *)
argument-hint: "<migration-name>"

Database Migration

Create or manage EF Core migrations for PostgreSQL.

Usage

  • •/migrate AddNewColumn — Create a new migration named AddNewColumn
  • •/migrate apply — Apply pending migrations
  • •/migrate status — Show migration status
  • •/migrate remove — Remove the last unapplied migration

Commands

Create Migration

bash
cd backend && dotnet ef migrations add $ARGUMENTS \
  --project src/Mithya.Infrastructure \
  --startup-project src/Mithya.Api

Apply Migrations

bash
cd backend && dotnet ef database update \
  --project src/Mithya.Infrastructure \
  --startup-project src/Mithya.Api

Check Status

bash
cd backend && dotnet ef migrations list \
  --project src/Mithya.Infrastructure \
  --startup-project src/Mithya.Api

Remove Last Migration

bash
cd backend && dotnet ef migrations remove \
  --project src/Mithya.Infrastructure \
  --startup-project src/Mithya.Api

Migration Naming Convention

Use PascalCase describing the change:

  • •AddServiceProxyTable
  • •AddFallbackEnabledToServiceProxy
  • •RemoveProxyConfigTable
  • •AddIndexOnLogsTimestamp

Notes

  • •App auto-migrates on startup (Program.cs calls db.Database.Migrate())
  • •Migrations are at backend/src/Mithya.Infrastructure/Data/Migrations/
  • •Entity configurations are at backend/src/Mithya.Infrastructure/Data/Configurations/
  • •Always create the EF Configuration class (IEntityTypeConfiguration<T>) before running migration
  • •After creating migration, review the generated file to verify correctness