Compare and Sync PostgreSQL Schema and Data

KS DB Merge Tools for PostgreSQL is an easy to use diff & merge tool for PostgreSQL databases:

Compare both schema and data
Quick filters to show all/new/changed
Merge changes in both directions
Lightweight GUI for Windows, command line for Windows and Linux
Free version with basic features, available for commercial use. No credit card, no signup, no ads, no hidden telemetry.
Standard version with whole set of features at a reasonable price. Free 14 days trial available.
Supported DBMS: PostgreSQL 9.3 .. 17

Screenshots and Use Cases

Scroll the gallery and click on the image title to open the use case with detailed steps.
Use the toggle to switch application modes, if applicable.
Or explore the app's key features by watching our short video walkthrough (about 3 minutes).

KS DB Merge Tools for PostgreSQL - Schema changes summary (thumbnail)

KS DB Merge Tools for PostgreSQL - Data changes summary (thumbnail)

KS DB Merge Tools for PostgreSQL - Compare and synchronize data (thumbnail)

KS DB Merge Tools for PostgreSQL - Compare ad-hoc query result (thumbnail)

KS DB Merge Tools for PostgreSQL - Compare and synchronize table definition (thumbnail)

KS DB Merge Tools for PostgreSQL - Automation and Scripting (thumbnail)

KS DB Merge Tools for PostgreSQL - Compare non-table schema objects (thumbnail)

KS DB Merge Tools for PostgreSQL - Compare object definition (thumbnail)

Schema changes summary

Data changes summary

KS DB Merge Tools for PostgreSQL - Compare and synchronize data

KS DB Merge Tools for PostgreSQL Free - Compare and synchronize data

Compare table data

Compare ad hoc query result

KS DB Merge Tools for PostgreSQL - Compare and synchronize table definition

KS DB Merge Tools for PostgreSQL Free - Compare and synchronize table definition

Compare table schema

Automation

KS DB Merge Tools for PostgreSQL - Compare non-table schema objects

KS DB Merge Tools for PostgreSQL Free - Compare non-table schema objects

Compare list of objects

Compare object definition

Free vs Standard

	Free	Standard, perpetual license
Price (USD, excluding VAT):	$0	Single-user personal license:	$80 BUY NOW
		Multi-user license for companies and organizations:	Starting at $105 per user, volume discounts: 5 users: $375 ($75 per user) 10 users: $700 ($70 per user) 20 users: $1200 ($60 per user) BUY NOW
		Payments are handled externally by PayPro Global (Toronto, Canada), transactions are encrypted and secure Includes a one year of free upgrades More about purchasing, license types and discounts
Compare schema and programming objects:	Tables (columns and constraints) ^{merge new only} Views (definition) Stored procedures Functions	Tables (columns, constraints, indexes and triggers) Views (definition and triggers) Materialized views Stored procedures Functions Schemas Sequences Other objects can be compared by querying system metadata
Compare data:	Per table ^{with limitations}	Per table Per view Per materialized view Any table/view/mview vs any other table/view/mview ^{merge only if target updateable} Any custom query result ^{diff only} Batch data diff across multiple tables, views, mviews, custom mappings and custom queries Data slices (customized subset of Batch data diff)
Other Standard features:	N/A	Diff profiles Id-Remap Merge Export to Xlsx and Json Application customization Misc. other enhancements: SSH support, scrollbars colored with changes summary, navigation thru changes, advanced search, etc. More about Standard features
Command line:	For Linux ^{with limitations}	For Linux For Windows Script Editor GUI

Free	Standard, perpetual license
Price (USD, excluding VAT):
$0	Single-user personal license: $80 BUY NOW Multi-user license for companies and organizations: Starting at $105 down to $60 per user BUY NOW More about purchasing and license types
Compare schema and programming objects:
Tables (columns and constraints) ^{merge new only} Views (definition) Stored procedures Functions	Tables (columns, constraints, indexes and triggers) Views (definition and triggers) Materialized views Stored procedures Functions Schemas Sequences Other objects can be compared by querying system metadata
Compare data:
Per table ^{with limitations}	Per table Per view Per materialized view Any table/view/mview vs any other table/view/mview ^{merge only if target updateable} Any custom query result ^{diff only} Batch data diff across multiple tables, views, mviews, custom mappings and custom queries Data slices (customized subset of Batch data diff)
Other Standard features:
N/A	Diff profiles Id-Remap Merge Export to Xlsx and Json Application customization Misc. other enhancements: SSH support, scrollbars colored with changes summary, navigation thru changes, advanced search, etc. More about Standard features
Command line:
For Linux ^{with limitations}	For Linux For Windows Script Editor GUI

If you have any questions, please contact us.