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.

Tools

Functions exposed to the LLM to take actions

query

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

search_tables

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

search_columns_by_table

Searches for columns in tables matching the provided name.

search_tables_by_column

Searches for tables containing columns matching the provided name.

search_query_patterns

Searches historical query patterns from the queryinsights.exec_requests_history view.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

duggurd

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/duggurd/ms_fabric_mcp

GitHub Stars

License

MIT License

Last publish date

2025-05-18

Last update date

2025-09-06

Server configs

in 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}"
  }
}

in 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}"
  }
}