SQLiteR - DB Browser & Editor

Macro Apps

About this app

Browse, edit, query, and export SQLite databases directly on your Android phone or tablet.

SQLiteR is a powerful SQLite editor, SQLite browser, and database manager designed for developers, testers, students, and anyone working with SQLite databases. Open existing databases, create new ones, modify schemas, run SQL queries, and export your work—all without a desktop computer.

Whether you're debugging an Android app, inspecting local databases, or editing production data, SQLiteR gives you everything you need in one fast, offline tool.

Open & manage databases
• Open SQLite databases from device storage
• Download and open databases from HTTP or HTTPS URLs
• Create new SQLite databases
• Quickly reopen recently used databases
• View database information including tables, file size, SQLite version and more
• Works completely offline

Browse & edit data
• Browse tables in a fast, paginated database browser
• Search rows instantly
• Sort data by any column
• Choose which columns to display
• Insert, edit and delete rows
• Type-aware editors for text, numbers, dates, booleans and NULL values
• Automatically refresh data after every change

Create & modify database schemas
• Create, rename and delete tables
• Add, edit and remove columns
• Configure data types and constraints
• Primary Keys
• Foreign Keys
• NOT NULL
• UNIQUE
• AUTOINCREMENT
• DEFAULT values
• Preview generated SQL before applying schema changes

SQL Editor & Terminal
• Execute raw SQL queries
• SQL autocomplete for keywords, tables and columns
• View large query results with pagination
• Helpful SQLite error messages
• Supports SELECT, INSERT, UPDATE, DELETE and DDL statements

Search your entire database
• Search table names
• Search records across every table
• Jump directly to matching rows
• Filter search results

Export & share
Export your database as:

• SQLite database
• SQL dump
• JSON
• CSV (ZIP)

Save files locally or share them directly with other apps.

Built for developers
• Material Design interface
• Phone and tablet layouts
• Light, dark and system themes
• Fast local processing
• No account required
• No internet required after opening your database
• All database processing stays on your device

Safe editing
SQLiteR never modifies your original database automatically.

Every database is opened as a working copy, allowing you to review your changes before exporting a new SQLite database. Your original file always remains untouched unless you choose to replace it yourself.

What’s new

- Fixed editing and deleting rows in tables without a primary key
- Fixed setting a field to NULL vs using the column default when inserting or updating
- Resetting a cell to its default value now works correctly
- Editing a table structure no longer drops indexes, triggers, or views
- Export cancel is faster and cleans up temporary files reliably
- Fixed exports sometimes leaving incomplete or duplicate files
- General stability improvements in the SQL editor and row editor