Azure Synapse Analytics Connector for AI agents.
7 live capabilities
Manage your enterprise data pipelines and cloud analytics from your code editor.
Waiting for input…
Why people use Azure Synapse Analytics
Azure Synapse Analytics Data Pipeline Debugging
With this Connector, you just ask your agent what's wrong with a specific pipeline. It pulls the exact definition for you, lets you inspect the steps, and helps you spot the error in seconds. You get to stay in your flow without the context switching.
What Vinkius changes
You get a direct line to your Synapse workspace for faster data engineering and auditing.
Use it from Claude, ChatGPT, Cursor or another AI client you already have.
One account · 5,900+ Connectors
- Real-world use case 01
Fixing a broken ETL
A data engineer notices a nightly sync failed and asks the agent to pull the definition of the 'NightlyCustomerSync' pipeline to find the bad step.
- Real-world use case 02
Auditing cloud costs
A cloud ops person asks the agent to list all Spark and SQL pools to see which ones are currently active and might be driving up the bill.
- Real-world use case 03
Finding research code
A data scientist needs to find a specific Spark notebook for marketing analysis and asks the agent to list all notebooks in the workspace.
Complete set · 7capabilities
The complete Azure Synapse Analytics capability set.
These are the exact actions your AI can choose when you ask it to work with Azure Synapse Analytics.
01—04
4 capabilities in this set.
Part of 7 available through Azure Synapse Analytics.
- 01 Capability
List pipelines
Get a full list of all your data integration pipelines. Use this to see what jobs are currently scheduled or running.
- 02 Capability
List spark pools
View all your pre-provisioned Spark Analytics pools. Check these to manage your big data compute resources.
- 03 Capability
List sql pools
See your dedicated and serverless SQL pools. Use this to monitor your relational data processing power.
- 04 Capability
List datasets
See all the explicit dataset targets in your Synapse workspace. It helps you quickly find where your data is being mapped.
05—07
3 capabilities in this set.
Part of 7 available through Azure Synapse Analytics.
- 05 Capability
List linked services
List all the linked services in your environment. This helps you track how your workspace connects to external sources.
- 06 Capability
Get pipeline
Pull the exact definition for a specific pipeline. This is great for debugging a single job that keeps failing.
- 07 Capability
List notebooks
See all the Apache Spark notebooks in your workspace. Use it to find the right code for your analysis.
Set up in minutes
One URL. Then ask Azure Synapse Analytics to work.
Claude and ChatGPT only need the Connector URL. Copy it once, add it in settings, and use Azure Synapse Analytics from the conversation.
Choose your client
Live previewAdvanced clients IDE · CLI
Claude · Web + desktop
Connector URL · ready to paste
Streamable HTTPhttps://edge.vinkius.com/vk_preview_MqO0WqrVDGRBLkpjn3kMhJJjBY9bjnhtsMU5bx9E/mcp - Step 01
Open Connectors
In Claude Web or Claude Desktop, open Settings and choose Connectors.
- Step 02
Add the URL
Choose Add custom connector, name it Azure Synapse Analytics, and paste the URL above.
- Step 03
Turn it on in chat
Select +, open Connectors, and enable Azure Synapse Analytics for the conversation.
ChatGPT · Web + desktop
Connector URL · ready to paste
Streamable HTTPhttps://edge.vinkius.com/vk_preview_MqO0WqrVDGRBLkpjn3kMhJJjBY9bjnhtsMU5bx9E/mcp - Step 01
Open MCP settings
On desktop, open Settings and MCP servers. On web, open your workspace app or connector settings.
- Step 02
Add the URL
Choose Add server with Streamable HTTP, or create a custom MCP app, then paste the Azure Synapse Analytics URL.
- Step 03
Save and start
Save the connection and enable Azure Synapse Analytics in your conversation. Desktop may ask you to restart once.
Cursor · IDE configuration
Advanced setup
{
"mcpServers": {
"azure-synapse-analytics": {
"url": "https://edge.vinkius.com/vk_preview_MqO0WqrVDGRBLkpjn3kMhJJjBY9bjnhtsMU5bx9E/mcp"
}
}
}- Step 01
Open MCP Settings
Press Cmd+Shift+P (macOS) or Ctrl+Shift+P (Windows/Linux) → search "MCP Settings"
- Step 02
Add the server config
Paste the JSON configuration above into the mcp.json file that opens
- Step 03
Save the file
Cursor will automatically detect the new Connector
- Step 04
Start using Azure Synapse Analytics
Open Agent mode in chat and ask: "Using Azure Synapse Analytics, help me...". 7 tools available
VS Code Copilot · IDE configuration
Advanced setup
{
"mcpServers": {
"azure-synapse-analytics": {
"url": "https://edge.vinkius.com/vk_preview_MqO0WqrVDGRBLkpjn3kMhJJjBY9bjnhtsMU5bx9E/mcp"
}
}
}- Step 01
Create MCP config
Create a .vscode/mcp.json file in your project root
- Step 02
Add the server config
Paste the JSON configuration above
- Step 03
Enable Agent mode
Open GitHub Copilot Chat and switch to Agent mode using the dropdown
- Step 04
Start using Azure Synapse Analytics
Ask Copilot: "Using Azure Synapse Analytics, help me...". 7 tools available
Windsurf · IDE configuration
Advanced setup
{
"mcpServers": {
"azure-synapse-analytics": {
"url": "https://edge.vinkius.com/vk_preview_MqO0WqrVDGRBLkpjn3kMhJJjBY9bjnhtsMU5bx9E/mcp"
}
}
}- Step 01
Open MCP Settings
Go to Settings → MCP Configuration or press Cmd+Shift+P and search "MCP"
- Step 02
Add the server
Paste the JSON configuration above into mcp_config.json
- Step 03
Save and reload
Windsurf will detect the new server automatically
- Step 04
Start using Azure Synapse Analytics
Open Cascade and ask: "Using Azure Synapse Analytics, help me...". 7 tools available
Cline · IDE configuration
Advanced setup
{
"mcpServers": {
"azure-synapse-analytics": {
"url": "https://edge.vinkius.com/vk_preview_MqO0WqrVDGRBLkpjn3kMhJJjBY9bjnhtsMU5bx9E/mcp"
}
}
}- Step 01
Open Cline MCP Settings
Click the Connectors icon in the Cline sidebar panel
- Step 02
Add remote server
Click "Add Connector" and paste the configuration above
- Step 03
Enable the server
Toggle the server switch to ON
- Step 04
Start using Azure Synapse Analytics
Ask Cline: "Using Azure Synapse Analytics, help me...". 7 tools available
Claude Code · Terminal command
Advanced setup
claude mcp add azure-synapse-analytics --transport http "https://edge.vinkius.com/vk_preview_MqO0WqrVDGRBLkpjn3kMhJJjBY9bjnhtsMU5bx9E/mcp"- Step 01
Install Claude Code
Run npm install -g @anthropic-ai/claude-code if not already installed
- Step 02
Add the Connector
Run the command above in your terminal
- Step 03
Verify the connection
Run claude mcp to list connected servers, or type /mcp inside a session
- Step 04
Start using Azure Synapse Analytics
Ask Claude: "Using Azure Synapse Analytics, show me...". 7 tools are ready
Where the request belongs
Work Azure Synapse Analytics can move forward.
This is for the data engineer who's tired of clicking through dashboards at 2am to find why a pipeline failed, or the cloud ops person trying to track down a spike in their Spark pool costs.
Data Engineer
They use this to pull pipeline definitions and audit data mappings without leaving their IDE.
Cloud Ops Engineer
They use it to monitor Spark and SQL pool statuses to manage cloud spending and scaling.
Data Scientist
They use it to quickly survey all notebooks in the workspace to find the right analysis code.
Build the capability set
Add more capabilities.
Each Connector adds new actions and data without changing how you work.
Browse ConnectorsMaterialize (Streaming SQL DB)
Execute streaming SQL, manage compute clusters, and monitor real-time data pipelines directly from your AI agent.
Databricks
Manage lakehouse via Databricks. monitor compute clusters, track job executions, audit SQL warehouses, and explore Unity Catalog directly from any AI agent.
Snowflake
Execute SQL queries, manage databases, and analyze data on Snowflake with AI agents.
Starburst
Connect your AI to Starburst Enterprise. Query federated data lakes, manage access roles, and orchestrate complex data environments seamlessly.
Amazon Redshift
Equip your AI to directly query, analyze, and manage your petabyte-scale data warehouse via the serverless AWS Redshift Data API.
Coalesce
Enable your AI agent to manage Snowflake data pipelines, trigger transformations, and monitor jobs via the Coalesce API.
Bring your own AI
Change the model, client or framework. Keep Azure Synapse Analytics connected.
-
Claude -
ChatGPT -
Gemini -
Cursor -
VS Code -
Windsurf -
ZCode -
Cline -
Zed -
Continue -
Kiro -
Roo Code -
Zencoder -
Goose -
Void -
Augment Code -
Amp -
Qodo -
Tabnine -
Pieces -
Sourcegraph Cody -
JetBrains -
Warp -
Amazon Q -
Antigravity -
BoltAI -
Raycast -
Jan -
LM Studio -
AnythingLLM -
Open WebUI -
Msty -
Cherry Studio -
LibreChat -
TypingMind -
Chorus -
5ire -
n8n -
LangChain -
LlamaIndex -
CrewAI -
Vercel AI SDK
Before you connect
Questions about Azure Synapse Analytics.
The practical details behind the request, access and result.
Can I use Azure Synapse Analytics MCP to see my data pipelines?
Yes, you can list every data integration pipeline in your workspace. This lets you see your entire ETL flow without having to log into the Azure portal.
How does Azure Synapse Analytics MCP help with Spark pools?
It lets you see all your pre-provisioned Spark Analytics pools in one list. You can check which ones are active to help with your big data processing and cost management.
Can I find my notebooks with Azure Synapse Analytics MCP?
Yes, you can list every Apache Spark notebook stored in your workspace. It makes it much faster to find the specific code you need for your analysis.
Does Azure Synapse Analytics MCP show my linked services?
It lists all your explicit linked services, which shows how your workspace connects to things like Blob Storage or Key Vaults. This is great for auditing your data dependencies.
Can I get details on a specific pipeline using Azure Synapse Analytics MCP?
You can pull the precise definition of any single pipeline. This is a huge help when you need to debug a specific job that's failing and you need to see the exact parameters.
Is Azure Synapse Analytics MCP good for cloud ops?
It's great for cloud ops because it lets you remotely inspect compute scale thresholds for SQL and Spark pools. You can answer billing and scaling questions quickly from your chat.
Can I audit completely isolated Spark clusters running heavy tasks?
Yes. Ask the agent to pull your active or paused list_spark_pools. It exposes pre-provisioned engine nodes along with boundaries explicitly defining core-node dimensions for analytic scaling operations.
Can my AI pinpoint the exact failing task inside an ETL pipeline?
Using the specific get_pipeline action equipped with the exact target name, the agent unfolds the raw underlying JSON orchestration topology. You can trace its target execution mappings, identifying incorrectly bounded inputs right on your prompt window.
Is it possible to diagnose broken connectivity to external Azure services?
Yes! The agent can invoke the built-in Linked Services inspector. This extracts all distinct dependencies attached to your current scope, such as mapping paths to a lost Key Vault or orphaned CosmosDB. Finding blind spots has never been faster.
One connection away
Give your agent a direct line to Azure Synapse Analytics.
Connect Azure Synapse Analytics once. Keep it beside 5,900+ managed Connectors when the next task needs more.
Explore every Connector No credit card required · Free tier available