Introduction
Initializing
Database
Fetch data
Insert data
Update data
Upsert data
Delete data
Call a Postgres function
Using filters
Column is equal to a value
Column is not equal to a value
Column is greater than a value
Column is greater than or equal to a value
Column is less than a value
Column is less than or equal to a value
Column matches a pattern
Column matches a case-insensitive pattern
Column is a value
Column is in an array
Column contains every element in a value
Greater than a range
Greater than or equal to a range
Less than a range
Less than or equal to a range
Mutually exclusive to a range
With a common element
Match a string
Don't match the filter
Match at least one filter
Match the filter
Auth
Overview
Create a new user
Listen to auth events
Sign in a user
Sign in a user through OTP
Sign in a user through OAuth
Sign in a user through SSO
Sign out a user
Send a password reset request
Verify and log in through OTP
Retrieve a session
Retrieve a new session
Retrieve a user
Update a user
Send a password reauthentication nonce
Resend an OTP
Set the session data
Exchange an auth code for a session
Auth MFA
Enroll a factor
Create a challenge
Verify a challenge
Create and verify a challenge
Unenroll a factor
Get Authenticator Assurance Level
Auth Admin
Retrieve a user
List all users
Create a user
Delete a user
Send an email invite link
Generate an email link
Update a user
List all factors for a user
Delete a factor for a user
Edge Functions
Invokes a Supabase Edge Function.
Realtime
Subscribe to channel
Unsubscribe from a channel
Unsubscribe from all channels
Retrieve all channels
Storage
Create a bucket
Retrieve a bucket
List all buckets
Update a bucket
Delete a bucket
Empty a bucket
Upload a file
Download a file
List all files in a bucket
Replace an existing file
Move an existing file
Copy an existing file
Delete files in a bucket
Create a signed URL
Create signed URLs
Create signed upload URL
Upload to a signed URL
Retrieve public URL
Kotlin: Copy an existing file
RLS policy permissions required:
buckets
table permissions: none
objects
table permissions:
insert
and
select
Refer to the
Storage guide
on how access control works
Examples
Copy file
supabase.storage["test"].copy(from = "avatar.png", to = "avatar2.png")