Assign a workspace to a Fabric capacity.

Args: workspace: Workspace name or GUID. capacity_id: UUID of the capacity to assign the workspace to.

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.

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.

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

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 collations.

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.

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

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 cause the Fabric API to
    return an error.  See the Fabric documentation for the full
    list of supported collations.
description: Optional description for the new warehouse.

Rename a Warehouse (and optionally update its description).

Delete a Warehouse.

Take ownership of 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.

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

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.

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. Use to resolve inconsistencies or force a clean rebuild. Destructive — use with caution. Requires FABRIC_MCP_ALLOW_DESTRUCTIVE=1 when enabled.

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.

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).

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 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>".

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"). object_name: Qualified object name <schema>.<object> (required when scope is "OBJECT"). with_grant_option: When True, allows the grantee to grant the permission to others (adds WITH GRANT OPTION). columns: Optional list of column names for column-level security (OBJECT scope only; permissions must be SELECT, UPDATE, or REFERENCES). Pass None (omit) for no column restriction. Passing an empty list raises a ToolError.

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"). object_name: Qualified object name <schema>.<object> (required when scope is "OBJECT"). columns: Optional list of column names for column-level security (OBJECT scope only; permissions must be SELECT, UPDATE, or REFERENCES). Pass None (omit) for no column restriction. Passing an empty list raises a ToolError.

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 "OBJECT". schema: Schema name (required when scope is "SCHEMA"). object_name: Qualified object name <schema>.<object> (required when scope is "OBJECT"). columns: Optional list of column names for column-level security (OBJECT scope only; permissions must be SELECT, UPDATE, or REFERENCES). Pass None (omit) for no column restriction. Passing an empty list raises a ToolError. grant_option_only: When True, revokes only the grant option (adds GRANT OPTION FOR), leaving the base permission in place. cascade: When True, cascades the revocation to principals the grantee has granted the permission to (adds CASCADE).

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.

Create a row-level security policy.

Executes CREATE SECURITY POLICY with one or more FILTER predicates. There is no predicate-type option (#966): Fabric Data Warehouse supports FILTER predicates only. Each entry in predicates must include:

• fn_schema: schema of the predicate function

• fn_name: name of the predicate function

• fn_args: list of column names to pass to the function

• table_schema: schema of the target table

• table_name: name of the target table

Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. policy_name: Qualified policy name ("schema.name" or "name"). predicates: List of predicate definitions (see above). state: Initial policy state -- True to enable, False to disable (default: True).

Add a FILTER predicate to an existing row-level security policy.

Executes ALTER SECURITY POLICY ... ADD FILTER PREDICATE. There is no predicate-type or operation 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"). fn_name: Name of the predicate function. fn_args: Column names to pass to the predicate function. table_schema: Schema name of the target table. table_name: Name of the target table. fn_schema: Schema name of the predicate function (optional -- omit when the function lives in the default schema).

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.

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.

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").

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.

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: 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 to mask. fn_type: Mask function type -- "default", "email", "random", or "partial" (case-insensitive). start: Lower bound for random() masking (required when fn_type is "random"). Must be <= end. end: Upper bound for random() masking (required when fn_type is "random"). prefix: Leading characters to expose for partial() masking (required when fn_type is "partial"). padding: Replacement padding string for partial() masking (required when fn_type is "partial"). Must not contain ", ), ;, --, control characters (including U+0085, U+2028, U+2029), and must not exceed 128 characters. suffix: Trailing characters to expose for partial() masking (required when fn_type is "partial").

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.

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.

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.

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.

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 GUID. warehouse: Warehouse or SQL analytics endpoint name or GUID. action_groups: List of audit action group names.

Add a single audit action group without overwriting the others.

Idempotent -- if the group is already 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: Warehouse or SQL analytics endpoint name or GUID. group: Action group name, e.g. BATCH_COMPLETED_GROUP.

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: Warehouse or SQL analytics endpoint name or GUID. group: Action group name, e.g. BATCH_COMPLETED_GROUP.

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 period in days (1-3650). The API enforces its own upper bound.

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.

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.

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).

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 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 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.

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.

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) and DML (DELETE, UPDATE) are permitted unless FABRIC_MCP_READONLY=1 is set. Use only when the user explicitly requests data modification. Default to SELECT when the user's intent is read-only investigation.

Supports both Warehouse and SQL Analytics Endpoint items. Multi-statement batches are allowed; only the last result set is returned. DDL/DML statements that produce no result set return columns=[] and rows=[].

datetime and Decimal column values are pre-serialised to strings. bytes / varbinary columns are base64-encoded and their column names are suffixed with __base64.

