Skip to main content

Microsoft Fabric Analytics MCP Server - Enable AI assistants to access and analyze Microsoft Fabric data

Project description

Microsoft Fabric Analytics MCP Server - Python Package

PyPI version Python Support License: MIT

Easy PyPI installation for Microsoft Fabric Analytics MCP Server

This Python package provides a convenient wrapper around the Microsoft Fabric Analytics MCP Server, enabling seamless installation and integration with AI assistants like Claude, GitHub Copilot, and other MCP-compatible clients.

🚀 Quick Start

# Install from PyPI
pip install fabric-analytics-mcp

# Start the server
fabric-analytics-mcp start

# Validate installation
fabric-analytics-mcp validate

✨ Features

  • 41+ Microsoft Fabric Tools - Complete analytics toolkit
  • Easy Installation - Simple pip install command
  • Cross-Platform - Windows, macOS, Linux support
  • Multiple Auth Methods - Bearer token, Service Principal, Interactive
  • Workspace Management - Easy discovery and management
  • Spark Integration - Job monitoring and session management
  • Notebook Support - Execution and management
  • Production Ready - Battle-tested and reliable

📋 Requirements

  • Python 3.8+
  • Node.js 18+ (automatically validated)
  • Microsoft Fabric Access (with appropriate permissions)

🔧 Installation

Option 1: Direct PyPI Installation (Recommended)

pip install fabric-analytics-mcp

Option 2: Development Installation

git clone https://github.com/santhoshravindran7/Fabric-Analytics-MCP
cd Fabric-Analytics-MCP/python-wrapper
pip install -e .

⚙️ Configuration

Environment Variables

export FABRIC_AUTH_METHOD=bearer_token
export FABRIC_CLIENT_ID=your-client-id
export FABRIC_CLIENT_SECRET=your-client-secret  
export FABRIC_TENANT_ID=your-tenant-id
export FABRIC_DEFAULT_WORKSPACE_ID=your-workspace-id

Claude Desktop Configuration

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "fabric-analytics": {
      "command": "fabric-analytics-mcp",
      "args": ["start"],
      "env": {
        "FABRIC_AUTH_METHOD": "bearer_token"
      }
    }
  }
}

GitHub Copilot Configuration

For VS Code with GitHub Copilot:

{
  "github.copilot.mcp.servers": {
    "fabric-analytics": {
      "command": "fabric-analytics-mcp",
      "args": ["start"],
      "env": {
        "FABRIC_AUTH_METHOD": "bearer_token"
      }
    }
  }
}

🛠️ Usage

Command Line Interface

# Start the MCP server
fabric-analytics-mcp start

# Start with specific configuration
fabric-analytics-mcp start --auth-method service_principal --workspace-id <id>

# Validate installation
fabric-analytics-mcp validate

# Show configuration help
fabric-analytics-mcp config

# Get help
fabric-analytics-mcp --help

Python API

from fabric_analytics_mcp import FabricMCPServer

# Start server programmatically
config = {
    'FABRIC_AUTH_METHOD': 'bearer_token',
    'FABRIC_DEFAULT_WORKSPACE_ID': 'your-workspace-id'
}

with FabricMCPServer(config) as server:
    # Server is running
    tools = server.list_tools()
    print(f"Available tools: {len(tools['result']['tools'])}")

🏢 Available Tools

The server provides 41+ tools for Microsoft Fabric analytics:

Workspace Management

  • fabric_list_workspaces - List all accessible workspaces
  • fabric_find_workspace - Find workspace by name
  • fabric_create_workspace - Create new workspace

Item Management

  • list-fabric-items - List workspace items
  • create-fabric-item - Create new items
  • update-fabric-item - Update existing items
  • delete-fabric-item - Delete items

Notebook Operations

  • create-fabric-notebook - Create notebooks
  • execute-fabric-notebook - Run notebooks
  • get-fabric-notebook-definition - Get notebook content

Spark Integration

  • submit-spark-job - Submit Spark jobs
  • get-job-status - Monitor job status
  • create-livy-session - Create interactive sessions
  • execute-livy-statement - Run Spark code

Monitoring & Analytics

  • get-spark-monitoring-dashboard - Performance insights
  • analyze-livy-session-logs - Log analysis
  • get-workspace-spark-applications - Application monitoring

View complete tool list →

🔐 Authentication

Bearer Token (Recommended for Development)

export FABRIC_AUTH_METHOD=bearer_token
# Get token from Fabric portal

Service Principal (Recommended for Production)

export FABRIC_AUTH_METHOD=service_principal
export FABRIC_CLIENT_ID=your-app-id
export FABRIC_CLIENT_SECRET=your-secret
export FABRIC_TENANT_ID=your-tenant-id

Interactive Login

export FABRIC_AUTH_METHOD=interactive
# Opens browser for authentication

🔍 Validation

Ensure everything is working correctly:

# Validate installation
fabric-analytics-mcp validate

# Test server startup
fabric-analytics-mcp start --validate

# Check tool availability
echo '{"jsonrpc": "2.0", "id": 1, "method": "tools/list"}' | fabric-analytics-mcp start

📚 Documentation

🤝 Support

📄 License

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

🙏 Contributing

Contributions are welcome! Please read our Contributing Guide for details.


Made with ❤️ by the Microsoft Fabric Analytics Community

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

fabric_analytics_mcp-1.0.0.tar.gz (11.5 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

fabric_analytics_mcp-1.0.0-py3-none-any.whl (9.5 kB view details)

Uploaded Python 3

File details

Details for the file fabric_analytics_mcp-1.0.0.tar.gz.

File metadata

  • Download URL: fabric_analytics_mcp-1.0.0.tar.gz
  • Upload date:
  • Size: 11.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.11.9

File hashes

Hashes for fabric_analytics_mcp-1.0.0.tar.gz
Algorithm Hash digest
SHA256 e5876b03b29fa503ded1f7e5bc05820a0d2176b87a07a017295b95d8a5c6ca80
MD5 8e22371eba29656763f047d12512c7de
BLAKE2b-256 f7ec6b98cd73f0b7fac4dff0204d8a534577d998e0a185e030d834f77c04f249

See more details on using hashes here.

File details

Details for the file fabric_analytics_mcp-1.0.0-py3-none-any.whl.

File metadata

File hashes

Hashes for fabric_analytics_mcp-1.0.0-py3-none-any.whl
Algorithm Hash digest
SHA256 c7398f0188777eb89d0626becfe8f1c29902af40af8cf22dce00cd0c0f6a55c1
MD5 69d11c77c9ea33727333c5b7d4bfcbed
BLAKE2b-256 74646445e4b43c942ff25c9c76b97c0740461fd2b4c669b4d70da71753e50eb9

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page