Open files in VS Code and Cursor / Tables and data

Compare two Postgres schemas

To see how two databases differ, for example dev against prod, install Postgres & MySQL Query Client by Zovo, add both connections and run "Compare Two Schemas (Pro)". It writes each schema as a sorted text description, one table per block with columns, types, keys and foreign keys, and opens both in VS Code's diff view, so every added, removed or changed column is marked. It is part of Zovo Pro (USD 19 once) and works 3 times without a key.

Free, MIT license. Extension ID zovo.zovo-sql-client, version 0.2.4. Needs VS Code 1.90.0 or newer.

Also free from Zovo: SQLite Editor & Viewer, VS Code Marketplace · Open VSX (Cursor, Windsurf).

Steps in VS Code

1. Install Postgres & MySQL Query Client from the Marketplace, or press Ctrl+P (Cmd+P on macOS) and run ext install zovo.zovo-sql-client.
2. Add both databases in the SQL Client view: Add Connection, paste the URL, Test connection, Save.
3. Right-click a connection or schema in the SQL Client view and pick "Compare Two Schemas (Pro)", or run it from the Command Palette.
4. Pick the first connection and schema, then the second one.
5. Read the result in VS Code's diff view. F7 jumps to the next change.

Steps in Cursor, Windsurf or VSCodium

1. Open the Extensions view with Ctrl+Shift+X (Cmd+Shift+X on macOS).
2. Search for zovo.zovo-sql-client and click Install. Cursor, Windsurf and VSCodium install from Open VSX, where it is published as zovo/zovo-sql-client.
3. If your editor has no gallery, download the .vsix from the Open VSX page and run "Extensions: Install from VSIX...".
4. Then use it the same way as in VS Code.

What Postgres & MySQL Query Client handles

• Two schemas from any two connections, also two schemas in the same database.
• PostgreSQL, MySQL, MariaDB and SQLite.
• Tables and views with their columns, types, NOT NULL, defaults and primary keys, and every foreign key, sorted by name so the order of creation does not show up as a change.
• A short summary of added, removed and changed tables.

What it does not do

• It shows the differences. It does not write a migration script and does not change either database.
• Indexes, functions, triggers and permissions are not compared. For a view only its columns are compared, not its query.
• PostgreSQL and MySQL compare with each other only as text, so expect type names to differ.

Free and Zovo Pro

Free, and staying free: unlimited connections to PostgreSQL, MySQL, MariaDB and SQLite, the Database Explorer, running SQL, the results grid, row edits, Cancel, and export to CSV, JSON or SQL INSERT.

Zovo Pro adds these tools to Postgres & MySQL Query Client. Each one works 3 times on your computer before it asks for a license. Nothing about Pro shows when you open a file: no popup, no countdown, no banner.

• Explain Plan: the plan of the statement at the cursor as a tree with cost bars, the slowest step marked, and plain hints (a full scan of a filtered table, a sort that spilled to disk, a step with no index, a row estimate 10 times off). Explain Analyze shows the real time and rows per step.
• Table data compare: two tables on any two connections, matched by primary key, with a report and a SQL script that makes the second table match the first. The script is opened, never run for you.
• ER diagram of a schema: tables, columns, keys and foreign-key links. Drag tables to arrange them, then save it as SVG.
• Schema compare: two schemas, from any two connections, side by side in VS Code's diff view.
• CSV import into a table: header names matched to columns, rows inserted in batches of 500.
• Query library: named queries saved on your computer that open on any connection.

Zovo Pro costs USD 19 once. It is not a subscription, and one purchase covers every Zovo VS Code extension. Today it also covers the Pro tools in Hex Viewer and DOCX Viewer, and Pro tools added to other Zovo extensions later.

Two ways to unlock it:

1. GitHub Sponsors: pick the "$19 one time" tier. Then, in VS Code, click a Pro tool and pick "Unlock with GitHub Sponsors" (or type "GitHub Sponsors" in the Command Palette) and sign in with the same GitHub account. A monthly sponsorship of USD 10 or more that is still running counts too.
2. PayPal, no GitHub account needed: send USD 19 by PayPal with "Zovo Pro" in the note, then post the transaction ID with the Zovo Pro key form (a public GitHub issue, so post only the ID). The license key goes to the email address of your PayPal account within a day. Click a Pro tool and pick "I have a license key" (or type "license key" in the Command Palette) and paste it. The key is checked on your computer, with no network call.

A team of 5: USD 59 once by PayPal, with "Zovo Pro Team" in the note. Every rule and every Pro tool is on the Zovo Pro page.

In JetBrains IDEs (IntelliJ IDEA, PyCharm, WebStorm, CLion and others)

• Database Tools and SQL. JetBrains' own database tools, in DataGrip and IntelliJ IDEA Ultimate (a paid IDE). They draw diagrams of a schema and compare two schemas. Zovo has no JetBrains database plugin.
• ERD Editor. Its listing: "Design a database schema visually, without leaving your IDE." 33,131 downloads.

Other options

• Postgres Schema Compare (wcNeo96.postgres-schema-compare, 116 installs, not on Open VSX). Its own description: "Compare, review, and synchronize PostgreSQL schema objects with local SQL files." Not on Open VSX.
• DBML Studio (konyshevav.dbml-studio, 126 installs, not on Open VSX). Its own description: "Diagram, import, and diff DBML schemas: ERD view, import from PostgreSQL, MySQL and SQL Server, live database compare."
• pg_dump and diff. pg_dump --schema-only on both databases and a text diff of the two files works with no extension, but the dumps list objects in an order that adds noise.
• migra, Liquibase or pgAdmin Schema Diff. Command-line and desktop tools that compare PostgreSQL schemas and write the SQL to sync them.

Install counts and Open VSX status were checked on 9 November 2026. Descriptions in quotes are the extensions' own.

Questions

More about Postgres & MySQL Query Client

Read the Postgres & MySQL Query Client page for every feature and setting, or the source code on GitHub.

Related guides

• SQLite Editor & Viewer on the VS Code Marketplace (also on Open VSX). Opens .db and .sqlite files as tables, edits cells and runs SQL.
• Use a PostgreSQL client in VS Code
• Use a MySQL client in VS Code
• See an ER diagram of your database in VS Code
• See a Postgres EXPLAIN plan as a tree in VS Code