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 18+ (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 prod --target staging
$ 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
Multi-arch (amd64 + arm64). Full configuration, SSO, and the IBM Db2 variant are in the self-hosting guide.
10 SQL dialects
PostgreSQL, MySQL, MariaDB, SQL Server, Azure SQL, Oracle, IBM Db2, SQLite, ClickHouse, and Amazon Redshift — the same engine across CLI and web app.
