@@ changelog @@

Changelog

Track the evolution of PostgresCompare with detailed release notes and version history.

git show v2.2.0 Latest

Version 2.2.0

Released August 21st, 2026

+ added

Pipelines

  • Multi-stage comparison pipelines — Chain comparisons together and run them as a single pipeline, with results streaming in live as each stage completes.
  • Visual pipeline diagram — View a pipeline as an interactive graph. Each connection between stages shows a summary of what changed, and you can re-run a single stage directly from its diagram edge without restarting the whole pipeline.
+ added

New Features

  • Multi-language interface — PostgresCompare is now available in Chinese, Hindi, Spanish, French and German, with a language switcher in the sidebar.
  • Linux support — PostgresCompare is now available as an official Linux build, alongside Windows and macOS.
  • Parallel connections per project — Run schema and data comparisons against multiple connections in parallel within the same project.
  • "Used by" on connections — See which projects, data projects and pipelines depend on a connection before you edit or delete it.
  • Diagnostic logging — Turn on verbose logging and open the log folder directly from the app menu, making it faster to get support when something goes wrong.
~ changed

Improvements

  • Refreshed interface — A modernized theme, spotlight search, and restyled modals, buttons, sidebar and script windows across the app. "Environments" has been renamed to "Connections" throughout.
  • Redesigned comparison views — The schema comparison view, data comparison view, and Data Projects section have all been modernized for clarity.
  • Live progress everywhere — Comparisons, pipeline runs and deployments now show live progress as they happen instead of refreshing periodically, for smoother and more immediate feedback.
  • More reliable deployment ordering — Deployment scripts now correctly order many more object types relative to each other, including collations, exclusion constraints, operators, casts, event triggers, publications and extensions.
  • Faster comparisons — Script generation and large schema comparisons complete noticeably faster.
- fixed

Bug Fixes

  • Fixed array-column data comparisons producing incorrect results on wide tables
  • Fixed incorrect argument type rendering in generated CREATE FUNCTION statements
  • Fixed index sort direction (DESC / NULLS ordering) not being preserved when scripted
  • Fixed the licence dialog overflowing on long licence keys
  • Fixed an error (SQLSTATE 42704) when deploying changes to array-typed columns
  • Fixed a blank "New script" window appearing when a comparison had no changes
  • Fixed SQL-file comparison sources not generating deployable DDL
  • Fixed materialized view drop ordering when other objects depended on it
  • Fixed functions and tables incorrectly reported as missing due to a catalog identifier collision
  • Fixed "Create scripts folder" hanging on objects with symbol characters in their names
Download Version 2.2.0
git show v1.2.2

Version 1.2.2

Released April 7th, 2026

+ added

MCP Server for AI Agent Integration

  • Model Context Protocol Support (pgc mcp serve) — PostgresCompare now integrates directly with AI coding assistants like Claude Desktop and Claude Code. Run pgc mcp serve to start a stdio JSON-RPC server that exposes your PostgreSQL environments to AI agents for schema exploration, comparison, and migration generation.
  • 10 MCP Tools Available — AI agents can use list_environments, compare_schemas, generate_migration, get_schema, health_check, validate_sql, apply_migration, create_snapshot, detect_drift, and explain_difference.
  • Production Safety Controls — Use --read-only to prevent any write operations, or --allowed-envs to restrict which environments the AI can access. The apply_migration tool respects environment-level read-only settings and supports --max-drops / --max-statements guardrails.
+ added

Data Comparison Enhancements

  • Redesigned Data Comparison View — A new horizontal three-panel layout with a compact table sidebar, row grid with status filter badges, and a slide-up row detail drawer for side-by-side value comparison.
  • Overview Dashboard — A new Overview tab shows summary statistics with an interactive donut chart for row status distribution and a horizontal bar chart highlighting tables with the most differences.
  • Data Script Generation — Generate INSERT, UPDATE, and DELETE scripts directly from data comparison results. Select which row changes to include and export a ready-to-run SQL migration script.
  • CSV Per-Table Export — Export data comparison results to CSV on a per-table basis for further analysis or reporting.
  • Star / Favourite Tables — Mark frequently compared tables with a star for quick filtering.
