A Desktop Client for Microsoft Dataverse Tables

DbSchema connects to Microsoft Dataverse through its read-only TDS endpoint and turns the entity model behind your Power Apps and Dynamics 365 solutions into ER diagrams, point-and-click T-SQL queries, and shareable documentation.

Diagram standard and custom tables side by side
Query Dataverse with T-SQL — no SDK, no REST calls
Compare entity schemas between environments
Publish documentation for solution reviews and handoffs

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema visualizing the Microsoft Dataverse entity model as an ER diagram

Trusted by teams at

Power Apps Grow by Clicks
The Data Model Grows in the Dark

Every maker who ships an app adds tables and columns through the portal, and the environment's entity model accretes across solution layers. The complete picture exists nowhere — until an architect needs it for the next integration.

DbSchema reads the model over the TDS endpoint and assembles that picture: standard tables, custom tables, and their relationships on one ER diagram.

Diagram, Query & Compare
Dataverse from Your Desktop

SQL-grade tooling for the data layer under Power Apps and Dynamics 365.

Reverse engineer Dataverse tables and relationships into a diagram

Custom and Standard Tables, One Map

DbSchema reads table definitions, column types, and relationships from Dataverse metadata and renders the entity model as a navigable ER diagram.

Build T-SQL queries against Dataverse tables visually

T-SQL by Point and Click

Compose queries against Dataverse tables in the visual builder — columns, filters, joins — and read the generated T-SQL before it runs.

Compare Dataverse entity schemas between environments

Spot Drift Between Environments

Compare the entity schemas of development and production environments and see every structural difference listed before a deployment surprises you.

The Entity Model, Readable
in Any Browser

Generate interactive HTML5 documentation of tables, columns, and relationships. Consultants, admins, and reviewers study the Dataverse structure from a link — no environment access granted, nothing installed on their side.

Explore the Documentation Tool

Interactive HTML5 documentation of the Microsoft Dataverse entity model

The TDS Endpoint in Practice

Dataverse accepts T-SQL through its Tabular Data Stream (TDS) endpoint, which is off by default: enable it in your Power Platform environment settings under Settings > Features > TDS endpoint. Then connect with a SQL Server-compatible JDBC driver and a URL of the form jdbc:sqlserver://org.crm.dynamics.com:5558 — replace org with your environment's organization name; 5558 is the endpoint's port. Sign in with an Azure AD account that has a Dataverse security role assigned.

The endpoint is read-only: SELECT-style T-SQL works, DDL statements do not — schema changes stay in Power Platform. Driver setup details are on the Dataverse JDBC driver page.