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.

The Table step on the Studio canvas
The Table step as it appears on the Studio canvas — input pins on the left, output ports on the right.

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.

Table in the node library, with the in-editor docs panel open
The library entry and the in-editor docs panel for Table — the same reference this page is generated from.

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.

Table wired into a runnable workflow in the Studio builder
Table wired into a runnable flow — input on the left, output on the right.

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.

The Table node's settings in the Studio builder
The settings for Table, showing the values from the flow above.

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.

DirectionPortLabelWhat flows through it
InputinputInput
OutputoutputResult

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

The Table node's input envelope in the run data viewer
The input envelope in the Runs view — Flowdrome always shows the whole envelope, with the payload inside 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.

PropertyTypeDefaultDescription
Table
table
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).
Operation
operation
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 id
rowId
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 path
rowIdPath
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))
Values
values
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 path
valuesPath
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 column
matchColumn
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 write
batchSize
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"
Filters
filters
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"
Limit
limit
int 50 Rows per page (server caps at 1000).
Shown when tblOp(c) === "list"
Offset
offset
int 0 Rows to skip — page 2 = limit × 1, page 3 = limit × 2, …
Shown when tblOp(c) === "list"
Order by
orderBy
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"
Order
order
select "asc" Sort direction.
ascdesc
Shown when tblOp(c) === "list"
Nucleus URL
baseUrl
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 token
token
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.