Nitro SQLite is a SQLite library for React Native on iOS, macOS, visionOS, and Android, built with Nitro Modules. It provides synchronous and asynchronous queries, transactions, and batch operations.
The bundled SQLite build enables R*Tree indexes by default on Apple platforms and Android. Set nitroSQLite.enableRTree to false in your app's package.json to omit it from the native build.
Read the documentation for setup, guides, integrations, and the API reference.
If you use a coding agent, give it the NitroSQLite skill. It links to focused guidance for connections, queries, transactions, concurrency, and migration. See the AI agent guide for what to check in generated code.
Installation
Requires React Native 0.75 or newer and react-native-nitro-modules 0.37.1 or newer.
npm install react-native-nitro-sqlite react-native-nitro-modules
Rebuild the native app after installing. Expo projects need a development build; Expo Go cannot load this native module. See Getting Started for details.
Example
import { open } from 'react-native-nitro-sqlite'
const db = open({ name: 'app.sqlite' })
db.execute('CREATE TABLE IF NOT EXISTS notes (id INTEGER PRIMARY KEY, body TEXT)')
db.execute('INSERT INTO notes (body) VALUES (?)', ['Hello'])
const { rows } = db.execute<{ id: number; body: string }>(
'SELECT id, body FROM notes',
)
console.log(rows._array)
db.close()
Migrating from Quick SQLite
react-native-quick-sqlite 8.x was succeeded by react-native-nitro-sqlite 9.x. Follow the migration guide before updating an app with existing database files.
Community and contributing
Join the Margelo Community Discord. Contributions are welcome through issues and pull requests.
License
MIT.
