SSMS is a pure Windows Application, there is no version for Mac.
But you can use Azure Data Studio on Mac with the same (and some more) features:
Microsoft SQL Management Studio for Mac
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Hi,
Is there any Mac version for Microsoft SQL Management Studio?
Where can I get it from?
Thanks,
Jassim
SQL Server | Other
{count} votes
-
Anonymous
2023-05-04T06:02:18.6933333+00:00 Hi @Jassim Al Rahma
Has your issue been resolved? Please checking in to see if the below suggestions helped. If this answers your query, do click
Accept AnswerandUp-Votefor the same. And, if you have any further query do let us know.Best regards,
Aniya
-
Anonymous
2023-05-05T08:47:03.28+00:00 Hi @Jassim Al Rahma
Did these answers help you? If the answer is useful, please click
Accept Answerto let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.Best regards,
Aniya
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 2%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZN%3C/text%3E%3C/svg%3E)
ÖZGÜN TEKSOY 5 Reputation points2024-02-11T17:10:40.0766667+00:00 Hello, I use azure because I use Mac but I have a problem. How can I open the .bak file in Mac?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 48%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Yong Shao 0 Reputation points2024-02-28T22:04:44.5033333+00:00 I installed Azure data studio on my mac, but cannot connect to MS Fabric lakehouse SQL endpoint. Anyone knows how? thank you in advance
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 9%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deny Dermawan Sabri 0 Reputation points2024-06-13T04:02:16.62+00:00 How to draw erd based on implemented data structure using azure data studio as ssms do?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 30%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hitesh81 1 Reputation point2024-07-04T09:03:49.37+00:00 Azure Data Studio is not comparable to SSMS
MS is blocking all Data management /scripts generation etc on Azure Data Studio
SSMS runs only on windows, I am not sure why they cant build one for Mac and 64-bit these days.
dacpac/bacpac might be good but they are flaky and not suitable.
or atleast they should release extension with all features of SSMS to Azure Data Studio
Sign in to comment
Answer accepted by question author
-
Olaf Helper 47,616 Reputation points2023-04-27T10:17:23.64+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 97%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Akash kr. sinha 0 Reputation points2024-03-21T09:22:19.9066667+00:00 Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server)
for mac m2 chip
i am unable to fix this error, help me
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 80%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVE%3C/text%3E%3C/svg%3E)
Vlček Josef 0 Reputation points2025-02-25T10:16:15.6833333+00:00 If ADS or VSC have same functionality as SSMS, how can I run tasks -> generate script. I use it a lot on SSMS, but cant find it in ADS or VSC. For ADS, there is a plugin for that, but it seems only for Windows.
So is there a way to generate insert scripts with data in ADS or VSC?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 67%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jarle F 0 Reputation points2025-03-26T11:01:40.91+00:00 And now? Microsoft is retiring Azure Data Studio next year and claiming users should use an inferior product like VS Code with more advanced features only being available in SSMS.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 26%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Sign in to comment -
4 additional answers
Sort by: Most helpful
-
Anonymous
2023-04-28T06:06:56.1533333+00:00 Hi @Jassim Al Rahma
You can check this link to see the operating systems currently supported by SSMS: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16#ssms-system-requirements.
As Olaf and Rahul say, if you need tools that run on operating systems other than Windows, we recommend Azure Data Studio.
If these answers are helpful, please click
Accept AnswerandUp-Votefor the same. If you have any questions, please feel free to let us know.Best regards,
Aniya
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive 10,506 Reputation points Volunteer Moderator2023-04-27T11:38:49.3866667+00:00 Thanks for your question.
As per Microsoft document, https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
SSMS is available only as a 32-bit application for Windows. If you need a tool that runs on operating systems other than Windows, we recommend Azure Data Studio. Azure Data Studio is a cross-platform tool that runs on macOS, Linux, and Windows. For details, see Azure Data Studio.
Please let us know if you need any additional information.
Thank you.
-
Anonymous
2023-04-27T14:10:25.3433333+00:00 I tried the Azure Data Studio but when I create a connection it's asking me to Create a New firewall rule and then when I click on Add an Account I get the following error
-
RahulRandive 10,506 Reputation points Volunteer Moderator
2023-04-27T14:56:11.9033333+00:00 The account which you are using to login has multiple tenants in Azure?
Can you please try login with SQL Server admin account.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 76%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Basem Mahmoud 0 Reputation points2023-08-15T09:39:40.8266667+00:00 Azure data studio doesn't have all features as Export database as SSMS.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 77%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jeff Tucker 100 Reputation points2025-04-22T13:17:37.1233333+00:00 I know this is an old post, but just commenting that Azure Data Studio is now retiring, and I believe the suggest is to use VS Code instead. As of right now though, the VS Code SQL connector is a bit buggy. Hopefully that gets improved soon!
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 26%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Alek Kowalczyk 0 Reputation points2026-02-04T10:39:14.42+00:00 Since Azure Data Studio is being retired, another option worth mentioning is https://jamsql.com — a native macOS desktop app built specifically for working with SQL Server (including Azure SQL).
It covers a lot of what people in this thread have been asking for: query editor with IntelliSense, table explorer, schema compare, execution plans, and scripting — without needing a VM or Windows.
Disclosure: I'm the creator of Jam SQL Studio.
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more