# Azure Synapse Analytics MCP for AI Agents AI Agent Connect

> Azure Synapse Analytics MCP connects your workspace to your AI agent, letting you audit data pipelines, check Spark and SQL pool statuses, and manage your cloud analytics without leaving your editor.

## Overview
- **Category:** industry-titans
- **Price:** Free
- **Endpoint:** https://edge.vinkius.com/vk_preview_MqO0WqrVDGRBLkpjn3kMhJJjBY9bjnhtsMU5bx9E/ai-agent-connect
- **Tags:** data-warehousing, big-data, spark-pools, sql-pools, pipeline-orchestration, data-integration

## Description

This Connector connects your workspace to your AI agent so you can handle data engineering tasks without jumping back to the Azure portal. You'll be able to see what's happening with your Spark pools or check the status of your SQL pools directly in your chat. If a data pipeline breaks, you can grab the exact definition of a specific job to figure out where it failed. It also lets you map out your linked services to see how your data flows between Key Vaults and Blob Storage. Finding the right Spark notebook or auditing your dataset schemas becomes a quick conversation instead of a manual search. It's a big time saver for anyone who spends their day managing complex analytics workflows. You can quickly survey your infrastructure to see what's provisioned and what's active, making it much easier to stay on top of your cloud spending. Whether you're tracing a failed ETL job or just trying to find a specific notebook for a new project, this connection puts all your workspace metadata into a single, searchable interface. It takes the friction out of cloud architecture by letting you ask questions about your compute thresholds and data mappings in plain English. You'll find it easy to get running through the Vinkius catalog.

## Tools

### list_pipelines
Get a full list of all your data integration pipelines. Use this to see what jobs are currently scheduled or running.

### list_spark_pools
View all your pre-provisioned Spark Analytics pools. Check these to manage your big data compute resources.

### list_sql_pools
See your dedicated and serverless SQL pools. Use this to monitor your relational data processing power.

### list_datasets
See all the explicit dataset targets in your Synapse workspace. It helps you quickly find where your data is being mapped.

### list_linked_services
List all the linked services in your environment. This helps you track how your workspace connects to external sources.

### get_pipeline
Pull the exact definition for a specific pipeline. This is great for debugging a single job that keeps failing.

### list_notebooks
See all the Apache Spark notebooks in your workspace. Use it to find the right code for your analysis.

## Prompt Examples

**Prompt:** 
```
Retrieve the full integration topology for 'NightlyCustomerSync'.
```

**Response:** 
```
I've pulled the configuration for 'NightlyCustomerSync'. It consists of 3 connected steps:

*   **Initial Lookup**: Queries an external datastore.
*   **Mapping Sequence**: A large iterative process for data transformation.
*   **Final Load**: Targets your primary sink.

Would you like me to look at the specific parameters for that mapping sequence?
```

**Prompt:** 
```
List all Spark Notebooks currently stored in this analytic root.
```

**Response:** 
```
I found 12 Apache Spark Notebooks in your workspace:

| Notebook Name | Primary Use | Compute |
| :--- | :--- | :--- |
| Mkt_ML_Analysis | Marketing ML | 8-core |
| ETL_Mapping_01 | Deep ETL | Standard |
| ETL_Mapping_02 | Deep ETL | Standard |
| ... | ... | ... |

Should I pull the code for a specific one?
```

**Prompt:** 
```
Check and audit our externally mapping Linked Services health statuses.
```

**Response:** 
```
I've audited your Linked Services. Here's what I found:

*   **DataLakeStorageV2**: Active and properly anchored.
*   **SQLDedicated**: Active and properly anchored.
*   **StagingKeyVault**: **Warning** - This service is issuing a deprecation notice for an aging secret token mapping.
```

## Capabilities

### Audit data pipelines
See every step and parameter in your ETL workflows to find where things break.

### Check compute pools
View your active Spark and SQL pool statuses in one glance.

### Explore Spark notebooks
List and find the specific notebooks stored in your workspace.

### Map linked services
Identify external dependencies like Blob Storage or Key Vaults.

### Inspect datasets
Audit the storage mappings for your static and dynamic data structures.

## Use Cases

### 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.

### 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.

### 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.

### Security review
A security lead asks the agent to list all linked services to identify which external endpoints like Blob Storage are currently connected.

## Benefits

- Stop jumping between tabs by using list_pipelines to see your data flows without leaving your editor.
- Debug failed jobs faster by using get_pipeline to see exact parameters for a single job that's failing.
- Manage costs and scaling by using list_spark_pools and list_sql_pools to monitor active compute.
- Audit your security and data flow by using list_linked_services to see connections to Key Vaults and Blob Storage.
- Find your analysis code faster by using list_notebooks to see every Spark notebook in your workspace.
- Verify your data structures by using list_datasets to check storage mappings for static or dynamic data.

## How It Works

The bottom line is you get a direct line to your Synapse workspace for faster data engineering and auditing.

1. Subscribe to the Azure Synapse Analytics MCP from the Vinkius catalog.
2. Provide your Workspace URL and an active Access Token in your client settings.
3. Ask your agent to list pipelines, check pool statuses, or audit your datasets.

## Frequently Asked Questions

**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.