macOS
Homebrewverified · 100%
brew install apgdiffprovider-native install command
brew / rank 6430
Install apgdiff with Homebrew
Another PostgreSQL diff tool. Version 2.7.0 via Homebrew; verified from local package data.
install
Additional install commands
overview
Package summary
Another PostgreSQL diff tool
Project links
Commands and aliases
- apgdiff
history
Project history and usage
Another PostgreSQL Diff Tool, usually packaged as apgdiff, is a Java command-line utility for comparing PostgreSQL schema dumps and generating DDL needed to move an old schema toward a new one. Its niche is intentionally narrow: it is for schema-diffing PostgreSQL dump files, not for live database migration orchestration.
Project history
The official site presents apgdiff as a free PostgreSQL database schema diff tool and notes that it compares two database dump files to produce SQL statements describing schema changes. The project predates its GitHub repository: the web site lists 2010-era 2.x releases, and a 2012 news entry says the sources and issue tracker moved to GitHub to make participation easier.
The GitHub README describes the repository as mainly unmaintained, while still accepting useful bug-fix pull requests. The changelog shows the package's long tail of PostgreSQL compatibility work: version 2.0 rewrote the SQL parser, version 2.4 added schema-creation and Slony-trigger options, version 2.5 added materialized views, extensions, foreign tables, grants, and ownership support, version 2.6 added PostgreSQL 10 support, and version 2.7.0 added early support for PostgreSQL 12-era syntax such as partitioning and identity columns.
Adoption history
The official home page states that apgdiff was already being used by many developers worldwide. The batch input shows it has also crossed into several package-manager ecosystems, including Homebrew, Debian, Ubuntu, MacPorts, and Nix, which is typical for small database utilities that remain useful in scripts long after active feature development slows.
How it is used
Typical use is to dump two PostgreSQL schemas, run apgdiff against the old and new dumps, and review or apply the generated DDL. The official site emphasizes command-line use from batches and web applications, and the project README points users to GitHub issues for bugs.
Package users care about PostgreSQL version support because apgdiff parses SQL dump syntax. Its changelog is therefore practically part of the compatibility contract: support for materialized views, unlogged tables, extensions, foreign tables, sequences, triggers, rules, grants, views, and newer CREATE syntax determines whether a given schema dump can be diffed safely.
Why package nerds care
apgdiff is the kind of small, stable package that package managers preserve because it solves one specific operational problem without needing a server. It is especially interesting to PostgreSQL users who want schema comparison in CI or release scripts and are willing to inspect generated SQL rather than adopt a larger migration framework.
Timeline
- 2010: Version 2.0 rewrote the SQL parser and expanded supported PostgreSQL DDL.
- 2012: The project moved its sources and issue tracker to GitHub.
- 2012: Version 2.4 shipped with trigger, schema, and parser fixes.
- 2016: GitHub releases recorded 2.5.0 prereleases.
- 2018-2020: Changelog entries added PostgreSQL 10, Java 11 development, PostgreSQL 12-related syntax, partitioning, and identity-column support.
Related projects
- PostgreSQL schema dump tooling, database migration frameworks, and schema comparison utilities are adjacent, but apgdiff remains focused on diffing two PostgreSQL dump files and emitting DDL.
Sources
- https://api.github.com/repos/fordfrog/apgdiff
- https://github.com/fordfrog/apgdiff#readme
- https://www.apgdiff.com/
- input source_facts.package-manager
security posture
Risk level: blue
broad file, network, media, or database tool signal.
Risk classifier
blue risk · medium confidence · tool
Why
- broad file, network, media, or database tool signal
Signals
- text:sql
Install behavior
- No Homebrew bottle metadata was recorded.
Recommended review
Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.
executables
Installed executables
| Command | Kind | Exposure | Note |
|---|---|---|---|
apgdiff | executable | indexed executable | Discovered from the local executable index. |
freshness
Version and freshness
These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.
page generated2026-08-03
manager version2.7.0
manager updated
local dataunknown
upstreamnot available
latest detectednot detected
- okNo freshness warnings were generated.
install metadata
Package metadata
| Package key | brew:apgdiff |
|---|---|
| Version | 2.7.0 |
| Package manager | Homebrew |
| Homepage | https://www.apgdiff.com/ |
| Repository | https://github.com/fordfrog/apgdiff |
| Bottle | not recorded |
| Service | none declared |
source trail
Generated from repository data
This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.
Combined YAML source
View the package source record on GitHub.
Used sources
- Geiger risk classifier
- Nucleus package database
- curated package history
- pkgdb category and tag curation