Fivetran MCP server

Connect Fivetran to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

What you can do with the Fivetran MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the list connections tool in Fivetran
  • Use the update group tool in Fivetran
  • Use the delete group tool in Fivetran
  • Use the delete destination tool in Fivetran
  • Use the list destinations tool in Fivetran
  • Use the update connection tool in Fivetran

Supported Tools

list_connections

List Connections

List all connections (connectors) in the Fivetran account, or within a specific group. Returns summary information about each connection including its status, service type, and sync state.

update_group

Update Group

Update an existing group's name.

delete_group

Delete Group

Delete a group. Inspect its connections, destination and other associated resources before planning removal.

delete_destination

Delete Destination

Delete a destination. This action is irreversible.

list_destinations

List Destinations

List all destinations in the Fivetran account. Each destination is a data warehouse or storage service that receives synced data from connections.

update_connection

Update Connection

Update an existing connection's configuration, sync settings, or paused state. Only provided fields will be updated.

delete_connection

Delete Connection

Delete a connection (connector). Data already written to the destination is retained. This action is irreversible.

list_users

List Users

List all users in the Fivetran account with their roles, status, and contact information.

create_connection

Create Connection

Create a new connection (connector) in a group. Specify the service type and service-specific configuration. Use the **List Connector Types** tool to discover available services and their config requirements.

list_groups

List Groups

List all groups in the Fivetran account. Groups are organizational containers that hold destinations, connectors, users, and other resources.

get_user

Get User

Retrieve details of a specific user or the currently authenticated user.

update_user

Update User

Update a user's information such as name, phone, or role.

get_destination

Get Destination

Retrieve full details of a specific destination, including its status and safe setup-test results. Stored destination credentials are omitted.

trigger_sync

Trigger Sync

Request an incremental sync or a historical re-sync for a connection. Forced incremental sync addresses rescheduling; historical re-sync reloads source data and can incur additional costs.

update_connection_schema

Update Connection Schema

Update the schema configuration for a connection. Enable or disable specific schemas, tables, and columns for syncing. You can also change how new schema changes are handled.

update_destination

Update Destination

Update an existing destination's configuration. Only provided fields will be updated.

reload_connection_schema

Reload Connection Schema

Reload the schema configuration from the source for a connection. This refreshes the available schemas, tables, and columns from the data source.

invite_user

Invite User

Invite a new user to the Fivetran account by email. Assign an account-level role during invitation.

create_group

Create Group

Create a new group. Groups are organizational containers for destinations, connectors, and users.

get_connection

Get Connection

Retrieve full details of a specific connection (connector), including its status and safe setup-test results. Stored source credentials are omitted.

create_destination

Create Destination

Create a new destination within a group. Groups and destinations are mapped 1:1. Specify the service type and service-specific configuration.

get_group

Get Group

Retrieve details of a specific group, including its connections and users.

get_connection_schema

Get Connection Schema

Retrieve the schema configuration for a connection, including which schemas, tables, and columns are enabled or disabled for syncing.

list_webhooks

List Webhooks

List all webhooks configured in the Fivetran account. Webhooks notify external URLs when events like syncs, transformations, or status changes occur.

get_connector_type

Get Connector Type

Retrieve detailed metadata about a specific connector type, including its configuration requirements and supported features.

create_webhook

Create Webhook

Create a new webhook to receive notifications for Fivetran events. Webhooks can be account-level (all activity) or group-level (activity within a specific group).

create_transformation

Create Transformation

Create a new transformation. Transformations can be scheduled to run after connection syncs (integrated), at custom intervals, or on a cron schedule.

get_transformation

Get Transformation

Read a transformation's safe metadata, dependencies, schedule and status. Commands and stored configuration values are omitted.

list_teams

List Teams

List all teams in the Fivetran account with their roles and descriptions.

update_webhook

Update Webhook

Update an existing webhook's URL, events, active status, or secret.

