How to use a script to query android sqlite database

Question

Android saved settings in a database file which is /data/data/com.android.providers.settings/databases/settings.db.

Android use sqlite3 as the database. We can use adb to manage the database file. I want to know if there is a way to run all these commands in a perl/python script to automate the whole query process?

$adb shell 
$sqlite3 /data/data/com.android.providers.settings/databases/settings.db

The above command will open the settings database. Then you will enter into sqlite3 command line.

First check how many tables existed in the database. Here lists the result.

sqlite> .tables

android_metadata   bookmarks          gservices        
bluetooth_devices  favorites          system

The settings (such as volume_alarm) I want to get are in "system" table, a .dump command will list all items in the table.

sqlite> .dump system
BEGIN TRANSACTION;
CREATE TABLE system (_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT UNIQUE ON CONFLICT REPLACE,value TEXT);
INSERT INTO "system" VALUES(3,’volume_system’,’5′);
INSERT INTO "system" VALUES(4,’volume_voice’,’4′);
INSERT INTO "system" VALUES(5,’volume_alarm’,’6′);
.....
$ select value from system where name ='volume_alarm';
select value from system where name ='volume_alarm'
6
$.quit;

yes, you can. search.cpan.org/~msergeant/DBD-SQLite-0.31/lib/DBD/SQLite.pm — mpapec
– mpapec, Commented May 31, 2013 at 7:23
@mpapec, he wants to use perl/python on PC to query database on the device. the sqlite perl module is not going to help unless he would pull the database file to PC. — Alex P.
– Alex P., Commented May 31, 2013 at 7:30

Alex P. · Accepted Answer · 2013-05-31 07:27:39Z

12

To query a specific value:

adb shell sqlite3 /data/data/com.android.providers.settings/databases/settings.db "select value from 'system' where name = 'volume_alarm';"

Or to pull all records from a table:

adb shell sqlite3 /data/data/com.android.providers.settings/databases/settings.db "select name, value from 'system';"

answered May 31, 2013 at 7:27

Alex P.

32k17 gold badges124 silver badges178 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ying.Zhao Over a year ago

@Alex I have the same question with you, and when I enter the command above, there is an error: sqlite3: Error: too many options: "acct", Do you know how to resolve it ? And do you have any suggestion on this issue that use a script to query android sqlite3? hope your reply,thanks.

pelotasplus Over a year ago

@Ying.Zhao you ned to quote the query like this: adb shell sqlite3 /path/file.db '"select * form table;"'

Veener Over a year ago

slightly modifying this worked for me, try my answer below

jay fall · Accepted Answer · 2016-04-13 13:11:46Z

0

this one works.

adb shell sqlite3 /data/data/com.android.providers.settings/databases/settings.db "\"select name, value from 'system';\""

answered Apr 13, 2016 at 13:11

jay fall

3842 silver badges4 bronze badges

Comments

Veener · Accepted Answer · 2018-06-07 14:06:39Z

0

Alex P's answer didn't quite work for me but this does:

To query a specific value

adb shell sqlite3 /data/data/com.android.providers.settings/databases/settings.db "\"select value from 'system' where name = 'volume_alarm';\""

Or to pull all records from a table:

adb shell sqlite3 /data/data/com.android.providers.settings/databases/settings.db "\"select name, value from 'system';\""

answered Jun 7, 2018 at 14:06

Veener

5,2712 gold badges36 silver badges37 bronze badges

Collectives™ on Stack Overflow

How to use a script to query android sqlite database

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related