How to Use the Azure Synapse Analytics MCP in Google ADK

Q: Can I restrict which Azure Synapse Analytics tools are visible to my Google ADK agent?

Yes, you can use the toolnames filter during the McpToolset setup. This lets you hide administrative tools like listsqlpools while leaving pipeline tools accessible.

Q: How does the Google ADK apply Gemini's long context to the Azure Synapse Analytics MCP Server?

The agent can ingest entire pipeline schemas returned by getpipeline and listnotebooks simultaneously. Gemini processes these large metadata structures in one go to find optimization opportunities across your workspace.

Feed your Azure Synapse Analytics pipeline configurations into Google ADK for long-context Gemini reasoning.

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 Google ADK

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

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Map Synapse Pipelines into Google ADK Context

The `list_pipelines` tool pulls your entire pipeline inventory directly into Gemini's active context window. Your agent then calls `get_pipeline` to load specific JSON definitions, letting the LLM analyze complex ETL logic across thousands of lines of code. Because Google ADK handles long-context inputs, you can feed multiple pipeline JSONs into a single prompt. This lets Gemini map dependencies between Synapse and your Google Cloud data assets without hitting token limits.

Correlate Synapse Datasets with GCP Resources

The `list_datasets` tool exposes all explicit dataset targets defined in your Synapse workspace. Your agent uses this data to cross-reference your Azure storage endpoints with BigQuery tables. The Google ADK framework builds agents that verify if data exported by Synapse has arrived in your Google Cloud buckets. The agent queries `list_linked_services` to trace the network path between clouds.

Audit Compute Configurations via MCP Server

The `list_spark_pools` tool lists all pre-provisioned Apache Spark clusters configured in your workspace. Your agent checks these alongside `list_sql_pools` to evaluate the compute footprint dedicated to your data processing tasks. This MCP Server lets your Gemini-powered agent write optimization reports comparing Azure compute costs with Vertex AI resource usage. The agent gets the exact state of your Synapse compute without manual dashboard digging.

Setup guide

Set up Azure Synapse Analytics MCP in Google ADK

Prerequisites

Python 3.10+ installed
google-adk package (pip install google-adk)
Active Vinkius subscription with a valid endpoint token

1

Install Google ADK

Run pip install google-adk to install the Agent Development Kit. MCP support is included via the McpToolset class.
2

Connect via SSE transport

Use McpToolset.from_server() with SseServerParams pointing to your Vinkius endpoint. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.
3

Create an LlmAgent

Pass the returned mcp_tools list directly to LlmAgent(tools=mcp_tools). The ADK maps each MCP tool to a native Gemini function call — no manual schema definitions required.
4

Run with any Gemini model

The agent works with any Gemini model (gemini-2.0-flash, gemini-2.5-pro, etc.). Copy the full example on the right to get started with Azure Synapse Analytics tools in your ADK agent.

agent.py

from google.adk.agents import LlmAgent
from google.adk.tools.mcp_tool.mcp_toolset import McpToolset
from google.adk.tools.mcp_tool.mcp_session_manager import SseServerParams

# Connect to the MCP via SSE
mcp_tools, exit_stack = await McpToolset.from_server(
    connection_params=SseServerParams(
        url="https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    )
)

# Create your agent with auto-discovered tools
agent = LlmAgent(
    name="Azure Synapse Analytics_agent",
    model="gemini-2.0-flash",
    instruction="You have access to Azure Synapse Analytics tools via MCP.",
    tools=mcp_tools,
)

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 Google ADK

You initialize the McpToolset using the HTTP transport URL provided by Vinkius. Pass this toolset into your LlmAgent constructor to expose the MCP tools to your Gemini model.

Yes, you can use the tool_names filter during the McpToolset setup. This lets you hide administrative tools like `list_sql_pools` while leaving pipeline tools accessible.

The agent can ingest entire pipeline schemas returned by `get_pipeline` and `list_notebooks` simultaneously. Gemini processes these large metadata structures in one go to find optimization opportunities across your workspace.

No, this server is restricted to workspace metadata. Tools like `list_sql_pools` only return configuration details and pool status, not the actual rows stored inside your SQL tables.

This server only reads Synapse workspace metadata and configuration schemas. Vinkius secures your Azure credentials within a zero-trust, ephemeral sandbox, ensuring your authentication tokens are never exposed to the Google ADK client or external networks.

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