Skip to content

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.
  • Permissions: Manage Fabric item-level and T-SQL in-database permissions (GRANT/DENY/REVOKE).
  • 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.