sqlite - zollak/pentest-notes GitHub Wiki

Basic sqlite commands and usage

Tipically location: /databases

https://developer.android.com/studio/command-line/sqlite3.html http://www.sqlite.org/cli.html

Usage:

# sqlite3 /data/data/com.android.email/databases/EmailProvider.db
sqlite> .help
sqlite> .tables
sqlite> .dump Account

sqlite> .header on
sqlite> .mode column
sqlite> .timer on
sqlite> SELECT * FROM android_metadata;

root@android:/data/data/com.dropbox.android/databases # sqlite3 prefs.db       
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .headers on
sqlite> .mode line
sqlite> .tables
DropboxAccountPrefs     DropboxPersistentPrefs  android_metadata      
sqlite> select * from DropboxAccountPrefs;
...
       _id = 7
 pref_name = EMAIL
pref_value = [email protected]
...
sqlite> .q
⚠️ **GitHub.com Fallback** ⚠️