How do I use Fivetran MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Fivetran MCP Server list all my connections" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

Fivetran MCP Server

Official

by fivetran

Overview Schema Related Servers Score Discussions

Python

Remote

Fivetran MCP Server

An MCP server that you can use to interact with your Fivetran environment. It allows you to ask read-only questions like "when was the last time my postgres connection completed a sync?" and "are any of my connection's broken?" Additionally, if you set FIVETRAN_ALLOW_WRITES to "true" you can complete write operations like "update the sync frequency of my Redshift connections to every 3 hours". The MCP will confirm with you before performing a write operation.

Enabling Additional Tools

Not all tools are enabled by default. To keep context usage manageable for AI clients with smaller context windows, tools for managing users, teams, roles, system keys, private links, proxy agents, HVR, and certificates/fingerprints are commented out in server.py. The tables in the Available Tools section below indicate which tools are enabled by default.

To enable additional tools, open server.py and uncomment the relevant tool definitions in the TOOLS dictionary. You can enable as many or as few as you need.

Related MCP server: datadog-mcp

Plugins

We have plugins that use this MCP server to make complicated tasks easier, compatible with Claude Code and Codex. Each plugin lives in its own repository with its own README.

copy-connections — Copy existing Fivetran connections to a new destination. Keep their configs and schemas intact or modify them as you like.

Regenerating API Schema Files

The open-api-definitions/ directory contains lightweight per-endpoint schema files used by the server. To regenerate them from an updated OpenAPI spec:

python split_openapi_by_endpoint.py fivetran-open-api-definition.json open-api-definitions

This will replace the existing schema files with freshly generated ones.

Setup

1. Choose how to run the server

You have two options. Most users should use uvx — no clone required.

Option A: Run with uvx (recommended)

Requires uv (which provides uvx) and Python 3.10+. uvx fetches and runs the server directly from this repository, so there is nothing to install or update manually.

The command your MCP client will run is:

uvx --from git+https://github.com/fivetran/fivetran-mcp fivetran-mcp

Note: bare uvx fivetran-mcp (without --from) does not work — the fivetran-mcp and mcp-fivetran names on PyPI are owned by unrelated projects, so you must install from the git URL.

Option B: Run from a local clone (for development)

Use this if you want to modify server.py or regenerate schema files.

git clone https://github.com/fivetran/fivetran-mcp
cd fivetran-mcp
python3 -m venv .venv
source .venv/bin/activate
pip install .

You can then point your MCP client at python /path/to/fivetran-mcp/server.py.

2. Get Fivetran API credentials

You can generate credentials within https://fivetran.com/dashboard/user/api-config

3. Connect to your AI client

Choose your preferred AI client below and follow the configuration instructions.

Claude Desktop

Open Claude Desktop and go to Settings → Developer → Edit Config
This opens claude_desktop_config.json. Add the Fivetran MCP server:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json

Using uvx (Option A):

{
  "mcpServers": {
    "fivetran": {
      "command": "uvx",
      "args": ["--from", "git+https://github.com/fivetran/fivetran-mcp", "fivetran-mcp"],
      "env": {
        "FIVETRAN_API_KEY": "your-api-key",
        "FIVETRAN_API_SECRET": "your-api-secret",
        "FIVETRAN_ALLOW_WRITES": "false"
      }
    }
  }
}

Using a local clone (Option B):

{
  "mcpServers": {
    "fivetran": {
      "command": "python",
      "args": ["/path/to/fivetran-mcp/server.py"],
      "env": {
        "FIVETRAN_API_KEY": "your-api-key",
        "FIVETRAN_API_SECRET": "your-api-secret",
        "FIVETRAN_ALLOW_WRITES": "false"
      }
    }
  }
}

Save the file and restart Claude Desktop
Look for the MCP server indicator in the bottom-right corner of the chat input

Claude Code (CLI)

Use the claude mcp add command to register the server.

Using uvx (Option A):

