Fabric-Analytics-MCP

# Microsoft Fabric Analytics MCP Server - Python Package [](https://badge.fury.io/py/fabric-analytics-mcp) [](https://pypi.org/project/fabric-analytics-mcp/) [](https://opensource.org/licenses/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 ```bash # 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) ```bash pip install fabric-analytics-mcp ``` ### Option 2: Development Installation ```bash git clone https://github.com/santhoshravindran7/Fabric-Analytics-MCP cd Fabric-Analytics-MCP/python-wrapper pip install -e . ``` ## ⚙️ Configuration ### Environment Variables ```bash 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`: ```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: ```json { "github.copilot.mcp.servers": { "fabric-analytics": { "command": "fabric-analytics-mcp", "args": ["start"], "env": { "FABRIC_AUTH_METHOD": "bearer_token" } } } } ``` ## 🛠️ Usage ### Command Line Interface ```bash # 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 ```python 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 →](https://github.com/santhoshravindran7/Fabric-Analytics-MCP#-available-tools) ## 🔐 Authentication ### Bearer Token (Recommended for Development) ```bash export FABRIC_AUTH_METHOD=bearer_token # Get token from Fabric portal ``` ### Service Principal (Recommended for Production) ```bash 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 ```bash export FABRIC_AUTH_METHOD=interactive # Opens browser for authentication ``` ## 🔍 Validation Ensure everything is working correctly: ```bash # 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 - **[Full Documentation](https://github.com/santhoshravindran7/Fabric-Analytics-MCP)** - **[API Reference](https://github.com/santhoshravindran7/Fabric-Analytics-MCP/blob/master/docs/)** - **[Examples](https://github.com/santhoshravindran7/Fabric-Analytics-MCP/blob/master/EXAMPLES.md)** - **[Troubleshooting](https://github.com/santhoshravindran7/Fabric-Analytics-MCP/blob/master/TROUBLESHOOTING.md)** ## 🤝 Support - **Issues**: [GitHub Issues](https://github.com/santhoshravindran7/Fabric-Analytics-MCP/issues) - **Discussions**: [GitHub Discussions](https://github.com/santhoshravindran7/Fabric-Analytics-MCP/discussions) - **Email**: santhoshravindran7@gmail.com ## 📄 License This project is licensed under the MIT License - see the [LICENSE](https://github.com/santhoshravindran7/Fabric-Analytics-MCP/blob/master/LICENSE) file for details. ## 🙏 Contributing Contributions are welcome! Please read our [Contributing Guide](https://github.com/santhoshravindran7/Fabric-Analytics-MCP/blob/master/CONTRIBUTING.md) for details. --- **Developed by [Santhosh Ravindran](https://github.com/santhoshravindran7)** ✨