pgquarrel
- Android app
- Not listed
- Free plan
- Yes
- Runs on
- Linux, self-hosted, Windows
Summary
pgquarrel is a free tool for comparing PostgreSQL database schemas and generating commands that bring a target schema in line with a source. It connects directly to PostgreSQL servers and reads catalog metadata rather than relying on tools such as pg_dump. The project describes deployment of schema changes to testing, staging, or production as its main use. Filters and options allow comparison of selected object types and inclusion or exclusion of schemas by pattern. Generated changes go to stdout by default, with options to write to a file, print a summary, or output changes as one transaction. pgquarrel does not alter table data using INSERT, UPDATE, DELETE, or COPY operations. Documented coverage includes PostgreSQL object types with both complete and partial support; inheritance and roles are listed as major omissions. Output may not work as expected when the source PostgreSQL version is newer than the target. The software is BSD-3-Clause licensed and distributed as source through GitHub or a Git clone. The listed latest release is version 0.7.0.
Who it is for
pgquarrel suits database administrators or developers deploying PostgreSQL schema changes between environments. It is most relevant when schema comparison is needed without manipulating table data.
What is good
- Compares schemas by connecting directly to PostgreSQL servers.
- Supports object-type and schema-pattern filters.
- Can write SQL changes to a file or one transaction.
- Free and BSD-3-Clause licensed.
What to know first
- Inheritance and roles are unsupported.
- Some PostgreSQL object types have only partial support.
- Newer source versions may produce unexpected output for older targets.
- Distributed as source code.
Verdict
pgquarrel provides a focused way to generate PostgreSQL schema changes for deployment across environments. Check its object coverage and version caveat before relying on the generated output.
pgquarrel plans and pricing
All plansCompared on database schema comparison tools
- Free plan
- Yesgithub.com
- Migration scripts
- Yesgithub.com
- Database scope
- single-enginegithub.com
- Supported platforms
- cross-platformgithub.com
Facts
- Purpose
- pgquarrel compares PostgreSQL database schemas (DDL) and outputs the differences as commands to make the target schema match the source.github.com · 3 Oct 2026
- Deployment use
- The README describes deploying database changes to testing, staging, or production environments as its main use case.github.com · 3 Oct 2026
- Direct connections
- It connects directly to PostgreSQL servers and reads catalog metadata rather than relying on tools such as pg_dump.github.com · 3 Oct 2026
- Data scope
- The tool does not manipulate table data with INSERT, UPDATE, DELETE, or COPY operations.github.com · 3 Oct 2026
- Selective comparison
- It supports filters and options to compare selected object types and include or exclude schemas by pattern.github.com · 3 Oct 2026
- 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.github.com · 3 Oct 2026
- PostgreSQL object coverage
- The README lists support for many PostgreSQL objects, with support marked partial for numerous types and complete for others.github.com · 3 Oct 2026
- Notable omissions
- The README identifies inheritance and roles as main absences and says pgquarrel does not support all PostgreSQL objects.github.com · 3 Oct 2026
- Version compatibility
- The generated file may not work as expected when the source PostgreSQL version is newer than the target version.github.com · 3 Oct 2026
- Platforms
- The README says it was tested on Linux, FreeBSD, and Windows, and provides installation instructions for UNIX based operating systems and Windows.github.com · 3 Oct 2026
- Distribution
- pgquarrel is distributed as source code through GitHub and can also be obtained by cloning its Git repository.github.com · 3 Oct 2026
- License
- The repository identifies the software as BSD-3-Clause licensed.github.com · 3 Oct 2026
- Release
- The releases page lists version 0.7.0 as the latest release and notes fixes to its Windows, Debian/Ubuntu, and FreeBSD builds.github.com · 3 Oct 2026
- Support channel
- The repository has a public GitHub issues page for bug reports and feature requests.github.com · 3 Oct 2026
Best pgquarrel alternatives
See all 12
Where it ranks on Everything Xiaomi
Is pgquarrel yours?
Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.
Sources
- github.com/eulerto/pgquarrel· checked 3 Oct 2026
- github.com/eulerto/pgquarrel/releases· checked 3 Oct 2026
- github.com/eulerto/pgquarrel/issues· checked 3 Oct 2026