Action MySQL

MySQL Query

Executes a SELECT query against MySQL. Returns rows as a JSON array. Use ? placeholders to prevent SQL injection. Fires On Success with the rows, or On Error with the error message.

Node IDMySqlQueryAction

Parameters

Parameter	Type	Required	Default	Description
Connection String Secret Key `connection_string_secret_key`	`string`	No	`MYSQL_URL`	Key in the Secrets store holding your MySQL connection string (e.g. mysql://user:pass@host/db).
SQL Query `sql`	`textarea`	Yes	—	The SELECT query to execute. Use ? for parameterized queries.
Parameters (JSON Array) `parameters`	`textarea`	No	—	Optional JSON array of parameter values matching ? placeholders. E.g. ["val1", 42].
Timeout (seconds) `timeout_seconds`	`integer`	No	`30`	Connection timeout in seconds.
Require TLS `require_tls`	`boolean`	No	`true`	Require an encrypted TLS connection. If true, the connection will fail if the server does not support TLS.

Inputs

Input	Type	Required	Description
Execute `input0`	`object`	Yes	Execution signal.

Outputs

Output	Type	Identifier	Description
On Success `output0`	`object`	`result`	Fires on successful query. Contains rows (JSON array) and row_count.
On Error `output1`	`object`	`error`	Fires on failure. Contains the error message.