Debugging sqlite database on the device

by

I’ll repeat myself from another answer:

Starting from API level 8 (Android 2.2), if you build the application as debuggable, you can use the shell run-as command to run a command or executable as a specific user/application or just switch to the UID of your application so you can access its data directory.

So if you wish to pull your application database from the device you should run the debug build of the application, connect with adb shell and run the following command:

run-as com.yourpackage sh -c "cat ~/databases/db-file" > /sdcard/db-file.sqlite

This will copy your db-file to the root of your SD card / external storage. Now you can easily get it from there by using file manager, adb pull or whatever else you like. Note that with this approach, there is NO need for your app to have WRITE_EXTERNAL_STORAGE permission, as the copying is done by the shell user who can always write to the external storage.

On Linux/Mac systems there is a possibility to copy a database directly to your computer with the following command one can use without entering the adb shell:

adb shell 'run-as com.yourpackage sh -c "cat ~/databases/db-file"' > db-file.sqlite

This however will not work correctly on Windows because of CR/LF symbols conversion. Use the former method there.

More Related Contents:

  1. How do I view the SQLite database on an Android device? [duplicate]
  2. Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?
  3. How to check database on not rooted android device
  4. sqlite3: not found
  5. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  6. Run/install/debug Android applications over Wi-Fi?
  7. Android Studio doesn’t see device [closed]
  8. Where does Android emulator store SQLite database?
  9. Android SQLite Example [closed]
  10. Is there a way to get current activity’s layout and views via adb?
  11. Google Android USB Driver and ADB
  12. Android SQLite issue – table … has no column named
  13. Android ADB devices unauthorized
  14. android studio adb Syntax error: “)” unexpected
  15. How to add new Column to Android SQLite Database?
  16. Exporting SQLite Database to csv file in android
  17. How to turn off Wifi via ADB?
  18. send touch events to a device via adb [duplicate]
  19. Find out the running process ID by package name
  20. Android Device Chooser — device not showing up
  21. How to get Last record from Sqlite?
  22. select distinct value in android sqlite
  23. A pre-populated database does not work at API 28 throws “no such table” exception
  24. Get last inserted value from sqlite database Android
  25. Could not allocate CursorWindow
  26. When should I do certain SQLite operations on another thread(not the main thread)?
  27. Changing values from Cursor using SimpleCursorAdapter
  28. How can I reset a autoincrement sequence number in sqlite
  29. Same serial number on several android devices. Adb is useless. How can I change the serial number?
  30. adb shell su works but adb root does not

Leave a Comment