Fabric GraphQL MCP Connector
Allows AI agents to query and mutate data in a Microsoft Fabric data warehouse via GraphQL, providing an abstraction layer for universal data access.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Fabric GraphQL MCP Connectorshow me the top 10 trips by distance from the fabric warehouse"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
MCP Connector: Integrating AI agent with Data Warehouse in Microsoft Fabric
This repo demonstrates the integration of an Azure OpenAI-powered AI agent with a Microsoft Fabric data warehouse using the Model Context Protocol (MCP), open integration standard for AI agents by Anthropic.
MCP enables dynamic discovery of tools, data resources and prompt templates (with more coming soon), unifying their integration with AI agents. GraphQL provides an abstraction layer for universal data connection. Below, you will find detailed steps on how to combine MCP and GraphQL to enable bidirectional access to enterprise data for your AI agent.
In the MCP server's script, some query parameter values are hard-coded for the sake of this example. In a real-world scenario, these values would be dynamically generated or retrieved.
Table of contents:
Part 1: Configuring Microsoft Fabric Backend
In Microsoft Fabric, create a new data warehouse pre-populated by sample data by clicking New item -> Sample warehouse:
Next, create a GraphQL API endpoint by clicking New item -> API for GraphQL:
In the data configuration of GraphQL API, choose the Trip (dbo.Trip) table:
Copy the endpoint URL of your GraphQL API:
Part 2: Configuring Local Client Environment
Install the required Python packages, listed in the provided requirements.txt:
pip install -r requirements.txtConfigure environment variables for the MCP client:
Variable | Description |
| Base URL of the Azure OpenAI endpoint |
| API version of the Azure OpenAI endpoint |
| Deployment name of the Azure OpenAI model |
Set the value of the
AZURE_FABRIC_GRAPHQL_ENDPOINTvariable with the GraphQL endpoint URL from Step 1.4 above. It will be utilised by the MCP Server script to establish connectivity with Microsoft Fabric:
Variable | Description |
| Microsoft Fabric's GraphQL API endpoint |
Part 3: User Experience - Gradio UI
Launch the MCP client in your command prompt:
python MCP_Client_Gradio.pyClick the Initialise System button to start the MCP server and connect your AI agent to the Microsoft Fabric's GraphQL API endpoint:
You can now pull and push data to your data warehouse using GraphQL's queries and mutations enabled by this MCP connector:
Part 4: Demo video on YouTube
A practical demo of the provided MCP connector can be found on this YouTube video.
This server cannot be installed
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/LazaUK/AIFoundry-MCPConnector-FabricGraphQL'
If you have feedback or need assistance with the MCP directory API, please join our Discord server