Supabase Backup via Stacks

Overview

SimpleBackups connects to your Supabase account via OAuth and automatically discovers everything worth backing up across all your active projects — the PostgreSQL database, Storage buckets, Edge Functions, Auth configuration, PostgREST config, and Secrets.

No server required. No SSH. Just 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 → 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.

No API keys or passwords needed — connection is handled entirely via OAuth and refreshed automatically.

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 will 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, PostgREST Config

Exported as JSON files via the Supabase Management API. These 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 discoery 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. Simply don’t enable 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.

Supabase Stack Backup