Skip to main content
Glama
LazaUK

Fabric GraphQL MCP Connector

by LazaUK
OverviewSchemaRelated ServersScoreDiscussions
Python
Remote

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.

NOTE

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:

Related MCP server: GraphQL MCP Toolkit

Part 1: Configuring Microsoft Fabric Backend

  1. In Microsoft Fabric, create a new data warehouse pre-populated by sample data by clicking New item -> Sample warehouse: Step1_SampleWarehouse

  2. Next, create a GraphQL API endpoint by clicking New item -> API for GraphQL: Step2_GraphQlCreate

  3. In the data configuration of GraphQL API, choose the Trip (dbo.Trip) table: Step3_GraphQLData.png

  4. Copy the endpoint URL of your GraphQL API: Step4_GraphQLDataURL.png

Part 2: Configuring Local Client Environment

  1. Install the required Python packages, listed in the provided requirements.txt:

pip install -r requirements.txt

  1. Configure environment variables for the MCP client:

Variable

Description

AOAI_API_BASE

Base URL of the Azure OpenAI endpoint

AOAI_API_VERSION

API version of the Azure OpenAI endpoint

AOAI_DEPLOYMENT

Deployment name of the Azure OpenAI model

  1. Set the value of the AZURE_FABRIC_GRAPHQL_ENDPOINT variable 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

AZURE_FABRIC_GRAPHQL_ENDPOINT

Microsoft Fabric's GraphQL API endpoint

Part 3: User Experience - Gradio UI

  1. Launch the MCP client in your command prompt:

python MCP_Client_Gradio.py

  1. Click the Initialise System button to start the MCP server and connect your AI agent to the Microsoft Fabric's GraphQL API endpoint: Step5_GradioLaunch.png

  2. You can now pull and push data to your data warehouse using GraphQL's queries and mutations enabled by this MCP connector: Step5_GradioUse.png

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

A
license - permissive license
-
quality - not tested
D
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

  • mcp-graphql

    launchthatbrand
    A
    license
    -
    quality
    D
    maintenance
    A Model Context Protocol server that enables LLMs to interact with GraphQL APIs by providing schema introspection and query execution capabilities.
    Last updated
    1,267
    3
    MIT

  • Microsoft Fabric MCP Server

    snahrup
    A
    license
    B
    quality
    D
    maintenance
    Enables AI assistants to interact with Microsoft Fabric and Power BI services through the Model Context Protocol. Users can manage workspaces, execute DAX queries, refresh datasets, and create Fabric notebooks using natural language.
    Last updated
    6
    29
    2
    MIT

  • TextQL MCP Server

    alexandme
    A
    license
    -
    quality
    D
    maintenance
    Translates natural language to SQL/GraphQL queries and executes them, enabling AI agents to interact with databases through the Model Context Protocol.
    Last updated
    1
    Apache 2.0

View all related MCP servers

Related MCP Connectors

  • mcp

    The grounded data layer for any LLM: governed SQL, metrics, lineage and catalog over your data.

  • mcp

    A Model Context Protocol server for Wix AI tools

  • Microsoft MCP Server for Enterprise

    Official Microsoft MCP Server to query Microsoft Entra data using natural language

View all MCP Connectors

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