SQL Server Client for Mac,
on Apple Silicon and Intel

Jam SQL Studio is a SQL Server client that runs on macOS itself, with separate builds for Apple Silicon and Intel Macs, so you can query and administer SQL Server, Azure SQL Database and Azure SQL Managed Instance from a Mac without a Windows virtual machine. It covers IntelliSense, execution plans, sessions and blocking, Agent jobs, Query Store, deadlock graphs, schema and data compare, backups and file import. On a Mac it does not offer Windows authentication or Kerberos sign-in and has no Profiler or Extended Events capture, and the SSIS, SSRS and SSAS tools need Windows; the table below lists each task and its limits.

On Windows or Linux? Get the Windows or Linux build

Free for personal, non-commercial use • No account required • macOS 11 Big Sur or later

What works on a Mac and what does not

Each row is a task people open SSMS for, checked against Jam SQL Studio 1.5.11 on macOS. On a Mac the app connects to SQL Server over TCP with its built-in driver, so there is no ODBC driver to install first.

SSMS taskOn a Mac in Jam SQL StudioLimitDocs
IntelliSense✓ YesCompletion, hover and syntax checking are built into the app and work the same on every systemIntelliSense
Execution plans✓ YesEstimated and actual plans, .sqlplan files and side-by-side compare; missing-index suggestions are not shownExecution plans
Sessions and blocking✓ YesSession Browser with a Blocked By column, the head blocker marked, a Locks tab and Kill; killing a session needs ALTER ANY CONNECTIONSession Browser, finding the blocking session
Agent jobs✓ Yes, in betaNeeds an edition with SQL Server Agent (Express has none); the actions offered follow your msdb roleAgent jobs
Query Store✓ YesRead-only: history, period comparison and plans; it does not force plans. SQL Server 2016 or laterQuery Store
Deadlock graphs✓ YesOpens .xdl files and reads the deadlocks the system_health session kept; Azure SQL Database has no system_health, so import onlyDeadlock Analyzer
Schema compare and data compare✓ YesBoth generate sync scripts. Personal tier: 200 objects per schema, and 10,000 rows per table for a full data compareSchema compare, data compare, data compare tools compared
.bak backup and restore, BACPACPartly.bak files are written to and read from a folder on the SQL Server machine, as in SSMS; the Personal tier backs up databases up to 1 GB. BACPAC export and import: Apple Silicon Macs onlyBackup & restore
CSV and Excel import✓ Yes, in betaCSV, TSV, TXT, Excel .xlsx and JSON into a new or existing table; the Personal tier imports up to 100,000 rows per runData Import
Windows authentication✗ NoNot offered on macOS since 1.5.11: the driver the app uses on a Mac cannot sign in as a Windows userWindows authentication
Kerberos✗ NoThe app has no Kerberos or NTLM domain sign-in on macOS; use a SQL login or Microsoft Entra IDSigning in from a Mac
Profiler and Extended Events✗ NoThe app has no trace capture and no Extended Events session editor; its Session Browser shows live sessions, locks and waits. For event capture on a Mac, use the VS Code MSSQL extension's Query ProfilerSession Browser
SSIS, SSRS and SSAS designers✗ NoNot in the app; these stay in SSMS and Visual Studio on WindowsSSMS in a Windows VM
Jam SQL Studio 1.5.11 on macOS, checked against the app's source code and documentation on 17 November 2026. Personal-tier limits are listed on the pricing page.

What Jam SQL Studio does not do on a Mac: Windows authentication, Kerberos sign-in, and Profiler or Extended Events capture. For event capture on a Mac, the VS Code MSSQL extension has a Query Profiler, which Microsoft describes as capturing database activity “in real time using Extended Events” and which “Works on Windows, macOS, and Linux”. The SSIS, SSRS and SSAS tools need Windows. SSMS can run in a Windows 11 virtual machine on the Mac, but on an Apple Silicon Mac that is Windows 11 on Arm, and Microsoft's SSMS known issues say “There's no support for SSAS and SSIS on Arm64 devices”. SSMS for Mac covers that route and what it costs.

Signing in from a Mac

On macOS the Authentication list of a SQL Server connection has three entries:

  • SQL Server authentication — a SQL login and password, stored encrypted with the connection. This is the sign-in for SQL Server in a Docker container and for any server that allows SQL logins.
  • Microsoft Entra ID (Interactive Browser) — for Azure SQL Database and Azure SQL Managed Instance; the recommended Entra mode.
  • Microsoft Entra ID (Device Code) — the same accounts, for tenants whose policy blocks the browser sign-in. Both Entra modes take an optional tenant ID.

