1. Run your emulator and check the port on which he’s running.

2. Connect to the emulator via shell (terminal)
Use command:
$ adb -s <emulatorId> shell
My example:
$ adb -s emulator-5554 shell
Hint: to list all active emulators use command:
$ adb devices
3. Each Android database is hold in a file .
The path pattern to your db file is (while you connected to emulator):
# /data/data/<your_app_package>/databases
So just go there to see your databases, in my example it looks like this:
# cd /data/data/com.example.application/databases
# ls EXAMPLE_DATABASE
4. Open your database.
So now, while I know which db I want to open I do this:
# sqlite3 /data/data/net.hopbit.dev.myapplication/databases/MY_EXAMPLE_DATABASE
SQLite version 3.6.22
Enter „.help” for instructions
Enter SQL statements terminated with a „;”
5. Manage your DB and execute queries
Now, when I’m connected to my database I can manage my db and execute some queries, here’s example:
sqlite> .tables
NOTES_TAB USERS_TAB
sqlite> select * from users_tab;
LOGIN|NAME|SURNAME
test1|Test|One
test2|Test|Two
Resources:
* Android Debug Bridge | Android Developers
* Command Line Shell For SQLite
Share this article