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.

Site license: $349, single copy $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.

• Fix for crash when save connector position was turned off and connector style is orthogonal
• Renamed "save connector position" preference to "Use stored orthogonal connector position"
• Previously connector position data was lost if the "save connector position" setting was turned off, it is now saved if it is available
• Connector handles are not shown if the "Use stored orthogonal connector position" preference is unchecked
• Add a new compatibility warning if you open a file from a new version of SQLEditor in an older version
• Fixed a bug relating to autosizing
• Add first touchbar support (Add table, add field, duplicate and copy commands are available)
• Modified django exporter field panel (can now add any property you like on columns)
• Type sizes will not be displayed in the main canvas where the dialect doesn’t support them (preference to turn off)
• SQLServer exporter is better at knowing which types support sizes and which don’t
• Drag and drop now supports plugins (including JS plugins)
• Fixed issue where icon for sidebars was different on retina screens vs non-retina
• Fixed issue where SQLWorker was sending messages to the wrong thread during startup
• Fix issue with some selection events not changing with multiple selections
• Fewer log messages at startup for Java
• Plugin loading now logs to a single line
• Fix for Django plugin python error on startup if Django is not installed
• New list of currently installed plugins in preferences window (under export)