Home Assistant Database Management Project Plan#

First establish safe Recorder purge and repack settings. Then create and validate an export target for historical Home Assistant data.

Keep approximately 30 days of detailed history locally. Complete and verify the Recorder maintenance setup before starting the export work.

1. Configure Recorder Purge and Repack#

• 1.1 Set purge_keep_days to 30.
• 1.2 Enable auto_purge.
• 1.3 Enable auto_repack.
• 1.4 Validate the configuration and restart Home Assistant if required.
• 1.5 Confirm that automatic purge and repack are active.
• 1.6 Confirm that the database remains within the 30-day retention period.
• 1.7 Confirm that sufficient free space remains for maintenance operations.

Do not begin the export-target work until the Recorder purge and repack settings have been configured and verified.