40+ object types, line by line
Tables, functions, types, policies, triggers, and more — side by side with line-level highlighting, a plain-English summary, and dependency chips linking related objects.
@@ v2.2.0 · schema & data comparison for postgresql @@
−Eyeball two schemas and hope for the best. +Know exactly what changed. Deploy it safely.
PostgresCompare finds every difference across 40+ object types, then writes the dependency-ordered SQL to sync them — flagging anything destructive before you run it.
runs 100% locallyno credit cardmacOS · Windows · Linux
staging.public.ordersproduction.public.orders
@@ table: orders · 2 differences @@
staging
11 CREATE TABLE orders (
12 amount numeric(10,2),
13+ currency char(3),
14 status order_status,
15 );
production
11 CREATE TABLE orders (
12 amount numeric(10,2),
13 status order_status,
14- legacy_ref varchar(64),
15 );
⚠ 1 destructive change: DROP COLUMN legacy_ref — review before deploying
@@ see it work @@
Walk through a comparison first.
@@ what it does @@
Every difference found.
Every deploy accounted for.
Compare any two schemas — then act on what you find with a script you can read before you run.
compare
deploy
Deployment scripts, dependency-ordered
One click generates the SQL to bring two schemas in sync — in an order that actually runs, with destructive statements surfaced in red before anything else.
data pro
Rows, not just structure
Compare the data itself, see which rows differ, and generate the INSERT, UPDATE and DELETE statements to reconcile them. Export any table's differences to CSV.
automate pro
The pgc CLI and pipelines
Run the same comparisons from CI, fail a build when a schema drifts unexpectedly, and chain steps into repeatable pipelines. No interface required.
track pro
Schema history and drift
Keep every comparison you run. Watch your schema evolve in a swimlane view, and catch drift between environments before it reaches an incident channel.
agents pro
Built for AI-assisted workflows
The bundled MCP server lets coding agents run comparisons and read the results. Read-only mode and environment allow-lists control exactly what an agent can reach.
srclive databases
srcpg_dump files
srcmigration folders
srcany combination of the three
@@ where it runs @@
Your schema never leaves your machine.
Every comparison runs locally on your desktop. No cloud processing, no data in transit, nothing for your security team to review — which is exactly how they like it.
your machine ├── postgrescompare ✓ compares here ├── staging connection ✓ read-only └── production connection ✓ read-only the cloud receives your data
Clever and complete tool to compare PostgreSQL schemas and diff databases.Scott Hanselman · @shanselman
I needed a quick schema diff and got the answers I needed in under a minute.
Richard Hayes · @justcompile
Compare dev to test to stage to prod — it has become essential as I plan website updates and verify database changes have been implemented.
Dan Langille · @DLangille
Just used the tool for the first time and it was a huge help.
Ryan Booz · @ryanbooz
Using PostgresCompare daily and loving it.
Wellspring · @WellspringCloud
@@ pricing @@
Free to compare. Paid to automate.
Quick compare, scripting and deploying are free forever. Saved projects, history, pipelines and the CLI are what you pay for.
Free
$0
Where your 14-day trial lands
- Quick compare, all 40+ object types
- Live databases, pg_dump files, migration folders
- Dependency-ordered deployment scripts
- Deploy, with destructive-change safeguards
- Your trial projects stay readable
- Comparisons aren't saved
- No data comparison, exports or CLI
Pro
$29.95 / user / month
Or $299.95 a year — saves $59.45
- Everything in Free
- Saved schema and data projects, re-run anytime
- Comparison history and drift timelines
- Pipelines and the pgc CLI
- Reports, exports and scripts folders
- Parallel connections, include/exclude rules
- Pre- and post-deploy scripts
Team
Volume pricing
For teams and consultancies
- Everything in Pro
- Volume discounts
- Invoice billing
- Priority support
See what changed. In the next five minutes.
Download free, open the sample comparison, and watch a realistic schema drift resolve into a deployment script.
Download free macOS · Windows · Linux — no credit card, no account