Postgreswithout the hassle
Every Supabase project is a dedicated Postgres database. 100% portable with no vendor lock-in.
idint8 | created_attimestamptz | nametext | emailtext | roletext | is_activebool | avatar_urltext |
|---|---|---|---|---|---|---|
| 1 | 2024-01-15 09:23:41+00 | Alice Johnson | [email protected] | admin | true | https://i.pravatar.cc/150?u=alice |
| 2 | 2024-01-15 10:45:12+00 | Bob Smith | [email protected] | editor | true | https://i.pravatar.cc/150?u=bob |
| 3 | 2024-02-03 14:12:08+00 | Carol Williams | [email protected] | viewer | false | https://i.pravatar.cc/150?u=carol |
| 4 | 2024-02-14 08:33:55+00 | David Brown | [email protected] | editor | true | NULL |
| 5 | 2024-03-01 16:07:29+00 | Eve Martinez | [email protected] | admin | true | https://i.pravatar.cc/150?u=eve |
| 6 | 2024-03-10 11:52:44+00 | Frank Lee | [email protected] | viewer | true | https://i.pravatar.cc/150?u=frank |
| 7 | 2024-03-22 07:18:03+00 | Grace Kim | [email protected] | editor | false | https://i.pravatar.cc/150?u=grace |
| 8 | 2024-04-05 13:41:17+00 | Henry Chen | [email protected] | viewer | true | https://i.pravatar.cc/150?u=henry |
| 9 | 2024-04-12 09:05:33+00 | Isla Patel | [email protected] | admin | true | https://i.pravatar.cc/150?u=isla |
| 10 | 2024-04-18 15:22:07+00 | Jack Rivera | [email protected] | editor | false | NULL |
| 11 | 2024-05-02 11:48:19+00 | Karen Nguyen | [email protected] | viewer | true | https://i.pravatar.cc/150?u=karen |
| 12 | 2024-05-09 08:14:52+00 | Liam O'Brien | [email protected] | editor | true | https://i.pravatar.cc/150?u=liam |
| 13 | 2024-05-21 17:33:28+00 | Mia Tanaka | [email protected] | admin | true | https://i.pravatar.cc/150?u=mia |
| 14 | 2024-06-01 10:07:41+00 | Noah Garcia | [email protected] | viewer | false | https://i.pravatar.cc/150?u=noah |
| 15 | 2024-06-14 14:55:03+00 | Olivia Schmidt | [email protected] | editor | true | NULL |
| 16 | 2024-06-23 06:29:17+00 | Pablo Morales | [email protected] | viewer | true | https://i.pravatar.cc/150?u=pablo |
| 17 | 2024-07-04 12:11:44+00 | Quinn Foster | [email protected] | admin | true | https://i.pravatar.cc/150?u=quinn |
| 18 | 2024-07-15 19:38:56+00 | Ruby Aoki | [email protected] | editor | false | https://i.pravatar.cc/150?u=ruby |
| 19 | 2024-07-28 07:52:10+00 | Sam Walker | [email protected] | viewer | true | https://i.pravatar.cc/150?u=sam |
| 20 | 2024-08-03 16:04:33+00 | Tara Singh | [email protected] | admin | true | https://i.pravatar.cc/150?u=tara |
Everything you need
from your database
Every Supabase project is a full Postgres database with realtime functionality, fine-grained access controls, and instant APIs — no extra configuration required.
A dedicated Postgres database.
100% portable. Bring your existing Postgres database, or migrate away at any time.
idint8 | emailtext | roletext |
|---|---|---|
| 1 | [email protected] | admin |
| 2 | [email protected] | user |
CREATE POLICY "Users can read their own profile" ON public.users FOR SELECT USING (auth.uid() = id);
Built on Postgres' proven Row Level Security.
Integrated with JWT authentication which controls exactly what your users can access.
idint8 | usertext | texttext |
|---|
Data-change listeners over websockets.
Subscribe and react to database changes, milliseconds after they happen.
You can have a really great product, but you need to want to work with the people behind it. With Supabase, we always felt very aligned.
Built for scale
with powerful new features
Branching
- Branch your Supabase project
- Sync with your git branches
- Manage every Preview from the Dashboard
- Support for Vercel Previews
Read Replicas
- Serve data closer to your users
- Provide data redundancy
- Run complex queries without affecting your primary database
- Distribute load across various databases
Manage your data with a
built-in Table Editor
Manage your data with a spreadsheet-like interface. Create tables, set up relationships, and export — no SQL required.
Spreadsheet editing
Add, edit, and update your data with the simplicity of a no-code tool.
Write and run queries with a
full SQL Editor
Write, run, and save SQL queries directly from the dashboard with full autocomplete and syntax highlighting.
Full SQL
A full SQL editor built right into the dashboard.
Never write
an API again
We introspect your database and provide instant APIs. Focus on building your product, while Supabase handles the CRUD.
// Fetch all public rooms with their messages
const { data: rooms } = await supabase
.from('rooms')
.select(`
id, name, created_at,
messages ( id, text, user_id )
`)
.eq('public', true)
.order('created_at', { ascending: false })
.limit(20)// Fetch all public rooms with their messages
const { data: rooms } = await supabase
.from('rooms')
.select(`
id, name, created_at,
messages ( id, text, user_id )
`)
.eq('public', true)
.order('created_at', { ascending: false })
.limit(20)Kickstart your next project
with production ready templates
View all examples
Stripe Subscriptions Starter
The all-in-one subscription starter kit for high-performance SaaS applications, powered by Stripe, Supabase, and Vercel.
Next.js Starter
A Next.js App Router template configured with cookie-based auth using Supabase, TypeScript and Tailwind CSS.
AI Chatbot
An open-source AI chatbot app template built with Next.js, the Vercel AI SDK, OpenAI, and Supabase.
LangChain + Next.js Starter
Starter template and example use-cases for LangChain projects in Next.js, including chat, agents, and retrieval.
Flutter User Management
Get started with Supabase and Flutter by building a user management app with auth, file storage, and database.
Expo React Native Starter
An extended version of create-t3-turbo implementing authentication on both the web and mobile applications.