Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
    
Possible duplicate dba.stackexchange.com/questions/1283/… –  David Oct 29 '11 at 20:04
3  
@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
add comment

4 Answers 4

up vote 9 down vote accepted

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

http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools

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: http://www.databaseanswers.org/modelling_tools.htm

share|improve this answer
add comment

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
3  
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: dba.stackexchange.com/help/behavior –  JNK Mar 6 at 14:40
6  
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 at 14:52
    
I improved the answer, thanks for bringing this issue to my attention. Ignorantia iuris nocet. –  Jarosław Błąd Mar 7 at 12:51
add comment

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
add comment

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 http://www.postgresonline.com/journal/index.php?/archives/133-Database-Administration,-Reporting,-and-Light-application-development.html

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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