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.

• Add new dark mode for Mojave (10.14)
• Better applescript support, can now add more types of object, delete objects and extract cardinality information
• Better file reading code is now enabled by default
• New option to turn dark mode on or off for SQLEditor only or follow system setting
• The icon on the button that links a field to its parent has been changed
• Some other graphics have been redrawn mostly without change
• The drawing of the icons in the left (source) sidebar toolbar has been improved
• Cursor images for creating foreign key connections have been redrawn
• Color modification for selected tables has been modified slightly
• Fix: Tables that have position locked will now resize if a field is added
• Fix: The show object palette menu command now works properly again
• Fix for extra lines sometimes appearing in the blue overlay selection rectangle
• Fix: the add field button on the table inspector is now disabled if more than one table is selected
• Fix: Better automatic quoting for identifiers with characters that require quoting (postgres,mysql)
• Fix: for bug where about box display caused crash if appearance had changed
• Added new preference to turn off quoting for identifiers with characters that require quoting (postgres,mysql)
• Removed print toolbar item
• Some images in the app that were redundant have been removed
• Minor cleanup and fixes
• Now built with 10.14 sdk