Launching soon
Your database schema, documented
erddocs turns a SQL dump, a Prisma schema, or framework migrations into an interactive ER diagram and a printable data dictionary — every table, column, type and relation, ready to hand to a client, a new teammate, or a professor. Parsing happens in your browser; the schema is never uploaded.
One payment. No subscription. No account.
How it works
- 01Export your schema —
pg_dump --schema-onlyfor PostgreSQL,mysqldump --no-datafor MySQL. - 02Paste it in. Tables, keys and relations are detected automatically.
- 03Rearrange the diagram, follow relationships, export PNG or SVG.
- 04Generate the data dictionary and save it as HTML or PDF.
Example
Two tables and a foreign key — this renders as two boxes joined by a many-to-one relation, and as a two-entry dictionary with types, defaults and constraints.
CREATE TABLE customers (
id bigserial PRIMARY KEY,
email varchar(255) NOT NULL UNIQUE,
created_at timestamptz NOT NULL DEFAULT now()
);
CREATE TABLE orders (
id bigserial PRIMARY KEY,
customer_id bigint NOT NULL REFERENCES customers(id),
status varchar(20) NOT NULL DEFAULT 'pending',
total numeric(10,2) NOT NULL,
created_at timestamptz NOT NULL DEFAULT now()
);Why erddocs
- Documentation, not just a picture. A data dictionary is what auditors, clients and new hires actually ask for.
- No signup, no install. No account before you see the result, and no package to add to your project.
- Pay once. A one-time price instead of a per-seat subscription you forget to cancel.
- Private by design. Parsing runs locally in your browser — production schemas stay on your machine.
FAQ
- What is a data dictionary?
- A data dictionary is a readable reference document for your database: every table, column, data type, nullability, default value, index, and relationship, described in one place. Teams use it for onboarding, audits, and client handover.
- Does my schema get uploaded anywhere?
- No. Parsing and rendering run entirely in your browser. Your SQL never leaves your device, and there is no account to create.
- Which databases are supported?
- PostgreSQL and MySQL dumps at launch, including pg_dump output with ALTER TABLE ONLY ... ADD CONSTRAINT statements. Prisma schemas and framework migrations follow.
- What does it cost?
- Viewing diagrams and exporting images is free. The data dictionary export is a one-time payment — no subscription, no seats.