Driver Qualification File Tracker
Track every driver's DQ file — CDL, medical card, MVR review, drug test — with 60/30/0-day expiration alerts and a safety-manager approval gate, so a lapsed driver never operates.
A private web tool that holds each driver's qualification file, alerts you at 60/30/0 days before any credential expires, captures renewal uploads, and restores "qualified" status only after the safety manager approves — with a full audit trail.
Before you start
- A free Supabase account
- A free Vercel account
- A free Resend account
- A list of your drivers and their current credential dates (a spreadsheet is fine)
The problem this kills
Every driver you dispatch carries a stack of credentials that quietly expire: the CDL, the DOT medical examiner's certificate (the "med card"), the annual MVR (motor vehicle record) review, and drug-and-alcohol testing. Miss one renewal and you've put an unqualified driver on the road — a violation that turns up in a DOT audit, raises your CSA score, and can void coverage on a claim.
Most safety and HR teams track all of this in one fragile spreadsheet, plus a folder of scanned PDFs, plus a calendar reminder someone set up two managers ago. Nobody sees the full picture, the alerts get missed, and "qualified" is whatever the spreadsheet last said. When a med card downgrades a driver to a restricted status, that change rarely flows anywhere fast enough.
What you'll build
A small private web app — just for your team — that holds a real Driver Qualification File for each driver, shows you a single expiration timeline across all credentials, and emails you automatically at 60, 30, and 0 days before anything lapses. A driver or an admin uploads the renewed document, the safety manager reviews it, and only after that human approval does the driver's status flip back to Qualified. Every action is logged.
What's inside the Implementation Plan
The plan opens by interviewing you about your operation — your fleet size, which credentials you track, how you name drivers and number files, your renewal cadence, who approves, and your messy edge cases (med-card downgrades, intrastate vs. interstate rules, leased owner-operators). It reflects a short tailored spec back to you for a thumbs-up, then builds the data model and every alert around your answers instead of a generic template.
From there it walks you, prompt by prompt, through standing up the database, the login, the upload flow, the 60/30/0-day alert engine, and the approval gate. Each step ends with a ready-to-paste prompt — you never have to write code.
The governance it includes (this is the point)
- Login so only your safety and HR team can open it.
- Row-level security so each carrier/organization only ever sees its own drivers.
- A complete audit trail — who changed what credential, who approved a renewal, and exactly when.
- A hard human-in-the-loop approval gate: the tool drafts the status change, the safety manager reviews the uploaded document, and only an approval restores "Qualified."
- Duplicate guards keyed on driver + credential type, so the same renewal can't be processed twice.
Who it's for
Safety and compliance managers, DOT compliance staff, and HR teams at trucking and fleet operations who are responsible for keeping every driver's qualification file current and audit-ready — and who are tired of trusting a spreadsheet to do it.
You've got this — paste the first prompt and let the agent interview you.