What This Converter Accepts
This page is focused on one common workflow: converting simple SQL INSERT INTO statements into JSON. The input should include a table name, a parenthesized column list, a VALUES clause, and a semicolon.
INSERT INTO users (id, name, active) VALUES
(1, 'Alice', true),
(2, 'Bob', false);
How Values Are Converted
| SQL value | JSON value | Example |
|---|
NULL | null | null |
true / false | boolean | true |
| Bare numbers | number | 42 |
| Single- or double-quoted text | string | "Alice" |
Best Uses
- API mocks: convert sample rows into JSON for mock endpoints.
- Test fixtures: turn seed data into a JSON file for Jest, Vitest, Playwright, or pytest.
- Frontend handoff: share realistic records without asking someone to connect to a database.
- Documentation: convert small SQL examples into JSON examples for API docs.
Limits to Know
This is not a SQL engine and it does not parse every database dialect. It does not convert CREATE TABLE schemas, terminal-style SELECT result tables, stored procedures, full dumps, transactions, comments, or dialect-specific clauses such as RETURNING or ON CONFLICT. Complex strings, nested parentheses, functions, binary values, and unusual escaping may need cleanup before conversion. For production migrations or very large exports, use a script or database export library that understands your database format.
Privacy Note
The conversion logic runs in your browser after the page loads; the tool does not need to send your SQL to a conversion API. Still, avoid pasting passwords, private customer data, or regulated records into any web tool unless your own security policy allows it.
