Skip to content
Changelog
new tooladvanced & local

SQLite Explorer

v1.0

SQLite Explorer opens a SQLite database in your browser so you can browse its schema and run SQL against it. It runs real SQLite, so queries behave the way they would on your own machine. Drop in a .sqlite, .db or .sqlite3 file up to 50 MB, start an empty database, or load a sample.

The schema sidebar lists tables with their row counts, views, and indexes (unique ones are marked). Each table expands to show its columns, types and primary key, and clicking a name previews its first 100 rows. A filter narrows the list on large schemas.

Queries go in a SQL editor with syntax highlighting and run with the Run button or Cmd/Ctrl+Enter. Results appear in a table that shows NULL and blob sizes plainly and stops at 10,000 rows with a note on how to see the rest. Writes report how many rows they changed, and the sidebar counts update. When a query fails you see SQLite's own error message, and a file that isn't a SQLite database gets a plain explanation. Results export as CSV or JSON.

The database lives in memory, so changes are only kept if you download the database as a real SQLite file. Recent queries are kept in a history on this device, and Clear empties it. Share puts only the query in a link, never the data.

The Sample menu has three databases, each opened with a query already run: a small shop with joins and a view, a library catalog, and a week of hourly sensor readings. Close puts the database away.

All changes