Fivetran MCP

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/yimingyan-fivetran-mcp

About

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list and install config. Checked Oct 25, 2026.

Tools

8 read · 3 write · 0 delete · 4 not yet classified

Secrets

2 (API keys, tokens or passwords)

Install scripts

Not scanned yet

Runs as

Python package

Tools (15)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

• get_connection_schema

  Retrieve schema information for a Fivetran connection with optional table filter. When called without a table parameter, returns all schemas and tables. When a table is specified (format: "schema.table_name"), returns detailed information for that specific table including all column metadata. This is useful for: - Debugging dbt model failures when columns are missing - Detecting schema changes - Building new models with accurate column metadata - Identifying which columns are actively synced vs excluded Args: connection_id: The unique identifier of the connection table: Optional tab…

• get_connection_status

  Get detailed status for a specific Fivetran connection. Returns comprehensive information including sync state, tasks with full details, warnings, and scheduling configuration. Use this for investigating connection issues and understanding sync status. Args: connection_id: The unique identifier of the connection Returns: Dictionary containing connection details, sync status, tasks, and warnings with full details for troubleshooting

• get_schema

  Retrieve the complete schema configuration for a Fivetran connection. Returns all schemas and tables with their enabled/disabled status, sync modes, and configuration. Useful for understanding what data is being synced and investigating missing tables. Args: connection_id: The unique identifier of the connection Returns: Dictionary containing schema configuration with all tables and their status

• get_table_columns

  Retrieve column details for a specific table in a Fivetran connection. Returns column names, sync configuration, and metadata. Useful for investigating schema issues or understanding table structure. Note: Column data types are not available via the Fivetran API. Data types can be queried directly from your destination database. Args: connection_id: The unique identifier of the connection schema: The schema name containing the table table: The table name to get columns for Returns: Dictionary containing column details including names, enabled status, primary key info, a…

• get_table_status

  Get per-table sync status for a Fivetran connection. Returns detailed status for each table including enabled/disabled state, sync configuration, and metadata from the most recent successful sync. Useful for debugging large connectors with many tables, identifying stale tables, and monitoring data freshness. For connectors with many tables (e.g., Airtable with 20+ bases, or Postgres with 50+ tables), this provides visibility into which specific tables are configured and their sync settings. Note: Table metadata (like destination names) is only available after at least one successful sync ha…

• list_connections

  List all Fivetran connections in the account. Args: limit: Maximum number of connections to return (1-1000, default 100) group_id: Optional group ID to filter connections by group Returns: Dictionary containing list of connections with their IDs, names, status, and sync state

• list_groups

  List all Fivetran groups (destinations) in the account. Groups represent destinations where data is synced to. Args: limit: Maximum number of groups to return (1-1000, default 100) Returns: Dictionary containing list of groups with their IDs and names

• list_tables

  List all tables in a Fivetran connection with their sync status. Provides a flattened view of all tables across all schemas, showing enabled status, sync mode, and configuration. Useful for quickly seeing which tables are being synced. Args: connection_id: The unique identifier of the connection Returns: Dictionary containing a flat list of all tables with their status

• pause_connection

  Pause a Fivetran connection. Paused connections will not sync data until resumed. Args: connection_id: The unique identifier of the connection Returns: Dictionary with updated connection status

• reload_schema

  Reload the schema configuration from the source for a Fivetran connection. Fetches the latest schema from the data source and updates the configuration. Useful after source schema changes to detect new tables or columns. Args: connection_id: The unique identifier of the connection Returns: Dictionary confirming the schema reload was triggered

• resume_connection

  Resume a paused Fivetran connection. The connection will start syncing according to its schedule. Args: connection_id: The unique identifier of the connection Returns: Dictionary with updated connection status

• resync_tables

  Trigger a historical resync for specific tables within a connection. This re-syncs historical data only for the specified tables, not the entire connection. Useful when you need to refresh specific tables without a full resync. Args: connection_id: The unique identifier of the connection tables: List of table names to resync (e.g., ["schema.table_name", "public.users"]) Returns: Dictionary with resync trigger confirmation

• test_connection

  Test a Fivetran connection to diagnose connectivity and configuration issues. Executes diagnostic tests to identify root causes when syncs fail, validate connection health proactively, and support incident response workflows. Args: connection_id: The unique identifier of the connection to test Returns: Dictionary containing test results with overall pass/fail status, counts of passed/failed tests, and detailed information for each test

• trigger_resync

  Trigger a full historical resync for a Fivetran connection. This re-syncs all historical data from the source. Use with caution as it may take significant time and resources. Args: connection_id: The unique identifier of the connection Returns: Dictionary with resync trigger confirmation

• trigger_sync

  Trigger a data sync for a Fivetran connection. This starts a sync without waiting for the next scheduled sync time. Does not override the standard sync frequency. Args: connection_id: The unique identifier of the connection force: If True, force the sync even if one is already in progress Returns: Dictionary with sync trigger confirmation

Compare and alternatives

Featured in

• Best MCP servers for data engineering

Signals

Stars

2

Forks

0

Open issues

0

Weekly downloads

292

Last commit

Feb 1, 2026 (8 months ago)

Last release

Feb 1, 2026 (8 months ago)

Last package publish

Feb 1, 2026 (8 months ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name

io.github.YimingYAN/fivetran-mcp

Version

0.3.1

Auth

API key

Packages

pypi fivetran-mcp

License

MIT

Repository

github.com/YimingYAN/fivetran-mcp

First seen

Oct 24, 2026

Last checked

Oct 24, 2026

Source

Official MCP Registrygithub-graphql