Install
Install FoxSchema
FoxSchema is distributed as a command-line tool (npm & Homebrew) and a self-hostable web app (Docker). All open-source, Apache-2.0.
Command line (CLI)
The fox command compares and migrates schemas from your terminal or CI. Requires Node.js 22.5 or newer (npm) — Homebrew bundles its own runtime.
npm
npm install -g foxschema
Homebrew (macOS & Linux)
brew tap tedious-code/foxschema https://github.com/tedious-code/foxschema
brew trust tedious-code/foxschema
brew install foxschema
# then
$ fox setup --email you@example.com
$ fox compare --source staging --target prod
$ fox tui
Web app (Docker)
Run the full web UI + API as a single self-hosted container. Saved connections and history persist on a volume — nothing leaves your infrastructure.
docker run -d --name foxschema \
-p 3210:3210 \
-v foxschema_data:/data 5nickels/foxschema:latest
# → http://localhost:3210
One image with every dialect, including IBM Db2 (linux/amd64). Full configuration and SSO are in the self-hosting guide.
14 SQL dialects
PostgreSQL, MySQL, MariaDB, SQL Server, Azure SQL, Oracle, IBM Db2, SQLite, ClickHouse, Amazon Redshift, CockroachDB, DuckDB, TiDB, and YugabyteDB — the same engine across CLI and web app.
