Agent skill · software engineering · github
scaffolding-oracle-to-postgres-migration-test-project
Scaffolds an xUnit integration test project targeting Oracle in .NET solutions. Creates the test project, transaction-rollback base class, and seed data manager. Use only during Phase 3, before writing Oracle baseline integration tests. Do not invoke during Phase 6 — the PostgreSQL test project is produced by migrating this project, not by running this skill again.
Why this skill is useful
Adds a complete scaffolding script for creating an xUnit test project tailored for Oracle-to-PostgreSQL migrations, which includes transaction management and seed data infrastructure.
What it needs
Requires dotnet, nuget installed locally. About 2k tokens when loaded. Last updated 2026-08-07. 37,534 stars on the source repository.
What this skill does
Scaffolding an Integration Test Project for Oracle-to-PostgreSQL Migration Creates a compilable, empty xUnit test project with transaction management and seed data infrastructure for a single target project. Run once per project before writing tests. Workflow Step 1: Inspect the target project Read the target project's .csproj to determine the .NET version and existing package references. Match these versions exactly — do not upgrade. Step 2: Create the xUnit test project Target the same .NET version as the application under test. Add NuGet packages for Oracle database connectivity (Oracle.ManagedDataAccess.Core) and xUnit. Add a project reference to the target project only — no other application projects. Add an appsettings.json configured for Oracle database connectivity. Step 3: Implement transaction-rollback base class Create a base test class that opens a transaction before each test and rolls it back after. Catch and handle all exceptions to guarantee rollback. Make the pattern inheritable by all downstream test classes. Step 4: Implement seed data manager Create a global seed manager for loading test data within the transaction scope. Do not commit seed data — transactions roll back after each test. Do not use TRUNCATE TABLE — preserve existing database data. Establish a naming convention for seed file location that downstream test creation will follow. Step 5: Verify the project compiles Build the test project and confirm it compiles with zero errors before finishing. Key Constraints Phase 3 only — this skill scaffolds the Oracle-targeting test project. The PostgreSQL test project (Phase 6) is created by copying and migrating this project; do not run this skill again at that point. Oracle is the golden behavior source — scaffold for Oracle only, not PostgreSQL. Keep to existing .NET and C# versions; do not introduce newer language or runtime features. Output is an empty test project with infrastructure only — no test cases.
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills github/scaffolding-oracle-to-postgres-migration-test-project