Skip to content

How Fivetran’s scores are calculated

The full audit trail, recomputed from the verdict data at build time through the same code that produced the leaderboard: verdict × quality × story weight per cell, cells sum to dimension scores, dimensions blend into the PA Score. Every number on the product page is reproducible from this page alone; for why the formula looks like this, see the methodology.

verdict factors: full ×1.0 · partial ×0.6 · disputed ×0.3 · none ×0.0 · n/a excluded from both sides · cell points = weight × quality × factor · cell max = weight × 10

PA Score30/100

Agent-ready 45.8 × 0.30 = 13.74

API quality 0.0 × 0.20 = 0.00

Openness 25.5 × 0.20 = 5.10

Built-in AI 39.1 × 0.15 = 5.87

Automation 34.0 × 0.15 = 5.10

(13.74 + 0.00 + 5.10 + 5.87 + 5.10) ÷ (0.30 + 0.20 + 0.20 + 0.15 + 0.15) = 29.80 ÷ 1.00 = 29.8

Scores are stored to 1 decimal; the product page’s pills round to whole numbers for display. Each dimension below shows the stories, verdicts, and cited evidence behind its number.

Agent-ready45.8/100×0.30 of the PA blend

Outside-in: can YOUR agent reach and drive this product — API, MCP, CLI, headless runs, agent docs.

Point an agent at llms.txt or agent-oriented docsweight 2

2 (weight) × 8 (quality) × 1.0 (full) = 16.0 of 20 max

  • [probe] https://fivetran.com/llms.txtPROBE llms.txt: HTTP 200 at https://fivetran.com/llms.txt # Fivetran Documentation > Fivetran is a fully managed data movement platform that automates data pipelines > from hund
  • [claimed-docs] https://fivetran.com/docs/connector-sdkWe provide AI coding agent plugins that add Connector SDK-specific skills to Claude Code, Codex CLI, Gemini CLI, and GitHub Copilot CLI. These skills let you build, test, and deploy connectors using natural language prompts.
  • [probe] https://fivetran.com/docs.mdPROBE docs-md: HTTP 404 at https://fivetran.com/docs.md

Run the product headlessly / in CI for automationweight 2

2 (weight) × 5 (quality) × 0.6 (partial) = 6.0 of 20 max

  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiSet up and scale your data pipeline, and manage your Fivetran account programmatically using the Fivetran REST API.
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiFivetran REST API
  • [claimed-docs] https://fivetran.com/docs/connector-sdkFivetran’s Connector SDK allows you to develop a custom data connector using Python and deploy it as an extension of Fivetran.
  • [claimed-docs] https://fivetran.com/docs/getting-started/fivetran-dashboard/account-settings/hybrid-deployment-agents.mdIn the **Hybrid Deployment Agents** tab of the Fivetran dashboard, you can create new agents and view or manage all existing Hybrid Deployment Agents associated with your account.
  • [claimed-docs] https://fivetran.com/docs/connector-sdkFollow our Connector SDK setup guide for custom connectors and visit our Connector SDK GitHub Repo to create a custom source connector and connect it with your destination using Fivetran.

Plug MCP servers into this product so it can use their toolsweight 3

3 (weight) × 0 (quality) × 0.0 (none) = 0.0 of 30 max

  • [probe] https://github.com/fivetran/fivetran-mcpofficial MCP server documented at https://github.com/fivetran/fivetran-mcp
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdIt allows you to ask read-only questions like "when was the last time my postgres connection completed a sync?" and "are any of my connections broken?"
  • [claimed-docs] https://fivetran.com/docs/connector-sdkWe provide AI coding agent plugins that add Connector SDK-specific skills to Claude Code, Codex CLI, Gemini CLI, and GitHub Copilot CLI. These skills let you build, test, and deploy connectors using natural language prompts.

Connect an agent via an official MCP serverweight 3

3 (weight) × 8 (quality) × 1.0 (full) = 24.0 of 30 max

  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdIt allows you to ask read-only questions like "when was the last time my postgres connection completed a sync?" and "are any of my connections broken?"
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdSet `FIVETRAN_SCOPE` to `read/write` or `read/write/delete` to unlock write and delete operations
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdCopy existing Fivetran connections to a new destination. Keep their configs and schemas intact or modify them as you like.
  • [probe] https://github.com/fivetran/fivetran-mcpofficial MCP server documented at https://github.com/fivetran/fivetran-mcp

Use an official CLIweight 2

2 (weight) × 0 (quality) × 0.0 (none) = 0.0 of 20 max

  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiSet up and scale your data pipeline, and manage your Fivetran account programmatically using the Fivetran REST API.
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiFivetran REST API
  • [claimed-docs] https://fivetran.com/docs/connector-sdkWe provide AI coding agent plugins that add Connector SDK-specific skills to Claude Code, Codex CLI, Gemini CLI, and GitHub Copilot CLI. These skills let you build, test, and deploy connectors using natural language prompts.
  • [probe] https://fivetran.com/openapi.jsonPROBE openapi: all candidate paths 404 (https://fivetran.com/openapi.json, https://fivetran.com/swagger.json, https://fivetran.com/api/openapi.json, https://fivetran.com/.well-known/openapi.json)

Drive the product through a documented public APIweight 3

3 (weight) × 7 (quality) × 1.0 (full) = 21.0 of 30 max

  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiSet up and scale your data pipeline, and manage your Fivetran account programmatically using the Fivetran REST API.
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiFivetran REST API
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-api/getting-startedConnect Cards
  • [claimed-docs] https://www.fivetran.com/pricingAccess to Fivetran REST API
  • [probe] https://fivetran.com/llms.txtPROBE llms.txt: HTTP 200 at https://fivetran.com/llms.txt # Fivetran Documentation > Fivetran is a fully managed data movement platform that automates data pipelines > from hund
  • [probe] https://fivetran.com/openapi.jsonPROBE openapi: all candidate paths 404 (https://fivetran.com/openapi.json, https://fivetran.com/swagger.json, https://fivetran.com/api/openapi.json, https://fivetran.com/.well-known/openapi.json)
  • [community] https://news.ycombinator.com/item?id=32395076Unrelated to the article itself but Fivetran has the worst possible product from a developer perspective, their APIs are unreliable and will fail on you randomly.

Issue scoped/least-privilege API credentials for an agentweight 2

2 (weight) × 6 (quality) × 0.6 (partial) = 7.2 of 20 max

  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdSet `FIVETRAN_SCOPE` to `read/write` or `read/write/delete` to unlock write and delete operations
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdIt allows you to ask read-only questions like "when was the last time my postgres connection completed a sync?" and "are any of my connections broken?"
  • [claimed-docs] https://www.fivetran.com/pricingRole-based access control
  • [probe] https://github.com/fivetran/fivetran-mcpofficial MCP server documented at https://github.com/fivetran/fivetran-mcp

Build against official SDKsweight 2

2 (weight) × 8 (quality) × 1.0 (full) = 16.0 of 20 max

  • [claimed-docs] https://fivetran.com/docs/connector-sdkFivetran’s Connector SDK allows you to develop a custom data connector using Python and deploy it as an extension of Fivetran.
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiFivetran REST API
  • [claimed-docs] https://fivetran.com/docs/connector-sdkFollow our Connector SDK setup guide for custom connectors and visit our Connector SDK GitHub Repo to create a custom source connector and connect it with your destination using Fivetran.
  • [claimed-docs] https://fivetran.com/docs/connector-sdkWe provide AI coding agent plugins that add Connector SDK-specific skills to Claude Code, Codex CLI, Gemini CLI, and GitHub Copilot CLI. These skills let you build, test, and deploy connectors using natural language prompts.
  • [claimed-docs] https://fivetran.com/docs/connector-sdkSee our video tutorial to learn how to build a Fivetran connector with Cursor AI.
  • [claimed-docs] https://fivetran.com/docs/connector-sdkBuild Custom Data Connectors with Python | Fivetran Connector SDK

Subscribe to events via webhooksweight 2

2 (weight) × 5 (quality) × 0.6 (partial) = 6.0 of 20 max

  • [claimed-docs] https://fivetran.com/docs/core-concepts/usage-based-pricing/tracking-and-optimizing-usage/webhooks.mdYou have total control over what is sent to your endpoint, so you can exclude source data by simply not generating unwanted records.
  • [claimed-docs] https://fivetran.com/docs/using-fivetran/fivetran-dashboard/alertsFivetran Alerts

