JSONL Viewer — DBConvert

Open .jsonl and .ndjson files as a table with types inferred across every line, and the lines that fail to parse named. Nothing leaves your machine.

JSON Lines carries no schema, so the types come from reading the lines: every column gets a name and a type — BIGINT, DOUBLE, VARCHAR — before you write a query.

The lines that do not parse are named

A bad line in the middle of a large file is the reason this exists. The file still opens, the valid lines still load, and the broken ones are listed by line number with the parser's own message and the offending text.

A line holding an array rather than an object is not an error — JSON Lines allows any JSON value — and it loads with the rest.

Several files at once

Open more than one .jsonl file and each becomes a named view:

SELECT * FROM orders JOIN customers USING (customer_id)

Same format only. Joining a Parquet file to a JSONL one is a different job, and that one is DBConvert Streams.

What it does not do

It is read-only — SELECT and WITH … SELECT, nothing that writes — and it needs a file that already exists.

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 server, no account, and no network call.

The other two

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

• SQLite Viewer — VS Code · Open VSX · Chrome
• Parquet Viewer — VS Code · Open VSX

Built by DBConvert. The same viewer runs in a browser tab at streams.dbconvert.com/jsonl-viewer if you would rather not install anything.