FoxSchema SQL Builder for n8n: A Multi-Dialect Database Node
n8n-nodes-fox-schema-sql-builder is a community node powered by FoxSchema's catalog engine, covering PostgreSQL, MySQL, MariaDB, SQL Server, and Oracle inside n8n workflows.
SQL Editor Code Cells: Mixing JavaScript with SQL to Clean Migration Data
How FoxSchema's SQL Editor code cells (-- @js / -- @node) let you clean and reshape migration data with lodash and date-fns, right next to the query that produced it.
The Expand/Contract Pattern for Safe Schema Migrations
How the expand/contract (parallel change) pattern splits risky schema changes into safe phases, with a worked example and how to generate the SQL for each step.
Sequences, Identity Columns, and Auto-Increment: How They Differ Across Databases
How auto-increment, identity columns, and sequences differ across MySQL, PostgreSQL, SQL Server, Oracle, and Db2 — and where cross-dialect migrations break.
SQL Server to Oracle Migration: A Schema-Level Guide
Migrating SQL Server schemas to Oracle: data type mapping, IDENTITY to sequences, identifier case rules, the empty-string trap, and generating safe migration DDL.
Run One SQL Query Across Multiple Database Servers
How the FoxSchema SQL Editor runs the same query against several database servers at once, with per-connection variables, safe mode, and side-by-side results.
Oracle to PostgreSQL Migration: A Schema-Level Guide
A practical guide to migrating Oracle schemas to PostgreSQL: data type mapping, sequences and identity columns, PL/SQL objects, and generating safe migration SQL.
Zero-Downtime Database Schema Migrations: A Practical Guide
How to change a production database schema without downtime using the expand/contract pattern, safe sequencing, and automated schema diffing.
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.
