If you ever need to edit a SQLite database on Android then use the app I built: SqlitePrime. You can use the built-in SQL Editor, view and edit fields, create Tables, view DDL for Tables, Views, Indices, Triggers. It also has support for editing the Blob data type. You can also edit app's databases (Root needed)

https://forum.xda-developers.com/android/apps-games/app-sqliteprime-database-manager-root-t3684598

Apparently it was removed from Google Play Store because it uses the Play services and requires a Privacy policy. The app can be downloaded from here https://sqlite-prime.en.aptoide.com/ until I find time to make it GDPR compliant.

TODO: Migrate Sqlite Prime app entirely to Kotlin with MVVM and Open source it (I'm planning to do this when I find a bit more free time).