foxschema
v0.2.111
Published
Fox Schema CLI — schema diff, migrations, and a rich SQL Editor (TypeScript / Node ESM)
Maintainers
Readme
foxschema
Fox Schema — compare database schemas, generate migrations, and run a rich
SQL Editor in your browser. One global CLI: foxschema.
npm install -g foxschema
foxschema # UI → http://localhost:3210SQL Editor (0.2)
Multi-destination queries, notebook-style cells, Data Peek, FoxScript, variables, and Safe mode — next to Schema Sync in the same UI.

| | |
|--|--|
| Multi-destination Run | By-cred / Side-by-side result grids |
| Notebook cells | SQL + @js / @ts / @node with Out [n] |
| Data Peek | Cmd/Ctrl-click Schema tables · click rust FK cells in results |
| Peek tools | WHERE / ORDER BY / LIMIT · Prev/Next · arrange · resize |
| Variables | ${{name}}, @set, session secrets |
Schema Sync

Diff source vs target, generate migration DDL, dry-run by default.
Install channels
# npm
npm install -g foxschema
# Homebrew (macOS)
brew tap tedious-code/foxschema https://github.com/tedious-code/foxschema
brew trust tedious-code/foxschema
brew install foxschema
# Docker (linux/amd64, includes Db2)
docker pull 5nickels/foxschema:latest
docker run -d -p 3210:3210 -v foxschema_data:/data 5nickels/foxschema:latestCLI
foxschema # start local UI and open the browser
foxschema stop
foxschema shortcut # Desktop icon
foxschema doctor
foxschema compare --source a --target b
foxschema tuiPackage format
- Written in TypeScript
- Published CLI entry is ESM (
"type": "module") with atypesfield for editors - Native DB drivers may resolve as CommonJS at runtime
- Node.js ≥ 22.5
Docs
License
Copyright 2024–2026 Huy Phan · Apache-2.0 · see NOTICE