~ changed

CLI Improvements

  • License Activation Command — Use pgc license activate <key> to activate your license directly from the command line without needing the desktop app.
  • Configuration File Settings Apply Everywhere — Comparison settings defined in pgc.yaml now correctly apply to the script and report commands, not just diff.
- fixed

Bug Fixes

  • Fixed partition detection to use relispartition instead of pg_inherits, eliminating false positives on inherited tables that are not partitions
  • Fixed the Update SQL tab not showing content in certain comparison scenarios
  • Fixed foreign key constraint scripting when adding new tables via the WebApplication script creator
  • Fixed CLI license file detection on Windows when the license was stored in a non-default location
  • Fixed data comparison row panel and drawer rendering issues
  • Fixed excessive Sentry error logging in both CLI and desktop builds
git show v1.2.1

Version 1.2.1

Released March 31st, 2026

+ added

New Command-Line Interface (CLI)

  • Full-Featured CLI (pgc) — A powerful new CLI for schema comparison, script generation, and automation. All major features of the desktop app are now available in the terminal, designed for both interactive use and CI/CD integration.
  • Advanced Script Generation (pgc script) — Generate dependency-ordered, transactional deployment scripts directly from the command line. Supports pre/post deployment scripts, migration direction control, and dry-run checks.
  • New Data Sources (Git Refs & Folders) — Compare against schema files directly from any Git branch, tag, or commit (e.g., git:main:schema.sql). You can also now use a folder of .sql files as a single data source.
  • Interactive Mode (pgc interactive) — A new terminal UI for interactively exploring schema differences in a tree view, with keyboard shortcuts for easy navigation.
  • Schema Documentation (pgc docs) — Generate schema documentation in Markdown or HTML format from any data source.
  • Watch Mode (pgc watch) — Monitor a database for schema drift against a baseline, with the ability to trigger a command on change.
  • Configuration Files (pgc.yaml) — Manage project-level settings for environments, default comparison options, and script generation. Use pgc config init to get started.
  • Apply Scripts Safely (pgc apply) — Apply migration scripts to a database with built-in safety features: explicit --confirm flag required, --dry-run validation, --max-drops and --max-statements guardrails, and read-only environment protection.
  • Rich Comparison Reports (pgc report) — Generate standalone HTML reports (with dark mode support), Markdown summaries, or JSON reports. Optionally include the full migration script with --include-script.
  • Multi-Target Validation (pgc validate) — Validate SQL scripts, configuration files, database connections, or snapshot files with a single command. Checks for dangerous statements, unbalanced transactions, and connectivity issues.
  • Health Checks (pgc health) — Check database connectivity and CLI health. Use --all-envs to verify all configured environments at once — ideal for CI/CD pipeline pre-flight checks.
~ changed

CLI Improvements

  • Comprehensive Object Support — The CLI now supports comparison and scripting for over 40 PostgreSQL object types, including FDWs, Publications, Subscriptions, and more, achieving parity with the desktop app.
  • CI/CD Friendly Output Formats — New output formats like JUnit XML (--format junit) and GitHub Actions annotations (--format github) are available for seamless pipeline integration.
  • Advanced Filtering — Use wildcard patterns to include or exclude specific objects from a comparison (e.g., --include 'users_*,orders_*').
  • Environment Management — pgc profile has been renamed to pgc env for consistency. The @ prefix is now optional for better PowerShell compatibility.
  • Clean SQL Output — Using --sql or --format sql suppresses the license banner and progress indicators, so pgc diff ... --sql > migration.sql produces clean, pipeable output.
- fixed

Bug Fixes

  • Fixed snapshot JSON serialization/deserialization losing constraints due to array handling with PreserveReferencesHandling
  • Fixed --only type normalization (e.g. tables is now correctly normalized to table)
  • Fixed false positives when comparing databases with partitioned tables — constraints on partition child tables are now excluded from comparisons
git show v1.2.0

Version 1.2.0

Released March 23rd, 2026

+ added

