DT Dev Tools

SQLite Viewer

Open SQLite .sqlite and .db files in your browser. Browse tables, run SQL queries and export results to CSV — nothing is uploaded.

🔒 Runs entirely in your browser — nothing is uploaded

Drop a SQLite database here (.sqlite, .sqlite3, .db, .db3) or click to browse

Advertisement

View SQLite databases without installing anything

SQLite is the most widely deployed database engine in the world. Mobile apps, desktop programs, browsers, embedded devices and many web frameworks store their data in a single SQLite file. When you need to look inside one — to debug an app, inspect an export or check a migration — you usually have to install a desktop client or the command-line shell. This viewer lets you open the file directly in a browser tab instead.

It uses sql.js, the official SQLite engine compiled to WebAssembly. After you drop a file, the tool verifies the "SQLite format 3" header, loads the database into memory and lists every table and view with its row count. Click a table to browse its rows page by page, choosing 25 to 250 rows per page. Values are displayed as plain text, NULL is shown explicitly, and binary BLOB columns are summarized by their size rather than dumped as unreadable bytes.

Running queries and exporting data

The SQL box accepts any statement SQLite understands: joins, aggregates, window functions, common table expressions, PRAGMA commands such as PRAGMA table_info(users), and even INSERT, UPDATE or CREATE statements. When a query returns rows, the result appears in a scrollable table along with the row count and execution time. Large results show the first 1,000 rows on screen, while CSV export always includes every row. The CSV file follows RFC 4180 quoting, so commas, quotes and line breaks inside values open correctly in Excel, LibreOffice or Google Sheets.

Private by design

Database files often contain personal data, credentials or business records, which is exactly why they should not be uploaded to an online converter. Here, the file is read by your browser and queried locally; there is no server component at all. Any changes you make with SQL affect only the in-memory copy and disappear when you close the page, so the original file is never altered. For very large databases, a desktop tool or the sqlite3 command-line shell is still the better choice, but for quick inspection this viewer is fast and safe.

How to use

  1. Open a databaseDrop a .sqlite or .db file onto the drop zone or click to choose one.
  2. Browse tablesClick a table to page through its rows and see the row count.
  3. Run SQLWrite any SQLite query and press Run SQL or Ctrl+Enter.
  4. ExportDownload the current table or query result as a CSV file.

Frequently asked questions

Is my database uploaded to a server?
No. The file is read into memory by your browser and opened with sql.js, a WebAssembly build of SQLite. Nothing is sent over the network.
Can I modify the database?
You can run INSERT, UPDATE, DELETE and schema statements, but the changes only exist in memory for the current page. The original file on your disk is never modified.
Which file types are supported?
Any SQLite 3 database file, whatever its extension — commonly .sqlite, .sqlite3, .db or .db3. The tool checks the SQLite header before opening the file.
How large can the database be?
The whole file is loaded into browser memory, so databases of a few hundred megabytes work on most computers. Very large files may be slow or exceed the browser's memory limit.
What does the CSV export contain?
When browsing a table, the export contains every row of that table. After running a query, it contains all rows of the last result set, even if only the first 1,000 are shown on screen.
Advertisement