claude mcp add fivetran \
  --env FIVETRAN_API_KEY=your-api-key \
  --env FIVETRAN_API_SECRET=your-api-secret \
  --env FIVETRAN_ALLOW_WRITES=false \
  -- uvx --from git+https://github.com/fivetran/fivetran-mcp fivetran-mcp

Using a local clone (Option B):

claude mcp add fivetran \
  --env FIVETRAN_API_KEY=your-api-key \
  --env FIVETRAN_API_SECRET=your-api-secret \
  --env FIVETRAN_ALLOW_WRITES=false \
  -- python /path/to/fivetran-mcp/server.py

Or add it directly to your ~/.claude.json configuration:

{
  "mcpServers": {
    "fivetran": {
      "command": "uvx",
      "args": ["--from", "git+https://github.com/fivetran/fivetran-mcp", "fivetran-mcp"],
      "env": {
        "FIVETRAN_API_KEY": "your-api-key",
        "FIVETRAN_API_SECRET": "your-api-secret",
        "FIVETRAN_ALLOW_WRITES": "false"
      }
    }
  }
}

Verify the server is configured:

claude mcp list

OpenAI Codex

Codex stores MCP configuration in ~/.codex/config.toml. You can configure via CLI or by editing the file directly.

Option 1: CLI

Using uvx (Option A):

codex mcp add fivetran \
  --env FIVETRAN_API_KEY=your-api-key \
  --env FIVETRAN_API_SECRET=your-api-secret \
  --env FIVETRAN_ALLOW_WRITES=false \
  -- uvx --from git+https://github.com/fivetran/fivetran-mcp fivetran-mcp

Using a local clone (Option B):

codex mcp add fivetran \
  --env FIVETRAN_API_KEY=your-api-key \
  --env FIVETRAN_API_SECRET=your-api-secret \
  --env FIVETRAN_ALLOW_WRITES=false \
  -- python /path/to/fivetran-mcp/server.py

Option 2: Edit config.toml

Add the following to ~/.codex/config.toml. Using uvx (Option A):

[mcp_servers.fivetran]
command = "uvx"
args = ["--from", "git+https://github.com/fivetran/fivetran-mcp", "fivetran-mcp"]

[mcp_servers.fivetran.env]
FIVETRAN_API_KEY = "your-api-key"
FIVETRAN_API_SECRET = "your-api-secret"
FIVETRAN_ALLOW_WRITES = "false"

Using a local clone (Option B):

[mcp_servers.fivetran]
command = "python"
args = ["/path/to/fivetran-mcp/server.py"]

[mcp_servers.fivetran.env]
FIVETRAN_API_KEY = "your-api-key"
FIVETRAN_API_SECRET = "your-api-secret"
FIVETRAN_ALLOW_WRITES = "false"

Verify configuration:

codex mcp list

Cursor

Cursor supports both global and project-level MCP configurations.

Global Configuration: ~/.cursor/mcp.json
Project Configuration: .cursor/mcp.json (in your project root)

Add the following to your chosen configuration file.

Using uvx (Option A):

{
  "mcpServers": {
    "fivetran": {
      "command": "uvx",
      "args": ["--from", "git+https://github.com/fivetran/fivetran-mcp", "fivetran-mcp"],
      "env": {
        "FIVETRAN_API_KEY": "your-api-key",
        "FIVETRAN_API_SECRET": "your-api-secret",
        "FIVETRAN_ALLOW_WRITES": "false"
      }
    }
  }
}

Using a local clone (Option B):

{
  "mcpServers": {
    "fivetran": {
      "command": "python",
      "args": ["/path/to/fivetran-mcp/server.py"],
      "env": {
        "FIVETRAN_API_KEY": "your-api-key",
        "FIVETRAN_API_SECRET": "your-api-secret",
        "FIVETRAN_ALLOW_WRITES": "false"
      }
    }
  }
}

Alternative: Use Cursor's UI

Open Cursor and press Cmd/Ctrl + Shift + P
Search for "MCP" and select View: Open MCP Settings
Click Tools & Integrations → MCP Tools → Add Custom MCP
Add the configuration above

