Guide

SSMS for Mac: is there one, and what to use instead

SQL Server Management Studio does not run on macOS, and Azure Data Studio is retired. Here is what Mac users do now.

By Updated 7 min read

Short answer

No, there is no SSMS for Mac: Microsoft says SSMS is available only for Windows. Azure Data Studio was retired on Feb 28, 2026. Microsoft recommends VS Code with the MSSQL extension. DataGrip, DBeaver and TablePlus also work.

On this page
  1. Is there a version of SSMS for Mac?
  2. What did Microsoft recommend instead of Azure Data Studio?
  3. What are your options for SQL Server on a Mac?
  4. How do you set up VS Code for SQL Server on a Mac?
  5. Can you run SSMS in a Windows VM on a Mac?
  6. Can you run SQL Server itself on a Mac with Docker?
  7. Which option should you pick?

The short version

  • There is no SSMS for Mac. Microsoft’s FAQ says “SSMS is available only for Windows” (Microsoft Learn).
  • The current release is SSMS 22.12.0, dated Nov 10, 2026 (release notes). It supports Windows 11, including Arm64, and Windows Server 2019 to 2025.
  • Azure Data Studio retired on Feb 28, 2026. Microsoft recommends VS Code with the MSSQL extension (Microsoft Learn).
  • The MSSQL extension supports macOS on Intel and Apple Silicon, and it is free (Microsoft Learn).
  • Microsoft supports SQL Server containers only on x86-64 Linux hosts, and says Rosetta 2 and QEMU emulation are “not tested or supported” (Microsoft Learn).
  • Three paid or free third-party clients cover SQL Server on Mac: DataGrip at $109 for year one, DBeaver Community at $0 and TablePlus at $99 one-time, checked Nov 17, 2026.

There is no SSMS for Mac. SQL Server Management Studio, the free Microsoft tool for administering SQL Server, runs only on Windows. This guide is part of our SQL editors compared section. It covers what Mac users should install instead, in order of fit, and what you give up.

Azure Data Studio is not the answer anymore

Older guides tell Mac users to install Azure Data Studio. Microsoft retired it on Feb 28, 2026. It no longer receives updates or security fixes, so do not start a new setup on it.

Is there a version of SSMS for Mac?

No. Microsoft’s SSMS FAQ asks “Does SSMS run on macOS?” and answers “No. SSMS is available only for Windows.” The system requirements page lists the supported systems for SSMS 22: Windows 11 (Home, Pro, Enterprise and more, including Arm64 editions) and Windows Server 2019, 2022 and 2025. macOS and Linux are not on the list (system requirements).

SSMS is free for personal or enterprise use. Our dataset records it as SSMS 22.12.0, a native Windows app built on the Visual Studio shell. The real question is which tool does the job you used SSMS for.

What did Microsoft recommend instead of Azure Data Studio?

Microsoft’s retirement page is direct: “Migrate to Visual Studio Code with the MSSQL extension for continued support.” It says existing queries, scripts and database projects work in VS Code without conversion. For SQL Server Agent jobs and full administration, Microsoft keeps SSMS as the “supported home” (Microsoft Learn).

A user on r/SQL described the old path failing: they had installed SQL Server through Docker and Azure Data Studio on a Mac and could not get a connection working (paraphrased user report). If you are in that spot, the steps below are the current route. If you want more than Microsoft’s pick, see our Azure Data Studio alternatives.

What are your options for SQL Server on a Mac?

Here they are in order of fit for most people.

Free option License Runs on Databases
VS Code + MSSQL extension Free Yes MIT (extension) Windows, macOS, Linux SQL Server No
DataGrip Commercial $109/user/yr No
30-day trial
Proprietary Windows, macOS, Linux PostgresMySQLSQL ServerOracleSQLiteSnowflake+6 No
DBeaver Community Free Yes Open source (Apache 2.0) Windows, macOS, Linux PostgresMySQLSQL ServerSQLiteMariaDBOther No
TablePlus $99 one-time No
Free trial limited to 2 tabs, 2 windows, 2 advanced filters
Proprietary Windows, macOS, Linux PostgresMySQLSQL ServerOracleSQLiteSnowflake+6 Yes
SQLPro Studio $99.99/user/yr No
Free trial; free first year for students
Proprietary macOS, Windows MySQLMariaDBPostgresRedshiftSQL ServerSQLite+2 Yes

