How to view data saved in android database(SQLite)?

Question

I am able to view the database from eclipse(from file explorer), but I want to view the whole detail, I mean the data that I have inserted, which I am unable. And my complete Android installation has made on F Drive.

score 86 · Accepted Answer · edited Feb 18 '15 at 22:30

86

You can access this folder using the DDMS for your Emulator. you can't access this location on a real device unless you have a rooted device.

You can view Table structure and Data in Eclipse. Here are the steps

Install SqliteManagerPlugin for Eclipse. Jump to step 5 if you already have it.
Download the *.jar file from here
Put the *.jar file into the folder eclipse/dropins/
Restart eclipse
In the top right of eclipse, click the DDMS icon
Select the proper emulator in the left panel
In the File Explorer tab on the main panel, go to /data/data/[YOUR.APP.NAMESPACE]/databases
Underneath the DDMS icon, there should be a new blue icon of a Database light up when you select your database. Click it and you will see a Questoid Sqlite Manager tab open up to view your data.

*Note: If the database doesn't light up, it may be because your database doesn't have a *.db file extension. Be sure your database is called [DATABASE_NAME].db

*Note: if you want to use a DB without .db-Extension:

Download this Questoid SqLiteBrowser: http://www.java2s.com/Code/JarDownload/com.questoid/com.questoid.sqlitebrowser_1.2.0.jar.zip
Unzip and put it into eclipse/dropins (not Plugins)

Check this for more information

edited Feb 18 '15 at 22:30

Muhammad Rehan Qadri

6,824
1
17
18

answered Apr 23 '11 at 06:13

droid kid

7,569
2
32
37

@soorya good ans but jar file not properly installing. it showing blur icon and it is not clickable in DDMS. why? – vnshetty Apr 23 '11 at 06:23
did you put it in the eclipse plugin folder.....i can't understand why its not working – droid kid Apr 23 '11 at 06:43
@YESi placed com.questoid.sqlitemanager_1.0.0.jar file in eclipse/plugins "It showing blur icon(In your article u showed with red arrow mark. there database icon was color no? it is rest in my case! ) and it is not clickable also in DDMS " .and one thing im using Helios version. – vnshetty Apr 23 '11 at 07:17
first you go to the data->data->Your Package-->then click the db file, then it will enable – droid kid Apr 23 '11 at 07:24
@soorya yeah! right.. but it opens only for .db extension my sqlite file is not .db extension. without renaming what can i do ? – vnshetty Apr 23 '11 at 07:36
3

updated Link to download: http://www.coderzheaven.com/2011/04/18/sqlitemanager-plugin-for-eclipse/ – AnhSirk Dasarp Feb 28 '13 at 04:32
Download the *.jar files from here "http://www.coderzheaven.com/2011/04/18/sqlitemanager-plugin-for-eclipse/" – Vinod VT May 29 '13 at 06:58
Updated the answer to contain new link. – ekatz Jul 10 '13 at 21:29
Does this require me to root the device? I don't think it's possible to go into the data/data directory without that... – ekatz Jul 10 '13 at 21:30
no..you cant see the database through device..this is d case of simulator – droid kid Jul 11 '13 at 11:33
Device must be rooted in order to access data/data directory. – IgorGanapolsky Jul 30 '13 at 15:08
/data is not present in my phone. How can i do that? – Sazzad Hissain Khan May 25 '14 at 11:55
You can only view /data on your physical phone if it is rooted. But you can view /data on a running emulator. – JDJ Jun 02 '14 at 06:30
any idea how to in ADT – Amit May 01 '16 at 17:24

score 6 · Answer 2 · edited Dec 25 '15 at 19:21

6

Dowlnoad sqlite manager and install it from Here.Open the sqlite file using that browser.

edited Dec 25 '15 at 19:21

shareef

9,255
13
58
89

answered Apr 23 '11 at 05:44

vnshetty

20,051
23
64
102

This manager seems to have a problem opening the contacts db, I'm not sure if that also applies to other Android sqlite dbs. The firefox addon [SQLite Manager](https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/) did the job for me. – user1151923 Sep 04 '17 at 08:21

score 4 · Answer 3 · edited Oct 29 '21 at 17:44

Try this..

Download the Sqlite Manager jar file here.
Add it to your eclipse > dropins Directory.
Restart eclipse.
Launch the compatible emulator or device
Run your application.
Go to Window > Open Perspective > DDMS >
Choose the running device.
Go to File Explorer tab.
Select the directory called databases under your application's package.
Select the .db file under the database directory.
Then click Sqlite manager icon like this .
Now you're able to see the .db file.

score 2 · Answer 4 · answered Dec 16 '12 at 17:42

2

I recommend the firefox plugin(SQLLite Manager) if you always use firefox.

Here is the link

answered Dec 16 '12 at 17:42

Günay Gültekin

4,486
8
33
36

I really appreciate this answer. http://stackoverflow.com/a/8925968/621951 This is the solution :) – Günay Gültekin Dec 16 '12 at 17:53

score 2 · Answer 5 · edited Sep 21 '16 at 12:31

2

If you are able to copy the actual SQLite database file to your desktop, you can use this tools to browse the data.

edited Sep 21 '16 at 12:31

Divyesh Savaliya

2,692
2
18
37

answered Apr 23 '11 at 05:32

Jim Blackler

22,946
12
85
101

score 1 · Answer 6 · edited Sep 07 '13 at 16:04

1

1. Download SQLite Manager
2. Go to your DDMS tab in Eclipse
3. Go to the File Explorer --> data --> data --> "Your Package Name" --> pull file from device 4. Open file in SQLite Manager.
5. View data.

edited Sep 07 '13 at 16:04

Tushar Gupta - curioustushar

58,085
24
103
107

answered Sep 07 '13 at 15:44

rjk2013

11
1

Skartt · Answer 7 · 2013-11-25T14:28:07.637

0

If you don't want to download anything, you can use sqlite3 tool which is provided with adb :

Examining sqlite3 databases from a remote shell

and :

Command Line Shell For SQLite

edited Nov 25 '13 at 14:28

answered Nov 25 '13 at 13:47

Skartt

551
2
7
19

score 0 · Answer 8 · answered Apr 23 '11 at 06:24

0

Open DDMS than in DATA>DATA>"Select your package like com.example.foo"> than select your database folder than pull that data in eclipse you can see the pull an push icon on top right side ...

answered Apr 23 '11 at 06:24

Ajay Patel

5,298
11
55
87

How to view data saved in android database(SQLite)?

8 Answers8

Linked