Dump
Open a copy of an app database and see which tables it contains.
File
Drop a database file here or click to choose one
.db, .sqlite, .sqlite3, .db3
SQLite viewer
Open a .db or .sqlite file online. The file is read locally in the browser.
The database is parsed in a background thread by a WebAssembly build of SQLite. The page does not crash when opening large files.
About the tool
The tool is intended for browsing a SQLite file without installing a client.
Schema
Read the CREATE statements of the selected table or view.
Rows
Page through the data before an import or a debugging session.
Quick reference
SQLite is an embedded relational database. The whole database lives in one file, and no separate server is required.
- File
- Extensions are .db, .sqlite, .sqlite3, and .db3. One file holds tables, indexes, views, and triggers.
- SQL
- A subset of SQL-92 is supported. Object definitions are stored in the sqlite_master table.
- Types
- Five storage classes: NULL, INTEGER, REAL, TEXT, and BLOB. A declared column type is an affinity, not a rigid constraint.