---
title: "A Native SQL Server Client for Mac"
description: "SQL Server Management Studio doesn't run on a Mac and Azure Data Studio is retired. TableStudio browses, edits and queries SQL Server and Azure SQL natively, next to your other databases, and gives your coding agent a safe way in."
canonical_url: "https://tablestudio.sh/databases/sql-server"
---

> Index of every page on this site: [llms.txt](https://tablestudio.sh/llms.txt)

TableStudio is a native Mac client for Microsoft SQL Server and Azure SQL. SQL Server Management Studio has never run on a Mac, and Azure Data Studio was retired on February 28, 2026. TableStudio gives Mac developers a fast, native place to work with SQL Server, next to the Postgres, MySQL and SQLite databases they already use.

<lead-feature icon="i-ph-stack" title="SQL Server and the rest of your stack, in one Mac app">

Browse SQL Server the way it's organized, server, database, schema, with its stored procedures, functions and triggers. Edit rows inline and write T-SQL with autocomplete. Compare two databases to get the script that closes the gap.

It sits next to your PostgreSQL, MySQL and SQLite databases, with the same ⌘K palette across all of them. And if you're moving off SQL Server, **Migrate Database** copies a database to Postgres or MySQL with a pre-flight report of what won't translate.

</lead-feature>

<feature-cards description="Native on the Mac, for SQL Server and Azure SQL." title="What TableStudio does for SQL Server">
<feature-card icon="i-ph-shield-check" title="Agents on Azure SQL and SQL Server">

- Claude Code, Codex, Cursor and OpenCode reach Azure SQL by name, with no connection string in a config file.
- `xp_cmdshell`, `OPENROWSET` and other ways out of the database are refused.
- An agent's `UPDATE` or `DELETE` can be tried inside a transaction that's always rolled back.
- Nothing an agent writes reaches production until you approve it with Touch ID, and each change can be rolled back on its own.
- Set a database to Structure only and an agent can write queries against it without ever seeing a row.

</feature-card>

<feature-card icon="i-ph-plugs-connected" title="Connect">

- SQL Server and Azure SQL Database, directly or over an SSH tunnel.
- A SQL Server in a Docker or Apple container on your Mac, on the port you published.
- Paste a connection string into Host and every field fills itself.

</feature-card>

<feature-card icon="i-ph-tree-structure" title="Schemas and objects">

- Databases and schemas, the way SQL Server nests them.
- Stored procedures, functions, triggers and views, with their definitions.
- A column editor that leads with `nvarchar`, `datetime2` and `uniqueidentifier`, and knows `xml`, `rowversion` and `hierarchyid`.
- Create tables, columns, indexes and keys without writing DDL.

</feature-card>

<feature-card icon="i-ph-code" title="T-SQL">

- Completion that follows `dbo` and your other schemas down to each column.
- AI that writes T-SQL, `TOP` and `OFFSET … FETCH` included, and fixes failing queries.
- Snippets, formatting, tabs and query history.

</feature-card>

<feature-card icon="i-ph-table" title="Data">

- Edit rows inline and apply them in one transaction.
- See the parent row behind a foreign key without leaving the grid.
- Bring in CSV or TSV files, and get results out as JSON, SQL inserts, Markdown or Excel.
- Fake rows for testing, with foreign keys pointing at real parents.

</feature-card>

<feature-card icon="i-ph-swap" title="Move your data">

- Copy a SQL Server database to Postgres or MySQL with a pre-flight report.
- Sync rows into a SQL Server table, `IDENTITY` columns handled.
- Compare two databases and get the migration script.

</feature-card>

<feature-card icon="i-ph-gauge" title="Insights and checks">

- Query Insights over the T-SQL run from TableStudio, by you or your agents.
- Schema checks with each fix and its rollback SQL.
- ER diagrams across schemas.

</feature-card>
</feature-cards>

## What's not there yet

TableStudio's SQL Server support is new, and some of what it does on other engines isn't here yet. There's no visual query plan, no health checks, no backups or restore points, and no sandboxes for SQL Server. SQL Server Agent jobs and server administration belong in SSMS. If SQL Server is your only database, Microsoft's free MSSQL extension for VS Code covers those. If it's one of several, TableStudio puts them all in one native app.

## Sitemap

See the full [sitemap](https://tablestudio.sh/sitemap.md) for all pages.