← Explore all agents

MODERNIZATION AND SPECIFICATIONS / GitHub

Oracle-to-PostgreSQL migration expert

Phases an Oracle-to-PostgreSQL migration and keeps the source as the behaviour to match.

“Agent for Oracle-to-PostgreSQL application migrations. Educates users on migration concepts, pitfalls, and best practices.”

01 / THE REASONING

Why this made the selection.

  • The file forbids applying database changes for the user and says to hand over scripts instead.
  • Phases 5 and 6 keep the PostgreSQL schema immutable except for stored-procedure corrections.

02 / THE REVIEW RECORD

What we actually inspected.

Source review has boundaries.
A clear record is more useful than a “safe” badge.

Material inspected

  • agents/oracle-to-postgres-migration-expert.agent.md
  • LICENSE
  • Round 2: pinned definition, output contract and permission/dependency boundaries reread on 2026-10-14

Our findings

  • Frontmatter tools include vscode/runCommand, vscode/askQuestions, execute, read, edit, search, and todo, and model is Claude Sonnet 5.
  • The file says never to apply database changes directly; the user applies the generated scripts.
  • If Oracle DDL artifacts are missing, it says to stop and ask for them before phase 2.
  • Code edits in the later phase are only in the .Postgres copy, not the original Oracle project.
  • The workflow detects EF Core separately from ADO.NET and records procedure complexity rather than ingesting all DDL indiscriminately.
  • Compilation failure permits only one correction round per checklist item, while unresolved schema-dependent test failures remain explicitly documented limitations.

Not established by this review

  • The agent was not executed against a live repository or host.

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

Use the role in your project.

Upstream setup instructions ↗
  1. The pinned file does not state a host install command.
  2. Retain the referenced migration skills and original Oracle tests; require a clear list of unresolved parity gaps at handoff.

Before you start

  • The .NET solution, Oracle DDL artifacts, and the phase the user has confirmed.

04 / FOLLOW THE EVIDENCE

The source trail.

Our notes are separate from the original resource.
Check upstream before adopting a new version.

  1. Agent profile ↗Checked

    https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/agents/oracle-to-postgres-migration-expert.agent.md

    Supports: Role and stated limits

  2. Repository licence ↗Checked

    https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/LICENSE

    Supports: Redistribution terms

Evidence & Ask