Insert

Inserts in QuestDB.

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`	Column names (comma-separated، e.g. timestamp،symbol،price)
Table	`inTable`	Table name to insert into (e.g. my_table)
Values	`inValues`	Values to insert. Array of values for single row، or array of arrays for multiple rows

Property	Field	Description
Rows Affected	`outRowsAffected`	Number of rows inserted

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.