Skip to content
Skills Library
Data & analytics · Tool integration

fivetran

/fivetran

Skill for managing Fivetran data pipelines via the Fivetran MCP Server. Activates when the user wants to list, create, modify, sync, or monitor Fivetran connections, destinations, transformations, webhooks, or groups. Covers all 78 tools exposed by the MCP server.

Repository
wire-plugin ↗
Licence
Apache-2.0
Last repository change
22.10.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
0
URLs in SKILL.md
1
Deprecation

No signals detected. Repository changed on 22.10.2026, without references to retired models or APIs.

Licence

Apache-2.0, otwarta: można używać i zmieniać, z zachowaniem licencji i informacji o zmianach.

What it does and when to use it

Skill for managing Fivetran data pipelines via the Fivetran MCP Server. Activates when the user wants to list, create, modify, sync, or monitor Fivetran connections, destinations, transformations, webhooks, or groups. Covers all 78 tools exposed by the MCP server.

Original author description

Skill for managing Fivetran data pipelines via the Fivetran MCP Server. Activates when the user wants to list, create, modify, sync, or monitor Fivetran connections, destinations, transformations, webhooks, or groups. Covers all 78 tools exposed by the MCP server.

How it works

  1. On Activation
  2. When This Skill Activates
  3. Authentication
  4. Key Concepts
  5. Common Use Cases
  6. Full Tool Reference
  7. Safety Guidelines
Original SKILL.md headings · 402 lines, 2,107 words
SKILL.md preview
---
name: fivetran
description: Skill for managing Fivetran data pipelines via the Fivetran MCP Server. Activates when the user wants to list, create, modify, sync, or monitor Fivetran connections, destinations, transformations, webhooks, or groups. Covers all 78 tools exposed by the MCP server.
---

# Fivetran MCP Skill

## On Activation

Before proceeding, append a one-line entry to `.wire/execution_log.md`:

```
| YYYY-MM-DD HH:MM | skill | fivetran | activated | Fivetran pipeline work triggered this skill |
```

If `.wire/execution_log.md` does not exist, create it with the standard header first (see `specs/utils/execution_log.md`). If no `.wire/` directory exists in the current repo, skip this step.



## When This Skill Activates

Activate when the user asks about:
- Listing, creating, modifying, pausing, or deleting Fivetran connections
- Checking sync status or triggering syncs
- Managing destinations (data warehouses)
- Managing transformation projects or dbt transformations
- Working with groups, users, webhooks, or hybrid deployment agents
- Schema / column / table configuration
- Any phrase containing: "Fivetran", "connector", "sync", "pipeline", "destination", "data warehouse"

---

## Authentication

The Fivetran MCP Server authenticates per-request using two headers:
- `X-Fivetran-API-Key` — your Fivetran API key
- `X-Fivetran-API-Secret` — your Fivetran API secret

Get credentials from: **Fivetran dashboard → Account → Settings → API Config**

When using Claude Code with this MCP server configured, credentials are passed via the MCP client setup — you do not need to include them in tool calls.

---

## Key Concepts

**connection_id**: Fivetran's internal ID for a connector (e.g. `unaffected_school`). Use `list_connections` to find IDs.

**group_id**: The destination group ID. Use `list_groups` to find IDs. Connections are associated with groups.

**service**: The connector type slug (e.g. `salesforce`, `postgres`, `calendly`, `hubspot`). Use `list_metadata_connectors` or `get_metadata_connector_config` to discover the correct service slug and its required config fields.

**Auth vs Config for connectors**: Some connectors (e.g. Calendly, Google Analytics) use an `auth` object with `access_token` for OAuth-based authentication, while others use a `config` object with API keys. Always call `get_metadata_connector_config` first when creating a new connector type to check which fields are required and whether they go in `config` or `auth`.

**Write operations**: Tools marked ⚠️ mutate data. The server has a `FIVETRAN_ALLOW_WRITES` env var — if set to `false`, all write operations are blocked. By default, writes are allowed.

---

## Common Use Cases

### 1. List all connections

```
"Show me all my Fivetran connections"
"List connections grouped by destination"
```

Tool: `list_connections` (no arguments required — auto-paginates)

Follow-up: use `list_connections_in_group` with a `group_id` to filter by destination.

---

### 2. Check connection status

