Microsoft Fabric MCP Server

Documentation

Documentation link · transport

Tools

• docs_list-item-types — Lists the Fabric item types that have public API specifications available, plus the non-item API areas (platform, admin, spark, realTimeIntelligence).
• docs_item-api-spec — Retrieves the complete OpenAPI specification for a specific Fabric item type.
• docs_platform-api-spec — Retrieves the OpenAPI specification for core Fabric platform APIs.
• docs_item-definitions — Retrieves the JSON schema definition for a Fabric item type.
• docs_best-practices — Retrieves best practice documentation and guidance for a specific topic.
• docs_api-examples — Retrieves example API request/response files for a specific item type.
• onelake_list-workspaces — Lists available Microsoft Fabric workspaces.
• onelake_list-items — Lists workspace items with high-level metadata.
• onelake_list-items-dfs — Lists Fabric items via the DFS endpoint.
• onelake_list-files — Lists files using the hierarchical file-list endpoint.
• onelake_download-file — Downloads a OneLake file.
• onelake_upload-file — Uploads a file to OneLake storage.
• onelake_delete-file — Deletes a file from OneLake storage.
• onelake_create-directory — Creates a directory via the DFS endpoint.
• onelake_delete-directory — Deletes a directory (optionally recursive).
• onelake_get-table-config — Retrieves table API configuration for a workspace item.
• onelake_list-table-namespaces — Lists table namespaces (schemas) exposed through the table API.
• onelake_get-table-namespace — Retrieves metadata for a specific namespace.
• onelake_list-tables — Lists tables published within a namespace.
• onelake_get-table — Retrieves the definition for a specific table.
• onelake_list-data-access-roles — Lists all data access roles defined on a single item.
• onelake_get-data-access-role — Gets the full definition of a single data access role (members, permissions, decision rules).
• onelake_create-or-update-data-access-role — Upserts a single data access role on a single item.
• onelake_delete-data-access-role — Deletes a single data access role from an item.
• onelake_list-shortcuts — Lists shortcuts defined within an item. Hides DW-managed shortcuts by default (`--include-managed` to show).
• onelake_get-shortcut — Gets the properties of a single shortcut.
• onelake_create-shortcut-onelake — Creates a shortcut pointing to another OneLake location.
• onelake_create-shortcut-adls-gen2 — Creates a shortcut pointing to Azure Data Lake Storage Gen2.
• onelake_create-shortcut-amazon-s3 — Creates a shortcut pointing to Amazon S3.
• onelake_create-shortcut-azure-blob — Creates a shortcut pointing to Azure Blob Storage.
• onelake_create-shortcut-gcs — Creates a shortcut pointing to Google Cloud Storage.
• onelake_create-shortcut-s3-compatible — Creates a shortcut pointing to S3-compatible storage.
• onelake_create-shortcut-dataverse — Creates a shortcut pointing to a Dataverse environment.
• onelake_create-shortcut-onedrive-sharepoint — Creates a shortcut pointing to OneDrive/SharePoint Online.
• onelake_delete-shortcut — Deletes a single shortcut from an item (preserves destination data).
• onelake_reset-shortcut-cache — Drops cached shortcut reads, forcing re-resolution from destination.
• onelake_get-settings — Gets OneLake settings for a workspace (diagnostics + immutability policy).
• onelake_modify-diagnostics — Modifies diagnostic logging configuration (status, destination lakehouse) at workspace scope.
• onelake_modify-immutability-policy — Modifies the workspace-level OneLake immutability policy (scope, retention days).
• core_assign-workspace-to-capacity — Submits one request to assign an existing workspace to a capacity. Returns an accepted/pending receipt, not confirmation of completion.
• core_create-item — Creates a Fabric item by workspace UUID, optionally with a definition or creation payload, an existing folder ID, definition options, and label settings. Returns completed metadata or an accepted operation receipt; optionally waits within a bounded budget.
• core_create-workspace — Creates a Fabric workspace, optionally assigning an existing capacity and domain in the same request.
• core_delete-item — Deletes one known Fabric item using workspace and item UUIDs. Permanent deletion requires explicitly setting `hard-delete` to `true`.
• core_delete-workspace — Deletes one explicitly identified Fabric workspace **and the items under it**. Requires a workspace UUID and workspace Admin access.
• core_get-capacity — Gets one Fabric capacity's ID, display name, SKU, region, and state using its capacity UUID.
• core_get-item — Gets generic metadata for one existing Fabric item using its workspace ID and item ID. Does not read item data or definitions.
• core_get-item-definition — Retrieves typed definition parts inline, optionally waits for completion, or resumes a completed definition operation. Can explicitly export to a new local directory without overwriting files.
• core_get-operation-result — Reads one completed operation's JSON or empty result, up to 1 MiB. Binary results are unsupported.
• core_get-operation-state — Reads one operation's current state and polling guidance, without polling or resubmitting the original request.
• core_get-workspace — Gets one workspace's metadata by UUID, including optional capacity, domain, identity, tags, and endpoints. Does not read item data or modify resources.
• core_list-capacities — Lists one page of accessible Fabric capacity metadata: ID, display name, SKU, region, and state, plus available continuation information.
• core_list-items — Lists one page of Fabric Core item metadata in a known workspace or folder, with optional type filtering and continuation information.
• core_list-workspaces — Lists one page of accessible workspace management metadata, optionally filtered by the caller's workspace roles. Returns continuation information and can request workspace-specific API endpoints.
• core_search-catalog — Searches one page of OneLake catalog metadata across workspaces. Continue with the returned token without repeating search or filter.
• core_update-item — Updates an existing item's display name or description and returns metadata only.
• core_update-item-definition — Replaces a known item's complete definition from inline content or explicitly selected saved files. Optionally applies supplied `.platform` metadata and waits for a no-result operation.
• core_update-workspace — Renames a workspace or updates or clears its description by UUID, leaving omitted properties unchanged. Requires workspace Admin access.
• jobs_cancel-item-job-instance — Requests cancellation of one known item job with one POST. Returns cancellation requested, not a Cancelled job state, with known IDs and validated guidance for a separate Get. Never automatically retries or polls.
• jobs_get-item-job-instance — Reads one known item's job instance, including status, timing, safe failure metadata, and available retry guidance. Does not poll, run, cancel, or schedule jobs.
• jobs_list-item-job-instances — Reads one complete page of an item's job snapshots, with safe failure metadata and an unchanged token for an explicitly requested next page. Does not fetch individual jobs or infer full history.
• jobs_list-item-schedules — Reads one complete schedule page for an explicit item and job type, preserving available settings, owner, and execution data. Requires explicit continuation and never changes or executes schedules.
• jobs_run-on-demand-item-job — Submits exactly one on-demand item job and returns an accepted receipt, a trustworthy job-instance ID when available, and validated first-status-read guidance. Never automatically retries or polls.
• datafactory_list-pipelines — Lists all pipelines in a Microsoft Fabric workspace.
• datafactory_create-pipeline — Creates a new pipeline in a workspace.
• datafactory_get-pipeline — Gets details of a specific pipeline.
• datafactory_run-pipeline — Runs a pipeline on demand.
• datafactory_list-dataflows — Lists all Dataflow Gen2 items in a workspace.
• datafactory_create-dataflow — Creates a new Dataflow Gen2 item.
• datafactory_execute-query — Executes an M (Power Query) query against a dataflow.

About MCP

The Model Context Protocol (MCP) is an open protocol Anthropic introduced for connecting LLM-based agents to external tools and data sources. Providers publish MCP servers that expose their API surface as structured, discoverable tools — an MCP-compatible client (Claude Desktop, Cursor, Cline, Continue, etc.) can connect to the server and call its tools without any per-provider integration code.

Browse every MCP server on the APIs.io network or compare with the broader Agent Skill surfaces of the same providers.

Work with this as data

Every MCP server here is available over the APIs.io API and to AI agents over MCP.

curl "https://apis.io/api/v1/mcp/microsoft-fabric-mcp-server"

curl "https://apis.io/api/v1/mcp?limit=25"