Equipment Asset Register & History: One Source of Truth for Every Machine
Turn binders and scattered spreadsheets into a clean equipment register — each asset with its ID, location, specs, manuals, warranty, and a running history of PMs, repairs, and costs — with the maintenance manager approving new assets and major status changes before they hit the register.
A web tool where you import or enter assets and their docs, the maintenance manager reviews and approves new records and major status changes, anyone can open a machine to see its full PM/repair/cost history, and you can export a clean asset-register CSV any time.
Before you start
- A Supabase account (free)
- A Vercel account (free)
- A Resend account (free)
- An asset list CSV (ID, description, location, install date, warranty, parent line)
- Manuals / photos to upload (optional)
- Claude Code or any AI coding agent
The problem this kills
Someone asks a simple question on the floor: "What is this machine, when did we last service it, is it still under warranty, and what has it cost us this year?" And the answer takes twenty minutes of flipping through a binder, hunting a serial number on a faded nameplate, and pinging two people who "think they remember." The manual for it is in a drawer somewhere. The install date is in an email. The repair from last spring lives in a notebook that left with the tech who did it.
Your asset data is real and valuable — it's just scattered. A clean equipment register fixes that without a six-figure CMMS rollout, and you don't need to be a developer to build one.
What you'll build
A simple internal web tool that is the single source of truth for every machine you maintain. You import or enter your asset list — asset ID, description, location, install date, warranty, parent line/cell — and upload the manuals, photos, and nameplate shots that go with each one. The maintenance manager reviews and approves new asset records (and major changes like retiring or transferring an asset) before they're committed to the register. From then on, anyone on the team can open a machine and see exactly what it is, where it lives, what's attached to it, and a running history of every PM and repair — with costs rolled up so you can answer "what's this machine cost us" in seconds. When you need it in another system, you export a clean asset-register CSV in the exact columns your CMMS or ERP expects.
What's inside the Implementation Plan
The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — how you number and name assets today, what your location/line/cell hierarchy looks like, which fields and codes you already use, where your current asset list and manuals live, your typical and peak asset counts, who's allowed to approve a new machine or retire one, and the messy edge cases (same machine moved between lines, assets that share a parent, decommissioned-but-not-disposed gear) — and then it tailors the data model, the validations, and every later step to your answers. This is not a generic template; the agent reads a short spec back to you and waits for your thumbs-up before it builds anything. From there it walks the agent through the import, the document uploads, the manager review-and-approve gate, the per-asset history view with cost rollups, and the CSV export — each step with a ready-to-copy prompt. There's also a fallback so you can build and run the whole thing today with no integration at all: asset CSV in, register CSV out.
The governance it includes (this is the point)
This is the master record for your equipment, so it ships with the controls a maintenance team needs: login so only your team can use it, row-level security so you only ever see your own organization's assets, a complete audit trail of who created, edited, approved, retired, or transferred each asset and when, a hard human-approval gate so a new asset or a major status change isn't committed to the register until the maintenance manager signs off, and duplicate guards keyed on asset ID so the same machine can't be entered twice. If you later build PM-schedule or work-request tools that share the same asset ID, this register auto-pulls their history so the machine's timeline stays complete.
Who it's for
Maintenance managers, planners, and reliability engineers who own the equipment data and are tired of it living in binders, nameplates, and three different spreadsheets. If you can describe how your plant numbers and groups its machines, you can build this.
You've got this — start with the plan, paste the first prompt, answer the interview, and you'll have your first machines in a real register the same afternoon.