apgdiff ☆

« Back to VersTracker

Description:
Another PostgreSQL diff tool

Type: Formula | Latest Version: 2.7.0@0 | Tracked Since: Dec 17, 2025

Links: Homepage | formulae.brew.sh

Category: Databases

Tags: postgresql diff migration database cli

Install: brew install apgdiff

About:
apgdiff is a command-line tool designed to compare two PostgreSQL database schema dump files and generate a single SQL script containing the necessary DDL statements to migrate the first schema to the second. It excels at handling complex changes like renames and is particularly useful for managing database schema evolution across different development and production environments.

Key Features:

Generates SQL migration scripts from two schema dumps
Intelligently detects and handles object renames (e.g., columns, tables)
Command-line interface suitable for automation and CI/CD pipelines
Supports PostgreSQL-specific DDL constructs

Use Cases:

Automating database schema migrations in deployment workflows
Comparing development and production schemas to identify discrepancies
Generating incremental update scripts for database versioning

Alternatives:

Flyway – Flyway manages versioning via SQL files and a metadata table, whereas apgdiff compares snapshots to generate migrations.
Liquibase – Liquibase uses XML/YAML/SQL changelogs for granular control, while apgdiff automates diff generation from full dumps.

License: MIT

Dependencies: openjdk

Bottles available for: all

Version History

Detected	Version	Rev	Change	Commit