Prices from each vendor’s own pricing or download page, checked 2026-11-17. List price for one commercial user, before tax and volume discounts. How we research · Full SQL client price index

Source: vendor pages and Microsoft Learn, checked Nov 17, 2026. All five list SQL Server support.

1. VS Code with the MSSQL extension

This is Microsoft’s own answer. The extension is free (MIT licensed) and supports macOS on Intel and Apple Silicon, plus Windows and Linux. It includes IntelliSense, a results grid, query plans, a table designer, schema compare and a local container feature. It targets SQL Server, Azure SQL Database, Azure SQL Managed Instance and SQL database in Fabric. Microsoft says SQL Server Agent jobs and classic administration stay in SSMS.

2. DataGrip

JetBrains’ IDE connects to SQL Server along with a dozen other databases. It costs $109 for the first year as an individual, $87 for the second and $65 from the third (checked Nov 17, 2026). The free offer covers individual, non-commercial use only. It is the best choice if you write a lot of T-SQL and also touch other databases. See DataGrip alternatives for cheaper options.

3. DBeaver Community

Free and open source (Apache 2.0). The download page lists a macOS Apple Silicon DMG for version 26.2.5. It lists SQL Server among its databases, but it is a general tool, so it will not match SSMS for administration. The DBeaver alternatives page covers what to try if it feels heavy.

4. TablePlus and other paid clients

TablePlus is a native Mac app for $99 one-time per device and lists SQL Server among its 23 databases. SQLPro Studio, another native Mac app, also lists SQL Server ($99.99 per year or $219.99 lifetime for one platform). Neither is an SSMS replacement for administration. They suit people who mostly run queries. See TablePlus vs DBeaver if you are choosing between those two.

How do you set up VS Code for SQL Server on a Mac?

These steps follow Microsoft’s documentation.

  1. Install Visual Studio Code for macOS.
  2. Open the Extensions view with Cmd+Shift+X and search for mssql.
  3. Select SQL Server (mssql) and click Install. The MSSQL icon appears in the Activity Bar and the Connections view opens when it works.
  4. Choose Add Connection. Enter the server name, database, and login, or paste a connection string, or browse your Azure account.
  5. Open a new SQL file, pick the connection, and run your query.
SELECT @@VERSION AS server_version;

If you do not have a SQL Server to connect to, the extension can create one for you. Choose Create local SQL Container in the Connections view. It needs Docker Desktop or an equivalent running in Linux container mode, and it pulls SQL Server 2025 by default. Microsoft says local containers are for development only, and that SQL Server needs at least 2 GB of memory to start a Linux container.

Can you run SSMS in a Windows VM on a Mac?

Yes, with limits. Microsoft says SSMS runs in a virtual machine as long as it is a full, persistent Windows operating system. SSMS supports Windows 11 on Arm64, which is what a VM on an Apple Silicon Mac runs.

Parallels’ knowledge base says SSMS “can be easily installed and run in a Windows 11 VM.” The catch is the server. The same article says SQL Server “doesn’t yet run in Windows 11 on a Mac with Apple silicon” and gives two workarounds. One is running SQL Server in an Ubuntu VM with emulation turned on, then connecting from SSMS using the Ubuntu VM’s IP address and port. That route needs a Parallels Desktop Pro or Business subscription. The other is SQL Server Express LocalDB, which works with a Standard license but cannot be managed remotely from SSMS. The KB also says SQL Server 2025 can be installed in Windows 11 without issues; we have not checked that claim ourselves.

So a VM works best when your SQL Server lives elsewhere, such as a server at work or Azure SQL. It adds a second operating system to maintain. If you only need queries, VS Code is lighter.

Can you run SQL Server itself on a Mac with Docker?

