Download the PostgreSQL JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.
A JDBC driver is a Java .jar library that lets applications connect to PostgreSQL.
DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation.
Driver files are usually published by the database vendor or an open-source project.
Host, port, database name, and SSL options are passed in a URL starting with jdbc:.
Each PostgreSQL driver uses its own syntax — see the connection details below.
PostgreSQL is the world's most advanced open-source relational database, known for its support for complex data types, JSON/JSONB, full-text search, PostGIS, and a rich extension ecosystem. It is the database of choice for data-intensive applications, SaaS platforms, and teams that need SQL compliance.
Download PostgreSQL JDBC Driver
The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.
If you want to connect to Heroku Postgresql web-based database, please edit the JDBC driver URL (in Driver Manager dialog) and append ?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory to the end. This SSL parameter is also useful for any PostgreSQL host that requires SSL, such as managed cloud instances.
DbSchema supports PostgreSQL schemas, extensions, and custom types natively. Use the Query Builder to compose complex joins across multiple schemas, and the Schema Documentation feature to generate HTML reference docs for your PostgreSQL data model.
Have a question about the driver version? Contact the DbSchema team — we keep the bundled driver up to date.
Connect PostgreSQL, build your first ER diagram in minutes. No account required.
Get the PostgreSQL driver zip below and install DbSchema for Windows, macOS, or Linux.
In DbSchema, open Driver Manager, add the extracted JAR, and paste your JDBC URL.
Reverse engineer PostgreSQL, edit the model visually, and publish schema documentation.
After the JDBC driver connects, you get ER diagrams, SQL editor, schema sync, and HTML documentation in one desktop app. Compare DbSchema editions.
Reverse engineer PostgreSQL into an interactive diagram and edit structures visually.
Run SQL with autocomplete or compose queries without writing every join by hand.
Export HTML docs your team can browse without installing DbSchema.
Connection tips, ports, SSL, and schema design workflows on the database landing page.
Other drivers teams often configure alongside PostgreSQL.
Teams working with PostgreSQL often use these engines too. Explore dedicated guides and JDBC setup for each.