Home - FoxSchema

Skip to content

FoxSchema

Comparison and Sync

10 SQL Dialects · Open Source

Schema changes,

perfectly migrated.

Compare and migrate SQL database schemas across 10 dialects — MySQL, PostgreSQL, SQL Server, Oracle, MariaDB, DB2, and more. Install the CLI from npm or Homebrew, or self-host the web app with Docker.

Get Started

View on GitHub

migration_2026_07_05.sql

MySQL 8 → PostgreSQL 16

-- Detected schema changes

ALTER TABLE users

ADD COLUMN last_login_at TIMESTAMP;

ALTER TABLE users

DROP COLUMN legacy_flag;

CREATE INDEX idx_users_email

ON users (email);

Migration Plan

users.last_login_at

TIMESTAMP • nullable

Add

users.legacy_flag

column

Drop

idx_users_email

index

Add

Validated & Migration-Ready

Install in seconds

FoxSchema ships as a CLI (npm or Homebrew) and a self-hostable web app (Docker). Pick your channel — no desktop install required.

📦npm · CLI

npm install -g foxschema

Gives you the fox command on any OS with Node.

🍺Homebrew · CLI

brew tap tedious-code/foxschema<br>brew install foxschema

macOS & Linux.

🐳Docker · Web app

docker run -p 3001:3001 5nickels/foxschema:latest

Self-host the web UI. Guide →

Terminal — FoxSchema CLI

$ npm install -g foxschema

$ fox compare --source prod --target staging

✓ Schema diff complete — 3 changes detected

$ fox migrate --source prod --target staging

✓ Migration applied successfully

All install options →

Engineered for migration speed

Eliminate manual diffing and risky migration scripts. FoxSchema validates changes before they touch production.

Instant Diffing

Grouped, searchable diff — drill into any object’s column, index, and foreign-key changes across tables, views, sequences, types, and routines.

👁️

Pre-Flight Validation

Dry-run by default. Review the generated target-dialect DDL, then apply with a pre-migration snapshot — or use skip-on-error to continue past a failed object.

📦

10 SQL Dialects

PostgreSQL, MySQL, MariaDB, SQL Server, Azure SQL, Oracle, IBM Db2, SQLite, ClickHouse, and Amazon Redshift — one tool for every target.

Scroll to Top

&times;

Stay in the loop

Get FoxSchema release news, new SQL-dialect support, and schema-migration tips. No spam — unsubscribe anytime.

Subscribe