Skip to content
Try for free
On this page

Integrations

Supabase

Use Supabase database

Supabase provides Postgres databases and related project services. Use this integration to query, insert, update, and delete table rows, or select the storage, function, and other operations listed below. Configure your Project ID and Service Role Secret; table operations also require a table name. Use PostgREST filter syntax when filtering, ordering, or limiting row queries.

Use the block

Supports database operations (query, insert, update, delete, upsert), full-text search, RPC functions, Edge Function invocation, row counting, vector search, and complete storage management (upload, download, list, move, copy, delete files and buckets).

Actions

Supabase Query

Query data from a Supabase table

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
tablestringYesThe name of the Supabase table to query
schemastringNoDatabase schema to query from (default: public). Use this to access tables in other schemas.
selectstringNoColumns to return (comma-separated). Defaults to * (all columns)
filterstringNoPostgREST filter (e.g., "id=eq.123")
orderBystringNoColumn to order by (add DESC for descending)
limitnumberNoMaximum number of rows to return
offsetnumberNoNumber of rows to skip (for pagination)
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray of records returned from the query

Supabase Insert

Insert data into a Supabase table

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
tablestringYesThe name of the Supabase table to insert data into
schemastringNoDatabase schema to insert into (default: public). Use this to access tables in other schemas.
dataarrayYesThe data to insert (array of objects or a single object)
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray of inserted records

Supabase Get Row

Get a single row from a Supabase table based on filter criteria

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
tablestringYesThe name of the Supabase table to query
schemastringNoDatabase schema to query from (default: public). Use this to access tables in other schemas.
selectstringNoColumns to return (comma-separated). Defaults to * (all columns)
filterstringYesPostgREST filter to find the specific row (e.g., "id=eq.123")
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray containing the row data if found, empty array if not found

Supabase Update Row

Update rows in a Supabase table based on filter criteria

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
tablestringYesThe name of the Supabase table to update
schemastringNoDatabase schema to update in (default: public). Use this to access tables in other schemas.
filterstringYesPostgREST filter to identify rows to update (e.g., "id=eq.123")
dataobjectYesData to update in the matching rows
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray of updated records

Supabase Delete Row

Delete rows from a Supabase table based on filter criteria

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
tablestringYesThe name of the Supabase table to delete from
schemastringNoDatabase schema to delete from (default: public). Use this to access tables in other schemas.
filterstringYesPostgREST filter to identify rows to delete (e.g., "id=eq.123")
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray of deleted records

Supabase Upsert

Insert or update data in a Supabase table (upsert operation)

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
tablestringYesThe name of the Supabase table to upsert data into
schemastringNoDatabase schema to upsert into (default: public). Use this to access tables in other schemas.
dataarrayYesThe data to upsert (insert or update) - array of objects or a single object
onConflictstringNoComma-separated column(s) with a unique or primary key constraint to resolve conflicts on (e.g., "email"). Defaults to the primary key.
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray of upserted records

Supabase Count

Count rows in a Supabase table

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
tablestringYesThe name of the Supabase table to count rows from
schemastringNoDatabase schema to count from (default: public). Use this to access tables in other schemas.
filterstringNoPostgREST filter (e.g., "status=eq.active")
countTypestringNoCount type: exact, planned, or estimated (default: exact)
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
countnumberNumber of rows matching the filter

Supabase Text Search

Perform full-text search on a Supabase table

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
tablestringYesThe name of the Supabase table to search
schemastringNoDatabase schema to search in (default: public). Use this to access tables in other schemas.
columnstringYesThe column to search in
querystringYesThe search query
searchTypestringNoSearch type: plain, phrase, or websearch (default: websearch)
languagestringNoLanguage for text search configuration (default: english)
limitnumberNoMaximum number of rows to return
offsetnumberNoNumber of rows to skip (for pagination)
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray of records matching the search query

Supabase Vector Search

Perform similarity search using pgvector in a Supabase table

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
functionNamestringYesThe name of the PostgreSQL function that performs vector search (e.g., match_documents)
queryEmbeddingarrayYesThe query vector/embedding to search for similar items
matchThresholdnumberNoMinimum similarity threshold (0-1), typically 0.7-0.9
matchCountnumberNoMaximum number of results to return (default: 10)
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray of records with similarity scores from the vector search. Each record includes a similarity field (0-1) indicating how similar it is to the query vector.

Supabase RPC

Call a PostgreSQL function in Supabase

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
functionNamestringYesThe name of the PostgreSQL function to call
paramsobjectNoParameters to pass to the function as a JSON object
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsjsonResult returned from the function

