All work

Lake Systems CRM

A working demo CRM for an invented company: revenue dashboard, drag-and-drop pipeline, contacts and tasks.

Role
Product scope, database schema and security, interface design and full-stack build.
Type
App, personal
Stack
Next.js, Supabase, Recharts, dnd-kit
Year
2026

Runs locally; not publicly deployed yet.

Lake Systems CRM, home page at desktop width
Lake Systems CRM, home page on a phone

The brief

Lake Systems is a made-up software-services company. The CRM is a complete working product built for it: a dashboard, a deal pipeline and the records behind them, designed to be re-skinned for a real business and to run on free tiers.

Drag the edge

Narrow the window to watch it fold into the phone layout.

localhost
Lake Systems CRM at desktop widthLake Systems CRM at phone width

Decisions that shaped it

Re-skinning is a two-file change

Colours are CSS tokens and every piece of company-specific text (owners, stages, win probabilities) sits in one brand file, so a new client's version changes two files and no components.

A private schema for a public demo

The tables live in their own schema with a dedicated role that cannot see anything else in the database, so a demo anyone can write to cannot reach real data.

Demo data that never goes stale

A SQL reset function regenerates the data from a fixed seed with dates relative to today, so the charts always look current and a visitor's changes can be undone in one call.

One connection per instance

The pooled transaction port hung when a page fired several queries at once. Session mode with a single connection passed every round with the real dashboard queries.

What's in it

  • Dashboard with five KPI tiles, won revenue by month, pipeline by stage and lead sources
  • Drag-and-drop pipeline with optimistic moves and a timeline entry per stage change
  • Company, contact, deal and task pages with create forms and activity logging
  • Search, status filters and date-range and owner filters kept in the URL
  • Light and dark themes
  • Zero console errors and zero overflow at phone and desktop widths