Awesome Open Source
Awesome Open Source

Android Arsenal


get sample apk from Google Play Store

What is this library about?

Sqlite Manager helps to manage your android Sqlite Database very effectively with ease

(currently under active development, expect to see new releases almost daily)


  • Add, Update and Delete entries from tables in UI (no sql).
  • Check all the table entries in your database with preferred sort order
  • Do custom queries on your database and results are displayed in UI


Based on your IDE you can import library in one of the following ways


debugCompile ''
releaseCompile ''

If you want this in library in production also then try this :

compile ''

or grab via Maven:


or Ivy:

<dependency org='' name='sqlite-manager' rev='1.3.0'>
  <artifact name='$AID' ext='pom'></artifact>

or Download the latest JAR


Implement SqliteDataRetriever interface either directly in SqliteOpenHelper (OR) if you are using thrid party ORM's ..etc just provide the inteface to library

Here is an example interface if SqliteOpenHelper is used (for other library implementations - check sample project)

    public class HelperSqliteDataRetriever implements SqliteDataRetriever {
        SqliteHelper mSqliteHelper;
        SQLiteDatabase mSQLiteDatabase;

        HelperSqliteDataRetriever(SqliteHelper sqliteHelper) {
            mSqliteHelper = sqliteHelper;
            mSQLiteDatabase = mSqliteHelper.getWritableDatabase();

        public Cursor rawQuery(@NonNull String query, String[] selectionArgs) {
            if (mSQLiteDatabase == null || !mSQLiteDatabase.isOpen()) {
                mSQLiteDatabase = mSqliteHelper.getWritableDatabase();
            return mSQLiteDatabase.rawQuery(query, selectionArgs);

        public String getDatabaseName() {
            return mSqliteHelper.getDatabaseName();

        public void freeResources() {
            // not good practice to open multiple database connections and close every time

Then just pass the interface instance with the context to launchSqliteManager method

    SqliteManager.launchSqliteManager(this, new HelperSqliteDataRetriever(sqliteHelper), null);

CSV/Json Export feature

To Use export as CSV/Json feature. need to define FileProvider in your app manifest.

1. If you don't have file-provider in your manifest

  1. Add this section under application tag in your manifest

        android:resource="@xml/file_provider_paths" />
  1. create a new xml file with name file_provider_paths and paste the below content in the file
<?xml version="1.0" encoding="utf-8"?>
        path="sqliteManager/" />
  1. while launching sqlite manager pass application_id
    SqliteManager.launchSqliteManager(this, new HelperSqliteDataRetriever(sqliteHelper), BuildConfig.APPLICATION_ID);

2. If you already have a file-provider in your manifest

  1. add files-path mentioned below to existing paths in your xml file.
<?xml version="1.0" encoding="utf-8"?>
    <!-- -.-.-.-.-.-.-.-.-.-.- your current paths, caches ..etc -.-.-.-.-.-.-.-.-.-.- -->
        path="sqliteManager/" />
  1. while launching sqlite manager pass the authorities declared in your manifest
    SqliteManager.launchSqliteManager(this, new HelperSqliteDataRetriever(sqliteHelper), "authority_string_mentioned_in_your_manifest");


Sqlite Manager library for Android
Copyright (c) 2016 Ashok Varma (

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
See the License for the specific language governing permissions and
limitations under the License.

Other Open Source Libraries

  1. Gander : Gander is a simple in-app HTTP inspector for Android OkHttp clients. Gander intercepts and persists all HTTP requests and responses inside your application, and provides a UI for inspecting their content.
  2. SharedPrefManager : SharedPref Manager is a Dev Debug tool that helps to manage(Edit, Add, Clear) your android Shared Preferences.
  3. BottomNavigation : This Library helps users to use Bottom Navigation Bar (A new pattern from google) with ease and allows ton of customizations.

Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
java (31,769
android (6,472
sqlite (320
sqlite-database (24