Fivetran MCP Server
OfficialServer Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| FIVETRAN_API_KEY | Yes | Your Fivetran API key | |
| FIVETRAN_API_SECRET | Yes | Your Fivetran API secret | |
| FIVETRAN_ALLOW_WRITES | No | Set to 'true' to enable POST, PATCH, and DELETE operations | false |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| get_account_infoB | Returns information about current account from API key. |
| list_connectionsA | ⚠️ RESULTS ARE PAGINATED. Returns a list of all accessible connections within your Fivetran account. |
| create_connectionA | ⚠️ WRITE OPERATION - Confirm with user before calling. Creates a new connection within a specified group in your Fivetran account. Runs setup tests and returns testing results. > IMPORTANT: The |
| connection_detailsC | Returns a connection configuration and status details if a valid identifier was provided. |
| modify_connectionA | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates connection parameters for an existing connection within your Fivetran account. This endpoint requires at least one persistent configuration parameter to be specified (e.g., |
| delete_connectionA | ⚠️ DESTRUCTIVE - Confirm with user before calling. Deletes a connection from your Fivetran account. |
| connect_cardB | ⚠️ WRITE OPERATION - Confirm with user before calling. Generates the Connect Card URI for the connection |
| resync_connectionA | ⚠️ WRITE OPERATION - Confirm with user before calling. Triggers a full historical sync of a connection or multiple schema tables within a connection. If the connection is paused, the table sync will be scheduled to be performed when the connection is re-enabled. If there is a data sync already in progress, we will try to complete it. If it fails, the request will be declined and the HTTP 409 Conflict error will be returned. |
| connection_schema_configA | ⚠️ IMPORTANT - If a table's parent schema is not enabled, the table will not be replicated. Check before telling the table the column is enabled. Returns the top-level schema configuration for an existing connection within your Fivetran account. The response includes global flags, every schema, each table, and only the columns that were explicitly overridden. Use this endpoint to read the current data-selection tree for a connection, to back up the schema before making edits, or to copy the configuration to another connection. > NOTE: To restore a backed-up schema or copy the configuration to another connection, use the Update a Connection Schema Config endpoint. For more information, see the Connection Schema config tutorial. > NOTE: Unedited columns (those following table defaults) are omitted from the response. For a real-time, exhaustive column list for a specific table, call the Retrieve Source Table Columns Config endpoint. For the NetSuite SuiteAnalytics, and Salesforce and Salesforce Sandbox connectors, the 'schemas' map field contains a single entry with the 'netsuite' or 'salesforce' key, respectively. For the 'schema.name_in_destination` name field, these connectors always return the destination schema name you set in the connection setup form. For more information on using this API endpoint with the the Oracle Fusion Cloud Applications connectors, see the Schema information documentation. > IMPORTANT: This endpoint does not apply to Magic Folder connectors. |
| modify_connection_schema_configA | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates the schema config for an existing connection within your Fivetran account. > NOTE: For backward compatibility, the response may contain the 'enable_new_by_default' boolean field. It defines whether new schemas and tables discovered in the source are synced. The value is 'true' if you specify 'ALLOW_ALL' as a value of 'schema_change_handling'. In the future API versions, we may remove this field. > > The response contains all known schemas and tables. Also, it contains columns whose state has ever been set by the user. For more information, see also the Connection Schema config tutorial. |
| delete_multiple_columns_connection_configA | ⚠️ WRITE OPERATION - Confirm with user before calling. Mark multiple blocked columns for deletion from your destination tables. The columns will be dropped during the next sync. |
| reload_connection_schema_configA | ⚠️ WRITE OPERATION - Confirm with user before calling. Reloads the connection schema config for an existing connection within your Fivetran account. > NOTE: This method reloads the full schema from the connection's data source. It may take a long time to complete the request. The method execution speed depends on the schema size and the number of databases, tables, and columns. > > The response contains all known schemas and tables. Also, it contains columns whose state has ever been set by the user. For more information, see also the Connection Schema config tutorial. |
| resync_tablesB | ⚠️ WRITE OPERATION - Confirm with user before calling. Triggers a historical sync of all data for multiple schema tables within a connection. This action does not override the standard sync frequency you defined in the Fivetran dashboard. |
| modify_connection_database_schema_configA | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates the database schema config for an existing connection within your Fivetran account (for a single schema within a connection with multiple schemas). > NOTE: The response contains all known schemas and tables. Also, it contains columns whose state has ever been set by the user. For more information, see also the Connection Schema config tutorial. In this API call, the NetSuite SuiteAnalytics, Salesforce and Salesforce Sandbox connectors always return the schema name as 'netsuite' and 'salesforce', respectively. For more information about this API call for the Oracle Fusion Cloud Applications connectors, see our Schema information documentation. |
| modify_connection_table_configA | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates the table config within your database schema for an existing connection within your Fivetran account. For the NetSuite SuiteAnalytics and Salesforce and Salesforce Sandbox connectors, the 'schemas' map field will always have a single entry with the 'netsuite' or 'salesforce' key, respectively. |
| modify_connection_column_configA | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates the column config within your table for an existing connection within your Fivetran account. For the NetSuite SuiteAnalytics and Salesforce and Salesforce Sandbox connectors, the 'schemas' map field will always have a single entry with the 'netsuite' or 'salesforce' key, respectively. > NOTE: The response contains all known schemas and tables. Also, it contains columns whose state has ever been set by the user. For more information, see also the Connection Schema config tutorial. |
| delete_column_connection_configA | ⚠️ DESTRUCTIVE - Confirm with user before calling. Marks a blocked column for deletion from your destination table. The column will be dropped during the next sync. For the NetSuite SuiteAnalytics and Salesforce and Salesforce Sandbox connectors, the 'schemas' map field will always have a single entry with the 'netsuite' or 'salesforce' key, respectively. |
| connection_column_configA | ⚠️ IMPORTANT - If a column's parent table or schema is not enabled, the column's data will not be replicated. Check before telling the user the column is enabled. Returns the real-time column list for one source table by querying the source. The response includes the current enabled and hashed flags, and the patchable fields. > NOTE: This endpoint works only for an existing connection that is in a 'Connected' state. |
| connection_stateA | Returns the connection state. This endpoint is only supported for Function and Connection SDK connectors. To update the connection state, use Update Connection State. |
| modify_connection_stateA | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates the connection state. To update the state, you should pause your connection first. To update the connection state, do the following: 1. Pause connection using Update a Connection endpoint (set 'paused' to 'true'). 2. Update the state by using the Update Connection State endpoint. 3. Unpause the connection by setting the 'paused' parameter to 'false' in the Update a Connection endpoint request. This endpoint is only supported for Function and Connection SDK connectors. |
| sync_connectionA | ⚠️ WRITE OPERATION - Confirm with user before calling. Triggers a data sync for an existing connection within your Fivetran account without waiting for the next scheduled sync. This action does not override the standard sync frequency you defined in the Fivetran dashboard. When |
| run_setup_testsC | ⚠️ WRITE OPERATION - Confirm with user before calling. Runs the setup tests for an existing connection within your Fivetran account. Use this parameter to test the connection without making any configuration changes. You can optionally include |
| list_destinationsA | ⚠️ RESULTS ARE PAGINATED. Returns a list of all accessible destinations within your Fivetran account. |
| create_destinationA | ⚠️ WRITE OPERATION - Confirm with user before calling. Creates a new destination within a specified group in your Fivetran account. > IMPORTANT: Groups and destinations are mapped 1:1 to each other. We do this mapping using the group's |
| destination_detailsB | Returns a destination object if a valid identifier was provided. To find a destination's unique identifier, call the List All Groups endpoint and search the response |
| modify_destinationA | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates information for an existing destination within your Fivetran account. |
| delete_destinationA | ⚠️ DESTRUCTIVE - Confirm with user before calling. Deletes a destination from your Fivetran account. |
| run_destination_setup_testsA | ⚠️ WRITE OPERATION - Confirm with user before calling. Runs the setup tests for an existing destination within your Fivetran account. |
| list_log_servicesA | ⚠️ RESULTS ARE PAGINATED. Returns a list of all accessible logging services within your Fivetran account. |
| add_log_serviceA | ⚠️ WRITE OPERATION - Confirm with user before calling. Creates a new group-level logging service within a specified group in your Fivetran account. |
| get_log_service_detailsB | Returns a group-level logging service object if a valid identifier was provided. |
| update_log_serviceA | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates information for an existing group-level logging service within your Fivetran account. |
| delete_log_serviceA | ⚠️ DESTRUCTIVE - Confirm with user before calling. Deletes a group-level logging service from your Fivetran account. |
| run_setup_tests_log_serviceA | ⚠️ WRITE OPERATION - Confirm with user before calling. Runs the setup tests for an existing group-level logging service within your Fivetran account. |
| list_all_groupsA | ⚠️ RESULTS ARE PAGINATED. Returns a list of all groups within your Fivetran account. |
| create_groupA | ⚠️ WRITE OPERATION - Confirm with user before calling. Creates a new group in your Fivetran account. > IMPORTANT: Groups and destinations are mapped 1:1 to each other. We do this mapping using the group's |
| group_detailsC | Returns a group object if a valid identifier was provided. |
| modify_groupA | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates information for an existing group within your Fivetran account. |
| delete_groupB | ⚠️ DESTRUCTIVE - Confirm with user before calling. Deletes a group from your Fivetran account. |
| list_all_connections_in_groupB | ⚠️ RESULTS ARE PAGINATED. Returns a list of information about all connections within a group in your Fivetran account. |
| group_ssh_public_keyA | Returns public key from SSH key pair associated with the group. |
| group_service_accountA | Returns Fivetran service account associated with the group. |
| list_all_users_in_groupC | ⚠️ RESULTS ARE PAGINATED. Returns a list of information about all users within a group in your Fivetran account. |
| add_user_to_groupA | ⚠️ WRITE OPERATION - Confirm with user before calling. Adds an existing user to a group in your Fivetran account. |
| delete_user_from_groupB | ⚠️ DESTRUCTIVE - Confirm with user before calling. Removes an existing user from a group in your Fivetran account. |
| get_hybrid_deployment_agent_listB | ⚠️ RESULTS ARE PAGINATED. Returns list of all Hybrid Deployment Agents within your Fivetran account, along with usage. Optionally filtered to a single group. |
| create_hybrid_deployment_agentA | ⚠️ WRITE OPERATION - Confirm with user before calling. Creates a new Hybrid Deployment Agent in a group. |
| get_hybrid_deployment_agentC | Returns Hybrid Deployment Agent Details. |
| delete_hybrid_deployment_agentA | ⚠️ DESTRUCTIVE - Confirm with user before calling. Delete a Hybrid Deployment Agent. |
| re_auth_hybrid_deployment_agentA | ⚠️ WRITE OPERATION - Confirm with user before calling. Regenerate authentication for a Hybrid Deployment Agent. |
| reset_hybrid_deployment_agent_credentialsA | ⚠️ WRITE OPERATION - Confirm with user before calling. Reset credentials for a Hybrid Deployment Agent. |
| metadata_connectorsA | ⚠️ RESULTS ARE PAGINATED. Returns all available source types within your Fivetran account. This endpoint makes it easier to display Fivetran connectors within your application because it provides metadata including the proper source name ('Facebook Ads' instead of 'facebook_ads'), the source icon, information about the Hybrid deployment support, and links to Fivetran resources. As we update source names and icons, that metadata will automatically update within this endpoint |
| metadata_connector_configC | Returns metadata of configuration parameters and authorization parameters for a specified connector type. |
| list_all_transformation_projectsB | ⚠️ RESULTS ARE PAGINATED. Returns a list of all transformation projects available via API within your Fivetran account. |
| create_transformation_projectA | ⚠️ WRITE OPERATION - Confirm with user before calling. Creates a new transformation project. |
| transformation_project_detailsB | Returns transformation project details if a valid identifier was provided. |
| modify_transformation_projectB | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates transformation project if a valid identifier was provided. |
| delete_transformation_projectA | ⚠️ DESTRUCTIVE - Confirm with user before calling. Deletes transformation project if a valid identifier was provided. |
| test_transformation_projectC | ⚠️ WRITE OPERATION - Confirm with user before calling. Triggers tests for an existing transformation project. |
| transformations_listA | ⚠️ RESULTS ARE PAGINATED. Returns a list of all transformations within your Fivetran account. |
| create_transformationB | ⚠️ WRITE OPERATION - Confirm with user before calling. Creates a new transformation. |
| transformation_package_metadata_listB | ⚠️ RESULTS ARE PAGINATED. Returns a list of available Quickstart transformation package metadata details. |
| transformation_package_metadata_detailsC | Returns the metadata details of the Quickstart transformation package if a valid identifier is provided. |
| transformation_detailsC | Returns a transformation details if a valid identifier is provided. |
| update_transformationA | ⚠️ WRITE OPERATION - Confirm with user before calling. Updates the transformation if a valid identifier is provided. |
| delete_transformationA | ⚠️ DESTRUCTIVE - Confirm with user before calling. Deletes a transformation if a valid identifier is provided. |
| cancel_transformationC | ⚠️ WRITE OPERATION - Confirm with user before calling. Cancels the execution of the transformation if a valid identifier is provided. |
| run_transformationA | ⚠️ WRITE OPERATION - Confirm with user before calling. Runs the transformation if a valid identifier is provided. |
| upgrade_transformation_packageA | ⚠️ WRITE OPERATION - Confirm with user before calling. Upgrades the Quickstart transformation package to latest version if a valid identifier is provided. |
| list_all_webhooksB | ⚠️ RESULTS ARE PAGINATED. The endpoint allows you to retrieve the list of existing webhooks available for the current account |
| create_account_webhookA | ⚠️ WRITE OPERATION - Confirm with user before calling. This endpoint allows you to create a new webhook for the current account. |
| create_group_webhookA | ⚠️ WRITE OPERATION - Confirm with user before calling. This endpoint allows you to create a new webhook for a given group |
| webhook_detailsC | This endpoint allows you to retrieve details of the existing webhook for a given identifier |
| modify_webhookA | ⚠️ WRITE OPERATION - Confirm with user before calling. The endpoint allows you to update the existing webhook with a given identifier |
| delete_webhookA | ⚠️ DESTRUCTIVE - Confirm with user before calling. This endpoint allows you to delete an existing webhook with a given identifier |
| test_webhookA | ⚠️ WRITE OPERATION - Confirm with user before calling. The endpoint allows you to test an existing webhook. It sends a webhook with a given identifier for a dummy connection with identifier _connection_1 |
| metadata_public_connectorsC | Returns all available source types. This endpoint provides metadata including the proper source name (‘Facebook Ads’ instead of facebook_ads), the source icon, feature tables, information about the Hybrid deployment support, information about the Authorization via API support, and links to Fivetran resources. As we update source names and icons, that metadata will automatically update within this endpoint. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/fivetran/fivetran-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server