There’s some life information that I’d like to display in Lovelace, but I’m not sure how to do it.
My HA instance records everything to MySQL, but there’s often very little utility to displaying some of the data the HA records.
Then, there’s some data that I’d really LIKE to have displayed for which there are no integrations in HA. One of those is banking information. Account charges, balances, etc., would be nice to have as a tab in HA.
I use GNUCash to manage finances, which is NOT an automated program, but, nonetheless, it is accurate, and it is stored in MySQL.
Is it possible to Query MySQL and create sensors with values based upon those queries through HA, or would it just make sense to use some other sort of dashboard system to display this information? It doesn’t necessarily need to be in Lovelace. I could run a separate Pi4 with a display to show the information if I knew the application or dashboard system to use.