SQLite Client
A local SQLite database client for Android. Open, edit, query, import, export, and maintain SQLite files safely on your device.
About
SQLite Client lets you open existing SQLite database files, create new databases, edit data and schemas, run SQL, manage encrypted databases, and export results from a mobile interface. It uses Android's Storage Access Framework (SAF) so you choose exactly which files the app can access, then works on a local cache copy and writes changes back only when you save.
Features
- File workflow: open SQLite files through SAF, create new empty databases, reopen recent files, and receive or share database files with other apps
- Data editing: inline cell editing, row add/duplicate/delete, column find and replace, and BLOB import/export
- SQL client: SELECT, INSERT, UPDATE, DELETE, and DDL with syntax highlighting, contextual autocomplete, multiple query tabs, history, bookmarks, transaction scripts, and destructive-query confirmation
- Schema designer: create/drop tables, add/rename/drop columns, manage indexes, and preview DDL before applying changes
- Maintenance tools: integrity and foreign-key checks, VACUUM, ANALYZE, REINDEX, selected PRAGMA editing, and schema diff between two databases
- SQLCipher support for opening encrypted databases and setting, changing, or removing database passwords
- Import/export: CSV and JSON import, plus CSV, JSON, SQL, and Markdown export
- Safety controls: automatic backup before write-back, integrity check before save, multi-step undo/redo, and read-only fallback with Save As when the original file cannot be written
- Extras: ERD diagram, charts, sample databases, in-app updates, English/Korean UI, themes, rows-per-page settings, and long text wrapping