Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x8pQa-00000001Wt3-0VGu for pgsql-announce@arkaria.postgresql.org; Tue, 22 Sep 2026 01:36:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x8pQX-0000000CQjk-4Bf9 for pgsql-announce@arkaria.postgresql.org; Tue, 22 Sep 2026 01:36:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x8pQW-0000000CQiw-2hRZ for pgsql-announce@lists.postgresql.org; Tue, 22 Sep 2026 01:36:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x8pQS-00000000aX6-2ay0 for pgsql-announce@lists.postgresql.org; Tue, 22 Sep 2026 01:36:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=ISjaZ90xbXPA7UPaELeCpz4q2iSXeDvYFAaYv/8JALw=; b=QKJYmUz4hvzYfMSqs1G0tHnYik PS+yL/uuG6v0A4DYYWOFCttX3Jf9P1pv8QnvyUa6gIYO59Lrq3J0jFdaf3zdlEgbnoqM089T4kGpi 3QnzIZ43dglLPxAFeEGDZQkeExJrHahkw1l9CmhAOHY4TC9ec8Z0vS9rEqxEiZ3XgIHclC2Y0FsQU 7tyu1IYBxH+dPbHqnlW75XI7xw6EMrapb1nJ//1Z7w1PqJvgQZ8VBuFlehncGAXuynkwDV+cYJ7it hsgVp3XrLOo6/t/82dyLFTScBabbjIb99kbKnaSH8ggkV3uIo8FyJoxpOWJDNt991FOtUBVuR83GV 71tQC4KQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x8pQS-001pZh-2Q for pgsql-announce@lists.postgresql.org; Tue, 22 Sep 2026 01:36:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x8pQQ-00000004rzN-3lG3 for pgsql-announce@lists.postgresql.org; Tue, 22 Sep 2026 01:36:03 +0000 Content-Type: multipart/alternative; boundary="===============5044325172007938591==" MIME-Version: 1.0 Subject: PostgresCompare 2.2.0 Released To: PostgreSQL Announce From: PostgresCompare via PostgreSQL Announce Reply-To: neil@postgrescompare.com Date: Tue, 22 Sep 2026 01:35:59 +0000 Message-ID: <179004095972.1026196.6417792169683839697@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: proprietary X-pglister-tagsig: a37196ef958bfac3a56d234b35d4d67f0e6f6f217bd3775498552112ea968357 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5044325172007938591== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable [PostgresCompare](https://www.postgrescompare.com) is pleased to announce t= he release of version 2.2.0, the first public release since 1.2.2 and the l= argest 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 compa= rison, data-change scripting, an MCP server for AI agents, and a fully tran= slated interface. [PostgresCompare](https://www.postgrescompare.com) connects to two live Po= stgreSQL databases, detects schema differences across tables, views, functi= ons, indexes, types, and 30+ other object types, and generates a ready-to-r= un SQL deployment script to synchronise them. It runs on Windows, macOS, an= d Linux. Rebuilt from the ground up - A new application foundation =E2=80=94 [PostgresCompare](https://www.po= stgrescompare.com) has moved from Electron to Tauri. The download is smalle= r, memory use is lower, and the application now updates itself: new version= s are detected and installed without a manual download. - A redesigned interface =E2=80=94 The application has been restyled thro= ughout, with a modern theme, list views for comparisons, a spotlight search that reaches projects, connections and comparison obje= cts from anywhere, keyboard navigation through the difference list, and connection health indicators. Environments were re= named Connections to match how people describe them. - Six languages =E2=80=94 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 =E2=80=94 Model a whole environment chain =E2=80=94 developme= nt, test, staging, production =E2=80=94 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 =E2=80=94 Compare two databases without creating a projec= t first. Choose two connections, set the comparison options, and run. Intended for one-off checks that do not warrant a saved projec= t. - A demo database =E2=80=94 A first-run option creates a sample project w= ith two deliberately diverging schemas, so the comparison and deployment workflow can be explored before connecting to a real dat= abase. Data comparison and scripting Data comparison gained a scripting engine. Differences between table cont= ents can be turned into a SQL script, with row-level selection so only the chosen rows are included, and the script panel high= lights 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 =E2=80=94 pgc mcp serve runs PostgresCompare as a Model Cont= ext Protocol server, so an AI agent can compare schemas, detect drift, generate and apply migrations, read a schema, take snapsh= ots, explain an individual difference and run health checks through a defined tool interface. A read-only mode disables ever= y tool that writes. - Export a schema to files =E2=80=94 pgc scripts-folder exports a databas= e to a folder of .sql files, one per object, suitable for checking a schema into version control. Under the hood - Parallel connections =E2=80=94 Projects can read each database over sev= eral connections at once, shortening both schema snapshots and data comparisons on large databases. - Faster large comparisons =E2=80=94 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 =E2=80=94 Deployment scripts preserve DESC and NUL= LS FIRST/LAST ordering on index columns. - Function argument types =E2=80=94 CREATE FUNCTION arguments retain thei= r schema qualification and array notation. - Diagnostic logging =E2=80=94 Optional verbose logging to a file, with a= menu item that opens the log folder, making support issues easier to report. Availability [PostgresCompare](https://www.postgrescompare.com) 2.2.0 is available for= Windows, macOS (Apple Silicon and Intel) and Linux (AppImage and .deb). Th= e pgc command-line tool ships for all three platforms. Users on 1.2.2 upgrade b= y downloading 2.2.0 directly; from 2.x onward the application updates itself. A 14-day free trial is available with no cred= it card required, and when a trial ends, quick compare and connection management remain available without a licence. Pos= tgreSQL versions 9.2 through 18 are supported. - [Download PostgresCompare 2.2.0](https://www.postgrescompare.com/downlo= ads) - [Full release notes](https://www.postgrescompare.com/release-notes) --===============5044325172007938591== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable PostgresCompare 2.2.0 Released
 

