Browse SQLite database from Android Studio [closed]

by

UPDATE July 2020

With Android Studio 4.1 (Canary 6 and higher), you can inspect, query, and modify your app’s databases using the new Database Inspector.

You can find the official doc here.

Currently there isn’t an official plugin for DB Inspection in your apps.

  • You can use the DDMS : Tools > Android > Android Device Monitor as described in @Subhalaxmi’s answer

  • There is a beta plugin provided by idescout that you can try here.

  • There is the Stetho tool (open source and free) provided by Facebook

I suggest you using the Stetho open-sourced tool provided by Facebook. It is simple to implement and very powerful.

Just add the dependencies in your build.gradle

dependencies {
    // Stetho core
    compile 'com.facebook.stetho:stetho:1.3.1'       

    //Optional network helper
    compile 'com.facebook.stetho:stetho-okhttp:1.3.1'       
}

Then just initialize the tool in your Application class:

Stetho.initialize(Stetho.newInitializerBuilder(this)
        .enableDumpapp(Stetho.defaultDumperPluginsProvider(this))
        .enableWebKitInspector(Stetho.defaultInspectorModulesProvider(this))
        .build());

Finally just open Chrome on your pc and navigare in chrome://inspect.

Here you can display the database in the app (with read/write capabilities), and you can run queries.

enter image description here

You can find more info about Stetho here:

More Related Contents:

  1. View contents of database file in Android Studio
  2. Include Stetho only in the debug build variant
  3. Android Device Monitor “data” folder is empty
  4. Error retrieving parent for item: No resource found that matches the given name after upgrading to AppCompat v23
  5. Android: upgrading DB version and adding new table
  6. How to convert image file data in a byte array to a Bitmap?
  7. Exclude a class from the build in Android Studio
  8. Android studio isn’t opening on Windows
  9. Does Android Support JDBC
  10. Android Studio build.gradle warning message [duplicate]
  11. How do I order my SQLITE database in descending order, for an android app?
  12. Render error in Android Studio 3.0 Layout Editor
  13. Android SDK is missing, out of date, or is missing templates. Please ensure you are using SDK version 22 or later
  14. Error: Execution failed for task ‘:app:clean’. Unable to delete file
  15. Android ExpandableListView and SQLite Database
  16. Multiple Table SQLite DB Adapter(s) in Android?
  17. Change fill color on vector asset in Android Studio
  18. Android Studio: Exclude resource file under resources sourceSets
  19. Android Studio not deploying changes to app
  20. Closing the database in a ContentProvider
  21. How to restart ADB manually from Android Studio
  22. Error:Execution failed for task ‘:ProjectName:mergeDebugResources’. > Crunching Cruncher *some file* failed, see logs
  23. Run Button is Disabled in Android Studio
  24. How to set the app icon as the notification icon in the notification drawer
  25. Error while Launching activity
  26. android, how to exec a sql file in sqlitedatabase
  27. SQLiteOpenHelper – creating database on SD card
  28. Difference between clean project and rebuild project in android studio
  29. Android Studio Warning: Using incompatible plugins for the annotation processing
  30. INSTALL_FAILED_CPU_ABI_INCOMPATIBLE on device using intellij

Leave a Comment