New Features

  • pg_dump / SQL file import — Compare one or both sides of a comparison against a pg_dump file or folder instead of a live database connection. PostgresCompare accepts plain SQL pg_dump output and binary pg_dump format (automatically converted via pg_restore if it is on your PATH). You can also point to a folder containing multiple SQL files. This is useful for auditing schema definitions stored in version control, comparing a snapshot against a live database, or working in environments where a direct connection is not available
  • Comparison options saved per result — The ignore flags, object type filters, name filters, and pre/post deploy script settings that were active when a comparison ran are now stored with the result. Click the info icon next to the Re-run comparison button to see exactly which options produced a given result
~ changed

Improvements

  • History viewer timeline — The schema history view has been redesigned as a vertical timeline with colour-coded indicator dots, relative timestamps (e.g. "2 hours ago"), and automatic selection of the most recent entry. The Monaco diff editor now shows the correct direction (older version on the left, newer on the right) and labels each side with its date. For objects that were created or deleted, a single editor with a contextual banner is shown instead of a blank diff panel
  • Changes tab in history viewer — A Changes tab alongside the diff panel gives a plain-English description of what changed for each object between the two selected history entries
  • Column reorder migration — PostgresCompare now detects when table columns have changed position and generates a safe migration using CREATE TABLE / INSERT INTO / DROP / RENAME with full constraint reconstruction (primary keys, unique constraints, check constraints, and foreign keys)
  • Column scale detection — Scale differences in numeric columns are now detected and generate ALTER COLUMN TYPE statements
  • Scrollable deployment progress log — The deployment progress log in the Run Script modal is now a scrollable, multi-line display that accumulates RAISE NOTICE output as each statement executes. The progress logging preference is saved per project in local storage
git show v1.1.107

Version 1.1.107

Released March 16th, 2026

+ added

New Features

  • Changes tab — A new Changes tab sits alongside the SQL diff view and shows a human-readable summary of what changed: which columns were added or removed, which constraints were modified, and so on. Switch between the Changes tab and the SQL view depending on whether you want a plain-English summary or the full DDL comparison
  • Deployment progress logging — Generated scripts now include timestamped RAISE NOTICE statements after each DDL change (e.g. [✓] 14:23:05 | public.users | alter table) and a [>>] Migration complete at … notice at the end. Progress output is visible in any client — psql, DataGrip, or similar — and NOTICE output is captured and displayed in the in-app deployment modal. The toggle is on by default and can be disabled from the script toolbar; notices follow statement selection so deselecting a change also removes its notice
  • Name filters — Each object type in the comparison list now has its own name filter. Type to show only objects whose names match within that type — for example, showing only tables containing "order" — without affecting other object types in the list
  • Create database — PostgresCompare can now create a new PostgreSQL database directly from within the app. Open an environment and click Create database to create a database on that server without leaving the app
~ changed

Improvements

  • Diff editor: navigator and word wrap — The SQL diff editor now includes a navigator panel listing each changed section for quick jumping, and a word wrap toggle in the toolbar for long lines such as function bodies
  • Cleaner object list — Value columns have been removed from the comparison list and the schema column is collapsed by default, giving more room for object names and making the list easier to scan
git show v1.1.106

Version 1.1.106

Released March 8th, 2026

+ added

New Features

  • Star / favourite comparisons — Mark comparisons as favourites by clicking the star icon on a comparison tile. Starred comparisons show an amber star and can be filtered to the top of the list with a single click on the toolbar toggle
  • Deploy confirmation dialog — Clicking "Run script…" now shows a confirmation modal displaying the target connection and database before executing. Destructive statements are highlighted in red and warnings in amber, and the Run button itself turns red when the script contains destructive changes
  • Export reports — Export comparison results in multiple formats: Excel (with a doughnut-chart summary sheet), HTML (with clickable status filter pills and sortable columns), PDF, JSON, Markdown, and CSV. Filenames default to the database names and date (e.g. devDb_vs_prodDb_2026-03-08.xlsx). A companion .schema.json is written alongside JSON exports for CI/CD validation. The export options modal defaults "Identical" objects to unchecked
~ changed