Restart Cursor to load the new MCP server configuration.

Environment Variables

Variable	Required	Default	Description
`FIVETRAN_API_KEY`	Yes	-	Your Fivetran API key
`FIVETRAN_API_SECRET`	Yes	-	Your Fivetran API secret
`FIVETRAN_ALLOW_WRITES`	No	`false`	Set to `true` to enable POST, PATCH, and DELETE operations

Available Tools

Account

Tool	Method	Description	Default
`get_account_info`	GET	Get account information associated with the API key	Yes

Certificates (Deprecated)

Tool	Method	Description	Default
`approve_certificate`	POST	(Deprecated) Approve a certificate for the account	No

Connections

Tool	Method	Description	Default
`list_connections`	GET	List all connections in your account	Yes
`create_connection`	POST	Create a new connection	Yes
`get_connection_details`	GET	Get connection status, last sync time, and config	Yes
`modify_connection`	PATCH	Update an existing connection	Yes
`delete_connection`	DELETE	Delete a connection	Yes
`get_connection_state`	GET	Get detailed sync state	Yes
`modify_connection_state`	PATCH	Update the sync state of a connection	Yes
`sync_connection`	POST	Trigger a data sync for a connection	Yes
`resync_connection`	POST	Trigger a historical re-sync for a connection	Yes
`resync_tables`	POST	Re-sync specific tables in a connection	Yes
`run_connection_setup_tests`	POST	Run setup tests for a connection	Yes
`create_connect_card`	POST	Create a connect card token for a connection	Yes
`get_connection_schema_config`	GET	Get schema/table sync configuration	Yes
`reload_connection_schema_config`	POST	Reload schema configuration from the source	Yes
`modify_connection_schema_config`	PATCH	Update schema configuration for a connection	Yes
`modify_connection_database_schema_config`	PATCH	Update configuration for a specific database schema	Yes
`get_connection_column_config`	GET	Get column configuration for a specific table	Yes
`modify_connection_table_config`	PATCH	Update configuration for a specific table	Yes
`modify_connection_column_config`	PATCH	Update configuration for a specific column	Yes
`delete_connection_column_config`	DELETE	Drop a blocked column from the destination	Yes
`delete_multiple_columns_connection_config`	POST	Drop multiple blocked columns from the destination	Yes
`list_connection_certificates`	GET	List certificates approved for a connection	No
`approve_connection_certificate`	POST	Approve a certificate for a connection	No
`get_connection_certificate_details`	GET	Get details of a specific certificate	No
`revoke_connection_certificate`	DELETE	Revoke a certificate for a connection	No
`list_connection_fingerprints`	GET	List fingerprints approved for a connection	No
`approve_connection_fingerprint`	POST	Approve a fingerprint for a connection	No
`get_connection_fingerprint_details`	GET	Get details of a specific fingerprint	No
`revoke_connection_fingerprint`	DELETE	Revoke a fingerprint for a connection	No

Destinations

Tool	Method	Description	Default
`list_destinations`	GET	List all data warehouse destinations	Yes
`create_destination`	POST	Create a new destination	Yes
`get_destination_details`	GET	Get destination configuration	Yes
`modify_destination`	PATCH	Update an existing destination	Yes
`delete_destination`	DELETE	Delete a destination	Yes
`run_destination_setup_tests`	POST	Run setup tests for a destination	Yes
`list_destination_certificates`	GET	List certificates approved for a destination	No
`approve_destination_certificate`	POST	Approve a certificate for a destination	No
`get_destination_certificate_details`	GET	Get details of a specific certificate	No
`revoke_destination_certificate`	DELETE	Revoke a certificate for a destination	No
`list_destination_fingerprints`	GET	List fingerprints approved for a destination	No
`approve_destination_fingerprint`	POST	Approve a fingerprint for a destination	No
`get_destination_fingerprint_details`	GET	Get details of a specific fingerprint	No
`revoke_destination_fingerprint`	DELETE	Revoke a fingerprint for a destination	No

External Logging

