SQLEditor
SQLEditor
3.7.2

4.8

SQLEditor free download for Mac

SQLEditor3.7.2

30 June 2020

Create SQL databases graphically.

Overview

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.

What's new in SQLEditor

Version 3.7.2:
  • New dark content mode option in preferences panel - display content of documents in dark mode
  • Options for light and dark UI and Content
  • Default setting uses dark ui with light content when in dark mode, light ui+light content in light mode
  • Dark mode option for saving images (choose light or dark export in image export panel)
  • This version has a Java runtime with more modules included to solve problems with certain JDBC drivers
  • Added Amazon redshift data types
  • Added importing of Postgres comments
  • Schema background color can be set by user
  • Fix for duplicate labels appearing in labels list
  • Fix for labels when copying and pasting
  • Better label handling when you paste a labeled object into another document
  • Better performance when selecting labeled objects
  • Better select all performance
  • Fixed redraw performance issue when selecting objects in a group
  • Fixed label list updating when deleting and undoing the delete of a labeled object
  • Colors are now always sRGB colors, previously some colors were device colorspace
  • Fixes for SSL support when using MySQL JDBC Drivers
  • Fix for file type not updating in save panels
  • Fixes for some minor analyser issues
  • Fix for bug where export images or files could cause save panel to freeze in various odd cases
  • Fix for bug where moving connector handle could cause schema to scroll to origin
  • Connector midpoints (if set) now get relocated relative to the originating table when copied
  • Fixes for SSL support when using MySQL JDBC Drivers
  • This version has a Java runtime with more modules included to solve problems with certain JDBC drivers
  • Fix for duplicate labels appearing in labels list
  • Fix for labels when copying and pasting
  • Better label handling when you paste a labeled object into another document
  • Better performance when selecting labeled objects
  • Better select all performance
  • Fixed redraw performance issue when selecting objects in a group
  • Fixed label list updating when deleting and undoing the delete of a labeled object
  • Colors are now always sRGB colors, previously some colors were device colorspace

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

How would you rate SQLEditor app?

22 Reviews of SQLEditor

5
Drtyrell969
23 August 2010
Version: 1.6.5

Most helpful

This product is instrumental in designing but also communicating to your clients what it is you've done. I highly recommend this software at any cost. A picture is worth a saved day. I use this product religiously.
(2)
4.5
angijordan
23 February 2018
Version: 3.3.0
For me it is useful app without any bugs
(0)
ylluminate
27 September 2016
Version: 3.1.4
How are Rails migrations handled?
(0)
4
LuxLogica
19 March 2016
Version: 2.9.17
Solid app, allowing you to draw ERD diagrams, which get reliably translated into the native script language - SQL or otherwise - of several databases, including: MySQL, PostgreSQL, SQLite, Filemaker, Rails and Django. Able to also connect to several databases and create the ERD diagram on-the-fly, thereby making it somewhat easier to reverse-engineer the data design of existing systems. These features alone make it worth the money.

I will deduct 1 star, however, because the developer has been announcing version 3 for well over a year, making existing users fearful that development has been abandoned. Also, although it is a solid data design tool, it is seriously lacking in the graphics department: the user is given very little control over the graph's appearance - it is impossible to even change the font used in the graphs, let alone change stroke and background colours. More polish on the interface is still needed, as it still looks like a java app programmed by a newbie.