manage_team_membership

Manage Team Membership

Add or remove a user from a team. Use action "add" to add a user and "remove" to remove a user from the team.

get_team

Get Team

Retrieve details of a specific team, optionally including its members.

update_transformation

Update Transformation

Update an existing transformation's configuration, schedule, or connected connections.

run_transformation

Run Transformation

Manually trigger a transformation run. The transformation will execute immediately regardless of its schedule.

delete_webhook

Delete Webhook

Delete a webhook. The webhook will stop receiving event notifications immediately.

update_team

Update Team

Update a team's name, description, or role.

list_transformations

List Transformations

List all transformations in the Fivetran account. Transformations reshape synced data using dbt Core or Quickstart packages.

create_team

Create Team

Create a new team in the Fivetran account. Teams allow you to group users and manage permissions collectively.

list_connector_types

List Connector Types

List all available connector (source) types supported by Fivetran. Use this to discover available services and their IDs when creating new connections.

delete_user

Delete User

Remove a user from the Fivetran account. This revokes all their access.

delete_transformation

Delete Transformation

Delete a transformation. This stops all future runs and removes the configuration.

delete_team

Delete Team

Delete a team from the Fivetran account. Members are not deleted but lose team-based permissions.

get_webhook

Get Webhook

Read an existing webhook subscription, its event types and active status. Signing secrets are omitted.

list_roles

List Roles

Discover current account, destination, connection and team role names before assigning user or team permissions.

get_account

Get Account

Identify the account and user or system key associated with the current API credentials.

Connect Fivetran to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Fivetran in Metorial. In your Metorial portal, enable the Fivetran MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Fivetran tools.

Run Fivetran through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Fivetran and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Fivetran tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Fivetran

Notion

Create, read, update, and archive pages and databases in a Notion workspace. Manage blocks (paragraphs, lists, headings, embeds, etc.) within pages. Query databases with filters and sorts across rich property types including text, numbers, dates, selects, relations, and formulas. Search across pages and databases by title. Add and read comments on pages and blocks. Upload files to pages. Manage workspace users and retrieve user profiles.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Microsoft Outlook

Send, read, reply to, forward, and manage email messages in user mailboxes. Organize messages into folders, apply categories, flags, and importance levels. Manage file and item attachments. Create, update, delete, and respond to calendar events and meetings. Find available meeting times, manage attendees, handle recurrence, and work with shared or delegated calendars. Create, read, update, and delete contacts, organize them into contact folders, and manage contact photos. Manage tasks and task lists via Microsoft To Do, including due dates, reminders, recurrence, and checklist items. Subscribe to webhook notifications for changes to messages, calendar events, and contacts. Support for Focused Inbox, @-mentions, mail tips, send-on-behalf, and send-as capabilities.

Linear

Create, read, update, and delete issues across teams with support for priorities, labels, assignees, due dates, and workflow states. Manage projects that group related issues, and organize work into time-boxed cycles (sprints). Create and manage documents, comments, and file attachments. Search issues using vector similarity or rich filters. Configure teams, workflow states, and labels. Track customers and link them to issues.

Technical notes for Fivetran

Manage Fivetran groups, connections, destinations, schema selection, users, teams, dbt Core and Quickstart transformations, and webhook subscriptions. Discover account identity, source configuration metadata and role names. Configure paused pipelines, inspect status, trigger incremental or historical syncs, and manage controlled data workflows.

Frequently asked questions

Common questions about connecting Fivetran to AI agents with Metorial.

  1. How many tools does the Fivetran MCP server have?
    The Fivetran MCP server exposes 45 tools, including List Connections, Update Group, Delete Group. Each one is governed and traced through Metorial.
  2. Fivetran exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Fivetran MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Fivetran and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Fivetran MCP server yourself or use the hosted gateway.

Connect Fivetran to production AI agents

See how Metorial gives your team governed access to Fivetran, with tracing and security controls built in.