Database Execute
Executes INSERT, UPDATE, or DELETE operations on a database. Returns metadata about the operation including rows affected and last insert ID.
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| database | database | Yes | Database ID. |
| sql | string | Yes | SQL command to execute (INSERT, UPDATE, DELETE, or DDL). |
| params | json | No | Query parameters (array of values). |
Outputs
| Name | Type | Description |
|---|---|---|
| success | boolean | True if the operation succeeded. |
| affected | number | Number of rows affected by the operation. |
| lastRowId | number | Last inserted row ID (for INSERT operations). |
Related Nodes in Developer Tools
JavaScript
Executes JavaScript in a sandboxed V8 isolate. Inputs are bound as `args` and console output is captured to stdout/stderr.
HTTP Request
Receives an HTTP request and returns the response synchronously.
HTTP Webhook
Receives an HTTP webhook and executes the workflow asynchronously.
Fetch
Fetch data from a URL using the Fetch API.
Database Query
Executes a SELECT query on a database and returns the results.
Conditional Fork
Splits the workflow into two branches based on a boolean condition. The 'true' output is taken if the condition is true, 'false' if false.
Conditional Join
Joins two mutually exclusive branches ('true' and 'false') into a single flow. Emits the value from the active branch. Errors if both or neither are provided.
Send Queue Message
Sends a single message to a message queue.
Receive Queue Message
Receives and extracts the message payload from a queue.
Aggregate Items
Collects multiple values into a repeated output array
Extract Item
Extracts a single item from a repeated input at the specified index