When you are working on an Android application that stores data in a SQLite database.There arise many questions like

  • where does this database file get stored on the filesystem ?
  • How can we access the database?

I will give solution to all these problems. I created the SQLite database from my previous post
about Using SQLite in ANDROID

You can see the sqlite database in eclipse by opening File Explorer .
Then navigate to “/data/data/package_name/databases

But here we cannot see the tables and table data.
For viewing the table details Eclipse has a plugin. You can download the jar from below.

Make easy money with infolinks

Download the jar from the sqlite manager from here.

Now put the jar in the folder


and restart the eclipse and now you can see the sqlitemanager plugin on the top right of the File Explorer window.

It will be enabled when you click on the DB file in the File Explorer Window.


Make easy money with infolinks

By clicking the icon [after selecting the db file], sqliteManager Window comes and here we can see the table structure.


and then the Browse Data tab shows the whole data


Hopefully i think you cleared all doubts about SqliteManager Plugin

Note : If you’re using a plug-in for which no Update Site is available, you can use the “dropins” folder in your Eclipse installation directory.

Plug-ins are typically distributed as .jar files. To add a plug-in to your Eclipse installation, put the plug-in .jar file into the Eclipse “dropins” folder and restart Eclipse. Eclipse should detect the new plug-in and install it for you.

Note : if your SQLiteManager Plugin is not enabled, then check your sqlite db file extension. It should be a “.db” extension.


