DOCS

Home

Getting Started

Client Library Reference

Tools

Framework Quickstarts

Web app tutorials

Mobile tutorials

Examples

Channels

Image Transformations

Managing Environments

Reference

Add-ons

Platform Management

Migrating and Upgrading

Network Restrictions

Performance Tuning

Permissions

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

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

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

Secrets

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

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

Home

Column is less than a value

Finds all rows whose value on the stated column is less than the specified value.


final data = await supabase
  .from('cities')
  .select('name, country_id')
  .lt('country_id', 250);

Need some help?

Not to worry, our specialist engineers are here to help. Submit a support ticket through the Dashboard.

Supabase 2022—Contributing Changelog Author Styleguide Open Source SupaSquad