pgquarrel
github.com
- Free plan
- Windows
- Linux
- Self-hosted
What pgquarrel is
pgquarrel compares PostgreSQL database schemas and generates SQL commands to bring a target schema into line with a source. It connects directly to PostgreSQL servers and reads catalog metadata. Its main described use is deploying database changes to testing, staging, or production environments. Filters let users select object types and include or exclude schemas by pattern. Output goes to stdout by default, with options to write it to a file, print a summary, or make the changes a single transaction. pgquarrel does not manipulate table data with INSERT, UPDATE, DELETE, or COPY operations. Its documented object coverage is mixed: some types are fully supported and others only partially supported. Inheritance and roles are among the stated omissions, and it does not cover every PostgreSQL object. Generated SQL may not work as expected when the source PostgreSQL version is newer than the target. The free, BSD-3-Clause licensed software is distributed as source through GitHub and supports Linux, Windows, and self-hosting.
Who it suits
pgquarrel suits PostgreSQL administrators who need to compare schemas and prepare changes for deployment across environments. It is less suited to workflows that require every PostgreSQL object or changes to table data.
Good to know, and what to watch
- Connects directly to PostgreSQL servers.
- Filters can select object types and schemas.
- Can output changes as a single transaction.
- Free and BSD-3-Clause licensed.
- Inheritance and roles are not supported.
- Some PostgreSQL object types have partial support.
- Newer source versions may yield unexpected output.
Plans
Every plan and pricepgquarrel
Free plan
Getting started
- Open the pgquarrel GitHub repository
- Clone the Git repository or obtain its source code
- Connect pgquarrel directly to the PostgreSQL servers
- Select object types and schema patterns to compare
- Send generated changes to stdout, a file, or one transaction
Limits to check
The tool omits inheritance and roles and does not support every PostgreSQL object. Generated output may not work as expected when the source PostgreSQL version is newer than the target.
The verdict
pgquarrel offers a focused way to compare PostgreSQL schemas and produce deployment SQL. Check its object coverage and version compatibility before relying on generated changes.
Questions people ask
Is pgquarrel free?
Yes. The pgquarrel plan costs nothing, and the software is BSD-3-Clause licensed.
Which platforms are supported?
pgquarrel is listed for Linux, Windows, and self-hosted use.
Does it change table data?
No. It does not manipulate table data with INSERT, UPDATE, DELETE, or COPY operations.
How is SQL output delivered?
Changes go to stdout by default. Options can write them to a file, print a summary, or output them as a single transaction.
Which database does it compare?
pgquarrel compares PostgreSQL database schemas and has a single-engine database scope.
Where can users report problems?
The project provides a public GitHub issues page for bug reports and feature requests.
What the maker publishes
- Data scope
- The tool does not manipulate table data with INSERT, UPDATE, DELETE, or COPY operations. source
- Deployment use
- The README describes deploying database changes to testing, staging, or production environments as its main use case. source
- Direct connections
- It connects directly to PostgreSQL servers and reads catalog metadata rather than relying on tools such as pg_dump. source
- Distribution
- pgquarrel is distributed as source code through GitHub and can also be obtained by cloning its Git repository. source
- License
- The repository identifies the software as BSD-3-Clause licensed. source
- Notable omissions
- The README identifies inheritance and roles as main absences and says pgquarrel does not support all PostgreSQL objects. source
- Platforms
- The README says it was tested on Linux, FreeBSD, and Windows, and provides installation instructions for UNIX based operating systems and Windows. source
- PostgreSQL object coverage
- The README lists support for many PostgreSQL objects, with support marked partial for numerous types and complete for others. source
- Purpose
- pgquarrel compares PostgreSQL database schemas (DDL) and outputs the differences as commands to make the target schema match the source. source
- Release
- The releases page lists version 0.7.0 as the latest release and notes fixes to its Windows, Debian/Ubuntu, and FreeBSD builds. source
- Selective comparison
- It supports filters and options to compare selected object types and include or exclude schemas by pattern. source
- SQL output
- Changes are output to stdout by default, with options to write to a file, print a summary, or output changes as a single transaction. source
- Support channel
- The repository has a public GitHub issues page for bug reports and feature requests. source
- Version compatibility
- The generated file may not work as expected when the source PostgreSQL version is newer than the target version. source
Checked against the maker's pages on 3 Oct 2026.