I'm looking for a Mac app that has capabilities similar to Microsoft SQL Server Enterprise Manager.

The app should be capable of the following:

  • Create and administer SQL Server databases, objects, logins, users, and permissions
  • Define and execute SQL Server administrative tasks
  • Design and test SQL statements, batches, and scripts

Is an app like that available today?


Navicat offers a few products that can connect and manager a MSSQL Server. Their apps are available on the Mac App Store as well.

I have used their MySQL edition, as well as their lowest-cost option, Essentials (I think they used to have a free version).

While I haven't used it for all of the items you have below, it was great for some simple table management tasks.

| improve this answer | |

You may like SQLPro for MSSQL. (You can also get a trial at our website)

The app has a few neat features such as:

  • Syntax highlighting.
  • Intellisense.
  • Tabbed based interface.
  • Support for executing multiple queries at once.
  • Quick access to tables, columns and more.
  • Stored procedure execution.

Disclaimer: I'm the developer.

| improve this answer | |
  • @Zanox Hi, does your app allow us to create a local MS SQL database on our mac OS X? Or do you know of any software or ways to create a MS SQL database on a mac to be used locally only? – RǢF Feb 5 '15 at 20:39
  • @RǢF, the app allows you to connect to a MSSQL server. It sounds like your looking to HOST a MSSQL server on OS X which I do not know of a way to do so. – Kyle Feb 6 '15 at 15:07

Froq supports multiple databases including SQL Server. I have used this app for Oracle and really like it. Can't speak to specifics of SQL Server support.

The author is also very responsive.

| improve this answer | |

There is SQuirreL SQL which is cross-platform. It works great and supports so many data bases including SQL Server.

It's Open source and free.

| improve this answer | |
  • 1
    Last I checked, Squirrel's supporting plugin for MSSQL did not work at all. Did they fix it? – Priyeshj Sep 12 '14 at 19:01
  • @Priyeshj Yes I have heard now its working good – Durai Amuthan.H Sep 13 '14 at 6:26
  • 1
    I tried just now, and the Microsoft MSSQL Server Driver doesn't seem to work for me out of the box (with the plugin installed). Moreover, it doesn't use the KeyChain on MAC and stores passwords as plain text. So it has been a turn off for me. Switched over to SQL Client, and it works like a charm. – Priyeshj Sep 15 '14 at 18:45
  • 2
    SQL Client costs $20 after trial ends. It is worth it when cutting the time I used to try all the other free options out. – Priyeshj Sep 16 '14 at 18:06
  • 1
    @Priyeshj Thanks for pointing out SQL Client I'll try – Durai Amuthan.H Sep 17 '14 at 6:51

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .