Database
Reads and writes rows in the Supabase database the user connected. One node covers select, insert, update, upsert and delete.
Fields
| Field | Type | Required | What it does |
|---|---|---|---|
operation | one of: select, insert, update, upsert, delete | yes | What to do with the table. |
table | string | yes | Table name. |
filters | hybrid | PostgREST filters as a JSON string of column to expression, for example "{\"id\":\"eq.{{input.body.id}}\"}". Operators: eq, neq, gt, gte, lt, lte, like, ilike, in, is. Required for update and delete. | |
rows | hybrid | For insert, upsert and update: the row or rows as a JSON string, for example "{\"title\":\"{{input.body.title}}\"}". | |
columns | string | select only: columns to return, comma separated. | |
order | string | select only: PostgREST order, for example "created_at.desc". | |
limit | number | select only: up to 1000, defaults to 100. | |
offset | number | select only: rows to skip. | |
onConflict | string | upsert only: the column that decides a duplicate, for example "id". |
Output
operation, table, rows (array), count, first (the first row or null)
Notes
An update or delete without filters is refused, so a missing filter cannot wipe a table. The connection lives in the profile, never in the node.