configuration.yaml

# ...

shell_command:
  clean_db: python3 /path/to/purge_sensor.py

automation:
  - trigger:
      platform: time
      after: '03:00:00'
    action:
      service: shell_command.clean_db

purge_sensor.py

import sqlite3

DB_PATH = '/path/to/home-assistant_v2.db'
ENTITY_IDS = ['sensor.my_sensor1', 'sensor.my_sensor2']

conn = sqlite3.connect(DB_PATH)
c = conn.cursor()
for eid in ENTITY_IDS:
    c.execute("DELETE FROM events WHERE event_data LIKE ?", ('%\"entity_id\": \"' + eid + '\"%',))
    c.execute("DELETE FROM states WHERE entity_id = ?", (eid, ))

conn.commit()
conn.execute("VACUUM")
conn.close()

Home Assistant has the option to run scripts. Perhaps it worth to think about an integration of this. That way one could run it like hass --script purge-db sensor.my_sensor1.

By running "shell_command.clean_db" where specific the name of the sensor ?? Thank

Hi,
with this script is it possible to delete the data of a sensor in a MariaDB database?