SQLite Viewer
Open a .sqlite or .db file to browse its tables, check its schema and run SQL, all inside your browser.
- Tables, views & schema
- Run any SQL
- CSV & JSON export
- No upload
Drop a .sqlite, .sqlite3 or .db file here, or start with the sample shop database or an empty one.
What is an SQLite viewer?
SQLite is the most widely deployed database in the world: phones, browsers, desktop apps and countless tools store their data in a single SQLite file. Reading one normally means installing DB Browser for SQLite or using the sqlite3 command line. This viewer runs the real SQLite engine, compiled to WebAssembly, in your browser. Open a file to list its tables, views, indexes and triggers with row counts, scroll through rows in a fast grid, inspect column types, primary keys, foreign keys and the original CREATE statements, and run any SQL query. Changes you make with SQL can be saved as a new database file.
How to open an SQLite database
- Choose Open File and pick a .sqlite, .sqlite3 or .db file, or drag it onto the page.
- Pick a table or view on the left to see its rows; search and sort the grid.
- Open Structure to see columns, keys, indexes and the CREATE statement.
- Use the SQL tab to run queries, then export results as CSV or JSON.
Tips for SQLite files
- If the app is still running, copy its database first: open files can be locked or incomplete.
- A file ending in -wal holds recent changes; open the database after the app has closed so they are merged.
- Use PRAGMA table_info(name) or the Structure tab to see column types; SQLite types are flexible, so check the data too.
- Download database saves your SQL changes as a new file; the original is never modified.
Why use this SQLite viewer
- Browse like a desktop appTables and views with row counts, a fast scrolling data grid with search and sorting, and column types, keys, foreign keys and indexes.
- Full SQLite SQLRun any query the real SQLite engine supports, including joins, window functions, JSON functions and CTEs, with results you can sort and export.
- Export and saveDownload any table or query result as CSV or JSON, and save the edited database as a new .sqlite file.
- Your database stays on your deviceThe file is opened by SQLite compiled to WebAssembly, running in your browser. App data, chat histories and customer records are never uploaded.
Handy SQLite queries
- List every table and view
SELECT name, type FROM sqlite_master WHERE type IN ('table', 'view') ORDER BY name;- Columns of a table
PRAGMA table_info(orders);- Top 10 by a value
SELECT customer, sum(total) AS spent FROM order_totals GROUP BY customer ORDER BY spent DESC LIMIT 10;- Find duplicates
SELECT email, count(*) FROM customers GROUP BY email HAVING count(*) > 1;- Check integrity
PRAGMA integrity_check;
Common uses
- App data. Inspect the database of a mobile or desktop app you are building or debugging.
- Browser and chat history. Open History, Places or message databases privately.
- Data hand-offs. Turn tables into CSV for spreadsheets or JSON for scripts.
- Learning SQL. Practise queries on a real database without installing anything.
Related tools: the SQL formatter, CSV viewer, Parquet viewer and JSON viewer.
Example: the sample shop database
The sample has customers, products and orders tables, an index and an order_totals view. Run SELECT customer, sum(total) FROM order_totals GROUP BY customer ORDER BY 2 DESC to rank customers by spend.
What to expect from the result
The database is loaded into memory, so very large files are limited by your browser. Encrypted (SQLCipher) databases are not supported. The grid shows the first 200,000 rows of a table; use SQL to reach the rest.
SQLite Viewer questions
How do I open an SQLite file online?
Choose Open File and select the .sqlite or .db file. Its tables appear on the left; click one to browse its rows.
Which files can I open?
Any SQLite 3 database, usually .sqlite, .sqlite3, .db or .db3, including Android and iOS app databases, browser history files, GeoPackage (.gpkg) and MBTiles. Encrypted SQLCipher databases cannot be opened.
Can I edit the database?
Yes, with SQL: run INSERT, UPDATE, DELETE or CREATE statements in the SQL tab, then choose Download database to save a copy with your changes.
How big a database can I open?
The whole file is loaded into memory, so databases of a few hundred megabytes work on most computers. Very large databases are better queried with the sqlite3 command-line tool.
Is my database uploaded?
No. The database is opened by SQLite running as WebAssembly in your browser. Nothing is sent to a server, and changes stay in the tab until you download them.