The problem
Equipment generated roughly ten thousand records a day, and getting an answer out of that data meant writing queries, which put analytics out of reach of the people who understood the equipment.
What we built
End-to-end ETL pipelines on Kafka for collection, validation and enrichment of IoT payloads. Time-series modelled in TimescaleDB with indexing and retention policies, and Druid datasources with rollups for fast exploratory analytics. FastAPI services expose the cleaned datasets and natural-language query endpoints; a language model translates plain-English questions into executable queries and summarises the results. The full interface was built in React and Vite.
The result
Operators query telemetry conversationally, with history and export flows. Services are containerised and orchestrated with Kubernetes, deliberately environment-agnostic rather than tied to one cloud.