Dataverse Tools: Query Analyzer

SQL query editor for Dataverse via the TDS (Tabular Data Stream) endpoint. Write SQL queries with autocomplete, execute them, and view results in a tabular format.

Features

• SQL editor powered by CodeMirror with syntax highlighting
• Intellisense — table and column autocomplete driven by live Dataverse metadata (cached with 5-min TTL)
• Execute queries against the Dataverse TDS endpoint using Azure AD authentication
• Tabular results displayed in a data table
• Export results to CSV or JSON
• Query history — automatically records the last 50 executed queries with duration and row count
• Saved queries — save, load, and delete named queries (persisted per workspace)
• Multi-instance panels — open separate panels per environment, each with its own connection
• Launch from Explorer — right-click an entity in the Explorer tree to open a pre-filled SELECT TOP 50 * FROM <entity> query
• Connection pooling — reuses TDS connections per environment for faster repeat queries
• Change environment — switch the target environment from the editor tab context menu

Commands

Settings

Dependencies

• Dataverse Tools: Environments — required for authentication and environment access

Requirements

• VS Code 1.96+
• TDS endpoint must be enabled on the target Dataverse environment

Acknowledgements

Inspired by Microsoft's original SQL Server Query Analyzer (pre-SSMS) and SQL 4 CDS by Mark Carrington (MarkMpn) for XrmToolBox.

Part of Dataverse Tools

This extension is part of the Dataverse Tools suite for Dynamics 365 / Power Platform plugin developers.