Manage Microsoft Fabric workspaces - list all workspaces the authenticated principal can see, inspect a single workspace's details (including its default Data Warehouse collation), and update that collation. All workspace commands operate at the workspace level and do not target a specific Data Warehouse or SQL…
Scaffolds a complete dbt-fabric project for a Fabric Data Warehouse: generates profiles.yml, dbtproject.yml, a column-rich sources.yml (with data types for every table column, ready for dbt contracts), requirements.txt, and .gitignore, then writes them to the local filesystem. Use when the user asks to "set up dbt"…
Analyzes query performance on a Fabric Data Warehouse: captures the estimated execution plan, inspects query insights history, identifies costly operators and missing or stale statistics, inspects data-clustering columns, and proposes or applies optimizations. Use when the user asks to "optimize a query", "why is my…
Investigates the performance of an ENTIRE Fabric Data Warehouse (warehouse-wide, not a single query): surfaces long-running and frequent queries, reads SQL pool resource-pressure insights, audits statistics health, checks result-set caching, reviews and tunes SQL pool configuration, and produces a prioritized findings…
MCP server "fabric-dw-mcp" as configured in sdebruyn/fabric-dw-mcp-cli. Runs in Docker (ghcr.io/sdebruyn/fabric-dw:2026.8.0). Needs 6 environment variables to run.