How to Open a .db File in Your Browser

Start with a complete SQLite file

SQLite databases commonly use .db, .sqlite, or .sqlite3. Files from other database engines may use the same extensions. SQLite Lab checks the SQLite file header instead of trusting the extension. Encrypted databases need to be decrypted with the appropriate tool first.

Open a browser copy

Go to the workspace and choose Open file. Select your database and choose saved browser storage or a temporary session in the toolbar. Your original file stays unchanged. Click a table in the explorer to preview its rows.

Run a first query

List the database’s tables and views with the query below. Replace the table name in your next SELECT with one from the results.

SELECT name, type
FROM sqlite_schema
WHERE type IN ('table', 'view')
ORDER BY name;

Check databases that use WAL mode

If the source database is still running, recent committed data can live in a separate -wal file. A bare copy of the main .db file may omit that data. Use the source application’s SQLite backup or export function to produce a complete snapshot before opening it here. SQLite Lab does not import WAL sidecar files.

Export what you want to keep

Use Export database to download the current browser copy, including committed edits. Saved browser storage is convenient, but clearing site data or changing domains removes access to that local workspace. Keep an exported backup.