Tools

SQL ↔ JSON

Convert between SQL CREATE/INSERT statements and JSON

Input

SQL
0 chars

Output

JSON
Click "Convert" to see the result

Supported Features

SQL → JSON

  • CREATE TABLE with column types, constraints
  • INSERT INTO with single/multiple value tuples
  • Quoted identifiers (backticks, double quotes, brackets)
  • NULL, boolean, numeric, and string values
  • Comments (single-line and multi-line)
  • PRIMARY KEY, NOT NULL, UNIQUE, DEFAULT

JSON → SQL

  • Array of objects → CREATE TABLE + INSERTs
  • Nested { schema, data } structure
  • Multi-table objects (keyed by table name)
  • Auto type inference (INT, FLOAT, BOOLEAN, VARCHAR, DATE, TIMESTAMP)
  • 4 SQL dialects: PostgreSQL, MySQL, SQLite, SQL Server
  • Proper identifier quoting per dialect

More tools like SQL ↔ JSON

View all

CSV Editor

Data

Spreadsheet-style CSV editor with formulas and virtual scrolling

Data Format Converter

Converters

Convert between JSON, YAML, XML, CSV, and TOML

Markdown ↔ HTML

Converters

Convert between Markdown and HTML bidirectionally

JSON Linter

Linters

Validate, format, and minify JSON with tree view