Design and Manage Microsoft Fabric Lakehouse Databases with DbSchema
Build a clearer workflow for Microsoft Fabric Lakehouse: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.
DbSchema is built for visual modeling, schema documentation, and deployment. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.
Download DbSchema See Microsoft Fabric Lakehouse Features Download Microsoft Fabric Lakehouse JDBC Driver
What happens after you download?
Get to your first Microsoft Fabric Lakehouse schema diagram in minutes. No account, no credit card.
Install in minutes
Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.
Connect to Microsoft Fabric Lakehouse or open a sample
Reverse engineer an existing Microsoft Fabric Lakehouse database or open a sample model to explore tables, relationships, and indexes.
Design, document, and deploy
Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.
Connecting to Fabric Lakehouse via the SQL Analytics Endpoint
Microsoft Fabric Lakehouse stores data as Delta Parquet files and exposes them for SQL queries through a SQL Analytics Endpoint — a read-oriented T-SQL interface backed by automatic metadata registration. DbSchema connects to this endpoint, introspects the available tables and views, and renders the lakehouse schema as an ER diagram. This gives data engineers and architects a structured, navigable view of the lakehouse data model that the Fabric portal's table list does not provide, and makes it straightforward to understand table relationships across a large lakehouse.
Download DbSchema Free See Microsoft Fabric Lakehouse Features
Visualize and Design Lakehouse Schemas
DbSchema renders Fabric Lakehouse tables as entities on a diagram canvas, showing columns, data types, and relationships. Engineers can use this view to draft schema designs and document the intended structure before implementing changes through the Fabric portal.
Build and Run T-SQL Queries Against the Lakehouse
The visual query builder generates T-SQL compatible with the SQL Analytics Endpoint, letting analysts join lakehouse tables, apply column filters, and retrieve results from Delta Parquet data without writing SQL. Queries execute against the endpoint and results display in the integrated data grid.
Document the Lakehouse Data Model
DbSchema produces HTML schema documentation from the Fabric Lakehouse metadata — including table definitions, column types, and ER diagrams — suitable for sharing with stakeholders and for maintaining data governance records without requiring live Fabric workspace access.
Connecting DbSchema to Microsoft Fabric Lakehouse
DbSchema connects to the Fabric Lakehouse SQL Analytics Endpoint using the SQL Server JDBC driver, which it downloads automatically. The JDBC URL format is jdbc:sqlserver://workspace-id.datawarehouse.pbidedicated.windows.net:1433;database=LakehouseName. Authentication requires Azure Active Directory credentials; append ;authentication=ActiveDirectoryPassword to the URL and provide your AAD username and password. Because the SQL Analytics Endpoint is primarily read-oriented, schema modifications such as creating or altering tables must be performed through the Fabric portal rather than through DbSchema's synchronization tool.
Why Teams Use DbSchema with Microsoft Fabric Lakehouse
- Visualize the SQL Analytics Endpoint schema as a navigable ER diagram
- Run T-SQL queries on Delta Parquet data from a standalone desktop client
- Document the lakehouse data model for governance and onboarding purposes
- Draft schema designs locally before implementing them through the Fabric portal
- Give analysts a query interface without requiring Fabric workspace membership