Converters

SQL to JSON Converter

Paste a SQL INSERT statement below to convert its values into a JSON array.

What does this tool do?

Paste a SQL INSERT statement below to convert its values into a JSON array. Everything runs locally using JavaScript in your browser — nothing you paste or upload is ever sent to a server.

How to use this tool

  1. Paste your sql input into the left-hand box.
  2. Click Convert to JSON.
  3. Copy the json output from the right-hand box.

Frequently asked questions

What SQL syntax is supported?

Standard INSERT INTO table (col1, col2) VALUES (...), (...); statements, including multiple value tuples in a single statement.

Are other SQL statements like SELECT or CREATE TABLE supported?

No — this tool is scoped specifically to parsing INSERT statements, since general SQL parsing (joins, subqueries, expressions) is far more complex than a browser-based tool can reliably handle.

How are SQL types like NULL and booleans converted?

NULL becomes JSON null, TRUE/FALSE become JSON booleans, quoted strings become JSON strings, and unquoted numbers become JSON numbers.