How to Use the Azure Synapse Analytics MCP in Windsurf

Q: How do I configure the Azure Synapse Analytics MCP Server in Windsurf?

Open your settings and add the server to /.codeium/windsurf/mcpconfig.json under the mcpServers key. Cascade automatically reads the schema and registers the tools.

Q: Can Windsurf fetch Azure Synapse Analytics Spark notebooks directly?

Yes, Cascade uses the listnotebooks tool to query your workspace and retrieve notebook metadata. This helps you audit spark jobs directly from your IDE.

Let Cascade map out your data lake, audit SQL pools, and trace Synapse pipelines autonomously inside Windsurf.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Azure Synapse Analytics MCP to Windsurf

Create your Vinkius account to connect Azure Synapse Analytics to Windsurf and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Azure Synapse Analytics with Windsurf

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Audit Data Pipelines Autonomously

Cascade traces your ETL routes without you clicking through the Azure Portal. By calling `list_pipelines` and pulling specific definitions with `get_pipeline`, your Windsurf agent builds a mental map of your data flow. It knows which pipeline failed and why, checking the exact JSON configuration directly. You don't have to guide Cascade step-by-step. Just point it at a failing run, and it uses this MCP Server to inspect the pipeline logic and pinpoint the broken activity.

Inspect SQL and Spark Pools in Windsurf

Stop leaving your editor to check if a cluster is running or over-provisioned. Windsurf queries `list_sql_pools` and `list_spark_pools` to check your active compute resources. It spots idle dedicated SQL pools costing you money or under-sized Spark pools causing job timeouts. Cascade uses this telemetry to recommend instant compute adjustments. It links resource states directly to the notebook or script you are editing, ensuring your code runs on the right environment.

Map Dataset Dependencies

When editing a data model, Cascade uses `list_datasets` and `list_linked_services` to verify your upstream connections. It traces where your raw files live and how they connect to Synapse without manual documentation lookup. This means you can refactor a database schema and let Windsurf verify every single linked service that depends on it. No broken connections after deployment.

Setup guide

Set up Azure Synapse Analytics MCP in Windsurf

Prerequisites

Windsurf IDE installed (macOS, Windows, or Linux)
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Click the Cascade assistant icon in the sidebar, then click the hammer icon (🔨) at the top of the panel. Select "Configure" to open ~/.codeium/windsurf/mcp_config.json.
2

Add the Azure Synapse Analytics MCP

Paste the JSON snippet shown on the right into the mcpServers object. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Refresh MCPs

Go back to the hammer icon (🔨) in Cascade and click "Refresh". Windsurf will detect the new server. No full restart is needed — the connection is hot-reloaded.
4

Verify in Cascade

Start a new Cascade conversation and ask something like "Show my Azure Synapse Analytics payment history." If connected, Cascade will call the Azure Synapse Analytics tools directly. You will see a green dot next to the server name in the MCP panel.

mcp_config.json

{
  "mcpServers": {
    "azure-synapse-analytics-mcp": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Azure Synapse Analytics. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Azure Synapse Analytics now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Azure Synapse Analytics MCP in Windsurf

Open your settings and add the server to `~/.codeium/windsurf/mcp_config.json` under the `mcpServers` key. Cascade automatically reads the schema and registers the tools.

Yes, Cascade uses the `list_notebooks` tool to query your workspace and retrieve notebook metadata. This helps you audit spark jobs directly from your IDE.

Vinkius manages the authentication layer securely. You provide one endpoint token to Windsurf, and our hosted platform handles the Azure AD handshake safely.

Cascade operates autonomously to read metadata. It chains calls like `list_pipelines` and `get_pipeline` to answer your questions without prompting you for every single step.

Your Synapse pipeline definitions, SQL/Spark pool names, and linked service configurations never persist on our servers. Vinkius runs a zero-trust, ephemeral V8 sandbox that isolates your metadata, ensuring it only flows directly to your Windsurf client.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript