Official agent skill

Scaffolding Oracle To Postgres Migration Test Project

by github in github/awesome-copilot

Scaffolds an xUnit integration test project targeting Oracle in .NET solutions.

OfficialMITAuto-check passedTesting & QA

Install Scaffolding Oracle To Postgres Migration Test Project

skills CLI
$ npx skills add github/awesome-copilot --skill scaffolding-oracle-to-postgres-migration-test-project -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install github/awesome-copilot scaffolding-oracle-to-postgres-migration-test-project --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/github/awesome-copilot.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/scaffolding-oracle-to-postgres-migration-test-project .claude/skills/scaffolding-oracle-to-postgres-migration-test-project && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
scaffolding-oracle-to-postgres-migration-test-project
GitHub stars
40k
Token cost
~687 tokens
SKILL.md length
296 words
Files
1
Skills in repo
417
Repo updated
First seen
Licence
MIT

At a glance

Scaffolds an xUnit integration test project targeting Oracle in .NET solutions.

  • Tasks that involve Project scaffolding
  • SKILL.md covers Workflow and Key Constraints
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
  • Tasks that involve Integration testing

What it does

Scaffolding Oracle To Postgres Migration Test Project is an agent skill from github/awesome-copilot, published by the product's own GitHub organization. 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.

Its SKILL.md is about 690 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Testing & QA, covering Project scaffolding, Integration testing and Test data and fixtures. It works with PostgreSQL and .NET. The repository describes itself as: Community-contributed instructions, agents, skills, and configurations to help you make the most of GitHub Copilot. The licence is MIT.

When your agent uses it

  • Tasks that involve Project scaffolding
  • Tasks that involve Integration testing
  • Tasks that involve Test data and fixtures

Example prompts

  • “Use the scaffolding-oracle-to-postgres-migration-test-project skill to scaffold an xUnit integration test project targeting Oracle in .NET solutions”
  • “/scaffolding-oracle-to-postgres-migration-test-project”

What it can do on your machine

Read from SKILL.md and the folder at commit 727ff2e. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Scaffolding Oracle To Postgres Migration Test Project loads about 687 tokens when it runs. Until then it costs about 105 tokens; SKILL.md has 296 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~105
When it runs · the whole SKILL.md, loaded when a task matches
~687

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from github/awesome-copilot at commit 727ff2e, republished under its MIT licence (© github). 296 words, ~687 tokens.