Improvements

  • Pre/post deploy scripts in statement list — Pre- and post-deploy scripts now appear as entries in the deployment statement list with include/exclude checkboxes. Section headers and dependency comments are suppressed automatically when their associated change is excluded, and the deployment execution matches exactly what the list shows
  • Faster script generation — The dependency-ordering algorithm has been replaced with Kahn's O(V+E) topological sort, eliminating the previous O(n³) approach. The script page now shows shimmer skeleton loaders on both panels while the draft is being generated
  • Cleaner script section headers — Drop operations now use the same "Type name" heading format as creates. Indexes, triggers, and policies each get their own per-item section header rather than being grouped under a parent table heading
- fixed

Bug Fixes

  • Fixed "Select all" / "Deselect all" not toggling pre/post deploy scripts
  • Fixed syntax errors when a column, index, or other identifier is named a PostgreSQL reserved keyword (e.g. order)
  • Fixed aggregate scripting to include the argument type in CREATE AGGREGATE and ALTER AGGREGATE statements
  • Fixed deployment script ordering for materialized views, corrected index expression parsing for multi-argument expressions such as COALESCE(a, b), and fixed character[] function arguments being rendered as haracter []
  • Fixed the Monaco diff editor failing to initialise in the comparison history viewer
  • Fixed a false "stale comparison" warning appearing when it should not
git show v1.1.105

Version 1.1.105

Released March 2nd, 2026

+ added

New Features

  • Re-run comparison — Run a fresh comparison directly from the comparison detail view without navigating away. Results stream in live, and the previous comparison is preserved in the history list
  • Comparison history swimlane view — Track how your schema has changed over time with a new grouped history view. Objects are organised by change category (Fixed, Regressed, New, Removed, Changed, Unchanged) with collapsible sections, count badges, and colour-coded borders
  • Related object navigation — When viewing a difference, clickable chips appear showing dependencies ("Depends on") and reverse references ("Referenced by") for the selected object, colour-coded by their comparison status. Clicking a chip jumps straight to that object in the list
  • SQL line highlighting — Clicking a child row (column, constraint, or property) in the differences list now scrolls the diff editor to and highlights the exact line of SQL for that sub-object
  • Auto-fetch databases and schemas — Databases load automatically when a connection is selected, and schemas load when a database is chosen. The environment dropdowns have been replaced with styled Bootstrap menus matching the rest of the app
  • Delete comparison confirmation — Deleting a comparison now shows a confirmation dialog. The tile fades out on confirm to give clear visual feedback
~ changed

Improvements

  • Redesigned Overview tab — Replaced the text summary with five clickable stat cards (Total, Identical, Different, New, Dropped). Chart segments are now interactive — clicking navigates to the Objects tab with the relevant filter applied. The tab has been renamed from "Summary" to "Overview"
  • Save script respects your selection — The saved .sql file now matches exactly what would be deployed, correctly applying any statements you have deselected
  • Faster startup — The app loads noticeably faster through parallel API calls on launch and deferred loading of the Monaco editor (~2.5 MB removed from the critical path)
- fixed

Bug Fixes

  • Fixed deployment executing the wrong statements when some script entries were deselected
  • Fixed save script failing silently on API error — an error dialog is now shown
  • Fixed the comparison toolbar scrolling out of view
  • Fixed the licence modal layout where the machine ID was overlapping the activation status indicator
git show v1.1.104

Version 1.1.104

Released February 23rd, 2026

+ added

New Features

  • Pre/post deploy scripts — Add custom SQL that runs before or after the generated deployment script, editable directly in the app using Monaco editor
  • Global search — Search across projects, environments, and comparison objects from anywhere in the app
  • Keyboard navigation in the difference list — Use arrow keys to move through differences without the mouse
  • Dependency cascade selection — Selecting a script statement automatically selects its dependencies
~ changed

Improvements

  • Redesigned comparison card with progress bars and a breakdown of difference types
- fixed

Bug Fixes

  • Fixed comparison panel overflowing the bottom of the screen
  • Fixed arrow key expand/collapse for tree rows
  • Fixed auto-updater crash on update errors
git show v1.1.103

Version 1.1.103

Released February 18th, 2026

+ added

