SQLite Pro: Database Editor

SQLite Pro is a careful, fast SQLite database manager for Android. Open any .db or .sqlite file, browse and edit rows like a spreadsheet, and run real SQL — with undo for your edits and scripts that roll back if anything fails.

DATABASES

• Create a new database or import any SQLite file (the original file is left untouched)

• Rename, duplicate (with data or structure only), export and share

• Search and sort by name, size, date or number of tables

• Delete safely: you type the name to confirm and can export a copy first

BROWSE AND EDIT DATA

• Spreadsheet-style grid with typed column headers (INTEGER, TEXT, REAL, BLOB)

• Search, sort by any column and page through large tables

• Edit rows in a form that understands NULLs, numbers and required fields

• Undo and redo row edits, deletes and column changes

• Add, drop and rename columns and tables, with a clear list of what will be affected

A REAL SQL EDITOR

• Syntax highlighting and line numbers

• Autocomplete for tables, columns, keywords and functions

• Run the statement under your cursor, or Run all to execute a whole script in one transaction — if any statement fails, nothing is changed

• Plain-English error messages with one-tap “Did you mean…?” fixes

• Query history, favorites and ready-made example queries

• Export results as CSV, JSON or TSV, copy them or share them

IMPORT CSV

• Pick a file, check the automatic column matching, import

• Live progress, a list of any rows that were skipped and why

• Cancel at any time and every imported row is rolled back

SCHEMA TOOLS

• Tables, views, indexes and triggers, each with its exact CREATE statement

• Visual table builder with primary keys, auto-increment, NOT NULL, UNIQUE and defaults

• View builder that checks your query and previews the result as you type

30 TEMPLATES

Inventory, CRM, point of sale, budgets, invoices, gym memberships, a library, recipes and more — each with tables and sample rows so you can start exploring right away.

MADE FOR EVERY SCREEN

• Light, dark or follow your phone’s theme

• Works on phones, in landscape and on tablets

• Respects “remove animations” and supports TalkBack

PRIVATE BY DESIGN

No account needed. Your databases stay on your device unless you export or share them.