ERD diagram from PostgreSQL SQL
You do not pick the dialect from a list — it shows in the script itself. Here is what the editor finds in a typical PostgreSQL schema.
The inputschema.sql
CREATE TABLE users (
id BIGSERIAL PRIMARY KEY,
email VARCHAR(255) NOT NULL UNIQUE,
full_name VARCHAR(120),
is_active BOOLEAN NOT NULL,
created_at TIMESTAMPTZ NOT NULL
);
CREATE TABLE orders (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT NOT NULL REFERENCES users(id),
total NUMERIC(12,2) NOT NULL,
note TEXT,
placed_at TIMESTAMPTZ NOT NULL
);- Detected as
PostgreSQL- Told apart by
SERIAL · TIMESTAMPTZ · BOOLEAN
Parsed: 2 tables, 1 relation
Open the editor
The script stays in the browser: both parsing and generation run on your machine, nothing goes to a server.
Types of this dialect the editor knows
INTEGERBIGINTSMALLINTSERIALBIGSERIALNUMERIC(12,2)REALDOUBLE PRECISIONBOOLEANTEXTVARCHAR(255)CHAR(2)DATETIMETIMESTAMPTIMESTAMPTZUUIDJSONBJSONBYTEAINET