From a remote shell to your device or from your host machine, you can use the sqlite3 command-line program to manage SQLite databases created by Android applications. The sqlite3 tool includes many useful commands, such as .dump to print out the contents of a table and .schema to print the SQL CREATE statement for an existing table. The tool also gives you the ability to execute SQLite commands on the fly.
To use sqlite3 from a remote shell:
- Enter a remote shell by entering the following command:
- From a remote shell, start the sqlite3 tool by entering the following command:
You can also optionally specify a full path to a database that you want to explore. Emulator/device instances store SQLite3 databases in the directory /data/data/<package_name>/databases/ .
Here’s an example:
To use sqlite3 locally, instead of within a shell, pull the database file from the device and start sqlite3 :
- Copy a database file from your device to your host machine:
- Start the sqlite3 tool from the /tools directory, specifying the database file: