- Paste SQL INSERT statements.
- Click Convert to JSON.
- Copy the JSON output.
SQL to JSON
Convert SQL INSERT statements into JSON.
Supports basic INSERT INTO table (cols) VALUES (...), (...);
How to Use This Tool
Learn More About SQL to JSON
Why convert SQL to JSON?
JSON is easier to inspect, share, and use in APIs than raw SQL inserts.
About SQL to JSON
SQL INSERT statements are often used to seed data. Converting them to JSON makes it easier to inspect and reuse datasets across systems.
Turn INSERT statements into JSON arrays.
- Runs in browser
- Yes
- Input
- INSERT SQL
- Output
- JSON array
Examples
Convert INSERTs
Turn SQL into JSON.
Input
INSERT INTO users (id, name) VALUES (1, 'Ava');
Output
[{"id":1,"name":"Ava"}]Features
INSERT support
Handles basic INSERT INTO ... VALUES statements.
Readable output
Returns an array of JSON objects.
Client-side
Runs in the browser.
Use Cases
- Inspect seed data quickly.
- Convert SQL fixtures to JSON.
- Share SQL data with non-SQL tools.
Frequently Asked Questions
Related Tools
Use JSON to SQL Inserts to reverse the process.