Supabase

Use Supabase database

Usage Instructions

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

Tools

`supabase_query`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`table`	string	Yes	No description
`schema`	string	No	Database schema to query from (default: public). Use this to access tables in other schemas.
`select`	string	No	No description
`filter`	string	No	PostgREST filter (e.g., "id=eq.123")
`orderBy`	string	No	No description
`limit`	number	No	No description
`offset`	number	No	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of records returned from the query

`supabase_insert`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`table`	string	Yes	No description
`schema`	string	No	Database schema to insert into (default: public). Use this to access tables in other schemas.
`data`	array	Yes	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of inserted records

`supabase_get_row`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`table`	string	Yes	No description
`schema`	string	No	Database schema to query from (default: public). Use this to access tables in other schemas.
`select`	string	No	No description
`filter`	string	Yes	PostgREST filter to find the specific row (e.g., "id=eq.123")
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array containing the row data if found, empty array if not found

`supabase_update`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`table`	string	Yes	No description
`schema`	string	No	Database schema to update in (default: public). Use this to access tables in other schemas.
`filter`	string	Yes	PostgREST filter to identify rows to update (e.g., "id=eq.123")
`data`	object	Yes	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of updated records

`supabase_delete`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`table`	string	Yes	No description
`schema`	string	No	Database schema to delete from (default: public). Use this to access tables in other schemas.
`filter`	string	Yes	PostgREST filter to identify rows to delete (e.g., "id=eq.123")
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of deleted records

`supabase_upsert`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`table`	string	Yes	No description
`schema`	string	No	Database schema to upsert into (default: public). Use this to access tables in other schemas.
`data`	array	Yes	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of upserted records

`supabase_count`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`table`	string	Yes	No description
`schema`	string	No	Database schema to count from (default: public). Use this to access tables in other schemas.
`filter`	string	No	PostgREST filter (e.g., "status=eq.active")
`countType`	string	No	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`count`	number	Number of rows matching the filter

`supabase_text_search`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`table`	string	Yes	No description
`schema`	string	No	Database schema to search in (default: public). Use this to access tables in other schemas.
`column`	string	Yes	No description
`query`	string	Yes	No description
`searchType`	string	No	No description
`language`	string	No	No description
`limit`	number	No	No description
`offset`	number	No	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of records matching the search query

