Skip to main content
affpapa.org
RU EN
skill GitHub Copilot official · GitHub

scaffolding-oracle-to-postgres-migration-test-project — Copilot skill

Creates an empty xUnit integration test project for Oracle in a .NET solution. Use it in Phase 3 before writing Oracle baseline integration tests.

Install into GitHub Copilot · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add github/awesome-copilot --skill scaffolding-oracle-to-postgres-migration-test-project
Open on GitHub

What scaffolding-oracle-to-postgres-migration-test-project does

The skill reads the target .csproj, matches its .NET and package versions, and creates a separate xUnit test project with a reference to the target project only. It adds Oracle connectivity through Oracle.ManagedDataAccess.Core, an appsettings.json file, and the infrastructure needed to build the test project.

The generated project includes a base class that opens a transaction before each test and rolls it back afterward. Exceptions are handled so rollback still runs. A seed manager loads test data inside the transaction, does not commit it, and avoids TRUNCATE TABLE. The skill builds the project before finishing, and the output contains infrastructure only, with no test cases.

Install it once per project during Phase 3 for Oracle. Do not run it during Phase 6: the PostgreSQL test project is created by copying and migrating this project.

What it helps with

  • create an xUnit project for Oracle integration tests
  • match the target project's .NET and package versions
  • roll back the transaction after each test
  • load seed data without committing it
  • verify that the test project builds with zero errors

Example prompts for the agent

  • Scaffold the Oracle test infrastructure for this .NET project during Phase 3.
  • Read the `.csproj`, create the xUnit project, and add a transaction-rollback base class.
  • Add the seed manager and build the project without creating test cases.

How to install scaffolding-oracle-to-postgres-migration-test-project

1Skills CLI (Vercel)

npx skills add github/awesome-copilot --skill scaffolding-oracle-to-postgres-migration-test-project

2GitHub CLI

gh skill install github/awesome-copilot scaffolding-oracle-to-postgres-migration-test-project

3Manually: put the files in place

.github/skills/scaffolding-oracle-to-postgres-migration-test-project/SKILL.md

From the same set554

The whole set →
git-commit official github This skill reviews Git changes, stages related files, and creates Conventional Commits. Use it when you want an agent to make one commit or split work into separate commits. GitHub Copilot 47,165installs excalidraw-diagram-generator official github Turn a plain-language description into an Excalidraw diagram. Useful for mapping processes, system structure, and relationships between entities. GitHub Copilot 31,639installs multi-stage-dockerfile official github This skill guides GitHub Copilot in writing multi-stage Dockerfiles for different languages and frameworks. Use it when the final runtime image should contain fewer build dependencies. GitHub Copilot 29,688installs documentation-writer official github Skill that turns the agent into a technical writer following the Diátaxis framework: tutorials, how-to guides, reference, and explanation. Proposes structure before writing. GitHub Copilot 27,757installs prd official github Turns a feature idea into a structured PRD with user stories, technical requirements, and risks. Use it when planning a software feature or an AI-powered one. GitHub Copilot 24,035installs refactor official github This skill reshapes existing code without changing its external behavior. Use it for gradual cleanup of large functions, duplication, weak types, and code smells. GitHub Copilot 22,321installs java-springboot official github Gives GitHub Copilot Spring Boot development practices, from project layout to tests and security. Use it when writing or reviewing Java application code. GitHub Copilot 21,272installs create-readme official github This skill reviews a project and creates a structured README.md. Use it when the repository needs clear documentation based on its actual files and code. GitHub Copilot 19,081installs

Similar

ai-debt-detector Adit Jain This skill audits AI-generated code for missed failure paths, orphaned resources, fake dependencies, and architecture drift before a merge. Claude Code CX Codex Cursor 2,900installs improve-codebase-architecture Matt Pocock This skill scans a codebase for architectural friction, then builds a visual HTML report with refactoring candidates. Use it before a deeper architecture review. Claude Code 1,163,035installs design-taste-frontend Leonxlnx This skill directs the design of public pages and work screens, then checks the result in a browser through screenshots. Use it when an interface feels generic or unfinished. Claude Code CX Codex Cursor +1 673,100installs tdd Matt Pocock Guides the red-green TDD loop: ensures tests are written first, keep them at public interfaces, and avoid coupling to implementation details. Claude Code 1,141,062installs skill-creator official anthropics Creates and refines skills, then tests them with prompts, evaluations, and performance checks. Claude Code Claude.ai 414,180installs agent-browser vercel-labs A CLI skill for browser control: it opens pages, fills forms, clicks buttons, and tests web apps. Use it when an agent needs to act inside a website. Claude Code CX Codex Cursor +1 1,200,000installs prototype Matt Pocock Creates throwaway prototypes for checking state logic or exploring UI before committing the decision to the main codebase. Claude Code 986,201installs

Questions about scaffolding-oracle-to-postgres-migration-test-project

How do I install scaffolding-oracle-to-postgres-migration-test-project in GitHub Copilot?

Run npx skills add github/awesome-copilot --skill scaffolding-oracle-to-postgres-migration-test-project, then use .github/skills/scaffolding-oracle-to-postgres-migration-test-project/SKILL.md.

What does scaffolding-oracle-to-postgres-migration-test-project do?

The skill creates an empty Oracle-focused xUnit project in a .NET solution. It adds transaction rollback, seed-data infrastructure, connection settings, and a build check.

Should I run the skill again when creating the PostgreSQL project in Phase 6?

No. It is for the Oracle project in Phase 3; the PostgreSQL project is produced by copying and migrating that project.

Source text

SKILL.md · MIT 
---
name: scaffolding-oracle-to-postgres-migration-test-project
description: '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.'
---

# 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

```
Progress:
- [ ] Step 1: Inspect the target project
- [ ] Step 2: Create the xUnit test project
- [ ] Step 3: Implement transaction-rollback base class
- [ ] Step 4: Implement seed data manager
- [ ] Step 5: Verify the project compiles
```

**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.

© github · MIT · github/awesome-copilot

See also

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor