SerSanWorkshop ERPClient system
Maintech OMA
Custom ERP for a heavy-vehicle workshop of about 50 staff, founded from the application scaffold to the first database schema.
- Access
- no public address
9
roles, default-deny on every table
01 What it is
Foundedfrom the scaffold
A custom ERP for a heavy-vehicle workshop with about 50 staff across mechanics, mechatronics, auto-electrics, bodywork and refrigeration. I founded the system: the application scaffold, the 'Diesel & Safety' design system (design tokens, light and dark themes, a component library) and the first database schema the rest of the product was built on.
Stack
- Vite
- React 18
- TypeScript
- Supabase (Postgres 17, RLS, Edge Functions)
- TanStack Query
02 The domain core
Customerto purchase order
The domain core I delivered, from the customer to the order that buys the parts.
- 01Customers
- 02Vehiclesequipment and inspection deadlines
- 03Job ordersrole-gated transitions, safe numbering under concurrency
- 04Parts cataloguemulti-supplier price comparison
- 05Purchase orders
The domain core The job-order phases are numbered here, not named.
03 Security
What holdsat the database
A database-first security model that cannot be bypassed from the client: default-deny access rules on every table, per-site data segregation, and permissions held in the database rather than in tokens.
3
Live defects
Exposed by the first database test suite written against the model, and fixed before they reached production.
6
Phases
Job orders on a state machine with role-gated transitions and safe numbering under concurrency.
10
Trade portals
A connector console, article-level price comparison and a caching layer that never degrades a good supplier response; and a high-severity privilege escalation closed: it let any user with price access alter where supplier credentials were sent.
04 The record
- Studio
- SerSanSersan LimitedLondonRemote
- Client
- A heavy-vehicle workshop, about 50 staff
- Role
- Founded the system and its architecture
- Access
- Client system, no public address
- Photograph
- none
More work
- 01SerSan Agent OSSerSan · multi-agent systemOpen
- 02SphereNodeSerSan · live at spherenode.comOpen
- 03Sphere AISerSan · RAG mentorOpen
- 04Maintech OMASerSan · workshop ERPThis case
- 05sersan.ioSerSan · Jun – Sep 2026Next
- 06Domus TuaSerSan · real-estate brand platformOpen
- 07Brand filmSerSan · identity and filmOpen
- 08OblaPersonal project · multi-agent systemOpen
- 09Badante24hALS MCL Civitanova · freelanceOpen
- 10Voice AI AgentDOIT S.r.l · internshipOpen
- 11Supply ChainUniversity of CamerinoOpen