Table
storage.table Storage v0.1.0 Works with Flowdrome Tables — the built-in database in the Nucleus: list/query rows (filters, paging, ordering), get one row, insert, update, upsert (match on a column) or delete. Address the table by name; rows carry a generated id + created/updated stamps, and a write hands back the STORED ROW — id, stamps and every column — not just an id. Array-native: a list on the wire is N records, so a row operation runs once per record (Values and Row id resolved against THAT record) and returns one result per record — ten items in, ten rows written. A single object in returns a single result, un-wrapped; an empty list writes nothing and returns an empty list. The list operation is a single query and never fans out.
Finding it in the library
Search the builder's node library for Table (it lives under Storage). A single click opens the in-editor docs panel shown here — description, ports, and every property, without leaving the canvas. Double-click (or drag) to add it to the workflow.
Wired up in the builder
Table in a real, runnable flow — captured live from the Studio editor, exactly as it looks on your canvas. This is the same workflow used for the example input & output below.
How it’s configured
The node’s settings as the builder shows them — every field laid out with real values. In the Studio these are edited on the node: click the chevron on the divider under its ports to open them.
Ports
Ports are the node’s contract with its neighbours. In the editor a port label renders bold when wired and italic when optional; ◈ ports accept attachment carriers rather than data wires.
| Direction | Port | Label | What flows through it |
|---|---|---|---|
| Input | input | Input | |
| Output | output | Result |
How data flows through it
Table consumes the content of the incoming envelope — when it is fed directly by a trigger, the trigger’s wrapper is unwrapped at the node boundary so the node sees the actual data, not the metadata shell. Its output becomes the payload for the next node, while the envelope (trace ids, correlation, binary refs) rides along untouched. In the Runs view you always see the whole envelope for both sides of this node.
Expressions in the config
String-typed properties accept {{ }} expressions evaluated against the
incoming item at run time — e.g. {{ $json.customer.email }}. On this node
that’s table, rowId, matchColumn, orderBy, baseUrl, token. JSON- and code-typed fields never interpolate — they are passed through literally.
Build it with AI
Every node in this reference is reachable through Flowdrome’s
AI Copilot and the
MCP tools — say what you want, and the graph surgery
happens server-side. Node types resolve fuzzily, so the catalog label
(Table) works as well as the exact type id (storage.table).
In the Copilot panel (or any connected AI):
add a table node after the trigger As a step in a create_chain_workflow call:
{"type":"Table","config":{}} Raw MCP call — add this node to a workflow with add_node
curl -s -X POST http://localhost:4800/mcp -H "content-type: application/json" -d '{ "jsonrpc": "2.0", "id": "1", "method": "tools/call", "params": { "name": "add_node", "arguments": { "workflowId": "<id>", "type": "Table" } } }' Example input & output
Captured from a real test run of the workflow above — this is what the Runs view shows after pressing Test workflow.
operation: list with an email-contains filter, after an insert + upsert wrote the row
Input — what the node received
body.Output — what the node produced
{
"tableId": "tbl_91197742d45f",
"rows": [
{
"email": "linus@kernel.test",
"score": 100,
"qualified": true,
"id": "row_5c5d9310c9be",
"createdAt": "2026-07-20T03:28:25.024+00:00",
"updatedAt": "2026-07-20T03:28:25.059+00:00"
}
],
"count": 1,
"total": 1,
"limit": 10,
"offset": 0
} Property reference
Every setting, with its type and default — the same fields shown configured above.
| Property | Type | Default | Description |
|---|---|---|---|
Tabletable | string | "" | Which Flowdrome Table to work with — its name (e.g. Leads) or tbl_ id. Pick from your tables or open one to view/edit its rows. Create tables under the Nucleus's Tables screen (or POST /api/tables). Must be set by run time (the editor badge flags it). |
Operationoperation | select | "list" | list = query rows (filters/paging/ordering). get = one row by id. insert = add a row. update = merge values into a row. upsert = update the row matched on a column, else insert. delete = remove a row. Every operation except list runs ONCE PER RECORD — a list of ten on the input writes ten rows and returns ten results. insert/update hand back the stored row itself (its generated id, createdAt/updatedAt stamps and every column value), upsert { row, created }, get { found, row }, delete { deleted, rowId }. deletegetinsertlistupdateupsert |
Row idrowId | string | "" | The row_ id to get/update/delete. A {{ }} expression here is resolved against THIS record, so {{ $json.id }} over a list addresses each record's own row. Blank = read it from the input at the Row id path. Shown when ["get", "update", "delete"].includes(tblOp(c)) |
Row id pathrowIdPath | field | "id" | Dot-path carrying the row id when Row id is blank, read from THIS record (default: id — a row from an earlier Table step carries it there). Shown when ["get", "update", "delete"].includes(tblOp(c)) |
Valuesvalues | keyvalue | {} | Column values to write — one row per column, e.g. email → {{ $json.email }} (pick from the input data with ƒ), score → 10. Expressions resolve against THIS record, so one mapping writes one row per record when a list arrives. Empty = the record itself is the row (it must be an object). Keys that aren't declared columns are dropped; values are coerced to each column's type. Shown when ["insert", "update", "upsert"].includes(tblOp(c)) |
Values pathvaluesPath | field | "" | Dot-path to an OBJECT on THIS record to use as the values instead (wins over Values). Shown when ["insert", "update", "upsert"].includes(tblOp(c)) |
Match columnmatchColumn | string | "" | Upsert identity: the column whose value finds the existing row (e.g. email). The incoming values must carry it. The editor lists the chosen table's columns. Shown when tblOp(c) === "upsert" |
Records per writebatchSize | int | 10 | How many records go to the table in one call. Ten by default — far fewer round trips on a big list, and the last batch simply carries whatever is left over. Set 1 to write them strictly one at a time. You still get one result per record, in order, either way. Shown when tblOp(c) === "insert" || tblOp(c) === "upsert" |
Filtersfilters | rows | [] | Only rows matching EVERY filter are returned. equals compares the value exactly; contains is a case-insensitive substring match. Shown when tblOp(c) === "list" |
Limitlimit | int | 50 | Rows per page (server caps at 1000). Shown when tblOp(c) === "list" |
Offsetoffset | int | 0 | Rows to skip — page 2 = limit × 1, page 3 = limit × 2, … Shown when tblOp(c) === "list" |
Order byorderBy | string | "" | Column to sort by (number columns sort numerically), or createdAt / updatedAt. Blank = insertion order. The editor lists the chosen table's columns. Shown when tblOp(c) === "list" |
Orderorder | select | "asc" | Sort direction. ascdesc Shown when tblOp(c) === "list" |
Nucleus URLbaseUrl | string | "" | Override the Nucleus base URL. Blank = the FLOWDROME_WORKER_SDK_URL this engine was armed with (automatic in the editor and on the built-in host). |
Nucleus tokentoken | string | "" | Override the Nucleus API token (a token with Run capability). Blank = FLOWDROME_WORKER_SDK_TOKEN. |
Timeout (ms)timeoutMs | int | 15000 | Abort each Tables API call after this many milliseconds. |
Related nodes
The rest of the Storage group — the same folder you’d scan in the editor’s library.
This page is generated from the node registry by gen-node-docs.mjs on every
site build — ports, properties, defaults and visibility rules cannot drift from the code.
The screenshots and example data are captured from a live Flowdrome by
npm run shots:nodes and npm run gen:examples.