Schema Manager
Overview
The Schema Manager node provides DDL (Data Definition Language) operations for tenant-scoped database tables. All tables are namespace-prefixed with the tenant ID to enforce isolation. It supports creating tables, managing columns and indexes, describing schemas, and seeding initial data.
Category
Data — data/schemaManager
Operations
| Operation | Description |
|---|---|
| create_table | Create a new table with specified columns |
| add_column | Add a column to an existing table |
| alter_column | Change a column's type or constraints |
| drop_column | Remove a column from a table |
| add_index | Create an index on specified columns |
| drop_index | Remove an index |
| describe | Return the schema of a table (columns, types, constraints) |
| list_tables | List all tables in the tenant namespace |
| drop_table | Drop a table (requires confirmDrop flag) |
| rename_column | Rename a column |
| rename_table | Rename a table |
| seed | Insert initial data rows into a table |
Settings
| Setting | Type | Default | Description |
|---|---|---|---|
| operation | String | describe | DDL operation to perform |
| tableName | String | — | Target table name |
| columns | Array | [] | Column definitions for create_table |
| columnName | String | — | Column name for add/alter/drop/rename operations |
| columnType | String | VARCHAR(255) | SQL type for add/alter column |
| confirmDrop | Boolean | false | Safety flag required for destructive operations |
Inputs & Outputs
- input1 — Operation parameters (optional — can use config instead)
- output1 — Operation result (table created, schema description, etc.)
Use Cases
- Dynamic table provisioning — Create tenant-specific tables on account setup
- Schema migration — Add new columns to existing tables during upgrades
- Data seeding — Populate initial reference data (countries, categories, roles)