DB Browser for SQLite Alternative for iPhone and Android
Short answer: DB Browser for SQLite is a free desktop tool for Windows, macOS and Linux. On a phone, the equivalent is SQLite Editor & DB Viewer, which opens .db, .sqlite and .sqlite3 files on iPhone, iPad and Android, browses tables, runs SQL and edits rows.
We make SQLite Editor & DB Viewer, so weigh our pick accordingly. The other options here are good at what they do, and we say where they fit better.
When you need a phone alternative
Looking inside a database someone sent you, checking an app's data away from your desk, or learning SQL with real tables.
Options
- SQLite Editor & DB Viewer (iPhone, iPad, Android): browse tables and the schema, run SQL with syntax highlighting, build queries visually, edit rows inline, and import CSV, JSON and Excel or export to CSV. It runs offline and keeps the file on the device. It also has 26 interactive SQL lessons.
- DB Browser for SQLite: free and open source on desktop, with visual design of tables, indexes and views. Best at a computer.
- DBeaver: a desktop client for many database types. Best when you work with more than SQLite.
FAQ
Can I open a .db file on my phone? Yes, from Files, iCloud Drive or your file manager.
Can I edit a SQLite database on a phone? Yes, inline, and commit the changes.
Is the database uploaded? No, it stays on the device.
Download SQLite Editor & DB Viewer on the App Store · Get it on Google Play for Android