New Features

  • Destructive change warnings — Deployment scripts now highlight dangerous statements before you run them. Statements are classified as Destructive (e.g. DROP TABLE, DROP COLUMN) or Warning (e.g. DROP FUNCTION, DROP VIEW), with colored row styling, warning icons, summary banners, and glyph margin indicators in the SQL editor
  • Hover to preview differences — Hovering over a row in the script statement list shows a floating diff popover so you can inspect the before/after SQL without leaving the screen
  • Deployment script section headers — Generated scripts now group statements by object type (Tables, Views, Types, Sequences, Column Changes, Constraints, Indexes, Functions, Materialized Views, Triggers, Policies, Privileges, Drop Objects). Section headers are clickable in the statement list, and a script header shows the version, source/target database names, and timestamps. Dependency comments explain ordering for dependency-sorted objects
- fixed

Bug Fixes

  • Select all now only toggles rows visible after filtering, and the header checkbox accurately reflects the current selection state
  • Filter dropdowns no longer lose their selected value on re-render
  • Filter counts exclude section header rows
git show v1.1.102

Version 1.1.102

Released February 7th, 2026

+ added

New Features

  • Added option to ignore column statistics differences - useful when source and target databases have different ANALYZE settings
git show v1.1.101

Version 1.1.101

Released January 18th, 2026

- fixed

Bug Fixes

  • Fixed PostgreSQL 18 compatibility by removing deprecated attcacheoff column from queries
  • Fixed compatibility issue with PostgreSQL 17's new MAINTAIN privilege
git show v1.1.100

Version 1.1.100

Released July 1st, 2024

~ changed

Improvements

  • Removed heading from difference viewer for cleaner UI
git show v1.1.99

Version 1.1.99

Released June 24th, 2024

- fixed

Bug Fixes

  • Fixed bug where PostgresCompare was not ignoring tablespace differences in indexes
git show v1.1.98

Version 1.1.98

Released May 8th, 2024

- fixed

Bug Fixes

  • Fixed bug where PostgresCompare was failing to fetch the version number of PostgreSQL databases on Linux or MacOS
git show v1.1.97

Version 1.1.97

Released May 6th, 2024

~ changed

Improvements

  • Updated .NET Core to v8
  • Refreshed the UI on the schema comparisons list
git show v1.1.94

Version 1.1.94

Released April 1st, 2024

- fixed

Bug Fixes

  • Fixed bug where PostgresCompare would attempt to read a now removed field from pg_database
git show v1.1.93

Version 1.1.93

Released March 22nd, 2024

+ added

New Features

  • Support variadic function arguments
git show v1.1.91

Version 1.1.91

Released July 30th, 2022

~ changed

Improvements

  • Quote the object name fields when generating a CSV report
git show v1.1.90

Version 1.1.90

Released July 28th, 2022

~ changed

Improvements

  • Add owner to CREATE sql for Materialized View
git show v1.1.89

Version 1.1.89

Released July 7th, 2022

- fixed

Bug Fixes

  • Fix blank window issue on macOS
git show v1.1.88

Version 1.1.88

Released June 22nd, 2022

- fixed

Bug Fixes

  • Fix escaping of CSV report
git show v1.1.87

Version 1.1.87

Released November 15th, 2021

- fixed

Bug Fixes

  • Fixed comparison of Casts
  • Added :: cast notation when changing data type of a column
  • Fixed filtering of tables to schema for data projects
git show v1.1.86

Version 1.1.86

Released October 5th, 2021

- fixed

Bug Fixes

  • Fixed navigation and display of data projects
git show v1.1.85

Version 1.1.85

Released September 22nd, 2021

+ added

New Features

  • Added comparison of Configuration Parameters
git show v1.1.84

Version 1.1.84

Released September 13th, 2021

+ added

New Features

  • Added history view
git show v1.1.83

Version 1.1.83

Released August 5th, 2021

- fixed

Bug Fixes

  • Fix comparison of partitions when comparing single schemas
git show v1.1.82

Version 1.1.82

Released July 31st, 2021

~ changed

Improvements

  • Ignore differing schema names when comparing single schemas
git show v1.1.80

Version 1.1.80

Released June 20th, 2021

+ added

New Features

  • Compare and deploy table partitions
- fixed

Bug Fixes

  • Fix bug deploying timestamp vs timestamp(0) differences
git show v1.1.79

Version 1.1.79

Released June 13th, 2021

