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.
Tutorials
Step-by-step guides for comparing and migrating database schemas.
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
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.
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.
