Free Database Design Tool Postgresql

Design the schema in a Team. Deploy the schema on multiple PostgreSQL servers.

DbSchema model is using its copy of schema structure, independent from the PostgreSQL database.
This is a separation between schema design and the database, with numerous advantages:

Manage Multiple Databases

Compare and deploy the database schema on multiple PostgreSQL databases. Incremental changes can be applied.
Model File

Save the design model including the schema structure to model file, as XML text. The model file can be open from any computer, without PostgreSQL connectivity.
Design in Team

The model file can be stored in GIT and shared in a team. Each team member can modify it and commit model changes in GIT. Database administrators can deploy the schema changes on testing or production databases.

Generate Migration Scripts

Generate migration scripts from one version of the schema to another by comparing two different model files with two versions of the same schema.
Design Offline

Schema can be designed offline, without database connectivity.

Relational Data Explorer: Easy Visualize Data

An amazingly simple PostgreSQL data explorer and editor that offers simultaneous views of data from multiple tables, and features numerous filters, data sorting mechanisms, and much more. The editor can explore data from multiple tables simultaneously using foreign keys or virtual foreign keys between tables. If the schema is missing foreign keys you can create virtual foreign keys that will be part of the DbSchema model.

Database Data Explorer

Discover the Tools for PostgreSQL

Visual Query Builder

There is no need to be an PostgreSQL SQL pro to be able to write database queries. Create queries is an easy task for the Visual Query Builder. The builder can use different Join types and Group By functions.

Read more
PostgreSQL SQL Client

The PostgreSQL SQL Editor features syntax highlight, text auto-completion, query and script execution, Groovy support, graphical execution plan.

Read more
Random Data Generator

For development or test purposes you may need to fill the PostgreSQL database with randomly generated data. A bunch of predefined reverse regular expressions as well numbers, date, JSON, and groovy script generators will help you.

Read more
PostgreSQL Schema Compare & Synchronization

DbSchema uses its own images of the schema, distinct from the PostgreSQL database, which is saved as a model file. The DbSchema model can be compared with any database. For each difference, you can decide to merge in the DbSchema model, apply it in the database, or generate the SQL scripts.

Read More
Automate Database Tasks

All major DbSchema processes, like schema synchronization and deployment, generate documentation, reverse engineer schema structure can be automated using Groovy or JS scripts with direct access to DbSchema API.

Read More
Virtual Foreign Keys

Foreign keys are used for data accuracy. If the database lacks foreign keys, you can create Virtual Foreign Keys that will be created only in the DbSchema model and will be saved to the model file. They will help you to gain a better understanding of the database.

Read More
Forms & Reports Designer

You don't need a separate tool to build database forms or reports. DbSchema can create responsive web reports which you can deploy on a separate server. You may also create small applications with input fields, buttons, and charts.

Read More
Database Data Importer

Import data in the database from various files, including CSV, XLSX, XLS, XML, etc.

Read More

Free Trial

Free download & evaluate DbSchema for 15 days.

Technical Support

Every user will benefit from full technical support.

All Databases Included

With a one license you can connect to every SQL, NoSQL or Cloud database

Money Back Guarantee

Not happy with DbSchema? 30 days after your purchase you can claim your money back.

Satisfied Customers

Many compliments! It is one of the best software I've ever seen

"The project team I am reporting to really like the HTML5 documentation I can send them. Thank you again for this brilliant software. I am recommending it to all my colleagues."

"Using Relational Data Editor i can see table data from multiple tables without writing any sql queries, it's like a child's play."

"I've had some time to play with and get acquainted with DbSchema. I am impressed. It never crashed once, it's very intuitive, and the compare/sync wizard is all I expected."