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 would like to have a good tool for designing the Database Schema with all the tables, columns, data types and relations. Today I mostly do this with pen and paper but I would like to do it in a good design tool.

Is there any good (and maybe free) Database Design tool?

share|improve this question

closed as off-topic by Paul White, RolandoMySQLDBA, Kin, Max Vernon, Mark Storey-Smith Apr 30 at 17:25

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, Kin, Max Vernon, Mark Storey-Smith
If this question can be reworded to fit the rules in the help center, please edit the question.

add comment

6 Answers 6

up vote 6 down vote accepted

More for ER than for prototyping (never heard it in the context of databases): If you are on MySQL, try MySQL Workbench. Although it generates MySQL specific code, small adjustments are easily made.

For PostgreSQL, there is a nice list in their wiki, PGDesigner lookes very capable. Furthermore, there will be a Designer in future versions of pgAdmin.

share|improve this answer
add comment

I started using NORMA (link fixed Oct 2011) which is useful to capture the relationships and constraints in plain English. See Object Role Modelling too.

This will generate XSDs and SQL scripts.

I hope never to see an ERD ever again...

share|improve this answer
add comment

I used in the past the Power Designer (or Q Designer back in those days). It was terrific! Had reverse engineering facilities, script generation.. everything you'd need. But it's not free.

A free tool I've used a bit in the past was DB Designer. But I could use it only for small dbs. Had errors back then working with complicated schema designs, but it was few years ago, so I'm sure it was fixed.

Now I use only SQL Server's own diagramming tool.

share|improve this answer
add comment

MySQL Workbench is a great free tool.

Another option is SQL Server's diagramming, which is included with Express, so you could try that for free as well.

Embarcadero's ER/Studio has a free trial. It is a more complete solution (read, expensive) in that it supports logical and physical modeling. ER/Studio is an incredible product that is worthy of its pricetag if you do a lot of design.

share|improve this answer
add comment

I have used both MySQL Workbench, Toad Data Modeler, and Oracle's SQL Developer Data Modeler. Any one of them would be a good place to start.

share|improve this answer
add comment

You can use 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:

  • Support for PosgreSql, MySQL, Oracle, MS SQL Server, DB2, SQLite, HSQLDB
  • Model versioning
  • Dynamic/Visual search
  • Live database model validation
  • Forward engineering
  • 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
add comment

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