Chemical Inventory & SDS Register
Build your own searchable register of every hazardous chemical on site - quantity, location, hazard class - with the current Safety Data Sheet attached, an EHS approval gate, and automatic flags for missing or outdated SDS.
A team-only web app where you import or enter chemicals, attach SDS files, have the EHS manager approve them onto the official on-site register, search by name/location/hazard, and get flagged when an SDS is missing or stale - plus one-click inventory and SDS-status exports.
Before you start
- A free Supabase account
- A free Vercel account
- A free Resend account
- A list of your on-site chemicals (a spreadsheet is fine) and your SDS files
The problem this kills
When an inspector, a firefighter, or your own EHS manager asks "what chemicals are in Bay 3, how much, and where's the current Safety Data Sheet?" - the honest answer is too often a binder nobody trusts, a shared drive of PDFs nobody dated, and a spreadsheet that hasn't matched reality since the last reorg.
Meanwhile chemicals show up on the floor that were never approved. SDS files quietly go out of date. And nobody can prove, in the moment that matters, that the sheet they're holding is the current one.
This plan kills that. You get a single, searchable, team-only register where every chemical has a location, a quantity, a hazard class, and the current SDS attached - and nothing lands on the official list until the EHS manager has signed off on it.
What you'll build
A small internal web app that lets you:
- Import or enter chemicals - product name, manufacturer, location, quantity, hazard class - from a spreadsheet or one at a time.
- Attach the Safety Data Sheet to each chemical and record its revision date.
- Route every new chemical through an EHS approval gate - nothing reaches the official on-site register until the EHS manager reviews it and the attached SDS and approves.
- Search instantly by product name, location, or hazard class - the answer a first responder needs in seconds.
- Get flagged when an SDS is missing entirely or older than your review window.
- Export a clean chemical-inventory CSV and an SDS-status report whenever you need one.
What's inside the Implementation Plan
A single markdown file you paste into an AI coding agent (Claude Code). It builds the whole tool with you, step by step, in plain language.
Crucially, the plan opens by interviewing you about your site - your locations and naming, your hazard-class scheme, how you store SDS today, your SDS review window, your approval rules, and your messy edge cases. It reads a short tailored spec back to you, gets your thumbs-up, and only then builds. You get a register shaped to your plant, not a generic template you have to fight.
Inside you'll find: the discovery interview, the exact data model, the import path, the SDS upload + revision-date tracking, the EHS approval workflow, search, the stale-SDS flagging logic, the email alerts, and both exports - each step ending in a ready-to-paste prompt.
The governance it includes (this is the point)
- Login so only your team can open the register.
- Row-level security so each organization only ever sees its own chemicals and SDS files.
- A human-in-the-loop approval gate - the EHS manager reviews and approves every new chemical (and its SDS) before it joins the official on-site register. No silent additions.
- A complete audit trail - who imported, who approved, who edited, and when.
- Duplicate guards - the same product + manufacturer + location can't be entered twice.
Who it's for
EHS managers who own the chemical register and the inspection that tests it. Lab and production staff who need to find an SDS in seconds. Stores and receiving who need to know what's allowed on site before it comes through the door.
You don't need to be a developer. If you can describe how your plant handles chemicals, the agent can build the tool around your answers.
You've got this - paste the first prompt and let the interview start.