Agent-ready = 96.2 ÷ 210 × 100 = 45.8

API quality0.0/100×0.20 of the PA blend

The programmable surface once an agent is there — machine-readable spec, interactive docs, sandbox, versioning discipline.

Explore an interactive API reference with runnable examplesweight 2

2 (weight) × 0 (quality) × 0.0 (none) = 0.0 of 20 max

  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiSet up and scale your data pipeline, and manage your Fivetran account programmatically using the Fivetran REST API.
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiFivetran REST API
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-api/getting-startedConnect Cards
  • [probe] https://fivetran.com/openapi.jsonPROBE openapi: all candidate paths 404 (https://fivetran.com/openapi.json, https://fivetran.com/swagger.json, https://fivetran.com/api/openapi.json, https://fivetran.com/.well-known/openapi.json)

Download a machine-readable API spec (OpenAPI or equivalent)weight 2

2 (weight) × 0 (quality) × 0.0 (none) = 0.0 of 20 max

  • [probe] https://fivetran.com/openapi.jsonPROBE openapi: all candidate paths 404 (https://fivetran.com/openapi.json, https://fivetran.com/swagger.json, https://fivetran.com/api/openapi.json, https://fivetran.com/.well-known/openapi.json)
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiFivetran REST API
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiSet up and scale your data pipeline, and manage your Fivetran account programmatically using the Fivetran REST API.

Test against a sandbox environment without touching production dataweight 1

1 (weight) × 0 (quality) × 0.0 (none) = 0.0 of 10 max

no evidence cited — the verdict rests on absence of evidence, re-checked on refresh

Rely on versioned APIs with a documented deprecation policyweight 2

2 (weight) × 0 (quality) × 0.0 (none) = 0.0 of 20 max

  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiFivetran REST API
  • [probe] https://fivetran.com/openapi.jsonPROBE openapi: all candidate paths 404 (https://fivetran.com/openapi.json, https://fivetran.com/swagger.json, https://fivetran.com/api/openapi.json, https://fivetran.com/.well-known/openapi.json)
  • [probe] https://fivetran.com/docs.mdPROBE docs-md: HTTP 404 at https://fivetran.com/docs.md

API quality = 0.0 ÷ 70 × 100 = 0.0

Openness25.5/100×0.20 of the PA blend

Can you leave, inspect, or self-host — data export, open source, portability.

Do everything through the API that I can do in the UIweight 2

2 (weight) × 5 (quality) × 0.6 (partial) = 6.0 of 20 max

  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiSet up and scale your data pipeline, and manage your Fivetran account programmatically using the Fivetran REST API.
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiFivetran REST API
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdIt allows you to ask read-only questions like "when was the last time my postgres connection completed a sync?" and "are any of my connections broken?"
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdSet `FIVETRAN_SCOPE` to `read/write` or `read/write/delete` to unlock write and delete operations
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdCopy existing Fivetran connections to a new destination. Keep their configs and schemas intact or modify them as you like.
  • [claimed-docs] https://fivetran.com/docs/getting-started/fivetran-dashboard/account-settings/connection-methods/proxy-agent.mdIn the **Proxy Agent** tab of the Fivetran dashboard, you can view all Proxy Agent connections associated with your account.
  • [claimed-docs] https://fivetran.com/docs/getting-started/fivetran-dashboard/account-settings/hybrid-deployment-agents.mdIn the **Hybrid Deployment Agents** tab of the Fivetran dashboard, you can create new agents and view or manage all existing Hybrid Deployment Agents associated with your account.
  • [claimed-docs] https://fivetran.com/docs/using-fivetran/fivetran-dashboard/alertsFivetran Alerts

Export all of my data in open formats and leaveweight 3

3 (weight) × 4 (quality) × 0.6 (partial) = 7.2 of 30 max

  • [claimed-docs] https://fivetran.com/docsAutomatically sync query‑ready, fully‑managed data to your data lake in open table formats.
  • [claimed-docs] https://www.fivetran.comSecurely move, manage, and transform data to power analytics, operations, and AI at scale.
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiSet up and scale your data pipeline, and manage your Fivetran account programmatically using the Fivetran REST API.
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiFivetran REST API

