Microsoft Fabric MCP Server: Setup for Claude, Cursor and Other Apps

• Lists Fabric item types that have API docs

  Shows which Fabric item types, such as lakehouses or notebooks, have bundled API specifications, plus the platform and admin API areas. It reads files that ship with the server.

  Try: “What Fabric item types are available?”

  Read · docs_list-item-types

• Gets the API spec for one item type

  Gives the assistant the bundled OpenAPI document for one item type, so it can see every operation that type supports. It reads files that ship with the server.

  Try: “Show me the API operations for notebooks.”

  Read · docs_item-api-spec

• Gets the core Fabric platform API spec

  Hands the assistant the bundled OpenAPI document for the platform-level Fabric APIs, so it can write calls against them.

  Try: “Get the platform API specification for Fabric.”

  Read · docs_platform-api-spec

• Gets the JSON schema for an item type

  Returns the schema that describes how a Fabric item type is defined, so the assistant can write valid definitions.

  Try: “Show the JSON schema for a data pipeline item.”

  Read · docs_item-definitions

• Reads Fabric best practices

  Returns guidance on a topic such as throttling, pagination or error handling.

  Try: “How should I handle API throttling in Fabric?”

  Read · docs_best-practices

• Gets example API calls

  Fetches sample request and response bodies for one item type, so the assistant can copy the shape of a valid call.

  Try: “Show an example payload for creating a notebook.”

  Read · docs_api-examples

• Lists your Fabric workspaces

  Returns one page of workspaces you can reach, optionally filtered by your role, with a token for the next page.

  Try: “List the Fabric workspaces where I am an Admin.”

  Network · core_list-workspaces

• Shows one workspace

  Looks up one workspace by its ID and returns details such as capacity, domain and endpoints. Nothing inside the workspace is read or changed.

  Try: “Get the details of this workspace.”

  Network · core_get-workspace

• Creates a workspace

  Makes a new workspace, and can attach a capacity and a domain in the same call. It never retries by itself, so check whether the workspace exists before asking again after a failure.

  Try: “Create a workspace called Sales Planning.”

  Write · core_create-workspace

• Renames a workspace or edits its description

  Edits the name or the description of a workspace by its ID. Anything you leave out stays as it was. You need the Admin role on the workspace.

  Try: “Rename this workspace to Capacity Analytics.”

  Write · core_update-workspace

• Deletes a workspace and everything in it

  Removes one workspace by ID together with the items under it. Needs workspace Admin access and is marked destructive.

  Try: “Delete the old test workspace.”

  Delete · core_delete-workspace

• Moves a workspace to a capacity

  Asks Fabric to put a workspace on a capacity. The answer only says the request was accepted, so check the workspace afterwards.

  Try: “Assign this workspace to capacity X.”

  Write · core_assign-workspace-to-capacity

• Lists your Fabric capacities

  Returns one page of the capacities where you are an administrator or contributor, with SKU, region and state.

  Try: “List my Fabric capacities and their SKUs.”

  Network · core_list-capacities

• Shows one capacity

  Looks up one capacity by its ID and returns its name, SKU, region and state.

  Try: “What state is this capacity in?”

  Network · core_get-capacity

• Lists items in a workspace

  Pages through the items in one workspace or folder, and can limit the list to one item type.

  Try: “List the lakehouses in this workspace.”

  Network · core_list-items

• Shows one item's details

  Fetches the basic details of one item from its workspace and item IDs. The item's data and definition are not read.

  Try: “Show the details of this item.”

  Network · core_get-item

• Creates a Fabric item

  Creates an item of a chosen type in a workspace, such as a lakehouse or notebook. It makes a real item when run.

  Try: “Create a lakehouse called Sales in this workspace.”

  Write · core_create-item

• Renames an item or edits its description

  Renames an item or edits its description, then shows the updated details.

  Try: “Rename this notebook.”

  Write · core_update-item

• Deletes a Fabric item

  Deletes one item. A permanent delete only happens if hard-delete is set to true, and that needs the workspace Admin role.

  Try: “Delete this old pipeline.”

  Delete · core_delete-item

• Searches the OneLake catalog

  Looks for items across workspaces by name, description or workspace name, one page at a time.

  Try: “Find items related to sales revenue.”

  Network · core_search-catalog

