SQL Query

io.sql Storage v0.1.0

Runs a SQL query against PostgreSQL or MySQL with real server-side positional parameters ($1…$n / ?) — no string splicing. Outputs the rows, row count, and field types.

Ports

Direction	Port	Label
Input	`input`	Payload
Output	`output`	Rows

Properties

Property	Type	Default	Description
Credential `credentialId`	`credential`	`""`	Use a stored credential for this connection — its fields are filled in at run start. Pick "None" to enter the connection details manually. accepts credential templates: `postgresmysql`
Dialect `dialect`	`select`	`"postgres"`	Which database to talk to. SQLite/DuckDB are deferred until the worker baseline is Node ≥ 24. `postgresmysql`
Host `host`	`string`	`"localhost"`	Database server hostname.
Port `port`	`int`	`0`	Server port. 0 = the dialect default (5432 / 3306).
Database `database`	`string`	`""`	Database name to connect to.
User `user`	`string`	`""`	Database user.
Password `password`	`string`	`""`	Database password — supports ${credential.NAME.FIELD}.
TLS `tls`	`select`	`"disable"`	Protocol-native TLS upgrade. "Require" fails with SQL_TLS when the server refuses. `disablerequire`
Query `query`	`code`	`""`	The SQL to run. Use positional parameters — $1…$n (PostgreSQL) or ? (MySQL) — never splice values into the text.
Parameters `params`	`json`	`[]`	Positional parameter values as a JSON array, e.g. [42, "name", true, null].
Parameters field `paramsField`	`string`	`""`	Dot-path to an array on the input to use as the parameters at run time (overrides the static list).
Row limit `rowLimit`	`int`	`10000`	Maximum rows to return; further rows are dropped and the result is marked truncated.
Timeout (ms) `timeoutMs`	`int`	`30000`	Abort the whole connection + query after this many milliseconds.

This page is generated from the node registry by gen-node-docs.mjs on every site build — ports, properties, defaults and visibility rules cannot drift from the code.