To view the contents of your local database, you need to download software called Sqlite Studio: http://sqlitestudio.one.pl/
1.) Download and install Sqlite Studio on your computer.
2.) Connect the phone to the computer, make sure that you enable USB debugging. USB debugging can be activated using Settings β Applications β USB Debugging (or Settings β Developer Options β USB Debugging if you use an ice cream sandwich).
3.) Open the DDMS view in Eclipse and open the Explorer tab in DDMS, and then go to the database β data β (your-name-of-application) β. Now pull the data file from the database folder to your computer.
4.) Open Sqlite Studio and import the data file that you just pulled from your Android phone.
5.) Browse the contents of your database!
Hope this helps. Feel free to check if you understand!
source share