Windows authentication is not in the list on macOS (since version 1.5.11). On a Mac the app connects with a driver that cannot sign in as a Windows user, so such a connection could only fail. A connection imported from SSMS, Azure Data Studio or VS Code, or a pasted connection string with Integrated Security=true, keeps its setting; Test connection then stops at the Authentication field until you choose SQL Server authentication or Microsoft Entra ID. The app does not support Kerberos or NTLM domain logins on macOS either, so a server that accepts only Windows logins needs a SQL login or an Entra account before Jam SQL Studio can reach it from a Mac.

Coming from SSMS: Import… reads SSMS registered servers and recent connections from a RegSrvr.xml or UserSettings.xml copied from your Windows PC (use Browse… to pick the file). Passwords are not imported. The connections docs cover encryption settings, SSH tunnels and every import source.

Running SQL Server itself on a Mac

A client is enough when the server is elsewhere: at work, on a Linux or Windows machine, or in Azure. To run SQL Server on the Mac itself you need a Linux container or a virtual machine. Microsoft's container quickstart supports its images only on Linux hosts with Intel or AMD x86-64 processors and says emulation such as Rosetta 2 is not tested or supported, so on Apple Silicon a container is a development setup. The SQL Server on macOS guide has the docker run command, the Apple Silicon settings and the virtual machine routes.

Jam SQL Studio next to other Mac clients

SSMS is available only for Windows, and Azure Data Studio, Microsoft's earlier cross-platform tool, was retired on 28 February 2026. These are the SQL Server clients a Mac user usually compares, as of November 2026. For a broader comparison beyond SQL Server, see the best SQL clients for Mac.

 Jam SQL StudioVS Code MSSQL extensionDBeaverDataGripTablePlusSSMS in a Windows VM
