Backup Restore

Create point-in-time backups of tenant databases and restore from previous backups.

Prerequisites

• Tenant must be deployed with an active database
• Backup directory must be writable (backend/backups/)

Workflow — Create Backup

1. Validate Tenant

• Confirm tenant exists and has a deployed database
• Check available disk space

2. Export Data

• For each table in the schema, run SELECT * FROM <table>
• Capture full schema via schema endpoint
• Package into a timestamped backup file

3. Save Backup

backups/<tenant-name>/
  backup-<timestamp>.json
    ├── metadata: { tenant, database, timestamp, tables, rowCounts }
    ├── schema: { full schema snapshot }
    └── data: { table_name: [rows...] }