Turn my smart home's 868 sensors into a data platform I can query for years
A homeowner had the AI SSH into his servers and build the long-term data platform his Home Assistant setup lacked: VictoriaMetrics storage with a decade of retention and two Grafana dashboards covering every room's temperature, humidity and computed mould risk plus whole-home solar, battery and per-appliance energy. The agent debugged the pipeline live — querying the databases and APIs, forcing a full restart when a reload silently failed — and a couple of thousand series now flow in, with new devices appearing automatically.
How it works
- SSH into the server and stand up VictoriaMetrics plus Grafana in Docker on a separate always-on box
- Point Home Assistant's influxdb integration at it with filters for the sensor domains
- Verify against the live system at each step: query loaded components, force a full restart when the integration silently didn't load
- Fix sparse-sensor queries with last_over_time
- Compute dew point and mould risk from paired temperature and humidity series
- Connect the home battery through a read-only cloud integration
- Keep the dashboards LAN-only after the agent's safety layer blocked a public route
Why it’s worth knowing
The agent didn't advise — it SSH'd in, built the platform, and interrogated the live databases until a years-old someday project worked in an afternoon.
Where it’s from
Summarized from a public post on dev.to. See the original ↗