# Supabase

> A hosted back end built on a Postgres database. It adds login and file storage.

**Field:** Software Development  
**Category:** Databases  
**Also known as:** Supabase Database, Supabase Postgres

## Think of it like

It is like a flat that comes with the furniture in. The rooms are a real home, and the bed is already made.

## Definition

Supabase is a hosted back end built around a PostgreSQL database. Each project gets a full Postgres database. Around it, Supabase adds user login, file storage, live updates and small server functions. It also makes an API for your tables. So a web or phone app can read and write data with no server of its own.

## Example

Lucy builds a small app over a weekend. Supabase gives her the database, the sign-in logic and photo storage. She only writes the front end.

## Example code

```javascript
const { data, error } = await supabase
  .from("orders")
  .select("id, total");
```

Reading rows from the orders table straight from the app, with the Supabase client.

## Why it matters

It lets a small team ship a full app without building a server. Because it is plain Postgres underneath, the data is not locked in.

## Common mistake

Leaving tables open to the public API. Turn on row level security and write rules for who can read each row.

## Three principles

- **Postgres underneath.** Each project is a real Postgres database.
- **Backend parts built in.** Login, storage, live updates and functions.
- **Lock down the API.** Rules decide who reads which rows.

## Related terms

- [PostgreSQL](https://learn.benibix.com/term/development/postgresql)
- [Relational Database](https://learn.benibix.com/term/development/relational-database)
- [Authentication](https://learn.benibix.com/term/development/authentication)
- [REST API](https://learn.benibix.com/term/development/rest-api)
- [Back End](https://learn.benibix.com/term/development/back-end)

## Told apart from

- [Supabase vs PostgreSQL](https://learn.benibix.com/compare/supabase-vs-postgresql): People think Supabase is its own kind of database, and it is not. Under it sits a normal PostgreSQL database, the same one you can run yourself. Supabase adds login, file storage and a ready-made API around it. So the SQL you know from Postgres works there too.

![Four relational databases in a row: PostgreSQL, MySQL, SQLite and Microsoft SQL Server, with a note that SQL Server speaks a version of SQL called T-SQL. Above PostgreSQL sits a larger box for Supabase. It holds a Postgres database and adds login, file storage, live updates and a ready-made API around it.](https://learn.benibix.com/diagrams/dev-db-products.svg)

---

Source: https://learn.benibix.com/term/development/supabase
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
