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

Supabase

Supabase Schema Diagram Generator

See your Supabase database -- auth tables, public tables, and foreign keys -- as an interactive ER diagram. Paste SQL or connect with Session pooler (port 5432).

Supabase Native

Paste SQL or Connect

Free

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 gets visualized

Public schema -- your application tables, views, and foreign keys
Auth schema -- users, identities, sessions, refresh_tokens
Storage schema -- buckets, objects, and access controls
All relationships -- foreign keys drawn as lines between tables

Frequently asked questions

How do I get my Supabase connection string?

Go to your Supabase Dashboard, click Settings, then Database. Under Connection string, select the Session pooler (port 5432). Copy the full URI -- it starts with postgresql://. This is the string you paste into dbdiagramr.

Why do I get ENOTFOUND or IPv6 errors with Supabase?

Supabase uses IPv6 by default on the Direct connection. Use the Session pooler (port 5432) instead -- it works over IPv4 from anywhere. The Transaction pooler (port 6543) is for serverless functions and won't work with schema tools.

Can I see the Supabase auth schema?

Yes. When you connect your Supabase database, dbdiagramr shows all tables including the auth schema (users, identities, sessions, refresh_tokens), storage schema, and your public schema tables. Everything is in one diagram.

Does this show RLS policies?

Not yet. dbdiagramr currently shows tables, columns, foreign keys, and primary keys. Row Level Security policies are on the roadmap.

Is this affiliated with Supabase?

No. dbdiagramr is an independent tool that works with any PostgreSQL database. Supabase is just one of many providers we support -- it also works with Neon, Railway, AWS RDS, Google Cloud SQL, and self-hosted PostgreSQL.

Visualize your own Supabase database

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

Try it free →