SQL to JSON

Paste INSERT INTO … VALUES statements and get a JSON array you can use as test data, fixtures or API mocks.

Output

Free · No sign-up · Your files are processed on your device and never uploaded

How to use SQL to JSON

  1. Paste or type…
    1

    Paste or type

    Put your content in the box - or try the example.

  2. Result appears instantly
    2

    Watch the result

    The result updates as you type - choose options above if needed.

  3. TXTCopy / Download
    3

    Copy or download

    Copy the result or save it as a file. What you typed never leaves your device.

Features

  • One object per row, keys from the column list.
  • Numbers stay numbers; NULL becomes null.
  • Works with MySQL, PostgreSQL and SQLite syntax.

Free and private

Everything runs in your browser. Nothing you paste is uploaded, logged or stored.

Questions

Can I get CSV instead?

Yes - switch Output to CSV above.

Is it free?

Yes - free and unlimited, with no sign-up and no watermark.

More developer tools

All tools →