How to open a SQLite file online safely

Open your database in three steps

1. Open SQLite Viewer in a modern desktop browser.
2. Drop your database onto the opening card, or click it and select a .db, .sqlite, .sqlite3 or .db3 file.
3. Select a table in the sidebar. The viewer creates a query tab and displays the first page of rows.

What you can inspect

The table list provides quick access to tables and views. You can search long schemas, sort tables by several measurements, inspect column information, control visible columns and pin columns while reviewing wide result sets.

For more detailed work, use the SQL editor. A basic query looks like this:

SELECT *
FROM "customers"
LIMIT 0, 30;

If the file will not open

• Confirm that it is a real SQLite database rather than a SQL text dump.
• Try renaming an uncommon extension to .db so it appears in the file picker.
• Check whether the file is encrypted; an encrypted database requires its matching extension or key and cannot be read as ordinary SQLite.
• For very large files, close memory-heavy browser tabs before trying again.

Save or export your findings

Query results can be exported in common formats. If you edit rows or execute write statements, use Save DB to download the current database. The original local file is not silently overwritten.