Nonconformance Report (NCR) Tracker
Capture a nonconformance with photos, route it to the MRB for a disposition, record the action and cost, close it with verification, and trend escapes by defect and source - so quality problems are controlled, not scribbled on a tag.
A login-protected NCR system where a quality engineer submits an NCR with photos, the MRB reviews and approves a disposition before any material status changes, the action and cost are recorded, the NCR is closed with verification, and the whole register exports to CSV and trends by defect and source.
Before you start
- A free Supabase account
- A free Vercel account
- A free Resend account
- A list of the defect types, sources, and dispositions you actually use
The problem this kills
Right now your nonconformances live on paper tags, in a shared spreadsheet someone forgets to update, and in the heads of whoever was on shift. Material gets dispositioned by hallway conversation. NCR numbers collide or get skipped. Nobody can answer "how many scrap NCRs did we write against that supplier last quarter?" without an afternoon of digging. And the most dangerous gap: material gets released, reworked, or scrapped before the MRB (Material Review Board - the people authorized to decide what happens to bad parts) has actually signed off.
That is how a quality escape becomes a recall. You need every nonconformance captured the same way, routed through a real approval gate, and trended so the recurring problems become CAPAs (Corrective and Preventive Actions) instead of repeat surprises.
What you'll build
A simple web app your quality team logs into. A quality engineer or supervisor submits an NCR - what the item is, the lot or work order it came from, the defect, how many, the source - and attaches reference photos. The tool auto-numbers it and routes it to the MRB. The board reviews, picks a disposition (use-as-is, rework, scrap, return to supplier), and approves. Only after that approval does the affected material's status change. The action and its cost get recorded, the NCR is closed with a verification check, and the entire register exports to a clean CSV. You also get a trend view by defect type and source so the recurring offenders surface on their own.
What's inside the Implementation Plan
The plan opens by interviewing you about your business - your current NCR process, the systems and spreadsheets you use, your real defect codes and SKU/lot naming, your typical and peak volumes, your exact disposition and approval rules, and the messy edge cases (split lots, partial dispositions, supplier returns). It reflects a short tailored spec back to you and waits for your thumbs-up before building anything. The result is an NCR tracker shaped to how you actually work, not a generic template.
From there it walks you, copy-paste prompt by copy-paste prompt, through building the login, the database with row-level security, the NCR intake form with photo upload, auto-numbering, the MRB approval gate, the action/cost recording, closure with verification, the CSV export, and the trend view. Every step ends with a ready-to-paste prompt.
The governance it includes (this is the point)
- Login so only your team can use the tool.
- Row-level security so each organization only ever sees its own NCRs.
- A complete audit trail - who submitted, who dispositioned, who closed, and exactly when.
- A hard human-in-the-loop approval gate - the tool drafts and routes, but material status only changes after a named MRB member approves the disposition.
- Duplicate guards - the NCR number is the dedupe key, so the same nonconformance can't be entered or processed twice.
Who it's for
Quality engineers, MRB members, and production supervisors who are tired of paper tags and stale spreadsheets and want a controlled, trendable NCR process they can build themselves - no developer required.
You've got this - paste the first prompt and let the interview tailor the rest.