Compare two PostgreSQL databases
See what changed between two PostgreSQL schemas.
Point DiffyPick at two PostgreSQL databases and it lists every table, column, index and constraint that differs — then generates the SQL to bring one in line with the other.
Why it is harder than it should be
Schemas drift between local, staging and production, and the truth lives in the database — not in a stack of migration files.
DiffyPick reads both schemas directly and shows the difference as a clean, per-object list you can act on.
The manual way
You can dump both schemas with pg_dump --schema-only and diff the two files, or query information_schema and pg_catalog by hand.
It works, but dump diffs are noisy — ordering, ownership and comments get in the way — and turning the result into safe ALTER statements is on you.
DiffyPick skips that: it compares object by object and writes the ALTER SQL for you.
With DiffyPick
Connect both databases
Pick the two PostgreSQL connections, then the database and schema on each side.
Compare
Every differing table, column, index, constraint, view and function is listed as a diff, color-coded and searchable.
Review and sync
Preview the generated ALTER SQL statement by statement, pick what to apply, and run it — or export an HTML report.
What you get
- A per-object diff, not a noisy text dump.
- Generated ALTER SQL with FK ordering handled for you.
- Preflight checks and one-click backup before anything runs.
- The same workflow across MySQL, SQL Server, MariaDB and SQLite too.
Compare your PostgreSQL schemas now.
Free for SQLite; connect PostgreSQL on a paid plan. No account needed to start.