For large tables, add a TOP clause or WHERE predicate to the query rather than relying solely on max_rows. The driver fetches at most max_rows + 1 rows (enough to detect truncation) so memory is bounded, but pushing the limit into the query itself is always more efficient.

Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. query: SQL statement or batch to execute. max_rows: Maximum rows to return (1-10000, default 1000). When the result set is larger the response includes "truncated": true.

Returns: A dict with keys columns (list[str]), rows (list[list[Any]]), rowcount (int; -1 when the driver does not report a count), row_count_returned (int), and truncated (bool).

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 Warehouse and SQL Analytics Endpoint items.

Format options:

• "xml" (default, backwards-compatible) — returns the raw SHOWPLAN_XML string in plan_xml. Existing callers relying on {"plan_xml": str} continue to work unchanged.

• "tree" — parses the XML into a native nested list of dicts (one entry per statement) in plan. Best for agent reasoning over the plan structure.

• "json" — same tree, serialised to an indented JSON string in plan_json. Ready to write out or pass through as compact text.

• "mermaid" — renders a Mermaid flowchart TD diagram string in mermaid. Paste into mermaid.live or embed in GitHub Markdown.

Artifact formats (SVG/HTML/DOT) are CLI-only. They write files to disk and are only available via fdw sql plan --format <fmt> -o <file>. The MCP server never writes files (ambiguous cwd, invisible side-effects).

Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. query: SQL statement to generate an estimated execution plan for. format: Output format — one of "xml" (default), "tree", "json", or "mermaid".

Returns: A dict whose shape depends on format:

- ``xml``     → ``{"format": "xml",     "plan_xml":   str}``
- ``tree``    → ``{"format": "tree",    "plan":       list[dict]}``
- ``json``    → ``{"format": "json",    "plan_json":  str}``
- ``mermaid`` → ``{"format": "mermaid", "mermaid":    str}``

Return all snapshots belonging to a warehouse.

Create a new warehouse snapshot.

Args: workspace: Workspace name or GUID. warehouse: Warehouse name or GUID. name: Display name for the new snapshot. description: Optional description. snapshot_dt: Optional ISO-8601 datetime string for the snapshot point-in-time. Naive datetimes (no timezone offset) are interpreted as UTC.

Rename a warehouse snapshot.

Delete a warehouse snapshot.

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.

Return all restore points for a warehouse.

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").

Create a restore point for a warehouse at the current timestamp.

Args: workspace: Workspace name or GUID. warehouse: Warehouse name or GUID. name: Optional display name (max 128 chars). description: Optional description (max 512 chars).

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).

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.

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.

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.

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.

Return the total row count of a view via SELECT COUNT_BIG(*).

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. as_of: Optional ISO-8601 UTC timestamp for a point-in-time (time-travel) count. When supplied the query uses OPTION (FOR TIMESTAMP AS OF ...). Omit to count the latest data.

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.

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.

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: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified view name, e.g. dbo.vw_sales. select_body: Single read-only SELECT or WITH (CTE) statement for the view body. Write keywords and semicolons are rejected fail-closed, even inside string literals or quoted identifiers.

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 GUID. item: Warehouse or SQL endpoint name or GUID. qualified_name: Dot-separated qualified view name, e.g. dbo.vw_sales. select_body: Single read-only SELECT or WITH (CTE) statement for the new view body. Write keywords and semicolons are rejected fail-closed, even inside string literals or quoted identifiers.

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.

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.

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 definition text — doing so would require parsing and regenerating SQL, which this project deliberately avoids.

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. target_schema: Schema to move the view into, e.g. archive.

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.

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.

Create a new stored 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 procedure body (the AS … section).

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).

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.

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 SQL endpoint name or GUID. qualified_name: Current dot-separated qualified procedure name, e.g. dbo.usp_load. target_schema: Schema to move the procedure into, e.g. archive.

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).

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.

Create a new T-SQL user-defined function.

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.

The body should include the parameter list, RETURNS clause, and function body (everything that follows CREATE FUNCTION [schema].[name]).

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. body: The function body (parameter list, RETURNS clause, and implementation).

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. qualified_name: Dot-separated qualified function name, e.g. dbo.fn_clean_input. body: The new function body (parameter list, RETURNS clause, and implementation).

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: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. qualified_name: Current dot-separated qualified function name, e.g. dbo.fn_clean_input. target_schema: Schema to move the function into, e.g. archive.

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.

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.

Create a new SQL schema on a warehouse or SQL Analytics Endpoint.

Both Fabric Data Warehouses and SQL Analytics Endpoints support CREATE SCHEMA per the Microsoft Fabric T-SQL reference.

Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID. name: The schema name. Must be a valid SQL identifier.

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. item: Warehouse or SQL Analytics Endpoint name or GUID. name: The schema name to drop. cascade: When True, drop all tables and views in the schema first. Defaults to False.

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.

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 the total row count of a table via SELECT COUNT_BIG(*).

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. as_of: Optional ISO-8601 UTC timestamp for a point-in-time (time-travel) count. When supplied the query uses OPTION (FOR TIMESTAMP AS OF ...). Omit to count the latest data.

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.

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.

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. If a legitimate query body contains a write keyword (e.g. a column alias 'DELETE'), rewrite the expression to avoid the keyword.

