Oracle-to-PostgreSQL Migration Expert

Oracle-to-PostgreSQL Migration Expert is an agent for Claude Code from archubbuck/workspace-architect. It costs 41 tokens per session (3,067 once invoked), scanned A, a copy of Oracle-to-PostgreSQL Migration Expert, ISC.

A migration assistant for moving applications from Oracle to PostgreSQL, two different relational database systems. It explains their behavioral differences and helps adapt .NET and C# data-access code and tests.

In plain words
What is it for?
It is for planning and carrying out Oracle-to-PostgreSQL migrations in .NET and C# applications. It can help map database features, edit code, and run integration tests.
Why use it?
It helps expose database differences that can cause incorrect queries or application behavior after a migration. It also breaks the work into deliberate, testable steps.

Agent for Claude Code

Written for Claude Code: a Claude Code subagent (agents/*.md). Also seen: model in frontmatter; mentions subagents; Copilot chat-mode frontmatter (tools: vscode/*).

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add agents/archubbuck/workspace-architect/oracle-to-postgres-migration-expert
Clone the repo
git clone --depth 1 https://github.com/archubbuck/workspace-architect

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for Oracle-to-PostgreSQL Migration Expert

README.md
[![agentmods](https://agentmods.dev/badge/agents/archubbuck/workspace-architect/oracle-to-postgres-migration-expert.svg)](https://agentmods.dev/agents/archubbuck/workspace-architect/oracle-to-postgres-migration-expert)
Your own site
<a href="https://agentmods.dev/agents/archubbuck/workspace-architect/oracle-to-postgres-migration-expert"><img src="https://agentmods.dev/badge/agents/archubbuck/workspace-architect/oracle-to-postgres-migration-expert.svg" alt="Measured on agentmods" height="20"></a>
Per session 41 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 3,067 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin 100% copy Near-identical to another mod in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00041 $0.03067
Opus 5 $0.00020 $0.01533
Sonnet 5 $0.00008 $0.00613
Haiku 4.5 $0.00004 $0.00307

Measured 2d ago against content hash 61490baefcb0, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-06, from the pricing page.

Security

Grade A, and why

Oracle-to-PostgreSQL Migration Expert scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

This is a copy

100% identical to Oracle-to-PostgreSQL Migration Expert — 0 lines differ, which has more behind it and is treated as the original. This page carries a canonical link to it rather than competing with it.

assets/agents/oracle-to-postgres-migration-expert.agent.md · 140 lines

How it starts

The opening of the file, as written. The whole thing — 140 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Your Expertise

You are an expert Oracle-to-PostgreSQL migration agent with deep knowledge in database migration strategies, Oracle/PostgreSQL behavioral differences, .NET/C# data access patterns, and integration testing workflows. You directly make code edits, run commands, and perform migration tasks.

Your Approach

  • Educate first. Explain migration concepts clearly before suggesting actions.
  • Suggest, don't assume. Present recommended next steps as options. Explain the purpose and expected outcome of each step. Do not chain tasks automatically.
  • One step at a time. After completing a step, summarize what was produced and suggest the logical next step. Do not auto-advance to the next task.
  • Act directly. Use edit, runInTerminal, read, and search tools to analyze the workspace, make code changes, and run commands. You perform migration tasks yourself rather than delegating to subagents.

Guidelines

  • Keep to existing .NET and C# versions used by the solution; do not introduce newer language/runtime features.
  • Minimize changes — map Oracle behaviors to PostgreSQL equivalents carefully; prioritize well-tested libraries.
  • Preserve comments and application logic unless absolutely necessary to change.
  • PostgreSQL schema is immutable during Phases 5 and 6 (code and test migration) — do not alter tables, views, indexes, constraints, sequences, or other schema objects (except stored procedures, which may be corrected in Phase 6 per the fix loop instructions) while the application code is being migrated. DDL creation is only permitted in Phase 4, and even then only generate scripts for the user to apply — never apply DDL directly.
  • Never apply database changes directly on behalf of the user. Generate scripts and explicit run instructions so the user applies DB changes themselves.
  • Oracle is the source of truth for expected application behavior during validation.
  • Be concise and clear in your explanations. Use tables and lists to structure advice.
  • When reading reference files, synthesize the guidance for the user — don't just dump raw content.

Read the full file on GitHub · 140 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 2d ago First seen · 140 lines · 41 tokens per session scan A 61490baefcb0

Subscribe to this mod's changes

Oracle-to-PostgreSQL Migration Expert is an agent published in the GitHub repository archubbuck/workspace-architect (18 stars, last pushed 2d ago), licensed ISC. It adds 41 tokens to every session and 3,067 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. It is 100% identical to Oracle-to-PostgreSQL Migration Expert, differing in 0 lines, and is treated as a copy.

Related

Other agents, from other repositories

Oracle-to-PostgreSQL Migration Expert

Agent for Oracle-to-PostgreSQL application migrations. Educates users on migration concepts, pitfalls, and best practices; makes code edits and runs commands directly.

github/awesome-copilot · 41 tokens

Oracle-to-PostgreSQL Migration Expert

Agent for Oracle-to-PostgreSQL application migrations. Educates users on migration concepts, pitfalls, and best practices; makes code edits and runs commands directly; and invokes extension tools on user confirmation.

KIMISKI33/awesome-copilot · 49 tokens

C# Expert

An agent designed to assist with software development tasks for .NET projects.

github/awesome-copilot · 18 tokens

Neon Migration Specialist

Safe Postgres migrations with zero-downtime using Neon's branching workflow. Test schema changes in isolated database branches, validate thoroughly, then apply to production—all automated with support for Prisma, Drizzle, or your favorite ORM.

github/awesome-copilot · 50 tokens

efcore-specialist

Database specialist for ASP.NET Core / EF Core, runs in the "database" extra phase after development. Finalizes entity configurations (Fluent API, column types, indexes, constraints, relations), generates the migration via dotnet ef migrations add, reviews the SQL, runs dotnet ef database update, verifies the schema.…

AratKruglik/claude-sdlc · 101 tokens

chadi-data

Database and data-flow helper for schema, migrations, queries, indexes, Prisma/Supabase/Postgres/MySQL/Redis, and data integrity.

chadixearth/graphyloop · 29 tokens