What Is SQLite Viewer?
SQLite Viewer lets you browse SQLite database files, explore tables, run custom SQL queries, and export results — all directly in your browser. This tool runs 100% client-side using a built-in database engine. Your database files are never uploaded to any server.
It supports .sqlite, .db, .sqlite3, and .db3 files up to 50MB. Features include table browsing, custom SQL queries with Ctrl+Enter execution, result export as CSV, copy to clipboard as TSV, drag-and-drop upload, and browser storage persistence across page refreshes.
How to Use This Tool
Upload a Database
Click Upload Database or drag and drop a .sqlite, .db, .sqlite3, or .db3 file onto the input area. Maximum file size: 100MB. The database is loaded entirely in your browser.
Browse Tables
All tables are shown as clickable buttons. Click a table name to view its first 100 rows. The SQL query updates automatically so you can modify it.
Run Custom Queries
Edit the SQL query in the text area and click Run Query or press Ctrl+Enter. You can run any valid SQL: SELECT, JOIN, WHERE, GROUP BY, ORDER BY, aggregate functions, and more.
Export Results
Click Copy Results to copy the table as TSV (tab-separated) to your clipboard, or Export CSV to download as a .csv file. Click Clear All to close the database and reset.
Features Explained
Full SQLite Engine
▼
This tool uses a full database engine running directly in your browser. This means you get real SQLite functionality — not a simplified parser — with full SQL support.
Table Browser
▼
After uploading a database, all tables are displayed as clickable buttons. Clicking a table automatically runs SELECT * FROM table LIMIT 100 and displays the results. The query is editable so you can refine it.
Custom SQL Queries
▼
Write any valid SQL query in the text area. Supports SELECT, JOIN, WHERE, GROUP BY, ORDER BY, HAVING, LIMIT, OFFSET, subqueries, aggregate functions (COUNT, SUM, AVG, MIN, MAX), and all standard SQLite syntax.
Keyboard Shortcut
▼
Press Ctrl+Enter (or Cmd+Enter on Mac) to execute the current query without clicking the Run Query button. Fast and convenient for iterating on queries.
Export as CSV
▼
Click Export CSV to download the current query results as a .csv file. The filename is based on the selected table name. Handles commas, quotes, and newlines in cell values correctly.
Copy Results
▼
Click Copy Results to copy the query output as tab-separated values (TSV) to your clipboard. Paste directly into Excel, Google Sheets, or any spreadsheet application.
Drag & Drop Upload
▼
Drag a SQLite database file from your file explorer directly onto the input area. The area highlights when a file is dragged over it.
File Size Limit
▼
Database files up to 50MB are supported. The file is loaded entirely into browser memory, so very large databases may be slow. The 50MB limit keeps performance reasonable across all devices.
Browser Storage Persistence
▼
Your uploaded database file is saved to browser storage. Refreshing the page restores the database, tables, and lets you continue querying. Only clicking Clear All removes the stored database.
NULL Value Display
▼
NULL values in query results are displayed as italic 'NULL' text in gray, making them easy to distinguish from empty strings or other values.
Who Is This Tool For?
Developers
Inspect SQLite databases from mobile apps, Electron apps, or embedded systems without installing any database client.
Data Analysts
Browse and query SQLite datasets, export results as CSV for further analysis in Excel or Python.
QA & Testers
Verify database contents during testing, run queries to check data integrity without setting up a local SQLite environment.
Students
Learn SQL by running queries against real databases directly in the browser. No installation or setup required.
Mobile Developers
Debug Android or iOS SQLite databases by uploading the .db file from your device or emulator.
Privacy-Conscious Users
Inspect database files without uploading them to any cloud service. Everything stays on your device.
Tips for Using SQLite Viewer
Start with table buttons
Click a table name to quickly see its data. The auto-generated query is editable — modify it to add WHERE clauses, change the LIMIT, or join other tables.
Use LIMIT for large tables
If a table has thousands of rows, use LIMIT and OFFSET to paginate: SELECT * FROM table LIMIT 100 OFFSET 200.
Ctrl+Enter to run queries
Press Ctrl+Enter to execute your query instantly without reaching for the Run Query button.
Export for further analysis
Use Export CSV to download results for Excel or Google Sheets. Use Copy Results (TSV) for quick paste into spreadsheets.
Inspect schema with SQL
Run SELECT sql FROM sqlite_master WHERE type='table' to see the CREATE TABLE statements for all tables.
Your database persists
The database is saved to browser storage. Refresh the page and continue where you left off. Only Clear All removes it.
Privacy & Security
This tool runs 100% in your browser. Your database file is never uploaded to any server. All SQL execution happens locally using a built-in database engine. The database is stored in browser storage for persistence across refreshes.
No cookies are used, no analytics track your queries, and no third-party services have access to your data. Click Clear All to remove the database from browser storage immediately.