Recover data from corrupted sqlite3 db? sqlite3: command not found

Configuration
1

OS Version: Home Assistant OS 16.2
Home Assistant Core: 2025.10.1

A few days ago my sqlite3 db became corrupted for an unknown reason. The system created a new db and saved the old one:

home-assistant_v2.db.corrupt.2025-10-04T23:25:10.837309+00:00

I have lost many months of solar system data which I’d really like to recover. I found some instructions on using the sqlite3 “recover” command:

sqlite3 home-assistant_v2.db ".recover" | sqlite3 home-assistant_v2.db.fixed

but when i ssh into my server the sqlite3 executable is not found, and I can’t find a way to install it.

[core-ssh config]$ sqlite3
-bash: sqlite3: command not found

I must be missing something obvious, any help/pointers would be appreciated.

2

Each addon runs in its own Docker container that sees a limited list of folders / apps etc. This is why the “core-ssh” addon cannot see it. You could install sqlite (or a different UI for SQL) on another machine and access it remotely.