Multi-Tenant CRM cover
All work

2024

Multi-Tenant CRM

A team CRM with row-level tenant isolation, granular roles, and a fast keyboard-driven pipeline board.

Overview

Built a CRM used by dozens of sales teams from schema to UI. Enforced tenant isolation with PostgreSQL row-level security so a query can never leak another workspace's data, layered role-based permissions on top, and designed an optimistic drag-and-drop pipeline that stays responsive on slow networks. Owned the GraphQL API, the Prisma data layer, and the React front end, plus the audit log that records every record change.

Role & impact

My role

Full-stack engineer — auth, tenancy, API, and front end.

Impact

Onboarded 40+ teams in the first quarter with zero cross-tenant data incidents.

Stack

TypeScriptReactGraphQLPrismaPostgreSQLDocker