Advanced database and reporting usage

Configuration
1

I’d like to be able to start running DB queries, generating reports, charts/graphs, and creating and using my own tables for custom logging purposes.

  • What kind of tools are available that you use with HA?
  • Do you change the native (SQLite?) database that HA uses? Why or why not?

If you’re like me and using docker, can you tell me which images you are using?

2

A while ago, I wrote a blog post about that.

We also have Jupyter notebooks.

The future will be https://data.home-assistant.io/