How do I get my PostgreSQL connection string?

In your database provider's dashboard, click Connect to retrieve your connection string. It typically looks like: postgresql://user:password@host:5432/dbname.

Which connection method should I use?

Select the Transaction pooler option. This ensures compatibility with stateless applications and allows dbdiagramr to detect connections properly.

What if I forgot my database password?

Regenerate your password in the Shared pooler section of your database provider's dashboard and copy-paste the new credentials into your connection string.

← Try the tool

PostgreSQL

PostgreSQL Schema Visualizer

Paste SQL or connect to your PostgreSQL database. See tables, relationships, and constraints as an interactive diagram in seconds.

Paste SQL or Connect

Live Preview

Export SVG/PNG

dbdiagramr.space/visualize

React Flow

Two ways to visualize your schema

Paste SQL for a quick preview, or connect to your live database for the full picture.

dbdiagramr.space/visualize

CREATE TABLE users {
  id uuid PRIMARY KEY,
  name varchar(255) NOT NULL,
  email varchar(255) UNIQUE
};

CREATE TABLE posts {
  id uuid PRIMARY KEY,
  user_id uuid REFERENCES users(id),
  title text,
  created_at timestamptz
};

Generate diagram2 tables, 1 relationship detected

Paste SQL

Paste CREATE TABLE statements and see a live ER diagram as you type. No server needed.

Try SQL mode →

Connect to Database

Paste your PostgreSQL connection string and see your entire database schema. Works with Supabase, Neon, Railway.

Try connection →

What you can see

Every table in your database with columns and data types
Foreign key relationships drawn as lines between tables
Primary keys highlighted on each table
Nullable columns marked so you can see optional relationships
Export options -- PNG, SVG, or interactive shareable link

Frequently asked questions

What is schema visualization?

Schema visualization converts your database metadata -- tables, columns, foreign keys, and constraints -- into a visual diagram. Instead of reading SQL or browsing a list, you see how your database is structured at a glance.

What is information_schema vs pg_catalog?

information_schema is the SQL-standard way to query database metadata. pg_catalog is PostgreSQL's internal catalog with more detail. dbdiagramr reads your schema using the standard approach, so it works with any PostgreSQL version.

Does this work with managed PostgreSQL?

Yes. It works with Supabase, Neon, Railway, AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL, and any self-hosted PostgreSQL instance. Just paste the connection string.

How accurate is the diagram?

100%. The diagram reads your live schema directly from the database. If you add a column or create a new table, the next visualization shows it immediately. Nothing is cached or guessed.

Can I use this for database documentation?

Yes. Export the diagram as PNG or SVG and include it in your README, technical docs, or architecture diagrams. It is a great way to onboard new team members.

Visualize your PostgreSQL schema now

Paste your PostgreSQL connection string and get an interactive schema diagram in under 10 seconds. No signup required.

Try it free →