Supabase

Definition

Supabase is an open-source backend-as-a-service platform built around PostgreSQL, providing a managed database, authentication, auto-generated APIs, file storage, and real-time subscriptions out of the box.

Overview

Supabase launched in 2020 and explicitly positions itself as an open-source alternative to Google's Firebase, but built on PostgreSQL instead of a proprietary NoSQL store — so developers get a full relational database with SQL and joins rather than a document store. Every project gets a dedicated Postgres database, and Supabase layers auto-generated REST and GraphQL APIs directly on top of the schema, along with row-level security policies enforced by Postgres itself for fine-grained authorization. Supabase Auth handles user sign-up and login (email, OAuth, magic links), Supabase Storage manages file uploads, and Realtime streams database changes to connected clients over WebSockets; Edge Functions let developers run serverless logic close to users. Supabase is popular with indie developers and startups building full-stack apps quickly with frameworks like Next.js or React Native, since a single Supabase project replaces a database, auth server, file storage, and real-time layer that would otherwise require wiring together several separate services, unlike proprietary alternatives such as Firebase. It can be self-hosted or used as a managed cloud service.

Key Features

• Managed PostgreSQL database with full SQL, joins, and Postgres extensions
• Auto-generated REST and GraphQL APIs from the database schema
• Row-level security policies enforced directly by Postgres for authorization
• Built-in authentication via email, OAuth, and magic links
• Realtime subscriptions streaming database changes over WebSockets
• File storage and Edge Functions for serverless backend logic

Use Cases

Frequently Asked Questions

Related in Database