~ changed

Improvements

  • Ensure that adding a column comes before adding a foreign key
git show v1.1.78

Version 1.1.78

Released June 4th, 2021

- fixed

Bug Fixes

  • Resolve issue comparing domains
git show v1.1.76

Version 1.1.76

Released June 2nd, 2021

- fixed

Bug Fixes

  • Resolve 'keynotfound' issue with data comparison
  • Resolve 'keynotfound' issue with schema comparison
git show v1.1.75

Version 1.1.75

Released May 31st, 2021

~ changed

Improvements

  • Performance improvements, filtering by schema
git show v1.1.74

Version 1.1.74

Released May 2nd, 2021

+ added

New Features

  • Index include columns
  • Index column operator class names
- fixed

Bug Fixes

  • Fix issue where an index implementing a fk constraint was being excluded
  • Fix ordering of deployment script when DROP/CREATE a view
git show v1.1.71

Version 1.1.71

Released April 2nd, 2021

+ added

New Features

  • Compare range types
  • Store and recover window state between launches
  • Include extensions when comparing single schemas
git show v1.1.69

Version 1.1.69

Released March 22nd, 2021

+ added

New Features

  • Add sample project option
  • Add ignore default arguments option
git show v1.1.68

Version 1.1.68

Released March 15th, 2021

+ added

New Features

  • Grant/Revoke privileges in deploy script
  • Show script folder progress
  • Add a description for a project
git show v1.1.67

Version 1.1.67

Released March 8th, 2021

~ changed

Improvements

  • Sort differences with identical last
  • Added edit project button
  • Add view dependency planning
git show v1.1.66

Version 1.1.66

Released March 1st, 2021

+ added

New Features

  • Add remaining object types to scripts folder creation
- fixed

Bug Fixes

  • Fix issue comparing check constraint definitions between postgres versions
git show v1.1.65

Version 1.1.65

Released February 22nd, 2021

+ added

New Features

  • Added first pass at scripts folder creation
git log --oneline

Older versions

Prior releases

~ changed

Historical Releases

  • v1.1.64 - Fix data compare issue, sort schemas alphabetically
  • v1.1.63 - Add scripting of owner of sequences, enums, domains and aggregates
  • v1.1.61 - Add comparison of Aggregates, new dependency calculation
  • v1.1.60 - Add comparison of privileges for functions, views, sequences, schemas
  • v1.1.59 - Fixed test connection feedback
  • v1.1.58 - Improved comparison performance, fixed v12 WHEN clause issue
  • v1.1.57 - Add comparison of privileges
  • v1.1.52 - Fix data compare 'Sequence contains no elements'
  • v1.1.51 - Fix deployment of CREATE POLICY, added altered primary key
  • v1.1.50 - Fix title bar on MacOS, improve query performance
  • v1.1.49 - Fix export report/save script, DROP POLICY, CREATE PUBLICATION
  • v1.1.48 - Fix frozen UI issue, add new onboarding
  • v1.1.47 - Detect differences in partition by clause, include CLI
  • v1.1.46 - Fix Citus tables being ignored, UI refactoring
  • v1.1.42 - Fix data compare issues, persist filter on projects list
  • v1.1.41 - Add environment variables, comments on Domain, Composite Type, MView
  • v1.1.40 - Add CSV report, improved keyboard navigation
  • v1.1.39 - Fix comparing views, procedure signature, NOT NULL scripting
  • v1.1.38 - Remove Easter Egg, fix OnUpdate, ReturnsSet properties
  • v1.1.35 - Improve performance, fix argument defaults, UI responsiveness
  • v1.1.34 - Add data compare beta
  • v1.1.33 - Fix deploying column comments, refactor options
  • v1.1.32 - Deploy precision differences
  • v1.1.31 - UI improvements, fix column name escaping, expression index parsing
  • v1.1.30 - UI improvements, add 'ignore column order' option
  • v1.1.28 - Deploy serial datatype changes, support v9.3
  • v1.1.27 - Deploy identity column differences
  • v1.1.16 - Add PostgreSQL 12 support
  • v1.0.45 - Added licensing
  • v1.0.0-alpha - Initial release (March 14th, 2018)