We're pleased to announce the general availability of Query Editor for Azure SQL Database. The updated experience brings a multi-tab query workspace, easier database exploration, and more interactive query results directly to the Azure portal, with no desktop tools to install.
Whether you're checking data after a deployment, investigating an unexpected result, or trying out a query, you can get started from your database in the portal. Modern Query Editor brings these everyday tasks together in a refreshed workspace.
Query Editor brings Object Explorer, multiple query tabs, and interactive results together in the Azure portalWork across multiple queries
Multiple query tabs let you keep related queries open and switch between them without replacing the SQL you're already working on.
For example, you can keep a query open while writing a second query to investigate its results. When you're ready, run the selected SQL and review the output in the same workspace.
Your work also stays with you. Open tabs and query text are restored as you move around the portal during your browser session, and you can save the queries you return to often in Queries. Saved queries are stored in your browser profile, so they're ready the next time you open Query editor in the same browser.
Save queries you use often and they will appear in Queries sectionFind objects and preview data
The updated Object Explorer makes it easier to find what you need in your database. Search for objects by name and narrow the results by object type, rather than browsing through the full hierarchy.
You can also open a table or view in a dedicated data-preview tab to inspect up to 1,000 rows without writing a query first. This gives you a quick way to get familiar with the data before building your query, without interrupting work in another tab.
Search Object Explorer, filter by object type, and preview up to 1,000 rows in a dedicated tabDo more with your query results
The results grid lets you sort and filter returned data, resize columns, and copy cells, rows, or columns. You can inspect the output and focus on the values that matter without changing your SQL for every quick check.
When you need to use the results outside the portal, export them as CSV, JSON, or Excel. That makes it straightforward to move from a quick database check to further analysis or sharing results with your team.
Sort and filter results directly in the grid, then export them as CSV, JSON, or Excel
Get started
To try Modern Query Editor:
- Open your Azure SQL database in the Azure portal.
- Select Query editor from the database resource menu.
- Connect using Microsoft Entra authentication or SQL authentication, then explore your database or run a query.
If something blocks the connection, such as a firewall rule or missing Microsoft Entra configuration, Query editor explains what went wrong and suggests the next step. For example, you can add your client IP address to the server firewall with a single click, or go straight to the relevant networking or Microsoft Entra settings.
For connection requirements and more details, see the Query Editor documentation.
Modern Query Editor is designed for lightweight querying and exploration. When you need a full desktop development or administration environment, use Open in to connect to the same database in Visual Studio Code or SQL Server Management Studio.
Prefer the original experience? The classic Query editor remains available, and you can switch between the classic and modern experiences without losing your database context.
Try the new experience and let us know what you think by selecting Feedback in the Query editor command bar.
Microsoft