SQLite Client

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