SQL queries of my HA database with datasette

The SQL sensor component has just been launched, and perhaps you want a nice browser interface to practice creating SQL queries? You could install the excellent SQLite browser but alternatively the datasette python package allows you to create a simple and read-only browser interface (and rest API) to your SQLite database (all localhost). The interface provides a form for running SQL queries, shown below. Once you’ve installed datasette start the interface with datasette serve home-assistant_v2.db, navigate to in Chrome (I haven’t tried other browsers), then get practicing your SQL queries.
Enjoy :slight_smile:

1 Like