Commands¶

fabric-dw exposes every operation as both a CLI command and an MCP tool. The two surfaces share the same authentication, connection, and business logic — a fix or new feature lands in both at once.

Each page below covers one command domain: CLI synopsis, options, and examples alongside the corresponding MCP tool parameters and return values.

Domains¶

• Audit — Manage SQL audit settings for Data Warehouses and SQL Analytics Endpoints.
• Cache — Manage the local name-to-UUID lookup cache.
• Completion — Install and manage shell completion scripts.
• Configuration & defaults — Store a default workspace and/or warehouse to avoid repeating them on every invocation.
• dbt — Scaffold a dbt project pre-wired to a Fabric Data Warehouse.
• Functions — Manage T-SQL user-defined functions.
• Queries — Inspect and manage running queries.
• Restore Points — Create, list, rename, and delete warehouse restore points.
• Running SQL — Execute SQL statements and capture estimated execution plans.
• Schemas — Manage SQL schemas.
• Settings — Manage server-side database settings.
• Snapshots — Manage Data Warehouse snapshots.
• SQL Analytics Endpoints — Manage SQL Analytics Endpoints.
• SQL Pools — Manage custom SQL Pools at the workspace level.
• Statistics — Manage user-defined statistics.
• Stored procedures — Manage stored procedures.
• Tables — Manage SQL tables, including CTAS, clone, load, and clustering.
• Views — Manage SQL views.
• Warehouses — Manage Data Warehouses and SQL Analytics Endpoints.
• Workspaces — List, inspect, and manage workspaces — capacity assignment, collation, and more.