pgquarrel

Input—per 1M tokens

Output—per 1M tokens

Context—tokens

WeightsClosed

About

pgquarrel is ranked #4 of 19 in database schema comparison tools on Inferse. It runs on Linux, Self-hosted, Windows. There is a free plan.

Compared 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