```
"What's the status of my Salesforce connection?"
"Are any connections failing?"
"When did my HubSpot connector last sync?"
```

Tools:
- `list_connections` — scan `status.setup_state` and `succeeded_at` / `failed_at` fields
- `get_connection_details` — for a single connection's full status and config
- `get_connection_state` — for granular sync state

---

### 3. Trigger a sync

```
"Sync my Salesforce connection now"
"Force a full historical re-sync of my Stripe connection"
"Re-sync just the orders table in my Postgres connection"
```

Tools:
- `sync_connection` — immediate incremental sync. Pass `{"force": true}` in `request_body` to force.
- `resync_connection` — full historical re-sync (expensive — use sparingly)
- `resync_tables` — re-sync specific tables only

---

### 4. Pause and resume connections

```
"Pause all my connections during maintenance"
"Resume the postgres_production connection"
```

Tool: `modify_connection` with `request_body: {"paused": true}` or `{"paused": false}`

---

### 5. Create a new connection

```
"Create a new Calendly connection syncing to the ra-development destination"
"Set up a HubSpot connector in the marketing group"
```

Workflow:
1. `get_metadata_connector_config` with the service slug — check which fields go in `config` vs `auth`
2. `list_groups` — find the destination `group_id`
3. `create_connection` with:
   - `service`: connector type slug
   - `schema`: destination schema name (permanent, cannot be changed)
   - `group_id`: destination group ID
   - `config`: service-specific config fields (schema is merged in automatically)
   - `auth` (if required): OAuth tokens (use `modify_connection` after creation to set auth)
4. `run_connection_setup_tests` — verify connectivity after creation

**Note on OAuth connectors** (Calendly, Google Analytics, etc.): Create the connection first with `create_connection`, then call `modify_connection` with `{"auth": {"access_token": "..."}}` to add the token. The setup test will fail until auth is provided.

---

### 6. Modify connection settings

```
"Change Salesforce to sync every hour"
"Update the sync frequency of my Stripe connection to 6 hours"
```

Tool: `modify_connection` with `request_body: {"sync_frequency": 60}` (value in minutes)

Common `sync_frequency` values: 5, 15, 30, 60, 180, 360, 720, 1440

---

### 7. Delete a connection

```
"Delete the old Stripe test connection"
```

Tool: `delete_connection` — **DESTRUCTIVE, cannot be undone**. Always confirm with the user before calling.

---

### 8. Manage schema / table / column sync config

```
"Which tables are being synced from my Postgres connection?"
"Disable the internal_logs table from syncing"
"Hash the email column in the users table"
```

Tools:
- `get_connection_schema_config` — view all schemas, tables, columns and their enabled status
- `modify_connection_table_config` — enable/disable a table
- `modify_connection_column_config` — enable/disable or hash a column (`hashed: true` anonymises values)
- `reload_connection_schema_config` — discover new tables added at source since last reload
- `modify_connection_schema_config` — bulk update multiple schemas/tables at once

---

### 9. List and manage destinations

```
"What destinations do I have?"
"Show me the config for my BigQuery destination"
```

Tools:
- `list_destinations` — all destinations
- `get_destination_details` — single destination config
- `run_destination_setup_tests` — verify destination connectivity

---

### 10. Work with groups

```
"List all my destination groups"
"Who's in the ra-development group?"
"Add user@company.com to the marketing group"
```

Tools:
- `list_groups` — all groups with their IDs
- `get_group_details` — single group
- `list_users_in_group` — users with access to a group
- `add_user_to_group` / `delete_user_from_group` — manage group membership
- `list_connections_in_group` — all connections in a specific destination

---

### 11. Manage dbt transformations

```
"List my transformation projects"
"Run the nightly dbt transformation"
"Cancel the transformation that's been running too long"
```

Tools:
- `list_transformation_projects` — all projects
- `list_transformations` — all transformations
- `get_transformation_details` — single transformation
- `run_transformation` — trigger a run
- `cancel_transformation` — cancel a running transformation
- `upgrade_transformation_package` — upgrade dbt package version

---

### 12. Manage webhooks

```
"List my webhooks"
"Create a webhook for sync completion events"
"Test the webhook at https://my-endpoint.com"
```