Tool	Method	Description	Default
`list_log_services`	GET	List all log services in your account	Yes
`create_log_service`	POST	Create a new log service	Yes
`get_log_service_details`	GET	Get details of a specific log service	Yes
`update_log_service`	PATCH	Update a log service	Yes
`delete_log_service`	DELETE	Delete a log service	Yes
`run_log_service_setup_tests`	POST	Run setup tests for a log service	Yes

Groups

Tool	Method	Description	Default
`list_groups`	GET	List all groups	Yes
`create_group`	POST	Create a new group	Yes
`get_group_details`	GET	Get group information	Yes
`modify_group`	PATCH	Update a group	Yes
`delete_group`	DELETE	Delete a group	Yes
`list_connections_in_group`	GET	List connections within a specific group	Yes
`list_users_in_group`	GET	List all users in a group	Yes
`add_user_to_group`	POST	Add a user to a group	Yes
`delete_user_from_group`	DELETE	Remove a user from a group	Yes
`get_group_ssh_public_key`	GET	Get the SSH public key for a group	Yes
`get_group_service_account`	GET	Get the service account for a group	Yes

HVR

Tool	Method	Description	Default
`hvr_register_hub`	POST	Register an HVR hub	No

Hybrid Deployment Agents

Tool	Method	Description	Default
`list_hybrid_deployment_agents`	GET	List all hybrid deployment agents	Yes
`create_hybrid_deployment_agent`	POST	Create a new hybrid deployment agent	Yes
`get_hybrid_deployment_agent`	GET	Get details of a hybrid deployment agent	Yes
`re_auth_hybrid_deployment_agent`	PATCH	Regenerate authentication keys	Yes
`reset_hybrid_deployment_agent_credentials`	POST	Reset credentials for an agent	Yes
`delete_hybrid_deployment_agent`	DELETE	Delete a hybrid deployment agent	Yes

Metadata

Tool	Method	Description	Default
`list_metadata_connectors`	GET	List all available connector types	Yes
`get_metadata_connector_config`	GET	Get configuration metadata for a connector type	Yes

Private Links

Tool	Method	Description	Default
`list_private_links`	GET	List all private links	No
`create_private_link`	POST	Create a new private link	No
`get_private_link_details`	GET	Get details of a private link	No
`modify_private_link`	PATCH	Update a private link	No
`delete_private_link`	DELETE	Delete a private link	No

Proxy Agents

Tool	Method	Description	Default
`list_proxy_agents`	GET	List all proxy agents	No
`create_proxy_agent`	POST	Create a new proxy agent	No
`get_proxy_agent_details`	GET	Get details of a proxy agent	No
`delete_proxy_agent`	DELETE	Delete a proxy agent	No
`list_proxy_agent_connections`	GET	List connections attached to a proxy agent	No
`regenerate_proxy_agent_secrets`	POST	Regenerate secrets for a proxy agent	No

Public Metadata

Tool	Method	Description	Default
`list_public_connectors`	GET	List available connector types (no auth required)	Yes

Roles

Tool	Method	Description	Default
`list_roles`	GET	List all available roles	No

System Keys

Tool	Method	Description	Default
`list_system_keys`	GET	List all system keys	No
`create_system_key`	POST	Create a new system key	No
`get_system_key_details`	GET	Get details of a system key	No
`update_system_key`	PATCH	Update a system key	No
`delete_system_key`	DELETE	Delete a system key	No
`rotate_system_key`	POST	Rotate a system key	No

Teams