Check out more similar posts on SQLite in Android below.



  1. Pingback: Using SQLite in ANDROID, A really simple example. | Coderz Heaven

  2. teja July 12, 2011 at 11:20 pm

    i couldn’t find my package under /data/data/… how can i push my database into eclipse?

  3. jettimadhu Chowdary July 15, 2011 at 3:55 pm

    Hi, Thanks for Posting.
    Here I am unable to download the Sqlitemanger_1 jar.Can you have any alternate posts to download this file..

    • Soorya July 15, 2011 at 10:28 pm

      frnd…..now the link is enabled…you can download…thans

  4. Halvorsen August 27, 2011 at 3:29 pm

    the plugin is outdated, download the updated one at http://www.cellobject.net

    • Rajat June 9, 2012 at 6:34 am

      Yes.. this works… Thanks

      Users: you need to go to download section to download

      • James June 10, 2012 at 7:20 am

        Users can just download the plugin from here and just update the eclipse you have, The SQLIte manager will also be updated along with other update.

  5. Pingback: Working with SQLite databases through command Line in android. | Coderz Heaven

  6. Pingback: Working with SQLite databases through command Line in android … | Programmer Solution

  7. sureshkumar February 8, 2012 at 3:47 pm

    Hi, I got my database in file manager tab…
    But the opensqlite manager icon at top right corner is not enable

    • James February 8, 2012 at 10:16 pm

      Reinstall it or update the eclipse.

  8. Lars Vogel March 6, 2012 at 2:40 pm

    Great plug-in thanks. Please update the install description, as of Eclipse 3.5 plug-ins should be placed in the dropin folder. Please see here: http://www.vogella.de/articles/Eclipse/article.html#dropins

    • James March 6, 2012 at 7:34 pm

      @Lars Vogel :- Thanks for the information.

  9. James March 8, 2012 at 8:57 pm

    Thanks for the advice. Vogel

  10. Santhosh Kumar March 27, 2012 at 4:20 pm

    In my Eclipse Sqlitemanager plugin its looks very dull on the top right of the File Explorer window i could not click it (Sqlitemanager is looking like a showdow)what should i do now? Help me!!!

    • James March 27, 2012 at 10:13 pm

      First select the db file then only it will highlight.

  11. sylwester June 10, 2012 at 7:07 am


    Sorry of my English – don’t use this language.

    1. download plugin in this site:

    2. place this file ( com.questoid.sqlitemanager_1.0.0.jar ) in dropins folder or my eclipse ( e:programs/eclipse/dropins ).

    3. this file don’t work, why?

    4. search this bug in google, find, but my English very low and don’t understand.

    pleas help me, thank You.

    • James June 10, 2012 at 7:12 am

      Hello sylwester :- Did you restart the eclipse?

      • sylwester June 10, 2012 at 9:24 am

        Yes, restart Eclipse, and restart OS ( WindowsXP sp3, 32bit ) and don’t work 🙁

        Eclipse Galileo ( 3.5.1 )

  12. sylwester June 10, 2012 at 9:26 am
  13. khushbu joshi June 25, 2012 at 4:58 pm

    Sylwester -> when you create database name it as “dbname.db” i.e give.db as extension this will i hope best luck

    • khushi June 25, 2012 at 5:05 pm

      when you create database name it as “dbname.db” i.e give.db as extension this will i hope best luck

  14. Pingback: Cara Melihat Database Yang Tersimpan Di Android (Emulator) – Eclipse | ayo belajar sama – sama …

  15. Pingback: Ferramentas interessantes para desenvolvimento em Android « Portal BLL

  16. Valentin Despa November 18, 2012 at 5:50 pm

    Hi James,

    I just wanted to drop an thanks for sharing this. Worked like a charm in Eclipse Juno.

  17. Pingback: How can I see my created tables structure in Sqlite with out using any commands : Android Community - For Application Development

  18. Pingback: error copying my database file from assets folder into my application : Android Community - For Application Development

  19. Pingback: FrAndroid DevTips #37 - FrAndroid

  20. Rene February 19, 2013 at 1:10 am

    Thanks for dveloping this plugin!!!
    Works like a charm (Eclipse 3.7 Indigo), checked on 7″ tablet (4.03) and SGS3 (4.12)

    Cheers, Rene

  21. Mitch February 21, 2013 at 1:18 am

    Thank you, awesome plugin!!!!!

  22. prostynick March 15, 2013 at 7:57 am

    I can’t browse my phone (real device) in Eclipse using File Explorer 🙁 Phone is rooted and I can browse its files using ls and cd with adb shell.

    I also asked it here with no help 🙁


  23. Pingback: Stop a 2nd Android Emulator opening up : Android Community - For Application Development

  24. Behnam April 14, 2013 at 1:25 pm

    Thx,great. Helped me alot

  25. KIRU April 15, 2013 at 2:11 am

    Nice one very useful and user friendly.

  26. darwing July 25, 2013 at 4:54 am

    asi se ve como esta en la imagen
    no se selecciona el icono ayudenme por favor

    • James July 27, 2013 at 5:23 pm

      Reset the adb from command prompt or using Devices view.

  27. Edgar August 17, 2013 at 5:18 pm

    Thankyou very much, I can perfectly see my database!

  28. Pingback: Android Development Tools | androidmyway

  29. Dan January 5, 2014 at 9:29 pm

    I’ve reset and updated my eclipse and it still won’t show up. What gives?

    • James January 31, 2014 at 6:22 pm

      Sometimes this happens try with a new eclipse.

  30. Bemytthm August 7, 2014 at 1:55 am

    Im using Android Developer Tools, v22.6.2-1085508 which includes Eclipse 4.3.1 inside. I try to use your instructions by adding the plugin but the symbol looks disable.
    There is no newer update for Android Developer Tools.

  31. vijayprakash August 9, 2014 at 5:57 am

    Thank you …this is useful to me

  32. !tihS August 10, 2014 at 12:31 pm

    That method didnt help me. I put the jar file on the dropins folder on eclipse and restart eclipse and my Eclipse is crash with a statement “An error has occurred. See log file”

    Thanks for destroying my eclipse and i cannot make my project because of that stupid jar file.

    • James September 2, 2014 at 10:01 am

      This will not happen, many users are already using it.

  33. Pavan Atri October 26, 2014 at 12:06 am

    Great plugin! Thank you!!

  34. sai November 15, 2014 at 6:01 am

    there is no database folder in my ddms how can i open it
    the ddms contains
    data>data>my app>cache>lib
    there is no database folder

    • James November 15, 2014 at 6:21 am

      Try to create a db in data/data/yourapp directory and see.

      • sai November 15, 2014 at 8:35 am

        i have already an app with sq lite database there is no database folder and
        my emulator also not working it shows unfortunately your app is stopped
        plz solve my problem

        • sai November 16, 2014 at 4:37 pm

          i can’t open my database in ddms
          because there is no database folder in ddms
          how can i open my db

  35. kumar November 17, 2014 at 3:53 am

    i have already an app with sq lite database there is no database folder and
    my emulator also not working it shows unfortunately your app is stopped
    plz solve my problem

    • James November 17, 2014 at 1:36 pm

      Hi Kumar,

      Please check the Logcat and see the reason for the crash. It has nothing to do with the SQLite Manager Plugin.


  36. Borja November 18, 2014 at 1:06 pm

    Hi, when I restart Eclipse and go to file explorer, the DDBB symbol is disabled, Eclipse Luna with ADT plugin…
    Thanks in advance.

  37. Borja November 19, 2014 at 7:39 am

    It’s strange, in the emulator, I have the database, but in a real device no.

    • James November 19, 2014 at 10:07 am

      Hey Borja ,

      In real device also there is the DB, its in the application sandbox, you can see it if your device is rooted, else create the DB in the SDCARD.

  38. Pingback: Android, viewing SQLite database in runtime (not like other questions) | Zills Answers

  39. nfa August 23, 2015 at 4:39 pm

    there is no any folder or file in my ddms. why?

    • James August 29, 2015 at 3:40 pm

      what do yu mean exactly?


Leave a Reply

Your email address will not be published. Required fields are marked *




Theme by HermesThemes

Copyright © 2018 CoderzHeaven. All Rights Reserved

Please wait...

Subscribe to our newsletter

Want to be notified when our article is published? Enter your email address and name below to be the first to know.