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.
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.
Library capture pending — regenerate with npm run shots:nodes.
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.
Canvas capture pending — regenerate with npm run shots:nodes.
How it’s configured
The node’s Configure panel as it opens in the builder when you select the step — every setting laid out with real values. Click any field to edit it.
Config capture pending — regenerate with npm run shots:nodes. See the full property reference below.
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:48170/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 you see in the run data panel after pressing Test workflow.
operation: list with an email-contains filter, after an insert + upsert wrote the row
Input — what the node received
{
"kind": "json",
"contentType": "application/json",
"payload": {
"email": "linus@kernel.test",
"score": 5
},
"body": {
"email": "linus@kernel.test",
"score": 5
}
} 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 in the panel 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. deletegetinsertlistupdateupsert |
Row idrowId | string | "" | The row_ id to get/update/delete. 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 on the input carrying the row id when Row id is blank (default: id — a row from an earlier Table step carries it there). Shown when ["get", "update", "delete"].includes(tblOp(c)) |
Valuesvalues | json | {} | Column values to write, e.g. { "email": "{{ $json.email }}", "score": 10 }. Empty = the node's whole input 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 the input 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" |
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.