Used for loading environment variables from a .env file to configure the Fivetran API token
Required as the runtime environment for the MCP server (version 3.12.8 or higher)
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:
- Obtain an API authentication token from your Fivetran account
- Create a
.env
file in the project root (you can copy fromenv.example
): - Edit the
.env
file and add your Fivetran API token:
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 invitegiven_name
(string): First name of the userfamily_name
(string): Last name of the userphone
(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.
This server cannot be installed
A server implementation that enables AI assistants to interact with Fivetran's API, allowing for user management, connection listing, and triggering syncs.
Related MCP Servers
- -securityFlicense-qualityA server that enables AI assistants to interact with Linear's project management tools through the Model Context Protocol, supporting features like searching, creating, and updating issues, adding comments, and retrieving user profiles and team information.Last updated -TypeScript
- -securityAlicense-qualityThis server implementation allows AI assistants to interact with Asana's API, enabling users to manage tasks, projects, workspaces, and comments through natural language requests.Last updated -189TypeScriptMIT License
- -securityFlicense-qualityA powerful server that enables AI agents to interact with MySQL databases, execute SQL queries, and manage database content through a simple interface.Last updated -254JavaScript
- AsecurityFlicenseAqualityA server that provides easy access to Payman AI's APIs, allowing users to create payees, search payees, send payments, and check balances using natural language prompts.Last updated -53JavaScript