Fivetran MCP connector

Fivetran is a fully managed data movement platform that automates syncing data from sources into your data warehouse. The Fivetran MCP connector allows AI agents to manage user access and group memberships, retrieve account information, and configure hybrid deployment agents. It also supports listing and updating groups, deleting users, and monitoring data pipeline infrastructure across your Fivetran organization.

Authentication type

• API Key - Requires a static API key to be configured before the agent can connect to the service.

Uses

Use the Fivetran MCP connector to perform the following actions:

• Automate data syncing from your business applications to a centralized data warehouse
• Verify Fivetran connector credentials and account access before launching workflows
• Manage team access and group memberships across your Fivetran data pipelines
• Monitor and approve security fingerprints for source and destination connections
• Configure table-level settings and column mappings for incoming data sources
• Deploy hybrid agents to securely move data from restricted or on-premise systems
• Rotate authentication keys and certificates to maintain data pipeline security
• Track webhook events and group-level activities for audit and compliance requirements

Example prompts

Use the following example prompts to invoke Fivetran MCP connector tools from your AI assistant or Boomi Connect workflow:

• List all the groups in Fivetran so I can see our data warehouse destinations.
• Show me which team members have access to our Fivetran connectors.
• Add a new user to our Fivetran group for the analytics team.
• What source metadata is available for our Salesforce connector in Fivetran?
• Retrieve the table configuration details from our customer data source.
• Show me all approved security fingerprints for our destination connections.
• Create a new hybrid deployment agent for our on-premise data sources.
• List all the quickstart package templates available in Fivetran.
• Regenerate the authentication keys for our Fivetran API access.
• Show me the webhook events logged for our Fivetran group this week.

Fivetran MCP connector tools

The Fivetran MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

