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.

Recent changes:
A complete redesign — faster, cleaner, and easier to use.
• Brand-new UI with light & dark themes
• Redesigned table viewer: search, sort, inline edit, undo/redo
• Powerful SQL editor: syntax highlighting, autocomplete,
"Did you mean" error fixes, run-in-transaction
• 30 ready-made templates with sample data
• Smarter CSV import with auto column matching
• Export to CSV / JSON / TSV
• Fonts now bundled — fully offline, nothing leaves your device