SQLite File Explorer
Open a SQLite database on your device. Browse tables, inspect their links and download query results without uploading the file.
How can I browse a SQLite file without uploading it?
Open an unencrypted SQLite 3 file in this local explorer. Inspect tables, views, column definitions, foreign keys and indexes. Browse rows with sorting and text filtering, or run one read-only SQL query with optional named parameters. The file stays on your device. Download CSV or typed JSON results and keep a query notebook to reopen later.
A closer look, on your device
Open the data. Find the answer.
No database open
Open a database or try the fictional library example.
Files stay on this device. Use a consistent database copy with completed transactions; separate WAL/journal files, encrypted databases and extensions are not supported. Closing this page clears the session. Download your queries before leaving.
Inside the database
Tables, views and relationships will appear here when you open a database.
A question for your data
One SELECT, WITH or EXPLAIN query. ⌘/Ctrl + Enter runs it. Database-changing commands are disabled.
Named parameters
For WHERE city = :city, use {":city":"Toronto"}. Values may be text, a finite number or null. Quote integers outside JavaScript’s safe range.
Saved queries (0/30)
Three simple steps
How to use SQLite File Explorer
Open a local SQLite file or load the fictional library database.
Inspect the schema, browse a table or run a read-only query. Named parameters let you reuse a query safely.
Download results as CSV or typed JSON, save the query text or keep a portable query notebook.
Common questions
Good to know
Understand the result.
Keep the original.
Is this tool free, and are my files uploaded?
This tool is free with no account required. The work happens in your browser. Your input and files are not sent to a processing server.
What are the limits and details?
Read-only SQLite SELECT/WITH/EXPLAIN queries in a dedicated browser worker. Unencrypted SQLite 3 files up to 8 MB, 200 tables/views, 100 result columns and 5,000 result rows. Queries stop after 12 seconds; SQLite has a 64 MiB heap cap, separate from browser and file-buffer memory. Result text is limited to eight million characters, 65,536 per cell and 32 KB per blob. WAL/journal sidecars and extensions are not loaded. Query notebooks contain SQL and progress, not database contents; nothing is synced or saved automatically.