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.

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: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.

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.
deletegetinsertlistupdateupsert
Row id
rowId
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 path
rowIdPath
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))
Values
values
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 path
valuesPath
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 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"
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.