Microsoft Data Factory MCP Server
Managing Fabric pipelines, dataflows and gateways through Azure AD: the official Microsoft server for VS Code
- 47 ★ on the repository
- Last commit
- MIT
Broad access
Why this level
- The tools create and update pipelines, connections and gateways, and `delete_airflow_job` deletes Airflow jobs
- Running pipelines and copy jobs moves data between sources with the rights of the signed-in user
- `get_access_token` hands the agent an access token for Fabric
Install
- Works in
Manual install
{
"servers": {
"DataFactory.MCP": {
"type": "stdio",
"command": "dnx",
"args": ["Microsoft.DataFactory.MCP", "--version", "#{VERSION}#", "--yes"]
}
}
}The `.vscode/mcp.json` file; replace `#{VERSION}#` with the package version from NuGet. For Visual Studio use `.mcp.json` in the solution folder.
Access and checks
How we reviewBroad accessThe tool can change data, run commands or handle secrets.
- The tools create and update pipelines, connections and gateways, and `delete_airflow_job` deletes Airflow jobs
- Running pipelines and copy jobs moves data between sources with the rights of the signed-in user
- `get_access_token` hands the agent an access token for Fabric
This is third-party code. Review the repository files before installing.
What it does
The server connects an agent to Data Factory in Microsoft Fabric. The agent lists workspaces and capacities, creates and runs pipelines, copy jobs and Apache Airflow jobs, watches run status and schedules runs. For dataflows it can create them, read the definition, add connections and Power Query M queries, start a background refresh and check its status. Separate tools create gateways, including virtual network gateways, and connections to cloud and on-premises sources. Sign-in goes through Azure AD, interactively or with a service principal. In VS Code a connection wizard opens as a form right in the chat. The repository also holds Data Factory skill files for Claude projects: M basics, query optimization, destination setup and advanced features such as Fast Copy.
Who it is for. Data engineers who build pipelines and dataflows in Microsoft Fabric and want to run them from chat.
Good fit when
- A copy pipeline from an on-premises database has to be created and put on a schedule
- A pipeline run hangs, and the agent checks the status and result of the last run
- A Dataflow Gen2 query hits a timeout, and the Data Factory skills suggest how to split it
- You need to find dataflows in a workspace and add a connection to one of them
- An Apache Airflow job in Fabric is updated together with its definition
Not a fit when
- Data lives outside Microsoft Fabric: the server manages only its objects
- You need SQL queries against lakehouse tables: the `execute_query` tool covers dataflow queries and is marked Preview
- The account has no rights in the Fabric workspace: the server acts with the rights of the signed-in user or the service principal
Example request
List the pipelines in the Sales workspace, run the one that copies orders, then check the run status.MCP
- Transport
- stdio
- Authentication
- OAuth
Limitations
You need .NET 10 or newer, and the server starts with `dnx`. Sign-in requires an Azure AD tenant and a registered application with Fabric permissions, as described in the authentication guide. Some tools, including `execute_query` and the copy and Airflow jobs, are marked Preview. In the README configuration the package version is a `#{VERSION}#` placeholder, and the current version is taken from NuGet.
How to disable. Remove the `DataFactory.MCP` block from `.vscode/mcp.json` or `.mcp.json`. The `sign_out` tool ends the session.
FAQ
How do I connect Data Factory MCP to VS Code?
Create `.vscode/mcp.json` with a stdio server, the command `dnx` and the arguments `Microsoft.DataFactory.MCP --version <version> --yes`. For Visual Studio the same block goes into `.mcp.json` in the solution folder. Replace the `#{VERSION}#` placeholder with the package version from NuGet.
How does the server sign in to Microsoft Fabric?
Through Azure AD: interactively (`authenticate_interactive`) or with a service principal (`authenticate_service_principal`). `get_authentication_status` shows the sign-in state and `sign_out` ends it. Preparing the tenant and the application is described in the authentication guide.
What are the skills in the repository?
Files from the `claude-skills/` folder for Claude projects: M and Dataflow Gen2 basics, performance, output destinations and advanced features. They are added to Project Knowledge by hand. A similar set for ChatGPT sits in `chatgpt-skills/`.
Which Fabric objects can the server create?
Pipelines, dataflows, copy jobs, Apache Airflow jobs, connections and virtual network gateways. Workspaces and capacities are only listed.
What has to be installed before launch?
The .NET 10 runtime or newer, an Azure AD tenant and a registered application with the right permissions. The environment variables for sign-in are described in the authentication guide in the repository.
Discussion
No questions or reviews yet.
Related
MCP serversMicrosoft plugin for Fabric: warehouses and Lakehouse, Spark, Power BI, Eventhouse, event streams and migrations for Copilot CLI and Claude Code
Microsoft's MCP server for Fabric Real-Time Intelligence: KQL queries, Eventstreams, Activator triggers and maps from an agent.
MCP server and CLI to drive real Microsoft Excel: Power Query, DAX, VBA, PivotTables and charts
An MCP server for Microsoft SQL Server and Azure SQL: the agent lists tables and runs SQL queries that read and write data
A local Microsoft MCP server for Power BI semantic models: an agent creates tables, DAX measures and relationships in Desktop, Fabric and PBIP files
An MCP server and the dbcode-cli skill: an agent runs SQL through connections already saved in the DBCode editor extension.
Comparison with similar tools
Cards that share the main search query, and how they differ.
| Tool | Official | Authentication | Repository stars | Main difference |
|---|---|---|---|---|
| Microsoft Data Factory MCP Server (this card) | yes | OAuth | 47 | |
| Microsoft Fabric Skills | yes | 1,344 | a plugin of skills for warehouses, Spark and Power BI, without Data Factory control through MCP | |
| Azure MCP Server | yes | OAuth | 3,850 | a general server for Azure services that does not create Fabric pipelines or dataflows |
README in short
The repository describes the server's features by Fabric area and lists the tools. Installation comes from the NuGet package through an IDE configuration, with details moved to guides for each area. Skills for Claude and ChatGPT are described separately.