n8n + Postgres operations platform
Compliance-safe automation starts with the data boundary.
A diagnostic for long-running, multi-state medical consulting workflows where Postgres is the system of record and n8n orchestrates document, approval, and outreach steps without handling PHI.
First design slice
| Area | Diagnostic focus |
|---|---|
| Data model | States, regulations, candidates, collaborations, documents, packets, standing orders, approvals, and outreach events. |
| Boundary rules | Explicit no-PHI assumptions, redaction rules, Drive/document references, and what n8n may store versus only reference. |
| Approval gates | Human signoff before regulatory changes, packet generation, outreach, and any recurring scheduled action. |
| Auditability | Append-only event log for automation decisions, sent packets, skipped candidates, failed runs, and manual overrides. |
| Operating model | Self-hosted n8n, Postgres backups, environment separation, retry policy, and recovery steps for long-running workflows. |
$29 diagnostic deliverable
- Entity map and first Postgres schema outline for the no-PHI workflow boundary.
- n8n orchestration map with approval gates and audit-log writes.
- Risk register for compliance, document versioning, and state-specific workflow changes.
- First implementation slice and fixed-scope estimate.