Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am about to design a database which is going to run with PostgreSQL. I am used to the magnificent tool called MySQL Workbench for MySQL database. It is useful and it looks good which I kind of expect from a database designing software.

If I am about to learn a new database designing tool, I want it to be the most popular one. Therefore, my question is: what are the most popular tools for designing the database in PostgreSQL?

share|improve this question

closed as off-topic by Paul White, Phil, dezso, bluefeet, Aaron Bertrand Jan 26 '15 at 14:39

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Phil, dezso, bluefeet, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

Possible duplicate… – David LeBauer Oct 29 '11 at 20:04
@David I don't think this is a duplicate though it is a related question - tools for managing a database are not necessarily the same as those for designing and modelling – Jack Douglas Oct 30 '11 at 17:37
up vote 10 down vote accepted

There are several options in the PostgreSQL world, most of them are listed in the PostgreSQL wiki:

The next version of pgAdmin will include a ER designer as well as far as I know.

PowerArchitect works with PostgreSQL, though in the free version it is somewhat limited. In general it does not support DBMS specific features (or only a very limited set).

In the commercial world, nearly all of the "big names" support PostgreSQL as far as I know (including Sybase PowerDesigner and ERwin).

dbWrench is a not too expensive and seems to be quite nice.

TOAD data modeler is a bit more expensive but has an impressive feature list.

You might also want to check the options listed on this page:

share|improve this answer

A similar question was asked on SO and my answer is still the same:

I use the Community Edition of MySQL Workbench for creating pretty pictures of my schema - but I'd rather create the DDL that actually runs on my database by hand.

share|improve this answer
You have a very good point there (creating the DDL by hand). That's why I prefer tools that write the model as XML because that gives me the chance to generate the DDL via XSLT and still have a single source for everything. – a_horse_with_no_name Oct 30 '11 at 11:58
That's a great idea, I might copy it :) – Jack Douglas Oct 30 '11 at 17:33

I suspect you will have a hard time transitioning to something given the limited options in Postgres land, but probably the most popular ERD is the AquaData Studio tool. There was actually a write up on this topic recently, check out,-Reporting,-and-Light-application-development.html

(note, I'm not affiliated with either aqua data studios or the blog)

share|improve this answer

I recommend Vertabelo. Vertabelo is an online database designer working under Chrome developed by company I work for.

The most important feature of this tool is that it allow to share database models across the team and collaborate on them via web browser.

Others Vertabelo features include:

  • Model versioning
  • Support for PosgreSql, MySQL, Oracle, MS SQL Server, DB2, SQLite, HSQLDB
  • Dynamic/Visual search
  • Live database model validation
  • Reverse engineering

Vertabelo is free to use for smaller projects (up to 3 models and 20 tables within each model) and have commercial versions for larger database projects.

share|improve this answer
Yes, as @dezso indicates please disclose your affiliation with anything you endorse. If your sole contribution to the site is those endorsements we may have an issue. Please see: – JNK Mar 6 '14 at 14:40
See This reply from a vendor representative for a good example of how a vendor can contribute an answer of this type. – ConcernedOfTunbridgeWells Mar 6 '14 at 14:52
I improved the answer, thanks for bringing this issue to my attention. Ignorantia iuris nocet. – Jarosław Błąd Mar 7 '14 at 12:51
The answer is good enough already. Why you people keep voting down on it? – Cleankod Aug 19 '15 at 9:33

Not the answer you're looking for? Browse other questions tagged or ask your own question.