Query Data

Queries a data in TimescaleDB.

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
Select Columns	`inColumns`	Columns to select (e.g. time，device_id，avg(temperature) as avg_temp)
Table Name	`inTable`	Name of the hypertable to query
Time Column	`inTimeColumn`	Name of the time column (default: time)
Where Clause	`inWhere`	Optional WHERE clause without the WHERE keyword (e.g. device_id

Property	Field	Description
Row Count	`outRowCount`	Number of rows returned
Rows	`outRows`	Array of result rows as JSON objects

Property	Field	Description
Credentials	`optCredentials`	TimescaleDB credentials (optional if using Connect node)
Limit	`optLimit`	Maximum number of rows to return
Order By	`optOrderBy`	ORDER BY clause (default: time column descending)
Time Bucket	`optBucket`	Time bucket interval for aggregation (e.g. 1 hour，5 minutes，1 day). Leave empty for no bucketing
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.