Skip to content

Database

Migrations ship with the package. Apply them before every deploy that upgrades the version:

wrangler d1 migrations apply CMS_DB --remote

This includes 0004_username (sign in with a username) and 0005_jobs_log (job log and concurrency): without 0005, the cron cannot claim jobs and scheduled publishing stops.

If one is missing, the panel tells admins and shows the command, and GET /api/cms/health returns 503 ({ ok: false }; panel staff also get the list). Use it as a monitor check after every deploy.

Backups: D1 keeps Time Travel (7 days on the free plan, 30 on paid) — wrangler d1 time-travel restore CMS_DB --timestamp …. For a copy outside Cloudflare, wrangler d1 export CMS_DB --remote --output backup.sql.