PostgresCompare 2.2.0 Released

PostgresCompare is pleased to announce the release of version 2.2.0, the first public release since 1.2.2 and the largest change in the product's history. The application has been rebuilt on a new foundation, and the 2.x series adds database pipelines, ad-hoc comparison, data-change scripting, an MCP server for AI agents, and a fully translated interface.

PostgresCompare connects to two live PostgreSQL databases, detects schema differences across tables, views, functions, indexes, types, and 30+ other object types, and generates a ready-to-run SQL deployment script to synchronise them. It runs on Windows, macOS, and Linux.

Rebuilt from the ground up

• A new application foundation — PostgresCompare has moved from Electron to Tauri. The download is smaller, memory use is lower, and the application now updates itself: new versions are detected and installed without a manual download.
• A redesigned interface — The application has been restyled throughout, with a modern theme, list views for comparisons, a spotlight search that reaches projects, connections and comparison objects from anywhere, keyboard navigation through the difference list, and connection health indicators. Environments were renamed Connections to match how people describe them.
• Six languages — The interface, including the native application menu, is translated into English, Chinese, Hindi, Spanish, French and German, switchable from the sidebar.

New ways to compare

• Pipelines — Model a whole environment chain — development, test, staging, production — and run every comparison in it from one place. Comparisons are explicit edges between environments, so hub-and-spoke and matrix topologies are supported as well as straight chains. A graph canvas draws the pipeline, shows each comparison's result on its edge, and allows any comparison to be re-run from the diagram.
• Quick compare — Compare two databases without creating a project first. Choose two connections, set the comparison options, and run. Intended for one-off checks that do not warrant a saved project.
• A demo database — A first-run option creates a sample project with two deliberately diverging schemas, so the comparison and deployment workflow can be explored before connecting to a real database.

Data comparison and scripting

Data comparison gained a scripting engine. Differences between table contents can be turned into a SQL script, with row-level selection so only the chosen rows are included, and the script panel highlights the row under the cursor as you work through it. Comparison results can also carry notes, so the reason for a decision stays with the comparison.

Automation and AI agents

• MCP server — pgc mcp serve runs PostgresCompare as a Model Context Protocol server, so an AI agent can compare schemas, detect drift, generate and apply migrations, read a schema, take snapshots, explain an individual difference and run health checks through a defined tool interface. A read-only mode disables every tool that writes.
• Export a schema to files — pgc scripts-folder exports a database to a folder of .sql files, one per object, suitable for checking a schema into version control.

Under the hood

• Parallel connections — Projects can read each database over several connections at once, shortening both schema snapshots and data comparisons on large databases.
• Faster large comparisons — Comparisons containing thousands of objects open substantially faster, and deployment script generation now builds SQL directly rather than through an intermediate syntax tree.
• Index sort direction — Deployment scripts preserve DESC and NULLS FIRST/LAST ordering on index columns.
• Function argument types — CREATE FUNCTION arguments retain their schema qualification and array notation.
• Diagnostic logging — Optional verbose logging to a file, with a menu item that opens the log folder, making support issues easier to report.

Availability

PostgresCompare 2.2.0 is available for Windows, macOS (Apple Silicon and Intel) and Linux (AppImage and .deb). The pgc command-line tool ships for all three platforms. Users on 1.2.2 upgrade by downloading 2.2.0 directly; from 2.x onward the application updates itself. A 14-day free trial is available with no credit card required, and when a trial ends, quick compare and connection management remain available without a licence. PostgreSQL versions 9.2 through 18 are supported.

• Download PostgresCompare 2.2.0
• Full release notes