# Supabase

Easy Supabase backups with automatic discovery across all your active projects.

SimpleBackups connects to your Supabase account via OAuth and automatically discovers everything worth backing up — the PostgreSQL database, Storage buckets, Edge Functions, Auth configuration, PostgREST config, and Secrets. No server required, no SSH: connect your Supabase account and SimpleBackups takes it from there.

## What gets discovered and backed up

| Resource | What gets backed up | Notes |
| --- | --- | --- |
| PostgreSQL Database | Full database dump | One per Supabase project |
| Storage Buckets | All files in the bucket | Backed up as a storage-to-storage transfer |
| Edge Functions | Function source code | All functions in the project, grouped as one backup |
| Auth Config | Email templates, OAuth providers, JWT settings | Exported as JSON |
| PostgREST Config | API configuration | Exported as JSON |
| Secrets | Secret names (reference only) | Values are masked by Supabase and cannot be retrieved |

## Prerequisites

- A Supabase account with at least one active project
- OAuth access granted to SimpleBackups (done during Stack setup — no manual API keys needed)

## Setup guide

### Step 1 — Create a Supabase Stack

Go to [Stacks](https://my.simplebackups.com/stack) → **Create Stack** and select **Supabase** as the provider.

### Step 2 — Connect your Supabase account

Click **Connect with Supabase**. You'll be redirected to Supabase to authorize SimpleBackups. Once authorized, you'll be returned to SimpleBackups automatically.

Connection is handled entirely via OAuth and refreshed automatically — no API keys or passwords are required.

### Step 3 — Configure discovery

Choose what to scan across your projects:

| Setting | Default | What it does |
| --- | --- | --- |
| Discover Storage Buckets | On | Finds and backs up all Storage buckets |
| Discover Edge Functions | On | Backs up all Edge Function source code |
| Discover Secrets | On | Lists secret names (values cannot be retrieved from Supabase) |
| Discover Auth Config | On | Backs up Auth settings (email templates, OAuth providers, JWT) |
| Discover PostgREST Config | On | Backs up PostgREST API configuration |

The **PostgreSQL database** is always discovered for every active project — it cannot be turned off.

### Step 4 — Run discovery

Click **Discover Resources**. SimpleBackups returns a list of everything found across all your active projects. Discovery is near-instant.

### Step 5 — Review and enable

You'll see all discovered resources grouped by project. For each one:

- Review the configuration
- Enter your **database password** for the PostgreSQL backup (required — Supabase does not expose passwords via API)
- Click **Enable** to activate the backup

## How each resource type is backed up

### PostgreSQL database

SimpleBackups connects directly to your Supabase project's PostgreSQL instance (`db.<project-ref>.supabase.co:5432`). The direct connection is used (not the connection pooler) to ensure a full, consistent dump.

You'll be prompted to enter your database password when enabling this backup. You can find it in your Supabase project under **Project Settings → Database**.

### Storage buckets

Storage bucket backups are handled as a **storage-to-storage transfer**. SimpleBackups creates a Storage connection for each discovered bucket and copies all files to your chosen backup destination.

Storage connections created during discovery appear in your **Storage** list and are managed automatically by SimpleBackups.

### Edge Functions

All Edge Functions in a project are backed up together as a single archive.

### Auth config and PostgREST config

These are exported as JSON files via the Supabase Management API. They are useful for auditing configuration changes and for disaster recovery (re-applying settings to a new project).

### Secrets (reference only)

Secret **names** are exported, but **values are always masked by Supabase** and cannot be retrieved via any API. This backup gives you a record of which secrets exist and when they were last seen.

## Multi-project support

If your Supabase account has multiple projects, SimpleBackups discovers all of them in a single scan. Each project's resources appear in the list independently, so you can enable backups selectively per project.

Only projects with status **ACTIVE_HEALTHY** are included in discovery.

## Troubleshooting

### "Supabase account not connected" error

- Go to Stack settings and click **Reconnect** to re-authorize the OAuth connection
- If the issue persists, disconnect and reconnect from scratch

### Storage bucket discovery is skipped with a warning

- SimpleBackups needs to fetch your project's service role key to access Storage
- This requires the OAuth token to have sufficient permissions
- Reconnecting your Supabase account usually resolves this

### Database backup fails with authentication error

- Verify the database password you entered is correct
- Find it in Supabase under **Project Settings → Database → Connection string**
- Note: the password is different from your Supabase account password

### Edge Functions not appearing

- Make sure your project has at least one deployed Edge Function
- If functions were deployed after the last discovery run, click **Discover Resources**

### Only some projects appear

- SimpleBackups only discovers projects with status **ACTIVE_HEALTHY**
- Projects in a paused, restoring, or error state are skipped automatically

## Frequently asked questions

**What if I rotate my database password?**

Update it in the backup configuration under **Backups → [your backup] → Edit**.

**Can I back up only specific Supabase projects?**

Not at the filter level — discovery always scans all active projects. However, you can choose which resources to enable after discovery. Skip the backups for projects you want to exclude.

**What permissions does SimpleBackups need on my Supabase account?**

Read access via OAuth. SimpleBackups never modifies your projects, databases, or functions.

- [Stack Discovery Overview](https://simplebackups.com/docs/stack-discovery/overview): How Stacks scan your infrastructure and turn discovered resources into automated backups.