Database Diagramming tool for OSX?

Question

I've seen several questions posted here about recommendations for UML diagramming tools as an alternative to Visio. What I seem to be missing, though, is a good database diagramming tool for OS X. I have done all of my development work in the .NET world for the last few years, and for better or worse Visio has been my go-to tool for database diagramming (as it supports defining columns, keys, relationships, etc.). I've found several completely adequate general-purpose diagramming tools for OSX, but I haven't yet found something suitable for a fairly detailed, exhaustive database diagram.

Does anyone have any suggestions? I need to be able to define columns, keys, and relationships. Indexes and constraints would be a bonus, too.

Edit

So far I've tried:

• Visual Paradigm Community Edition
• OmniGraffle
• ConceptDraw

And one or two others that I've since uninstalled and, of course, can't remember!

Answer 1

In XCode, you can make nice database diagrams with .xcdatamodel files that generate some code for Core Data. I imagine you could just use XCode to do the diagram and not actually generate any code if you wanted to.

Answer 2

For MySQL there is MySQL Workbench

Answer 3

I've also used Power*Architect on Mac OS and Linux, and while it wasn't perfect, it was good enough.

Answer 4

This question was answered, but you should try SQLEditor. It's DB agnostic and it even works with Rails Migrations. It can reverse engineer an existing db, and output SQL for some other variant.

http://www.malcolmhardie.com/sqleditor/