PostgreSQL schema changes, reviewed in Git

PostgreSQL ER Diagrams, Schema Design, and SQL Client

Connect DbSchema to PostgreSQL and get an ER diagram of the real schema, documentation you can publish, and a design model your team reviews in Git before anything reaches production.

  • Reverse engineer tables, views, indexes, and foreign keys into an editable diagram
  • Keep JSONB columns and arrays visible in context, not buried in catalogs
  • Compare development, staging, and production, then generate the migration SQL
  • The same workflow covers Neon, Supabase, and Aurora PostgreSQL
available for ISO-27001 certified ISO-27001 certified
Free Community Edition No signup required 15-day Architect trial included
Free Download
DbSchema showing a PostgreSQL ER diagram and schema documentation
100+ Databases
|See All   >

Trusted by teams at

Three Years of Migrations Later,
Nobody Has the Full Picture

The real PostgreSQL schema exists only in production: the design docs are stale, \d prints one table at a time, and every new feature starts with an archaeology session through old migration files.

DbSchema rebuilds the picture from the live database — an editable model your team can diagram, document, version, and review.

Everything Between the First Diagram
and the Reviewed Migration

Understand the schema, change it visually, ship the SQL — one PostgreSQL model throughout.

Reverse engineer a PostgreSQL schema into an ER diagram
Import the Schema You Inherited

Point DbSchema at a PostgreSQL instance and it builds the diagram from the live catalog — tables, views, indexes, and foreign keys, with JSONB columns and arrays shown in context.

Split a PostgreSQL schema into focused diagrams
Break a Big Schema into Readable Diagrams

Give each domain its own layout, color the tables that belong together, and export any diagram to PDF or SVG when the design review needs a picture.

Generate PostgreSQL migration scripts from a schema diff
Migrations You Read Before You Run

Diff the model against development, staging, or production and get the DDL in PostgreSQL's own dialect — nothing is applied until you approve it.

Build PostgreSQL queries visually
Build the Join with the Mouse

Snap tables, filters, and grouping together visually, then inspect the generated query — a relief when the relationships exist only in application code.

PostgreSQL SQL editor with schema-aware autocomplete
SQL with Your Schema on Autocomplete

Completion that knows your tables and views, script execution, editable result grids, and export to CSV, Excel, or JSON.

Generate HTML5 documentation for a PostgreSQL database
Documentation Nobody Has to Maintain

Regenerate interactive HTML5 docs from the model whenever the schema moves — searchable diagrams with comments, readable in any browser.

Design review for your schema, not just your code.

psql Tells You What Is
The Model Says What Should Be

The schema lives in a design file as well as on the server. Because of that file you can work offline, put changes through review, and choose what production receives.

Design the PostgreSQL schema offline
Work Disconnected

Sketch schema changes on the train, or before the first CREATE TABLE ever runs.

Branch and review the PostgreSQL schema in Git
Branch the Schema

The model is a file: branch it, diff it, and merge it alongside your code.

Approve the generated PostgreSQL DDL
Approve the Exact SQL

Each change becomes DDL you read before it touches any server.

Promote reviewed changes across PostgreSQL environments
Promote with Intent

Carry one reviewed change from development through staging to production.

Schema Review Belongs
in the Pull Request

Commit the model file with your code and the schema follows your team's normal review flow. After the merge, DbSchema compares model and database and produces the SQL that closes the gap — for you to read, then run.

PostgreSQL schema synchronization between the Git model and database instances
Read Git Workflow Docs

Documentation That Regenerates
Instead of Rotting

One click publishes the model as interactive HTML5 documentation — zoomable diagrams, table and column comments, hover details. Analysts and new joiners explore the schema from a browser tab, with no database credentials and no wiki page slowly going stale.

Explore the Documentation Tool

Interactive HTML5 documentation generated from a PostgreSQL schema

An AI Assistant That Has Read Your Schema

Describe the query in plain English, ask what an unfamiliar view does, or ask which index a slow query is missing. Answers come from your own design model, so they name your tables — not textbook examples.

See What the AI Assistant Can Do

DbSchema AI assistant answering questions about a PostgreSQL schema

Watch: From a Live PostgreSQL Database
to a Designed Schema

Connecting to PostgreSQL and designing the schema (5 min). DbSchema fetches the PostgreSQL JDBC driver automatically on first connect.

The default port is 5432 and the URL format is jdbc:postgresql://host:5432/dbname. SSL is supported natively, and the usual access rules in postgresql.conf and pg_hba.conf apply unchanged — for wire-compatible services such as Neon, Supabase, and Aurora PostgreSQL, too.

DbSchema vs pgAdmin

pgAdmin is the community's standard PostgreSQL administration tool, and server management is where it shines. DbSchema comes at the database from the design side — diagrams, an offline model, documentation — and applies that same workflow to the rest of your database estate.

DbSchema pgAdmin 4
Supported databases 100+ engines, including every major PostgreSQL flavor PostgreSQL family
ER diagrams Interactive diagrams with multiple layouts, saved in the model ERD tool per database
Offline design model in Git Yes — reviewable project file plus Git integration (Pro) —
Schema compare between environments Diff models or live databases and generate migration SQL (Pro) Schema Diff tool
Interactive HTML documentation Yes — searchable diagrams and comments (Pro) —
Server administration — (schema design focus) Yes — roles, backups, monitoring dashboards
Price Free Community edition; paid Pro with 15-day trial Free, open source

Reflects typical pgAdmin 4 usage at the time of writing; check the pgAdmin documentation for current features.

Put Your PostgreSQL Schema on a Diagram

Free Community Edition, 15-day Architect trial, one installer — and no signup.

Download Free

Tutorials and guides

Frequently asked questions

For schema design, ER diagrams, and documentation, yes — DbSchema adds an offline model with Git versioning and interactive HTML docs, while pgAdmin remains the standard for PostgreSQL server administration. Many teams use both.

Yes. DbSchema uses the official PostgreSQL JDBC driver and supports SSL/TLS with standard connection parameters in the JDBC URL.

Yes. Connect to your instance and DbSchema imports tables, views, indexes, and foreign keys into an interactive ER diagram you can edit and document.

Yes. The Community edition is free and includes reverse engineering, interactive ER diagrams, visual table editing, and the SQL editor. Pro features can be evaluated with a 15-day trial.

Port 5432. The JDBC URL format is jdbc:postgresql://host:5432/dbname.

Teams working with PostgreSQL often use these engines too. Explore dedicated guides and JDBC setup for each.

Browse all 100+ supported databases