Tools:
- `list_webhooks` — all webhooks
- `create_account_webhook` — account-level webhook
- `create_group_webhook` — group-level webhook
- `test_webhook` — send a test event
- `delete_webhook` — remove a webhook

---

### 13. Discover connector types

```
"What connectors does Fivetran support?"
"What config fields does the Calendly connector need?"
"What scopes does the HubSpot connector require?"
```

Tools:
- `list_metadata_connectors` — all connector types with metadata
- `get_metadata_connector_config` — detailed config schema for a specific connector (shows required `config` and `auth` fields)
- `list_public_connectors` — public connector list (no auth required)

---

### 14. Get a connection's dashboard URL

```
"Give me the link to the Salesforce connection in Fivetran"
```

Tool: `get_connection_url` with `connection_id`

---

### 15. Account information

```
"What's my Fivetran account info?"
"What plan am I on?"
```

Tool: `get_account_info` (no arguments)

---

## Full Tool Reference

### Account
| Tool | Type | Description |
|------|------|-------------|
| `get_account_info` | Read | Account info for current credentials |

### Connections
| Tool | Type | Description |
|------|------|-------------|
| `list_connections` | Read | All connections (auto-paginated) |
| `create_connection` | Write | Create a new connection |
| `get_connection_details` | Read | Full details for one connection |
| `modify_connection` | Write | Update connection settings |
| `delete_connection` | Destructive | Permanently delete a connection |
| `get_connection_state` | Read | Detailed sync state |
| `modify_connection_state` | Write | Update sync state |
| `sync_connection` | Write | Trigger immediate sync |
| `resync_connection` | Write | Full historical re-sync |
| `resync_tables` | Write | Re-sync specific tables |
| `run_connection_setup_tests` | Write | Verify connection config |
| `create_connect_card` | Write | Embed Fivetran setup UI token |
| `get_connection_url` | Read | Dashboard URL for a connection |

### Schema / Table / Column Config
| Tool | Type | Description |
|------|------|-------------|
| `get_connection_schema_config` | Read | Which tables/columns are enabled |
| `reload_connection_schema_config` | Write | Discover new tables from source |
| `modify_connection_schema_config` | Write | Bulk enable/disable schemas and tables |
| `modify_connection_database_schema_config` | Write | Update a specific database schema |
| `get_connection_column_config` | Read | Column-level config for a table |
| `modify_connection_table_config` | Write | Enable/disable a table |
| `modify_connection_column_config` | Write | Enable/disable/hash a column |
| `delete_connection_column_config` | Destructive | Remove a blocked column config |
| `delete_multiple_columns_connection_config` | Destructive | Remove multiple blocked columns |

### Destinations
| Tool | Type | Description |
|------|------|-------------|
| `list_destinations` | Read | All destinations (auto-paginated) |
| `create_destination` | Write | Create a new destination |
| `get_destination_details` | Read | Config for one destination |
| `modify_destination` | Write | Update destination config |
| `delete_destination` | Destructive | Delete a destination |
| `run_destination_setup_tests` | Write | Verify destination connectivity |

### Groups
| Tool | Type | Description |
|------|------|-------------|
| `list_groups` | Read | All groups (auto-paginated) |
| `create_group` | Write | Create a new group |
| `get_group_details` | Read | Details for one group |
| `modify_group` | Write | Update a group |
| `delete_group` | Destructive | Delete a group |
| `list_connections_in_group` | Read | Connections in a group (auto-paginated) |
| `list_users_in_group` | Read | Users in a group (auto-paginated) |
| `add_user_to_group` | Write | Add a user to a group |
| `delete_user_from_group` | Destructive | Remove a user from a group |
| `get_group_ssh_public_key` | Read | SSH public key for a group |
| `get_group_service_account` | Read | Service account email for a group |

### Log Services
| Tool | Type | Description |
|------|------|-------------|
| `list_log_services` | Read | All external log services |
| `create_log_service` | Write | Create a new log service |
| `get_log_service_details` | Read | Details for one log service |
| `update_log_service` | Write | Update a log service |
| `delete_log_service` | Destructive | Delete a log service |
| `run_log_service_setup_tests` | Write | Test a log service |