Download SKILL.mdSave it as .claude/skills/scaffolding-oracle-to-postgres-migration-test-project/SKILL.md (or your agent's skills folder).
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. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in skills/scaffolding-oracle-to-postgres-migration-test-project of github/awesome-copilot.

Open the folder on GitHubat commit 727ff2e

Compare with similar skills

Scaffolding Oracle To Postgres Migration Test Project next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Scaffolding Oracle To Postgres Migration Test Project compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Scaffolding Oracle To Postgres Migration Test Project this skillgithub/awesome-copilot40k—~687Automated safety check: PassMIT
Scaffolding Oracle To Postgres Migration Test Projectboshi-xixixi/TraeSkill274—~632Automated safety check: PassMIT
Aspire Integration TestingDevBetterCom/DevBetterWeb1572 repos~2.3kAutomated safety check: PassNone
Creating Oracle To Postgres Migration Integration Testsboshi-xixixi/TraeSkill274—~760Automated safety check: PassMIT
Airbyte Postgres Source E2E Testsairbytehq/airbyte22k—~2.5kAutomated safety check: PassCustom licence
New Event Sourceaws/aws-lambda-dotnet1.7k—~3kAutomated safety check: PassApache-2.0

Similar skills

  • Scaffolds an xUnit integration test project for validating Oracle-to-PostgreSQL database migration behavior in .NET solutions.

    274 GitHub stars~632 tokensUpdated 4 mo ago
    Testing & QAAuto-check passed
  • Aspire Integration Testing

    DevBetterCom/DevBetterWeb

    Write integration tests using .NET Aspire's testing facilities with xUnit.

    157 GitHub starsUsed in 2 repos~2.3k tokens
    Testing & QAAuto-check passed
  • Official

    Starts a local PostgreSQL 16 container, loads SQL fixtures and runs the Airbyte spec, check, discover and read commands against a chosen source-postgres image.

    22k GitHub stars~2.5k tokensUpdated today
    Testing & QAAuto-check passed
  • New Event Source

    aws/aws-lambda-dotnet

    Official

    Add a new AWS event source attribute (e.g., Kinesis, Kafka, MQ) to the Lambda .NET Annotations framework, including the attribute class, source generator integration, CloudFormation writer, unit…

    1.7k GitHub stars~3k tokensUpdated today
    Testing & QAAuto-check passed
  • Robotics Testing

    arpitg1304/robotics-agent-skills

    Testing strategies, patterns, and tools for robotics software.

    368 GitHub stars~4.7k tokensUpdated 1 mo ago
    Testing & QAAuto-check passed

More from github/awesome-copilot

All 417 skills in this repo
  • Acquire Codebase Knowledge

    github/awesome-copilot

    Official

    Maps an unfamiliar codebase into seven evidence-backed documents in docs/codebase/, using a scan script and templates, for onboarding or architecture write-ups.

    40k GitHub starsUsed in 1 repo~2.3k tokens
    Auto-check passed
  • Azure Architecture Autopilot

    github/awesome-copilot

    Official

    Designs Azure infrastructure from a natural-language description, or diagrams an existing resource group, then refines the design through conversation and deploys it with Bicep.

    40k GitHub starsUsed in 1 repo~1.9k tokens
    Auto-check passed
  • Draw.io Diagram Generator

    github/awesome-copilot

    Official

    Generates, edits and validates draw.io files with correct mxGraph XML, covering flowcharts, architecture, sequence, ER and UML class diagrams.

    40k GitHub starsUsed in 1 repo~4.9k tokens
    Auto-check passed
  • Credit Risk Data Cleaning

    github/awesome-copilot

    Official

    Cleans raw credit data and screens variables before loan modeling, dropping unstable, noisy or redundant features and writing an Excel report of every step.

    40k GitHub starsUsed in 1 repo~1.5k tokens
    Auto-check passed
  • Daily Focus Board

    github/awesome-copilot

    Official

    Builds a warm, browser-based daily focus board the user updates by talking to their agent, with Eisenhower priorities, a brain-dump box and kind not-today carryover.

    40k GitHub stars~3k tokensUpdated today
    Auto-check passed
  • Python Pypi Package Builder

    github/awesome-copilot

    Official

    End-to-end skill for building, testing, linting, versioning, and publishing a production-grade Python library to PyPI.

    40k GitHub starsUsed in 1 repo~4.6k tokens
    Auto-check passed

Works with

Categories

Questions about Scaffolding Oracle To Postgres Migration Test Project

What does Scaffolding Oracle To Postgres Migration Test Project do?

Scaffolds an xUnit integration test project targeting Oracle in .NET solutions. Scaffolding Oracle To Postgres Migration Test Project is an agent skill from github/awesome-copilot, published by the product's own GitHub organization.NET solutions.

When should I use Scaffolding Oracle To Postgres Migration Test Project?

Scaffolding Oracle To Postgres Migration Test Project fits situations like: tasks that involve Project scaffolding; tasks that involve Integration testing; tasks that involve Test data and fixtures.

How do I install Scaffolding Oracle To Postgres Migration Test Project in Claude Code?

Run `npx skills add github/awesome-copilot --skill scaffolding-oracle-to-postgres-migration-test-project -a claude-code`. Or copy the skill folder (skills/scaffolding-oracle-to-postgres-migration-test-project in github/awesome-copilot) into .claude/skills/scaffolding-oracle-to-postgres-migration-test-project in your project. Claude Code loads it when a task matches its description.

How do I install Scaffolding Oracle To Postgres Migration Test Project in Codex?

Run `npx skills add github/awesome-copilot --skill scaffolding-oracle-to-postgres-migration-test-project -a codex`. Or copy the skill folder (skills/scaffolding-oracle-to-postgres-migration-test-project in github/awesome-copilot) into .agents/skills/scaffolding-oracle-to-postgres-migration-test-project in your project. Codex loads it when a task matches its description.

Can I use Scaffolding Oracle To Postgres Migration Test Project in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add github/awesome-copilot --skill scaffolding-oracle-to-postgres-migration-test-project -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/scaffolding-oracle-to-postgres-migration-test-project, .gemini/skills/scaffolding-oracle-to-postgres-migration-test-project, .github/skills/scaffolding-oracle-to-postgres-migration-test-project and .opencode/skills/scaffolding-oracle-to-postgres-migration-test-project in your project.

What does Scaffolding Oracle To Postgres Migration Test Project need to run?

SKILL.md names no scripts, command-line tools or credentials: Scaffolding Oracle To Postgres Migration Test Project is instructions for the agent only.

Does Scaffolding Oracle To Postgres Migration Test Project access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Scaffolding Oracle To Postgres Migration Test Project safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Scaffolding Oracle To Postgres Migration Test Project use?

Scaffolding Oracle To Postgres Migration Test Project is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Scaffolding Oracle To Postgres Migration Test Project use?

About 687 tokens (SKILL.md is roughly 2.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Scaffolding Oracle To Postgres Migration Test Project?

Skills that share tags, products or a category with Scaffolding Oracle To Postgres Migration Test Project: Scaffolding Oracle To Postgres Migration Test Project (boshi-xixixi/TraeSkill, 274 stars), Aspire Integration Testing (DevBetterCom/DevBetterWeb, 157 stars), Creating Oracle To Postgres Migration Integration Tests (boshi-xixixi/TraeSkill, 274 stars) and Airbyte Postgres Source E2E Tests (airbytehq/airbyte, 22k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Scaffolding Oracle To Postgres Migration Test Project?

github (a GitHub organization, an official publisher) maintains it in github/awesome-copilot, which has 39,748 GitHub stars. The repository holds 417 skills in this directory. The repository was last updated on October 7, 2026.

Source: github/awesome-copilot on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.