Fabric MCP

Fabric MCP is a Python-based MCP server for interacting with Microsoft Fabric APIs. It provides utilities for managing workspaces, lakehouses, warehouses, and tables.(More incoming features will be added in the future). This project is inspired by the following project: https://github.com/Augustab/microsoft_fabric_mcp/tree/main

Features

• List workspaces, lakehouses, warehouses, and tables.
• Retrieve schemas and metadata for Delta tables.
• Generate markdown documentation for Delta tables.

Requirements

• Python 3.12 or higher
• Azure credentials for authentication
• uv (from astral) : Installation instructions
• Azure Cli : Installation instructions
• Optional: Node.js and npm for running the MCP inspector : Installation instructions

Installation

1. Clone the repository:

   git clone https://github.com/your-repo/fabric-mcp.git
   cd fabric-mcp

2. Set up your virtual environment and install dependencies:

   uv sync

3. Install dependencies:

   pip install -r requirements.txt

Usage

Connect to MS Fabric

• Run the Azure CLI command to log in:

  az login --scope https://api.fabric.microsoft.com/.default

Running the MCP Server and coonecting to it using the MCP inspector

• Run the MCP server with the inspector exposed for testing: bash uv run --with mcp mcp dev fabric_mcp.py This will start the server and expose the inspector at http://localhost:6274. !alt text

Running the MCP Server and coonecting to it using the MCP inspector

• To use the MCP server with VSCode, you can set up a launch configuration in your launch.json file:

  {
      //Existing configurations...
      "mcp": {
      "servers": {
          "ms-fabric-mcp": {
              "type": "stdio",
              "command": "\\.venv\\Scripts\\python.exe ",
              "args": [
                  "\\fabric_mcp.py"
              ]
          }
      }
  }
  }

  This configuration allows you to run and connect to the MCP server directly from VSCode. And provide access to the Tools : !alt text
• Using Agent mode in the Copilot chat, you can access the different tools available in the MCP server by specifying to tool name with #, for example #list_workspaces.

Available Tools

The following tools are available via the MCP server:

• create_lakehouse(name, workspace, description): Create a new lakehouse in a Fabric workspace.
• create_warehouse(name, workspace, description): Create a new warehouse in a Fabric workspace.
• get_all_lakehouse_schemas(workspace, lakehouse): Retrieve schemas and metadata for all Delta tables in a lakehouse.
• get_lakehouse_table_schema(workspace, lakehouse, table_name): Retrieve the schema and metadata for a specific Delta table.
• get_report(workspace, report_id): Get a specific report by ID.
• get_semantic_model(workspace, model_id): Get a specific semantic model by ID.
• get_sql_endpoint(workspace, lakehouse, warehouse, type): Retrieve the SQL endpoint for a specified lakehouse or warehouse.
• list_lakehouses(workspace): List all lakehouses in a specified workspace.
• list_reports(workspace): List all reports in a Fabric workspace.
• list_semantic_models(workspace): List all semantic models in a Fabric workspace.
• list_tables(workspace, lakehouse): List all tables in a specified lakehouse.
• list_warehouses(workspace): List all warehouses in a specified workspace.
• list_workspaces: List all available Fabric workspaces.
• load_data_from_url(url, destination_table, workspace, lakehouse, warehouse): Load data from a URL into a table in a warehouse or lakehouse.
• run_query(workspace, lakehouse, warehouse, query, type): Run a SQL query against a warehouse or lakehouse (SQLEndpoint).
• set_lakehouse(lakehouse): Set the current lakehouse context.
• set_table(table_name): Set the current table for the session.
• set_warehouse(warehouse): Set the current warehouse context.
• set_workspace(workspace): Set the current workspace context.
• create_notebook(name, workspace, content): Create a new notebook in a Fabric workspace with the specified content. -- WIP
• list_notebooks(workspace): List all notebooks in a Fabric workspace.

License

This project is licensed under the MIT License. See the LICENSE file for details.