Tool	Method	Description	Default
`list_teams`	GET	List all teams	No
`create_team`	POST	Create a new team	No
`get_team_details`	GET	Get details of a team	No
`modify_team`	PATCH	Update a team	No
`delete_team`	DELETE	Delete a team	No
`delete_team_membership_in_account`	DELETE	Delete a team's account-level role	No
`list_users_in_team`	GET	List all users in a team	No
`add_user_to_team`	POST	Add a user to a team	No
`get_user_in_team`	GET	Get a user's membership in a team	No
`update_user_membership_in_team`	PATCH	Update a user's membership in a team	No
`delete_user_from_team`	DELETE	Remove a user from a team	No
`list_team_memberships_in_groups`	GET	List a team's group memberships	No
`add_team_membership_in_group`	POST	Add a team to a group	No
`get_team_membership_in_group`	GET	Get a team's membership in a group	No
`update_team_membership_in_group`	PATCH	Update a team's membership in a group	No
`delete_team_membership_in_group`	DELETE	Remove a team from a group	No
`list_team_memberships_in_connections`	GET	List a team's connection memberships	No
`add_team_membership_in_connection`	POST	Add a team to a connection	No
`get_team_membership_in_connection`	GET	Get a team's membership in a connection	No
`update_team_membership_in_connection`	PATCH	Update a team's membership in a connection	No
`delete_team_membership_in_connection`	DELETE	Remove a team from a connection	No

Transformation Projects

Tool	Method	Description	Default
`list_transformation_projects`	GET	List all transformation projects	Yes
`create_transformation_project`	POST	Create a new transformation project	Yes
`get_transformation_project_details`	GET	Get details of a transformation project	Yes
`modify_transformation_project`	PATCH	Update a transformation project	Yes
`delete_transformation_project`	DELETE	Delete a transformation project	Yes
`test_transformation_project`	POST	Test a transformation project	Yes

Transformations

Tool	Method	Description	Default
`list_transformations`	GET	List all transformations	Yes
`create_transformation`	POST	Create a new transformation	Yes
`get_transformation_details`	GET	Get details of a transformation	Yes
`update_transformation`	PATCH	Update a transformation	Yes
`delete_transformation`	DELETE	Delete a transformation	Yes
`run_transformation`	POST	Run a transformation	Yes
`cancel_transformation`	POST	Cancel a running transformation	Yes
`upgrade_transformation_package`	POST	Upgrade a transformation's package version	Yes
`list_transformation_package_metadata`	GET	List all quickstart package metadata	Yes
`get_transformation_package_metadata_details`	GET	Get details of a quickstart package	Yes

Users

Tool	Method	Description	Default
`list_users`	GET	List all users in the account	No
`create_user`	POST	Create a new user	No
`get_user_details`	GET	Get details of a user	No
`modify_user`	PATCH	Update a user	No
`delete_user`	DELETE	Delete a user	No
`delete_user_membership_in_account`	DELETE	Delete a user's account-level role	No
`list_user_memberships_in_groups`	GET	List a user's group memberships	No
`add_user_membership_in_group`	POST	Add a user to a group with a role	No
`get_user_membership_in_group`	GET	Get a user's membership in a group	No
`update_user_membership_in_group`	PATCH	Update a user's membership in a group	No
`delete_user_membership_in_group`	DELETE	Remove a user from a group	No
`list_user_memberships_in_connections`	GET	List a user's connection memberships	No
`add_user_membership_in_connection`	POST	Add a user to a connection with a role	No
`get_user_membership_in_connection`	GET	Get a user's membership in a connection	No
`update_user_membership_in_connection`	PATCH	Update a user's membership in a connection	No
`delete_user_membership_in_connection`	DELETE	Remove a user from a connection	No

Webhooks

Tool	Method	Description	Default
`list_webhooks`	GET	List all webhooks in the account	Yes
`create_account_webhook`	POST	Create a webhook at the account level	Yes
`create_group_webhook`	POST	Create a webhook for a specific group	Yes
`get_webhook_details`	GET	Get details of a webhook	Yes
`modify_webhook`	PATCH	Update a webhook	Yes
`delete_webhook`	DELETE	Delete a webhook	Yes
`test_webhook`	POST	Test a webhook by sending a test event	Yes

Example Questions

"What connections are failing?"
"When did the Salesforce connection last sync?"
"Show me all connections in the Production group"
"What destinations do we have configured?"

This server cannot be installed

license - not found

quality - not tested

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly
Lightport: Open-Sourcing Glama's AI Gateway
By punkpeye on April 27, 2026.
OpenAI
open source

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