Is it possible in IntelliJ IDEA or something else to see what is stored in SQLite without downloading it from the device / emulator?

Question

Android

Good!
I can't seem to find a clear answer on the net. I would like to see what is stored in the database in the Android application I launched from IntelliJ IDEA and see what and how is added and removed from the database when the application is running. Everything is simple with MySQL via jdbc, but I don’t understand with android
That’s what I see, well, I don’t know what to do next

Answer 1

SQLite doesn't have a server like MySQL, so you can't connect to it remotely. You can connect to the device, and from it already to the database:

> adb devices
List of devices attached
emulator-xxxx   device

> adb -s emulator-xxxx shell

> cd data/data/<your-package-name>/databases/

> sqlite3 <your-db-name>.db