First published on the Tech Style blog .

Most Oracle to PostgreSQL projects are priced before anyone has read the code. Someone counts tables and guesses at the PL/SQL, and the expensive surprises turn up late: package-level state, autonomous transactions, LONG columns, interval partitioning, database links. pgrecon is our free, open-source tool for finding those things first.

It is on GitHub under Apache 2.0 and on PyPI as pgrecon . It needs Python 3.11 or later.

It never connects to your database

That matters, because it decides whether a bank or a hospital will let you run the tool at all. pgrecon writes a plain SQL*Plus script, SELECT only, against the dictionary views. The DBA reads it, runs it with a read-only account and hands back a folder of files.…