Paste SQL. See Schema. Ship Faster.

An entity-relationship diagram (ERD) for PostgreSQL shows your tables, columns, data types, primary keys, and foreign keys as a visual map. It helps you understand how your database is structured and how tables relate to each other.

Copy your PostgreSQL connection string from your database provider (Supabase, Neon, Railway, AWS RDS, etc.) and paste it into dbdiagramr. The tool reads your schema and generates an interactive ER diagram in under 10 seconds.

As their own node. A join table like film_actor appears as a table with two foreign-key lines, one to film, one to actor. Composite primary keys (order_id, product_id) get a PK badge on each column, so junction tables are instantly recognizable.

Type strings are preserved exactly as PostgreSQL reports them: text[], integer[], custom enum names, jsonb, tstzrange, and domains all render verbatim on the column. Nothing is simplified into generic types, so the diagram matches \d output.

A PK badge marks a primary-key column. Each line is a foreign key from one table's column to another table's primary key. A line from a nullable column is an optional relationship; a line from a NOT NULL column is mandatory. Self-referencing keys (like employees.reports_to) draw as a loop back to the same table.

Yes. Export your diagram as PNG or SVG. You can also zoom, pan, and hover over tables to trace foreign key relationships interactively.

Postgres has no built-in diagram view like SSMS database diagrams. The usual workarounds are pgAdmin's graphical query builder, which is not a real ERD, or exporting the schema to an external tool. dbdiagramr fills that gap: paste your connection string and get the SSMS-style table-and-relationship view Postgres never shipped, with Postgres-native types (arrays, enums, jsonb) shown exactly as the database reports them.