How do I view the SQLite database on an Android device? [duplicate]

by

Here are step-by-step instructions (mostly taken from a combination of the other answers). This works even on devices that are not rooted.

  1. Connect your device and launch the application in debug mode.

  2. You may want to use adb -d shell "run-as com.yourpackge.name ls /data/data/com.yourpackge.name/databases/" to see what the database filename is.

Notice: com.yourpackge.name is your application package name. You can get it from the manifest file.

  1. Copy the database file from your application folder to your SD card.

    adb -d shell "run-as com.yourpackge.name cat /data/data/com.yourpackge.name/databases/filename.sqlite > /sdcard/filename.sqlite"

Notice: filename.sqlite is your database name you used when you created the database

  1. Pull the database files to your machine:

    adb pull /sdcard/filename.sqlite

This will copy the database from the SD card to the place where your ADB exist.

  1. Install Firefox SQLite Manager: https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

  2. Open Firefox SQLite Manager (Tools->SQLite Manager) and open your database file from step 3 above.

  3. Enjoy!

More Related Contents:

  1. Android SQLite data display to ListView
  2. Android SQLite database: slow insertion
  3. Retrieve database or any other file from the Internal Storage using run-as
  4. Pros and Cons of SQLite and Shared Preferences [closed]
  5. Share SQLite database between 2 android apps?
  6. Android: upgrading DB version and adding new table
  7. Best way to work with dates in Android SQLite [closed]
  8. Best place to close database connection
  9. 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?
  10. Import .csv file to Sqlite in Android
  11. Debugging sqlite database on the device
  12. Cursor adapter and sqlite example [closed]
  13. How to add new Column to Android SQLite Database?
  14. How to retrieve data from sqlite database in android and display it in TextView
  15. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  16. Android SQLite Database, WHY drop table and recreate on upgrade
  17. SQLite simultaneous reading and writing
  18. update sql database with ContentValues and the update-method
  19. Create SQLite database in android
  20. Could not allocate CursorWindow
  21. Saving ArrayLists in SQLite databases
  22. How to check database on not rooted android device
  23. android, how to exec a sql file in sqlitedatabase
  24. SQLiteOpenHelper – creating database on SD card
  25. SQLite android column not found
  26. How to store JSON object in SQLite database
  27. sqlite3: not found
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment