Skip to content
PPureDevKit

Tools/JSON → INSERT

JSON → INSERT

Turn JSON arrays or CSV into INSERT or PostgreSQL COPY. Nothing is uploaded.

Loading tool…

How to use JSON → INSERT

  1. 1. Paste JSON or CSV. Arrays of objects work best.
  2. 2. Name the table. Quoted as an identifier.
  3. 3. Choose INSERT or COPY. COPY uses tab-separated stdin style.
  4. 4. Format next. SQL Formatter if you want pretty INSERT.

About this tool

Seed data often starts as a spreadsheet or an API dump. Emitting INSERT locally means production credentials never sit next to a converter.

NULL

Empty CSV cells become NULL. JSON null too.

COPY

Meant for psql. Tabs and newlines in values are escaped.

Code examples

JSON

[{ "id": 1, "email": "[email protected]" }]

Frequently asked questions

Related tools

CSV ↔ JSON

Parse CSV to JSON objects and emit INSERT statements.

SQL Formatter

Pretty-print SQL for PostgreSQL, MySQL, SQLite, MariaDB, and T-SQL.

Fake data

Generate fictional people for fixtures. Obviously fake emails.

All tools