D1 Migration
& KPI Launch

D1 + single Worker + Zero Trust identity. org_id on all tables. JSON answers column for flexibility. Done — you're reading the output.

Workers & Pages → D1 → Create database → name it switchpoint_db. Three clicks.

Tables: kpi_submissions, garden_log, marketing_tasks, org_chart, activity_log, facilities, departments. JSON answers column. org_id everywhere.

One Worker handles all tools. Endpoints: POST /submit, GET /submissions, GET /summary, POST /log. Reads Zero Trust header for identity. Bind D1 database.

POST a test KPI submission, GET it back, verify activity_log entry, confirm email comes from header not body.

Single HTML file. Department selector at top drives conditional sections. Housing, Bed N Biscuits, Garden, Thrift/Boutique/Exchange, Coffee, Stepping Stones. POSTs JSON to Worker. Replaces Microsoft Forms entirely.

You have Housing questions solid. Confirm Bed N Biscuits, Garden, Thrift, Coffee, Stepping Stones question lists before building the form. Claude has Excel files as reference.

kpi.switchpoint.pages.dev or similar. Put behind Zero Trust — @switchpoint.org only. Test a real submission end to end.

Same navy/orange look Carol already knows. Strip out Excel upload. Replace with live D1 fetch via Worker. Traffic lights, week filter, location breakdown. No more manual uploads.

Occupancy, boarding revenue, grooming revenue, open slots. Reads from D1 kpi_submissions filtered by dept=bednbiscuits.

Migrate garden KPIs from KV to D1 reads. Harvest weight, subscription revenue, yield by crop. Same data, better home.

Three locations, one view with a location toggle. Daily sales, transactions, donation intake, top categories. Same dashboard template, different filter.

Daily revenue, transactions, top items, catering bookings, training completions. Small footprint, clean view.

Enrollment vs capacity, DWS subsidized vs self-pay, staff ratios, licensing compliance flags.

The command center. One page, all departments, traffic lights only. Click a department to drill in. This is her Monday morning screen.

One landing page. Cards for every tool: KPI Form, Housing, Garden, Thrift, Coffee, Stepping Stones, Bed N Biscuits, Marketing Tracker, Org Chart, CEO Hub. Staff always know where to go.

Every Cloudflare Pages deployment gets an Access policy. One policy, all apps. 20 minutes in the dashboard.

Hub URL, her login, what she'll see Monday morning. Nothing technical. Just "here's your dashboard, here's where to look."

Reality: something always takes longer than expected. This is your cushion. Use it guilt-free.