SQLite Viewer — DBConvert

Open .db, .sqlite and .sqlite3 files in the editor: schema, ER diagram, read-only SQL across several databases, integrity check. Nothing leaves your machine.

Pick the file in the Explorer and it opens as a tab: tables and views with their row counts, triggers, a row grid you can sort and page through, how many indexes the file carries, the page size and text encoding it was created with, and PRAGMA integrity_check already run.

A damaged file still opens — it reports what the check found and shows whatever is readable, instead of refusing the file.

Read-only SQL over the whole database

SELECT c.country, count(*) AS orders, round(sum(o.amount), 2) AS total
FROM orders o JOIN customers c USING (customer_id)
GROUP BY 1 ORDER BY 3 DESC

SELECT and WITH … SELECT only. The file you opened is the file you still have.

Every table pages to its last row. Export a result as CSV or JSON: the first 10,000 rows free, the whole result with PRO.

Several databases at once

The editor opens one file per tab. To query several databases together, click Choose files in that tab and select all of them at once: each is attached under a name taken from its filename, so one query reaches tables in all of them. Choosing again replaces the set.

SELECT a.customer_id, a.name, b.name AS name_in_archive
FROM "sales".customers a JOIN "archive".customers b USING (customer_id)

Up to ten databases, all in the same text encoding.

ER diagram

The Diagram tab draws every table and view with the foreign keys the file declares — N at the referencing column, 1 at the key — and a frame per database when several are open.

Select a table and its relations stand out while the rest fades.

Binary values are identified, not printed as hex

Every BLOB shows its size and the kind of thing it holds — JPEG, AVIF, ICO, TIFF, MP4, WebM, MP3, Ogg — and images under 512 KB get a thumbnail in the row itself. An empty blob reads as empty rather than as NULL.

Open a value and it renders as an image, a <video>, an <audio>, text, or a hex dump — with a download in the type that was sniffed.

Where the file goes

Nowhere. The editor reads it from disk and hands it to the panel; the panel parses it with WebAssembly in the editor itself. There is no account and no remote server. The one port the extension opens is the local one AI agents use (below), bound to 127.0.0.1 and closed by a token.

Ask AI about the open file

The file tab has an Ask AI about this file button. It opens the editor's own agent chat with the question already typed — "What is in orders.db? Use the DBConvert viewer tools to look at its tables and data." — and the agent answers from the file, not from a guess.

The agent gets three read-only tools: list the tables of the files open in the viewer, describe a table, and run one SELECT. Each query it runs shows in the viewer, and a result comes back as at most 100 rows with the full row count.

Where each agent gets the tools from:

• VS Code with Copilot Chat — nothing to set up. The tools are part of the chat.
• Cursor — nothing to set up. The extension adds its server to Cursor's MCP list. Cursor asks before each tool call unless you allow it.
• Claude Code and Codex — run Connect agent to open files from the Command Palette once. It adds the server to the agent's config and prints the first question to ask. Quit Codex before you connect it: a running Codex rewrites its config and drops the entry.
• Windsurf, Cline, Roo, Kilo, Gemini CLI, Continue and others — the same command shows the config to paste: a JSON block, or the address and header.

In an editor with no agent chat to open, the button copies the question and offers Connect.

One server serves every open editor window and every installed DBConvert viewer, so an agent sees all the files you have open. Reset MCP token issues a new token; connected agents need Connect again after it.

The viewer never talks to a model itself. What the agent reads — table names, columns, the rows its queries return — goes to whichever model that agent uses.

The other viewers

Same viewer, one per format — install only the one you need, so a SQLite user never downloads the Parquet engine.

• Parquet Viewer — VS Code · Open VSX
• JSONL Viewer — VS Code · Open VSX
• MDB and ACCDB Viewer — VS Code · Open VSX
• PostgreSQL Dump Viewer — VS Code · Open VSX

Built by DBConvert. The same viewer runs in a browser tab at streams.dbconvert.com/sqlite-viewer, and as a Chrome extension.