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.
- The pinned file does not state a host install command.
- 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.
- Agent profile ↗Checked
https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/agents/oracle-to-postgres-migration-expert.agent.md
Supports: Role and stated limits
- Repository licence ↗Checked
https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/LICENSE
Supports: Redistribution terms