Getting Started

Serverless APIs

Client Library Reference

PythonCommunity

Tools

getting-started

Getting Started

Local Development

Framework Quickstarts

Web app tutorials

Mobile tutorials

AI & ML

Vector Search with OpenAI

database

Database Connections

Tables and Data

Database Functions

Database Webhooks

Full Text Search

Database Testing

Postgres resources

Managing Indexes

Cascade Deletes

Drop All Tables in Schema

Select First Row per Group

Print PostgreSQL Version

Configuration

reference

Serverless APIs

Guides

Creating API routes

How API Keys work

Securing your API

Querying joins and nested tables

REST & REALTIME

Auto-generated Docs

Client Libraries

Generating Types

GRAPHQL

GraphiQL Documentation

realtime

Features

Postgres Changes

Guides

Subscribing to Database Changes

Bring Your Own Database

Using Realtime with Next.js

Deep dive

storage

Image Transformations

reference-cli

Managing Environments

Reference

platform

Add-ons

Compute Add-ons

Database Backups

Platform Management

HTTP Status Codes

Migrating and Upgrading

Network Restrictions

Performance Tuning

SSL Enforcement

Billing

Single sign-on

Enable SSO for your organization

SSO with Azure AD

SSO with Google Workspace

Go-live Checklist

Production Readiness

Troubleshooting

HTTP and Project Issues

resources

Migrate to Supabase

Firebase Storage

resources

Self-Hosting with Docker

Auth Server

Storage Server

Realtime Server

Analytics Server

Functions Server

integrations

Auth

Caching / Offline-first

Developer Tools

Low-code

Messaging

reference

Client libraries

supabase-csharp

Other tools

Back to Main Menu

reference-javascript

JavaScript

Typescript Support

Database

Call a Postgres function

Using Modifiers

Auth

Create a new user

Sign in a user through OTP

Sign in a user through OAuth

Sign in a user through SSO

Sign out a user

Verify and log in through OTP

Retrieve a session

Retrieve a new session

Retrieve a user

Set the session data

Listen to auth events

Send a password reset request

Enroll a factor

Create a challenge

Verify a challenge

Create and verify a challenge

Unenroll a factor

Get Authenticator Assurance Level

Functions

Invoke a 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

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

Misc

Back to Main Menu

reference-cli

Supabase CLI

General

Initialize a local project

Log in to a Supabase account

Link to a Supabase project

Start a container

Stop all containers

Retrieve container status

Testing

Run tests (pgTAP)

Generate Types

Run code generation tools

Generate types (Postgres schema)

Generate types (TypeScript)

Database

Manage local databases

Dump schema from remote database

Push migration to remote database

Reset local database

Diff local database

Lint local database

Manage remote databases

Commit remote database changes

Migrations

Manage database migrations

Create a migration

List all migrations

Repair migration history table

Projects

Manage projects

Create a project

List all projects

Organizations

Manage organizations

List all organizations

Edge Functions

Manage edge functions

Create a function

Download a function

Serve functions locally

Deploy a function

Delete a function

Secrets

List all secrets

Authentication

Manage SSO on your project

List all identity providers

Show information for an identity providers

Add an identity provider

Update an identity provider

Remove an identity provider

See your project's SSO information

Custom Domains

Manage custom domains

Activate custom hostname

Create a custom hostname

Retrieve custom hostname config

Re-verify custom hostname config

Delete custom hostname config

Vanity Subdomains

Manage vanity subdomains

Activate a vanity subdomain

Retrieve vanity subdomain

Check subdomain availability

Delete vanity subdomain

Network Bans

Manage network bans

Retrieve network bans

Remove a network ban

Network Restrictions

Manage network restrictions

Retrieve network restrictions

Update network restrictions

SSL Enforcement

Manage SSL enforcement configuration

Get the current SSL enforcement configuration

Update SSL enforcement configuration

Autocompletion Scripts

Generate autocompletion scripts

Generate zsh script

Generate powershell script

Generate fish script

Generate bash script

Back to Main Menu

reference-auth

Self-Hosting Auth

Usage

Generates an email action link

Returns the created user

Redirects the user to the 3rd party oauth provider to start the oauth1 0 or oauth2 0 authentication process

Receives the redirect from an external provider during the oauth authentication process starts the process of creating an access and refresh token

The healthcheck endpoint for gotrue returns the current gotrue version

Sends an invite link to the user

Logs out the user

Passwordless sign in method for email or phone

Sends a password recovery email link to the users email

Returns the configuration settings for the gotrue server

Password based signup with either email or phone

Signs in a user with a password

Refreshes a users refresh token

Get information for the logged in user

Returns the updated user

Verifies a sign up

Back to Main Menu

reference-realtime

Self-Hosting Realtime

Back to Main Menu

reference-analytics

Self-Hosting Analytics

Management API

Create endpoint

Delete endpoint

Update endpoint

Back to Main Menu

reference-functions

Self-Hosting Functions

Home

Order the results


const { data, error } = await supabase
  .from('cities')
  .select('name, country_id')
  .order('id', { ascending: false })

Supabase 2022—Contributing Changelog Author Styleguide Open Source SupaSquad