Browser 108

no file limit

Inspector developer/database-viewer

SQLite Database Viewer & Editor

Overview

This SQLite viewer and editor opens a database file straight in your browser and shows its tables in a fast, spreadsheet-style grid. Drop in one file or a whole folder, switch between databases from the sidebar, and sort, filter or search any table, including ones with millions of rows. Values are shown exactly as stored: large integers keep every digit, REAL numbers keep their decimal point, and NULL, empty text and zero are never confused. Edit a cell, add or delete a row, and undo or redo it, or use the SQL tab for anything the grid does not cover, with completion for your own table and column names. Constraint errors appear in place and the change is rolled back, and risky statements ask for confirmation first. The engine is SQLite itself, compiled to WebAssembly and running in a background worker, so your database is never uploaded. Download the edited result as a new file, or keep a database on this device so it is there after a reload.

Inspect an App's DatabaseDevelopers open the SQLite file from a mobile app, desktop app or test run to see what was actually stored, without installing a database browser or sending the file anywhere.
Debug a Fixture or Dev DatabaseCheck a migration, a seed script or a test fixture: look at the schema, run a query with your own table names completed for you, and compare what is in the tables with what you expected.
Make a Quick FixCorrect a bad value, remove a duplicate row or fill in a missing field, undo it if it was wrong, and download the fixed copy. The original file stays exactly as it was.
Explore Data Exports and BackupsMany programs keep their data in SQLite. Open a copy of an export or backup to search it, sort it and read it, with a privacy guarantee that nothing leaves your machine.
Learn and Practice SQLStudents and newcomers try queries on the built-in sample or a database of their own, see the results as a table, and read the schema and CREATE statements alongside.

Key features

Open .sqlite, .sqlite3, .db and .db3 files, or a whole folder of them, and switch between databases without re-parsing
A spreadsheet-style grid that stays smooth on tables with millions of rows
Sort by any column, filter by value, and search across every column at once, with live row counts
Edit cells, add, duplicate and delete rows, with undo and redo
Constraint errors (CHECK, NOT NULL, UNIQUE, foreign key) are shown in place and the change is rolled back
Exact values: integers beyond 2^53 keep every digit, REAL numbers keep their .0, and NULL, empty text and 0 look different
A SQL tab with a syntax-highlighted editor and table and column completion
DROP, and DELETE or UPDATE without a WHERE clause, ask for confirmation with the number of rows affected
A schema view with the CREATE statements, columns, indexes, views and triggers
A side panel for long text, JSON and BLOB values, with BLOB replace-from-file and download
Download an edited copy, or keep a database on this device so it is still there after a reload
Foreign key enforcement is on by default and can be switched off
Light and dark mode, and keyboard shortcuts for the grid, undo, open and download

Set

Document Tools 12

Neighbours

01 Invoice Builder 02 CSV to JSON Converter 03 CSV to XLSX Converter 04 JSON to CSV Converter 05 JSON to XLSX Converter 06 Markdown Editor & Live Preview

Specification

Command: developer.database_viewer
Set: Document
Input: text
Output: —
Max file: no limit
Batch: single file

Runtime

Engine: SheetJS · Intl.Segmenter
Threads: single
Isolated: —
WebGPU: —
Memory: —

Transport 0 B

The file is opened, worked on and written back inside this tab. No upload step exists in this tool — there is nowhere for the bytes to go.

Keys

Search: ⌘K
Panels: ⌘1 · ⌘2
Full width: F
All keys: ⌘/

How it works

Open a database

Drop one or more SQLite files or a whole folder onto the page, or use Open. Every database appears in the sidebar and is read only when you first click it. A sample database is there if you just want to look around.

Browse, sort and search

Pick a table or view to see it in the grid. Click a column header to sort, add filter chips, or search every column at once. The row range and the total update as you go.

Edit or query

Double-click a cell or press Enter to edit it, add or delete rows, and undo or redo any step. For anything else, open the SQL tab; risky statements ask first and tell you how many rows they would touch.

Download or keep

Download the edited database as a new file. Your original is never touched. You can also keep a database on this device, still without any upload, so it is waiting after a reload.

Frequently asked

Is my database private?

Completely. The SQLite engine runs inside your browser as WebAssembly, in a background worker. Your file is read locally and is never uploaded, and there is no tracking. Databases you choose to keep are stored only in this browser's own storage on your device.

Which files can I open?

SQLite 3 databases, usually named .sqlite, .sqlite3, .db or .db3. The viewer checks the file's header rather than trusting the extension. If you pass it something else, such as a CSV, a JSON file or a SQL dump, it says what the file looks like instead of failing silently. In a folder, files that are not SQLite databases are skipped and counted.

How big can the database be?

Up to about 1 GB. The whole database is held in your browser's memory, and saving makes extra copies, so the tool needs roughly three times the file size at its peak. It warns you before opening a large file, and the limit you can reach depends on your device.

What about WAL files?

The viewer opens the main database file only. If a -wal or -shm file sits next to it, you get a warning: changes that are still in the -wal file are not included. To get them in, close the program that uses the database or run a checkpoint (PRAGMA wal_checkpoint(TRUNCATE)), then open the main file again.

Are encrypted databases supported?

No. Databases encrypted with SQLCipher or a similar extension cannot be read by standard SQLite. A .db or .sqlite file that looks encrypted gets a message saying so, rather than a confusing error.

Does editing change my original file?

No. The viewer works on a copy held in the browser, and it never writes to the file you opened. When you are done, use Download to save the edited database as a new file. Until then, the tool shows which edits are not yet downloaded.

Can I keep a database on this device?

Yes, per database and only if you turn it on. The copy is stored in your browser's private storage (OPFS, or IndexedDB where that is not available) and is not uploaded anywhere. It reopens after a reload and is labelled as saved on this device, not downloaded. You can remove it again at any time, and clearing the site's data removes it too.

Can I run my own SQL?

Yes. The SQL tab runs any SQLite statement against the open database. Reads run straight away. DROP, ALTER, VACUUM and DELETE or UPDATE with no WHERE clause ask for confirmation first, and show how many rows they would affect where that can be counted. Changes made from the SQL tab clear the undo history.

Keys

Search: ⌘K
Panels: ⌘1 · ⌘2
Full width: F
All keys: ⌘/

Related · Document Tools