Azure Data Studio Alternatives and Replacement Options
Microsoft retired Azure Data Studio on February 28, 2026. The final 1.52.0 installer is still available as an archive, but the product gets no updates, security fixes or support. Microsoft's official replacement is Visual Studio Code with the MSSQL extension, with SSMS on Windows for SQL Server Agent and full administration.
That covers SQL Server work inside an editor. If you used Azure Data Studio as a standalone app on a Mac or Linux machine, relied on its charts, dashboards or Kusto extension, or worked with PostgreSQL or MySQL next to SQL Server, Jam SQL Studio keeps those workflows in one desktop app for Mac, Windows and Linux and imports your Azure Data Studio connections. Below: the three replacement options compared as of October 2026, what each Azure Data Studio workflow maps to, and a migration checklist.
Free for personal use • Pro for work • No account required • Mac, Windows, Linux
“As an abandoned user of Azure Data Studio, I was left looking for a good replacement. I tried multiple options and JamSQL is my new go-to tool for SQL. It has everything I need and the development team at JamSQL has been super responsive to feedback with consistent product improvements!”
“JamSQL has been a lifeline for MacBook users. It's replaced several SQL tools in my workflow, and I'm still discovering new features. The support team is genuinely helpful, and clearly invested in their customers' success.”
What Happened to Azure Data Studio
- Retired February 28, 2026. Microsoft announced the retirement on February 6, 2025. Since the retirement date Azure Data Studio gets no updates, security fixes or support.
- The final build is still downloadable, unsupported. Version 1.52.0 (June 18, 2025) remains on Microsoft's archived download page and on the final GitHub release, which also carries an archive of the extensions Microsoft used to host. On Apple Silicon Macs it needs Rosetta 2. Download links are on the Azure Data Studio retirement page.
- The source is frozen. The microsoft/azuredatastudio GitHub repository was archived as read-only on February 28, 2026.
- Microsoft split the replacement across tools. Its guidance sends daily work to VS Code with the MSSQL extension and SQL Server Agent and full administration to SSMS. PostgreSQL moves to a separate VS Code extension; a MySQL replacement is listed as “pending announcement”; the Kusto extension has no listed replacement.
- Why: Microsoft says retiring Azure Data Studio consolidates its SQL tools into Visual Studio Code and SSMS so the team can focus on fewer tools.
Sources: Microsoft Learn — What's happening with Azure Data Studio, the archived download page and GitHub releases, checked October 5, 2026. Full timeline: Azure Data Studio end of life.
The 3 Azure Data Studio Replacement Options Compared
Microsoft's two successors and one standalone cross-platform app, feature by feature, as of October 2026.
| Feature | Jam SQL Studio | VS Code + MSSQL ext. | SSMS 22 |
|---|---|---|---|
| Status | ✓ Maintained | ✓ Maintained (1.46.0, Sep 28, 2026) | ✓ Maintained (22.10.2, Sep 28, 2026) |
| Price | Free for personal, non-commercial use; Pro $9.99/mo or $99/yr for work | ✓ Free | ✓ Free |
| Platforms | ✓ macOS (Apple Silicon & Intel), Windows 10/11 x64, Linux x64 & ARM64 | ✓ Windows 10/11, macOS, Linux (x64 & Arm64) | ✗ Windows 11 & Windows Server 2019–2025 only |
| Standalone desktop app | ✓ | ✗ VS Code extension | ✓ Admin rights needed to install |
| SQL Server / Azure SQL | ✓ | ✓ Plus SQL database in Fabric | ✓ Plus Azure Synapse and Fabric |
| PostgreSQL / MySQL / MariaDB / Oracle / SQLite | ✓ All built in | PostgreSQL via a separate extension | ✗ SQL Server family only |
| Kusto / KQL (Azure Data Explorer) | ✓ Native engine | Not listed | Not listed |
| SQL notebooks (.ipynb) | ✓ Opens ADS notebooks | ✓ GA | Not listed |
| Execution plans | ✓ SQL Server, PostgreSQL, MySQL, Oracle | ✓ | ✓ |
| Schema compare | ✓ Free up to 200 objects per schema | ✓ GA | ✓ GA since 22.10.2 |
| Data compare | ✓ Free up to 10,000 rows per table | Not listed | Not listed |
| Charts from query results | ✓ | Not listed | Not listed |
| SQL Server Agent jobs | ✓ Beta, on Mac, Windows and Linux | Not listed; Microsoft points to SSMS | ✓ |
| Live trace / profiler | ✗ | ✓ Query Profiler (Extended Events) | ✓ XEvent Profiler |
| SQL projects / DACPAC | Database Blueprint (beta) and BACPAC export; no .sqlproj or DACPAC deploy | ✓ DACPAC/BACPAC, SQL database projects | ✓ Database DevOps workload (GA since 22.10.2) |
| AI | Local MCP server for any MCP client, off by default | GitHub Copilot chat and agent mode | GitHub Copilot, with Agent Mode GA since 22.10.2 |
| Microsoft Entra ID sign-in | ✓ | ✓ | ✓ |
| Import saved ADS connections | ✓ From ADS settings.json, with server groups | Not listed | Not listed |
Pick VS Code + MSSQL extension if…
You work only with SQL Server, Azure SQL or Fabric and already spend your day in VS Code. The extension has execution plans, schema compare, a schema designer, SQL notebooks, a query profiler, backup and restore, and GitHub Copilot integration. Keep SSMS around (on Windows) for SQL Server Agent.
Pick SSMS 22 if…
You administer SQL Server from a Windows 11 or Windows Server machine where you have admin rights. It is the most complete SQL Server administration tool, and since 22.10.2 its schema compare and Copilot Agent Mode are generally available. It covers none of Azure Data Studio's Mac, Linux or multi-engine use cases.
Pick Jam SQL Studio if…
You used Azure Data Studio as a standalone app, especially on a Mac or Linux, and want its notebooks, charts, dashboards and Kusto workflow in one place, plus PostgreSQL, MySQL, MariaDB, Oracle and SQLite, data compare, and SQL Server Agent jobs off Windows. If you relied on the Kusto extension, its native Azure Data Explorer engine covers that workflow. It is free for personal use; work use needs Pro.
Other cross-platform clients, such as DBeaver and DataGrip, also connect to SQL Server and PostgreSQL; their pages compare them with Jam SQL Studio in detail.
What Jam SQL Studio Replaces From Azure Data Studio
The Azure Data Studio workflows and extensions you already know, mapped to Jam SQL Studio — including the ones it doesn't replace. For Microsoft's replacement for each extension, see the extension table in the migration guide.
| Azure Data Studio | Jam SQL Studio |
|---|---|
| Query editor with IntelliSense | Query Editor with IntelliSense (Monaco-based), plus completions for JSON paths, enum values and loose foreign keys you declare |
| Results grid | Results grid and Table Explorer with inline editing and export |
| Connection manager and server groups | Connections with SQL, Windows and Entra ID authentication; ADS connections and server groups imported from settings.json |
| SQL Notebooks (.ipynb) | SQL Notebooks — opens the same .ipynb files; SQL and JavaScript cells, with SQL cells sharing one database session |
| Dashboard and insight widgets | SQL dashboards with chart, stat, table and pivot tiles and auto-refresh; Performance Dashboard for live server metrics |
| Execution plan viewer | Execution plans (estimated & actual) on SQL Server, PostgreSQL, MySQL and Oracle; opens .sqlplan files and compares two plans |
| Schema Compare extension | Schema Compare, built in, with sync scripts, on all five relational engines |
| Results-to-chart | Charts: bar, line, pie, area, scatter, exported as PNG or SVG |
| Object Explorer | Object Explorer with search, scripting and a dependency viewer |
| SQL Server Agent extension | Agent Jobs manager (beta): jobs, history, operators, alerts, proxies |
| Import Flat File wizard | Data Import for CSV, TSV, Excel, JSON and NDJSON (free up to 100,000 rows per import) |
| SQL Server dacpac extension | Backup and restore with .bak files and BACPAC export for Azure SQL; DACPAC deployment stays with SqlPackage or the VS Code MSSQL extension |
| Kusto (KQL) extension | Native Azure Data Explorer engine, including App Insights and Log Analytics query proxies |
| PostgreSQL and MySQL extensions | PostgreSQL 10+ (including Azure Database for PostgreSQL), MySQL and MariaDB built in |
| SQL Database Projects extension | Different model: Database Blueprint (beta) keeps schema and table data as .sql files in Git |
| SQL Server Profiler extension | No equivalent — use the VS Code MSSQL Query Profiler or SSMS's XEvent Profiler |
| Azure Cosmos DB and Azure SQL migration extensions | No equivalent |
| Keyboard shortcuts | An SSMS / Azure Data Studio shortcut scheme in Settings → Keyboard Shortcuts |
| Integrated terminal | Integrated terminal, plus a local MCP server for AI agents |
Replacement Checklist
Five steps to replace Azure Data Studio with Jam SQL Studio. The migration guide covers each one with screenshots.
Install Jam SQL Studio
Download the build for macOS (Apple Silicon or Intel), Windows 10/11 x64, or Linux (x64 or ARM64). No account needed for the free Personal tier.
Import your connections
Use Import…: Jam SQL Studio reads Azure Data Studio's settings.json and lists your saved SQL Server, PostgreSQL and Kusto connections under the same server groups, with duplicates pre-unchecked. Tick the ones you want and import; passwords are re-entered inline, never read from ADS's secure store. Moving to a new machine? Export the ADS connections first. See how import works →
Open your notebooks and scripts
Open existing .ipynb notebooks and .sql files directly — no conversion needed. Attach a connection and run.
Keep your SSMS / ADS keys
In Settings → Keyboard Shortcuts, pick the SSMS / Azure Data Studio scheme: F5 executes, Alt+Break cancels, Ctrl+R toggles the results pane. Shortcut schemes →
(Optional) Connect your AI agent
Turn on the built-in MCP server to let Claude Code, Claude Desktop, Cursor, Codex CLI or another MCP client query your databases. It is off by default and runs no queries until you allow Read-only or approval-gated writes for a connection. MCP setup →
settings.json and keeps server groups and authentication types.Frequently Asked Questions
Direct answers about Azure Data Studio alternatives and replacing it in 2026.
What is the best Azure Data Studio replacement?
It depends on where you work. If you use only SQL Server, Azure SQL or SQL database in Fabric and already work in VS Code, Microsoft's recommended MSSQL extension covers execution plans, schema compare, SQL notebooks and a query profiler. If you administer SQL Server from Windows 11 or Windows Server, use SSMS 22, which Microsoft names as the home for SQL Server Agent and full administration. If you want one standalone app on Mac, Windows or Linux that keeps Azure Data Studio's notebooks, charts, dashboards and Kusto workflow, adds MySQL, MariaDB, Oracle and SQLite next to SQL Server and PostgreSQL, and manages SQL Server Agent jobs off Windows, use Jam SQL Studio.
Is Azure Data Studio retired?
Yes. Microsoft announced the retirement on February 6, 2025, and Azure Data Studio was retired on February 28, 2026. It no longer receives updates, security fixes or support, and its GitHub repository was archived as read-only the same day. Microsoft says it retired the product to consolidate its SQL tools into Visual Studio Code and SSMS.
Can I still download Azure Data Studio?
Yes, as an archive. The final build, version 1.52.0 (released June 18, 2025), is still on Microsoft's archived download page and attached to the final release in the microsoft/azuredatastudio GitHub repository, together with an archive of the extensions Microsoft used to host. Downloading it does not bring back support: the retired product gets no security fixes or bug fixes, and on Apple Silicon Macs it still needs Rosetta 2. Download links and version details are on the Azure Data Studio retirement page.
Is there a free Azure Data Studio replacement?
Yes. The VS Code MSSQL extension and SSMS are free. Jam SQL Studio's Personal tier is free for personal, non-commercial use, with unlimited connections, IntelliSense, execution plans, charts, SQL notebooks and the MCP server; schema compare is capped at 200 objects per schema and data compare at 10,000 rows per table. Work use needs Pro at $9.99 per month or $99 per year, which includes the commercial-use license and lifts the caps. The Personal tier needs no account.
Which Azure Data Studio alternatives run on Mac and Linux?
The VS Code MSSQL extension runs on Windows, macOS and Linux, including Arm64. Jam SQL Studio ships separate builds for Apple Silicon and Intel Macs, Windows 10 and 11 (x64), and Linux x64 and ARM64. SSMS 22 runs only on Windows 11 and Windows Server 2019, 2022 and 2025.
Can I reuse my Azure Data Studio notebooks (.ipynb)?
Yes. Jam SQL Studio's SQL Notebooks open the same .ipynb files Azure Data Studio used, without conversion: attach a connection and run. SQL cells share one database session, so temp tables persist between cells. The VS Code MSSQL extension's SQL notebooks are also Jupyter-based.
What does the VS Code MSSQL extension cover, and what does it leave out?
Microsoft recommends VS Code with the MSSQL extension for daily work and SSMS for SQL Server Agent and full administration. As of version 1.46.0 (September 28, 2026), the MSSQL extension lists execution plans, schema compare, a schema designer, SQL notebooks, a query profiler, backup and restore, DACPAC and BACPAC, flat-file import and GitHub Copilot integration as generally available. Its feature list does not include charts from query results, data compare, Azure Data Studio-style dashboards or Kusto, and it supports SQL Server, Azure SQL and SQL database in Fabric; PostgreSQL is a separate extension. See the VS Code MSSQL comparison.
Does Jam SQL Studio support the same databases as Azure Data Studio?
Jam SQL Studio supports SQL Server (including Azure SQL Database and Managed Instance), PostgreSQL (including Azure Database for PostgreSQL), MySQL, MariaDB, Oracle, SQLite and Azure Data Explorer (Kusto/KQL, read-only). Azure Data Studio reached PostgreSQL, MySQL and Kusto through extensions; its MySQL extension became generally available in September 2023. Jam SQL Studio adds MariaDB, Oracle and SQLite. It does not connect to Azure Cosmos DB, which Azure Data Studio supported through an extension.
What does Jam SQL Studio add beyond Azure Data Studio?
Compared with Azure Data Studio and the extensions Microsoft published for it, Jam SQL Studio adds data compare with sync scripts; schema compare for PostgreSQL, MySQL, Oracle and SQLite, not only SQL Server; Oracle, MariaDB and SQLite connections; a visual Schema Overview graph; and a local MCP server (Model Context Protocol) for AI agents such as Claude Code, Claude Desktop, Cursor and Codex CLI. The MCP server is off by default, listens on localhost only and requires a token; no queries run until you allow Read-only or approval-gated writes for a connection.
What does Jam SQL Studio not replace?
Jam SQL Studio has no live trace tool like SQL Server Profiler; use the MSSQL extension's Query Profiler or SSMS's XEvent Profiler. It has no extension marketplace, and it does not build .sqlproj SQL database projects or deploy DACPACs; its Database Blueprint keeps schema and data as .sql files in Git instead. It has no Azure SQL migration or assessment tooling, and it does not connect to Azure Cosmos DB.
How do I migrate from Azure Data Studio?
Install Jam SQL Studio, then use Import to read Azure Data Studio's settings.json: your saved SQL Server, PostgreSQL and Kusto connections appear under their server groups, and you re-enter passwords inline. Open your .sql files and .ipynb notebooks directly, pick the SSMS / Azure Data Studio shortcut scheme if you want those keys, and enable the MCP server only if you use an AI agent. If you are moving to a new machine, export the connections from Azure Data Studio first. The step-by-step migration guide covers each step with screenshots.
Can I use my Azure Data Studio keyboard shortcuts?
Yes. Jam SQL Studio uses familiar keyboard shortcuts from Azure Data Studio and SSMS. F5 executes the query (and runs just your selection when you have one, like SSMS), Cmd/Ctrl+Enter or Shift+Enter runs the statement under the cursor, Ctrl+Space triggers IntelliSense, and Cmd/Ctrl+S saves. The SQL editor is the same Monaco editor Azure Data Studio uses, so the editing keybindings match. To use SSMS's keys, pick the SSMS / Azure Data Studio scheme in Settings → Keyboard Shortcuts: on Windows and Linux, Alt+Break then cancels a query and Ctrl+R shows or hides the results pane, and every other shortcut, including F5 and Cmd/Ctrl+Enter, keeps working.
Does Jam SQL Studio work with Azure SQL Database and Microsoft Entra ID?
Yes. Jam SQL Studio connects to Azure SQL Database and Azure SQL Managed Instance with SQL authentication or Microsoft Entra ID (formerly Azure AD). For Entra ID, Interactive Browser sign-in is recommended, and Device Code is available when browser sign-in is blocked.
Download Jam SQL Studio
Free for personal, non-commercial use; Pro ($9.99/month or $99/year) for work. No account needed for the Personal tier. Import your Azure Data Studio connections and notebooks after install.
Further Reading
The Azure Data Studio retirement, migration steps, and how Jam SQL Studio compares to other SQL tools.
Replacing specific ADS pieces: ADS dashboards · SQL Database Projects · Kusto / KQL · Polyglot Notebooks deprecated · SSMS alternatives for Mac
Recently shipped: JSON column filters & declarations · enum-column dropdown filters · filtered loose foreign keys · JSON tour blog · polymorphic FKs in SQL
Jam SQL Studio 