Intermediate · 1–3 days
Operational tracker / simple CRM
Contacts, status, notes — enough structure to feel real, enough risk to practice access control.
Reference demo on this site
Reference from a real prompt run (Client Desk–style solo consultant tracker). Local mock with Supabase wiring TODOs — not multi-user production. Ian: seem working.
Open demo →Milestones
- Data model for contacts + notes
- List/detail UI
- Auth for a single operator
- Search + status filters
Starter prompt
Brief Create a simple CRM for a solo consultant: contacts, status tags, notes timeline, search. Use env-based Supabase config. Explain RLS assumptions. Never commit service role keys.
Constraints Keep scope finishable. Document env vars. No secrets in client code. Prefer accessible UI. List assumptions at the end.
Hardening notes
- Enable RLS; no open tables
- Validate ownership on every row
- Escape note content
Full checklist: Production reality & hardening.