PROS: solid ERD diagramming tool, which reliably produces good database scripts - in SQL as well as in other languages - which is directly usable in a variety of systems.
CONS: very little graphics configuration options - your graphics will all look like java charts from the 1990's. Interface needs polish.
(2)
harrypeter175
03 March 2016
Version: 2.9.17
This is very useful for me which is about SQLEditor. I am a student of computer science and SQL is my favorite book to do practice related to database. This full website contains a large collection of stuff which is very useful for all of us. Buy our best safety flooring from http://safetyflooringco.co.uk/safety-flooring.html
(0)
Show comment (1)
Macbookpro
27 February 2015
Version: 2.9.7
FYI from the Company web page... "SQLEditor 3 is coming soon Buy now and get a free upgrade when it is released"
(0)
5
Drtyrell969
11 July 2014
Version: 2.8.4
I'm just chiming in to reaffirm my 5-star rating four years since my last rating. Best product of its kind. GET!
(0)
5
Kris-nx
25 May 2013
Version: 2.1.3
Great program and support. The latest release would not launch and the support I received from the developer was excellent -very responsive and got me a version of the program that worked. He also got the latest build working within a week. Turned out to be a JAVA issue. I highly recommend this program.
(1)
5
Drtyrell969
23 August 2010
Version: 1.6.5
This product is instrumental in designing but also communicating to your clients what it is you've done. I highly recommend this software at any cost. A picture is worth a saved day. I use this product religiously.
(2)
5
Trashie
26 February 2010
Version: 1.6.1
Great application and made in Scotland of all places. Very good, very stable. Another little hidden gem on osx.
(0)
barefeettom
06 March 2008
Version: 1.4b19
I tested SQLEditor with an SQLite database. It imported the table structures fine, using the appropriate driver. After playing with it a bit, I realize that SQLEditor only shows relationships between tables that are set up as a "foreign key" within the tables. SQLite (and I think others) don't have a foreign key parameter for fields within tables. I set up relationships in SQLite within views. Unfortunately, SQLEditor does not appear to show views or the relationships tat they contain. So it seems of little use to show or edit the structure of my SQLite databases.
(0)
Show comments (2)
5
Kiddailey
01 March 2008
Version: 1.4b19
Just thought I'd post an updated comment because my original one below is a bit outdated. I've been using this for years now, and it is by far the best ER diagramming tool I've used on OS X or Windows. Everything is straight-forward. You don't have to hover over buttons to figure out what they do and most of the work takes place in the canvas area (and optionally, the inspector) keeping you from having to constantly return to a toolbar or menu. The layout tools are simple. Color, notes and canvas areas make it easy to organize and group segments, types and blocks of entities around the work area. Printed output is fantastic and you can turn on page-breaks as well, enabling you to move objects to fit on individual sheets just as you want. Import and export tools are awesome, and being able to see the raw query as you work is handy. I use it for both MS SQL and MySQL. Though it doesn't (yet?) come configured to diagram for MS SQL Server, it is fairly trivial to get it configured for it in terms of diagramming. For MySQL and a few others, it's perfect out of the box. The developer is responsive and the software is actively maintained. For any serious DB architect on the Mac, this is worth every penny.
(0)
4.25
Silverdr
25 November 2006
Version: 1.3
I have to admit that the app is quickly entering maturity stage and may well be one of the quite popular among database design enabled OS X users. The recent version even managed to properly read-in and parse my hand-made DDL with lots of nasty things inside ;-) I still have some doubts concerning the data types, which could be more aligned to what the (chosen?) RDBMS supports but this is in no way a show-stopper. The author is supportive, reacts to bug reports and suggestions quickly and efficiently. Price, while not cheap is quite moderate and IMHO not too high.
(0)
4.5
Anonymous
21 October 2004
Version: 1.0CB11a
Excellent, excellent, excellent! This great ER Diagramming tool just keeps getting better with every release. It's got the basic functions for creating simple diagrams that can be exported to a few different SQL formats. It doesn't easily allow you to specify field lengths, and it's got a few minor bugs, but otherwise it's a great tool.
(0)
Anonymous
19 October 2004
Version: 1.0CB11a
I guess I should just download it and have a look, but... what databases does it support (the review kinda misses that !) I have a remote SQL Server database (actually it runs inside a VPC session on my Mac) and a native MySQL database that I need to develop against... one tool that can do that (so I don't have to go into Enterprise Manager) would be great....
(0)
Show comments (2)
Anonymous
15 October 2004
Version: 1.0CB11a
For yet another alternative see www.mludi.net/YourSQL/!
(0)
Show comment (1)
Anonymous
15 October 2004
Version: 1.0CB11a
For an alternative see DataWerkz by www.uwerkz.com!
(0)
Anonymous
29 September 2004
Version: 1.0CB9
To the Anonymous post below: You mean inferior like your "inferrior" spelling ability? Wake up man, MySQL resources have been available for the Mac for some time and you can't be dumb enough to knock MySQL (or are you?). The MySQL database server is the world's most popular open source database. With more than five million active installations, MySQL has quickly become the core of many high-volume, business-critical applications. Customers such as Yahoo!, Google, Cisco, Sabre Holdings, HP and NASA are realizing significant cost savings by using MySQL's high performance, reliable database management software to power large Web sites, business-critical enterprise applications and packaged software applications. And, by the way, don't knock Macs because 'MonopolySoft' doesn't port their software to other platforms. Don't kid yourself, Macs can certainly handle it.
(0)
Show comments (2)
Anonymous
03 August 2004
Version: 1.0CB5
Hate to say it but until there is an application equal to Microsofts SQL Enterprise Manager the Mac will always be inferrior on the Database side. Shoot I'd settle for Access for Mac for small local DB's. :-( File Maker is a joke & at least Access can do a good job of administering SQL Server Databases.
(0)
Show comments (6)
3.5
Ebushohio
15 March 2004
Version: 1.0b7
I agree with many of the other reviewers that this is a good-to-great start. Some of the things I would like to see from a designers/DBA perspective would be: - ability to change the relationship style to Crow's Feet or at least directional relationship (The F for foriegn key is good, but I would like it to be visible in the relationship. - ability to set cardinality and referential integrity on relationships - ability to set indexes on a table - ability to add views (denoted differently from tables) - ability to add stored procedures - ability to add triggers (when available... see theme comment below) - ability to separate items into multiple SQL sections (e.g. primary keys, foreign keys, procedures, views, etc with ADD/DROP functions being an option). This would drive how the SQL was written and nicely divide (if the user wanted to) constraints from structure, adds, drops, etc. - ability to specify more data types at the application level instead of having to type those in. - ability to set a "theme" for the type of SQL database that would be written to (e.g. MySQL, SQL Server, Oracle, etc.) this would drive optimizations in the SQL in the future. This isn't quite where I could use it yet, but for a 1.0 release and a good set of features to get started, it is something I don't have a Mac tool for this functionality yet. Especially one that writes out SQL. I hope my comments are read as suggestions to improve the product and hopefully drive future features so that you are encouraged to continue development.
(0)
4.25
Wranglertx
21 February 2004
Version: 1.0b6
Very interesting implementation. Several "wish-list" items include: - ability to set id field to "auto-increment" - ability to re-sort field order by dragging - selection of field type by typing the first characters and having the selection "auto-fill" (e.g., typing "var" auto-completes "VARCHAR(255)"). - ability to designate a field for indexing and full-text indexing Would be wonderful to see in a later version the ability to diagram and existing database live, and after changes are made, to have those implemented to the database.. but that's for a later day, eh? Nice first effort, indeed!
(0)
4
Anonymous
21 February 2004
Version: 1.0b6
Looking good for a first release - Mac OS X really needs something like this. Not quit 1.0 level yet though, feels more like somewhere around 0.5. That said, looks very promising.
(0)
5
Anonymous
21 January 2004
Version: 1.0b5
Excellent! This is a very promising start for a visual database schema editor. Sure it's a beta and some features are not yet implemented, but what is working is doing so well for me so I'm giving it a 5 stars for the feature set as it exists on this version. I'm using it without problems on 10.3.2.
(0)