Documentation Index
Fetch the complete documentation index at: https://docs.royaltyport.com/llms.txt
Use this file to discover all available pages before exploring further.
Overview
The Database step lets you read, write, and query your automation databases. Choose from structured operations (Read, Insert, Update, Upsert, Delete) with a visual builder, or write raw SQL with the Query operation.
Configuration
| Field | Description |
|---|
| Database | Select a connected automation database |
| Operation | Read, Insert, Update, Upsert, Delete, or Query |
| Table | Target table (for structured operations) |
Operations
| Operation | Description | Fields |
|---|
| Read | Fetch rows from a table | Column toggles to select which columns to return |
| Insert | Add a new row | Set field values for the new row |
| Update | Modify existing rows | Set field values + where clauses to match rows |
| Upsert | Insert or update | Set field values (inserts if not found, updates if exists) |
| Delete | Remove rows | Where clauses to match rows to delete |
| Query | Run raw SQL | SQL editor with template variable support and AI generation |
Where Clauses
For Update, Delete, and Read operations, use where clauses to filter rows. Each clause specifies a column, operator, and value.
Available operators:
| Operator | Description |
|---|
= | Equals |
!= | Not equals |
> | Greater than |
< | Less than |
>= | Greater than or equal |
<= | Less than or equal |
LIKE | Pattern match (case-sensitive) |
ILIKE | Pattern match (case-insensitive) |
IN | Matches any value in a list |
NOT IN | Does not match any value in a list |
BETWEEN | Within a range |
IS NULL | Value is null |
IS NOT NULL | Value is not null |
Output
| Field | Type | Description |
|---|
rows | array | Result rows |
count | number | Number of affected/returned rows |
error | boolean | Whether an error occurred |
error_message | string | Error description if failed |
