Skip to content
Get packs

Oracle-to-PostgreSQL Migration Integration Tests

Writes Oracle-based integration tests for .NET data access code as a baseline for a later PostgreSQL migration.

Source Download skill
Repository
github/awesome-copilot
Stars
40,703
Licence
MIT
Files
1 file

What it does

This skill guides an AI coding agent to write integration tests for the database-access code in a .NET project (repositories, DAOs, stored procedure callers). The tests run against Oracle and record Oracle's behavior as the reference, so they can later be ported to PostgreSQL during a separate migration phase. It also sets rules for test data: add minimal seed records, avoid wiping tables, use transactions that roll back, and assert concrete values rather than just non-null results.

Great for

  • .NET teams in the test-writing phase of a planned Oracle-to-PostgreSQL migration
  • Developers who need a deterministic, Oracle-backed safety net before changing database code
  • Teams following a phased migration playbook that uses this numbered phase structure

Skip it if

  • Projects already migrated to PostgreSQL or past Phase 3; the skill says not to use it there, and tests written against the wrong database would be misleading
  • Non-.NET stacks or general unit testing, since the guidance is specific to a base test class and seed manager conventions
  • Teams without an existing, compiling test project; the skill assumes one already exists and will not scaffold it

Try asking

  • “Write integration tests for the customer repository methods in our Oracle-backed .NET project before we start the PostgreSQL migration”
  • “Create minimal seed data and tests for the stored procedure callers in the Orders project”
  • “Review my new integration tests for non-deterministic assertions against seeded data”
Step-by-step guide: how to use Oracle-to-PostgreSQL Migration Integration TestsInstall, first run, examples, tips and FAQs

Install in 3 steps

  1. 1

    Download the skill

    The ZIP contains the 1 original files, the MIT licence and an attribution note.

    creating-oracle-to-postgres-migration-integration-tests.zip
  2. 2

    Add it to your agent

    Claude Code (all projects)

    mkdir -p ~/.claude/skills && unzip creating-oracle-to-postgres-migration-integration-tests.zip -d ~/.claude/skills/

    Claude Code / Agent SDK (this project only)

    mkdir -p .claude/skills && unzip creating-oracle-to-postgres-migration-integration-tests.zip -d .claude/skills/

    Claude apps (web/desktop): Settings → Capabilities → Skills → Upload skill, and choose the ZIP.

  3. 3

    Ask for the task

    No special command needed — the agent reads the skill's description and loads it when your request matches. Try one of the prompts above.

Get better results

  • Point the agent at your base test class and seed manager first, since the skill tells it to read these conventions before writing anything.
  • Run the generated tests against Oracle and confirm they pass before the migration begins, so Oracle is a verified baseline.
  • Keep the skill out of Phase 6 work; use a separate skill or manual process for porting tests to PostgreSQL.

What's inside

  • SKILL.md

Redistributed unmodified from github/awesome-copilot under the MIT licence. The assessment was drafted with AI from the skill's files on 2026-10-29. Skills can instruct your agent to run code — read SKILL.md and any scripts before installing.