Database Query
Execute a SQL query against your organization's SQLite database. Supports SELECT, INSERT, UPDATE, and DELETE. Use parameterized queries with ? placeholders. One statement per query — no semicolons.
Built-in action Built In
Execute a SQL query against your organization's SQLite database. Supports SELECT, INSERT, UPDATE, and DELETE. Use parameterized queries with ? placeholders. One statement per query — no semicolons.
At a Glance
| Field | Value |
|---|---|
| Action ID | db-query |
| Category | Built In |
| Connector | Not required |
| Requires gas | No |
| Funds movement | None declared |
| Tags | database, sql, query, storage |
Payload Schema
| Field | Type | Required | Description |
|---|---|---|---|
sql | string | Yes | SQL statement to execute. Use ? for parameter placeholders. |
params | array | No | Values to bind to ? placeholders in the SQL statement. |
Result Schema
| Field | Type | Required | Description |
|---|---|---|---|
status | string | No | - |
rows | array | No | Rows returned by SELECT queries. |
rowsAffected | integer | No | Number of rows affected by INSERT/UPDATE/DELETE. |
lastRowId | integer | No | Last inserted row ID for INSERT statements. |
Examples
json{ "type": "db-query", "payload": { "sql": "SELECT * FROM users WHERE age > ?" }, "children": []}
bashcurl -X POST "https://api.b3os.org/v1/actions/db-query/test" \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "Content-Type: application/json" \ -d '{ "inputs": { "sql": "SELECT * FROM users WHERE age > ?" }}'
Payload fields can use workflow expressions such as {{$trigger.body.amount}}, {{$nodes.fetch.result.price}}, and {{$props.asset}} when the value should come from a trigger, prior node, or reusable workflow prop.