Machinery Hub API
Sparepart interchange lookup engine with compatibility matrix mapping
Overview
A specialized lookup API that maps compatibility matrices and part cross-references across multiple machine categories, enabling fast sparepart interchange search across a 500,000+ part database.
The client's procurement team was manually cross-referencing parts across thick manufacturer catalogs. Finding a compatible alternative part for a machine took hours and was prone to errors, causing costly downtime.
Designed a graph-based compatibility model in PostgreSQL with full-text search powered by pg_trgm. Built a REST API with sub-50ms p99 query times even on complex multi-level interchange lookups. Includes OEM/aftermarket part confidence scoring.
Part lookup time reduced from hours to seconds. Procurement team processes 3x more requests per day. Alternative part identification improved machinery uptime by reducing procurement lead time.
