How to Use the Azure Synapse Analytics MCP in VS Code Copilot

Q: Can VS Code Copilot deploy new Azure Synapse Analytics pipelines?

No, the toolset is read-only. Copilot can use listpipelines and getpipeline to inspect your current workspace setup, but it cannot deploy or modify resources.

Q: Can my team view linked services in VS Code Copilot?

Yes. The listlinkedservices tool lists all configured linked services, helping your team verify connection endpoints directly within the chat.

Share Azure Synapse Analytics pipeline and compute metadata with this MCP Server inside VS Code Copilot.

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 VS Code Copilot

Create your Vinkius account to connect Azure Synapse Analytics to VS Code Copilot 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 VS Code Copilot

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Shared Synapse workspace visibility for VS Code Copilot

The `list_pipelines` and `list_linked_services` tools allow engineering teams to share access to Azure Synapse metadata directly through VS Code Copilot. By committing the MCP Server configuration to your repository, every developer gets instant access. Team members can ask Copilot to explain the current data flow or verify connection targets. This keeps everyone aligned on the architecture without requiring everyone to have the Azure Portal open constantly.

Audit compute resources inside VS Code Copilot

The `list_sql_pools` and `list_spark_pools` tools provide direct insight into your active compute infrastructure. Your developers can check the status of dedicated SQL pools or Spark clusters right from the Copilot chat window. This eliminates guesswork when writing database queries or Spark jobs. Copilot checks the available pools in real-time to suggest the correct target compute for your deployment scripts.

Extract pipeline and dataset schemas instantly

The `get_pipeline` and `list_datasets` tools expose raw pipeline structures and explicit targets to your workspace. Copilot reads these definitions to help your team write clean, accurate integration code. You can also search for existing scripts using `list_notebooks`. This ensures your team does not recreate existing data processing logic that is already deployed to your Synapse workspace.

Setup guide

Set up Azure Synapse Analytics MCP in VS Code Copilot

Prerequisites

VS Code 1.99 or later with GitHub Copilot extension
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Open the Command Palette (Cmd+Shift+P / Ctrl+Shift+P) and run "MCP: Add Server". Select HTTP (Streamable) as the server type. VS Code will create .vscode/mcp.json in your workspace.
2

Add the Azure Synapse Analytics MCP

Paste the JSON snippet shown on the right into your .vscode/mcp.json. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Switch to Agent mode

Open Copilot Chat (Cmd+Shift+I / Ctrl+Shift+I) and switch to Agent mode using the dropdown. MCP tools are only available in Agent mode — they do not appear in Edit or Ask modes.
4

Verify the connection

In the Copilot Chat input, type # to list available tools. You should see the Azure Synapse Analytics tools listed. Try asking: "List my recent Azure Synapse Analytics transactions" and Copilot will invoke them automatically.

.vscode/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 VS Code Copilot

You commit the configuration file to your repository. VS Code Copilot automatically loads the MCP tools for the entire team.

No, the toolset is read-only. Copilot can use `list_pipelines` and `get_pipeline` to inspect your current workspace setup, but it cannot deploy or modify resources.

Your Azure credentials run locally or through a zero-trust sandbox. The MCP setup only reads metadata, keeping your raw credentials safe.

The server requires reader access to your Azure Synapse workspace. This allows the tools to fetch pipeline definitions, datasets, and SQL or Spark pool listings.

Yes. The `list_linked_services` tool lists all configured linked services, helping your team verify connection endpoints directly within the chat.

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