SQLite Viewer: Open and Browse .db Files
Drop a .sqlite or .db file to explore it like a lightweight DB Browser. Browse every table, inspect its schema, page through rows and run read-only SELECT queries. Everything runs locally in your browser, so the database is never uploaded.
How to open a SQLite file
- Drag your .sqlite or .db file onto the drop zone, or click browse to pick it.
- Choose a table from the sidebar to see its columns and the first 100 rows.
- Use the SQL box to run your own SELECT query, then open another file when you are done.
Examples
Browse a table
Select the users table
Shows its columns (with PK and NOT NULL flags) and up to 100 rows
Run a query
SELECT name, email FROM users WHERE active = 1
A results table with the matching rows
Frequently asked questions
Is my database uploaded anywhere?
No. The SQLite engine runs entirely in your browser using WebAssembly, so your file is read locally and never sent to a server.
Which file types can I open?
Any SQLite database file, whatever its extension. Common ones are .sqlite, .sqlite3, .db and .db3.
Can I edit the data or only view it?
This tool is for read-only browsing. You can run SELECT and PRAGMA queries to explore the data, but changes are not saved back to the file.
Why do I only see the first 100 rows of a table?
Large tables are capped at 100 rows for speed. The header shows the full row count, and you can write your own query with a different LIMIT to see more.
How big a file can it handle?
The whole database is loaded into memory, so small and medium files open instantly. Very large files may be slow or hit your browser's memory limit.
Related tools
SQL Playground
Write and run SQL in your browser against an in-memory SQLite database. Query a sample dataset or load your own .sqlite file. Nothing is uploaded.
JSON to SQL
Convert JSON to SQL INSERT statements online. Paste an array of objects, set a table name, and get ready-to-run INSERTs. Runs in your browser.
CSV to JSON
Convert CSV to JSON online. Turn spreadsheet rows into clean JSON objects or arrays, with smart number and boolean typing. Free tier plus API.
.env to JSON
Convert a .env file to JSON, or JSON back to .env. Parses KEY=value lines, comments, quotes and export. Runs entirely in your browser.
Aspect Ratio Calculator
Calculate aspect ratios fast. Enter a ratio like 16:9 and one dimension to get the other, or enter width and height to simplify the ratio.
Base58 Encoder
Encode and decode Base58 online with the Bitcoin alphabet. Convert text to Base58 or back, UTF-8 safe, no confusing 0 O I l. Runs in your browser.