A react native android wrapper for SQLite

Usage no npm install needed!

<script type="module">
  import reactNativeAndroidSqlite from '';


React Native Android Sqlite

A react native android wrapper for SQLite


React Native doesn't have a built-in module to access Sqlite databases, either in iOS or Android.

This library intends to fill the gap on the Android side.


  • Install Module
npm install --save-dev react-native-android-sqlite
  • android/settings.gradle
include ':react-native-android-sqlite'
project(':react-native-android-sqlite').projectDir = new File(settingsDir, '../node_modules/react-native-android-sqlite')
  • android/app/build.gradle
dependencies {
    compile project(':react-native-android-sqlite')
  • register module (in

import io.jbrodriguez.react.*; // <--- import 

public class MainActivity extends Activity implements DefaultHardwareBackBtnHandler {
    protected void onCreate(Bundle savedInstanceState) {
        mReactRootView = new ReactRootView(this);

        mReactInstanceManager = ReactInstanceManager.builder()
                .addPackage(new MainReactPackage())
                .addPackage(new RNSQLiteModule())           // <- add here

        mReactRootView.startReactApplication(mReactInstanceManager, "YourProject", null);



This library depends on SQLiteAssetHelper.

The idea is that you import your previously created database as an application asset.

SQLiteAssetHelper manages schema definition (create), as well as upgrades.

For more information refer to SQLiteAssetHelper's docs and/or check SQLiteOpenHelper

So, the first step involves copying your sqlite db to the following folder


Substitute <YourProject> with the folder where your app resides, i.e. AwesomeProject.

NOTE: Originally, I suggested copying the sqlite db to <ReactNativeRootFolder>/node_modules/react-native-android-sqlite/src/main/assets/databases. Although it works, the db will be erased each time you upgrade this component, so it's better to follow the updated instructions.

Having done that, you can start interacting with the db, through 4 public functions:

  • init
  • query
  • exec
  • close


The database must be initialized before any other call takes place

var sqlite = require('react-native-android-sqlite')

var databaseName = 'app.db'

    .then((_) => {
        console.log('database initialized.')


pre-requisite: the db must have been initialized

var sqlite = require('react-native-android-sqlite')

var sql = 'INSERT INTO todo(name, completed) VALUES (?, ?)'
var params = ["Create react native android sqlite", 1]

sqlite.exec(sql, params)
    .then((_) => {
        console.log('row inserted.')


pre-requisite: the db must have been initialized

var sqlite = require('react-native-android-sqlite')

var sql = 'SELECT * FROM todo WHERE completed = ?'
var params = [1]

sqlite.query(sql, params)
    .then((data) => {
        console.log('retrieved: ', data)


pre-requisite: the db must have been initialized

    .then((_) => {
        console.log('database closed')

Known Issues

  • It doesn't return the id for a newly inserted row (maybe create a separate insert function ?)
  • Column types currently supported are Integer and String
  • Additional error handling should be implemented
  • Although I'm using it in my personal projects, it's still an early release. Please do read the license


Please submit any PR's you seem fit.