Nirmion
도움말 도구 찾기

Developer & Data

SQL to JSON

Convert literal INSERT INTO ... VALUES rows into JSON without running SQL.

  1. 01Runs in this browser
  2. 02Limits are explicit
  3. 03Copy or download output

Step 1

Set up the source

Paste one INSERT statement with an explicit column list and literal VALUES tuples. Expressions and SELECT-based inserts are rejected.

Confirming the published workspace...

No black box

How this tool handles the input

A bounded parser separates columns, tuples, quoted strings, nulls, booleans, and numbers. Each tuple becomes one JSON object.

Before you start

What you need

One INSERT INTO table (columns) VALUES (...) statement containing literal values.

What you get

What the page gives back

A JSON object with the table name, row count, and converted rows.

Keep in mind

Use the result responsibly

This is not a general SQL parser. Functions, binary literals, casts, DEFAULT, INSERT ... SELECT, and database-specific expressions are not interpreted.

Practical uses

Where this tool earns its place

  1. Turn seed INSERT rows into test fixtures.
  2. Inspect a small data patch before migration.
  3. Move literal sample records into an API mock.

Verified data boundary

Source text stays on this page.

The published contract marks these tools as client-only processing. Nirmion uses the API only to confirm that this workspace is enabled in MySQL; source values and results are not sent to Flask.

Keep working

SQL FormatterJSON FormatterCSV to JSON