Database Migrations in Git: Commit, Review, Run
Keep database migrations in Git: commit each one as a plain SQL file, then run it from that exact commit. Fetch, pull and push from Fox Schema.
Database Schema History: Snapshots, Revert, Applies
Database schema history in one place: track versions, see what changed, revert with a plan you review first, and review every migration run.
Rename a Column Safely, or Change Its Type
Rename a column safely or change its type in steps: see what it touches, copy rows in batches, then switch over. Preview every statement first.
Archive a Large Table with Fox Schema’s Clone Table
Archive a large table as name_N and recreate an empty one with the same name and columns, so your app keeps working. Preview the SQL first.
Database Backup Strategy: Protecting Your System from Incident
A database backup strategy is not simply about making a copy of the database. A reliable strategy must answer three
Tutorials
Your Database Choice Starts With the Primary Key
Your Database Choice Starts With the Primary Key When starting a new application, one of the first decisions developers make
Product
Self-Hosting a Database Schema Tool with Docker
How to self-host a database schema diff and migration tool with Docker — a single container, encrypted credentials, on your own infrastructure.
Database Guides
Understanding Cross-Dialect Readiness: What Migrates Cleanly
A breakdown of cross-dialect readiness — which schema object types translate cleanly between SQL dialects and which need manual review.
Tutorials
Comparing Database Schemas from the Command Line with the fox CLI
How to compare database schemas from the command line with the fox CLI — setup, compare, snapshot, and migrate for scripts and CI.
Tutorials
Building Your Own Language in Monaco Editor: Tokenizers, Embedded Cells and Semantic Tokens
How to build a custom language in Monaco Editor — Monarch tokenizers, embedding TypeScript inside SQL, virtual documents for IntelliSense, semantic tokens and diagnostics.