• Checks a long-running operation

  Checks where a long-running Fabric operation stands with a single read, and passes on the wait time Fabric suggests before asking again.

  Try: “Is that operation finished?”

  Network · core_get-operation-state

• Reads a finished operation's result

  Returns the JSON result of a completed operation, up to 1 MiB.

  Try: “Get the result of that operation.”

  Network · core_get-operation-result

• Lists pipelines in a workspace

  Shows the data pipelines in a workspace.

  Try: “List the pipelines in this workspace.”

  Network · datafactory_list-pipelines

• Shows one pipeline

  Shows how one pipeline is set up.

  Try: “Show how the nightly-load pipeline is set up.”

  Network · datafactory_get-pipeline

• Creates a pipeline

  Makes a data pipeline in the workspace you name.

  Try: “Create a pipeline that copies sales data nightly.”

  Write · datafactory_create-pipeline

• Runs a pipeline now

  Triggers a run of an existing pipeline right now.

  Try: “Run the nightly-load pipeline now.”

  Write · datafactory_run-pipeline

• Lists Dataflow Gen2 items

  Shows the Dataflow Gen2 items in a workspace.

  Try: “List the dataflows in this workspace.”

  Network · datafactory_list-dataflows

• Creates a Dataflow Gen2

  Makes a Dataflow Gen2 item in a workspace.

  Try: “Create a dataflow named Customer Clean-up.”

  Write · datafactory_create-dataflow

• Runs a Power Query (M) query on a dataflow

  Sends a Power Query (M) query to a dataflow and returns what it produces.

  Try: “Run this M query on the customer dataflow.”

  Write · datafactory_execute-query

• Lists workspaces visible to OneLake

  Returns the workspaces you can see through OneLake.

  Try: “Which workspaces can I open in OneLake?”

  Network · onelake_list-workspaces

• Lists items in a workspace

  Shows the items in a workspace with a few key fields for each.

  Try: “What items are in this workspace?”

  Network · onelake_list-items

• Lists items through the file endpoint

  Returns the items in a workspace using the DFS (file system) endpoint.

  Try: “List the items in this workspace via the file endpoint.”

  Network · onelake_list-items-dfs

• Lists files and folders

  Returns the files and folders at a path in OneLake.

  Try: “List the files in the Sales lakehouse.”

  Network · onelake_list-files

• Downloads a file

  Copies a file from OneLake onto your computer.

  Try: “Download report.csv from the lakehouse.”

  Files · onelake_download-file

• Uploads a file

  Sends a file from your computer into OneLake.

  Try: “Upload this CSV to the Files folder.”

  Write · onelake_upload-file

• Deletes a file

  Deletes one file in OneLake.

  Try: “Delete the old export file.”

  Delete · onelake_delete-file

• Creates a folder

  Makes a folder in OneLake.

  Try: “Create a folder called archive.”

  Write · onelake_create-directory

• Deletes a folder

  Deletes a folder in OneLake. A recursive option also deletes everything inside it.

  Try: “Delete the temp folder and its contents.”

  Delete · onelake_delete-directory

• Shows table API settings for an item

  Shows how the table API is set up for one workspace item.

  Try: “What is the table configuration of this lakehouse?”

  Network · onelake_get-table-config

• Lists table schemas

  Lists the schemas (namespaces) that the table API exposes for an item.

  Try: “What schemas does this lakehouse have?”

  Network · onelake_list-table-namespaces

• Shows one table schema

  Shows the details of one namespace.

  Try: “Show the dbo namespace.”

  Network · onelake_get-table-namespace

• Lists tables in a schema

  Lists the tables inside one namespace.

  Try: “Which tables are in dbo?”

  Network · onelake_list-tables

• Shows a table's definition

  Shows the definition of one table.

  Try: “Show the columns of the orders table.”

  Network · onelake_get-table

• Lists data access roles on an item

  Shows every data access role set on one item.

  Try: “Which data access roles does this lakehouse have?”

  Network · onelake_list-data-access-roles

• Shows one data access role

  Returns a role's members, permissions and decision rules.

  Try: “Show who is in the Analysts role.”

  Network · onelake_get-data-access-role

