I am using Home Assistant as my hub and have installed a few dimmer switch. I can see HA reports energy consumption from the switches. Is there a way for me to extract those data and store in a databbase (e.g. Postgresql)?
Have you looked at InfluxDB?
Thank you for the suggestion. I am not aware of InfluxDB. I will give it a try.