### Hybrid Deployment Agents
| Tool | Type | Description |
|------|------|-------------|
| `list_hybrid_deployment_agents` | Read | All hybrid agents |
| `create_hybrid_deployment_agent` | Write | Create a new agent |
| `get_hybrid_deployment_agent` | Read | Details for one agent |
| `re_auth_hybrid_deployment_agent` | Write | Regenerate agent credentials |
| `reset_hybrid_deployment_agent_credentials` | Write | Reset agent credentials |
| `delete_hybrid_deployment_agent` | Destructive | Delete an agent |

### Connector Metadata
| Tool | Type | Description |
|------|------|-------------|
| `list_metadata_connectors` | Read | All connector types with metadata |
| `get_metadata_connector_config` | Read | Config schema for a connector type |
| `list_public_connectors` | Read | Public connector list (no auth) |

### Transformations
| Tool | Type | Description |
|------|------|-------------|
| `list_transformation_projects` | Read | All transformation projects |
| `create_transformation_project` | Write | Create a new project |
| `get_transformation_project_details` | Read | Details for one project |
| `modify_transformation_project` | Write | Update a project |
| `delete_transformation_project` | Destructive | Delete a project |
| `test_transformation_project` | Write | Run project tests |
| `list_transformations` | Read | All transformations |
| `create_transformation` | Write | Create a new transformation |
| `get_transformation_details` | Read | Details for one transformation |
| `update_transformation` | Write | Update a transformation |
| `delete_transformation` | Destructive | Delete a transformation |
| `run_transformation` | Write | Trigger a transformation run |
| `cancel_transformation` | Write | Cancel a running transformation |
| `upgrade_transformation_package` | Write | Upgrade dbt package version |
| `list_transformation_package_metadata` | Read | Quickstart package metadata |
| `get_transformation_package_metadata_details` | Read | Details for a quickstart package |

### Webhooks
| Tool | Type | Description |
|------|------|-------------|
| `list_webhooks` | Read | All webhooks |
| `create_account_webhook` | Write | Create account-level webhook |
| `create_group_webhook` | Write | Create group-level webhook |
| `get_webhook_details` | Read | Details for one webhook |
| `modify_webhook` | Write | Update a webhook |
| `delete_webhook` | Destructive | Delete a webhook |
| `test_webhook` | Write | Send a test event to a webhook |

---

## Safety Guidelines

- Always confirm with the user before calling **Destructive** tools (`delete_*`, `delete_multiple_columns_connection_config`)
- `resync_connection` triggers a full historical re-sync — this can be slow and costly for large datasets. Prefer `sync_connection` unless a full re-sync is specifically needed
- `modify_connection_column_config` with `hashed: true` anonymises data on the next sync — this is a one-way operation per sync cycle
- `schema` in `create_connection` is permanent and cannot be changed after creation — confirm the schema name before creating

Versions

The database has no other skills named fivetran.

Database snapshot: 13.11.2026 · package version b194798606e3 (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 100fivetran-webhooks
    Receive and verify Fivetran webhooks. Use when setting up Fivetran webhook handlers, debugging X-Fivetran-Signature-256 verification, or handling data pipeline events like sync_start, sync_end, connection_failure, or transformation_succeeded.
  • 95migrating-from-fivetran
    Move a user's Fivetran connectors into PostHog data warehouse sources. Use when the user says "migrate from Fivetran", "import my Fivetran setup", "replace Fivetran with PostHog", or asks what of their Fivetran account PostHog can take over. Reads the Fivetran account with a…
  • 100deploy-connector
    Package and deploy a Fivetran connector to Fivetran. Use when the user wants to deploy or ship their connector.
  • 100deploy-connector
    Package and deploy a Fivetran connector to Fivetran. Use when the user wants to deploy or ship their connector.
  • 100fivetran-dagster-to-orchestra
    Use this skill when the user wants to convert a Dagster Fivetran integration — FivetranResource / FivetranWorkspace, build_fivetran_assets, load_fivetran_asset_specs, or fivetran_assets — into an equivalent Orchestra pipeline task. Triggers: any mention of migrating or rewriting…
  • 100fivetran-prefect-to-orchestra
    Use this skill when the user wants to convert a Prefect task that syncs Fivetran — FivetranConnector block, trigger_sync_and_wait_for_completion, or FivetranSyncResult — into an equivalent Orchestra pipeline task. Triggers: any mention of migrating or rewriting Prefect Fivetran…

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.