What's in the backup
A single JSON file containing every row of all 22 tables (clients, quotes, builds, products, suppliers, calendar, employees, timesheets, stock takes & counts, stock requests, drawer slides, cleaning, checklists, meetings, JAP imports, cutting lists and more), fetched fresh from Supabase at download time so a table that was slow to load can't leave a silent gap. Workshop docs, tracking, ordering, payments and materials ride inside each build's consultation_snapshot.
Two-layer backup strategy
You're on Supabase Pro as of 2026-05-17, which means:
- Layer 1 (automatic): Supabase takes a full daily backup of every table, retained for 7 rolling days. If a save ever corrupts data you can roll back from Supabase dashboard → Backups.
- Layer 2 (manual, this page): The Download backup button above writes a JSON file to your machine. Run it before any big change or once a week, and keep the file in Dropbox / iCloud so you also have an off-Supabase copy.
The two layers protect against different failure modes. Supabase backups protect against bad saves and accidental deletes. Manual JSON exports protect against Supabase itself being unreachable, or against a billing lapse.