How can I edit old values in the database? I tried doing it with “DB Browser for SQLite” but I can’t even find the helper I want to modify.
help me
Are you trying to modify a helper, or the data stored by it?
If the former, they’re either stored in the YAML where you created them, or in JSON files in the .storage directory if you created them through the UI. It’s not recommended to modify JSON files.
If you just want to delete old data from the Recorder database, you can use the purge action in Developer Tools / Actions. Directly editing values would require a very good understanding of the database design. A good starting point would be here: https://data.home-assistant.io/