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.txt“PROBE 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-sdk“We 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.md“PROBE 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-api“Set 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-api“Fivetran REST API”
- [claimed-docs] https://fivetran.com/docs/connector-sdk“Fivetran’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.md“In 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-sdk“Follow 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-mcp“official MCP server documented at https://github.com/fivetran/fivetran-mcp”
- [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.md“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 connections broken?"”
- [claimed-docs] https://fivetran.com/docs/connector-sdk“We 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.md“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 connections broken?"”
- [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.md“Set `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.md“Copy 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-mcp“official 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-api“Set 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-api“Fivetran REST API”
- [claimed-docs] https://fivetran.com/docs/connector-sdk“We 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.json“PROBE 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-api“Set 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-api“Fivetran REST API”
- [claimed-docs] https://fivetran.com/docs/developer-resources/rest-api/getting-started“Connect Cards”
- [claimed-docs] https://www.fivetran.com/pricing“Access to Fivetran REST API”
- [probe] https://fivetran.com/llms.txt“PROBE 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.json“PROBE 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=32395076“Unrelated 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.md“Set `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.md“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 connections broken?"”
- [claimed-docs] https://www.fivetran.com/pricing“Role-based access control”
- [probe] https://github.com/fivetran/fivetran-mcp“official 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-sdk“Fivetran’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-api“Fivetran REST API”
- [claimed-docs] https://fivetran.com/docs/connector-sdk“Follow 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-sdk“We 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-sdk“See our video tutorial to learn how to build a Fivetran connector with Cursor AI.”
- [claimed-docs] https://fivetran.com/docs/connector-sdk“Build 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.md“You 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/alerts“Fivetran 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-api“Set 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-api“Fivetran REST API”
- [claimed-docs] https://fivetran.com/docs/developer-resources/rest-api/getting-started“Connect Cards”
- [probe] https://fivetran.com/openapi.json“PROBE 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.json“PROBE 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-api“Fivetran REST API”
- [claimed-docs] https://fivetran.com/docs/developer-resources/rest-api“Set 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-api“Fivetran REST API”
- [probe] https://fivetran.com/openapi.json“PROBE 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.md“PROBE 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-api“Set 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-api“Fivetran REST API”
- [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.md“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 connections broken?"”
- [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.md“Set `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.md“Copy 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.md“In 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.md“In 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/alerts“Fivetran 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/docs“Automatically sync query‑ready, fully‑managed data to your data lake in open table formats.”
- [claimed-docs] https://www.fivetran.com“Securely move, manage, and transform data to power analytics, operations, and AI at scale.”
- [claimed-docs] https://fivetran.com/docs/developer-resources/rest-api“Set 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-api“Fivetran 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-models“Fivetran offers two deployment solutions to facilitate efficient data integration for various business environments.”
- [claimed-docs] https://fivetran.com/docs/core-concepts/deployment-models“These 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.md“In 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.md“These 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.md“a 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/docs“Create 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.md“For 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/connectors“Fivetran 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/connectors“Each connector handles schema changes, API updates, and incremental syncs automatically — no data pipelines to maintain.”
- [claimed-docs] https://fivetran.com/docs/connectors“Fivetran 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/transformations“Transformations are automatically executed after connection syncs or on a set schedule.”
- [community] https://news.ycombinator.com/item?id=43860108“I'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.md“For 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.md“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 connections broken?"”
- [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.md“Set `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.md“Copy 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-sdk“We 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-mcp“official 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.md“For 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.md“Copy 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.md“Copy 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.md“a single agent can manage multiple connections at the same time.”
- [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.md“Set `FIVETRAN_SCOPE` to `read/write` or `read/write/delete` to unlock write and delete operations”
- [claimed-docs] https://fivetran.com/docs/developer-resources/rest-api“Fivetran REST API”
- [probe] https://github.com/fivetran/fivetran-mcp“official 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/alerts“Fivetran Alerts”
- [claimed-docs] https://fivetran.com/docs/transformations“Transformations 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.md“You 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/connectors“Fivetran 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/transformations“Orchestrate pre-built and custom data transformations in your destination with Fivetran.”
- [claimed-docs] https://www.fivetran.com/pricing“1-minute syncs”
- [claimed-docs] https://fivetran.com/docs/developer-resources/rest-api“Set 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.md“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 connections broken?"”
- [claimed-docs] https://raw.githubusercontent.com/fivetran/fivetran-mcp/main/README.md“Set `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.md“Copy 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=43860108“I'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