`supabase_vector_search`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`functionName`	string	Yes	The name of the PostgreSQL function that performs vector search (e.g., match_documents)
`queryEmbedding`	array	Yes	No description
`matchThreshold`	number	No	No description
`matchCount`	number	No	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array 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`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	Your Supabase project ID (e.g., jdrkgepadsdopsntdlom)
`functionName`	string	Yes	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	json	Result returned from the function

`supabase_introspect`

Introspect Supabase database schema to get table structures, columns, and relationships

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`schema`	string	No	Database schema to introspect (defaults to all user schemas, commonly "public")
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`tables`	array	Array of table schemas with columns, keys, and indexes
↳ `name`	string	Table name
↳ `schema`	string	Database schema name
↳ `columns`	array	Array of column definitions
↳ `name`	string	Column name
↳ `type`	string	Column data type
↳ `nullable`	boolean	Whether the column allows null values
↳ `default`	string	Default value for the column
↳ `isPrimaryKey`	boolean	Whether the column is a primary key
↳ `isForeignKey`	boolean	Whether the column is a foreign key
↳ `references`	object	Foreign key reference details
↳ `table`	string	Referenced table name
↳ `column`	string	Referenced column name
↳ `primaryKey`	array	Array of primary key column names
↳ `foreignKeys`	array	Array of foreign key relationships
↳ `column`	string	Local column name
↳ `referencesTable`	string	Referenced table name
↳ `referencesColumn`	string	Referenced column name
↳ `indexes`	array	Array of index definitions
↳ `name`	string	Index name
↳ `columns`	array	Columns included in the index
↳ `unique`	boolean	Whether the index enforces uniqueness
`schemas`	array	List of schemas found in the database

`supabase_storage_upload`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`bucket`	string	Yes	No description
`fileName`	string	Yes	The name of the file (e.g., "document.pdf", "image.jpg")
`path`	string	No	Optional folder path (e.g., "folder/subfolder/")
`fileData`	json	Yes	File to upload - UserFile object (basic mode) or string content (advanced mode: base64 or plain text). Supports data URLs.
`contentType`	string	No	MIME type of the file (e.g., "image/jpeg", "text/plain")
`upsert`	boolean	No	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	object	Upload result including file path, bucket, and public URL
↳ `id`	string	Unique identifier for the uploaded file
↳ `path`	string	Path to the uploaded file within the bucket
↳ `fullPath`	string	Full path including bucket name

`supabase_storage_download`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`bucket`	string	Yes	No description
`path`	string	Yes	The path to the file to download (e.g., "folder/file.jpg")
`fileName`	string	No	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`file`	file	Downloaded file stored in execution files

`supabase_storage_list`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`bucket`	string	Yes	No description
`path`	string	No	No description
`limit`	number	No	No description
`offset`	number	No	No description
`sortBy`	string	No	No description
`sortOrder`	string	No	No description
`search`	string	No	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of file objects with metadata
↳ `id`	string	Unique file identifier
↳ `name`	string	File name
↳ `bucket_id`	string	Bucket identifier the file belongs to
↳ `owner`	string	Owner identifier
↳ `created_at`	string	File creation timestamp
↳ `updated_at`	string	Last update timestamp
↳ `last_accessed_at`	string	Last access timestamp
↳ `metadata`	object	File metadata including size and MIME type
↳ `size`	number	File size in bytes
↳ `mimetype`	string	MIME type of the file
↳ `cacheControl`	string	Cache control header value
↳ `lastModified`	string	Last modified timestamp
↳ `eTag`	string	Entity tag for caching

`supabase_storage_delete`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`bucket`	string	Yes	No description
`paths`	array	Yes	Array of file paths to delete (e.g., ["folder/file1.jpg", "folder/file2.jpg"])
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of deleted file objects
↳ `name`	string	Name of the deleted file
↳ `bucket_id`	string	Bucket identifier
↳ `owner`	string	Owner identifier
↳ `id`	string	Unique file identifier
↳ `updated_at`	string	Last update timestamp
↳ `created_at`	string	File creation timestamp
↳ `last_accessed_at`	string	Last access timestamp

`supabase_storage_move`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`bucket`	string	Yes	No description
`fromPath`	string	Yes	The current path of the file (e.g., "folder/old.jpg")
`toPath`	string	Yes	The new path for the file (e.g., "newfolder/new.jpg")
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	object	Move operation result
↳ `message`	string	Operation status message

`supabase_storage_copy`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`bucket`	string	Yes	No description
`fromPath`	string	Yes	The path of the source file (e.g., "folder/source.jpg")
`toPath`	string	Yes	The path for the copied file (e.g., "folder/copy.jpg")
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	object	Copy operation result
↳ `message`	string	Operation status message

`supabase_storage_create_bucket`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`bucket`	string	Yes	No description
`isPublic`	boolean	No	No description
`fileSizeLimit`	number	No	No description
`allowedMimeTypes`	array	No	Array of allowed MIME types (e.g., ["image/png", "image/jpeg"])
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	object	Created bucket information
↳ `name`	string	Created bucket name

`supabase_storage_list_buckets`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of bucket objects
↳ `id`	string	Unique bucket identifier
↳ `name`	string	Bucket name
↳ `owner`	string	Owner identifier
↳ `public`	boolean	Whether the bucket is publicly accessible
↳ `created_at`	string	Bucket creation timestamp
↳ `updated_at`	string	Last update timestamp
↳ `file_size_limit`	number	Maximum file size allowed in bytes
↳ `allowed_mime_types`	array	List of allowed MIME types for uploads

`supabase_storage_delete_bucket`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`bucket`	string	Yes	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	object	Delete operation result
↳ `message`	string	Operation status message

`supabase_storage_get_public_url`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`bucket`	string	Yes	No description
`path`	string	Yes	The path to the file (e.g., "folder/file.jpg")
`download`	boolean	No	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`publicUrl`	string	The public URL to access the file

`supabase_storage_create_signed_url`

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	No description
`bucket`	string	Yes	No description
`path`	string	Yes	The path to the file (e.g., "folder/file.jpg")
`expiresIn`	number	Yes	No description
`download`	boolean	No	No description
`apiKey`	string	Yes	No description

Output

Parameter	Type	Description
`message`	string	Operation status message
`signedUrl`	string	The temporary signed URL to access the file

Speech-to-Text Table

On this page

Start building today

Trusted by over 100,000 builders.

The SaaS platform to build AI agents and run your agentic workforce.