Select Rows

Select Rows — see the properties below.

This node is also exposed as an AI Agent tool.

This node has 1 input port and 1 output port.

Common Properties

Every node shares these.

Name — the node's display name on the canvas.
Color — the node's colour on the canvas.
Delay Before (sec) — wait this long before the node runs.
Delay After (sec) — wait this long after the node runs.
Continue On Error — carry on instead of failing the flow. Defaults to false.

info

When Continue On Error is true the error is not raised at all, so a Catch node will not see it either.

Property	Field	Description
Client ID	`inClientID`	Client ID from Connect node (optional if credentials provided)
Table	`inTable`	Table name to query

Property	Field	Description
Count	`outCount`	Number of rows returned
Result	`outResult`	Query results (array of rows or single object)

Property	Field	Description
Columns	`optColumns`	Columns to select (comma-separated٫ default: *)
Credentials	`optCredentials`	Supabase API key (optional - use instead of Connect node)
Filter	`optFilter`	Filter conditions (e.g. id
Limit	`optLimit`	Maximum number of rows to return
Offset	`optOffset`	Number of rows to skip
Order By	`optOrder`	Order by column (e.g. created_at.desc)
Project URL	`optProjectURL`	Supabase project URL (required if using credentials directly)
Single Row	`optSingle`	Return single object instead of array (fails if no or multiple rows)

A Client ID from this package's Connect node, unless you set credentials directly on this node.
Supabase API Key — API key for Supabase authentication. Use anon key for client-side or service_role key for server-side operations.
- value — API Key (password, required). Your Supabase anon key or service_role key from Project Settings > API

Store these in a Vault and reference the vault item from the node, rather than typing the secret into the property.