MCP Fivetran

MCP Fivetran

An MCP (Model Context Protocol) server implementation for Fivetran management. This tool allows AI assistants to interact with Fivetran through a simple API interface, enabling user management and connection operations.

Local Client Integration

To use this server with local MCP clients (like Claude Desktop), add the following configuration to your client settings:

Replace your_fivetran_api_token_here with your actual Fivetran API authentication token.

Description

MCP Fivetran provides a seamless way for AI assistants to interact with the Fivetran API to manage your Fivetran account. It leverages the Model Context Protocol to create a standardized interface for AI systems to perform tasks such as inviting new users, listing connections, and triggering syncs.

Requirements

• Python 3.12.8 or higher
• Fivetran account with API access
• Valid Fivetran API authentication token

Installation

Install the project and its dependencies using uv:

Configuration

Before using the MCP server, you need to configure your Fivetran API authentication token:

1. Obtain an API authentication token from your Fivetran account
2. Create a .env file in the project root (you can copy from env.example):
   cp env.example .env
3. Edit the .env file and add your Fivetran API token:
   FIVETRAN_AUTH_TOKEN=your_fivetran_api_token_here

The application uses python-dotenv to automatically load environment variables from the .env file.

Usage

Running the MCP Server

Start the MCP server by running:

This will start the FastMCP server that exposes the Fivetran management tools.

Using the Tools

The MCP server exposes the following tools:

1. invite_fivetran_user

Invites a new user to your Fivetran account.

Parameters:

• email (string): Email address of the user to invite
• given_name (string): First name of the user
• family_name (string): Last name of the user
• phone (string): Phone number of the user (including country code)

Example usage from an AI assistant:

2. list_connections

Lists all connection IDs in your Fivetran account.

Example usage:

3. sync_connection

Triggers a sync for a specific connection by ID.

Parameters:

• id (string): ID of the connection to sync

Example usage:

Example Prompts

Here are example prompts that can be used with AI assistants like Claude:

Development

To run the main script for testing:

Adding Dependencies

To add new dependencies:

Troubleshooting

Building the Package

If you encounter an error like this when building the package:

Update your pyproject.toml file to explicitly specify the modules:

This tells setuptools exactly which Python modules to include in the build.