Skip to main content

Supabase

Type ID: supabase  ·  Kind: Action  ·  Ports: 1 in, 1 out

Read and write rows, call Postgres functions, and manage Storage files in Supabase.

Credentials​

Connect a Supabase credential via the integration picker.

{
"credentials": {
"name": "supabase",
"id": "<credential-id>"
}
}

Resources & operations​

  • Database (database)
    • Get Rows (getRows) - Select rows from a table or view, with optional filters
    • Insert Row (insertRow) - Insert a new row (or rows) into a table
    • Update Rows (updateRows) - Update rows matching filters
    • Upsert Row (upsertRow) - Insert a row, or update it on conflict
    • Delete Rows (deleteRows) - Delete rows matching filters
    • Call Function (callFunction) - Call a Postgres function exposed via PostgREST RPC
  • Storage (storage)
    • Upload File (uploadFile) - Upload a file to a Storage bucket
    • Download File (downloadFile) - Download a file from a Storage bucket
    • List Files (listFiles) - List files in a Storage bucket folder
    • Delete File (deleteFile) - Delete a file from a Storage bucket

For agent integrations (name: 'supabase' in permissions.integrations), grant '*', a resource key, or an operation key — see Tools and Permissions:

Resource key (<resource>)Operation keys (<resource>.<operation>)
databasedatabase.getRows, database.insertRow, database.updateRows, database.upsertRow, database.deleteRows, database.callFunction
storagestorage.uploadFile, storage.downloadFile, storage.listFiles, storage.deleteFile

Properties​

Common​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
ResourceresourceoptionsYesdatabaseDatabase (database), Storage (storage)-
OperationoperationoptionsYesgetRowsGet Rows (getRows), Insert Row (insertRow), Update Rows (updateRows), Upsert Row (upsertRow), Delete Rows (deleteRows), Call Function (callFunction)resource = database
OperationoperationoptionsYesuploadFileUpload File (uploadFile), Download File (downloadFile), List Files (listFiles), Delete File (deleteFile)resource = storage

Database → Get Rows​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
TabletablestringYes''Name of the table or view to queryresource = database, operation = getRows
ColumnscolumnsstringNo*Comma-separated columns to select, e.g. id,name,created_atresource = database, operation = getRows
FiltersfiltersjsonNo{}PostgREST filters as an object, e.g. { "id": "eq.5", "status": "in.(active,pending)" }resource = database, operation = getRows
Order ByorderstringNo''PostgREST order clause, e.g. created_at.descresource = database, operation = getRows
LimitlimitnumberNo100Maximum number of rows to returnresource = database, operation = getRows

Database → Insert Row​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
TabletablestringYes''Name of the table to insert intoresource = database, operation = insertRow
Row DatarowDatajsonYes{}Object (or array of objects) of column/value pairs to insertresource = database, operation = insertRow

Database → Update Rows​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
TabletablestringYes''Name of the table to updateresource = database, operation = updateRows
FiltersfiltersjsonYes{}PostgREST filters identifying which rows to update, e.g. { "id": "eq.5" }. Required as a safety rail against unscoped updates.resource = database, operation = updateRows
Row DatarowDatajsonYes{}Object of column/value pairs to set on matching rowsresource = database, operation = updateRows

Database → Upsert Row​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
TabletablestringYes''Name of the table to upsert intoresource = database, operation = upsertRow
Row DatarowDatajsonYes{}Object (or array of objects) of column/value pairs to upsertresource = database, operation = upsertRow
Conflict ColumnsonConflictstringNo''Comma-separated column(s) that define the uniqueness constraint to upsert on, e.g. idresource = database, operation = upsertRow

Database → Delete Rows​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
TabletablestringYes''Name of the table to delete fromresource = database, operation = deleteRows
FiltersfiltersjsonYes{}PostgREST filters identifying which rows to delete, e.g. { "id": "eq.5" }. Required as a safety rail against unscoped deletes.resource = database, operation = deleteRows

Database → Call Function​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
Function NamefunctionNamestringYes''Name of the Postgres function exposed via PostgREST RPCresource = database, operation = callFunction
ArgumentsargsjsonNo{}Object of named arguments to pass to the functionresource = database, operation = callFunction

Storage → Upload File​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
BucketbucketstringYes''Bucket nameresource = storage, operation = uploadFile
File PathfilePathstringYes''Destination path within the bucket, e.g. folder/file.pngresource = storage, operation = uploadFile
Binary Property NamebinaryPropertyNamestringYesdataName of the binary property which contains the data for the file to be uploadedresource = storage, operation = uploadFile
UpsertupsertbooleanNofalseOverwrite the file if it already exists at this pathresource = storage, operation = uploadFile

Storage → Download File​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
BucketbucketstringYes''Bucket nameresource = storage, operation = downloadFile
File PathfilePathstringYes''Path of the file within the bucket, e.g. folder/file.pngresource = storage, operation = downloadFile
Binary Property NamebinaryPropertyNamestringYesdataName of the binary property to which to write the downloaded file dataresource = storage, operation = downloadFile

Storage → List Files​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
BucketbucketstringYes''Bucket nameresource = storage, operation = listFiles
Folder PathfolderPathstringNo''Folder prefix to list within the bucket. Leave blank for the bucket root.resource = storage, operation = listFiles
LimitlimitnumberNo100Maximum number of files to returnresource = storage, operation = listFiles

Storage → Delete File​

PropertyKeyTypeRequiredDefaultPossible valuesApplies when
BucketbucketstringYes''Bucket nameresource = storage, operation = deleteFile
File PathfilePathstringYes''Path of the file within the bucket, e.g. folder/file.pngresource = storage, operation = deleteFile

Notes​

  • filters, rowData, and args accept a JSON string or a native object/array.
  • filters are required for updateRows and deleteRows to prevent accidental bulk modifications.