SQLite Studio & Viewer
Explore, query, and convert SQLite databases in your browser. Runs entirely client-side using WebAssembly database execution.
Drag your SQLite database (.db, .sqlite, .sqlite3) here or
Open, query, and export SQLite databases client-side. No server upload. 100% secure.
How to use SQLite Studio & Viewer
- Drag and drop your SQLite database file.
- Select a table from the sidebar to inspect its records, or write custom queries in the editor.
- Click 'Execute' to run queries in real-time.
- Click export formats (CSV, Excel, SQL, Access XML) to save query tables.
What is SQLite Studio & Viewer?
A local-first SQL database workstation. Using sql.js WebAssembly compiling, this tool reads .db and .sqlite database binaries in-browser. You can select tables to browse rows, write custom SQL queries (with filters, joins, or aggregations), and export output rows directly to CSV, Excel sheets, SQL inserts, or Access XML import catalogs.
FAQ
- Can I run destructive queries like DELETE or DROP?
- Yes. However, since the database is loaded in temporary WASM memory, any modifications only affect your session and will not alter the original source file unless you download a modified file version.
- Does this tool send my SQLite database to the cloud?
- No, it uses WebAssembly to run SQLite entirely in your browser, ensuring your data stays private.
- Can I import data from CSV files into the database?
- Yes, you can import CSV files directly, with all operations performed locally without any data upload.
Related tools
People also use
- CSV to SQL📊 CSV Tools
Convert a CSV to SQL INSERT statements for MySQL, PostgreSQL, SQLite or MS SQL. Optional CREATE TABLE, multi-value INSERT mode.
- CSV Studio📊 CSV Tools
CSV Studio — Drop a CSV file (or load 100-row demo data) and explore it like a power tool: filter rows, sort by multiple columns, bulk-update cells, vis...
- CSV to XLSX💼 Office Tools
CSV to XLSX — Wrap a CSV file (or pasted CSV) into a single-sheet Excel .xlsx file. Pick the delimiter, sheet name, and output filename.