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
Results
Run a SQL statement to see its result here.
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…