DBC vs pgquarrel

DBC is a free, open-source command-line tool for comparing database schemas across versions, environments, or database systems. Built with Go, it captures schema snapshots and checks tables, columns, indexes, foreign keys, and constraints for changes. It supports MySQL, PostgreSQL, SQL Server, Oracle, and SQLite. Optional data checksums can reveal data modifications, while exact row counts are enabled by default. Results can be output as text, JSON, or HTML. Database drivers run as separate executables and communicate with the core application over JSON-RPC through standard input and output; the README notes that drivers use timeouts but makes no certification or compliance claim. Building the core and drivers from source with Make is the documented installation route. DBC is licensed under MIT and is listed for Linux, macOS, and Windows. The releases page lists v0.1.0-alpha as a pre-release. CI/CD examples, Docker support, migration script generation, and a web UI appear on the roadmap, not among the available features.

pgquarrel compares PostgreSQL database schemas and produces SQL commands to bring a target schema in line with a source. It connects to PostgreSQL servers and reads catalog metadata directly, rather than depending on tools such as pg_dump. The project describes deploying schema changes to testing, staging, or production as its main use. Filters can narrow comparisons to selected object types or include and exclude schemas by pattern. Output goes to stdout by default, with options to save it to a file, print a summary, or place changes in one transaction. pgquarrel does not manipulate table data with INSERT, UPDATE, DELETE, or COPY. Its documented object coverage includes both complete and partial support; inheritance and roles are noted absences, and not all PostgreSQL objects are supported. Output may not work as expected when the source PostgreSQL version is newer than the target. The software is free under the BSD-3-Clause license, distributed as source through GitHub or a Git clone, and the listed latest release is 0.7.0.