# Fivetran MCP

> Fivetran MCP connects your AI client directly to your automated data movement and ELT pipelines. It lets you monitor connector health, audit destination settings, track sync progress, and manage user access—all through natural conversation. You get full visibility into complex data flows without ever having to open the Fivetran interface.

## Overview
- **Category:** ship-it
- **Price:** Free
- **Tags:** elt-pipelines, data-integration, connector-orchestration, data-warehousing, sync-monitoring, automated-data-movement

## Description

Managing data pipelines usually means jumping between dashboards, clicking through tabs, and running reports just to check if everything is still connected correctly. This MCP changes that. It lets you take control of your entire automated data movement process using only chat commands in your preferred AI client. You can ask your agent to list all connectors within a specific group or pull up the detailed configuration for any destination database. Need to know who has access? Your agent enumerates all registered users and teams instantly. The MCP allows you to verify precise sync statuses across organizational pipelines, giving you immediate confirmation of data movement progress. Because Vinkius hosts this catalog, you connect your AI client once and gain access to deep, operational control over your most critical data infrastructure.

## Tools

### list_connectors
Retrieves a list of all data connectors within a specific group.

### get_connector
Pulls detailed configuration and status information for one particular connector.

### list_groups
Lists all the destination groups configured in your Fivetran account.

### get_group
Retrieves detailed information about a specified destination group.

### get_destination
Gets the specific configuration details for a data warehouse connected to your groups.

### list_users
Lists all individual users registered and authorized within the Fivetran workspace.

### list_teams
Retrieves a list of all defined user teams and their structures.

## Prompt Examples

**Prompt:** 
```
List all Fivetran groups in my account
```

**Response:** 
```
Retrieving groups... I found 3 groups (destinations): 'Marketing-Analytics', 'Product-Insights', and 'Finance-Sync'. Which one would you like to see the connectors for?
```

**Prompt:** 
```
What is the status of connector 'conn_abc123'?
```

**Response:** 
```
Retrieving connector details... Connector 'conn_abc123' (PostgreSQL) is currently 'Active'. The last sync finished 15 minutes ago with no errors. The next sync is scheduled for top of the hour.
```

**Prompt:** 
```
List all users in the Fivetran workspace
```

**Response:** 
```
Retrieving users... I found 5 registered users. Highlights include 'Admin User' (Account Administrator), 'Data Analyst' (Analyst), and 3 other members. Would you like the detailed profile for any of them?
```

## Capabilities

### Audit Connector Status
You check the configuration details for any specific connector or list every active connector within a defined group.

### Review Data Destinations
You retrieve setup and configuration details for all connected destination databases, verifying where your data is actually being delivered.

### Monitor Sync Progress
Your agent identifies the current sync status and validates physical progress across organizational pipelines in real-time.

### Manage Workspace Users
You list all registered users and RBAC teams, checking access levels and administrative statuses within the workspace.

## Use Cases

### Verifying a New Data Source Connection
A developer just activated a new data stream and needs to confirm it's ready. They ask their agent to check the connector details using `get_connector` and then verify its sync status, getting confirmation that the connection is 'Active' with no errors.

### Onboarding a New Team Member
An IT admin needs to know who has access before granting credentials. They ask the agent to run `list_users` and get a summary of all registered personnel, confirming their roles and team affiliations quickly.

### Auditing Data Warehouse Boundaries
An analytics lead suspects data is missing from a report. They use the destination tools to check the configuration for the target data warehouse (`get_destination`), ensuring that the correct group was mapped and delivery boundaries are sound.

### Debugging ELT Flow Failures
A data engineer notices a pipeline is failing. Instead of diving into logs, they ask their agent to list all groups (`list_groups`) and then use `get_group` on the affected destination to check for structural constraints or mapping errors.

## Benefits

- Stop opening the Fivetran UI just to check a status. You can ask your agent for the current active sync statuses instantly, confirming physical data movement progress without leaving your workspace.
- Gain immediate visibility into who has access. Use `list_users` and `list_teams` to enumerate all registered users and RBAC teams in real-time, making user oversight simple.
- Validate where data is going. By using the destination tools, you can retrieve configuration details for connected databases, verifying delivery boundaries instantly.
- Troubleshoot connectors quickly. You can use `list_connectors` to see all available sources and then run `get_connector` to check its specific setup state or schema details.
- Manage data flow structure. You don't have to guess which source maps where; you can retrieve complex structural arrays defining global resource mappings.

## How It Works

The bottom line is you manage complex, automated data pipelines using simple conversation rather than clicking through dashboards.

1. Subscribe to this MCP on Vinkius.
2. Enter your Fivetran API Key and API Secret into your client's settings (found in Account Settings > API Config).
3. Ask your AI agent anything about your data flow—like listing groups or checking sync status—and get immediate results.

## Frequently Asked Questions

**Can the Fivetran MCP list all my data sources?**
Yes, you can use the `list_connectors` tool to retrieve a detailed listing of all connectors within any specified group or destination.

**How do I check if a user has admin rights using Fivetran MCP?**
You run the `list_users` tool. This lists every registered user, allowing you to see their role and administrative status within the workspace immediately.

**Does Fivetran MCP help me debug failed pipelines?**
It helps by providing diagnostic data. You can use `get_connector` to retrieve detailed configuration information that points to potential issues, like schema or setup state problems.

**What is the difference between listing groups and getting a destination?**
Using `list_groups` gives you a high-level roster of all destination containers. Running `get_destination` provides the specific configuration details for one of those destinations.

**Is Fivetran MCP only useful for data engineers?**
No. While powerful for data engineers, analytics leads can use it to audit pipelines and IT admins can use it for user oversight, making it valuable across multiple roles.

**Can my agent list all connectors in a specific Fivetran group?**
Yes. Use the 'list_connectors' tool. Provide the Group ID, and the agent will return a list of all connectors configured within that destination group, including their unique IDs and statuses.

**How do I check the details of a specific data destination via chat?**
Use the 'get_destination' tool. Provide the Group ID. Your agent will retrieve configuration details about the database or data warehouse connected to that group, providing clear boundary information natively.

**Can I audit users and their roles in my Fivetran workspace through the agent?**
Absolutely. Use the 'list_users' tool. The agent retrieves all registered users in your workspace with their assigned roles and current statuses, allowing for organizational administrative auditing natively.