How to connect Fabric to Cursor

  • Cursor gets 36 Fabric tools through one Metorial MCP URL.
  • Setup is 3 steps; teammates then sign in with SSO.
  • You need Cursor with MCP support.

What Cursor can do with Fabric

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Ask Cursor to use the one lake list table namespaces tool in Fabric
  • Ask Cursor to use the data factory get pipeline tool in Fabric
  • Ask Cursor to use the core create item tool in Fabric
  • Ask Cursor to use the data factory list pipelines tool in Fabric
  • Ask Cursor to use the one lake create directory tool in Fabric

Add the Fabric MCP server to Cursor

Run these once. Afterwards, everyone you give access to signs in the same way.

  1. 1. Enable Fabric in Metorial

    In your Metorial portal, enable the Fabric MCP server and sign in with the account that owns the data. Access stays governed by your team policies.

  2. 2. Add Metorial to your MCP config

    Use ~/.cursor/mcp.json for every project, or .cursor/mcp.json for one.

    {
    "mcpServers": {
    "metorial": {
    "url": "<your-magic-mcp-url>"
    }
    }
    }
  3. 3. Sign in

    Open Customize in the sidebar, find Metorial and sign in to load Fabric tools.

Give your team Fabric in Cursor

Once Fabric is enabled in Metorial, teammates sign in with SSO and get the same connection in Cursor, with only the tools their role allows.

One link covers every app you approve. See how the MCP gateway handles access, roles and audit logs for the whole company.

Fabric tools available in Cursor

Full descriptions and inputs are on the Fabric MCP server page.

Using Fabric tools in Cursor

What to expect once Fabric is connected.

  • Cursor picks MCP tools automatically when they are relevant, including in Plan Mode. Name a Fabric tool to steer it.
  • Cursor asks for approval before it uses an MCP tool by default. Click the arrow next to the tool name to check the arguments first.
  • Switch the Metorial server off from Customize in the sidebar without removing it.
  • Cursor shows each Fabric tool response in chat, with expandable views of the arguments and the result.

Troubleshooting Cursor

Metorial connects but tools are missing or failing
Open the Output panel (Cmd+Shift+U), choose MCP Logs, and look for authentication or connection errors.
Your company blocks the server
Enterprise admins approve remote servers in Team Settings, then MCP Configuration. Ask them to add a URL entry for your Metorial URL.
Cursor asks before every tool call
That is the default. Allowlist the Metorial tools you trust in your Run Mode settings to run them without a prompt.

Based on the Cursor MCP documentation.

Frequently asked questions

Common questions about connecting Fabric to AI agents with Metorial.

  1. Does Cursor support the Fabric MCP server?
    Yes. Cursor connects to the Fabric MCP server through its MCP config file, pointed at your Metorial URL. You need Cursor with MCP support.
  2. No. You sign in to Fabric once through Metorial, and Cursor uses that connection. No API keys go into Cursor's settings.
  3. All 36 Fabric tools your team allows, such as Docs Workload API Spec, Docs Platform API Spec, Docs Workloads. Admins can narrow that list per team.
  4. Yes. Role-based access control decides who can use Fabric and which of its tools appear in Cursor, and every call is logged with the person's identity.
  5. Open the Output panel (Cmd+Shift+U), choose MCP Logs, and look for authentication or connection errors.