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.
Product
FoxSchema product news, releases, and features.
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.
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.
Data Masking for Dev Environments with FoxScript and Faker.js
How to mask sensitive data for dev/staging using FoxSchema's bundled @faker-js/faker import in FoxScript, with deterministic seeding and Server Beam.
Server Insights: Connection Pool, Sessions, and Table Sizes at a Glance
How FoxSchema's Server Insights utility surfaces connection pool health, active sessions, host resources, and table/index sizes per dialect.
Server Beam: Moving Data Between Two Databases with SQL and JavaScript
How FoxSchema's Server Beam moves data across two live database connections using sql.on(alias), bind parameters, and a 20-call-per-run safety cap.
Query Files: Turn a CSV, JSON, or Fixed-Width File Into a Queryable Table
How FoxSchema's Query files utility imports CSV/TSV, JSON, and fixed-width files into a temp SQLite workspace or a saved connection for instant SQL access.
FoxScript: SQL with Embedded JavaScript and Node Code Cells
How FoxScript works: SQL-first documents with @js/@ts/@node code blocks, statement strip, bind-parameter sql tags, and browser vs server execution.
IBM Db2 in n8n: A Docker-Distributed SQL Builder Node
n8n-nodes-db2-sql-builder brings IBM Db2 into n8n workflows via a Docker image with the native driver already built in, powered by FoxSchema's catalog engine.
