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.
Product
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.
Database Guides
What Is a Database Schema Diff Tool (and When You Need One)
What a database schema diff tool does, how it works, and the situations where it saves you from painful production surprises.
Multi-Tenant Schema Management: Keeping Per-Tenant Databases in Sync
How to detect and fix schema drift across per-tenant or shared-schema multi-tenant databases, and how to roll out migrations across many tenants safely.
Database Guides
Oracle to PostgreSQL Migration: Comparing Schemas Across Dialects
A schema-level look at migrating from Oracle to PostgreSQL — NUMBER types, sequences, and the objects that need manual review.
Best Database Migration Tools: What Makes One Advanced
The criteria that separate the best database migration tools from basic ones: readable generated SQL, cross-dialect awareness, dry-run safety, and CI fit.
How to Find Which Indexes Are Actually Used
How to find unused database indexes with real usage stats in PostgreSQL, MySQL, SQL Server, Oracle, Db2, and SQLite, and why a zero-usage counter isn't reason enough to drop one.
Rollback Strategies for Database Schema Migrations
How to plan safe rollbacks for schema migrations: reversible vs irreversible changes, pre-migration snapshots, and testing the rollback itself.
