fabric-dw

Add a new custom SQL pool to a workspace. Args: workspace: Workspace name or GUID. name: Pool name (must be unique within the workspace). max_percent: Max resource percentage (1-100). is_default: Whether this pool is the default pool. Defaults to false. optimize_for_reads: Enable read optimisation. Defaults to true. classifier_type: Classifier type (e.g. ``"Application Name"``). classifier_values: List of classifier values (e.g. application names). Requires workspace admin role. This tool targets a **beta / preview** API.

Create a single-column statistic on a table. Only supported on Data Warehouses (SQL Analytics Endpoints are read-only). Only single-column statistics are supported (Fabric limitation). Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. SQL Analytics Endpoints are rejected. qualified_table: Qualified table name, e.g. ``dbo.sales``. column: Column name to build the statistic on. stat_name: Name for the new statistic. fullscan: When True (default), use WITH FULLSCAN. Ignored when sample_percent is provided. sample_percent: Sample percentag…

Create a new SQL table via CTAS (CREATE TABLE AS SELECT). Only supported on Fabric Data Warehouses (not SQL Analytics Endpoints). The service rejects SQL Analytics Endpoints with a ``ToolError``. CAUTION: ``select_body`` is executed verbatim as DDL on the warehouse. Ensure the body matches the user's intent before calling this tool. ``select_body`` must be a single read-only SELECT or WITH (CTE) statement. The guard is always on and fail-closed: a write keyword (DELETE, DROP, INSERT, etc.) or a semicolon anywhere in the body is rejected, even inside a string literal or quoted identifier. …

Create a new SQL view. CAUTION: ``select_body`` is executed verbatim as DDL. Ensure the body matches the user's intent before calling this tool. ``select_body`` must be a single read-only SELECT or WITH (CTE) statement. The guard is always on and fail-closed: a write keyword (DELETE, DROP, INSERT, etc.) or a semicolon anywhere in the body is rejected, even inside a string literal or quoted identifier. If a legitimate view body contains a write keyword (e.g. a column alias 'DELETE'), rewrite the expression to avoid the keyword. Args: workspace: Workspace name or GUID. item: Warehou…

Create a new Warehouse in a workspace. Args: workspace: Workspace name or GUID. name: Display name for the new warehouse. collation: Optional default collation for the new warehouse. Fabric Data Warehouse supports a fixed set of collations. Supported values include: - ``Latin1_General_100_BIN2_UTF8`` (recommended default) - ``Latin1_General_100_CI_AS_KS_WS_SC_UTF8`` - ``Latin1_General_CI_AS`` - ``SQL_Latin1_General_CP1_CI_AS`` When omitted, the workspace default collation is used. Supplying an unsupported value will…

Delete a user-defined restore point. System-created restore points cannot be deleted. Args: workspace: Workspace name or GUID. warehouse: Warehouse name or GUID. restore_point_id: The restore point ID string.

Drop a SQL schema from a warehouse. CAUTION: This is a destructive, irreversible operation. The schema will be permanently deleted. If the schema still contains tables or views, the operation will fail unless *cascade* is ``True``. CAUTION: When *cascade* is ``True``, **all tables and views in the schema are permanently deleted along with their data**. Confirm explicitly with the user before calling with ``cascade=True``. Both Fabric Data Warehouses and SQL Analytics Endpoints support ``DROP SCHEMA`` per the Microsoft Fabric T-SQL reference. Args: workspace: Workspace name or GUID. …

Delete a warehouse snapshot.

Delete an SQL pool from a workspace. Args: workspace: Workspace name or GUID. pool_name: Name of the pool to delete. Requires workspace admin role. This tool targets a **beta / preview** API.

Drop a statistic via DROP STATISTICS. CAUTION: This is a destructive, irreversible operation. Only supported on Data Warehouses (SQL Analytics Endpoints are read-only). Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. SQL Analytics Endpoints are rejected. qualified_table: Qualified table name, e.g. ``dbo.sales``. stat_name: Name of the statistic to drop.

Drop a SQL table. Only supported on Fabric Data Warehouses (not SQL Analytics Endpoints). The service rejects SQL Analytics Endpoints with a ``ToolError``. CAUTION: This is a destructive, irreversible operation. The table and all its data will be permanently deleted. Confirm with the user before calling. Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. SQL Analytics Endpoints are rejected. qualified_name: Dot-separated qualified table name, e.g. ``dbo.sales``.

Delete a Warehouse.

Deny permissions on a securable to a principal. Executes ``DENY <permissions> ON <scope> TO <principal>``. Blocked by ``FABRIC_MCP_READONLY``. Does NOT require ``FABRIC_MCP_ALLOW_DESTRUCTIVE``. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. permissions: Comma-separated permission tokens (e.g. ``"SELECT"``). principal: Principal name to deny (Entra UPN, app GUID, or role name). scope: Securable class -- ``"DATABASE"`` (default), ``"SCHEMA"``, or ``"OBJECT"``. schema: Schema name (required when scope is ``"SCHEMA"``). …

Disable SQL auditing on a warehouse or SQL analytics endpoint. CAUTION: Each audit write reads current settings via an eventually-consistent GET that may lag a recent PATCH by several minutes. Two audit writes issued within that window can cause the second to silently revert the first. Space audit writes at least a few minutes apart. Args: workspace: Workspace name or GUID. warehouse: Warehouse or SQL analytics endpoint name or GUID.

Disable custom SQL Pools for a workspace, preserving pool configuration. Re-enabling with enable_sql_pools restores the previously saved configuration. Requires workspace admin role. This tool targets a **beta / preview** API.

Remove a dynamic data mask from a column. Executes ``ALTER TABLE ... ALTER COLUMN ... DROP MASKED``. This is a permanently destructive operation -- the mask is removed from the column and unmasked values become visible to all users who query the column. Requires ``FABRIC_MCP_ALLOW_DESTRUCTIVE=1``. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. table_schema: Schema name of the target table. table_name: Name of the target table. column_name: Name of the column whose mask to remove.

Drop a T-SQL user-defined function. Function DDL is supported on both Data Warehouses and SQL Analytics Endpoints. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. qualified_name: Dot-separated qualified function name, e.g. ``dbo.fn_clean_input``. if_exists: When ``true``, a missing function is treated as a no-op and ``{"dropped": false}`` is returned instead of raising an error. Defaults to ``false``.

Drop a stored procedure. Stored procedures are supported on both Fabric Data Warehouses and SQL Analytics Endpoints. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified procedure name, e.g. ``dbo.usp_load``.

Drop a row-level security policy. Executes ``DROP SECURITY POLICY``. This is a permanently destructive operation -- the policy and all its predicates are removed. Requires ``FABRIC_MCP_ALLOW_DESTRUCTIVE=1``. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. policy_name: Qualified policy name (``"schema.name"`` or ``"name"``).