Read the product's source under an open licenseweight 2

n/a — not applicable to this product: excluded from numerator and denominator

no evidence cited — the verdict rests on absence of evidence, re-checked on refresh

Self-host the core productweight 3

3 (weight) × 4 (quality) × 0.6 (partial) = 7.2 of 30 max

  • [claimed-docs] https://fivetran.com/docs/core-concepts/deployment-modelsFivetran offers two deployment solutions to facilitate efficient data integration for various business environments.
  • [claimed-docs] https://fivetran.com/docs/core-concepts/deployment-modelsThese solutions include the following deployment models: SaaS Deployment... Hybrid Deployment
  • [claimed-docs] https://fivetran.com/docs/getting-started/fivetran-dashboard/account-settings/hybrid-deployment-agents.mdIn the **Hybrid Deployment Agents** tab of the Fivetran dashboard, you can create new agents and view or manage all existing Hybrid Deployment Agents associated with your account.
  • [claimed-docs] https://fivetran.com/docs/core-concepts/deployment-models/hybrid-deployment/agent-configuration-parameters.mdThese parameters enable you to customize the Hybrid Deployment Agent specifically for your environment.
  • [claimed-docs] https://fivetran.com/docs/core-concepts/deployment-models/hybrid-deployment/troubleshooting/multiple-agents-per-host.mda single agent can manage multiple connections at the same time.

Openness = 20.4 ÷ 80 × 100 = 25.5

Built-in AI39.1/100×0.15 of the PA blend

Inside-out: how agentic the product itself is for its users — built-in assistants, autonomous features.

Get AI-generated insights and suggestions from my data inside the productweight 2

2 (weight) × 0 (quality) × 0.0 (none) = 0.0 of 20 max

  • [claimed-docs] https://fivetran.com/docsCreate a unified context layer that enables your AI tools to answer questions more accurately.
  • [claimed-docs] https://fivetran.com/docs/getting-started/fivetran-dashboard/account-settings/troubleshooting/ai-support-assistant-faq.mdFor users on Free and Standard plans, it is the first point of contact before opening a support ticket.

Set up automations that run autonomously in the backgroundweight 2

2 (weight) × 7 (quality) × 1.0 (full) = 14.0 of 20 max

  • [claimed-docs] https://fivetran.com/docs/connectorsFivetran provides pre-built data connectors that automatically sync data from your applications, databases, event streams, and files to your data warehouse or data lake. Each connector handles schema changes, API updates, and incremental syncs automatically — no data pipelines to maintain.
  • [claimed-docs] https://fivetran.com/docs/connectorsEach connector handles schema changes, API updates, and incremental syncs automatically — no data pipelines to maintain.
  • [claimed-docs] https://fivetran.com/docs/connectorsFivetran provides pre-built data connectors that automatically sync data from your applications, databases, event streams, and files to your data warehouse or data lake.
  • [claimed-docs] https://fivetran.com/docs/transformationsTransformations are automatically executed after connection syncs or on a set schedule.
  • [community] https://news.ycombinator.com/item?id=43860108I've used Fivetran at VC funded startups... I understand the value of not having to build this piece of common infrastructure... we did experience regular (probably once every couple of months) issues with our ETL getting out of sync. We even had to do a full re-sync on a couple of occasions (which to their credit they did for no charge).

Delegate tasks to a built-in AI assistant inside the productweight 3

3 (weight) × 4 (quality) × 0.6 (partial) = 7.2 of 30 max

  • [claimed-docs] https://fivetran.com/docs/getting-started/fivetran-dashboard/account-settings/troubleshooting/ai-support-assistant-faq.mdFor users on Free and Standard plans, it is the first point of contact before opening a support ticket.

Operate the product with natural-language commandsweight 2

