Integration

Fivetran integration

Fivetran REST API for managing automated data pipelines from 400+ sources to data warehouses. Manage connectors, destinations, groups, users, schemas, and trigger sync operations for ELT workflows.

Connect Fivetran How integrations work

Ask it in chat

Say what should happen.
The workflow builds itself.

When this happens, do that in Fivetran.Built from the 27 Fivetran tools below, on the connection you add once.

Common Fivetran use cases

automate connector management
automate destination management
automate group management
automate user management
automate connector schema management
add user programmatically
get user programmatically
get group programmatically
list user programmatically
list group programmatically

What you can do with Fivetran

Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.

Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.

Connector, 6 operations

create_connectorCreate connectorPOSTCreate a new connector to start syncing data from a source service into a destination. The connector is created and optionally starts syncing based on the paused flag.
delete_connectorDelete connectorDELETEPermanently delete a connector and stop all future syncs. This action is irreversible and removes all connector metadata.
get_connectorGet connectorGETRetrieve full details of a specific connector including its configuration, sync status, schedule, and schema metadata.
list_connectorsList connectorsGETList all connectors in the account with pagination support. Returns connector metadata including service type, status, sync frequency, and last sync timestamp.
modify_connectorModify connectorPATCHUpdate configuration, schedule, or sync settings for an existing connector. Only provided fields are updated; all others remain unchanged.
sync_connectorSync connectorPOSTTrigger an on-demand sync for a connector outside of its scheduled frequency. Optionally force a full re-sync of all historical data.

Destination, 6 operations

create_destinationCreate destinationPOSTCreate and configure a new destination warehouse where connector data will be loaded. The destination is associated with a group.
delete_destinationDelete destinationDELETEPermanently delete a destination configuration. Associated connectors must be deleted first before the destination can be removed.
get_destinationGet destinationGETRetrieve full configuration details of a specific destination including warehouse type, region, connection settings, and setup status.
list_destinationsList destinationsGETList all destinations (data warehouses) configured in the account with pagination support.
modify_destinationModify destinationPATCHUpdate region, time zone, or connection configuration for an existing destination. Only provided fields are changed.
test_destinationTest destinationPOSTRun a connection test against a destination warehouse to verify that Fivetran can successfully connect using the configured credentials.

Group, 5 operations

create_groupCreate groupPOSTCreate a new group to organize connectors that share the same destination warehouse. The group name must be unique within the account.
delete_groupDelete groupDELETEPermanently delete a group and all its associated connectors and destination configuration. This action is irreversible.
get_groupGet groupGETRetrieve details of a specific group including its name, creation timestamp, and associated destination service.
list_groupsList groupsGETList all groups in the account. A group represents a logical grouping of connectors sharing the same destination warehouse.
update_groupUpdate groupPATCHUpdate the display name of an existing group.

User, 3 operations

add_user_to_groupAdd user to groupPOSTGrant a user access to a specific group with a defined role. The user must already exist in the account.
get_userGet userGETRetrieve profile details and account role for a specific user.
list_usersList usersGETList all users in the Fivetran account with pagination support. Returns user profile information, roles, and account status.

Connector schema, 2 operations

get_connector_schemaGet connector schemaGETRetrieve the current schema configuration for a connector, including all synced schemas, tables, and columns with their enabled/disabled status.
modify_connector_schemaModify connector schemaPATCHUpdate schema settings for a connector including enabling/disabling schemas, tables, columns, and configuring schema change handling behavior.

Connector source metadata, 1 operation

get_connector_source_metadataGet connector source metadataGETGet source metadata for a connector including available schemas and tables. Returns the metadata structure that the connector exposes.

Group connector, 1 operation

list_group_connectorsList group connectorsGETList all connectors belonging to a specific group, with optional filtering by schema name or service type.

Group user, 1 operation

list_group_usersList group usersGETList all users who have access to a specific group, including their roles and permissions within the group.

Invite user, 1 operation

invite_userInvite userPOSTInvite a new user to the Fivetran account by email. The user will receive an invitation to set up their account and be assigned the specified role.

Resync connector table, 1 operation

resync_connector_tablesResync connector tablesPOSTTrigger a historical resync for specific tables within a connector. Useful for refreshing stale or corrupted table data without resyncing the entire connector.

Use Fivetran from Claude Code, Cursor or Codex

Connect Fivetran in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its Fivetran operations become tools the client can call, next to every other integration you connected.

Claude Code

claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"

Codex (~/.codex/config.toml)

[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"

[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"

Cursor, Claude Desktop and other JSON configs

{
  "mcpServers": {
    "livecontext": {
      "type": "http",
      "url": "https://livecontext.ai/mcp",
      "headers": {
        "X-API-Key": "YOUR_API_KEY"
      }
    }
  }
}

Set up the MCP server step by step

How to connect Fivetran

Create your workspace
Sign up free. Nothing to install.
Connect Fivetran once
Add your Fivetran connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.
Describe the job in chat
The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.

Fivetran integration FAQ

What can you do with the Fivetran integration?

LiveContext exposes 27 operations on Fivetran, covering connector, destination, group and user. Common uses include automate connector management, automate destination management and automate group management.