plsql2pgsql

A PLSQL to Postgres Transpiler

Only for Mac

$199.99

Mac

Transpile Oracle PL/SQL packages, procedures, functions, triggers, and types directly into PostgreSQL. Drag in your .sql files and get clean .pg.sql output instantly. plsql2pgsql converts Oracle PL/SQL source files into PostgreSQL PL/pgSQL with a single click. Built on a full ANTLR4-based parser that understands the complete Oracle PL/SQL grammar, it handles packages, procedures, functions, triggers, types, sequences, and libraries — not just simple SELECT statements. === What It Handles === Packages and package bodies Standalone procedures and functions DML and instead-of triggers, compound triggers Types (objects, collections, varrays, nested tables, REF cursors) Sequences (CREATE / ALTER / DROP) Libraries and call specifications Dynamic SQL (EXECUTE IMMEDIATE, OPEN FOR) Bulk operations (FORALL, BULK COLLECT) Exception handling, pragmas, autonomous transactions Cursor declarations (explicit, implicit, REF cursors) All Oracle DB data types with sensible PostgreSQL mappings === How It Works === 1. Select one or more Oracle .sql files. 2. Choose an output folder. 3. Click Convert. Each output file gets a header comment with the source path and UTC timestamp, making it easy to track what was converted and when. === Output === - Clean, readable PostgreSQL PL/pgSQL - Oracle-specific constructs mapped to PostgreSQL equivalents where possible - Unsupported constructs flagged with clear comments - One .pg.sql file per input file === Under the Hood === plsql2pgsql uses a hand-maintained ANTLR4 grammar covering the full Oracle PL/SQL syntax. The transpilation engine is written in Go. It runs entirely on your Mac with no network access required. Your source code never leaves your machine. === Disclaimer === All trademarks belong to their owners. === Requirements === - macOS 14.0 or later - Apple Silicon or Intel Mac

Ratings & Reviews

  • This app hasn’t received enough ratings or reviews to display an overview.

## v1.0.10 (2026-07-21) ### Added - **System view mappings** - 10 previously-unmapped Oracle views now translated to PostgreSQL equivalents: ALL_SEQUENCES, ALL_TAB_PRIVS, ALL_COL_COMMENTS, ALL_TAB_COMMENTS, ALL_SYNONYMS, USER_TABLES, USER_OBJECTS, V$PARAMETER, DBA_DATA_FILES, DBA_FREE_SPACE.

Version 1.0.10

The developer, FWLAB Limited, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .

  • Data Not Collected

    The developer does not collect any data from this app.

    Privacy practices may vary, for example, based on the features you use or your age. Learn More

    Accessibility

    The developer has not yet indicated which accessibility features this app supports. Learn More

    Information

    Seller
    • FWLAB Limited
    Size
    • 6 MB
    Category
    • Developer Tools
    Compatibility
    Requires macOS 14.0 or later.
    • Mac
      Requires macOS 14.0 or later.
    Languages
    • English
    Age Rating
    4+
    Copyright
    • © Copyright Michele Fadda and FWLAB Limited All Rights Reserved
  • Developer Website
  • Privacy Policy

    • Supports

    • Family Sharing

      Up to six family members can use this app with Family Sharing enabled.

    More by FWLAB Limited