Apple Silicon build✓ Separate Apple Silicon and Intel builds✓ Intel and Apple Silicon✓ Apple Silicon and Intel downloads✓ Apple Silicon and Intel downloads✓ Intel and Apple Silicon, macOS 12+No macOS build; SSMS has an Arm64 build for Windows 11 on Arm in a VM
Execution plans (SQL Server)✓ Estimated and actual, side-by-side compare✓ Estimated and actualPRO editions only, not Community✓ Tree, diagram or flame graph✗ No graphical plan; requested on its GitHub tracker since 2018✓ Estimated and actual
SQL Server Agent jobs✓ Beta✗ Feature request closed as not plannedAgent jobs listed in the navigator; running or editing them is not documented✗ Not built in (JetBrains' issue is shelved); the third-party SQL Agent plugin adds itNot documented (as of November 2026)✓ Full
Schema compare✓ Personal tier: up to 200 objects per schema✓Enterprise and Ultimate only✓ Compare Structure, with a migration scriptNot documented (as of November 2026)✓ Generally available since 22.10.2
PriceFree for personal, non-commercial use; Pro $9.99/month or $99/yearFreeCommunity free and open source; Lite $113/yr, Enterprise $255/yr, Ultimate $510/yrFree for non-commercial use; $109 first year (individual), $259/yr per user (organization)$99 perpetual licence for 1 device with 1 year of updates; trial limited to 2 tabs and 2 windowsSSMS free, plus a Windows 11 licence and a VM app such as Parallels Desktop (paid)
As of November 2026: checked on 17 November 2026 against SSMS 22.12.0 (10 November 2026), the MSSQL extension's Microsoft Learn feature list (updated 9 November 2026), DBeaver 26.2.5, DataGrip 2026.3, TablePlus 27.3.2 for macOS, and each vendor's documentation and pricing pages; Jam SQL Studio against version 1.5.11. Prices in US dollars, before tax. “Not documented” means the vendor's documentation and changelog do not describe the feature.

Sources — SSMS: FAQ (“SSMS is available only for Windows”, Arm64 builds, free for personal or enterprise use), release notes, actual execution plans, Windows 11 on Apple Silicon Macs. Azure Data Studio and Agent jobs in VS Code: retirement notice, which keeps SQL Server Agent in SSMS, and the closed Agent feature request. VS Code MSSQL extension: features and supported systems, Marketplace listing. DBeaver: downloads, execution plans, SQL Server driver, schema compare, editions. DataGrip: downloads, query plans, schema comparison, SQL Server Agent issue DBE-2423, the SQL Agent plugin on JetBrains Marketplace (by Leka; lists DataGrip 2026.2–2026.3 as compatible),pricing. TablePlus: downloads, macOS changelog, execution plan request, pricing.

Connect to SQL Server from a Mac in 3 steps

1

Install Jam SQL Studio

Download the Apple Silicon or Intel build from the macOS download page and install it.

2

Add your SQL Server connection

Click New Connection, choose SQL Server, enter the server address (for example localhost or myserver.database.windows.net) and choose SQL Server authentication or Microsoft Entra ID.

3

Write and run a query

Open a query tab, write SQL and click Execute in the toolbar.

AI agents can use the same connections: the app's local MCP server lets Claude Code, Cursor, Codex and other MCP clients list your connections, read the schema and run queries. It listens on 127.0.0.1 only and runs no queries until you raise its permission level to Read-only, or to Confirm, where each write waits for your approval in the app; the AI integrations and MCP docs cover the setup.

On Windows or Linux

The same app runs on Windows and Linux. The Windows download is a signed .exe installer for Windows 10 and 11 on x64; on Windows the Authentication list also has Windows authentication, which signs in as your Windows user through Microsoft's SQL Tools Service. The Linux download comes as .deb, .rpm and Arch packages for x64 and ARM64. The download page has the builds for all three systems; for a task-by-task comparison with SSMS on Windows, see Jam SQL Studio vs SSMS.

Questions

Using SQL Server from a Mac with Jam SQL Studio.

Is there a SQL Server client for Mac?

Yes. Jam SQL Studio runs on macOS 11 or later, with separate Apple Silicon and Intel builds, and connects to SQL Server, Azure SQL Database and Azure SQL Managed Instance without a Windows virtual machine. Microsoft's SQL Server Management Studio is available only for Windows; on a Mac, Microsoft's own option is the MSSQL extension for VS Code.

Can I use Windows authentication from a Mac?

Not with Jam SQL Studio. On macOS the app connects with a driver that cannot sign in as a Windows user, so since version 1.5.11 its connection form does not offer Windows authentication, and it does not support Kerberos or NTLM domain logins either. Use SQL Server authentication, or Microsoft Entra ID (Interactive Browser or Device Code) for Azure SQL. Windows authentication works in the Windows version of the app.

Can I manage SQL Server Agent jobs on a Mac?

Yes, in beta. The Agent Jobs Manager lists jobs and their history, runs and stops jobs, creates and edits jobs and schedules, and manages operators, alerts and proxies, on servers whose edition includes SQL Server Agent (Express does not). What you can change depends on your msdb role.

What does Jam SQL Studio not do on a Mac?

It does not offer Windows authentication (not on macOS since version 1.5.11) or Kerberos sign-in, and it has no Profiler or Extended Events capture. For event capture on a Mac, the MSSQL extension for VS Code has a Query Profiler that is built on Extended Events and runs on macOS. The SSIS, SSRS and SSAS tools need Windows: use SSMS on a Windows PC or in a Windows 11 virtual machine on the Mac. On an Apple Silicon Mac that virtual machine runs Windows 11 on Arm, where Microsoft lists no SSIS or SSAS support in SSMS.

Which SQL Server versions does it connect to?

SQL Server 2012 and later, Azure SQL Database and Azure SQL Managed Instance. Query Store needs SQL Server 2016 or later, and Agent jobs need an edition that includes SQL Server Agent.

Is Jam SQL Studio free on a Mac?

The Personal tier is free for personal, non-commercial use and needs no account. It caps a few bulk operations, such as Schema Compare at 200 objects per schema and Data Compare at 10,000 rows per table. Work use needs Pro at $9.99 a month or $99 a year.

JSON and spatial data in SQL Server

The native json type is generally available in SQL Server 2025 and Azure SQL Database (as of September 2026); SQL Server 2016–2022 use NVARCHAR(MAX) with OPENJSON, JSON_VALUE, JSON_QUERY, and JSON_PATH_EXISTS.

SQL Server JSON Guide JSON in 5 Engines Compared Migrate From MongoDB

SQL Server geometry / geography columns render on interactive maps — peek maps in the results grid, a Table Explorer map pane with spatial filters emitted as STIntersects / STDistance, and curve types like CircularString drawn correctly.

Spatial Guide SQL Server Geometry on a Map

Download the SQL Server client for Mac

Separate builds for Apple Silicon and Intel Macs, on macOS 11 Big Sur or later. Free for personal, non-commercial use, with no account.

Explore Other Databases

Jam SQL Studio also connects to these engines.

PostgreSQL MySQL Oracle SQLite Azure Data Explorer Azure Storage

Comparing SQL Server Tools?

See how Jam SQL Studio compares to other SQL Server tools.

vs SSMS SSMS for Mac SQL Server Management Tools Best SQL Client for Mac SQL Server on macOS Guide SQL Server Agent on Mac USE in SSMS, DBeaver and DataGrip Compare SQL Server Schemas