Supabase actions reference

The Supabase integration gives you actions to retrieve and change rows, manage files in Storage, call Postgres functions and Edge Functions, and sign users in with Supabase Auth. Each action links to a page with a full walkthrough.

WHERE YOU CAN USE SUPABASE ACTIONS

Most Supabase actions are available in both places:

• In Data & API workflows (API Endpoints).
• In Interface workflows (for example when a user clicks a button).

This gives you a choice:

• Use an Interface workflow when you want a quick action that happens directly from the app (for example upload a profile picture).
• Use an API Endpoint when you want the safest setup for access control and data rules (recommended for anything sensitive).

Supabase Auth actions like Login, Sign Up, and Login with Provider are only available in Interface workflows.

LOOKING FOR HOW TO USE SUPABASE?

• If you chose Supabase as backend (browser connects directly to Supabase), you typically call these actions from Interface workflows and secure data with RLS. Learn how that mode works →
• If you opened this from a backend workflow warning: those workflows always run on your WeWeb server, not on Supabase. Learn more →
• If you chose Supabase as data source only, start with Supabase as a data source →

This integration provides actions you can use in workflows.

Action	Description
Database | Select	Retrieve rows from a Supabase table, with related data, filters, sorting, pagination, and optional count.
Database | Insert	Insert one or more rows into a Supabase table.
Database | Update	Update one or more rows in a Supabase table (requires filters).
Database | Upsert	Insert rows, or update them if they already exist (based on conflict columns).
Database | Delete	Delete one or more rows from a Supabase table (requires filters).
Storage | List Files	List files inside a Supabase Storage bucket.
Storage | Upload File	Upload a file to Supabase Storage.
Storage | Download File	Download a file from Supabase Storage.
Storage | Update File	Replace an existing file in Supabase Storage.
Storage | Move File	Move/rename a file in Supabase Storage.
Storage | Copy File	Copy a file in Supabase Storage.
Storage | Delete Files	Delete one or more files from Supabase Storage.
Storage | Create Signed URL	Create a time‑limited URL for a private file.
Storage | Get Public URL	Get a public URL for a file in a public bucket (optional image transform).
Call Postgres Function	Call a Postgres function (RPC) in your Supabase project.
Invoke Edge Function	Call a Supabase Edge Function.
Sign up with email	Create a user with email and password (Supabase Auth).
Sign in with email	Sign in a user with email and password (Supabase Auth).
Sign in with provider	Sign in using a social provider configured in Supabase Auth.
Fetch user	Retrieve the currently signed‑in user from Supabase Auth.
Sign out	Sign out the currently signed‑in user from Supabase Auth.

Action details

Select

Retrieve rows from a table, with optional related data, filters, sorting, pagination, and count.

Inputs

Field	Description
Table	The table to retrieve rows from.
Columns	Which columns to return. Use the Columns flyout to pick fields, include related tables (References / Referenced by), set aliases, and choose a join type (Left or Inner).
Filters	Conditions to limit which rows you retrieve. Supports grouped And / Or logic and columns from related tables.
Sort	One or more sort rules (column + direction). Can include columns from related tables.
Limit	Maximum number of rows to return.
Offset	Number of rows to skip (useful for pagination).
Single row	Returns one object instead of an array (error if no row found).
Maybe single	Returns one object or null (no error if no row found).
Count	Row count mode: Exact count, Planned count, Estimated count, or No count.

Learn more about configuring Select →

Insert

Insert one or more rows into a table.

Inputs

Field	Description
Table	The table to insert into.
Data	Array of row objects to insert. Keys are column names.
Return columns	Which columns to return after insert. Leave empty for all columns.

Update

Update one or more rows in a table.

Inputs

Field	Description
Table	The table to update.
Filters	At least one filter is required (safety measure).
Data	The columns to update and their new values.
Return columns	Which columns to return after update. Leave empty for all columns.

Upsert

Insert rows, or update them if they already exist.

Inputs

