Aerospace Production Assistant

Problem

Technicians on the composite shop floor needed one reliable place for materials, mix ratios, tools, schedules, safety docs and work instructions. The original demo for this project was a single 9.6 MB HTML file with everything hardcoded — nothing could be edited without touching code, and any change was lost on refresh.

What I built

I turned a frozen, un-editable demo page into a living internal tool. All the content now lives in a real database, so the team can add, edit and delete materials, tools, schedules and instructions straight from the page — and it sticks. A simple login gives regular staff a clean read-only view and admins full edit controls. It includes a materials catalogue with safety gear and spec sheets, a mixing calculator, a live staff schedule that totals worked hours on its own, KPI charts, and a polished dark mode. It feels like a product, not a spreadsheet.

Tech used

• Supabase (Postgres)
• vanilla JavaScript
• supabase-js
• HTML/CSS
• SQL

Result

From a frozen 9.6 MB file to a tool the team maintains themselves — no code edits needed. ~12 database tables, role-based login, and admin editing across materials, tools, scheduling (with auto-calculated hours), instructions and KPIs. Refresh-proof, dark-mode ready, and structured to grow into full authentication later.