JSON σε SQL INSERT

Μετατρέψτε έναν πίνακα JSON από αντικείμενα σε εντολές SQL INSERT. Κάνει σωστό escaping στα strings και διαχειρίζεται null, boolean, αριθμούς, εμφωλευμένα αντικείμενα και multi-row inserts.

Data & DevOps

cosmodev ~/tools/json-to-sql

Πίνακας

Διάλεκτος

JSON (πίνακας από αντικείμενα)

cosmodev ~/docs/json-to-sql.md

(Τεκμηρίωση στα αγγλικά)

What it does

Convert a JSON array of objects into SQL INSERT statements. Columns are the union of keys across all rows; values are escaped per dialect: strings double their single quotes ('O''Brien'), MySQL additionally escapes backslashes, MySQL renders booleans as 1/0, null stays NULL, numbers stay bare, and nested objects/arrays serialize to JSON text. Identifier quoting follows the dialect: double quotes for standard SQL and Postgres, backticks for MySQL. 100% client-side.

How to use it

Paste a JSON array of objects (or a single object) into JSON — a sample is prefilled.
Set the Table name and pick a Dialect: SQL, MySQL, or Postgres.
The INSERTs render live on the right with the row count in the header.
Copy them, or Download as insert.sql.

Examples

Basic insert with escaping — [{"id":1,"name":"O'Brien"}], table users →

INSERT INTO "users" ("id", "name") VALUES
  (1, 'O''Brien');

Mixed value types — [{"id":2,"ok":false,"note":null,"meta":{"a":1}}] →

INSERT INTO "users" ("id", "ok", "note", "meta") VALUES
  (2, FALSE, NULL, '{"a":1}');

MySQL dialect — same input renders INSERT INTO `users` (`id`, `ok`) VALUES (2, 0); (backtick identifiers, boolean as 0/1).

Missing keys across rows — a row without a column the other rows have gets NULL in that position.

Good to know

Private: conversion is local — nothing leaves the browser.
One multi-row INSERT ... VALUES (...), (...) statement per conversion, not one statement per row.
Postgres output also works for SQLite in most cases; pick SQL for the conservative baseline.
Related tools: JSON Formatter, JSON to TypeScript.