---
title: "Oracle-to-PostgreSQL migration expert: review, role & definition · Undominated.ai"
canonical: https://undominated.ai/agents/github-oracle-to-postgres-migration-expert/
description: "Phases an Oracle-to-PostgreSQL migration and keeps the source as the behaviour to match."
---

# Oracle-to-PostgreSQL migration expert: review, role & definition · Undominated.ai

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

[← Explore all agents](/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.

 [Use this definition ↓](#setup)[Original source ↗](https://github.com/github/awesome-copilot/tree/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/agents)

SOURCE REVIEW

 Reviewed 2026-10-14
 Evidence 2 linked sources
 Publisher GitHub
 Licence [MIT ↗](https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/LICENSE)
 Revision 3a685010a7af
 [Read what was—and wasn’t—checked ↓](#review)

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

 [GitHub · upstream description ↗](https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/agents/oracle-to-postgres-migration-expert.agent.md) Our analysis follows below.

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.

### A good fit for

 - Planning one .NET project's Oracle-to-PostgreSQL move without editing the original project.
- Stopping when Oracle DDL artifacts are missing instead of inventing a schema.
- Supply Oracle DDL artifacts, the .NET solution and a stable behavior-test environment.
- Use separate risk/checklist artifacts and a PostgreSQL project copy while keeping the Oracle baseline testable.

### Weigh up before choosing

 - Tools include edit and execute, so the no-direct-database-change rule is an instruction.
- The file is a Copilot agent definition and does not install itself into a host.
- This review did not run the agent.
- A phase can be marked complete with documented schema-blocked failures; completion therefore does not mean full behavioral parity. Generated DDL is for the user to apply.

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 ↗](https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/agents/oracle-to-postgres-migration-expert.agent.md)
 - 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.

### Compatibility

GitHub Copilot agent files

### Implementation

Markdown

### Local role instructions

 - vscode/memory, vscode/runCommand, vscode/askQuestions, execute, read, edit, search, and todo.
- The body forbids applying database changes on the user's behalf.

### Cost model

MIT. The file names Claude Sonnet 5 and does not state a price.

04 / FOLLOW THE EVIDENCE

## The source trail.

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

 - [Agent profile ↗](https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/agents/oracle-to-postgres-migration-expert.agent.md) Checked 2026-10-14 https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/agents/oracle-to-postgres-migration-expert.agent.md Supports: Role and stated limits
- [Repository licence ↗](https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/LICENSE) Checked 2026-10-14 https://github.com/github/awesome-copilot/blob/3a685010a7afdc0dbd4c83b7fbda6c316aa516e5/LICENSE Supports: Redistribution terms

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### Business Rules Extractor ↗ Extracts domain calculations, validation and policy rules from legacy code into concrete test scenarios with source references and uncertainty questions.](/agents/anthropic-business-rules-extractor/)[### Neon Migration Specialist ↗ Tests schema changes on a temporary Neon database branch and prepares migration files for a separate production rollout.](/agents/github-neon-migration-specialist/)[### Pilot-Driven Uplift Migrator ↗ Applies an approved pilot playbook to one migration unit and returns build evidence, playbook gaps and shared-file needs to the coordinating owner.](/agents/anthropic-uplift-migrator/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Find reusable instructions](/skills/)
- [Inspect connections](/mcp-servers/)
- [Build a toolkit](/tools/)
- [Choose the model](/compare/)
