SQLEditor

SQLEditor is a SQL database design and entity relationship diagram (ERD) tool for OS X. It replaces typing SQL by hand with dragging, dropping, and clicking, making database creation faster and easier. And if you already have a database, then SQLEditor can help you see what it looks like by reverse engineering a diagram. Or use SQLEditor to create documentation with the new design report exporter. SQLEditor may be useful if you need to design a database or you have existing databases to manage. It's also useful if you're learning about database design.

SQLEditor supports exporting database designs to MySQL, Postgres, SQLite, Oracle, and others. Plus it also imports and exports Ruby On Rails Migration files.

Group License: $349, Single User License $79. Discounts for qualified educational orders.
Note SQLEditor 3 is a paid upgrade from earlier versions. Free upgrades for licenses purchased on or after 1 March 2014.

• This is a bug fix release for v3.3
• Fix for a bug where object hidden state wasn’t being saved
• Rewritten parts of the inspector code to remove a crashing bug
• TargetProxy object which caused some crashes has been removed entirely and the section rewritten
• Undo after deleting a table which is the target of a foreign key object now correctly restores the connection line
• Connector control handles now don’t snap too far to the right in certain odd cases
• Fix so that constraint key names cannot be edited with the inspector when multiple objects are selected
• It was previously possible to fix a connection point and move both tables to the right of that point. The line will now snap properly to the right.
• Much of the document XML loading code has been rewritten (but this new code is currently turned off by default)