en

SQLite to JSON

Convert a SQLite database to JSON locally - ideal for APIs, scripts and web apps, no upload.

Running locally on your device ...

Running locally on your device ...

0%

Is my file uploaded?

No. Everything runs in your browser - your file never leaves your device. How this is verifiable

No upload100% local
Your content stays with youno third-party access
Hosted in GermanyGlobal Content Delivery
Independently auditedTLS A+ · HTTP headers A+

If you want to bring a SQLite database’s content into a JavaScript program, an API mock file or a test fixture, JSON is usually the more direct target than CSV - it supports real numbers, nests cleanly and is the language modern web apps think in anyway.

This tool opens the file entirely locally in the browser (sql.js, WebAssembly SQLite) and reads every user table via SQL. If the database holds exactly one table, a plain JSON array of row objects is produced. With several tables you get ONE JSON object mapping each table name to its own row array - so the whole database stays in one file, no ZIP needed.

The file never leaves your device - unlike online converters that upload an entire database to a server. The conversion even works offline after the first load.

Specifications

Specifications
Input formatsSQLITE, DB, DB3, SQLITE3
Output formatJSON
Batch processingNo
ProcessingLocally in your browser (WebAssembly)
File uploadNone

In 3 steps

  1. Drop or pick your SQLite file.
  2. The tool reads each table locally via SQL.
  3. Download the JSON file.

Limitations: A single table yields a flat JSON array; several tables yield a {tableName: [...]} object. BLOB columns are emitted as base64 text. Views, indexes and triggers are not read. Very large databases need memory. Encrypted SQLite files (e.g. SQLCipher) are not supported.

FAQ

Is my database uploaded?

No. It is opened and read entirely locally in the browser.

What does the JSON structure look like with several tables?

An object mapping each table name to its row array, e.g. {"customers":[...], "orders":[...]}.

Are numbers output as numbers?

Yes, INTEGER and REAL columns are written as real JSON numbers, not as text.

How are binary values (BLOB) handled?

As base64 text, since JSON itself has no binary type.

Can I get an Excel workbook instead?

Yes, with the "SQLite to XLSX" tool.

Related tools

SQLite to CSV · SQLite to Excel · DBF to CSV · XLSX to JSON · JSON to CSV