We stand with Ukraine to help keep people safe. Join us
SQLEditor
SQLEditor
4.5
0.0
SQLEditor free download for Mac

SQLEditor

Version 3.7.7

Create SQL databases graphically.

4.5
Based on 16 user ratesRead reviews & comments
$79.00
One-Time Purchase
Buy Now

SQLEditor 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 version 3.7.7

Updated on Sep 28 2021

Version 3.7.7:
  • Fix for launch issue on Apple Silicon M1 macs

Information

License

Shareware

Size

70.8 MB

Downloads

60225

App requirements

  • Intel 64
  • Apple Silicon
  • OS X 10.10 or later
Try our new feature and write a detailed review about SQLEditor. All reviews will be posted soon.

Write your thoughts in our old-fashioned comment

MacUpdate Comment Policy. We strongly recommend leaving comments, however comments with abusive words, bullying, personal attacks of any type will be moderated.
0.0

(0 Reviews of )

There are no reviews yet
  • Comments

  • User Ratings

angijordan
angijordan
Feb 23 2018
3.3.0
4.5
Feb 23 2018
4.5
Version: 3.3.0
For me it is useful app without any bugs
ylluminate
ylluminate
Sep 27 2016
3.1.4
0.0
Sep 27 2016
0.0
Version: 3.1.4
How are Rails migrations handled?
LuxLogica
LuxLogica
Mar 19 2016
2.9.17
4.0
Mar 19 2016
4.0
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.
harrypeter175
harrypeter175
Mar 3 2016
2.9.17
0.0
Mar 3 2016
0.0
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
Macbookpro
Macbookpro
Feb 27 2015
2.9.7
0.0
Feb 27 2015
0.0
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"
Drtyrell969
Drtyrell969
Jul 11 2014
2.8.4
5.0
Jul 11 2014
5.0
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!
Kris-nx
Kris-nx
May 25 2013
2.1.3
5.0
May 25 2013
5.0
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.
Drtyrell969
Drtyrell969
Aug 23 2010
1.6.5
5.0
Aug 23 2010
5.0
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.
Trashie
Trashie
Feb 26 2010
1.6.1
5.0
Feb 26 2010
5.0
Version: 1.6.1
Great application and made in Scotland of all places. Very good, very stable. Another little hidden gem on osx.
barefeettom
barefeettom
Mar 6 2008
1.4b19
0.0
Mar 6 2008
0.0
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.
Kiddailey
Kiddailey
Mar 1 2008
1.4b19
5.0
Mar 1 2008
5.0
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.
silverdr
silverdr
Nov 25 2006
1.3
4.3
Nov 25 2006
4.3
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.
Guest
Guest
Oct 21 2004
1.0CB11a
4.5
Oct 21 2004
4.5
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.
Guest
Guest
Oct 19 2004
1.0CB11a
4.5
Oct 19 2004
4.5
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....
Guest
Guest
Oct 15 2004
1.0CB11a
4.5
Oct 15 2004
4.5
Version: 1.0CB11a
For yet another alternative see www.mludi.net/YourSQL/!
Guest
Guest
Oct 15 2004
1.0CB11a
4.5
Oct 15 2004
4.5
Version: 1.0CB11a
For an alternative see DataWerkz by www.uwerkz.com!
Guest
Guest
Sep 29 2004
1.0CB9
4.5
Sep 29 2004
4.5
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.
Guest
Guest
Aug 3 2004
1.0CB5
4.5
Aug 3 2004
4.5
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.
Ebushohio
Ebushohio
Mar 15 2004
1.0b7
3.5
Mar 15 2004
3.5
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.
Wranglertx
Wranglertx
Feb 21 2004
1.0b6
4.3
Feb 21 2004
4.3
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!
Ervins Strauhmanis
Ervins Strauhmanis
Oct 25 2018
5.0
Oct 25 2018
5.0
Version: null
angijordan
angijordan
Feb 23 2018
4.5
Feb 23 2018
4.5
Version: null
LuxLogica
LuxLogica
Mar 19 2016
4.0
Mar 19 2016
4.0
Version: null
Drtyrell969
Drtyrell969
Jul 11 2014
5.0
Jul 11 2014
5.0
Version: null
luispa
luispa
Jun 16 2014
4.0
Jun 16 2014
4.0
Version: null
Ronman
Ronman
May 30 2013
5.0
May 30 2013
5.0
Version: null
Kris-nx
Kris-nx
May 25 2013
5.0
May 25 2013
5.0
Version: null
Terryr
Terryr
Jan 10 2012
3.0
Jan 10 2012
3.0
Version: null
http
http
Aug 2 2011
5.0
Aug 2 2011
5.0
Version: null
LucasH
LucasH
Apr 26 2011
5.0
Apr 26 2011
5.0
Version: null
Trashie
Trashie
Feb 26 2010
5.0
Feb 26 2010
5.0
Version: null
Kiddailey
Kiddailey
Mar 1 2008
5.0
Mar 1 2008
5.0
Version: null
silverdr
silverdr
Nov 25 2006
4.3
Nov 25 2006
4.3
Version: null
Guest
Guest
Oct 21 2004
4.5
Oct 21 2004
4.5
Version: null
Ebushohio
Ebushohio
Mar 15 2004
3.5
Mar 15 2004
3.5
Version: null
Wranglertx
Wranglertx
Feb 21 2004
4.3
Feb 21 2004
4.3
Version: null
$79.00
One-Time Purchase
Buy Now
How would you rate SQLEditor?
Similar apps
Base
Create, design, edit, and browse SQLite 3 database files.
Is this app is similar to Base? Vote to improve the quality of this list.
Vote results
0
Upvotes
2
Total score
0
Downvotes
TablePlus
Modern, native tool for relational databases.
Is this app is similar to TablePlus? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
SQLPro for Postgres
Database management studio for Postgres.
Is this app is similar to SQLPro for Postgres? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
SQLPro for MySQL
Database management studio for MySQL.
Is this app is similar to SQLPro for MySQL? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
MySQL Workbench
Efficiently design, manage and document database schemata.
Is this app is similar to MySQL Workbench? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes