PM Schedule Generator
Generate preventive-maintenance work orders on the right cadence for every asset, attach the task checklist, route them through a planner for approval, assign them, and track completion - so PMs stop living on a wall calendar and in one person's head.
A private web tool that auto-generates due preventive-maintenance work orders per asset, lets a planner review/approve and assign them, lets technicians complete the checklist, and exports PM history plus the upcoming schedule as CSV.
Before you start
- A list of your assets/equipment with their PM intervals and task checklists (a spreadsheet is fine)
- Free Vercel, Supabase, and Resend accounts
- Claude Code installed on a Linux machine
The problem this kills
Preventive maintenance is where good intentions go to die. The PM schedule lives on a whiteboard, in a dusty binder, and mostly in the maintenance manager's head. When that person is on vacation - or just slammed - the 90-day gearbox lube slips to 140 days, the bearing fails, and a line goes down for a shift. Nobody planned it that way; the system just had no memory.
Spreadsheets help a little, but they can't tell you what's due. They don't roll the next date from the last time the job was actually done. They double-book. They email no one. And when the auditor asks "show me the PM history on press #4," you're flipping through paper.
This tool replaces the wall calendar and the manager's memory with something that quietly tracks every asset, knows exactly what's due and overdue, drafts the work orders, and refuses to forget.
What you'll build
A private, login-protected web app where:
- You keep your asset list with each asset's PM intervals (every X days/weeks/months) and the task checklist for each PM type.
- The tool generates the PM work orders that are due, with the right checklist attached - and the next-due date rolls forward from the last completion, not just the calendar, so a job done late doesn't immediately come due again.
- A maintenance planner reviews and approves the generated work orders, sets the schedule, and assigns a technician - nothing reaches the floor until a human signs off.
- Technicians complete the checklist and mark the work order done.
- The tool emails upcoming and overdue PMs so nothing slips silently.
- You export PM history and the upcoming schedule as clean CSV any time.
What's inside the Implementation Plan
The plan is a runbook you paste into Claude Code (an AI coding assistant). It builds the whole thing with you, step by step, in plain language.
It opens by interviewing you about your operation - your assets, how you name them, your PM intervals and task lists, your typical and peak work-order volumes, who approves and assigns, and the messy exceptions (assets down for repair, seasonal equipment, meter-based vs. calendar-based PMs). It reflects a short tailored spec back to you and waits for your thumbs-up. So you get a tool shaped to your plant, not a generic template you have to bend yourself into.
From there it builds the data model, the generation logic, the approval gate, the technician view, the email alerts, and the CSV exports - each step ending in a ready-to-paste prompt.
The governance it includes (this is the point)
This isn't a toy. The plan bakes in the controls a real maintenance operation needs:
- Login so only your team can get in.
- Row-level security so each organization only ever sees its own assets and work orders.
- A complete audit trail - who generated, approved, assigned, and completed each work order, and when.
- A hard human-in-the-loop approval gate - the tool drafts PM work orders, the planner reviews and approves, and only then are they released to technicians.
- Duplicate guards - the dedupe key is asset + PM type + due date, so the same PM can't be generated twice for the same window.
Who it's for
Maintenance planners, maintenance managers, and technicians at any plant, facility, or fleet operation that runs preventive maintenance on equipment - and is tired of doing it from memory and a whiteboard.
You've got this - paste the first prompt and let the plan interview you.