How to Use the Azure Synapse Analytics MCP in Claude

Q: Can I trigger or edit an Azure Synapse Analytics pipeline from Claude Desktop?

No, this server is read-only. It exposes tools like getpipeline and listpipelines to inspect configurations, but it does not have write permissions to modify or execute pipelines.

Q: Does this server support serverless SQL pools?

Yes. The listsqlpools tool lists both dedicated and serverless SQL Analytics pools configured in your Synapse workspace.

Audit your Azure Synapse Analytics pipelines and Spark pools with this MCP Server inside Claude Desktop.

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 Claude Desktop

Create your Vinkius account to connect Azure Synapse Analytics to Claude Desktop 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 Claude Desktop

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Inspect Synapse pipelines right from Claude Desktop

The `list_pipelines` tool exposes your Azure Synapse pipeline configurations directly inside Claude Desktop. Your agent uses this to pull your entire integration pipeline list into your active session. Instead of clicking through the Synapse Studio UI, you ask Claude Desktop to compare pipeline configurations. This saves you from context-switching when you are trying to find why a specific trigger failed or which dataset is bound to which activity.

Audit Spark and SQL compute pools in chat

The `list_spark_pools` and `list_sql_pools` tools let your agent query your active analytical runtimes directly. This gives you immediate visibility into your dedicated and serverless SQL pools alongside your pre-provisioned Apache Spark pools. When you need to check if a cluster is running or check its scale settings, Claude Desktop fetches these details instantly. You get the raw specs of your compute resources without digging through active resource groups in Azure.

Map datasets and linked services instantly

The `list_linked_services` tool maps your data architecture connections inside your chat window. This MCP Server lets your agent see exactly where your Synapse workspace is pulling data from. You can also locate Spark code by running `list_notebooks` to see what scripts are available for your data engineering jobs. Having this metadata inside Claude Desktop means you can document your entire ETL architecture by just talking to your agent.

Setup guide

Set up Azure Synapse Analytics MCP in Claude Web or Desktop

1

Open Claude Settings

Go to claude.ai, click your profile icon, then navigate to Customize → Connectors.
2

Add Custom Connector

Click the "+" button and select Add custom connector. Paste your Vinkius endpoint URL: https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. For OAuth-protected servers, expand Advanced settings to add credentials.
3

Start a conversation

Open a new chat. The Azure Synapse Analytics MCP tools are available immediately — no restart needed.

Endpoint URL

https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp

No configuration file needed — paste the URL directly in the Claude web interface.

Available on Free (1 connector), Pro, Max, Team, and Enterprise plans.

Prerequisites

Claude Desktop installed (macOS or Windows)
Active Vinkius subscription with a valid endpoint token

1

Open Claude Desktop Settings

Click the menu icon at the top-left corner, go to Settings → Developer → Edit Config. This opens claude_desktop_config.json in your default text editor.
2

Paste the Azure Synapse Analytics MCP configuration

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

Restart Claude Desktop

Close and reopen the application. Claude needs a full restart to load new MCPs — refreshing a conversation is not enough.
4

Verify the connection

Open a new conversation. Click the 🔌 icon at the bottom of the message input. You should see tools listed under azure-synapse-analytics-mcp.

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 Claude Desktop

Claude Desktop connects to the server running locally via your configuration file or remotely via a custom connector. The server uses your Azure credentials to query the Synapse API and feeds the resource metadata directly into your chat.

No, this server is read-only. It exposes tools like `get_pipeline` and `list_pipelines` to inspect configurations, but it does not have write permissions to modify or execute pipelines.

You config it by adding the details to your configuration file. Once saved, the MCP tools appear under the hammer icon.

Yes. The `list_sql_pools` tool lists both dedicated and serverless SQL Analytics pools configured in your Synapse workspace.

Your workspace metadata, including pipeline configurations, Spark pool lists, and linked services, stays inside your local environment or secure Vinkius sandbox. This MCP setup keeps your Azure environment isolated.

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