Skip to content

Most visited

Recently visited



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:

  1. Enter a remote shell by entering the following command:
    adb [-d|-e|-s {<serialNumber>}] shell
  2. 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/.

  3. Once you invoke sqlite3, you can issue sqlite3 commands in the shell. To exit and return to the adb remote shell, enter exit or press Control+D.

Here's an example:

$ adb -s emulator-5554 shell
# sqlite3 /data/data/
SQLite version 3.3.12
Enter ".help" for instructions
.... enter commands, then quit...
# sqlite> .exit

To use sqlite3 locally, instead of within a shell, pull the database file from the device and start sqlite3:

  1. Copy a database file from your device to your host machine:
    adb pull <database-file-on-device>
  2. Start the sqlite3 tool from the /tools directory, specifying the database file:
    sqlite3 <database-file-on-host>
This site uses cookies to store your preferences for site-specific language and display options.

Get the latest Android developer news and tips that will help you find success on Google Play.

* Required Fields


Follow Google Developers on WeChat

Browse this site in ?

You requested a page in , but your language preference for this site is .

Would you like to change your language preference and browse this site in ? If you want to change your language preference later, use the language menu at the bottom of each page.

This class requires API level or higher

This doc is hidden because your selected API level for the documentation is . You can change the documentation API level with the selector above the left navigation.

For more information about specifying the API level your app requires, read Supporting Different Platform Versions.

Take a short survey?
Help us improve the Android developer experience. (Dec 2017 Android Platform & Tools Survey)