Tool	Description
fivetran_fivetranlistgroups_invoke	Retrieves a list of all groups in the account.
delete_user	Removes a user account from the system.
get_user_memberships_in_groups	Retrieves all group memberships for a specific user.
add_user_membership_in_group	Adds a user to a group.
group_details	Retrieves detailed information about a specific group.
delete_group	Removes a group from the system.
modify_group	Updates group settings and properties.
get_account_info	Retrieves account information associated with the API key.
get_hybrid_deployment_agent_list	Retrieves a list of all hybrid deployment agents.
create_hybrid_deployment_agent	Creates a new hybrid deployment agent.
get_team_memberships_in_groups	Retrieves all group memberships for a specific team.
add_team_membership_in_group	Adds a team to a group.
metadata_connectors	Retrieves metadata information for available source connectors.
re_auth_hybrid_deployment_agent	Regenerates authentication keys for a hybrid deployment agent.
get_team_membership_in_group	Retrieves details about a team's membership in a group.
delete_team_membership_in_group	Removes a team from a group.
update_team_membership_in_group	Updates a team's membership settings in a group.
rotate_system_key	Generates a new system key for enhanced security.
get_connection_fingerprints_list	Retrieves all approved fingerprints for a connection.
approve_connection_fingerprint	Approves a security fingerprint for a connection.
transformation_package_metadata_list	Retrieves metadata for all available transformation packages.
connection_column_config	Retrieves column configuration details for a source.
get_destination_fingerprints_list	Retrieves all approved fingerprints for a destination.
approve_destination_fingerprint	Approves a security fingerprint for a destination.
modify_connection_table_config	Updates table configuration settings for a connection.
get_connection_certificate_details	Retrieves certificate details for a connection.
revoke_connection_certificate	Removes an active certificate from a connection.
create_group_webhook	Creates a webhook for group events.
get_team_membership_in_connection	Retrieves team membership details for a connection.
delete_team_membership_in_connection	Removes team access to a connection.
update_team_membership_in_connection	Update Connection Membership.
delete_user_from_group	Remove a User from a Group.
connection_details	Retrieve Connection Details.
delete_connection	Delete a Connection.
modify_connection	Update a Connection.
test_transformation_project	Test Transformation Project.
list_all_connections_in_group	List All Connections within a Group.
delete_multiple_columns_connection_config	Drop Blocked Columns from the Destination.
get_destination_certificate_details	Retrieve Destination Certificate Details.
revoke_destination_certificate	Revoke Destination Certificate.
connection_schema_config	Retrieve a Connection Schema Config.
pre_create_connection_schema_config	Set Up a New Connection Schema Config.
modify_connection_schema_config	Update a Connection Schema Config.
get_destination_certificates_list	List Certificates Approved for the Destination.
approve_destination_certificate	Approve a Certificate for the Destination.
regenerate_secrets_proxy_agent	Regenerate Secrets for Proxy Agent.
list_connector_sdk_packages	List All Connector SDK Packages.
list_connections	List All Connections.
create_connection	Create a Connection.
list_all_webhooks	List all Webhooks.
approve_certificate	(Deprecated) Approve a Certificate.
group_ssh_public_key	Retrieve Group Public SSH Key.
transformation_package_metadata_details	Retrieve a Quickstart Package Metadata Details.
get_proxy_agent_connections	List All Connections Attached to the Proxy Agent.
list_all_groups	List All Destinations within Account.
create_group	Create a Group.
reset_hybrid_deployment_agent_credentials	Reset Agent Credentials.
run_setup_tests_log_service	Run Group Log Service Setup Tests.
delete_column_connection_config	Drop a Blocked Column From the Destination.
modify_connection_column_config	Update a Connection Column Config.
get_connection_fingerprint_details	Retrieve Connection Fingerprint Details.
revoke_connection_fingerprint	Revoke Connection Fingerprint.
get_private_link_details	Retrieve Private Link Details.
delete_private_link	Delete a Private Link.
modify_private_link	Update a Private Link.
get_system_keys	List All System Keys.
create_system_key	Create a System Key.
list_all_roles	List all roles.
metadata_public_connectors	Retrieve Source Metadata Public Endpoint.
get_connection_certificates_list	List Certificates Approved for the Connection.
approve_connection_certificate	Approve a Certificate for the Connection.
list_destinations	List All Destinations Within Account.
create_destination	Create a Destination.
get_user_memberships_in_connections	List All Connection Memberships.
add_user_membership_in_connection	Add a Connection Membership.
get_destination_fingerprint_details	Retrieve Destination Fingerprint Details.
revoke_destination_fingerprint	Revoke Destination Fingerprint.
sync_connection	Sync Connection Data.
modify_connection_database_schema_config	Update a Connection Database Schema Config.
get_system_key_details	Retrieve System Key Details.
delete_system_key	Delete a System Key.
update_system_key	Update a System Key.
resync_connection	Re-sync Connection Data (Historical Sync).
get_log_service_details	Retrieve Group Log Service Details.
delete_log_service	Delete a Group Log Service.
update_log_service	Update a Group Log Service.
list_all_transformation_projects	List all Transformation Projects.
create_transformation_project	Create Transformation Project.
get_user_in_team	Retrieve User Membership in a Team.
delete_user_from_team	Delete a User from a Team.
update_user_membership	Update a User Membership.
team_details	Retrieve Team Details.
delete_team	Delete a Team.
modify_team	Update a Team.
transformation_details	Retrieve Transformation Details.
delete_transformation	Delete a Transformation.
update_transformation	Update a Transformation.
create_account_webhook	Create an Account Webhook.
get_connector_sdk_package	Retrieve Connector SDK Package Details.
delete_connector_sdk_package	Delete Connector SDK Package.
get_account_log_service_details	Retrieve Account Log Service.
add_account_log_service	Create Account Log Service.
delete_account_log_service	Delete Account Log Service.
update_account_log_service	Update Account Log Service.
upgrade_transformation_package	Upgrade Transformation Package.
get_proxy_agent_details	Retrieve Proxy Agent Details.
delete_proxy_agent	Delete a Proxy Agent.
connect_card	Create a Connect Card.
list_all_users_in_group	List All Users within a Group.
add_user_to_group	Add a User to a Group.
user_details	Retrieve a User Details.
modify_user	Update a User.
list_all_teams	List All Teams.
create_team	Create a Team.
list_log_services	List All Log Services within Account.
add_log_service	Create a Group Log Service.
connection_state	Retrieve Connection State.
modify_connection_state	Update a Connection State.
list_all_users	List All Users.
create_user	Invite a User.
delete_user_membership_in_account	Delete Account Role.
download_connector_sdk_package	Download Connector SDK Package.
test_webhook	Test a Webhook.
run_transformation	Run Transformation.
get_team_memberships_in_connections	List All Connection Memberships.
add_team_membership_in_connection	Add Connection Membership.
resync_tables	Re-sync Connection Table Data.
reload_connection_schema_config	Reload a Connection Schema Config.
transformations_list	List all Transformations.
create_transformation	Create a Transformation.
hvr_register_hub	Register Hub.
cancel_transformation	Cancel Running Transformation.
transformation_project_details	Retrieve Transformation Project Details.
delete_transformation_project	Delete Transformation Project.
modify_transformation_project	Update Transformation Project.
group_service_account	Retrieve Group Service Account.
webhook_details	Retrieve Webhook Details.
delete_webhook	Delete a Webhook.
modify_webhook	Update a Webhook.
get_user_membership_in_group	Retrieve Group Membership Details.
delete_user_membership_in_group	Delete Group Membership.
update_user_membership_in_group	Update Group Membership.
run_setup_tests	Run Connection Setup Tests.
get_hybrid_deployment_agent	Returns Hybrid Deployment Agent Details.
delete_hybrid_deployment_agent	Delete a Hybrid Deployment Agent.
get_proxy_agent	List all Proxy Agents.
create_proxy_agent	Create a Proxy Agent.
run_destination_setup_tests	Run Destination Setup Tests.
get_private_links	List All Private Links.
create_private_link	Create a Private Link.
list_users_in_team	List All User Memberships.
add_user_to_team	Add a User to the Team.
get_user_membership_in_connections	Retrieve Connection Membership.
delete_user_membership_in_connection	Delete Connection Membership.
update_user_membership_in_connection	Update Connection Membership.
destination_details	Retrieve Destination Details.
delete_destination	Delete a Destination.
modify_destination	Update a Destination.
metadata_connector_config	Retrieve Connector Configuration Metadata.
delete_team_membership_in_account	Delete Team from Account.