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 Sign in with Email, Sign up with Email, and Sign in 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.
Sign in with OTP	Send a one-time code or magic link to an email address.
Verify OTP	Check the one-time code the user received and sign them in.
Reset password for email	Send a password reset email.
Update user	Change the email, password or metadata of the signed‑in user.
Fetch User	Retrieve the currently signed‑in user from Supabase Auth.
Refresh Token	Get a new session for the signed‑in user.
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 rows	What to return after insert: All columns (default), Specific columns or None.
Return columns	Shown when Return rows is Specific columns. The columns to return after insert.

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 rows	What to return after update: All columns (default), Specific columns or None.
Return columns	Shown when Return rows is Specific columns. The columns to return after update.

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 rows	What to return after upsert: All columns (default), Specific columns or None.
Return columns	Shown when Return rows is Specific columns. The columns to return after upsert.

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 rows	What to return from deleted rows: All columns (default), Specific columns or None.
Return columns	Shown when Return rows is Specific columns. The columns to return from deleted rows.

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 a Column (Name, Created at, Updated at or Size) and an Order (Ascending or Descending).

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.

Sign in with Email

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 with Email

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.

Sign in 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	Optional, in the Advanced section. Where to send the user after sign in.
Scopes	Optional extra scopes (space‑separated).
Query parameters	Optional extra settings to pass to the provider.

Sign in with OTP

Send a one-time code or magic link to an email address. This action only sends the email: follow it with Verify OTP once the user has entered the code.

Inputs

Field	Description
Email	The email address to send the code to.
Create user if not exists	Optional, in the Advanced section. Creates a new user if no account uses this email. On by default.
Email redirect URL	Optional, in the Advanced section. Page to send the user to after they click the link in the email.

Verify OTP

Check the one-time code the user received and sign them in.

Inputs

Field	Description
Email	The user’s email.
Token	The code the user received.
Type	How the code was sent. It must match the action that sent it. Valid: email, email_change, invite, magiclink, phone_change, recovery, signup, sms.

Reset password for email

Send a password reset email. This action only sends the email: the new password is set later with Update user, on the page the reset link opens.

Inputs

Field	Description
Email	The email address to send the reset link to.
Redirect URL	Optional, in the Advanced section. Page to send the user to after they click the reset link.

Update user

Change the email, password or metadata of the signed‑in user. When you change the email, Supabase sends a confirmation link and the change only applies once the user clicks it.

Inputs

Field	Description
New email	Optional new email address.
New password	Optional new password.
Current password	Optional. The user’s current password, needed when your Supabase project asks for it before a password change.
User metadata	Optional profile data to update.

Fetch User

Retrieve the currently signed‑in user.

Inputs

This action has no inputs.

Refresh Token

Get a new session for the signed‑in user, so they stay signed in.

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 →