Database Query
Executes a SELECT query on a database and returns the results as JSON. Use this for retrieving data from your database.
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| database | database | Yes | Database ID |
| schema | schema | No | Optional schema to validate and coerce query results |
| sql | string | Yes | SQL SELECT query to execute |
| params | json | No | Query parameters (array of values) |
Outputs
| Name | Type | Description |
|---|---|---|
| results | json | Query results as an array of objects |
| count | number | Number of rows returned |
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 Execute
Executes INSERT, UPDATE, or DELETE operations on a database
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