1. Home
  2. Spreadsheets & Data
  3. SQLite Viewer

SQLite Viewer

Open SQLite database files, browse tables and run SQL queries.

Runs in your browser · No upload

How to use

  1. Drop or choose a .sqlite, .sqlite3, .db or .db3 file. It is loaded into browser memory; files up to 500 MB open.
  2. Pick a table or view on the left. The Data tab shows 100 rows per page. Choose a sort column and a filter (contains, equals, greater than, less than) and the tool builds and runs the query for you.
  3. On the SQL tab, write your own query and run it with Ctrl+Enter. You can chain several statements with ;; the result of the last statement that returns columns is shown as a table.
  4. The Structure tab lists each column’s name, type, PK and NOT NULL flags, plus the CREATE statements (including indexes and triggers).
  5. Download results as CSV (UTF-8 with BOM, so Excel reads it correctly), JSON or XLSX. If you changed data, use Save changed DB to get a copy.

Tabs and safeguards

Item Behavior
Data tab Sorting, filtering and paging turn into SQL. Filter values, LIMIT and OFFSET are always bound parameters and column and table names are double-quoted, so quotes or SQL inside a value cannot change the statement
SQL tab When splitting on ;, semicolons inside strings, comments and CREATE TRIGGER bodies are ignored
Write statements INSERT, UPDATE, DELETE, ALTER and DROP run, but only against the in-memory copy
Row limit The screen holds the first 10,000 rows. If the script only reads, exports re-run the query and include everything
Time limit A query that runs past 30 seconds is stopped and the file is reopened in its original state. Changes made so far are lost
BLOBs Shown as (BLOB 1.2KB) with a download button per cell. PNG, JPEG, GIF, WebP and BMP get a small preview, but only after the file signature is checked. Formats that can carry scripts, such as SVG, never get a preview

Your original file stays untouched

The tool copies the file into memory and works on that copy only. It never writes to the original, so an accidental DELETE or DROP TABLE leaves the file on disk as it was. Press Save changed DB only when you want the result as a new file such as name_changed.db. The button turns on after you run a write statement.

Where SQLite files come from

  • Android and iOS app backups, and the data folders of desktop apps (Electron apps included), often hold .db or .sqlite files.
  • Chrome’s History file and Firefox’s places.sqlite (history and bookmarks) are SQLite databases. The browser locks them while running, so close it and open a copy.
  • App-specific extensions such as Anki’s collection.anki2 can also be SQLite inside.

A SQLCipher-encrypted database or a file that is not SQLite fails the 16-byte header check (SQLite format 3) and you get a message instead. A file with a valid header but damaged contents is reported as a damaged database.

SQL examples (SQLite syntax)

-- 1. List every table, view and index
SELECT type, name FROM sqlite_schema ORDER BY type, name;

-- 2. Show column info
PRAGMA table_info('users');

-- 3. Top 10 countries by member count
SELECT country, COUNT(*) AS n FROM users GROUP BY country ORDER BY n DESC LIMIT 10;

-- 4. Revenue per month (date functions are date() and strftime())
SELECT date(created_at, 'start of month') AS month, SUM(total) AS revenue
FROM orders GROUP BY month ORDER BY month;

-- 5. Join two tables
SELECT o.id, u.name, o.total FROM orders o JOIN users u ON u.id = o.user_id WHERE o.total > 100;

Opening large databases

The whole file is held in memory and write queries run on top of it, so you need comfortably more memory than the file size. Files of several hundred MB may not open on mobile browsers. On big tables, narrow the query with LIMIT or WHERE rather than SELECT *. SQLite does not enforce column types strictly, so one column can mix numbers and text.

To tidy up SQL alone, use the SQL Formatter. To run SQL on CSV or Excel files, try Query CSV with SQL; for spreadsheet-style cleanup, the Excel & CSV Workbench. Columns that hold JSON are easier to read in the JSON Formatter.

Your file is processed only in your browser and is never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.