Recommended Free Tools
To test a Supabase database backup, restore it into an isolated local Supabase database or a separate project, then verify its schema, data, permissions, row-level security (RLS), and important application queries. A successful restore command proves only that the restore completed; it does not prove that the database is usable or that Storage files and other Supabase services are recoverable.
Choose a safe restore target
For local inspection, Supabase documents restoring a downloaded backup with the Supabase CLI. First identify the backup image’s PostgreSQL version and configure the local database to use it. Supabase says local restore support starts at PostgreSQL 15.1.0.55; a backup from an older hosted version may not restore locally. The CLI-started database is for local development, not production use. Follow Supabase’s local restore guide for the current command and setup details.
A separate hosted project is an alternative when you need a hosted environment for checks. Supabase labels restore-to-new-project as beta, and it is a database-only restore rather than a complete copy of the original project. Review the copied and missing components, access controls, and possible side effects before choosing this route. See Supabase’s new-project restore guide.
Whichever target you use, treat restored production data as sensitive: restrict access, use controlled credentials, and avoid exposing secrets in logs or test output.
#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
Restore and confirm the database is queryable
- Choose a recovery point. Record which downloaded backup or recovery point you are testing. Supabase’s daily backup access is listed as 7 days for Pro, 14 days for Team, and up to 30 days for Enterprise in its current Database Backups guide. Plan terms and availability can change, so check the live documentation before relying on a retention window. If PITR is enabled, select a point within the configured recovery window; Supabase says PITR offers restore points with up-to-seconds granularity, and its feature page states a two-minute worst-case recovery point objective. That is Supabase’s published figure, not a guarantee for every project or incident. Supabase also says PITR replaces daily backups while it is active.
- Match the PostgreSQL version where required. For a local downloaded-backup restore, check the backup image’s version and set the local version accordingly, as described in the local restore instructions. Supabase says projects on PostgreSQL
15.8.1.079and newer use its newer physical backup process; physical backups are enabled by default for eligible projects. Backup type can affect which restore and download paths are available. - Run the restore using the chosen path. For local inspection, use the CLI workflow in Supabase’s local restore guide. For a hosted restore, use the documented project restore flow and plan for possible unavailability during restoration; downtime depends on database size. A new-project restore is beta and database-only.
- Connect and issue a basic query. After a local restore starts, connect with
psqlas shown in the local guide, or use your application’s database client. Confirm that a simple query succeeds before moving on to content checks.
Do not assume restore duration is fixed. Supabase says PITR restore time depends on the time since the last full backup, WAL activity, and database size; its PITR troubleshooting guide explains these variables.
Verify schema, data, and database behavior
Check the expected schema
Compare the restored database with a known schema baseline or the source database. Check for the tables and schemas your application needs, plus relevant views, procedures, indexes, roles, and permissions. Supabase’s new-project restore documentation lists database schema, tables, views, procedures, data, indexes, roles, and permissions among the database content copied.
Rank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
Check representative data and relationships
Query records from important tables rather than relying only on table existence. Compare known row counts or application invariants where you have trustworthy reference values. Check key relationships and constraints—for example, whether records that should point to a parent still do so, and whether expected unique or foreign-key constraints are present. A query returning rows is useful evidence, but it does not establish that every table or relationship is intact.
Test permissions and RLS with realistic identities
Exercise access patterns using roles and user contexts that reflect the application. Verify that authorized operations succeed and that unauthorized reads or writes are blocked by the intended grants and RLS policies. Testing as an all-powerful database role alone can conceal application-facing access failures.
Rank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
Run application queries and repeatable tests
Test important reads and writes through the same Supabase client and application paths your service uses. Supabase documents two approaches to automated database tests: use a Supabase client in the application’s language and framework, or run SQL tests through the Supabase CLI. See Supabase’s database testing guide. Keep the checks repeatable so the same suite can be run after future backup drills or schema changes.
Check what a database restore does not recover
A database restore and a full Supabase project recovery are different tests. Supabase says database backups include Storage metadata but not the underlying Storage API objects. If application recovery depends on files, separately verify that the referenced objects and bucket configuration are available.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
A restore to a new project also requires manual reconfiguration of project-level components, including Storage objects and settings, Edge Functions, Auth settings and API keys, Realtime settings, extensions and database settings, and read replicas. Treat each required component as a separate recovery check rather than inferring it from successful database queries.
- Custom-role passwords: Supabase says daily backups do not store passwords for custom roles. Reset those passwords after restoring, then verify the relevant connections.
- Subscriptions and replication slots: When restoring a hosted project, subscriptions and replication slots may need to be dropped and recreated. Supabase says the Realtime slot is handled automatically.
- External operations: Supabase warns that enabled extensions with external operations may start running after a new-project restore completes. Review cron jobs, webhooks, and wrappers before using that path as a safe test environment.
- Logical backup availability: A downloaded backup can be restored locally for inspection. A logical export can also be made with the CLI or
pg_dump, but Supabase notes that physical-backup/PITR configurations do not necessarily produce a downloadable logical backup file. See its logical backup download guidance.
Include Vault in the recovery test when needed
If the database uses encrypted Vault secrets or encrypted columns, verify that the restored data can still be read or decrypted without printing secret values. Supabase documents that same-project restores and its new-project restore feature preserve or copy the encryption root key. A manual pg_dump/pg_restore migration creates a new project with its own key; copy the old root key if the migrated encrypted data must remain readable. See Supabase Vault documentation.
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
Make the backup drill repeatable
Keep a short record for each drill so a future restore can be compared against a known result:
- Backup or recovery point tested, and source and destination PostgreSQL versions.
- Restore errors and elapsed time.
- Schema, representative data, relationship, and application-query checks performed.
- Roles, grants, and RLS access patterns tested.
- Manual configuration or credential work still required for recovery.
Repeat the drill after material schema or backup-process changes. A passing test demonstrates only the database behaviors and recovery point you actually checked; it does not prove that every external service, file, or integration works. Supabase’s production checklist also covers backup and PITR planning.
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.
