Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problemsSupabase Free projects do not have downloadable managed database backups. You can still create your own logical export with the Supabase CLI, but it is a manual file-based backup—not Supabase-managed daily backups or point-in-time recovery (PITR). The steps below show how to export the database and what you need to protect and restore separately.
What “no backups” means on Supabase Free
Supabase’s production checklist says that “Database backups are not available for download for Free Plan projects.” That refers to Supabase-managed downloadable backups; it does not prevent you from creating your own export. The official checklist is at Supabase’s production checklist.
As an Amazon Associate I earn from qualifying purchases.
A CLI dump is a logical export that you create and store yourself. It does not provide a managed backup schedule, retention policy, or PITR. Supabase’s paid plans have managed daily backups: the current feature page lists seven days of retention for Pro, 14 days for Team, and up to 30 days for Enterprise. PITR is a separate add-on; its recovery-point wording varies across official pages, so check the current plan details in your dashboard rather than treating a stated interval as a universal guarantee. See Supabase’s database backup documentation and PITR documentation.
Export the database with the Supabase CLI
The documented workflow writes three SQL files—roles, schema, and data—to your current local environment. You need the Supabase CLI and Docker Desktop. Before starting, make sure the computer has enough space for the exports and that you have a secure place to keep them.
#1 Best Overall
- Easily store and access 2TB to content on the go with the Seagate Portable Drive, a USB external hard drive
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
-
Install the Supabase CLI and Docker Desktop. The CLI guide lists both as prerequisites for this workflow. Follow the installation steps in Supabase’s backup and restore guide.
-
Get your database connection string. In the Supabase dashboard, open the project’s Connect panel and copy a connection string. The guide recommends the Session pooler string by default. It says to use the direct connection string only when your network supports IPv6 or an IPv4 add-on is enabled. You also need the database password.
-
Run the three dump commands. Replace
[CONNECTION_STRING]with the connection string from the dashboard. Keep the connection string private: it contains credentials.Free tools Windows power users keep installed
One-click scans. No signup required.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.Rank #2
Seagate Portable 5TB External Hard Drive HDD – USB 3.0 for PC, Mac, PS4, & Xbox - 1-Year Rescue Service (STGX5000400), Black- Easily store and access 5TB of content on the go with the Seagate portable drive, a USB external hard Drive
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
supabase db dump --db-url [CONNECTION_STRING] -f roles.sql --role-only supabase db dump --db-url [CONNECTION_STRING] -f schema.sql supabase db dump --db-url [CONNECTION_STRING] -f data.sql --use-copy --data-only -x "storage.buckets_vectors" -x "storage.vector_indexes"The commands follow Supabase’s documented export example. The data command uses COPY and excludes the two named storage-related vector tables.
-
Protect the resulting files. The files are created in the local environment where you ran the commands. Restrict access to them and keep a separate copy if losing that computer is a risk. An external drive is one possible local copy; an off-site copy addresses a different failure mode. The CLI does not require a particular storage device or provider.
What the export does—and does not—cover
The export is for the database, not a complete copy of your Supabase project. Supabase states that database backups do not include objects stored through the Storage API. If you rely on uploaded files, back them up separately. See Supabase’s database backup overview.
Rank #3
- Easily store and access 1TB to content on the go with the Seagate Portable Drive, a USB external hard drive.Specific uses: Personal
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop. Reformatting may be required for Mac
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
A database dump also does not recreate every project setting or service. A new-project restore may require you to configure items such as Edge Functions, Auth settings and API keys, Realtime settings, Storage objects and settings, and some extensions. The managed restore-to-new-project workflow covers some items, but these manual configuration points still matter when planning recovery. Consult Supabase’s restore-to-new-project documentation.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Be especially careful with custom changes to the managed auth and storage schemas, Vault secrets, and encrypted columns. Supabase’s manual restore guidance notes that custom schema changes may need separate diff or migration handling; unlike its new-project and branching flows, the manual route does not copy the encryption root key automatically.
Restore the dump into a new project
Restoration is a separate, manual operation—not a one-click undo. Supabase’s guide describes creating a new project, enabling required extensions and Database Webhooks, then restoring the role, schema, and data files with psql. The commands use ON_ERROR_STOP so the restore halts when an SQL error occurs. Follow the current sequence in the official backup and restore guide, adapting its connection details to the destination project.
Rank #4
- Easily store and access 4TB of content on the go with the Seagate Portable Drive, a USB external hard drive.Specific uses: Personal
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
-
Set passwords manually for custom roles with login attributes.
-
Re-enable Realtime publications if your application uses them.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Review customizations to managed schemas and handle migrations or diffs separately where needed.
Best Value
Sale
UnionSine 500GB Ultra Slim Portable External Hard Drive HDD-USB 3.0- [Upgraded Version] - This external hard drive features a mirrored logo stripe combined with a striped anti-slip design, and the rounded corners of the casing make it easier to grip. The stripes also have a heat dissipation function, ensuring stable and fast data transfer.
- 【Ultra-thin and quiet】 - The motherboard adopts JMicron 578 noise-free solution, giving you a quiet working environment. Lightweight and portable size designed to fit in your pocket for easy portability.
- 【Ultra-Fast Data Transfers】 - Pairing this external hard drive with JMicron 578 solution USB 3.0 and USB 2.0 interfaces enables blazing-fast data transfer. It boasts theoretical read speeds of up to 125MB/s and write speeds of up to 103MB/s.
- 【Plug and Play】 - With no software to install, just plug it in and the drive is ready to use.The hard disk chip is wrapped with an aluminum anti-interference layer to increase heat dissipation and protect data.
- 【What You Get】 - 1 x Portable Hard Drive, 1 x USB 3.0 Cable, 1 x User Manual, Gift-type shell packaging ,Three-year manufacturer's warranty and free technical support services.
-
Reconfigure project services and settings that the dump does not restore, and restore Storage objects from their separate backup.
Do not assume a successful SQL import means the whole application is ready. Check application connectivity, authentication, uploads, database functions, and any integrations that depend on project settings before directing users to the restored project.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Choose the right recovery approach
-
Use a CLI export when you want a self-managed logical copy and are prepared to store it securely and perform a manual restore.
Recommended Free Tools
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Consider a paid plan’s managed backups if scheduled backups and documented retention are important. Verify current eligibility and terms in Supabase’s backup documentation and your dashboard.
-
Consider PITR when recovering to a point in time matters, but verify the current add-on availability and recovery details for your project. Supabase says restore duration depends on the time since a full backup, WAL activity, and database size; it is not an instant-restore promise.
Supabase Free projects have a 500 MB database-size quota, and a Free project can enter read-only mode after exceeding that limit. This is a separate operational issue from backup availability. See the database size guide and billing guide.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
