Understand Your Microsoft Fabric Lakehouse at a Glance

DbSchema connects to the lakehouse's SQL Analytics Endpoint — the T-SQL interface over your Delta Parquet tables — and turns the auto-registered tables and views into ER diagrams, visual queries, and shareable documentation.

Diagram the tables and views the endpoint exposes
Assemble T-SQL queries visually against Delta Parquet data
Publish the lakehouse model for governance reviews
Draft table designs before touching the Fabric portal

available for

ISO-27001 certified

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

Free Download

DbSchema mapping Microsoft Fabric Lakehouse tables into an ER diagram

Trusted by teams at

Fabric Registers Tables Automatically
Relationships Are Left to You

Every load into the lakehouse adds Delta tables, and the portal lists them — flat, one at a time. How orders relate to customers, and which views sit on which tables, is exactly what a list cannot show.

DbSchema introspects the SQL Analytics Endpoint and draws the structure: tables, views, columns, and relationships on a canvas data engineers can actually navigate.

Explore, Query & Plan
on Top of the SQL Analytics Endpoint

A desktop view of the lakehouse the Fabric portal does not offer.

Reverse engineer the Fabric Lakehouse SQL Analytics Endpoint schema

From Table List to Data Model

Connect once and DbSchema reads tables, views, and column types from the endpoint, laying the whole lakehouse out as a navigable diagram.

Build T-SQL queries against Fabric Lakehouse tables visually

Joins Assembled on the Canvas

Pick lakehouse tables, drag joins and filters into place, and read the generated T-SQL before it runs — results land in the integrated data grid.

Draft Fabric Lakehouse table designs in the DbSchema model

Sketch the Next Iteration Safely

Draft intended table structures in the local model and share the design for discussion — implementation then happens through the Fabric portal, since the endpoint is read-oriented.

Lakehouse Documentation for People
Without Workspace Access

Generate interactive HTML5 documentation — zoomable diagrams, table definitions, column comments — and hand it over as a link. Governance reviewers and analysts study the data model with no Fabric workspace membership and nothing installed.

Explore the Documentation Tool

Interactive HTML5 documentation of a Microsoft Fabric Lakehouse data model

Connecting to the SQL Analytics Endpoint

The SQL Analytics Endpoint speaks the SQL Server protocol, so choose SQL Server as the driver type — DbSchema downloads the Microsoft JDBC driver automatically. The URL takes the form jdbc:sqlserver://workspace-id.datawarehouse.pbidedicated.windows.net:1433;database=LakehouseName, with your workspace ID as the hostname's first label, port 1433, and the lakehouse name as the database. Append ;authentication=ActiveDirectoryPassword and sign in with your Azure Active Directory username and password.

The endpoint is read-oriented: querying and introspection work, while creating or altering tables stays in the Fabric portal — DbSchema's synchronization does not deploy changes here. Driver details are on the Fabric Lakehouse JDBC driver page.