SQLiteR - DB Browser & Editor

Macro Apps

About this app

SQLiteR is a Powerful SQLite database manager for Android. Open, browse, edit, query, and export databases from your phone or tablet.

Built for developers, testers, and students who need to look inside a .db file without a computer.

Database management
• Open .db and .sqlite files from device storage
• Download and open databases from a URL
• Create new SQLite databases
• Reopen recent databases, or delete one from the list
• See database size, table count, SQLite version, and modification date

Browse and edit
• Browse tables in a sortable, paginated data grid
• Search tables and rows
• Choose which columns to display
• Add, edit, and delete rows with type-aware inputs, including tables with no primary key
• Create, edit, rename, and delete tables
• Set column types, default values, primary keys, NOT NULL, UNIQUE, and AUTO INCREMENT
• Create foreign keys with ON UPDATE and ON DELETE actions
• Preview the generated SQL before applying schema changes
• Table rebuilds keep your indexes, triggers, and views

Views
• Browse views next to your tables
• Create and edit views on a dedicated screen
• View SQL is checked before it saves, and a broken view can be deleted from the error dialog
• Views open read-only

Schema relations
• Browse and search the relations between tables and views

SQL terminal
• Run raw SQL with syntax highlighting
• Get suggestions for keywords, tables, and columns as you type
• Results render for SELECT, PRAGMA, EXPLAIN, VALUES, and RETURNING queries
• Page through large result sets
• Query history is saved per database, and one tap restores an old query
• Plain database error messages

Global search
• Search table names and row values across the whole database
• Filter results by tables or rows
• Jump straight to a matching table or record
• Search history per database, with restore and clear

Export and share
• Export as SQLite DB, SQL dump, JSON, or CSV ZIP
• Save to device storage or send to another app
• Pick a filename, watch progress, cancel mid-export

Built for mobile & Tablet
• Light and dark themes
• Layouts that fit phones and tablets
• No account required
• Everything runs locally on your device

Important: SQLiteR edits a working copy of an opened database and never overwrites the original file automatically. Export the database when you are ready to save or share your changes.