Exporting MQTT historical values to HA


I switched over from Domotics to HA. I have a lot of BT temp/hum sensors values - from many years ago. Is it possible to export all the history to HA?

It is likely to be technically possible, but unless someone has already written a Python / SQL script for exactly this combination, you need DBA skills.
The basics are here, then install the database Add-On to get a web interface to look into the tables.

Once you trace the IDs for your existing sensor entity values, it’s pretty much one table of values.

I went the other way - format sensor values from HASS, publish to MQTT, then log with historic values in a script on an external Linux box (which originally logged the sensors directly).

Thank you very much for these suggestions. It seems to me that I’m leaning towards the first one.