Skip to content

SQLite Workbench

Open a SQLite database in your browser, run SQL, inspect query plans and table relationships, and practice SQLite commands.

SQLite

SQLite WASM WebAssembly

Ctrl/⌘ + Enter
Starting SQLite…

Results

Run a SQL statement to see its result here.

SQLite terminalBrowser session

Type .help for terminal commands. SQL runs in the current local SQLite database.

Open a local SQLite database and inspect its tables

Choose Import SQL / database and select your .sqlite, .sqlite3, .db or .db3 file. This replaces the current workspace, so download a backup first if you want to keep it. Open Schema to preview a table or switch on read-only mode before running your own SELECT query.

If the database still has changes in a separate WAL file, create a standalone backup or checkpoint it in SQLite first. Open that copy to inspect the latest data. You can also use Explain in the editor to see whether a query scans a table or uses an index.

Comments

Sign in or create an account to join the discussion.

Loading comments…