# SQLite Client - Browse & Query

Android app · by Sia Makerlab · Tools

SQLite Client - Browse & Query has 2,513 installs, \#65,678 of 236,906 in Tools.

## Figures

- Installs: 2,513
- Rating: unrated
- Price: Free
- In-app purchases: yes
- Rank: #762,867 of 2,861,668 Android listings with an install count (down 18,512 since 2026-11-01)
- Rank: #65,678 of 236,906 in Tools

## Description

🗄️ SQLite Client is a local SQLite database client for Android.  
  
Open a database file, create a new one, edit data and schema, run SQL, build queries visually, learn SQL hands-on, import or export data, and save changes back with safeguards designed to protect your files.  
  
✨ KEY FEATURES  
  
📂 File-based SQLite workflow  
Open .db, .sqlite, .sqlite3, and .db3 files through Android's Storage Access Framework. Create a new empty database, reopen recent files, receive database files from other apps, and share databases when needed.  
  
✏️ Data editing  
Edit cells inline, add rows, duplicate rows, delete rows, and find and replace values by column. Import or export BLOB data, preview image BLOBs inline, and open audio or video BLOBs in your player. Tables without a safe row identity stay protected from unsafe row edits.  
  
⌨️ SQL editor  
Run SELECT, INSERT, UPDATE, DELETE, DDL, and multi-statement scripts with syntax highlighting, context-aware completion, query tabs, history, bookmarks, destructive statement confirmation, and single-transaction script execution.  
  
🧩 Visual query builder  
Build SELECT statements without writing SQL. Pick a table and columns, add WHERE conditions (=, !=, \<, \>, LIKE, IS NULL, IN and more), set ORDER BY and LIMIT, preview the generated SQL live, then run it or send it to the editor.  
  
🎓 Learn SQL  
Practice with ten built-in lessons covering SELECT, WHERE, sorting, aggregates, GROUP BY, JOIN, and INSERT/UPDATE/DELETE. Every lesson runs in a safe sandbox on sample data, so your real files stay untouched, and your progress is saved.  
  
🏗️ Schema designer  
Create and drop tables, add columns, rename columns, drop columns, create or remove indexes, inspect constraints, and preview generated DDL before applying schema changes.  
  
🧰 Database tools  
Run integrity checks, foreign key checks, VACUUM, ANALYZE, REINDEX, PRAGMA edits such as user\_version and journal\_mode, and compare schemas between two databases.  
  
🔐 SQLCipher support  
Open encrypted SQLite databases, set or change a password, remove encryption, and save encrypted files back through the same safe editing flow.  
  
📥 Import and export  
Import CSV or JSON data with a guided column-mapping wizard: choose the delimiter, header handling, target mode (new table, append, or replace), per-column type, default values, and conflict policy. Export table data or query results as CSV, JSON, SQL, Markdown, or Excel (XLSX), and save reusable export presets with filename templates.  
  
🧭 ERD and data visualization  
Explore tables, columns, and foreign key relationships in an interactive ERD. Tap a table to jump to its data or schema, review foreign key details, and highlight tables with no relations. Create quick charts from query results when data needs a visual check.  
  
🛡️ SAFE BY DESIGN  
SQLite Client edits a temporary working copy first. When you save, the app backs up the original file, checkpoints WAL data, runs an integrity check, and only then writes back to the selected file. Before saving, you can preview a summary of schema and row-count changes.  
  
Additional safeguards include:  
• File snapshot undo and redo for data and schema edits  
• Change preview before writing back  
• Destructive SQL confirmation  
• Read-only fallback when the source cannot be written  
• Save As flow when original write access is unavailable  
• Offline core database features  
• No database contents collected or uploaded  
  
🌍 LANGUAGES  
Available in English and Korean.  
  
📱 MODERN ANDROID EXPERIENCE  
• Material Design 3  
• Light, Dark, and System themes  
• Recent files and sample databases  
• Optimized for phones, tablets, and foldables  
  
Use SQLite Client to inspect, edit, query, build, learn, and maintain SQLite databases directly on your Android device.

---

Source: https://storetally.com/android/com.siamakerlab.sqliteviewer  
As of 2026-11-09, from the StoreTally census.