ms_fabric_mcp

duggurd/ms_fabric_mcp

3.3

If you are the rightful owner of ms_fabric_mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The MS Fabric MCP Server is a Model Context Protocol server designed to facilitate querying and exploration of schemas in Microsoft Fabric items, enhancing automation in data engineering workflows.

The MS Fabric MCP Server is a robust solution for automating data engineering processes by enabling seamless interaction with Microsoft Fabric items. It allows clients to query and explore schemas in lakehouses, warehouses, and SQL databases, thereby streamlining the automation of data pipeline construction. The server leverages Azure Active Directory (AAD) token authentication to ensure secure access. With the ability to execute read-only SQL queries, search for tables and columns, and analyze historical query patterns, the server provides a comprehensive toolset for data engineers and developers. By integrating with various platforms through simple setup instructions and configuration, the MS Fabric MCP Server enhances the efficiency and reliability of data workflows.

Features

  • Enables querying and exploration of schemas in Microsoft Fabric items.
  • Supports Azure Active Directory (AAD) token authentication for secure access.
  • Facilitates automation of data engineering workflows by interacting with lakehouses, warehouses, and SQL databases.
  • Provides tools for executing read-only SQL queries and searching for tables and columns.
  • Analyzes historical query patterns to aid in efficient query construction.

Usages

usage with Cursor

"ms-fabric-mcp": {
  "command": "uv",
  "args": [
    "--directory",
    "path/to/server",
    "run",
    "mcp"
  ],
  "env": {
      "SQL_SERVER_NAME": "xyz-xyz.datawarehouse.fabric.microsoft.com",
      "SQL_DATABASE_NAME": "dev",
      "ODBC_DRIVER": "{ODBC Driver 18 for SQL Server}"
  }
}

usage with Claude Desktop

"ms-fabric-mcp": {
  "command": "uv",
  "args": [
    "--directory",
    "path/to/server",
    "run",
    "mcp"
  ],
  "env": {
      "SQL_SERVER_NAME": "xyz-xyz.datawarehouse.fabric.microsoft.com",
      "SQL_DATABASE_NAME": "dev",
      "ODBC_DRIVER": "{ODBC Driver 18 for SQL Server}"
  }
}

Tools

  1. query

    Executes a read-only SQL query against the configured SQL Server database.

  2. search_tables

    Searches for tables by name in the INFORMATION_SCHEMA.TABLES view.

  3. search_columns_by_table

    Searches for columns in tables matching the provided name.

  4. search_tables_by_column

    Searches for tables containing columns matching the provided name.

  5. search_query_patterns

    Searches historical query patterns from the queryinsights.exec_requests_history view.