Whether your databases run in the cloud, on windows, on macos, or on linux, your tool doesnt need to run on the same platform as the database. Heres how to get started coding with sql on the mac. Microsoft does not make a native mac port of sql server express. Download microsoft sql server 2012 native client qfe. The database driver should be free if possible, paid solutions can be ok as well. Sqlpro for mssql navicat valentina studio tableplus. The microsoft sql server 2012 native client is available as part of microsoft sql server 2012 feature pack, which is updated at each sql server 2012 service pack. Squirrel sql is a java based sql client, that ive had good experience with on windows and linux. Azure data studio sql client tools forum sql server data tools. Sqlpro for mssql is a lightweight microsoft sql server database client, allowing quick and simple access to mssql servers, including those hosted via cloud.
If that doesnt suit you, our users have ranked 30 alternatives to sql server management studio and 16 are available for mac so hopefully you can find a suitable replacement. The feedback you provide will help us show you more relevant content in the future. How to access microsoft sql server 2005 from cocoa on mac os x 10. Sqlpro for mssql, navicat for sql server, and azure data studio are probably your best bets out of the 4 options considered. The most popular mac alternative is dbeaver, which is both free and open source. Sqlpro for mssql is the premier application for editing and viewing sql server databases on mac os x. Starting with sql server 2017, you can now install sql server directly on to a linux machine.
Sql server azure sql database azure synapse analytics sql dw parallel data warehouse to manage your database, you need a tool. Sql client for mac os x that works with ms sql server max. Windows can run on a mac as a virtual machine using. Sql server management studio is not available for mac but there are plenty of alternatives that runs on macos with similar functionality. Smart code completion, onthefly analysis, quickfixes, refactorings that work in sql files, and more. It supports multiple open connections, but only one sql editor per connection. This version of azure data studio works with all supported versions of sql server 2014 sql server 2019 15.