About SQL to JSON Converter
This tool reads a single SQL INSERT statement with a column list and one or more value rows, and writes the rows as a JSON array of objects. Column names become keys, and numbers, true, false and null are typed correctly.
It is useful for turning a database export or a seed script into JSON for a mock API, a front-end prototype or a test suite without writing a parser yourself.
How to use SQL to JSON Converter
- Paste an INSERT INTO table (columns) VALUES (...) statement.
- Click Run Tool. Each row of values becomes one JSON object.
- Copy the JSON array.
Example
Input
INSERT INTO users (name, age, active) VALUES ('Aman', 25, true), ('Kiran', 28, false);Output
[
{
"name": "Aman",
"age": 25,
"active": true
},
{
"name": "Kiran",
"age": 28,
"active": false
}
]Common uses
- Creating mock API data from existing seed SQL.
- Moving sample rows from MySQL into a JavaScript project.
- Reviewing the content of an INSERT statement in a readable form.
Privacy and safety
This tool runs in your browser. The text you enter is processed on your device and is not sent to NHP Learning.
Frequently asked questions
Which SQL is supported?
A single INSERT INTO table (col1, col2) VALUES (...), (...) statement. SELECT queries, UPDATE statements and statements without a column list are not supported.
Does it connect to my database?
No. It only reads the text you paste in your browser.
How are string values handled?
Quoted values are read as strings with the quotes removed, and values like 25 or true become numbers and booleans. Strings that contain commas or parentheses may be split incorrectly.