BoM & Engineering Manager

A local-first engineering data management tool built with Streamlit and DuckDB — no cloud backend required.

BoM & Engineering Manager

Technical Overview

Managing Bills of Materials in engineering environments often means juggling spreadsheets or navigating bloated ERP interfaces. This tool was built as a lightweight, local-first alternative that runs entirely on the user's machine.

DuckDB handles SQL-speed querying directly on local files, while Streamlit provides a reactive interface for exploring, filtering, and editing engineering datasets. Originally developed during work in oil & gas, later refined as a standalone tool.

Project Outcomes

  • Local-first architecture: zero network dependency, full data privacy.
  • DuckDB enables complex SQL queries directly on flat files without a server.
  • Reactive dashboard for real-time BoM visualisation and hierarchical data exploration.