Fivetran MCP connector
Updated
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 and group access, including creating, updating, and deleting groups and their memberships. It also supports retrieving account details from API keys and managing hybrid deployment agents across your Fivetran instance.
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:
- Sync data automatically from multiple sources into your data warehouse
- Verify Fivetran credentials and account connectivity before running workflows
- Manage user access and group memberships across Fivetran destinations
- Configure and monitor hybrid deployment agents for on-premises connections
- Strengthen security by approving fingerprints and rotating authentication keys
- Track and revoke connection certificates to control data access
- Configure source tables and columns for accurate data syncing
- Trigger workflows automatically with webhooks tied to Fivetran group events
Example prompts
Use the following example prompts to invoke Fivetran MCP connector tools from your AI assistant or Boomi Connect workflow:
Show me every group in my Fivetran account.Add a new team member to a group in Fivetran.Check if my Fivetran credentials are working correctly.List all the hybrid deployment agents connected to Fivetran.Remove a user from my Fivetran account.Create a webhook so I get notified when a Fivetran sync finishes.Show me which fingerprints are approved for my Fivetran destination.Rotate the system key for my Fivetran account.What columns are enabled for this source table in Fivetran?Show me the certificate details for a Fivetran connection.
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 | Lists all groups (destinations) in your Fivetran account. |
| delete_user | Delete a User |
| get_user_memberships_in_groups | List All Group Memberships |
| add_user_membership_in_group | Add Group Membership |
| group_details | Retrieve Group Details |
| delete_group | Delete a Group |
| modify_group | Update a Group |
| get_account_info | Get Account Info from the API Key |
| get_hybrid_deployment_agent_list | List Hybrid Deployment Agents |
| create_hybrid_deployment_agent | Create a Hybrid Deployment Agent |
| get_team_memberships_in_groups | List All Group Memberships |
| add_team_membership_in_group | Add Group Membership |
| metadata_connectors | Retrieve Source Metadata |
| re_auth_hybrid_deployment_agent | Regenerate Authentication Keys |
| get_team_membership_in_group | Retrieve Group Membership Details |
| delete_team_membership_in_group | Delete Group Membership |
| update_team_membership_in_group | Update Group Membership |
| rotate_system_key | Rotate a System Key |
| get_connection_fingerprints_list | List Fingerprints Approved for the Connection |
| approve_connection_fingerprint | Approve a Fingerprint for the Connection |
| transformation_package_metadata_list | List All Quickstart Package Metadata |
| connection_column_config | Retrieve Source Table Columns Config |
| get_destination_fingerprints_list | List Fingerprints Approved for the Destination |
| approve_destination_fingerprint | Approve a Fingerprint for the Destination |
| modify_connection_table_config | Update a Connection Table Config |
| get_connection_certificate_details | Retrieve Connection Certificate Details |
| revoke_connection_certificate | Revoke Connection Certificate |
| create_group_webhook | Create a Group Webhook |
| get_team_membership_in_connection | Retrieve Connection Membership |
| delete_team_membership_in_connection | Delete Connection Membership |
| 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 |