Drop the FILTER predicate from an existing row-level security policy. Executes ``ALTER SECURITY POLICY ... DROP FILTER PREDICATE ON``. The T-SQL ``DROP PREDICATE ON`` syntax takes no operation qualifier. There is no predicate-type parameter (#966): Fabric Data Warehouse supports FILTER predicates only. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. policy_name: Qualified policy name (``"schema.name"`` or ``"name"``). table_schema: Schema name of the target table. table_name: Name of the target table.

Drop a SQL view. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified view name, e.g. ``dbo.vw_sales``.

Enable SQL auditing on a warehouse or SQL analytics endpoint. CAUTION: The pre-flight GET used to round-trip the existing action-group list is eventually consistent and may lag a recent PATCH by several minutes. If the action-group list was changed within that window, this call may silently revert it. Space audit writes at least a few minutes apart. Args: workspace: Workspace name or GUID. warehouse: Warehouse or SQL analytics endpoint name or GUID. retention_days: Log retention in days (0-3650; 0 = unlimited). Default 0.

Enable custom SQL Pools for a workspace without modifying pool definitions. Requires workspace admin role. This tool targets a **beta / preview** API.

Execute an arbitrary SQL statement or batch against a warehouse or SQL Analytics Endpoint. Prefer dedicated tools for common operations: use read_table or read_view to fetch rows, count_table_rows or count_view_rows to count, list_tables, list_views, list_schemas to discover objects, get_table_columns or get_view_columns to inspect schemas, and delete_table, rename_table, or clear_table to mutate. Dedicated tools return structured, typed results with no dialect pitfalls or batch-truncation surprises. WARNING: this tool executes arbitrary SQL against the target. DDL (DROP, ALTER, TRUNCATE) an…

Generate dbt-fabric project file contents for a Fabric Data Warehouse. Returns the generated file contents as text strings. Because the MCP server cannot write to the caller's local filesystem, it is the caller's responsibility to write the returned strings to the appropriate files. Authentication note: dbt-fabric is Entra-only. ServicePrincipal mode emits ``{{ env_var(...) }}`` placeholders for tenant_id / client_id / client_secret — no literal secrets are included in the output. Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. project_name: dbt project …

Fetch the current SQL audit settings for a warehouse or SQL analytics endpoint. Args: workspace: Workspace name or GUID. warehouse: Warehouse or SQL analytics endpoint name or GUID.

Return the data-clustering columns of a table, ordered by clustering ordinal. Only supported on Fabric Data Warehouses. SQL Analytics Endpoints raise a ``ToolError``. Returns an empty list when no clustering columns are defined. Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. qualified_name: Dot-separated qualified table name, e.g. ``dbo.sales``.

Fetch the full definition of a T-SQL user-defined function (schema.fn). Returns the function definition (from ``sys.sql_modules``) and its parameter list (from ``sys.parameters``). Scalar UDFs and inline TVFs are supported on both Data Warehouses and SQL Analytics Endpoints. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. qualified_name: Dot-separated qualified function name, e.g. ``dbo.fn_clean_input``.

Fetch the full definition of a stored procedure (schema.proc). Stored procedures are supported on both Fabric Data Warehouses and SQL Analytics Endpoints. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified procedure name, e.g. ``dbo.usp_load``.

Capture the estimated SHOWPLAN_XML execution plan for a SQL query without executing it. This tool does NOT execute the query — it only retrieves the estimated execution plan as SHOWPLAN_XML. Because no data is modified, this tool is permitted even under ``FABRIC_MCP_READONLY=1``. The plan XML uses the standard namespace ``http://schemas.microsoft.com/sqlserver/2004/07/showplan`` and can be opened in SSMS, Azure Data Studio, or uploaded to pastetheplan.com for visual analysis. Since the query is not executed, DDL/DML query text is safe to plan without modifying any data. Supports both Ware…

Look up a completed query from queryinsights.exec_requests_history. Uses distributed_statement_id to retrieve full query text and execution metrics after the query completes. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. dist_statement_id: The GUID identifying the distributed statement to look up.

Return a single restore point by ID. Args: workspace: Workspace name or GUID. warehouse: Warehouse name or GUID. restore_point_id: The restore point ID string (e.g. ``"1726617378000"``).

Return details for a single SQL analytics endpoint (name or GUID).

Return details for a single SQL pool by name. Args: workspace: Workspace name or GUID. pool_name: The pool name. Requires workspace admin role. This tool targets a **beta / preview** API.

Return whether custom SQL Pools are enabled for a workspace. Returns only the workspace-level enabled/disabled switch (``customSQLPoolsEnabled``). Use ``list_sql_pools`` to see the pool list, or ``get_sql_pool`` for a single pool's details. Requires workspace admin role. This tool targets a **beta / preview** API endpoint that may change before general availability.

Return column metadata for a SQL table via ``sys.columns``. Works on both Fabric Data Warehouses and SQL Analytics Endpoints. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified table name, e.g. ``dbo.sales``.

Return health metrics for a table via ``sp_get_table_health_metrics``. Only supported on SQL Analytics Endpoints (not Data Warehouses). The proc surfaces Delta/Parquet layout issues such as small files, fragmentation, excessive deletes/updates, and delayed checkpoints. The stored procedure is Generally Available (announced at Build 2026) but its output column schema is not yet documented by Microsoft. Columns and rows are passed through verbatim. Args: workspace: Workspace name or GUID. item: SQL Analytics Endpoint name or GUID. Data Warehouses are rejected with a ``ToolEr…

Fetch the full definition of a view (schema.view). Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified view name, e.g. ``dbo.vw_sales``.

Return column metadata for a SQL view via ``sys.columns``. Works on both Fabric Data Warehouses and SQL Analytics Endpoints. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified view name, e.g. ``dbo.vw_sales``.

Return details for a single warehouse (name or GUID).

Return the current server-side database settings for a warehouse. Reads ``result_set_caching``, ``time_travel_retention_days``, ``time_travel_retention_cutoff_date``, and ``data_lake_log_publishing`` from ``sys.databases``. Both Data Warehouses and SQL Analytics Endpoints are supported. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID.

Return details for a single workspace (name or GUID).

Grant permissions on a securable to a principal. Executes ``GRANT <permissions> ON <scope> TO <principal>``. Blocked by ``FABRIC_MCP_READONLY``. Does NOT require ``FABRIC_MCP_ALLOW_DESTRUCTIVE``. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. permissions: Comma-separated permission tokens (e.g. ``"SELECT,INSERT"``). principal: Grantee principal name (Entra UPN, app GUID, or role name). scope: Securable class -- ``"DATABASE"`` (default), ``"SCHEMA"``, or ``"OBJECT"``. schema: Schema name (required when scope is ``"SCHEMA…

Load data into an existing Data Warehouse table via ``COPY INTO`` from a remote URL. The target table **must already exist** and have a compatible schema. For auto-create with schema inference from local files, use the CLI ``tables load --file --create`` command instead. ``if_exists`` controls behaviour when the table already exists: - ``"fail"`` (default): raise an error if the table already exists, or if it does not exist (the table must be created first with create_empty_table or create_table). - ``"append"``: load rows into the existing table without modification. Raises an error …

Terminate a session on a warehouse by session_id. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. session_id: Session ID to terminate (must be a positive integer).

List all available MCP tools grouped by domain. Call this tool first to discover what dedicated tools are available before falling back to ``execute_sql``. Dedicated tools return typed, structured results and avoid SQL dialect pitfalls. Returns: A dict mapping domain name to a sorted list of tool names in that domain. The dict itself is sorted by domain key.

List all Fabric capacities the caller has access to. Requires the ``Capacity.Read.All`` permission. Returns a 403 ToolError when the caller lacks that permission.

Return all active SQL connections on a warehouse or SQL Analytics Endpoint. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID.

List database principals from sys.database_principals. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. principal_type: Filter by type -- ``"user"`` for users, ``"role"`` for database roles, ``"all"`` or omit for no filter.

Return frequently-run queries from queryinsights.frequently_run_queries. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. limit: Maximum rows to return (1-10000, default 100). since: Optional ISO-8601 lower bound on last_run_start_time. until: Optional ISO-8601 upper bound on last_run_start_time.

List T-SQL user-defined functions on a warehouse or SQL Analytics Endpoint. Scalar UDFs (FN) and inline TVFs (IF) are preview features on Fabric DW as of mid-2026. Function DDL is supported on both Data Warehouses and SQL Analytics Endpoints. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. schema: When provided, only functions in this schema are returned. kind: Filter by function kind — ``"scalar"`` (FN only), ``"inline-tvf"`` (IF only), or ``"all"`` (FN + IF + TF, the default).

Return principals with access to a Warehouse or SQL Analytics Endpoint item. Uses the Fabric admin API. Accepts both Data Warehouses and SQL Analytics Endpoints -- the item kind is resolved automatically from its GUID. Requires Fabric Administrator role (admin API). See https://learn.microsoft.com/en-us/fabric/admin/microsoft-fabric-admin for details. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID.

Return active lock rows from sys.dm_tran_locks joined with sys.dm_exec_requests. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. limit: Maximum rows to return (1-10000, default 100). waiting_only: When True, restrict to locks with request_status WAIT or CONVERT. blocked_only: When True, show only blocked sessions (victims). The blocker's session_id appears in blocking_session_id. include_database: When True, include DATABASE-scoped lock rows (excluded by default).

Return long-running queries from queryinsights.long_running_queries. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. limit: Maximum rows to return (1-10000, default 100). since: Optional ISO-8601 lower bound on last_run_start_time. until: Optional ISO-8601 upper bound on last_run_start_time.

List columns with dynamic data masking from sys.masked_columns. Returns all masked columns on the target Data Warehouse or SQL Analytics Endpoint. Filter by *table_schema* and/or *table_name* to narrow results. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. table_schema: Optional schema filter (case-insensitive). Pass ``None`` to include all schemas. table_name: Optional table name filter (case-insensitive). Pass ``None`` to include all tables.

List stored procedures on a warehouse or SQL Analytics Endpoint. Stored procedures are supported on both Fabric Data Warehouses and SQL Analytics Endpoints. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. schema: When provided, only procedures in this schema are returned.

Return completed SQL requests from queryinsights.exec_requests_history. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. limit: Maximum rows to return (1-10000, default 100). since: Optional ISO-8601 lower bound on submit_time. until: Optional ISO-8601 upper bound on submit_time.

Return all restore points for a warehouse.

Return all currently-executing queries on a warehouse or SQL Analytics Endpoint. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID.

List user-defined SQL schemas on a warehouse or SQL Analytics Endpoint. System schemas (``sys``, ``INFORMATION_SCHEMA``, ``db_*`` fixed-role schemas, ``guest``) are excluded. ``dbo`` is included as it is user-writable. Listing schemas is a read-only operation and works on both Fabric Data Warehouses and SQL Analytics Endpoints. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID.

List row-level security policies from sys.security_policies. Returns all security policies and their predicates for the target Data Warehouse or SQL Analytics Endpoint. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID.

Return completed sessions from queryinsights.exec_sessions_history. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. limit: Maximum rows to return (1-10000, default 100). since: Optional ISO-8601 lower bound on session_start_time. until: Optional ISO-8601 upper bound on session_start_time.

Return all snapshots belonging to a warehouse.

List all SQL analytics endpoints in a workspace. Args: workspace: Workspace name or GUID. Optional when *all_workspaces* is ``True``; required otherwise. all_workspaces: When ``True``, ignore *workspace* and aggregate results across every workspace the caller can see.

List T-SQL database permissions from sys.database_permissions. Reads from sys.database_permissions joined to sys.database_principals. Returns DATABASE, SCHEMA, and OBJECT class securables with readable names. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. principal: Filter by principal name (optional). schema: Filter by schema name -- returns SCHEMA class rows for this schema (optional). object_name: Filter by qualified object name ``<schema>.<object>`` -- returns OBJECT class rows for this object (optional).

Return SQL pool insight events from queryinsights.sql_pool_insights. Args: workspace: Workspace name or GUID. warehouse: Warehouse or SQL Analytics Endpoint name or GUID. limit: Maximum rows to return (1-10000, default 100). since: Optional ISO-8601 lower bound on timestamp. until: Optional ISO-8601 upper bound on timestamp.

Return the list of custom SQL pools for a workspace. Requires workspace admin role. This tool targets a **beta / preview** API.

List statistics on a warehouse or SQL Analytics Endpoint. Both Data Warehouses and SQL Analytics Endpoints are supported. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. schema: When provided, only statistics on tables in this schema are returned. table: When provided, only statistics on this table (unqualified name) are returned. user_only: When True, only user-created statistics are returned. auto_only: When True, only auto-created statistics are returned.

Show per-table metadata sync freshness via ``sys.dm_db_external_tables_log_status``. Only supported on SQL Analytics Endpoints (not Data Warehouses), and only on endpoints created after the workspace's 'New metadata sync' (preview) setting was enabled. A table with no matching DMV row still appears, with its sync fields ``null`` instead of the row being dropped -- this means no sync information is available for that table, NOT that it has never synced; do not treat a ``null`` row as proof the table has never synced. IMPORTANT for agents: by default this listing only includes tables already p…

List SQL tables on a warehouse or SQL Analytics Endpoint. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. schema: When provided, only tables in this schema are returned.

List SQL views on a warehouse or SQL Analytics Endpoint. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. schema: When provided, only views in this schema are returned.

List all warehouses and SQL analytics endpoints in a workspace. Args: workspace: Workspace name or GUID. Optional when *all_workspaces* is ``True``; required otherwise. all_workspaces: When ``True``, ignore *workspace* and aggregate results across every workspace the caller can see.

List all Fabric workspaces the caller has access to. When a workspace allowlist is configured (via ``FABRIC_MCP_WORKSPACES`` env var or ``[mcp] workspace_allowlist`` in ``config.toml``) only the workspaces that match the allowlist (by name or GUID) are returned.

Load data into a Data Warehouse table via ``COPY INTO`` from a remote URL. Supported file types: ``CSV``, ``PARQUET``. JSON remote URLs require downloading and converting locally first; use the CLI ``tables load`` command for local files (including JSON). For OneLake or same-tenant URLs, no credential is needed. For secured external URLs (Azure Blob Storage SAS, etc.), supply ``credential_type`` and the appropriate ``secret``/``identity`` values. CAUTION: This operation loads data into the target table. Confirm the source URL and target table before calling. Note: ``secret`` / ``identit…

Return permissions for the current connection via sys.fn_my_permissions. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. scope: Scope string -- ``"database"`` (default), ``"schema:<name>"``, or ``"object:<schema>.<object>"``.

Return up to *count* rows from a table as JSON-serialisable columns + rows. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified table name, e.g. ``dbo.sales``. count: Maximum number of rows to return (1-10000, default 10). as_of: Optional ISO-8601 UTC timestamp for a point-in-time (time-travel) read. When supplied the query uses ``OPTION (FOR TIMESTAMP AS OF ...)``. Omit to read the latest data.

Return up to *count* rows from a view as JSON-serialisable columns + rows. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified view name, e.g. ``dbo.vw_sales``. count: Maximum number of rows to return (1-10000, default 10). as_of: Optional ISO-8601 UTC timestamp for a point-in-time (time-travel) read. When supplied the query uses ``OPTION (FOR TIMESTAMP AS OF ...)``. Omit to read the latest data.

Refresh metadata for a SQL analytics endpoint (sync from the underlying Lakehouse). This is a long-running operation (LRO) that is polled to completion. Returns a list of per-table sync results. Use this tool for SCHEMA changes (tables added or dropped). For cheap, per-table DATA-only staleness on a table you already know exists, use ``refresh_table_metadata`` instead -- it does not pick up schema changes. Args: workspace: Workspace name or GUID. endpoint: SQL analytics endpoint name or GUID. recreate_tables: When ``True``, drop and recreate all tables during the refresh.…

Refresh one table's metadata via ``sys.sp_dw_refresh_ext_table``. This is the cheap, per-table refresh for DATA-only staleness: it re-reads the table's underlying Delta log without a full item-level sync. Use ``refresh_sql_endpoint_metadata`` instead when the SCHEMA changed (tables added or dropped) -- this tool does not pick up schema changes. Only supported on SQL Analytics Endpoints (not Data Warehouses), and only on endpoints created after the workspace's 'New metadata sync' (preview) setting was enabled. Mutating (respects ``FABRIC_MCP_READONLY``) but NOT destructive -- it never drops o…

Remove a single audit action group without overwriting the others. Idempotent -- if the group is not present the current settings are returned unchanged. Auditing must already be enabled. CAUTION: changes take effect immediately on the live audit policy. CAUTION: Each audit write reads current settings via an eventually-consistent GET that may lag a recent PATCH by several minutes. Two audit writes issued within that window can cause the second to silently revert the first. Space audit writes at least a few minutes apart. Args: workspace: Workspace name or GUID. warehouse: Warehou…

Rename a warehouse snapshot.

Rename a SQL table via ``sp_rename`` (Data-Warehouse-only). Renames the table in-place within the same schema using T-SQL ``EXEC sp_rename``. Both the current qualified name and the new bare name are passed as bound parameters — no SQL injection is possible. ``sp_rename`` cannot move a table to a different schema, so *new_name* must be an unqualified (bare) name without a dot. Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. SQL Analytics Endpoints are rejected. qualified_name: Current dot-separated qualified table name, e.g. ``dbo.sales``. ne…

Rename a SQL view via sp_rename. Works on both Data Warehouses and SQL Analytics Endpoints. The new name must be a bare (unqualified) identifier — ``sp_rename`` cannot move a view across schemas. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Current dot-separated qualified view name, e.g. ``dbo.vw_sales``. new_name: New bare view name (no schema prefix), e.g. ``vw_revenue``.

Rename a Warehouse (and optionally update its description).

Restore a warehouse in-place to a restore point. WARNING: This is a destructive, long-running operation. The warehouse will be unavailable for approximately 10 minutes while the restore completes. Args: workspace: Workspace name or GUID. warehouse: Warehouse name or GUID. restore_point_id: The restore point ID string to restore to.

Revoke permissions on a securable from a principal. Executes ``REVOKE <permissions> ON <scope> FROM <principal>``. Blocked by ``FABRIC_MCP_READONLY``. Requires ``FABRIC_MCP_ALLOW_DESTRUCTIVE=1`` because revoke removes an existing permission (destructive operation). Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. permissions: Comma-separated permission tokens (e.g. ``"SELECT,INSERT"``). principal: Principal name to revoke from (Entra UPN, app GUID, or role name). scope: Securable class -- ``"DATABASE"`` (default), ``"SCHEMA"``, or …

Roll a snapshot's timestamp forward (or reset to current). Args: workspace: Workspace name or GUID. warehouse: Parent warehouse name or GUID (used for the SQL connection). snapshot_name: The snapshot database name to roll. new_dt: Optional ISO-8601 datetime string; defaults to CURRENT_TIMESTAMP. Naive datetimes (no timezone offset) are interpreted as UTC.

Replace the audited action groups for a warehouse or SQL analytics endpoint. Only replaces the action groups. Does not toggle the audit enabled or disabled state; if auditing was Disabled before the call it remains Disabled afterwards. CAUTION: Each audit write reads current settings via an eventually-consistent GET that may lag a recent PATCH by several minutes. The retention period read from that GET is round-tripped; if retention was changed within the lag window, this call may silently revert it. Space audit writes at least a few minutes apart. Args: workspace: Workspace name or GUI…

Update the audit log retention period without changing the audit enabled/disabled state. Audit must already be enabled; if disabled, enable it first with ``enable_audit``. CAUTION: The pre-flight GET used to round-trip the existing action-group list is eventually consistent and may lag a recent PATCH by several minutes. If the action-group list was changed within that window, this call may silently revert it. Space audit writes at least a few minutes apart. Args: workspace: Workspace name or GUID. warehouse: Warehouse or SQL analytics endpoint name or GUID. days: Retention perio…

Change (or remove) the data-clustering columns of an existing table. Rebuilds the table via a transactional CTAS-swap: 1. ``CREATE TABLE [schema].[__recluster_<hex>] [WITH (CLUSTER BY (...))] AS SELECT * FROM [schema].[orig]`` 2. ``DROP TABLE [schema].[orig]`` 3. ``EXEC sp_rename`` to restore the original name All three steps run inside ONE transaction. Any failure rolls back automatically — no orphan temp table is left behind. CAUTION: This operation copies the full table (runtime is proportional to table size). Dependent views and stored procedures that reference this table by name …

Apply or replace a dynamic data mask on a column. Executes ``ALTER TABLE ... ALTER COLUMN ... ADD MASKED WITH (FUNCTION = '...')``. ``ADD MASKED`` replaces any existing mask on the column without error. Blocked by ``FABRIC_MCP_READONLY``. Supported mask function types: - ``"default"`` -- full masking; no extra args. - ``"email"`` -- email masking (exposes first char and ``".com"`` suffix); no extra args. - ``"random"`` -- numeric random mask; requires *start* and *end*. - ``"partial"`` -- custom string partial mask; requires *prefix*, *padding*, and *suffix*. Args: workspace: Workspac…

Enable or disable Delta Lake log publishing on a warehouse. Executes ``ALTER DATABASE CURRENT SET DATA_LAKE_LOG_PUBLISHING = { AUTO | PAUSED }`` and returns the effective settings read back after the change. Only supported on Fabric Data Warehouses (not SQL Analytics Endpoints). SQL Analytics Endpoints are rejected with a ``ToolError``. Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. SQL Analytics Endpoints are rejected. enabled: ``True`` to enable Delta Lake log publishing (``= AUTO``), ``False`` to disable it (``= PAUSED``).

Enable or disable result-set caching on a warehouse. Executes ``ALTER DATABASE CURRENT SET RESULT_SET_CACHING { ON | OFF }`` and returns the effective settings read back after the change. Only supported on Fabric Data Warehouses (not SQL Analytics Endpoints). SQL Analytics Endpoints are rejected with a ``ToolError``. Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. SQL Analytics Endpoints are rejected. enabled: ``True`` to enable result-set caching, ``False`` to disable it.

Enable or disable a row-level security policy. Executes ``ALTER SECURITY POLICY ... WITH (STATE = ON|OFF)``. Not destructive -- enabling or disabling a policy is reversible. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. policy_name: Qualified policy name (``"schema.name"`` or ``"name"``). enabled: ``True`` to enable the policy, ``False`` to disable it.

Set the time-travel retention period on a warehouse. Executes ``ALTER DATABASE CURRENT SET TIME_TRAVEL_RETENTION_PERIOD = <n> DAYS`` and returns the effective settings read back after the change. Only supported on Fabric Data Warehouses (not SQL Analytics Endpoints). SQL Analytics Endpoints are rejected with a ``ToolError``. Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. SQL Analytics Endpoints are rejected. days: Retention period in days. Must be in the range 1-120 (inclusive).

Set the default Data Warehouse collation for a workspace. Args: workspace: Workspace name or GUID. collation: Collation to apply. Fabric Data Warehouse supports a fixed set of collations. Supported values include: - ``Latin1_General_100_BIN2_UTF8`` (recommended default) - ``Latin1_General_100_CI_AS_KS_WS_SC_UTF8`` - ``Latin1_General_CI_AS`` - ``SQL_Latin1_General_CP1_CI_AS`` Supplying an unsupported value will cause the Fabric API to return an error. See the Fabric documentation for the full list of supported collati…

Show details of a statistic using DBCC SHOW_STATISTICS. Returns the stat header, density vector, and histogram steps. Both Data Warehouses and SQL Analytics Endpoints are supported. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_table: Qualified table name, e.g. ``dbo.sales``. stat_name: The name of the statistic to show. histogram_only: When True, return only the histogram steps.

Take ownership of a Warehouse.

Move a T-SQL user-defined function to another schema via ALTER SCHEMA TRANSFER. Function DDL is supported on both Data Warehouses and SQL Analytics Endpoints -- unlike table transfer, no endpoint guard applies here. CAUTION: ``ALTER SCHEMA ... TRANSFER`` does not rewrite the schema name inside the function's stored definition (``sys.sql_modules.definition``). After a transfer, ``get_function`` may still show the *old* schema name in the ``CREATE ... AS`` header, even though the function now lives in the new schema. This tool does not rewrite the definition text. Args: workspace: Workspa…

Move a stored procedure to another schema via ``ALTER SCHEMA ... TRANSFER OBJECT::...``. Stored procedures are supported on both Fabric Data Warehouses and SQL Analytics Endpoints; unlike ``transfer_table``, no endpoint guard is applied here. CAUTION: ``ALTER SCHEMA ... TRANSFER`` moves the procedure but does NOT rewrite the schema name inside its stored definition. After a transfer, ``get_procedure`` may still show the OLD schema name in the ``CREATE ... AS`` header even though the procedure now lives in the new schema. Args: workspace: Workspace name or GUID. item: Warehouse or SQ…

Move a SQL table to another schema via ``ALTER SCHEMA ... TRANSFER OBJECT::...``. Data-Warehouse-only: transferring a table between schemas via T-SQL is not supported on the Fabric SQL Analytics Endpoint and can break the OneLake sync, so SQL Analytics Endpoints are rejected with a ``ToolError``. CAUTION: Permissions granted directly on the table are dropped by the engine when the schema changes. Dependent views and stored procedures that reference the table by its old schema-qualified name are NOT automatically updated and may need refreshing after the transfer. Args: workspace: Worksp…

Move a SQL view to another schema via ``ALTER SCHEMA ... TRANSFER OBJECT::...``. Works on both Data Warehouses and SQL Analytics Endpoints — no DW-only guard is applied. CAUTION: ``ALTER SCHEMA ... TRANSFER`` moves the view but does **not** rewrite the schema name inside the view's stored definition (``sys.sql_modules.definition``, ``OBJECT_DEFINITION()``). After a transfer, the returned (and any subsequent ``get_view``) ``definition`` may still show the *old* schema name in the ``CREATE ... AS`` header, even though the view now lives in the new schema. This tool does not rewrite the definit…

Redefine a T-SQL user-defined function via CREATE OR ALTER FUNCTION. Note: ALTER FUNCTION cannot change the function kind (e.g. scalar to inline TVF). The body must be compatible with the original function's kind. Scalar UDFs and inline TVFs are preview features on Fabric DW as of mid-2026. Function DDL is supported on both Data Warehouses and SQL Analytics Endpoints. CAUTION: ``body`` is executed verbatim as DDL. Ensure the body matches the user's intent before calling this tool. Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. q…

Redefine a stored procedure via CREATE OR ALTER PROCEDURE. Stored procedures are supported on both Fabric Data Warehouses and SQL Analytics Endpoints. CAUTION: ``body`` is executed verbatim as DDL. Ensure the body matches the user's intent before calling this tool. Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified procedure name, e.g. ``dbo.usp_load``. body: The new procedure body (the AS … section).

Rename and/or update the description of a restore point. At least one of *name* or *description* must be provided. Args: workspace: Workspace name or GUID. warehouse: Warehouse name or GUID. restore_point_id: The restore point ID string. name: New display name (max 128 chars). description: New description (max 512 chars).

Update an existing SQL pool. Only the parameters you supply are changed. Args: workspace: Workspace name or GUID. name: Name of the pool to update. max_percent: New max resource percentage (1-100), or omit to keep current. is_default: Set or clear the default flag, or omit to keep current. optimize_for_reads: Enable/disable read optimisation, or omit to keep current. classifier_type: New classifier type, or omit to keep current. classifier_values: New classifier value list, or omit to keep current. Requires workspace admin role. This tool targets a **beta / prev…

Update an existing statistic via UPDATE STATISTICS. Only supported on Data Warehouses (SQL Analytics Endpoints are read-only). Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. SQL Analytics Endpoints are rejected. qualified_table: Qualified table name, e.g. ``dbo.sales``. stat_name: Name of the statistic to update. fullscan: When True (default), use WITH FULLSCAN. Ignored when sample_percent is provided. sample_percent: Sample percentage (1-100). When provided, overrides fullscan and uses WITH SAMPLE n PERCENT.

Redefine a SQL view via CREATE OR ALTER VIEW. CAUTION: ``select_body`` is executed verbatim as DDL. Ensure the body matches the user's intent before calling this tool. ``select_body`` must be a single read-only SELECT or WITH (CTE) statement. The guard is always on and fail-closed: a write keyword (DELETE, DROP, INSERT, etc.) or a semicolon anywhere in the body is rejected, even inside a string literal or quoted identifier. If a legitimate view body contains a write keyword (e.g. a column alias 'DELETE'), rewrite the expression to avoid the keyword. Args: workspace: Workspace name or …