JSON to PostgreSQL CREATE TABLE

Overview

When your data lives in JSON — API responses, log lines, NoSQL exports — the schema inferrer flattens the top-level keys into columns and infers PostgreSQL types from the values. Numbers become INT/BIGINT/NUMERIC, true/false becomes BOOLEAN, ISO 8601 strings become DATE or TIMESTAMP, UUID-shaped strings become UUID.

What you get

Type detection reference

Sample values and the dialect-native type they map to.

Example

[
  {"id": 1, "name": "Alice", "score": 9.4, "active": true},
  {"id": 2, "name": "Bob",   "score": 7.2, "active": false}
]

CREATE TABLE users (
    id     INT          NOT NULL,
    name   VARCHAR(16)  NOT NULL,
    score  NUMERIC(2,1) NOT NULL,
    active BOOLEAN      NOT NULL
);

Frequently asked questions

Try it now

No signup, no install — runs entirely in your browser.