Guide
How to open a SQLite database file
Drop the .sqlite or .db file on Anyfile’s database viewer and every table appears in a grid you can sort, filter and edit, with SQL beside it. It runs SQLite itself, built for the browser, so the file opens exactly as SQLite reads it.
Step by step
Open the database viewer
Go to the database viewer and drop the file on the card, or click Choose a file. Files named .sqlite, .sqlite3, .db3 and .db all work, as long as they’re SQLite inside; the SQLite page explains the format.
Browse a table in Data
Tables and views are listed down the side with their row counts. Pick one and it opens in the Data tab: click a column’s heading to sort, use Filter rows to search every column, and scroll through any number of rows.
See how it’s built in Structure
The Structure tab shows each column’s type, whether it’s required, its default and key, plus indexes, foreign keys, triggers and the table’s definition.
Ask questions in SQL
The SQL tab runs any statement SQLite understands, with completion for the database’s own tables and columns. Press Run to see the results of the last statement, up to 1,000 rows.
Export what you need
Open the arrow next to Download and pick a Format: CSV (.csv), for spreadsheets; JSON (.json), for code; or SQL script (.sql), to rebuild it anywhere. Under Tables, choose this table alone or all of them in a ZIP.
Changes you make, from a corrected value to a new column, can be undone, and the downloaded database is SQLite’s own image of the file. An unchanged database downloads byte for byte. Check for damage runs SQLite’s integrity and foreign-key checks; Compact (VACUUM) makes the file smaller.
One catch: a database in WAL mode may have recent changes sitting in a separate file ending in -wal, which can’t come along with one file. Open it once in the app that made it, so they’re merged, then try again.
Nothing is uploaded: your browser reads the file and makes the new one on your device. See how it works, and how to check.
Other ways to do it
DB Browser for SQLite. A free desktop app for Windows, Mac and Linux, with browsing, editing and SQL. The better choice if you work with databases every day.
The sqlite3 tool. Comes with macOS and most Linux systems. In Terminal, sqlite3 app.db opens it; .tables lists the tables and any SQL runs as typed. Fast, but nothing to look at.
The app that made it. Many .db files hold an app’s own data. If the app has an export, it may give cleaner results than reading its tables.
When Anyfile is quicker
Anyfile is quicker for a look inside a database you’ve been sent, on a computer where you can’t install DB Browser, or to turn a table into CSV in a minute. For daily database work, a desktop app with saved queries suits better.
Questions
Why won’t my .db file open?
Not every .db is SQLite: Windows thumbnail caches and encrypted app stores use the same ending. Anyfile says what the file really is when it isn’t SQLite.
Can I edit the database?
Yes. Double-click a value to change it, add or delete rows, and change the structure, with undo. Foreign keys are enforced as the schema asks.
How big a database can it open?
Up to 300 MB. Rows are fetched a page at a time, so large tables still scroll smoothly.
Is the database uploaded?
No. SQLite runs in your browser, on your device, and the file never leaves it.