Creating Oracle To Postgres Master Migration Plan

This does the upfront inventory work when you're migrating a .NET solution from Oracle to Postgres. It scans your solution file, checks each project for Oracle dependencies (NuGet packages, connection strings, OracleConnection references), classifies them as MIGRATE, SKIP, ALREADY_MIGRATED, or TEST_PROJECT, then writes a structured markdown plan to a Reports folder. The real value is creating a parseable artifact that downstream migration skills can consume, so you're not rediscovering project structure every time. It also forces you to confirm the classification and migration order before anything gets written, which prevents surprises when libraries get migrated out of dependency order.

skills.sh installs: 1.8K
GitHub stars: 41K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add github/awesome-copilot --skill creating-oracle-to-postgres-master-migration-plan --agent claude-code

Installs into .claude/skills of the current project.

Files

Creating an Oracle-to-PostgreSQL Master Migration Plan

Analyze a .NET solution, classify every project for Oracle→PostgreSQL migration eligibility, and write a structured plan that downstream agents and skills can parse.

Workflow

Progress:
- [ ] Step 1: Discover projects in the solution
- [ ] Step 2: Classify each project
- [ ] Step 3: Confirm with user
- [ ] Step 4: Write the plan file

Step 1: Discover projects

Find the Solution File (it has a .sln or .slnx extension) in the workspace root (ask the user if multiple exist). Parse it to extract all .csproj project references. For each project, note the name, path, and type (class library, web API, console, test, etc.).

Step 2: Classify each project

Scan every non-test project for Oracle indicators:

NuGet references: Oracle.ManagedDataAccess, Oracle.EntityFrameworkCore (check .csproj and packages.config)
Config entries: Oracle connection strings in appsettings.json, web.config, app.config
Code usage: OracleConnection, OracleCommand, OracleDataReader
DDL cross-references under .github/oracle-to-postgres-migration/DDL/Oracle/ (if present)

SKILL.md on GitHub

Details

Repository: github.com/github/awesome-copilot
Categories: Backend & APIs, Git & Pull Requests, AI & Agent Building, Productivity & Planning, Databases, .NET & C#
First seen: Apr 16, 2026