PostgresCompare 2.2.0 Released

PostgresCompare i= s pleased to announce the release of version 2.2.0, the first public releas= e since 1.2.2 and the largest change in the product's history. The applicat= ion 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 a= gents, and a fully translated interface.

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

Rebuilt from the ground up

  • A new applicati= on foundation =E2=80=94 PostgresCompare has mov= ed from Electron to Tauri. The download is smaller, memory use is lower, an= d the application now updates itself: new versions are detected and install= ed without a manual download.
  • A redesigned in= terface =E2=80=94 The application has been restyled throughout, with a mode= rn theme, list views for comparisons, a spotlight search that reaches projects, connections and comparison obje= cts from anywhere, keyboard navigation through the difference list, and connection health indicators. Environments were re= named Connections to match how people describe them.
  • Six languages = =E2=80=94 The interface, including the native application menu, is translat= ed into English, Chinese, Hindi, Spanish, French and German, switchable from the sidebar.

New ways to compare

  • Pipelines =E2= =80=94 Model a whole environment chain =E2=80=94 development, test, staging= , production =E2=80=94 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 = =E2=80=94 Compare two databases without creating a project first. Choose tw= o connections, set the comparison options, and run. Intended for one-off checks that do not warrant a saved projec= t.
  • A demo database= =E2=80=94 A first-run option creates a sample project with two deliberatel= y diverging schemas, so the comparison and deployment workflow can be explored before connecting to a real dat= abase.

Data comparison and scripting

Data comparison gained a scripting engine. = Differences between table contents can be turned into a SQL script, with ro= w-level selection so only the chosen rows are included, and the script panel high= lights 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 =E2= =80=94 pgc mcp serve runs PostgresCompare as a Model Context Protocol serve= r, so an AI agent can compare schemas, detect drift, generate and apply migrations, read a schema, take snapsh= ots, explain an individual difference and run health checks through a defined tool interface. A read-only mode disables ever= y tool that writes.
  • Export a schema= to files =E2=80=94 pgc scripts-folder exports a database to a folder of .s= ql files, one per object, suitable for checking a schema into version control.

Under the hood

  • Parallel connec= tions =E2=80=94 Projects can read each database over several connections at= once, shortening both schema snapshots and data comparisons on large databases.
  • Faster large co= mparisons =E2=80=94 Comparisons containing thousands of objects open substa= ntially faster, and deployment script generation now builds SQL directly rather than through an intermediate = syntax tree.
  • Index sort dire= ction =E2=80=94 Deployment scripts preserve DESC and NULLS FIRST/LAST order= ing on index columns.
  • Function argume= nt types =E2=80=94 CREATE FUNCTION arguments retain their schema qualificat= ion and array notation.
  • Diagnostic logg= ing =E2=80=94 Optional verbose logging to a file, with a menu item that ope= ns 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 b= y downloading 2.2.0 directly; from 2.x onward the application updates itself. A 14-day free trial is available with no cred= it card required, and when a trial ends, quick compare and connection management remain available without a licence. Pos= tgreSQL versions 9.2 through 18 are supported.
This email was sent to you from PostgresCompare. It was delivered on their = behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to PostgresCompare.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Proprietary. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============5044325172007938591==--