Supabase Invoke Edge Function

Invoke a Supabase Edge Function over HTTP

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
functionNamestringYesThe name of the Edge Function to invoke (e.g., "hello-world")
methodstringNoHTTP method to use: GET, POST, PUT, PATCH, or DELETE (default: POST)
bodyjsonNoRequest payload to send to the function as a JSON object (ignored for GET)
headersjsonNoAdditional request headers as a JSON object of header name to value
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsjsonResponse body returned by the Edge Function

Supabase Introspect

Introspect Supabase database schema from its OpenAPI spec to get table and column structures (best-effort primary/foreign key detection)

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
schemastringNoDatabase schema to introspect (defaults to all user schemas, commonly "public")
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
tablesarrayArray of table schemas with columns, keys, and indexes
↳ namestringTable name
↳ schemastringDatabase schema name
↳ columnsarrayArray of column definitions
↳ namestringColumn name
↳ typestringColumn data type
↳ nullablebooleanWhether the column allows null values — a NOT NULL column that has a default value is misreported as nullable, since the OpenAPI spec this is derived from omits it from the required list in that case
↳ defaultstringDefault value for the column
↳ isPrimaryKeybooleanBest-effort guess based on the column being named "id" (not authoritative)
↳ isForeignKeybooleanTrue only if the column has a "references table.column" SQL comment; most databases will show false even for real foreign keys
↳ referencesobjectForeign key reference details, when detected via SQL comment
↳ tablestringReferenced table name
↳ columnstringReferenced column name
↳ primaryKeyarrayArray of primary key column names
↳ foreignKeysarrayArray of foreign key relationships
↳ columnstringLocal column name
↳ referencesTablestringReferenced table name
↳ referencesColumnstringReferenced column name
↳ indexesarrayAlways empty — index definitions are not exposed by the OpenAPI spec this tool reads
↳ namestringIndex name
↳ columnsarrayColumns included in the index
↳ uniquebooleanWhether the index enforces uniqueness
schemasarrayList of schemas found in the database

Supabase Storage Upload

Upload a file to a Supabase storage bucket

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the storage bucket
fileNamestringYesThe name of the file (e.g., "document.pdf", "image.jpg")
pathstringNoOptional folder path (e.g., "folder/subfolder/")
fileDatajsonYesFile to upload - UserFile object (basic mode) or string content (advanced mode: base64 or plain text). Supports data URLs.
contentTypestringNoMIME type of the file (e.g., "image/jpeg", "text/plain")
cacheControlstringNoCache-Control header value in seconds for the stored object (e.g., "3600"; default: "3600")
upsertbooleanNoIf true, overwrites existing file (default: false)
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsobjectUpload result including file path, bucket, and public URL
↳ IdstringUnique identifier for the uploaded file
↳ KeystringFull object key including bucket name
↳ pathstringPath to the uploaded file within the bucket
↳ bucketstringName of the bucket the file was uploaded to
↳ publicUrlstringPublic URL for the uploaded file

Supabase Storage Download

Download a file from a Supabase storage bucket

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the storage bucket
pathstringYesThe path to the file to download (e.g., "folder/file.jpg")
fileNamestringNoOptional filename override
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
filefileDownloaded file stored in execution files

Supabase Storage List

List files in a Supabase storage bucket

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the storage bucket
pathstringNoThe folder path to list files from (default: root)
limitnumberNoMaximum number of files to return (default: 100)
offsetnumberNoNumber of files to skip (for pagination)
sortBystringNoColumn to sort by: name, created_at, updated_at, last_accessed_at (default: name)
sortOrderstringNoSort order: asc or desc (default: asc)
searchstringNoSearch term to filter files by name
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray of file objects with metadata
↳ idstringUnique file identifier
↳ namestringFile name
↳ bucket_idstringBucket identifier the file belongs to
↳ ownerstringOwner identifier
↳ created_atstringFile creation timestamp
↳ updated_atstringLast update timestamp
↳ last_accessed_atstringLast access timestamp
↳ metadataobjectFile metadata including size and MIME type
↳ sizenumberFile size in bytes
↳ mimetypestringMIME type of the file
↳ cacheControlstringCache control header value
↳ lastModifiedstringLast modified timestamp
↳ eTagstringEntity tag for caching

Supabase Storage Delete

