# Data browser for Encrypted Database

**URL:** <https://discuss.zetetic.net/t/data-browser-for-encrypted-database/523>\
**Category:** SQLCipher\
**Created:** [April 13, 2015, 7:19am UTC](https://discuss.zetetic.net/t/data-browser-for-encrypted-database/523 "2015-04-13T07:19:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vinay\_kumar](https://avatars.discourse-cdn.com/v4/letter/v/59ef9b/32.png) [@vinay\_kumar](https://discuss.zetetic.net/u/vinay_kumar)\
**Post date:** [April 13, 2015, 7:19am UTC](https://discuss.zetetic.net/t/data-browser-for-encrypted-database/523/1 "2015-04-13T07:19:47Z")

</div>

Hi All,

I have the SQLCipher for Android working and able to see some junk data when i hexdump an encrypted database. Want to know if there is any tool where in I can key in the passphrase to the encrypted database and can literally see the actual decrypted content in the database. I tried using Sqlite3 tool available as part of android-sdk/platofrm-tools and unable to do so. Can you pls suggest if there are any such tools available.

Also, the key that is derived by the framework using our passphrase, does that store in the device or within the database. Basically, want to export the encrypted database in one device and export the database and copy to another device and be able to extract the data. Will this be possible ?

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [April 13, 2015, 1:05pm UTC](https://discuss.zetetic.net/t/data-browser-for-encrypted-database/523/2 "2015-04-13T13:05:01Z")

</div>

Hello @vinay_kumar

There are few options in terms of tools to interact with a SQLCipher database, please take a look at the options [here](https://discuss.zetetic.net/t/management-interfaces-for-sqlcipher-databases/121). The key that is derived from the passphrase is only resident in memory, it is not persisted to the database or device. There are options available for exporting a database, please take a look at the [`sqlcipher_export(…)`](https://www.zetetic.net/sqlcipher/sqlcipher-api/#sqlcipher_export) convenience function.

---

<div class="post-metadata">

**Author:** ![vinay\_kumar](https://avatars.discourse-cdn.com/v4/letter/v/59ef9b/32.png) [@vinay\_kumar](https://discuss.zetetic.net/u/vinay_kumar)\
**Post date:** [April 20, 2015, 10:16am UTC](https://discuss.zetetic.net/t/data-browser-for-encrypted-database/523/3 "2015-04-20T10:16:12Z")

</div>

Thanks for the pointer Nick. What I want is something like a free tool which can open the encrypted database.

---

<div class="post-metadata">

**Author:** ![sjlombardo](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/sjlombardo/32/3_2.png) [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\
**Post date:** [April 20, 2015, 1:12pm UTC](https://discuss.zetetic.net/t/data-browser-for-encrypted-database/523/4 "2015-04-20T13:12:21Z")

</div>

Hello @vinay_kumar

The primary free tool available at this time is the SQLCipher command line shell. This command line tool allows you to open encrypted databases, query them, and manipulate them. You can either build the command line tools, or binaries are included in certain SQLCipher Commercial Edition packages.

Another free tool that might suit your needs is [http://sqlitebrowser.org/](http://sqlitebrowser.org/). They recently added SQLCipher support for Mac and Linux.