Android Enthusiasts Stack Exchange is a question and answer site for enthusiasts and power users of the Android operating system. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I read documentation such as Examining sqlite3 databases from a remote shell I get the impression an sqlite command-line binary should exist on my phone. Sadly I can't seem to find it on my phone (but I'm running a custom ROM.)

I've read a few other posts that either allude to the existence of such a binary or mention how it is only available in the emulator, but there is nothing definitive.

Does anybody know if such a binary is available anywhere?

Other refs:

share|improve this question
I suppose you could try pulling it from another ROM (or the emulator) and putting it on your device, but I have no idea if that would work or just crash. CM6, for instance, has the sqlite3 binary. – eldarerathis Jan 22 '11 at 2:59
on my Samsung Spica -- using Samdroid mod -- I can just type sqlite3 in terminal emulator or adb shell. – Lie Ryan Jan 22 '11 at 3:15
Is this a dev question? – Matthew Read Jan 22 '11 at 12:48
@Matthew - nope – fostandy Jan 23 '11 at 19:47

Your best bet would be to use ADB and pull it off the emulator, or pull it from another rom. You will then have to put it on your device, but you will have to have root to put it in the directory with the other binaries.

sqlite3 does not come on most of the devices, I think it only comes on the dev phones, like ADP1/ADP2, Nexus One/Nexus S. I know it is not on the Samsung Galaxy S devices such as the Vibrant (I am guessing its on the Nexus S).

share|improve this answer

SuperOneClick actually has a copy of the binary. It lives in the Dependencies folder, and according to one poster on Stack Overflow, it works when pushed onto your device (I assume it must work on most devices since SuperOneClick uses it).

share|improve this answer

As other posts have mentioned, the sqlite3 binary is typically used via ADB from your PC.

If all you want to do is manage SQLite DBs locally, then I've found the free app aSQLiteManager very useful. In addition to a simple GUI for managing and viewing data, it allows running of arbitrary queries.

share|improve this answer

I have put together some build scripts to compile SQLite for Android Native Code using the Android NDK. It builds the SQLite CLI in two versions: Statically and Dynamically Linked, as well as it's Static and Shared Libraries. You may get the scripts from my GitHub and build the binaries yourself:

Hope this will be useful for someone.

share|improve this answer

tech128 from XDA Forum provides compiled sqlite3 binary for Android.

As of current writing,

Here's SQLite combined into a single source file (the amalgamation) for ARM v6 and v7.

These binaries are built with optimized armv6 and armv7 flags.

Should work on Android 2.x and up.

I have attached 2 versions to this thread, compressed and uncompressed. I had to change the extension to .xap otherwise I can't upload it. Just remove the extension.

Just download and run the uncompressed file, whereas compressed you have to decompress it first.



Source code:

I have tested the armv7-pie (PIE needed for Lollipop) on my Nexus 5 running Android 5.1.1 Lollipop, and it worked.

share|improve this answer

Pulling it off of the emulator won't work.

I found a 1.6 binary here. That page details information on porting, so if the 1.6 binary doesn't work, you can try porting/compiling a new version.

share|improve this answer

A little complicated process I will suggest, because I am not aware of other ways :) , get the Android source code , compile it , in the output directory you will get sqlite3 binary , then push it to your phone's /system/bin/

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.