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.

Property	Field	Description
Client ID	`inClientID`	Client ID from Connect node (optional if credentials provided)
Parameters	`inParameters`	Query parameters as array for $1، $2، etc. placeholders
Query	`inQuery`	SQL query to execute (e.g. SELECT * FROM my_table)

Property	Field	Description
Result	`outResult`	Query result as array of rows (for SELECT) or affected row count (for INSERT/UPDATE/DELETE)
Row Count	`outRowCount`	Number of rows returned or affected

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

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.