Entity Relationship Modeling Tools for Mac OS X

In my Database class this evening we were watching the instructor do some database modeling using Visio. I was playing along using Omnigraffle, but after a while it didn’t go as far as Visio did in terms of automatically creating relationships, foreign keys, and that sort of thing. I wanted something more developer oriented. So I did some quick research on what is available:

MySQL Workbench

Supports MySQL, obviously. I might wind up using this just because I almost entirely deal with MySQL. The only variable in that is my forays into Oracle lately.

Aquafold Data Studio

Supports Oracle, DB2, SQL Server, Sybase, Informix, PostgreSQL, MySQL – code generation looks powerful.
Free version 4.7, 6.0 costs $399. 4.7 looks dated compared to the 6.0 version, but man the price jump!

Visual Paradigm

Many interesting and compelling variations. Community Edition is free. This one looks pretty nice to me – my cup of tea. Lots of related products and editions, so there are options for most modeling needs, budgets, and scopes.

ConceptDraw VI Pro

Standard $149, Pro $299

So far I’ve cracked open MySQL Workbench and Visual Paradigm for UML Community Edition. I am only at the beginning of exploring these tools, so I’ll let you know how it turns out.

3 thoughts on “Entity Relationship Modeling Tools for Mac OS X”

  1. In the past I’ve used a tool called XERD. It’s pretty basic, but that’s all I really want. But it’s been a long time since it was updated, so I’ve switched over to using OmniGraffle, and creating the tables by hand, using CocoaMySQL, or Migrations in Rails.

  2. Checked out ConceptDraw this morning. A couple of observations

    1) It appears to be quite powerful
    2) They offer different packages relating to different needs
    3) As a non-tech ancient guy I’m somewhat figured it out, it seems not complex
    4) It gets a 4 Mouse rating from MacWorld.
    5) It can work with Visio

  3. The new tool Vertabelo http://www.vertabelo.com is worth to check. Vertabelo is an online database designer working under Chrome.

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

    Vertabelo is free to use for smaller projects and have commercial versions for larger.

Leave a Reply

Your email address will not be published. Required fields are marked *