Asteria

SQLITE to JSON

Turn SQLite database files into JSON data files on your own Mac, Windows or Linux computer. Asteria is free, works offline, and never uploads your files.

How to do it

  1. Download Asteria and open it. It's free and needs no account.
  2. Drop your SQLITE files onto its window, or press ⌘O (Ctrl O on Windows) to choose them. Drop as many as you like.
  3. Type sqlite to jsonand press Enter. Every table as a list of row objects.
  4. Press ⌘↵ (Ctrl ↵ on Windows) to save. The JSON files appear next to the originals, which stay exactly as they were.

What it needs

Nothing. This conversion is built into Asteria, so it works the moment the app is open, even offline.

How it was tested

A real SQLITE file was converted on macOS on Apple silicon and Linux, and the JSON that came out was opened and checked with Python parser to make sure it is what it says it is.

More to JSON