SQLite Viewer

🗄️ SQLite Viewer is a 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, then jump straight into any table with a searchable list.

📊 Table Data Viewer
Browse table data with pagination, full-text search, and column sorting. NULL, BLOB, text, and numeric values are clearly distinguished by type, and you can 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 and smart, context-aware auto-completion for keywords, table names, and column names. Save frequently used queries as bookmarks, revisit your full query history, and export results as CSV, JSON, or SQL.

🔑 Schema Inspector
Inspect every table in detail: column names, data types, primary keys, NOT NULL and UNIQUE constraints, default values, foreign key relationships, and index definitions. Copy CREATE statements to the 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, and pinch to zoom and pan to explore complex schemas with ease.

🖼️ BLOB Preview
Preview image data stored in BLOB columns directly in the app, and inspect other binary data in hexadecimal format.

📤 Data Export
Export table data or query results in three formats — CSV (RFC 4180, UTF-8), JSON, and SQL INSERT statements. Save to your device or share directly with other apps.

🕘 Recent Files
Reopen your most recent databases right from the home screen, without navigating through folders again.

🧪 Sample Databases
Two built-in sample databases let you explore every feature immediately — perfect for learning SQL or trying out the query editor.

🔒 SAFE BY DESIGN
SQLite Viewer is strictly read-only. A multi-layer safeguard blocks all write operations — INSERT, UPDATE, DELETE, DROP, ALTER and more are prevented before they ever reach your database.
• No modifications to your databases
• No data collected or uploaded
• Core features work fully offline
• Files accessed through Android's secure Storage Access Framework

🌍 LANGUAGES
Available in English and Korean.

👩‍💻 DESIGNED FOR EVERYONE
Whether you are a developer debugging a Room database, a data analyst inspecting records, a student learning SQL, or simply curious about the data inside an app, SQLite Viewer gives you the tools to explore with confidence.

📱 MODERN ANDROID EXPERIENCE
• Material Design 3
• Light, Dark, and System themes
• Clean, intuitive navigation
• Optimized for phones, tablets, and foldables

Start exploring your databases today.