---
url: "https://supabase.com/database"
title: Database | Supabase
domain: supabase.com
locale: en
type: landing
words: 424
cited_by: 6
indexed_by: stealpage
---

## Postgreswithout the hassle

Every Supabase project is a dedicated Postgres database. Use it on its own, or with the rest of the Supabase platform. 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

alice@example.com

admin

true

https://i.pravatar.cc/150?u=alice

2

2024-01-15 10:45:12+00

Bob Smith

bob@example.com

editor

true

https://i.pravatar.cc/150?u=bob

3

2024-02-03 14:12:08+00

Carol Williams

carol@example.com

viewer

false

https://i.pravatar.cc/150?u=carol

4

2024-02-14 08:33:55+00

David Brown

david@example.com

editor

true

NULL

5

2024-03-01 16:07:29+00

Eve Martinez

eve@example.com

admin

true

https://i.pravatar.cc/150?u=eve

6

2024-03-10 11:52:44+00

Frank Lee

frank@example.com

viewer

true

https://i.pravatar.cc/150?u=frank

7

2024-03-22 07:18:03+00

Grace Kim

grace@example.com

editor

false

https://i.pravatar.cc/150?u=grace

8

2024-04-05 13:41:17+00

Henry Chen

henry@example.com

viewer

true

https://i.pravatar.cc/150?u=henry

9

2024-04-12 09:05:33+00

Isla Patel

isla@example.com

admin

true

https://i.pravatar.cc/150?u=isla

10

2024-04-18 15:22:07+00

Jack Rivera

jack@example.com

editor

false

NULL

11

2024-05-02 11:48:19+00

Karen Nguyen

karen@example.com

viewer

true

https://i.pravatar.cc/150?u=karen

12

2024-05-09 08:14:52+00

Liam O'Brien

liam@example.com

editor

true

https://i.pravatar.cc/150?u=liam

13

2024-05-21 17:33:28+00

Mia Tanaka

mia@example.com

admin

true

https://i.pravatar.cc/150?u=mia

14

2024-06-01 10:07:41+00

Noah Garcia

noah@example.com

viewer

false

https://i.pravatar.cc/150?u=noah

15

2024-06-14 14:55:03+00

Olivia Schmidt

olivia@example.com

editor

true

NULL

16

2024-06-23 06:29:17+00

Pablo Morales

pablo@example.com

viewer

true

https://i.pravatar.cc/150?u=pablo

17

2024-07-04 12:11:44+00

Quinn Foster

quinn@example.com

admin

true

https://i.pravatar.cc/150?u=quinn

18

2024-07-15 19:38:56+00

Ruby Aoki

ruby@example.com

editor

false

https://i.pravatar.cc/150?u=ruby

19

2024-07-28 07:52:10+00

Sam Walker

sam@example.com

viewer

true

https://i.pravatar.cc/150?u=sam

20

2024-08-03 16:04:33+00

Tara Singh

tara@example.com

admin

true

https://i.pravatar.cc/150?u=tara

### Everything you need  
from your database

Every Supabase project starts as a full Postgres database. Row Level Security, realtime subscriptions, and auto-generated APIs are built in and optional. Use what you need.

idint8

emailtext

roletext

1

alice@company.com

admin

2

bob@company.com

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

1

Alice

Hey, is the deploy ready?

2

Bob

Almost — running final tests now.

3

Alice

Nice, let me know when it’s live.

#### Data-change listeners over websockets.

Subscribe and react to database changes, milliseconds after they happen.

### Built for scale  
with powerful new features

### 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.