LexFlow
Company-wide agency ERP, built solo
statusin production — internal
stackNext.js 16, Prisma 6 + Postgres, WebAuthn + NextAuth
userscompany-wide
scope96 models · 315 endpoints
teamsolo
updated2026
Next.js 16PrismaPostgresWebAuthn
01 / / the problem
An experiential agency's commercial workflow was spread across spreadsheets, shared drives and inboxes: quotes built by hand in Excel, rate cards in a folder, staffing agreed over chat, approvals lost in email. LexFlow collapses that chain into one system — a quotation is priced from live rate cards, resourced against real staff and inventory availability, approved by the client through a portal, and exported to finance without anyone re-keying a number.
02 / / what i built
→Quotation editor with sections, line items and versioning, priced from live rate cards
→Client portal — clients review and approve with a 6-digit access code, no account needed
→Project pipeline from lead through delivery, with boards and calendar views
→Resource booking across staff, assets, accessories, licences and vendors
→HR module: payroll, timesheets, attendance, time-off and expense claims
→Role and permission matrix, scoped per workspace
→Passkey and Face ID sign-in for staff via WebAuthn
→Encrypted credential vault with per-user sharing
→Real-time collaborative editing and internal messaging
→Excel and PDF export built for the finance handoff
→Audit log across every mutation
→Freelancer talent pool with gig applications
03 / / how i built it
Next.js 16
App Router server components keep 78 pages and 315 API routes in one deployable
Prisma 6 + Postgres
A 96-model schema needs migrations and relations that stay readable
WebAuthn + NextAuth
Passkeys for staff, access codes for clients — no shared passwords
Yjs
Two people editing the same quotation without overwriting each other
04 / / access
This one runs behind a company login, so there is no public URL to open. Happy to walk through the architecture and the parts I can show on a call.
Loom walkthrough — 90 seconds
Access is restricted to Lexicon Lore staff, clients and freelancers.
05 / / what's next
Next on the roadmap:
→Wider automated test coverage across the quotation and payroll paths
→Scheduled report delivery to finance instead of manual export pulls
→Quote-to-win conversion analytics on top of the existing pipeline data