JSON ↔ SQL Converter

How to convert JSON to SQL online

jsonsql.dev converts JSON arrays to SQL INSERT statements instantly in your browser — supporting MySQL, PostgreSQL, and SQLite syntax with automatic type detection. No data is sent to any server.

How to convert SQL to JSON

jsonsql.dev parses SQL CREATE TABLE and INSERT statements directly in your browser, converting them to structured JSON data without needing a database connection.

Example: JSON to SQL conversion

Input JSON:

[
  { "id": 1, "name": "Alice", "email": "alice@example.com", "active": true },
  { "id": 2, "name": "Bob", "email": "bob@example.com", "active": false },
  { "id": 3, "name": "Charlie", "email": null, "active": true }
]

Output SQL (PostgreSQL):

CREATE TABLE IF NOT EXISTS "data" (
  "id" INTEGER,
  "name" TEXT,
  "email" TEXT,
  "active" BOOLEAN
);

INSERT INTO "data" ("id", "name", "email", "active") VALUES
  (1, 'Alice', 'alice@example.com', TRUE),
  (2, 'Bob', 'bob@example.com', FALSE),
  (3, 'Charlie', NULL, TRUE);

Example SQL to JSON (Data mode):

-- Input SQL:
CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  email VARCHAR(255),
  age INT DEFAULT 0,
  active BOOLEAN DEFAULT true
);

INSERT INTO users (id, name, email, age, active) VALUES
(1, 'Alice', 'alice@example.com', 30, true),
(2, 'Bob', 'bob@example.com', 25, false),
(3, 'Charlie', NULL, 35, true);

-- Output JSON:
[
  { "id": 1, "name": "Alice", "email": "alice@example.com", "age": 30, "active": true },
  { "id": 2, "name": "Bob", "email": "bob@example.com", "age": 25, "active": false },
  { "id": 3, "name": "Charlie", "email": null, "age": 35, "active": true }
]

JSON to SQL type mapping

jsonsql.dev automatically detects the JSON value type and maps it to the appropriate SQL column type for each dialect.

SQL type to JSON type mapping

When converting SQL to JSON, each SQL data type maps to its closest JSON equivalent.

SQL dialect differences

Each SQL dialect has its own syntax quirks. Here is how jsonsql.dev handles the differences between MySQL, PostgreSQL, and SQLite.

Common use cases

• API data import — you fetched data from a REST API as JSON and need to import it into your relational database. Convert the JSON response to INSERT statements and run them directly.
• Data migration — migrating from a NoSQL database (MongoDB, Firebase) to a relational database (MySQL, PostgreSQL), or vice versa. Export as JSON, convert to SQL, or extract SQL to JSON.
• Test fixtures and seed data — generate SQL INSERT statements from JSON test data files to seed your development or staging database, or convert SQL dumps to JSON fixtures for unit tests.
• Quick prototyping — define your data structure in JSON (which is easy to write), then generate the CREATE TABLE statement to bootstrap your database schema.
• Database export to JSON — convert database dumps to JSON for use in APIs, documentation, or data analysis without running a database.
• API mocking — generate JSON fixtures from SQL schema for frontend development and testing without a backend.
• Spreadsheet to database — export spreadsheet data as JSON (via CSV-to-JSON), then convert to SQL for database import.
• Log analysis — convert JSON log entries to SQL for analysis using familiar SQL queries instead of JSON-specific tools.

Code examples

Python: JSON to SQL

import json

with open('data.json') as f:
    rows = json.load(f)

cols = list(rows[0].keys())
table = 'data'

print(f"CREATE TABLE {table} ({', '.join(f'{c} TEXT' for c in cols)});")
for row in rows:
    vals = ', '.join(
        'NULL' if row.get(c) is None else f"'{row[c]}'"
        for c in cols
    )
    print(f"INSERT INTO {table} ({', '.join(cols)}) VALUES ({vals});")

Python: SQL to JSON

import json, sqlite3

conn = sqlite3.connect(':memory:')
conn.execute('CREATE TABLE users (id INT, name TEXT, email TEXT)')
conn.execute("INSERT INTO users VALUES (1, 'Alice', 'alice@example.com')")
conn.execute("INSERT INTO users VALUES (2, 'Bob', 'bob@example.com')")

cursor = conn.execute('SELECT * FROM users')
cols = [d[0] for d in cursor.description]
rows = [dict(zip(cols, row)) for row in cursor.fetchall()]
print(json.dumps(rows, indent=2))

Node.js: JSON to SQL

const fs = require('fs');
const rows = JSON.parse(fs.readFileSync('data.json', 'utf8'));
const cols = Object.keys(rows[0]);
const table = 'data';

console.log(`CREATE TABLE ${table} (${cols.map(c => `${c} TEXT`).join(', ')});`);
rows.forEach(row => {
  const vals = cols.map(c =>
    row[c] === null ? 'NULL' : `'${String(row[c]).replace(/'/g, "''")}'`
  ).join(', ');
  console.log(`INSERT INTO ${table} (${cols.join(', ')}) VALUES (${vals});`);
});

CLI with jq + sqlite3

# Generate INSERT statements from JSON array
cat data.json | jq -r '.[] | "INSERT INTO data VALUES (\(.id), '"'"'\(.name)'"'"', '"'"'\(.email)'"'"');"'

# Convert SQLite database to JSON
sqlite3 -json database.db "SELECT * FROM users" | jq '.'

Comparison: JSON ↔ SQL tools

Related tools

Frequently asked questions