Skip to content

Supabase

Node: supabase · Full type: n8n-nodes-base.supabase · Version: 1

Credentials

supabaseApi (alias: @supabase)

CREDENTIAL @supabase = supabaseApi "My Supabase"

Operations

Resource: row

create

Parameter Type Default Details
tableId options "" required
dataToSend options "defineBelow" autoMapInputData, defineBelow
inputsToIgnore string ""
fieldsUi fixedCollection {} groups: fieldValues

delete

Parameter Type Default Details
tableId options "" required
filterType options "manual" manual, string
matchType options "anyFilter" anyFilter, allFilters
filters fixedCollection {} groups: conditions
filterString string ""

get

Parameter Type Default Details
tableId options "" required
filters fixedCollection {} groups: conditions

getAll

Parameter Type Default Details
tableId options "" required
returnAll boolean false
limit number 50
filterType options "manual" none, manual, string
matchType options "anyFilter" anyFilter, allFilters
filters fixedCollection {} groups: conditions
filterString string ""

update

Parameter Type Default Details
tableId options "" required
filterType options "manual" manual, string
matchType options "anyFilter" anyFilter, allFilters
filters fixedCollection {} groups: conditions
filterString string ""
dataToSend options "defineBelow" autoMapInputData, defineBelow
inputsToIgnore string ""
fieldsUi fixedCollection {} groups: fieldValues

Common Parameters

Parameter Type Default Details
useCustomSchema boolean false
schema string "public"

Parameter Details

fieldsUi children:

fieldValues group:

Parameter Type Default Details
fieldId options ""
fieldValue string ""

filters children:

conditions group:

Parameter Type Default Details
keyName options ""
condition options "" eq, fullText, gt, gte, ilike, is, lt, lte, ... (10 total)
searchFunction options "" fts, plfts, phfts, wfts
keyValue string ""

Example

NODE "supabase" @supabase AS "Supabase" {
  resource: "row",
  operation: "get"
}