Database Tools
Online SQLite Viewer & Exporter is a free browser workbench for SQLite databases. Open a .sqlite, .sqlite3, .db, SQL, or CSV file, browse every table, run custom SELECT queries, and export the result set to CSV or JSON. The database is read in your browser and is never uploaded to a server, so you can inspect sensitive data without a sign-in or installation. The live app keeps the tool first: enter details, generate a result, then copy, download, or share the output.
Start on the first screen and drop a SQLite database file into the Primary input panel, or choose a file with the file picker. The workbench reads the SQLite header, walks the sqlite_master catalog, and lists every table and column in the schema rail on the left. Select a table to preview its rows instantly. You can also paste a SQL dump or CSV text into the same Primary input field, then press Run query, and the workbench builds a local in-memory database from that script before showing the rows. Nothing is transmitted anywhere: parsing and querying happen in the current browser tab.
The SQL editor sits above the result grid and is pre-filled with a working SELECT statement for the active table. Edit it freely, then press Run query or use the Ctrl/Cmd + Enter shortcut. The engine supports SELECT lists, aliases, WHERE filters, ORDER BY, LIMIT, DISTINCT, GROUP BY with COUNT, SUM, AVG, MIN and MAX, plus simple INNER and LEFT JOINs between tables. Each run reports the row count and execution time, and any syntax error is shown in a clear error banner that keeps your previous result visible so you never lose context.
When a query returns rows, copy them to the clipboard or export them as a CSV or JSON file with one click. The exporter writes the current result set, not the whole database, so you can slice a large table down with WHERE and LIMIT and export only the rows you need. A toast confirms the download and the action emits the standard tool_copy and tool_download events. File names are generated from the active table and the current timestamp, which keeps repeated exports easy to tell apart on disk.
The saved queries panel keeps useful statements in a local workspace so you can return to them later. Each saved item stores a name, the SQL text, and a status such as draft, saved, or reviewed. You can open a saved query back into the editor, update its status, add a short note, or delete it. These operations run through an Axle API adapter boundary: when a backend base URL is configured the adapter talks to the Go service, and otherwise it serves the same operations from a deterministic local store with localStorage persistence.
This tool is built for quick inspection, not for hosting your data. There is no upload endpoint for database files, no account, and no background processing. Databases you open stay inside the page memory, and clearing the tab removes them. Saved queries contain only the SQL text and a label, never the rows you queried. The privacy page explains the limited analytics events the site records, and the contact form lets you report a parsing bug or request a feature without sharing a database.
It is a browser tool that opens SQLite database files, shows their tables and rows, lets you run SQL queries against them, and exports the resulting rows to CSV or JSON. Online SQLite Viewer & Exporter performs all of that locally in your browser.
No. The file is read with the browser File API and parsed in page memory. There is no database upload endpoint, no account, and no server-side storage of your rows.
You can open SQLite database files (.sqlite, .sqlite3, .db), SQL dump scripts containing CREATE TABLE and INSERT statements, and CSV files with a header row. The CSV and SQL imports are converted into an in-memory database so you can query them with SQL immediately.
The workbench supports SELECT projections with aliases, WHERE comparisons, AND/OR, IN, LIKE, IS NULL, ORDER BY, LIMIT, DISTINCT, GROUP BY with COUNT, SUM, AVG, MIN and MAX, plus simple INNER and LEFT JOINs. It is a focused read-only query surface for inspection and export.
Yes. Add a WHERE clause and a LIMIT to your query, run it, then export. The CSV and JSON exporters always write the current result set, so only the filtered rows are downloaded.
Yes. The workbench is responsive and mobile-first. On small screens the schema rail becomes a collapsible panel above the editor, and the result grid scrolls horizontally so wide tables stay readable.