This integration allows you to export data from Home Assistant to a Supabase database.
This integration is available in the Home Assistant Community Store.
- Create a Supabase project and database.
- Run the following SQL query to create the required tables:
create table homeassistant_entities (
id bigint not null primary key,
created_at timestamp default now(),
entity_id text not null,
state text,
attributes json,
last_changed timestamp default now()
);
create table homeassistant_metadata (
id bigint not null primary key,
created_at timestamp default now(),
provisioned boolean,
data json
);
You can configure the integration via the Home Assistant UI.
Once the integration is configured, you should then configure the options for the integration. This can be done via the Home Assistant UI.
From here, you can configure the following options:
- Update interval: The interval at which the integration will update the data in the database. This is in seconds.
- Entities: The entities that you want to export to the database.