• Creates or edits a data access role

  Adds or changes one data access role on an item, which changes who can read its data.

  Try: “Give the Analysts role read access to the Sales folder.”

  Write · onelake_create-or-update-data-access-role

• Deletes a data access role

  Removes one role from an item.

  Try: “Delete the Interns role.”

  Delete · onelake_delete-data-access-role

• Lists shortcuts in an item

  Returns the shortcuts defined in an item. Shortcuts managed by a warehouse are hidden unless you ask.

  Try: “List the shortcuts in this lakehouse.”

  Network · onelake_list-shortcuts

• Shows one shortcut

  Shows how one shortcut is configured.

  Try: “Show where this shortcut points.”

  Network · onelake_get-shortcut

• Creates a shortcut to another OneLake location

  Links data that lives in another OneLake location into the item as a shortcut.

  Try: “Create a shortcut to the shared lakehouse.”

  Write · onelake_create-shortcut-onelake

• Creates a shortcut to Azure Data Lake Storage

  Links an Azure Data Lake Storage Gen2 location into the item as a shortcut.

  Try: “Create a shortcut to our ADLS container.”

  Write · onelake_create-shortcut-adls-gen2

• Creates a shortcut to Amazon S3

  Links an Amazon S3 location into the item as a shortcut.

  Try: “Create a shortcut to the S3 bucket.”

  Write · onelake_create-shortcut-amazon-s3

• Creates a shortcut to Azure Blob Storage

  Links an Azure Blob Storage location into the item as a shortcut.

  Try: “Create a shortcut to the blob container.”

  Write · onelake_create-shortcut-azure-blob

• Creates a shortcut to Google Cloud Storage

  Links a Google Cloud Storage location into the item as a shortcut.

  Try: “Create a shortcut to the GCS bucket.”

  Write · onelake_create-shortcut-gcs

• Creates a shortcut to S3-compatible storage

  Adds a shortcut that points to storage that speaks the S3 protocol.

  Try: “Create a shortcut to our MinIO bucket.”

  Write · onelake_create-shortcut-s3-compatible

• Creates a shortcut to Dataverse

  Links a Dataverse environment into the item as a shortcut.

  Try: “Create a shortcut to Dataverse.”

  Write · onelake_create-shortcut-dataverse

• Creates a shortcut to OneDrive or SharePoint

  Links OneDrive or SharePoint Online content into the item as a shortcut.

  Try: “Create a shortcut to the team SharePoint site.”

  Write · onelake_create-shortcut-onedrive-sharepoint

• Deletes a shortcut

  Removes a shortcut from an item. The data it points to is kept.

  Try: “Delete the old S3 shortcut.”

  Delete · onelake_delete-shortcut

• Clears cached shortcut reads

  Drops cached reads so the next read fetches from the destination again.

  Try: “Reset the cache for this shortcut.”

  Write · onelake_reset-shortcut-cache

• Shows OneLake workspace settings

  Reads the diagnostic logging and immutability policy settings that apply to a workspace.

  Try: “What are the OneLake settings for this workspace?”

  Network · onelake_get-settings

• Changes diagnostic logging

  Changes a workspace's diagnostic logging status and the lakehouse that receives the logs.

  Try: “Turn on diagnostic logging to the logs lakehouse.”

  Write · onelake_modify-diagnostics

• Changes the immutability policy

  Sets the scope and the retention period in days of a workspace's OneLake immutability policy.

  Try: “Set a 30-day immutability retention.”

  Write · onelake_modify-immutability-policy

Watch out for

• It can delete workspaces, items and files

  Tools delete whole workspaces with everything in them, items, OneLake files and folders, access roles and shortcuts. Review each request and use a limited account. github.com

• It can change who can read your data

  One tool creates or edits OneLake data access roles. Use an identity that cannot change security settings if you do not need it. github.com

• Microsoft collects usage data

  The README says the software may collect usage information and send it to Microsoft, and points to the repository for how to turn it off. github.com

• Item definitions may include secrets

  A tool that reads a full item definition is described on the main branch but is not in the published 1.6.0 package. Where it exists, the README says it asks for consent first. github.com

Security advisories