Execute Query
Execute Query — 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.
Inputs
| Property | Field | Description |
|---|---|---|
| Client ID | inClientID | Client ID from Connect node |
| Query Parameters | inParams | Array of parameter values for parameterized queries (optional) |
| SQL Query | inQuery | SQL query to execute. Use $1，$2，etc. for parameterized queries |
Outputs
| Property | Field | Description |
|---|---|---|
| Row Count | outRowCount | Number of rows returned or affected |
| Rows | outRows | Array of result rows as JSON objects |
Options
| Property | Field | Description |
|---|---|---|
| Credentials | optCredentials | TimescaleDB credentials (optional if using Connect node) |
| Timeout (seconds) | optTimeout | Maximum time in seconds to wait for the query to complete |
Requirements
- A Client ID from this package's Connect node, unless you set credentials directly on this node.
Related nodes
Connect · Disconnect · Insert Data · Query Data · Create Hypertable · Drop Chunks · Enable Compression · Create Continuous Aggregate · Refresh Continuous Aggregate · Toolkit
See also
- TimescaleDB — every node in this package
- Message object — how properties read values from
msg - Handling failure — Continue On Error, Catch and retries