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

Question

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.

3. 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

4. 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.

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

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

7. Enjoy!

UPDATE 2020

Database Inspector (for Android Studio version 4.1). Read the Medium article

For older versions of Android Studio I recommend these 3 options:

1. Facebook's open source [Stetho library] (http://facebook.github.io/stetho/). Taken from here

In build.gradle:

dependencies {
  // Stetho core
  compile 'com.facebook.stetho:stetho:1.5.1'        
  //If you want to add a network helper
  compile 'com.facebook.stetho:stetho-okhttp:1.5.1'
}

Initialize the library in the application object:

Stetho.initializeWithDefaults(this);

And you can view you database in Chrome from chrome://inspect

2. Another option is this plugin (not free)
3. And the last one is this free/open source library to see db contents in the browser https://github.com/amitshekhariitbhu/Android-Debug-Database

The best way I found so far is using the Android-Debug-Database tool.

Its incredibly simple to use and setup, just add the dependence and connect to the device database's interface via web. No need to root the phone or adding activities or whatsoever. Here are the steps:

STEP 1

Add the following dependency to your app's Gradle file and run the application.

debugCompile 'com.amitshekhar.android:debug-db:1.0.0'

STEP 2

Open your browser and visit your phone's IP address on port 8080. The URL should be like: http://YOUR_PHONE_IP_ADDRESS:8080. You will be presented with the following:

NOTE: You can also always get the debug address URL from your code by calling the method DebugDB.getAddressLog();

To get my phone's IP I currently use Ping Tools, but there are a lot of alternatives.

STEP 3

That's it!

---

More details in the official documentation: https://github.com/amitshekhariitbhu/Android-Debug-Database

The best way to view and manage your Android app database is to use the library DatabaseManager_For_Android.

It's a single Java activity file; just add it to your source folder. You can view the tables in your app database, update, delete, insert rows to you table. Everything from inside your app.

When the development is done remove the Java file from your src folder. That's it.

You can view the 5 minute demo, Database Manager for Android SQLite Database .

You can do this:

1. adb shell
2. cd /go/to/databases
3. sqlite3 database.db
4. In the sqlite> prompt, type .tables. This will give you all the tables in the database.db file.
5. select * from table1;