Stop drawing your database by hand
Generate a beautiful ER diagram from your PostgreSQL database in under 10 seconds. No signup, no setup, no sketching.
dbdiagramr is a free tool that converts PostgreSQL connection strings into interactive entity-relationship diagrams. It introspects your live database schema, tables, columns, foreign keys, and constraints and renders them as a navigable SVG diagram you can pan, zoom, and export.
See your database, visually
Hover tables to trace relationships.
Set up your database connection
Follow these three steps to connect your PostgreSQL database and generate your ER diagram.
Get your connection string
In the production dashboard, click Connect to retrieve the connection string.
Select the Transaction pooler
Under Connection method, select the Transaction pooler option - this ensures compatibility with stateless applications and allows dbdiagramr to detect connections properly.
Copy the credentials
If you don't remember your database password, regenerate it in the Shared pooler section and copy-paste the new credentials into your configuration.
Everything you need
No complex setup. No enterprise sales. Just your database, visualized.
Instant
Connect your PostgreSQL database and generate a diagram in under 10 seconds. No manual drawing required.
Shareable
Export as PNG or share an interactive link with your team. Everyone sees the same schema, always up to date.
Secure
Your connection string is never stored. We introspect your schema and discard everything else. Your data never leaves your control.
Why use dbdiagramr?
See how dbdiagramr compares to the alternatives for understanding your PostgreSQL schema.
| Feature | dbdiagramr | Drawing manually | SQL queries / pgAdmin |
|---|---|---|---|
| Setup time | Under 10 seconds | 30 minutes to hours | Instant but no visuals |
| No signup required | |||
| Interactive diagram | |||
| Auto-layout tables | |||
| Shows foreign key relationships | |||
| Export as SVG / PNG | |||
| Live schema from your DB | |||
| Always up to date | |||
| Free to use |
Simple pricing
Start free. Upgrade when you need more.
Perfect for solo developers exploring their database structure.
- 5 diagrams per month
- Static PNG export
- Single database connection
- Community support
Most popular
For developers who need to share and collaborate.
- Unlimited diagrams
- Interactive shareable links
- Version history
- Team access (up to 5 members)
- Priority email support
PostgreSQL guides
Practical guides on schemas, ER diagrams, and connection strings — all grounded in live database introspection.
dbdiagram.io vs dbdiagramr vs DrawSQL: Honest Comparison
The real differences between dbdiagram.io, dbdiagramr, and DrawSQL -- pricing, features, Supabase integration, and which one fits your workflow.
Supabase Connection String: IPv6, ENOTFOUND, and the Transaction Pooler Fix
Why Supabase throws ENOTFOUND and ETIMEDOUT errors, the IPv6 vs IPv4 problem, and how the transaction pooler port (6543) fixes most connection issues.
Why Schema Diagrams Go Stale (and the Fix)
Schema diagrams drift out of sync within weeks. Here's why it happens, the three fixes that actually work, and how to make your diagram self-healing.