DOCS

Home

Getting Started

Client Library Reference

Tools

Framework Quickstarts

Web app tutorials

Mobile tutorials

AI & ML

Vector Search with OpenAI

Postgres resources

Drop All Tables in Schema

Select First Row per Group

Print PostgreSQL Version

Configuration

Guides

Querying joins and nested tables

REST & REALTIME

Auto-generated Docs

Client Libraries

Generating Types

GRAPHQL

GraphiQL Documentation

Features

Guides

Subscribing to Database Changes

Bring Your Own Database

Using Realtime with Next.js

Deep dive

Image Transformations

Managing Environments

Reference

Add-ons

Platform Management

Migrating and Upgrading

Billing

Single sign-on

Enable SSO for your organization

SSO with Azure AD

SSO with Google Workspace

SSO with Okta

Go-live Checklist

Production Readiness

Troubleshooting

HTTP and Project Issues

Migrate to Supabase

Self-Hosting with Docker

Auth Server

Storage Server

Realtime Server

Analytics Server

Functions Server

Auth

Caching / Offline-first

Developer Tools

Low-code

Messaging

Client libraries

Other tools

JavaScript

Database

Call a Postgres function

Auth

Verify and log in through OTP

Retrieve a session

Retrieve a new session

Retrieve a user

Update 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

Auth Admin

Functions

Invoke a function

Realtime

Subscribe to channel

Unsubscribe from a channel

Unsubscribe from all channels

Retrieve all channels

Storage

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

Misc

Supabase CLI

General

Initialize a local project

Link to a Supabase project

Start a container

Stop all containers

Retrieve container status

Testing

Run tests

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

Organizations

List all organizations

Edge Functions

Manage edge functions

Create a function

Download a function

Serve functions locally

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

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

Self-Hosting Realtime

Introduction

Back to Main Menu

Self-Hosting Analytics

Management API

Self-Hosting Functions

Introduction

Home

Resources

Examples

Official GitHub examples, curated content from the community, and more.

Glossary

Definitions for terminology and acronyms used in the Supabase documentation.

Migrate to Supabase#

Postgres Resources#

Managing Indexes

Improve query performance using various index types in Postgres.

Drop all tables in schema

Delete all tables in a given schema.

Select first row per group

Retrieve the first row in each distinct group.

Print PostgreSQL version

Find out which version of Postgres you are running.

Supabase 2022—Contributing Changelog Author Styleguide Open Source SupaSquad