homeassistant.md

title	description	published	date	tags	editor	dateCreated
HomeAssistant		true	2025-02-08 16:35:16 UTC		markdown	2025-02-08 16:35:16 UTC

Using SQL

https://github.com/expaso/hassos-addon-timescaledb

Queries

Deleting states by entity id

DELETE FROM states
WHERE metadata_id IN
	(SELECT metadata_id FROM states_meta WHERE entity_id = 'sensor.my_unnecessary_sensor');