# Install sqldiff with Homebrew

Displays the differences between SQLite databases. Version 3.53.4 via Homebrew; verified 2026-07-25.

## Install

```sh
sudo av install brew:sqldiff
```

Additional install commands:

### macOS

- Homebrew (100%):

```sh
brew install sqldiff
```

  Evidence: local Homebrew formula metadata

## Package facts

- **Package key:** brew:sqldiff
- **Package manager:** Homebrew
- **Version:** 3.53.4
- **Source summary:** Displays the differences between SQLite databases
- **Homepage:** <https://www.sqlite.org/sqldiff.html>
- **Last updated:** 2026-07-25T14:38:49Z
- **Generated:** 2026-08-03T19:37:03+00:00

## Executables

- sqldiff (alias)

## Install behavior

- Bottle: not available

## Freshness

- Page generated: 2026-08-03
- Package-manager version: 3.53.4
## Project history and usage

sqldiff is the SQLite project's command-line database difference utility. It compares two SQLite databases and usually emits SQL that transforms the first database into the second.

### Project history

sqldiff is documented as part of the official SQLite toolset rather than as a separate standalone project. The SQLite source repository is managed in Fossil at sqlite.org/src, and the SQLite README emphasizes that this Fossil repository contains the official source history.

### Adoption history

As a small companion utility to SQLite, sqldiff is mostly adopted through SQLite-oriented packaging. The input metadata lists a Homebrew formula with the sqldiff executable, giving macOS and Linuxbrew users an easy way to install the database-diff tool without building SQLite source utilities themselves.

### How it is used

The basic invocation is sqldiff database1.sqlite database2.sqlite. Options can emit summaries, limit comparison to schema or a table, wrap output in a transaction, or produce a binary changeset for SQLite's session extension.

### Why package nerds care

Package nerds care about sqldiff because it is a tiny, official SQLite-adjacent CLI that does one packageable job well: inspect and script differences between database files. It is useful in migrations, fixtures, reproducible tests, and debugging binary database changes.

### Timeline

- 2000: SQLite source history begins, according to the SQLite source README.
- Current docs: sqldiff is documented as sqldiff.exe, a command-line database difference utility.
- 2023: sqldiff documentation page last updated on 2023-01-06.

### Related projects

- sqldiff is related to SQLite itself and to the SQLite session extension when using the --changeset mode.

### Sources

- <https://github.com/sqlite/sqlite#readme>
- <https://www.sqlite.org/sqldiff.html>
- <https://www.sqlite.org/src>
- input.source_facts.package-manager


## Security Notes

No matching local secret-handling manifest was found for sqldiff. Nucleus package metadata is still published here so future coverage has a stable package URL.



## Combined YAML source

View the package source record on GitHub. [combined/sqldiff.yml](https://github.com/mxcl/pkgdb/blob/main/combined/sqldiff.yml)


## Sources

- pkg.so package database
- Geiger risk classifier
- curated package history
- pkgdb category and tag curation
- cross-ecosystem install command graph