Database | Supabase Español

Every Supabase project gets a full Postgres database, not a Postgres abstraction. This database is the foundation that Auth, Storage, Realtime, and Edge Functions are built on, and Supabase manages daily database backups and offers point-in-time recovery on paid plans.

Work with your project's database in the following ways:

Visually using the Table Editor section of the Dashboard.
With query syntax using the SQL Editor section of the Dashboard.
Programmatically using a variety of different methods.

Get started

If you're new to the database section, these are the pages to read first:

Connect to your database: Connection strings, the Supavisor connection pooler, and when to use direct, transaction, or session mode.
Tables and data: Create tables and relationships, and edit rows from the Dashboard.
Import data: Load existing data from CSV files, pg_dump, or another Postgres database.
Secure your data: Row Level Security (RLS) is how Supabase makes the database safe to query directly from the client. Read this before exposing any table to your app.
Extensions: Add Postgres extensions from the Dashboard, including pgvector for embeddings, PostGIS for geospatial data, and pg_cron for scheduled jobs.
Run SQL commands: Use the Dashboard's SQL Editor for ad-hoc queries and saved snippets.

Next steps

Once you've covered the basics, these guides help with other use cases and features:

Database functions: Run logic inside the database in response to inserts, updates, or deletes.
Triggers: Run logic inside the database in response to inserts, updates, or deletes.
Database webhooks: Send row changes to an external HTTP endpoint.
Replication and read replicas: Stream changes to other systems or read from a geographically closer replica.
Backups: Daily backups on every project, with point-in-time recovery on paid plans. Backups cover the database itself; objects stored through the Storage API are not included.
Query performance and optimization: Indexes, the query planner, and tools for finding slow queries.
Roles and permissions: The Postgres roles Supabase ships with and how to add your own.
Deployment & Branching: Preview environments, branching, migrations, and production readiness for your database changes.