Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

Does anyone know a comprehensive Mac app to create SQL Diagramms? I think http://ondras.zarovi.cz/sql/demo/ is quite good, but it's a little bit too basic.

I would like to create the database schema, the relations between the tables (including labels for e.g. n:m relations), add comments, export to SQL, and so on to run from my Mac.

share|improve this question
add comment

8 Answers

MySQL Workbench is good enough for most programming demands. You can create EER Model and can also synchronize the model with DB Changes or vice versa. You can use it with no cost as it's a open-source application. I have been using MySQL for a year and it is very useful for me. I recommend it to you if you don't need any enterprise features and performance.

share|improve this answer
    
I know MySQL Workbench already, please look at the comments :) Actually i love MySQL Workbench, but there could be a few more features (look at my comment above or see my Workbench question here: stackoverflow.com/questions/14946161/…) –  Slevin Feb 21 '13 at 15:54
1  
I see! As for me, I don't export to Image File. But I use Workbench and hover mouse cursor to highlight relationship lines instead. –  Chris Feb 21 '13 at 16:28
add comment

MySQL Workbench is great, though I found that in a lot of cases OmniGraffle works wonderful, especially if you're not so much into "doing it painfully correct according to theory learnt at university" but rather getting the job done.

share|improve this answer
    
OmniGraffle is a little bit too basic for modelling ERD. I don't want doing it painfully correct, but some features are missing ;) –  Slevin Feb 27 '13 at 7:02
add comment

The only Mac only tool I know (and I would love to hear of others here) is SQLEditor. Unfortunately, there doesn't appear to be any support for Stored Procedures or other objects beyond tables and views.

There are also cross-platform solutions (mostly Java-based). In a recent search I evaluated DBWrench and DBVisualizer. When all was said and done, I decided to stay with a Windows solution running under Parallels.

share|improve this answer
1  
Thanks for SQLEditor. I'll give it a try. I'm currently trying MySQL Workbench for Mac and it's really great, except some visual "bugs" (see stackoverflow.com/questions/14946161/…) –  Slevin Feb 19 '13 at 11:40
    
Except, I don't use MySQL. –  Andrew Lazarus Feb 19 '13 at 15:37
    
Which Windows solution do you use? –  Slevin Feb 19 '13 at 16:03
    
@Slevin: Toad Data Modeler. Very powerful. Cranky interface. Internal documentation of scripting language mostly in Czech. –  Andrew Lazarus Feb 19 '13 at 19:59
    
I've made my choice: SQLEditor is great! Thanks for the advice! –  Slevin Feb 27 '13 at 20:42
show 1 more comment

You might want to check out the Navicat line of products. I use Navicat Premium and it's a really great all-in-one tool for many DBs, including MySQL, Postgres, SQLITE, Oracle, and MS SQL Server. It includes a Model tab where you can view and edit existing DBs or create de novo ones, sketch everything out, define relationships, export SQL, have access to an auto-layout function, and all sorts of other goodies.

There are several versions stepping up to the Premium product, including a separate Data Modeler program, so you'll have to browse around to see what fits your needs. It will set you back a little bit of cash, depending on the version, but you can download a 30-day free trial to make sure it's what you need.

I hope this helps!

share|improve this answer
    
Thanks for the advice. I tried it out and seen that the mac version is just a wine port. Also, it crashes if i start the app... –  Slevin Feb 21 '13 at 15:58
1  
that's strange, my version is a native app. I just downloaded download2.navicat.com/download/modeleress010_en.dmg and it was native as far as I could tell. What version of OSX are you running? I'm on 10.8.2... –  MattDMo Feb 21 '13 at 16:20
    
The app has a whole bunch of nib files in the Resources, so it looks really native for me. It works great for me. (I got it from the App Store.) The Linux version is Wine, though. –  Alan Shutko Feb 27 '13 at 3:32
    
I don't get it... something went wrong. Now it works... :) –  Slevin Feb 27 '13 at 6:58
add comment

The free SQL tool of choice for me is SQuirreLSQL. It is a Java application, but very responsive, and you can install both DB drivers and plugins from it, and one of them allows for reverse-engineering and diagramming databases.

Aqua Data Studio runs on Mac OS X as a mixed Cocoa/Java application, with native performance, and includes Entity-Relationship modeling capabilities.

share|improve this answer
add comment

Check out http://www.yworks.com/en/index.html, might not be what you are looking for but it has ER modelling and others...

share|improve this answer
1  
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. –  Global nomad Feb 27 '13 at 1:01
1  
Surely copy-pasting information which is available directly on their website is a) a waste of time and b) irrelevant if the information itself changes. The link is one of the few things that is likely to go unchanged for a very long time. I appreciate your comment but is all the other answers have user opinion mixed in with fact and sometimes masked as fact. I have merely given the link for reference then the OP can make their own call. –  Mike Feb 28 '13 at 13:55
add comment

My preferred tool for modeling in OS X, is Visual Paradigm (VP-UML). They have a free community edition, which is great for creating ERD - but if you want to generate the DDL from your ERD, you'll need to purchase the standard edition.

It's also cross-platform, so that's another boon.

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
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.