> ## Documentation Index
> Fetch the complete documentation index at: https://docs.encoreos.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Supabase bootstrap artifacts

> Supporting files for the Bootstrap and test Supabase CI runbook (operator steps).

Supporting files for the **Bootstrap and test Supabase CI** runbook (operator steps).

| File                                | Purpose                                                                                                                                                                      |
| ----------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `dev-cron-storage-queries.sql`      | Queries to run in Dev SQL Editor to snapshot `cron.job` and `storage.buckets`.                                                                                               |
| `dev-cron-storage.txt`              | Paste query results here; use when recreating cron/buckets in Prod.                                                                                                          |
| `edge-function-secrets.example.env` | Template of `Deno.env` keys used across Edge Functions — copy to a **gitignored** `.env.production.functions` and fill values from Dev Dashboard → Edge Functions → Secrets. |
| `CI_RUN_LOG_2026-04-22.md`          | What we ran in CI and how failures were triaged.                                                                                                                             |
| `DEV_MIGRATION_REPAIR_REQUIRED.md`  | When **Deploy Supabase (dev)** fails: how to fix Dev `schema_migrations` safely.                                                                                             |
| `OPERATOR_CHECKLIST.md`             | Edge secrets, cron/storage replay, seed parity, and CI unblock steps.                                                                                                        |
| `PREFLIGHT_2026-04-22.md`           | Automated secret / workflow presence checks.                                                                                                                                 |

Do not commit real secrets.

**Scripts:** `scripts/supabase/list-edge-function-env-keys.mjs` — regenerate `edge-function-secrets.example.env` keys if needed.

**Dev migration repair:** `npm run db:dev:diff-migrations` and `npm run db:dev:emit-repair-sql` — see [DEV\_MIGRATION\_REPAIR\_REQUIRED.md](/development/supabase/bootstrap-artifacts/DEV_MIGRATION_REPAIR_REQUIRED).

**Prod Edge secrets file:** `npm run supabase:verify:production-functions-env` — see [OPERATOR\_CHECKLIST.md](/development/supabase/bootstrap-artifacts/OPERATOR_CHECKLIST).