Free Online SQL (INSERT Statements) to JSON Converter

What the SQL (INSERT Statements) to JSON Converter does

The SQL to JSON Converter reads SQL INSERT statements and returns the inserted rows as a JSON array. The column list of each INSERT becomes the object keys, and every row in the VALUES clause becomes one object.

Numbers stay numbers, quoted strings become JSON strings and NULL becomes null, so the result can go straight into a script, a test fixture or an API request. Several INSERT statements and multi-row VALUES lists are combined into one array.

When to use it

• You have a snippet of a database dump and need the rows as data in JavaScript, Python or a REST call.
• Turning seed or migration files into JSON fixtures for unit tests.
• Reviewing what a script would insert before running it, then exporting the same rows with the JSON to CSV Converter.
• Moving a few rows between two databases that do not share an export format, using JSON as the common middle step.

Worked example

Input

INSERT INTO users (id, name, email) VALUES
  (1, 'Ana', 'ana@example.com'),
  (2, 'Ben', 'ben@example.com');

Output

[
  {
    "id": 1,
    "name": "Ana",
    "email": "ana@example.com"
  },
  {
    "id": 2,
    "name": "Ben",
    "email": "ben@example.com"
  }
]

Common questions about the SQL (INSERT Statements) to JSON Converter