SQLite Browser
Browse and query an SQLite database in your browser, with no DB Browser install and no upload.
- 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.
An SQLite browser that runs in your browser
Desktop SQLite browsers such as DB Browser for SQLite are great, but need installing and are not always allowed on work machines. This online SQLite browser gives you the essentials in a browser tab: a list of tables and views with row counts, a data grid with search and sorting, a structure view with keys and indexes, and a SQL editor powered by the real SQLite engine compiled to WebAssembly. The database never leaves your computer, and you can save any changes as a new .sqlite file.
How to browse an SQLite database online
- 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 browser
- 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 Browser questions
Is this like DB Browser for SQLite?
It covers the everyday tasks: browsing tables, viewing the schema, running SQL and exporting data. Advanced editing tools such as visual table designers are not included.
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.