2 (weight) × 7 (quality) × 1.0 (full) = 14.0 of 20 max

  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdIt allows you to ask read-only questions like "when was the last time my postgres connection completed a sync?" and "are any of my connections broken?"
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdSet `FIVETRAN_SCOPE` to `read/write` or `read/write/delete` to unlock write and delete operations
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdCopy existing Fivetran connections to a new destination. Keep their configs and schemas intact or modify them as you like.
  • [claimed-docs] https://fivetran.com/docs/connector-sdkWe provide AI coding agent plugins that add Connector SDK-specific skills to Claude Code, Codex CLI, Gemini CLI, and GitHub Copilot CLI. These skills let you build, test, and deploy connectors using natural language prompts.
  • [probe] https://github.com/fivetran/fivetran-mcpofficial MCP server documented at https://github.com/fivetran/fivetran-mcp
  • [claimed-docs] https://fivetran.com/docs/getting-started/fivetran-dashboard/account-settings/troubleshooting/ai-support-assistant-faq.mdFor users on Free and Standard plans, it is the first point of contact before opening a support ticket.

Built-in AI = 35.2 ÷ 90 × 100 = 39.1

Automation34.0/100×0.15 of the PA blend

Depth of automation primitives — rules, scheduling, bulk operations, webhooks.

Perform bulk operations across many items at onceweight 2

2 (weight) × 5 (quality) × 0.6 (partial) = 6.0 of 20 max

  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdCopy existing Fivetran connections to a new destination. Keep their configs and schemas intact or modify them as you like.
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdCopy existing Fivetran connections to a new destination. Keep their configs and schemas intact or modif
  • [claimed-docs] https://fivetran.com/docs/core-concepts/deployment-models/hybrid-deployment/troubleshooting/multiple-agents-per-host.mda single agent can manage multiple connections at the same time.
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdSet `FIVETRAN_SCOPE` to `read/write` or `read/write/delete` to unlock write and delete operations
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiFivetran REST API
  • [probe] https://github.com/fivetran/fivetran-mcpofficial MCP server documented at https://github.com/fivetran/fivetran-mcp

Define rules that trigger actions automatically on eventsweight 3

3 (weight) × 4 (quality) × 0.6 (partial) = 7.2 of 30 max

  • [claimed-docs] https://fivetran.com/docs/using-fivetran/fivetran-dashboard/alertsFivetran Alerts
  • [claimed-docs] https://fivetran.com/docs/transformationsTransformations are automatically executed after connection syncs or on a set schedule.
  • [claimed-docs] https://fivetran.com/docs/core-concepts/usage-based-pricing/tracking-and-optimizing-usage/webhooks.mdYou have total control over what is sent to your endpoint, so you can exclude source data by simply not generating unwanted records.

Schedule recurring jobs or workflowsweight 2

2 (weight) × 7 (quality) × 1.0 (full) = 14.0 of 20 max

  • [claimed-docs] https://fivetran.com/docs/connectorsFivetran provides pre-built data connectors that automatically sync data from your applications, databases, event streams, and files to your data warehouse or data lake. Each connector handles schema changes, API updates, and incremental syncs automatically — no data pipelines to maintain.
  • [claimed-docs] https://fivetran.com/docs/transformationsOrchestrate pre-built and custom data transformations in your destination with Fivetran.
  • [claimed-docs] https://www.fivetran.com/pricing1-minute syncs
  • [claimed-docs] https://fivetran.com/docs/developer-resources/rest-apiSet up and scale your data pipeline, and manage your Fivetran account programmatically using the Fivetran REST API.
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdIt allows you to ask read-only questions like "when was the last time my postgres connection completed a sync?" and "are any of my connections broken?"
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdSet `FIVETRAN_SCOPE` to `read/write` or `read/write/delete` to unlock write and delete operations
  • [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.mdCopy existing Fivetran connections to a new destination. Keep their configs and schemas intact or modify them as you like.
  • [community] https://news.ycombinator.com/item?id=43860108I've used Fivetran at VC funded startups... I understand the value of not having to build this piece of common infrastructure... we did experience regular (probably once every couple of months) issues with our ETL getting out of sync. We even had to do a full re-sync on a couple of occasions (which to their credit they did for no charge).

Version, review, and roll back my automationsweight 1

1 (weight) × 0 (quality) × 0.0 (none) = 0.0 of 10 max

no evidence cited — the verdict rests on absence of evidence, re-checked on refresh

Automation = 27.2 ÷ 80 × 100 = 34.0