Comparing Database Schemas from the Command Line with the fox CLI

Prefer the terminal? The fox CLI runs the same schema engine as the FoxSchema app, so you can compare database schemas from the command line — ideal for scripts, automation, and CI.

One-time setup

$ fox setup --email you@example.com

This binds the encryption key (kept in your OS keychain) that protects saved connection passwords.

Compare two schemas

$ fox compare --source prod --target staging
✓ exit 0 = identical, exit 1 = drift

The non-zero exit on drift is what makes this scriptable — drop it into a pipeline as a gate.

Snapshot and migrate

fox snapshot dumps a schema as DDL; fox migrate diffs source and target and applies the changes with the same dry-run and snapshot safeguards as the UI. There is also a full-screen interactive mode: fox tui.

Get the CLI

The fox command ships with every build. Download FoxSchema and see the documentation for the full command reference.

Scroll to Top