fabric-mcp
Verified Safeby aturlov-alta
Overview
Facilitates AI assistant interaction with Microsoft Fabric data and resources (workspaces, lakehouses, tables, SQL queries) via a Model Context Protocol server for GitHub Copilot in VS Code.
Installation
python main.pyEnvironment Variables
- FABRIC_CLIENT_ID
- FABRIC_CLIENT_SECRET
- FABRIC_TENANT_ID
Security Notes
The server implements robust input validation for SQL identifiers (table names, schema names) to prevent SQL injection in tools that construct SQL queries (e.g., `get_table_schema`, `get_table_sample_data`). The `execute_custom_sql_query` tool explicitly allows execution of arbitrary SQL, placing responsibility for query safety on the user (and the AI crafting the query), but this is a feature, not a vulnerability in the server's parsing. Authentication tokens are handled by MSAL, with interactive mode caching tokens locally (with a warning not to share), and service principal mode requiring secrets via environment variables, which the documentation strongly advises against committing to version control. No 'eval' or malicious patterns were found. The primary security risk lies in the permissions granted to the authenticated user/service principal, rather than vulnerabilities in the server's code itself.
Similar Servers
powerbi-mcp
Enables AI assistants to interact with Power BI Desktop and Service for querying data, managing models, and performing safe bulk operations through natural language, ensuring enterprise-grade security and preserving report visual integrity during refactoring.
fabric-rti-mcp
Provides a Model Context Protocol (MCP) server that enables AI agents to interact with Microsoft Fabric Real-Time Intelligence (RTI) services for data querying, analysis, and management.
remote-mcp-functions-typescript
Provides a remote Model Context Protocol (MCP) server using Azure Functions to host tools for AI agents, specifically for managing code snippets and simple greetings.
copilot-kit
Provides a curated collection of GitHub Copilot prompts, instructions, and configurations to enhance developer productivity and streamline AI-assisted programming workflows in VS Code.