Delete files from a Supabase storage bucket

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the storage bucket
pathsarrayYesArray of file paths to delete (e.g., ["folder/file1.jpg", "folder/file2.jpg"])
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray of deleted file objects
↳ namestringName of the deleted file
↳ bucket_idstringBucket identifier
↳ ownerstringOwner identifier
↳ idstringUnique file identifier
↳ updated_atstringLast update timestamp
↳ created_atstringFile creation timestamp
↳ last_accessed_atstringLast access timestamp

Supabase Storage Move

Move a file within a Supabase storage bucket

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the storage bucket
fromPathstringYesThe current path of the file (e.g., "folder/old.jpg")
toPathstringYesThe new path for the file (e.g., "newfolder/new.jpg")
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsobjectMove operation result
↳ messagestringOperation status message
↳ IdstringIdentifier of the destination object
↳ KeystringFull object key of the destination

Supabase Storage Copy

Copy a file within a Supabase storage bucket

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the storage bucket
fromPathstringYesThe path of the source file (e.g., "folder/source.jpg")
toPathstringYesThe path for the copied file (e.g., "folder/copy.jpg")
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsobjectCopy operation result with the destination object key
↳ KeystringFull object key of the copied file
↳ IdstringIdentifier of the copied object

Supabase Storage Create Bucket

Create a new storage bucket in Supabase

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the bucket to create
isPublicbooleanNoWhether the bucket should be publicly accessible (default: false)
fileSizeLimitnumberNoMaximum file size in bytes (optional)
allowedMimeTypesarrayNoArray of allowed MIME types (e.g., ["image/png", "image/jpeg"])
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsobjectCreated bucket result (name)
↳ namestringCreated bucket name

Supabase Storage Update Bucket

Update the configuration of an existing Supabase storage bucket

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the bucket to update
isPublicbooleanNoWhether the bucket should be publicly accessible (leave unset to keep the current value)
fileSizeLimitnumberNoMaximum file size in bytes (leave unset to keep the current value)
allowedMimeTypesarrayNoArray of allowed MIME types (e.g., ["image/png", "image/jpeg"]) — leave unset to keep the current value
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsobjectUpdate operation result
↳ messagestringOperation status message

Supabase Storage Empty Bucket

Delete all objects inside a Supabase storage bucket without deleting the bucket itself

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the bucket to empty
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsobjectEmpty bucket operation result
↳ messagestringOperation status message

Supabase Storage List Buckets

List all storage buckets in Supabase

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsarrayArray of bucket objects
↳ idstringUnique bucket identifier
↳ namestringBucket name
↳ ownerstringOwner identifier
↳ publicbooleanWhether the bucket is publicly accessible
↳ created_atstringBucket creation timestamp
↳ updated_atstringLast update timestamp
↳ file_size_limitnumberMaximum file size allowed in bytes
↳ allowed_mime_typesarrayList of allowed MIME types for uploads

Supabase Storage Delete Bucket

Delete a storage bucket in Supabase

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the bucket to delete
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
resultsobjectDelete operation result
↳ messagestringOperation status message

Supabase Storage Get Public URL

Get the public URL for a file in a Supabase storage bucket

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the storage bucket
pathstringYesThe path to the file (e.g., "folder/file.jpg")
downloadbooleanNoIf true, forces download instead of inline display (default: false)

Output

ParameterTypeDescription
messagestringOperation status message
publicUrlstringThe public URL to access the file

Supabase Storage Create Signed URL

Create a temporary signed URL for a file in a Supabase storage bucket

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the storage bucket
pathstringYesThe path to the file (e.g., "folder/file.jpg")
expiresInnumberYesNumber of seconds until the URL expires (e.g., 3600 for 1 hour)
downloadbooleanNoIf true, forces download instead of inline display (default: false)
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
signedUrlstringThe temporary signed URL to access the file

Supabase Storage Create Signed Upload URL

Create a temporary signed URL a client can use to upload directly to a Supabase storage bucket

Inputs and outputs

Input

ParameterTypeRequiredDescription
projectIdstringYesYour Supabase project ID (e.g., jdrkgepadsdopsntdlom)
bucketstringYesThe name of the storage bucket
pathstringYesThe destination path for the uploaded file (e.g., "folder/file.jpg")
upsertbooleanNoIf true, allows overwriting an existing file at this path (default: false)
apiKeystringYesYour Supabase service role secret key

Output

ParameterTypeDescription
messagestringOperation status message
signedUrlstringThe temporary signed URL a client can PUT the file to
pathstringThe destination object path
tokenstringThe upload token embedded in the signed URL
Was this helpful?
Suggest an edit