FoxSchema is a free, open-source database schema diff tool that compares two databases, shows exactly what differs, and generates the SQL to make one match the other — across 10 SQL dialects.
What it does
Point FoxSchema at a source and a target database. It introspects both, shows a colour-coded diff of everything that changed — tables, columns, keys, indexes, constraints, views, sequences, types, functions, procedures, triggers — then generates runnable DDL to bring the target in line, and can apply it with a pre-migration snapshot and per-object history.
Ten dialects, one tool
PostgreSQL, MySQL, MariaDB, SQL Server, Azure SQL, Oracle, IBM Db2, SQLite, ClickHouse, and Amazon Redshift. Comparisons are cross-dialect aware, so equivalent types are not flagged as changes and you see up front which objects translate cleanly.
Three ways to run it
- Desktop app — native macOS, Windows, and Linux builds. Download here.
- Web app — a single self-hostable container. Self-hosting guide.
- CLI —
fox compareandfox migratefor automation and CI pipelines.
Safe by default
FoxSchema never writes to your source database. Migrations are dry-run by default; you review the generated SQL before anything is applied, a snapshot is taken first, and saved database passwords are encrypted at rest and never sent back to the browser.
Open source
FoxSchema is Apache-2.0 licensed. Browse the code, file issues, or contribute on GitHub. Read the documentation to get started in a few minutes.
