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 Oct 1, 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_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_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_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

NEW
Paris Housing: Rent Caps & Social Housing

Paris Housing: Rent Caps & Social Housing MCP

7 tools Official

Keyless Paris housing data: the official rent-control ceilings by room/zone/building era (2019–2025), social-housing program delivery 2001–2024, and the housing waiting-list counts per arrondissement.

A+ View details →
Webhook HMAC Signature Validator

Webhook HMAC Signature Validator MCP

3 tools Official

Verify the authenticity of incoming webhook payloads by validating their HMAC signatures.

A+ View details →
HTML to Markdown Converter

HTML to Markdown Converter MCP

1 tools Official

Stop LLMs from skipping website content. Convert massive HTML files into clean Markdown deterministically without data loss.

A+ View details →
Html2Pdf

Html2Pdf MCP

1 tools Official

Convert any website URL or raw HTML into high-quality PDF documents directly from your AI agent.

A+ View details →