MCP For Claude Marketplace
Azure Synapse Analytics

Azure Synapse Analytics MCP Connector for Claude

A+

Manage your Azure Synapse data pipelines seamlessly — audit Spark pools, SQL pools, datasets, and integration pipelines via your AI agent.

7 tools Official Updated Jun 28, 2026 Official Vinkius Partner
More Details Connect to Claude

Connect your Azure Synapse workspace to any AI agent and take full control of your enterprise analytics workflows and data integration limits through natural conversation.

What you can do

  • Compute Pools — Monitor currently provisioned infrastructure, ranging from Serverless/Dedicated SQL Pools to your active Apache Spark analytic clusters
  • Integration Pipelines — Dissect data movement workflows (ETL/ELT), viewing precise activity target parameters and logical steps for a single tracked job
  • Notebooks — Explore global Apache Spark analytics notebooks stored in the workspace mapped limits
  • Datasets & Schemas — Audit specifically defined storage mappings shaping static or dynamic structures natively inside the limits
  • Linked Services — Safely extract dependencies indicating external mappings referencing Key Vaults, Blob Storages, or other crucial endpoints

How it works

  1. Subscribe to this server
  2. Provide your Azure Synapse Workspace URL and an active Access Token
  3. Start dispatching complex analytics queries or debugging pipeline health from Claude, Cursor, or any MCP-compatible client

Who is this for?

  • Data Engineers — trace failed pipelines and dissect linked service misconfigurations seamlessly without bouncing back to the Azure portal
  • Data Scientists — survey available Spark Notebooks and retrieve dataset bounds quickly to evaluate variables right in the AI IDE
  • Cloud Ops — remotely inspect compute scale thresholds (SQL/Spark pools) answering billing and scaling architecture queries on-demand
data-warehousingbig-dataspark-poolssql-poolspipeline-orchestrationdata-integration

7 tools expose this connector's capabilities to your AI agent.

list_datasets

List all Azure Synapse explicit datasets targets

list_pipelines

List all Azure Synapse Analytics data integration pipelines

get_pipeline

Get precise definition of a specific Azure Synapse pipeline

list_notebooks

List all Azure Synapse Spark notebooks

list_spark_pools

List pre-provisioned Apache Spark Analytics pools

list_sql_pools

List dedicated and serverless SQL Analytics pools in Synapse

list_linked_services

List explicit Azure Synapse Linked Services

See how to talk to your AI agent using Azure Synapse Analytics.

Retrieve the full integration topology for 'NightlyCustomerSync'.

I fetched 'NightlyCustomerSync' configurations recursively. It contains 3 connected flow steps. An initial lookup against an external datastore proceeds towards a massive iterative mapping sequence. Would you like me to inspect the target payload for the iteration loop?

List all Spark Notebooks currently stored in this analytic root.

You have 12 Apache Spark Notebooks saved. Three are flagged primarily for Marketing ML analysis utilizing the basic 8-core compute provision. The others govern deep ETL mapping routines. Shall we retrieve the metadata code mapping one of them?

Check and audit our externally mapping Linked Services health statuses.

I discovered 4 linked services mapped to this workspace constraint natively. 'DataLakeStorageV2' and 'SQLDedicated' indicate active, properly anchored keys. The last one, 'StagingKeyVault', is issuing a deprecation notice for an aging secret token mapping.

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.

Related Connectors

CR

Cronofy MCP

10 tools Official

Automate scheduling via Cronofy — unify Google, iCloud, and Exchange calendars to manage events and track multi-user availability directly from any AI agent.

A+ View details →
RE

Redo MCP

12 tools Official

Manage returns, track shipping protection claims, and oversee exchanges via AI agents with Redo.

A+ View details →
GR

GrowingIO MCP

10 tools Official

Leading product analytics platform in China — manage events, segments, and metrics via AI.

A+ View details →
MA

Marqo AI (Vector Search & Embeddings) MCP

6 tools Official

Manage semantic search via Marqo — execute tensor queries, index JSON documents, and audit vector indices.

A+ View details →