DB File Viewer
Open a .db file to see whether it is an SQLite database and, if so, browse its tables and data.
- 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 a .db file?
The .db extension is used by many programs, but most .db files are SQLite databases: Android and iOS apps, Firefox and Chrome, WhatsApp backups (unencrypted), Plex, Kodi, Anki and many more. This viewer checks the file’s header first: if it is SQLite, it lists the tables and views and lets you browse rows, read the schema and run SQL. If it is a different format, such as Windows Thumbs.db, an encrypted database or Paradox, it tells you instead of failing silently.
How to open a .db file
- 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 DB File 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
- Unknown .db files. Find out what is inside before you delete or share it.
- Phone backups. Read app databases extracted from Android or iOS backups.
- Media servers. Inspect Plex, Kodi or Jellyfin libraries.
- Flashcards and notes. Open Anki and other app databases to export your data.
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.
DB File Viewer questions
What program opens .db files?
Most .db files are SQLite databases, which this viewer opens in your browser. Others belong to specific programs and need those programs.
Why does my .db file not open?
It is probably not SQLite (for example Windows Thumbs.db or a Paradox table) or it is encrypted. The viewer checks the file header and tells you which.
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.