You can try, but Microsoft does not support it on a Mac. Its Docker quickstart says SQL Server container images are supported only on Linux hosts on Intel and AMD x86-64 CPUs, and that “emulation or translation environments (for example, Rosetta 2, Prism, or QEMU) aren’t tested or supported.” Microsoft does not list macOS as a host, so a Mac setup is outside that support statement. The image Microsoft documents is mcr.microsoft.com/mssql/server:2025-latest, and on Apple Silicon you rely on emulation without Microsoft’s backing.

For a throwaway development database, that may be acceptable. For anything you care about, point your Mac client at a SQL Server on Windows, Linux or Azure instead. If you hit emulator problems, Microsoft directs reports to the mssql-docker GitHub repository.

Which option should you pick?

Your situationPickWhy
SQL Server and Azure SQL onlyVS Code + MSSQLFree, Microsoft-supported on macOS
T-SQL plus several other databasesDataGripIDE, many databases
Free, several databasesDBeaver CommunityApache 2.0, Apple Silicon DMG
A fast native app, light adminTablePlusNative, $99 one-time
Agent jobs, security, performance dashboardsSSMS in a Windows VM, or a Windows PCThe tasks Microsoft keeps in SSMS

Source: Microsoft Learn and vendor pages, checked Nov 17, 2026.

My own pick: start with VS Code and the MSSQL extension. It costs nothing, Microsoft maintains it, and it covers most day-to-day query work. If it feels thin, move to DataGrip or TablePlus. Our wider best SQL editor roundup and best SQL client for Mac page compare the rest, and DataGrip vs DBeaver helps if you are deciding between the two big general tools.

Questions people ask

Is there a SQL Management Studio for Mac?

No. Microsoft answers this in the SSMS FAQ: "SSMS is available only for Windows." SSMS 22 supports Windows 11 (including Arm64) and Windows Server 2019, 2022 and 2025. On a Mac, use the MSSQL extension for VS Code, DataGrip, DBeaver or TablePlus (Microsoft Learn, checked Nov 17, 2026).

Can I run SSMS on a Mac with Parallels?

Yes, inside a Windows 11 virtual machine. Parallels says SSMS "can be easily installed and run in a Windows 11 VM." SQL Server itself does not run natively there on Apple silicon, so the KB suggests running it in an Ubuntu VM and connecting from SSMS.

Is there a SQL Server client available for macOS?

Yes. Microsoft supports the MSSQL extension for VS Code on macOS, Intel and Apple Silicon. Third-party clients that list SQL Server include DataGrip ($109 first year), DBeaver Community (free) and TablePlus ($99 one-time), all checked Nov 17, 2026. See our best SQL client for Mac picks.

What replaced Azure Data Studio?

Microsoft says to migrate to Visual Studio Code with the MSSQL extension. Azure Data Studio was retired on Feb 28, 2026 and no longer gets updates or security fixes. Microsoft says queries, scripts and database projects work in VS Code without conversion.

Can I run SQL Server on a Mac with Docker?

Microsoft supports SQL Server container images only on Linux hosts running on Intel and AMD x86-64 CPUs. It says emulation such as Rosetta 2 or QEMU is not tested or supported. Many Mac users run it anyway for development, but you do it without a Microsoft guarantee.

What is the best SQL editor for Mac?

For SQL Server specifically, VS Code with the MSSQL extension. For several databases, TablePlus is the native pick and DBeaver Community is the free one. We compare them in best SQL editor.

Sources

  1. SSMS frequently asked questions (Microsoft Learn) ·
  2. System requirements for SQL Server Management Studio (Microsoft Learn) ·
  3. Release notes for SSMS 22 (Microsoft Learn) ·
  4. What is happening with Azure Data Studio (Microsoft Learn) ·
  5. MSSQL extension for Visual Studio Code (Microsoft Learn) ·
  6. Local SQL Server container in the MSSQL extension (Microsoft Learn) ·
  7. Docker quickstart for SQL Server on Linux (Microsoft Learn) ·
  8. Parallels KB: Microsoft SQL Server on a Mac with Apple silicon ·
  9. Reddit r/SQL: Those who use a Mac, what platform do you use for SQL? ·

Start hereBest SQL editor

Open