Introduction
Initializing
Database
Fetch data
Insert data
Update data
Upsert data
Delete data
Call a Postgres function
Using filters
Match an associated value
Don't match the filter
Match at least one filter
Match the filter
Using modifiers
Return data after inserting
Order the results
Limit the number of rows returned
Limit the query to a range
Retrieve one row of data
Retrieve as a CSV
Auth
Overview
Create a new user
Listen to auth events
Sign in a user
Sign in with ID Token
Sign in a user through OTP
Sign in a user through OAuth
Sign out a user
Verify and log in through OTP
Retrieve a session
Retrieve a new session
Retrieve a user
Update a user
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
Edge Functions
Invokes a Supabase Edge Function.
Realtime
Subscribe to channel
Unsubscribe from a channel
Unsubscribe from all channels
Retrieve all channels
Broadcast a message
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
Retrieve public URL
Swift: Match an associated value
Examples
With `select()`
try await supabase.database .from("countries") .select("name") .match(["id": 2, "name": "Albania"])