What SQL statements does this tool support?

Only CREATE TABLE and INSERT INTO. SELECT, JOIN, UPDATE, DELETE, stored procedures, triggers, and views are not supported.

Does my SQL data get sent to a server?

No. All parsing happens in your browser using a custom JavaScript tokenizer.

How are data types converted to JSON?

NULL to null, quoted strings to string, numbers to number, TRUE/FALSE to boolean. Big integers above 2^53-1 are output as strings.

What if my SQL has multiple tables?

Each table becomes a key in the output JSON object.

What happens if part of my SQL can't be parsed?

You'll see a warning with the reason. Nothing is silently skipped.

🗄️ SQL to JSON Converter

Convert SQL dump files (CREATE TABLE + INSERT INTO) to structured JSON. Multi-dialect, big-int safe, zero-server processing.

Supported: CREATE TABLE, INSERT INTO (single/multi-row).
Not supported: SELECT, JOIN, stored procedures, triggers, views, ALTER/UPDATE/DELETE — flagged with warnings.

SQL Input

Escape Mode

📌 Embed This Tool

Add the SQL to JSON Converter to your website for free.

<iframe src="https://toolstand.io/tools/sql-to-json/embed.html" width="100%" height="500" frameborder="0" style="border:1px solid #e2e8f0;border-radius:8px" loading="lazy" title="SQL to JSON Converter" allow="clipboard-write" sandbox="allow-scripts allow-same-origin allow-popups allow-forms"></iframe>

📋 When to Use

Ideal for migrating SQL dump data to JSON for API integration, NoSQL databases, or web app configuration. Extracts schema and row data into clean, structured JSON — all in your browser.

⚙️ How It Works

Custom state-machine tokenizer parses CREATE TABLE and INSERT INTO character by character. Auto-detects SQL dialect and applies correct escape mode. Comments stripped, identifiers normalized, types inferred. Big integers above 2⁵³-1 preserved as strings. No server communication.

How to Use

Paste CREATE TABLE and INSERT INTO statements. Works with MySQL, PostgreSQL, SQLite, and MSSQL.
Choose escape mode: Auto (recommended), Standard, or MySQL.
Click Convert to JSON to extract structured data.
Check warnings — unsupported statements are flagged.
Copy or Download the JSON output.

Frequently Asked Questions

What SQL statements are supported?

Only CREATE TABLE and INSERT INTO. SELECT, JOIN, stored procedures, triggers, and views are not supported. Designed for SQL dump files, not arbitrary queries.

Does my data get sent to a server?

No. All parsing happens in your browser. Your SQL never leaves your device.

How are data types converted?

NULL → null, quoted strings → string, numbers → number, TRUE/FALSE → boolean. Dates stay as strings. Big integers above 9,007,199,254,740,991 become strings.

What about multiple tables?

Each table is a key: {"users": [...], "orders": [...]}. Multiple INSERT blocks for the same table merge in order.

Which SQL dialects are supported?

MySQL (backtick, backslash), PostgreSQL (double-quote), SQLite (double-quote, brackets), MSSQL (brackets). Auto-detection with manual override.

What if part of my SQL can't be parsed?

Warnings with reasons appear. Nothing is silently skipped — unsupported statements are flagged.

Which escape mode should I choose?

Auto (default) detects: backticks → MySQL mode (backslash escapes), otherwise Standard mode ('' only). Override via dropdown if wrong.

Can I convert JSON back to SQL?

No, one-directional. For formatting SQL, use our SQL Formatter tool.