Skip to main content
// WorkCase 03 — Product · 2026Status: Shipped2026

Custom CRM
In-house replacement for a licensed vendor platform.

Forensic teardown · architecture · build · audit

Custom CRM

// Stack

Next.jsPostgreSQLDrizzleDocker

A full forensic teardown of a third-party admissions CRM — two portals, 8 admin sections, 35 screens, 14 modules — then a provider-agnostic rebuild on Next.js, PostgreSQL, Drizzle and Docker, hardened by a line-by-line security audit.

// The brief

Replaced a licensed admissions CRM with an in-house, provider-agnostic platform — documented every control and route before writing a line of code, then rebuilt, hardened and validated it.

Automated checks345
Cross-tenant exposures closedall
// 01 — What I built4 components
01

Forensic teardown first.

Two portals, 8 admin sections, 35 screens, 14 modules, every control and API route documented — before writing a line of code.

02

Provider-agnostic rebuild.

Next.js, PostgreSQL, Drizzle and Docker — 37 routes, a background job worker, and configurable pipelines, fields, role matrix, templates, attribution and automation controls.

03

Hardened by audit.

Closed cross-tenant write exposure on all lead actions, unscoped queries, record-scope enforcement and an overridable suppression control.

04

Validated.

345 automated checks across 8 suites, three consecutive clean runs and zero worker-job failures.

// 02 — OutcomesMeasured, not claimed
37

Routes delivered

345

Automated checks

14

Modules rebuilt

0

Worker-job failures

Want something like this built?