Select

Select — 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)
Columns	`inColumns`	Columns to select (comma-separated). Leave empty for all columns (*)
Limit	`inLimit`	Maximum number of rows to return
Order By	`inOrderBy`	ORDER BY clause without 'ORDER BY' keyword (e.g. timestamp DESC)
Table	`inTable`	Table name to select from (e.g. my_table)
Where Clause	`inWhere`	WHERE clause without 'WHERE' keyword (e.g. symbol

Property	Field	Description
Row Count	`outRowCount`	Number of rows returned
Rows	`outRows`	Selected rows as array of objects

Property	Field	Description
Credentials	`optCredentials`	QuestDB credentials (optional - use instead of Connect node)
Timeout (seconds)	`optTimeout`	Maximum time in seconds to wait

A Client ID from this package's Connect node, unless you set credentials directly on this node.
QuestDB Connection — QuestDB database connection credentials
- type — Database Type (hidden, optional)
- server — Server (text, required). QuestDB server hostname or IP address
- port — Port (text, optional). PostgreSQL wire protocol port (default: 8812)
- database — Database (text, optional). Database name (default: qdb)
- username — Username (text, required). Database username (default: admin)
- password — Password (password, optional). Database password (default: quest)
- ssl_mode — SSL Mode (select, optional). SSL connection mode

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