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
Tutorials
Step-by-step guides for comparing and migrating database schemas.
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.
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.
Tutorials
Automating Database Schema Checks in Your CI/CD Pipeline
How to automate database schema checks in CI/CD — compare environments, fail on drift, and generate migrations from the command line.
Learn SQL Queries Using Your Own Excel Data (Import, Query, Export)
Export an Excel sheet to CSV, import it into FoxSchema's SQL Editor, write real SQL queries and joins against it, then export results back to CSV.
Tutorials
Database Migration Best Practices for Safer Deployments
Database migration best practices: review generated DDL, snapshot before applying, use skip-on-error, and verify with a schema diff.
Tutorials
Schema Drift Detection: Catch DB Changes Before Prod
Learn what schema drift detection is, how to catch unsafe database changes across environments, and how FoxSchema helps teams review diffs before production.
Tutorials
How to handle schema drift detection with FoxSchema
Practical guidance on schema drift detection for engineering teams, driven by Analytics + Search Console demand on foxschema.com.
Tutorials
How to Keep Staging and Production Databases in Sync
Practical ways to keep staging and production database schemas in sync and stop "works on staging" bugs before they ship.
SQLite to PostgreSQL Migration: A Step-by-Step Schema Guide
A practical guide to migrating a SQLite schema to PostgreSQL: type mapping, constraint differences, and how to compare, dry-run, and apply the migration safely.