Field	Description
Table	The table to upsert into.
Data	Array of row objects to upsert.
On conflict columns	Columns to check for conflicts. Defaults to the primary key if left empty.
Ignore duplicates	If enabled, duplicate rows are ignored instead of updated.
Return columns	Which columns to return after upsert. Leave empty for all columns.

Delete

Delete one or more rows from a table.

Inputs

Field	Description
Table	The table to delete from.
Filters	At least one filter is required (safety measure).
Return columns	Which columns to return from deleted rows. Leave empty for all columns.

List Files

List files in a bucket (optionally inside a folder).

Inputs

Field	Description
Bucket	The bucket to list files from.
Path	Optional folder path inside the bucket.
Limit	Maximum number of files to return.
Offset	Number of files to skip.
Search	Only return files that match this search string.
Sort by	Sort files by name, created date, updated date, or size.

Upload File

Upload a file to a bucket.

Inputs

Field	Description
Bucket	The bucket to upload to.
Path	Full path including filename (for example users/123/avatar.png).
File	The file you want to upload (for example from a file input).
Upsert	Overwrite the file if it already exists.
Content type	File type (MIME type). Usually auto‑detected.
Cache control	Cache duration in seconds.

Download File

Download a file from a bucket.

Inputs

Field	Description
Bucket	The bucket to download from.
Path	Full path to the file.

Update File

Replace an existing file in a bucket.

Inputs

Field	Description
Bucket	The bucket containing the file.
Path	Full path to the existing file to update.
File	The new file content.
Content type	File type (MIME type). Usually auto‑detected.
Cache control	Cache duration in seconds.

Move File

Move (rename) a file in a bucket.

Inputs

Field	Description
Bucket	The bucket containing the file.
From path	Current path of the file.
To path	New path for the file.

Copy File

Copy a file in a bucket.

Inputs

Field	Description
Bucket	The bucket containing the file.
From path	Path of the file to copy.
To path	Destination path for the copy.

Delete Files

Delete one or more files from a bucket.

Inputs

Field	Description
Bucket	The bucket containing the files.
File paths	An array of file paths to delete.

Create Signed URL

Create a time‑limited URL for a file (useful for private buckets).

Inputs

Field	Description
Bucket	The bucket that contains the file.
Path	File path inside the bucket.
Expires in (seconds)	How long the link should work for.
Transform	Optional image resizing/quality options (requires Supabase Pro plan).

Get Public URL

Get a public URL for a file in a public bucket.

Inputs

Field	Description
Bucket	The bucket (must be public).
Path	File path inside the bucket.
Download	If enabled, the URL triggers a download.
Transform	Optional image resizing/quality options (requires Supabase Pro plan).

Call Postgres Function

Call a Postgres function (RPC) from Supabase.

Inputs

Field	Description
Function name	The Postgres function you want to call.
Parameters	Key/value parameters for the function.
Single result	Return a single object instead of an array.

Invoke Edge Function

Call a Supabase Edge Function.

Inputs

Field	Description
Function	The Edge Function to invoke.
Method	HTTP method to use (for example POST).
Body	Data you want to send (for POST, PUT, PATCH).
Custom headers	Optional headers to send with the request.

Login

Sign in a user with email and password (Supabase Auth).

Inputs

Field	Description
Email	The user’s email.
Password	The user’s password.

Sign Up

Create a user with email and password (Supabase Auth).

Inputs

Field	Description
Email	The user’s email.
Password	The user’s password.
User metadata	Optional extra profile data to store on the user.
Email redirect URL	Optional redirect after the user confirms their email.

Login with Provider

Sign in with a social provider configured in Supabase Auth.

Inputs

Field	Description
Provider	The OAuth provider (for example Google or GitHub).
Redirect URL	Where to send the user after sign in.
Scopes	Optional extra scopes (space‑separated).
Query parameters	Optional extra settings to pass to the provider.

Fetch User

Retrieve the currently signed‑in user.

Inputs

This action has no inputs.

Sign Out

Sign out the currently signed‑in user.

Inputs

This action has no inputs.

CONTINUE LEARNING

Something doesn't work as expected? Check the most common Supabase issues and questions.

Supabase errors and FAQs →