Supabase takes a daily backup of every Pro, Team and Enterprise project. Pro keeps 7 days, Team 14 and Enterprise up to 30. Free projects get none, and the docs recommend exporting with supabase db dump yourself.
Whether you can download one of those backups depends on its type. Projects on Postgres 15.8.1.079 and newer get physical backups: you can restore the project from them in the dashboard, but there is no file to download. Supabase's knowledge base says the same for projects with PITR, where the downloadable backup.gz is no longer generated.
For most current projects, a copy you hold yourself means taking a logical dump:
supabase db dump --db-url "$DB_URL" -f roles.sql --role-only supabase db dump --db-url "$DB_URL" -f schema.sql supabase db dump --db-url "$DB_URL" -f data.sql --use-copy --data-only
Enter fullscreen mode
Exit fullscreen mode
$DB_URL is the connection string under Connect in the dashboard.…