A full-stack internal operations platform built end-to-end for manufacturing businesses, replacing hand-maintained spreadsheets with a live, single source of truth for inventory, production, orders, equipment and more with a built-in AI assistant that can answer questions and make changes in plain English.
// The problemSpreadsheets
- Stock, production, and allocation data lived across manually updated spreadsheet files, with no single source of truth.
- No access control: anyone with the file could edit anything, with no record of who changed what or when.
- Nothing stopped bad states before they happened — the same stock could get double-allocated, or a machine assignment could conflict, with no automatic check.
- Answering a simple operational question (“what’s Paused on Machine 5 right now?”) meant manually scanning and filtering rows.
- A clean report for anyone outside the spreadsheet meant manual cleanup, every time.
// The solutionReal full-stack application
- One live web application backed by a relational database, replacing the spreadsheets as the single source of truth for stock, production, and allocations.
- A flexible, user-defined data model: instead of hardcoded tables, an admin can create new record types and fields at runtime — the system adapts to how the business actually works, rather than forcing the business into a fixed schema.
- Associations link related records together (a pipe to its stock and production allocations, a contact to their orders), with inline previews of the fields that matter most.
- Role-based access control: an Owner role that can edit, and a View-only role for everyone else, enforced at every layer of the app — the network layer, every API endpoint, the UI itself, and an automated check that locks down any newly added feature by default, so a permission can never be accidentally left open as the system grows.
- Spreadsheet export is still there for when a client needs a file — but now it’s a clean byproduct of good data, not the data’s home.
- A live dashboard — KPIs, charts, and status lists — that stays readable at any window size.
- A built-in AI assistant, built on Anthropic’s Claude, with direct access to the live data: it answers operational questions in plain English, makes bulk changes from a single sentence, applies the business’s own operating rules automatically, respects the exact same permission system as everyone else, and understands new record types and fields the moment they’re created.
// What’s in itFeatures
- A custom object system built from scratch — user-defined objects, fields, and associations
- Role-based authentication and user management (invite, edit, deactivate), built in-house rather than bolted on
- A real-time dashboard with KPIs and charts
- Record-level notes, file attachments, and change history
- Configurable spreadsheet export with mergeable, reorderable columns
- An AI assistant with live, tool-calling access to the database schema, bound by the same business rules and permissions as the rest of the app