Menu
Create or modify an EF Core migration for PlaylistMiner database schema changes, with review and verification steps.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Debug why a PlaylistMiner video was categorized incorrectly or not categorized, by tracing through all 3 pipeline layers.
Implement a .NET feature using strict Red-Green-Refactor TDD with xUnit, FluentAssertions, and Moq for PlaylistMiner backend.
Implement a Next.js component or page using TDD with Jest, React Testing Library, and Playwright for PlaylistMiner frontend.
Debug why a video was categorized incorrectly or not categorized at all in PlaylistMiner.
Create or modify an Entity Framework Core migration for PlaylistMiner database schema changes.
Write a new feature using Red-Green-Refactor TDD with xUnit and FluentAssertions for PlaylistMiner .NET backend.
| name | ef-migration |
| description | Create or modify an EF Core migration for PlaylistMiner database schema changes, with review and verification steps. |
Create a new migration after modifying entities or DbContext.
Verify changes:
git diff src/PlaylistMiner.Core/Models/
git diff src/PlaylistMiner.Infrastructure/Data/
Create migration (use descriptive name like AddVideoStatusColumn, CreateSearchIndexes):
dotnet ef migrations add <Name> --project src/PlaylistMiner.Infrastructure --startup-project src/PlaylistMiner.Api
Review generated migration — check for data loss, verify indexes (especially pg_trgm GIN indexes)
Apply locally:
dotnet ef database update --project src/PlaylistMiner.Infrastructure --startup-project src/PlaylistMiner.Api
Run integration tests to verify schema:
dotnet test tests/PlaylistMiner.IntegrationTests
dotnet ef migrations remove # Remove last unapplied
dotnet ef database update <PreviousMigration> # Rollback applied