fde_fabric_mcp
Verified Safeby mmcdermott-ashleyne
Overview
An MCP server to expose Microsoft Fabric workspaces, Lakehouses, Warehouses, SQL endpoints, and FDE-specific project orchestration as tools for AI agents.
Installation
python -m fde_fabric_mcp.serverEnvironment Variables
- FABRIC_AUTH_MODE
- FABRIC_TENANT_ID
- FABRIC_CLIENT_ID
- FABRIC_CLIENT_SECRET
- FABRIC_SCOPE
- FABRIC_BASE_URL
- FABRIC_DEFAULT_WORKSPACE_ID
- FABRIC_SQL_DRIVER
- FABRIC_READ_ONLY_SQL_ENABLED
- FABRIC_READ_ONLY_WORKSPACE_NAMES
- FABRIC_READ_ONLY_WORKSPACE_IDS
Security Notes
The server correctly uses environment variables for sensitive credentials. SQL queries executed via `run_sql_query` for the user-defined SQL string are protected by `guardrails.py` which attempts to prevent write operations (INSERT, UPDATE, DELETE, etc.) by analyzing the SQL after stripping comments and literals. While this is a strong defense, executing arbitrary (though filtered) SQL strings carries an inherent risk. DML operations via `execute` and `execute_many` use parameterized queries, which is a safer approach to prevent SQL injection for those specific operations. `subprocess.run` is used for `az account show`, which is a controlled execution of a known command.
Similar Servers
mcp-kql-server
An AI-powered MCP server that facilitates KQL query execution against Azure Data Explorer through natural language conversion, intelligent schema discovery, and RAG-enhanced context.
powerdrill-mcp
An MCP server for AI-driven data analysis by providing tools to interact with Powerdrill datasets using natural language questions and managing data sources, jobs, and sessions.
mcp-compose
This server provides a robust example of OAuth2 authentication for MCP (Model Context Protocol) servers, using GitHub as the identity provider. It demonstrates secure multi-server management, protocol translation, and integration with AI agents for tool invocation.
MsSqlMCP
Provides an MCP Server for SQL Server database schema inspection and safe, read-only query execution to AI clients.