Developer: Hankinsoft Development Inc

Current Version: 2020.82

Last Updated: 21 hours ago

Download Size: 10.5 MB - Download


SQLPro for MSSQL is a lightweight Microsoft SQL Server database client, allowing quick and simple access to MSSQL Servers, including those hosted via cloud services such as SQL Azure or Amazon RDS.

Features include:
+ Syntax highlighting (including customizable themes).
+ Intellisense.
+ Tabbed based interface.
+ Support for executing multiple queries at once.
+ Quick access to tables, columns and more.
+ Stored procedure execution.
+ NTLMv2 supported (but not required).

SQLPro for MSSQL can be used to connect with the following databases:
+ Microsoft SQL Azure
+ Microsoft SQL Server 2005
+ Microsoft SQL Server 2008
+ Microsoft SQL Server 2008 R2
+ Microsoft SQL Server 2012
+ Microsoft SQL Server 2014
+ Microsoft SQL Server 2016

Thanks to the FreeTDS project (http://www.freetds.org/) for their great library.

This SQL Client does NOT work with MySQL or Postgres. Please ensure that your server is a Microsoft SQL Server (2005 or above).

Note 1: SQL Server Express is supported, however using it makes me sad. Please confirm that the SQL Server Express installation has been configured properly for remote connections over TCP/IP, and that you can connect remotely from another windows pc before requesting support.

Note 2: SQLPro for MSSQL can connect to Microsoft SQL Server 2000 however it is not supported.

Privacy Policy:

Terms of Use:

SQLPro offers Premium subscriptions in order to interact with database result sets. Premium subscriptions are available as either a Monthly, or a Yearly duration. Subscriptions auto-renew within 24 hours of the expiration date unless auto-renewal is turned off in the iTunes account settings. Payment will be charged to your iTunes Account at confirmation of purchase.


Release Notes:

+ Fixed an issue that could cause a crash when inserting/duplicating rows, deleting rows, then cancelling actions together on the results grid.
+ Added the common enter/exit full-screen keyboard shortcut. [#497](https://github.com/hankinsoft/SQLPro/issues/497).
+ Multi-cursor improvements. Cmd+Delete and Opt+Delete now work properly.
+ Fixed an issue where tables with periods were not handled properly. [#496](https://github.com/hankinsoft/SQLPro/issues/496)
+ Keyboard support added for selecting multi-cursors. Cmd+Option+Up/Down arrows.
+ Fixed a few crashes which could occur with multi-cursors.
+ Improved pasting with multi-cursors.
+ Fixed an issue when inserting rows where the string 'default' could sometimes be used rather than the default value.


Most Helpful Reviews

Version 1.0.308
Review by Ajkoop

Love This App - I'm a veteran programmer coming from a unix/linux background. I took a windows-based job, which forced me to work almost entirely with SQL server. I can do nearly all of my dba work that I need to on a daily basis in this app. There are a few things I can't do in the same way such as creating SQL server agent jobs, but those are outside of my daily work. This app saves me a ton of time on a daily basis, because a) I don't have to log-into a virtual machine to do my work and b) it performs far faster than MMSQL on Windows in my experience. Especially in dark mode, it is simply far easier on my eyes as well.

Found helpful by 19 out of 20 people
Version 1.0.6
Review by Yogibearded

Doesn’t connect. Useless software. Save yourself trouble - Doesn’t read server name or ip address. It doesn’t even provide an error or feedback as to what’s wrong so you can correct. After spending 8.99 and half an hour of time trying to make it work, I gave. So spare yourself the trouble and go with DBVis or Navicat

Found helpful by 4 out of 13 people