Microsoft Fabric MCP Server

A comprehensive Python-based MCP (Model Context Protocol) server for interacting with Microsoft Fabric APIs, featuring advanced PySpark notebook development, testing, and optimization capabilities with LLM integration.

Features# Core Fabric Operations

• Workspace, lakehouse, warehouse, and table management
• Delta table schemas and metadata retrieval
• SQL query execution and data loading
• Report and semantic model operations

Advanced PySpark Development

• Intelligent notebook creation with 6 specialized templates
• Smart code generation for common PySpark operations
• Comprehensive validation with syntax and best practices checking
• Fabric-specific optimizations and compatibility checks
• Performance analysis with scoring and optimization recommendations
• Real-time monitoring and execution insights

LLM Integration

• Natural language interface for PySpark development
• Context-aware assistance with conversation memory
• Intelligent code formatting and explanations
• Smart optimization suggestions based on project patterns

Requirements

• Python 3.12+
• Azure credentials for authentication
• uv (from astral)
• Azure CLI
• Optional: Node.js for MCP inspector

Installation

1. Clone the repository:

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

2. Set up virtual environment:

   uv sync
   

3. Install dependencies:

   pip install -r requirements.txt
   

Usage

1. Using STDIO

   az login --scope https://api.fabric.microsoft.com/.default
   uv run --with mcp mcp dev fabric_mcp.py
   

2. Using HTTP

   uv run python .\fabric_mcp.py --port 8081
   

License

This project is licensed under the MIT License.