Identifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences (empty strings, refcursors, type coercion, sorting/collations, UNION ALL planner risks, materialized-view refresh requirements, timestamps, concurrent transactions, etc.). Use when planning a database migration, reviewing migration artifacts, or validating that integration tests cover Oracle/PostgreSQL differences.
Reviewing Oracle-to-PostgreSQL Migration is a review and risk-assessment skill that surfaces migration hazards by cross-referencing code against a curated library of documented Oracle/PostgreSQL behavioral differences. It solves a costly, error-prone problem: subtle semantic gaps between the two databases (empty-string-as-NULL, refcursor handling, type coercion, default collations and sorting, UNION ALL planner risks, materialized-view refresh requirements, timestamp/timezone behavior, no-data-found exceptions, and concurrent-transaction differences) that pass code review but break in production.
The skill offers two workflows. The planning/risk-assessment workflow identifies migration scope (procedures, triggers, queries, views, and the app code that calls them), screens each documented insight in references/REFERENCE.md for applicability, and documents risks with recommended fix patterns, flagging insights that require a design decision. The validation workflow maps a completed migration artifact, cross-checks each applicable insight, verifies integration-test coverage for both happy-path and failure scenarios, and gates the result with a checklist asserting every applicable insight was addressed, scripts run, and tests pass. Each concern has a dedicated reference file with problem descriptions, root causes, recommended SQL/collation patterns (for example CAST(... AS TEXT) instead of TO_CHAR on numerics, or wrapping DISTINCT queries before ordering with an explicit collation), migration checklists, and error messages to watch for.
It targets database engineers, backend developers, and reviewers planning or validating Oracle-to-PostgreSQL migrations, especially those wanting to ensure integration tests actually cover the semantic differences. It is read-only advisory guidance; it does not execute migrations.
Identifying and validating Oracle-to-PostgreSQL migration risks by cross-referencing code against documented behavioral differences, either when planning a migration or when reviewing completed migration artifacts.
Empty-string handling, refcursors, type coercion, sorting/collations, UNION ALL planner risks, materialized-view refresh, timestamps/timezones, no-data-found exceptions, TO_CHAR numeric conversions, and concurrent transactions, each in its own reference file.
The planning workflow screens each insight for applicability and documents risks up front. The validation workflow cross-checks a finished migration, verifies integration-test coverage of failure scenarios, and returns a gating checklist.
No. It is advisory review guidance built around reference documentation; it recommends SQL patterns and tests but does not execute migrations or modify data.
Yes. For example, replacing TO_CHAR(numeric) with CAST(... AS TEXT), applying COLLATE "C" only where Oracle-style binary ordering is needed, and wrapping SELECT DISTINCT before an outer ORDER BY.
Quick Setup:
.claude/skills/Repository
github/awesome-copilot