Assembly Explorer
Designers had no way to answer “which assemblies use this part?” without opening files one at a time. I indexed the entire SolidWorks assembly tree into SQL Server and put a search layer on top of it — where-used lookups, specification search and tree browsing. It ships as a Windows Service with a browser front end, so the whole department reaches it from a LAN URL with nothing to install, and the web tier connects through its own read-only database login.
Screenshots
Key Highlights
- Indexes full assembly trees into SQL Server for instant search
- Where-used and specification lookup across the whole component library
- Deployed as a Windows Service — colleagues use a LAN URL, nothing to install
- Separate read-only database login for the web tier
- WPF client and React web front end over the same index
Tech Stack
Tags
Related Projects
BOM Director
Built in-house at a regional HVAC manufacturer
Turns SolidWorks BOMs into production documentation and writes material rows straight into the ERP — no re-keying between engineering and production.
CNC G-Code Generator
Built in-house at a regional HVAC manufacturer
Excel tube specifications in; optimised bar-nesting layouts and machine-ready Syntec G-code out.
Structure Maker
Built in-house at a regional HVAC manufacturer
Draw the structure in 2D, get the SolidWorks 3D assembly — tubes, panels, doors and components generated and packed.