Microsoft Fabric MCP Server
Gives your LLM direct access to Microsoft Fabric's data platform, including lakehouses, data warehouses, and notebooks. Part of Microsoft's official MCP server collection built from their unified repository. You'd reach for this when you want AI assistance navigating Fabric workspaces, querying datasets, or managing analytics pipelines without context switching. Ships as a Node package with stdio transport, following the same engineering patterns as Microsoft's Azure MCP server. Useful if you're already working in Fabric and want to keep your AI workflows in the same environment where your data lives.
- tools
- 56
- transport
- STDIO
- last updated
- Aug 27, 2026
Tools
56 toolsPublic tool metadata for what this MCP can expose to an agent.
jobs_cancel-item-job-instanceRequests cancellation of an existing job.
Requests cancellation of an existing job.
No parameter schema in public metadata yet.
jobs_create-item-scheduleCreates a schedule for an item job, with explicit enabled, timing, timezone and configuration.
Creates a schedule for an item job, with explicit enabled, timing, timezone and configuration.
No parameter schema in public metadata yet.
jobs_delete-item-scheduleDeletes an item schedule; returns a receipt and does not cancel already-running jobs.
Deletes an item schedule; returns a receipt and does not cancel already-running jobs.
No parameter schema in public metadata yet.
jobs_get-item-job-instanceReads one job instance.
Reads one job instance.
No parameter schema in public metadata yet.
jobs_get-item-scheduleReads one item schedule by schedule ID.
Reads one item schedule by schedule ID.
No parameter schema in public metadata yet.
jobs_list-item-job-instancesLists one page of an item's job instances.
Lists one page of an item's job instances.
No parameter schema in public metadata yet.
jobs_list-item-schedulesLists one page of an item's schedules.
Lists one page of an item's schedules.
No parameter schema in public metadata yet.
jobs_run-on-demand-item-jobSubmits an on-demand item job.
Submits an on-demand item job.
No parameter schema in public metadata yet.
jobs_update-item-scheduleUpdates an existing item schedule.
Updates an existing item schedule.
No parameter schema in public metadata yet.
docs_list-item-typesLists the Fabric item types that have public API specifications available, plus the non-item API areas (platform, admin, spark, realTimeIntelligence).
Lists the Fabric item types that have public API specifications available, plus the non-item API areas (platform, admin, spark, realTimeIntelligence).
No parameter schema in public metadata yet.
docs_item-api-specRetrieves the complete OpenAPI specification for a specific Fabric item type.
Retrieves the complete OpenAPI specification for a specific Fabric item type.
No parameter schema in public metadata yet.
docs_platform-api-specRetrieves the OpenAPI specification for core Fabric platform APIs.
Retrieves the OpenAPI specification for core Fabric platform APIs.
No parameter schema in public metadata yet.
docs_item-definitionsRetrieves the JSON schema definition for a Fabric item type.
Retrieves the JSON schema definition for a Fabric item type.
No parameter schema in public metadata yet.
docs_best-practicesRetrieves best practice documentation and guidance for a specific topic.
Retrieves best practice documentation and guidance for a specific topic.
No parameter schema in public metadata yet.
docs_api-examplesRetrieves example API request/response files for a specific item type.
Retrieves example API request/response files for a specific item type.
No parameter schema in public metadata yet.
onelake_list-workspacesLists available Microsoft Fabric workspaces.
Lists available Microsoft Fabric workspaces.
No parameter schema in public metadata yet.
onelake_list-itemsLists workspace items with high-level metadata.
Lists workspace items with high-level metadata.
No parameter schema in public metadata yet.
onelake_list-items-dfsLists Fabric items via the DFS endpoint.
Lists Fabric items via the DFS endpoint.
No parameter schema in public metadata yet.
onelake_list-filesLists files using the hierarchical file-list endpoint.
Lists files using the hierarchical file-list endpoint.
No parameter schema in public metadata yet.
onelake_download-fileDownloads a OneLake file.
Downloads a OneLake file.
No parameter schema in public metadata yet.
onelake_upload-fileUploads a file to OneLake storage.
Uploads a file to OneLake storage.
No parameter schema in public metadata yet.
onelake_delete-fileDeletes a file from OneLake storage.
Deletes a file from OneLake storage.
No parameter schema in public metadata yet.
onelake_create-directoryCreates a directory via the DFS endpoint.
Creates a directory via the DFS endpoint.
No parameter schema in public metadata yet.
onelake_delete-directoryDeletes a directory (optionally recursive).
Deletes a directory (optionally recursive).
No parameter schema in public metadata yet.
onelake_get-table-configRetrieves table API configuration for a workspace item.
Retrieves table API configuration for a workspace item.
No parameter schema in public metadata yet.
onelake_list-table-namespacesLists table namespaces (schemas) exposed through the table API.
Lists table namespaces (schemas) exposed through the table API.
No parameter schema in public metadata yet.
onelake_get-table-namespaceRetrieves metadata for a specific namespace.
Retrieves metadata for a specific namespace.
No parameter schema in public metadata yet.
onelake_list-tablesLists tables published within a namespace.
Lists tables published within a namespace.
No parameter schema in public metadata yet.
onelake_get-tableRetrieves the definition for a specific table.
Retrieves the definition for a specific table.
No parameter schema in public metadata yet.
onelake_list-data-access-rolesLists all data access roles defined on a single item.
Lists all data access roles defined on a single item.
No parameter schema in public metadata yet.
onelake_get-data-access-roleGets the full definition of a single data access role (members, permissions, decision rules).
Gets the full definition of a single data access role (members, permissions, decision rules).
No parameter schema in public metadata yet.
onelake_create-or-update-data-access-roleUpserts a single data access role on a single item.
Upserts a single data access role on a single item.
No parameter schema in public metadata yet.
onelake_delete-data-access-roleDeletes a single data access role from an item.
Deletes a single data access role from an item.
No parameter schema in public metadata yet.
onelake_list-shortcutsLists shortcuts defined within an item. Hides DW-managed shortcuts by default (--include-managed to show).
Lists shortcuts defined within an item. Hides DW-managed shortcuts by default (--include-managed to show).
No parameter schema in public metadata yet.
onelake_get-shortcutGets the properties of a single shortcut.
Gets the properties of a single shortcut.
No parameter schema in public metadata yet.
onelake_create-shortcut-onelakeCreates a shortcut pointing to another OneLake location.
Creates a shortcut pointing to another OneLake location.
No parameter schema in public metadata yet.
onelake_create-shortcut-adls-gen2Creates a shortcut pointing to Azure Data Lake Storage Gen2.
Creates a shortcut pointing to Azure Data Lake Storage Gen2.
No parameter schema in public metadata yet.
onelake_create-shortcut-amazon-s3Creates a shortcut pointing to Amazon S3.
Creates a shortcut pointing to Amazon S3.
No parameter schema in public metadata yet.
onelake_create-shortcut-azure-blobCreates a shortcut pointing to Azure Blob Storage.
Creates a shortcut pointing to Azure Blob Storage.
No parameter schema in public metadata yet.
onelake_create-shortcut-gcsCreates a shortcut pointing to Google Cloud Storage.
Creates a shortcut pointing to Google Cloud Storage.
No parameter schema in public metadata yet.
onelake_create-shortcut-s3-compatibleCreates a shortcut pointing to S3-compatible storage.
Creates a shortcut pointing to S3-compatible storage.
No parameter schema in public metadata yet.
onelake_create-shortcut-dataverseCreates a shortcut pointing to a Dataverse environment.
Creates a shortcut pointing to a Dataverse environment.
No parameter schema in public metadata yet.
onelake_create-shortcut-onedrive-sharepointCreates a shortcut pointing to OneDrive/SharePoint Online.
Creates a shortcut pointing to OneDrive/SharePoint Online.
No parameter schema in public metadata yet.
onelake_delete-shortcutDeletes a single shortcut from an item (preserves destination data).
Deletes a single shortcut from an item (preserves destination data).
No parameter schema in public metadata yet.
onelake_reset-shortcut-cacheDrops cached shortcut reads, forcing re-resolution from destination.
Drops cached shortcut reads, forcing re-resolution from destination.
No parameter schema in public metadata yet.
onelake_get-settingsGets OneLake settings for a workspace (diagnostics + immutability policy).
Gets OneLake settings for a workspace (diagnostics + immutability policy).
No parameter schema in public metadata yet.
onelake_modify-diagnosticsModifies diagnostic logging configuration (status, destination lakehouse) at workspace scope.
Modifies diagnostic logging configuration (status, destination lakehouse) at workspace scope.
No parameter schema in public metadata yet.
onelake_modify-immutability-policyModifies the workspace-level OneLake immutability policy (scope, retention days).
Modifies the workspace-level OneLake immutability policy (scope, retention days).
No parameter schema in public metadata yet.
core_assign-workspace-to-capacitySubmits one request to assign an existing workspace to a capacity. Returns an accepted/pending receipt, not confirmation of completion.
Submits one request to assign an existing workspace to a capacity. Returns an accepted/pending receipt, not confirmation of completion.
No parameter schema in public metadata yet.
core_create-itemCreates a Fabric item by workspace UUID, optionally with a definition or creation payload, an existing folder ID, definition options, and label settings.
Creates a Fabric item by workspace UUID, optionally with a definition or creation payload, an existing folder ID, definition options, and label settings.
No parameter schema in public metadata yet.
core_create-workspaceCreates a Fabric workspace, optionally assigning an existing capacity and domain in the same request.
Creates a Fabric workspace, optionally assigning an existing capacity and domain in the same request.
No parameter schema in public metadata yet.
core_delete-itemDeletes one known Fabric item using workspace and item UUIDs. Permanent deletion requires explicitly setting hard-delete to true.
Deletes one known Fabric item using workspace and item UUIDs. Permanent deletion requires explicitly setting hard-delete to true.
No parameter schema in public metadata yet.
core_delete-workspaceDeletes one explicitly identified Fabric workspace and the items under it. Requires a workspace UUID and workspace Admin access.
Deletes one explicitly identified Fabric workspace and the items under it. Requires a workspace UUID and workspace Admin access.
No parameter schema in public metadata yet.
core_get-capacityGets one Fabric capacity's ID, display name, SKU, region, and state using its capacity UUID.
Gets one Fabric capacity's ID, display name, SKU, region, and state using its capacity UUID.
No parameter schema in public metadata yet.
core_get-itemGets generic metadata for one existing Fabric item using its workspace ID and item ID. Does not read item data or definitions.
Gets generic metadata for one existing Fabric item using its workspace ID and item ID. Does not read item data or definitions.
No parameter schema in public metadata yet.
core_get-item-definitionRetrieves typed definition parts inline, optionally wa
Retrieves typed definition parts inline, optionally wa
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
🌟 Microsoft MCP Servers
📘 What is MCP?
Model Context Protocol (MCP) is an open protocol that standardizes how applications provide context to large language models (LLMs). It allows AI applications to connect with various data sources and tools in a consistent manner, enhancing their capabilities and flexibility. MCP follows a client-server architecture:
- MCP Hosts: Applications like AI assistants or IDEs that initiate connections.
- MCP Clients: Connectors within the host application that maintain 1:1 connections with servers.
- MCP Servers: Services that provide context and capabilities through the standardized MCP.
For more details, visit the official MCP website.
📁 Which MCP Servers are built from this repository?
This repository contains core libraries, test frameworks, engineering systems, pipelines, and tooling for Microsoft MCP Server contributors to unify engineering investments; and reduce duplication and divergence:
Details
- Repository
- github.com/microsoft/mcp
- Website
- github.com/microsoft/mcp/tree/main/servers/Fabric.Mcp.Server
- Package
@microsoft/fabric-mcp- Transport
- STDIO
- Registry
- MCP registry, active