Database Backup

Download Full Backup

Downloads every table in the database as a single JSON file. This includes all campers, activities, schedules, assignments, staff, preferences, medical data, and configuration. Save this file to your computer, Google Drive, or a USB drive.

Automatic Weekly Backups

A Vercel cron job runs every Sunday at 2am ET and creates a backup automatically. To save these backups to a file, you can also bookmark this URL and download manually each week:

/api/cron/weekly-backup

Tip: Download a backup before and after major changes (like running the scheduler or doing bulk imports).

What's Included

All campers & bunk assignments
All activities & locations
Availability sets (A/B/C/D)
Camper preferences
All schedule assignments
Locks & overrides
Medical records
Activity restrictions
Staff & staff schedules
Staff days off & templates
Waterski roster & schedule
Swap history log

Disaster Recovery

If the site goes down and you need to recover, type "help - disaster" into Claude Code and it will walk you through the recovery steps. Full instructions are also saved in the file DISASTER_RECOVERY.md in the project root.

Key info to have ready:

  • Your latest backup JSON file
  • Your GitHub account (KateKelly10)
  • Your Neon database URL (in .env.local)
  • Your Vercel account login