Database

Reads and writes rows in the Supabase database the user connected. One node covers select, insert, update, upsert and delete.

Fields

FieldTypeRequiredWhat it does
operationone of: select, insert, update, upsert, deleteyesWhat to do with the table.
tablestringyesTable name.
filtershybridPostgREST 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.
rowshybridFor insert, upsert and update: the row or rows as a JSON string, for example "{\"title\":\"{{input.body.title}}\"}".
columnsstringselect only: columns to return, comma separated.
orderstringselect only: PostgREST order, for example "created_at.desc".
limitnumberselect only: up to 1000, defaults to 100.
offsetnumberselect only: rows to skip.
onConflictstringupsert 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.