PostgresCompare has released 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 introduces several major features aimed at modern development workflows. PostgresCompare connects to two live PostgreSQL databases, detects schema differences across tables, views, functions, indexes, types, and over 30 other object types, and generates a ready-to-run SQL deployment script to synchronize them. It runs on Windows, macOS, and Linux.
Key changes in this release include:
- Rebuilt from the ground up: The application has moved from Electron to Tauri, resulting in a smaller download and lower memory use. The app now updates itself, detecting and installing new versions without manual downloads.
- Redesigned interface: A modern theme, list views for comparisons, spotlight search that reaches projects, connections, and comparison objects from anywhere, keyboard navigation through the difference list, and connection health indicators.
- Database pipelines: New in the 2.x series, enabling streamlined deployment workflows.
- Ad-hoc comparison: Compare databases on the fly without pre-configuring a project.
- Data-change scripting: Generate scripts for data changes, not just schema.
- MCP server for AI agents: An MCP (Model Context Protocol) server that allows AI agents to interact with PostgresCompare.
- Fully translated interface: The UI is now available in multiple languages.
For developers, this release means a faster, more responsive tool that fits better into automated pipelines and AI-assisted workflows. The self-updating mechanism reduces friction, while the new comparison and scripting features save time in schema management. The MCP server opens up possibilities for integrating database comparisons into AI-driven development environments. Overall, PostgresCompare 2.2.0 positions itself as a more modern, efficient solution for PostgreSQL schema management.
Source: https://www.postgresql.org/about/news/postgrescompare-220-released-3382/