When cluster_by is supplied, the DDL becomes CREATE TABLE … WITH (CLUSTER BY ([c1], [c2])) AS SELECT …. Column existence is not validated for CTAS because the result columns come from the SELECT and are not known ahead of time.

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. select_body: Single read-only SELECT or WITH (CTE) statement for the CTAS source. Write keywords and semicolons are rejected fail-closed, even inside string literals or quoted identifiers. cluster_by: Optional list of column names for the CLUSTER BY clause (up to 4).

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.

Truncate a SQL table (remove all rows, keep structure).

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. All rows will be permanently deleted. The table structure and schema are preserved. 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.

Create an empty table from an explicit column spec (DDL only, no data).

Builds CREATE TABLE [schema].[table] (col TYPE [NULL|NOT NULL], …) from the supplied column definitions. No data is read or inserted; this is a pure DDL operation.

Server-side file access is unreliable in MCP deployments, so CSV/Parquet inference is not available via this tool — use the fabric-dw tables create --from-parquet or --from-csv CLI commands instead.

Only supported on Fabric Data Warehouses (not SQL Analytics Endpoints).

When cluster_by is supplied, each column must appear in columns.

Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. qualified_name: Dot-separated qualified table name, e.g. dbo.sales. columns: List of column definitions, each a dict with: name (str) — column identifier; sql_type (str) — Fabric-DW T-SQL type, e.g. "INT", "VARCHAR(255)"; nullable (bool, optional, default true) — whether the column allows NULL. cluster_by: Optional list of column names for the CLUSTER BY clause (up to 4). Each name must appear in columns.

Create a zero-copy clone of a table using CREATE TABLE … AS CLONE OF ….

Only supported on Fabric Data Warehouses (not SQL Analytics Endpoints).

Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. source: Qualified source table name, e.g. dbo.sales. new_table: Qualified name for the new cloned table, e.g. dbo.sales_clone. at: Optional ISO-8601 UTC timestamp for a point-in-time clone, e.g. 2024-05-20T14:00:00. Must be within the data-retention window (30 days by default). When omitted, the clone reflects the current state of the source table.

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 ToolError. qualified_name: Dot-separated qualified table name, e.g. dbo.sales.

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. new_name: New table name (unqualified, e.g. sales_v2). Must not contain a dot.

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: 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. target_schema: Schema to move the table into, e.g. archive.

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 are NOT automatically updated by sp_rename and may need refreshing after the swap.

Only supported on Fabric Data Warehouses (not SQL Analytics Endpoints).

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. cluster_by: New list of column names for the CLUSTER BY clause (up to 4). Pass null or an empty list to remove clustering (rebuilds table without CLUSTER BY).

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 / identity values are accepted but are NEVER logged or included in any debug output.

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. url: Source URL (OneLake DFS URL or external Azure Blob URL). file_type: CSV or PARQUET. credential_type: Credential type for the source URL. secret: Credential secret (not logged). identity: Identity for managed-identity or service-principal. delimiter: CSV column delimiter. has_header: Whether the CSV file has a header row. encoding: CSV file encoding. field_quote: CSV field-quote character. row_terminator: CSV row terminator. max_errors: Maximum errors before aborting. rejected_row_location: URL for rejected-row output.

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 if the table does not exist.

• "truncate": TRUNCATE the existing table, then load, both inside a single transaction so a failed load leaves the existing rows intact (atomic replace). Requires FABRIC_MCP_ALLOW_DESTRUCTIVE=1. Raises an error if the table does not exist.

• "replace": not supported for remote URLs (schema inference requires downloading the file). Use "truncate" to keep the current schema, or download locally and use the CLI with --create --if-exists replace.

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 supply credential_type and the appropriate secret/identity values.

CAUTION: truncate is permanently destructive. Confirm the source URL and target table before calling.

Note: secret / identity values are accepted but are NEVER logged or included in any debug output.

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. url: Source URL (OneLake DFS URL or external Azure Blob URL). file_type: CSV or PARQUET. if_exists: Policy when the target table already exists. credential_type: Credential type for the source URL. secret: Credential secret (not logged). identity: Identity for managed-identity or service-principal. delimiter: CSV column delimiter. has_header: Whether the CSV file has a header row. encoding: CSV file encoding. field_quote: CSV field-quote character. row_terminator: CSV row terminator. max_errors: Maximum errors before aborting. rejected_row_location: URL for rejected-row output.

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.