SQLite Viewer

Browse, query, and explore SQLite databases safely on your Android device.

SQLite Viewer is a powerful, read-only database inspector for Android. Open any SQLite database file on your device to explore its structure, browse data, run queries, and visualize table relationships — all without risking accidental changes to your data.

━━━━━━━━━━━━━━━━━━━━━━━━━

KEY FEATURES

▸ Open & Browse Databases
Open any .db or .sqlite file from your device storage. View a complete dashboard showing tables, views, indexes, triggers, file size, and SQLite version at a glance. Jump straight into any table with a searchable list.

▸ Table Data Viewer
Browse table data with pagination, full-text search, and column sorting. Values are color-coded by type — easily distinguish NULL, BLOB, text, and numeric values. Copy any cell or an entire row as JSON with a single tap.

▸ SQL Query Editor
Write and execute read-only SQL queries with syntax highlighting, auto-completion for keywords, table names, and column names. Save frequently used queries as bookmarks and access your full query history. Export query results in CSV, JSON, or SQL format.

▸ Schema Inspector
View detailed schema information for every table: column names, data types, primary keys, NOT NULL and UNIQUE constraints, default values, foreign key relationships with cascade rules, and index definitions. Copy CREATE statements to clipboard.

▸ Entity Relationship Diagram (ERD)
Visualize your entire database schema as an interactive diagram. See all tables, columns, and foreign key relationships at a glance. Zoom and pan to explore complex schemas with ease.

▸ BLOB Preview
Preview image data stored in BLOB columns directly in the app. Inspect non-image binary data in hexadecimal format.

▸ Data Export
Export table data or query results in three formats:
• CSV (RFC 4180 compliant, UTF-8 with BOM)
• JSON
• SQL INSERT statements
Save exports to your device or share directly to other apps.

▸ Recent Files
Quickly reopen your last 10 databases from the home screen. No need to navigate through folders again.

▸ Sample Databases
Two built-in sample databases let you explore the app's features immediately — no database file needed. Perfect for learning SQL or trying out the query editor.

━━━━━━━━━━━━━━━━━━━━━━━━━

SAFE & SECURE

SQLite Viewer is strictly read-only. A multi-layer security system blocks all write operations — INSERT, UPDATE, DELETE, DROP, ALTER, and more are prevented before they reach your database. Your data stays exactly as it is.

• No database modifications possible
• No data collected or uploaded
• No internet required for core features
• Files accessed through Android's secure Storage Access Framework

━━━━━━━━━━━━━━━━━━━━━━━━━

DESIGNED FOR EVERYONE

Whether you're an Android developer debugging a Room database, a data analyst inspecting records, a student learning SQL, or anyone curious about the data inside an app — SQLite Viewer gives you the tools to explore with confidence.

━━━━━━━━━━━━━━━━━━━━━━━━━

MODERN ANDROID EXPERIENCE

• Material Design 3 with dynamic colors
• Light, Dark, and System theme options
• Clean, intuitive navigation
• Optimized for phones and tablets

━━━━━━━━━━━━━━━━━━━━━━━━━

OPTIONAL AD REMOVAL

The app includes minimal, non-intrusive ads. Remove all ads permanently with a single one-time purchase from the Settings screen.

━━━━━━━━━━━━━━━━━━━━━━━━━

Download SQLite Viewer and start exploring your databases today.