SQLPro Studio is the premium database management tool for Postgres, MySQL, Microsoft Management Studio and Oracle databases.
Some of the great features include:
+ Intellisense/SQL autocompletion.
+ Syntax highlighting with customizable themes (including dark).
+ Tabbed based interface for an optimal user experience.
+ Context aware database tree navigation, including quick access to tables, views, columns, indexes and much more!
+ SQL Beautifier/formatter.
+ Database wide searching.
+ NTLMv2 supported (but not required).
+ Netbios support.
+ Master password support for additional security.
SQLPro Studio supports the following database servers:
+ MySQL & MariaDB
+ Microsoft SQL Server (2005 and above)
+ Oracle (8i and above)
+ A few Mojave improvements.
Ratings and Reviews
Highly recommended. This program has a very elegant interface, is stable and has searchable tab history similar to sql prompt by redgate. It has a few nice dark themes that apply in a few clicks. I prefer having it right on the mac desktop rather than remoting into another computer and working in ssms.
Does everything I need except export
I purchased this to be able to manage all the different databases that I have to develop against.
The SSH tunneling feature is very valuable, elimnating manual tunneling to production systems.
The only missing piece for me is to generate exports for importing into another system.
If it’s there I can’t find it.
Repeatedly Get Permissions Error
The app is ok. Haven’t hit any unsurmountalbe issues as of yet, although I come across one issue frequently (i.e. about once per day).
When I’m writing a new query and trying to save as a .sql file locally an error pops up saying I do not have permission to save to my file system. I am an admin on the system, and I’m not trying to overwrite an existing file that I do not have permissions to. I am simply trying to save a brand new file.
I have to force quit the app (so I don’t lose the SQL) or copy/paste the SQL into a text editor and relaunch the app and try to save again. At least one other person on my team suffers from the same issue.
Would love to have that resolved!
With Family Sharing set up, up to six family members can use this app.