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
- Get Rows (
- 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
- Upload File (
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>) |
|---|---|
database | database.getRows, database.insertRow, database.updateRows, database.upsertRow, database.deleteRows, database.callFunction |
storage | storage.uploadFile, storage.downloadFile, storage.listFiles, storage.deleteFile |
Properties
Common
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Resource | resource | options | Yes | database | Database (database), Storage (storage) | - |
| Operation | operation | options | Yes | getRows | Get Rows (getRows), Insert Row (insertRow), Update Rows (updateRows), Upsert Row (upsertRow), Delete Rows (deleteRows), Call Function (callFunction) | resource = database |
| Operation | operation | options | Yes | uploadFile | Upload File (uploadFile), Download File (downloadFile), List Files (listFiles), Delete File (deleteFile) | resource = storage |
Database → Get Rows
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Table | table | string | Yes | '' | Name of the table or view to query | resource = database, operation = getRows |
| Columns | columns | string | No | * | Comma-separated columns to select, e.g. id,name,created_at | resource = database, operation = getRows |
| Filters | filters | json | No | {} | PostgREST filters as an object, e.g. { "id": "eq.5", "status": "in.(active,pending)" } | resource = database, operation = getRows |
| Order By | order | string | No | '' | PostgREST order clause, e.g. created_at.desc | resource = database, operation = getRows |
| Limit | limit | number | No | 100 | Maximum number of rows to return | resource = database, operation = getRows |
Database → Insert Row
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Table | table | string | Yes | '' | Name of the table to insert into | resource = database, operation = insertRow |
| Row Data | rowData | json | Yes | {} | Object (or array of objects) of column/value pairs to insert | resource = database, operation = insertRow |
Database → Update Rows
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Table | table | string | Yes | '' | Name of the table to update | resource = database, operation = updateRows |
| Filters | filters | json | Yes | {} | 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 Data | rowData | json | Yes | {} | Object of column/value pairs to set on matching rows | resource = database, operation = updateRows |
Database → Upsert Row
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Table | table | string | Yes | '' | Name of the table to upsert into | resource = database, operation = upsertRow |
| Row Data | rowData | json | Yes | {} | Object (or array of objects) of column/value pairs to upsert | resource = database, operation = upsertRow |
| Conflict Columns | onConflict | string | No | '' | Comma-separated column(s) that define the uniqueness constraint to upsert on, e.g. id | resource = database, operation = upsertRow |
Database → Delete Rows
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Table | table | string | Yes | '' | Name of the table to delete from | resource = database, operation = deleteRows |
| Filters | filters | json | Yes | {} | 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
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Function Name | functionName | string | Yes | '' | Name of the Postgres function exposed via PostgREST RPC | resource = database, operation = callFunction |
| Arguments | args | json | No | {} | Object of named arguments to pass to the function | resource = database, operation = callFunction |
Storage → Upload File
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Bucket | bucket | string | Yes | '' | Bucket name | resource = storage, operation = uploadFile |
| File Path | filePath | string | Yes | '' | Destination path within the bucket, e.g. folder/file.png | resource = storage, operation = uploadFile |
| Binary Property Name | binaryPropertyName | string | Yes | data | Name of the binary property which contains the data for the file to be uploaded | resource = storage, operation = uploadFile |
| Upsert | upsert | boolean | No | false | Overwrite the file if it already exists at this path | resource = storage, operation = uploadFile |
Storage → Download File
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Bucket | bucket | string | Yes | '' | Bucket name | resource = storage, operation = downloadFile |
| File Path | filePath | string | Yes | '' | Path of the file within the bucket, e.g. folder/file.png | resource = storage, operation = downloadFile |
| Binary Property Name | binaryPropertyName | string | Yes | data | Name of the binary property to which to write the downloaded file data | resource = storage, operation = downloadFile |
Storage → List Files
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Bucket | bucket | string | Yes | '' | Bucket name | resource = storage, operation = listFiles |
| Folder Path | folderPath | string | No | '' | Folder prefix to list within the bucket. Leave blank for the bucket root. | resource = storage, operation = listFiles |
| Limit | limit | number | No | 100 | Maximum number of files to return | resource = storage, operation = listFiles |
Storage → Delete File
| Property | Key | Type | Required | Default | Possible values | Applies when |
|---|---|---|---|---|---|---|
| Bucket | bucket | string | Yes | '' | Bucket name | resource = storage, operation = deleteFile |
| File Path | filePath | string | Yes | '' | Path of the file within the bucket, e.g. folder/file.png | resource = storage, operation = deleteFile |
Notes
filters,rowData, andargsaccept a JSON string or a native object/array.filtersare required forupdateRowsanddeleteRowsto prevent accidental bulk modifications.