Is my JSON data uploaded to a server?

No. Everything runs entirely in your browser with JavaScript. Nothing is sent over the network, which makes the tool safe for sensitive data.

Which PostgreSQL types are used?

Strings map to TEXT, integers to BIGINT, floats to DOUBLE PRECISION and booleans to BOOLEAN. Nested objects and arrays become JSONB columns, and names are snake_case in double quotes.

Can I paste an array of records?

Yes. An array of objects describes one row each: the first element defines the table columns, exactly like the JSON to MySQL tool.

JSON to PostgreSQL CREATE TABLE

JSON to PostgreSQL CREATE TABLE — Free Online Tool

Generate a PostgreSQL CREATE TABLE statement from sample JSON in your browser. Free, private and offline-friendly: your data never leaves your device.

Instant Private Zero cookies

Root name

JSON input

PostgreSQL output

Why convert JSON to PostgreSQL?

Designing a table from an existing payload should not require writing DDL by hand. Paste a sample JSON document above and get a ready-to-run CREATE TABLE statement for PostgreSQL in an instant.

How it works

The converter infers a column per key. Strings become TEXT, integers BIGINT, floats DOUBLE PRECISION, booleans BOOLEAN — and anything nested becomes a JSONB column, which is more honest than inventing foreign keys from a single sample. Columns are NOT NULL unless the sample value is null, and the Root name option sets the table name.

Frequently asked questions

Is my JSON data uploaded to a server?: No. Everything runs entirely in your browser with JavaScript. Nothing is sent over the network, which makes the tool safe for sensitive data.
Which PostgreSQL types are used?: Strings map to TEXT, integers to BIGINT, floats to DOUBLE PRECISION and booleans to BOOLEAN. Nested objects and arrays become JSONB columns, and names are snake_case in double quotes.
Can I paste an array of records?: Yes. An array of objects describes one row each: the first element defines the table columns, exactly like the JSON to MySQL tool.