SQL Builder for n8n, powered by @foxschema/core.
FoxSchema supports all dialects: PostgreSQL, MySQL/MariaDB, SQL Server, Oracle, and Db2.
This package ships as a Docker image with the Db2 driver (ibm_db) baked in. Package name stays n8n-nodes-db2-sql-builder.
For other dialects via npm/community install (no native Db2), use n8n-nodes-fox-schema-sql-builder.
| Channel | Supported? |
|---|---|
Docker Hub (5nickels/n8n-nodes-db2-sql-builder) |
Yes |
| npm / n8n Community nodes UI install | No |
ibm_db is a native addon (CLI driver + compile toolchain). n8n cannot preinstall that via the community-node installer, so this package is not meant for npmjs / verified-community install.
For multi-dialect SQL builder without Db2 (Postgres, MySQL, MariaDB, SQL Server, Oracle) via npm, use n8n-nodes-fox-schema-sql-builder.
docker pull 5nickels/n8n-nodes-db2-sql-builder:0.1.2
# or
docker pull 5nickels/n8n-nodes-db2-sql-builder:latestLocal compose (requires sibling foxSchema checkout next to this repo for image builds):
# Layout:
# ../foxSchema/
# ./n8n-nodes-db2-sql-builder/ (this repo)
cp .env.example .env
docker compose up -d --build
# UI: http://localhost:5678Compose builds with context: .. so the Dockerfile can bundle @foxschema/core from ../foxSchema/packages/core.
- Row get / create / update / delete with SELECT, WHERE, GROUP BY, HAVING, ORDER BY,
FETCH FIRST - Routine: Call Procedure / Call Function (Form / From Item / JSON parameter modes)
- Execute Query: multi-statement, bindings, preview/dry-run, transactions
- Catalog browse via foxSchema Db2 provider (
getTables— tables, views, procedures, functions) - Security: Allow Unsafe SQL off by default; validated identifiers; schema-qualified tables
IBM DB2 Credential — host, database, user, password, port (default 50000), protocol / SSL, schema (default DB2INST1). Mapped to foxSchema ConnectionOptions for the Db2 adapter.
Requires sibling ../foxSchema for pnpm build (bundles core into dist/vendor/foxschema-core.js).
pnpm install
pnpm test
pnpm build
pnpm validate:n8nvalidate:n8n checks package layout for custom Docker installs — it does not mean the package is eligible as a verified community node (runtime ibm_db remains).
- Raw SQL expressions, EXISTS subqueries, and SQL-typed bind parameters require Allow Unsafe SQL.
- Prefer least-privilege Db2 accounts for n8n workflows.