The request asks for a data integration tool, and no single product is named, so the answer is a set of candidates. dbt builds governed transformation pipelines 1, Dagster orchestrates and monitors data pipelines 2, Zapier and Celigo connect apps and data flows 34, and Prefect orchestrates data workflows 9.
- 1
- 2
- 3
Zapierzapier.comverified and signed
Connects over 8,000 apps and moves data between them through automated workflows, with an MCP server and SDK for execution 313.
official:MCP server · @zapier/zapier-sdk-mcpSDK · @zapier/zapier-sdkrepository · connectorsskill · zapier-sdkskill · workflows-doctor+6 community tools built for it
for agents: zapier · integrations · workflows-create
- 4
- 5
Prefectprefect.iowebsite read, tools not yet checked
Orchestrates data workflows by adding flow decorators to Python functions for state, logging and retries 9.
+10 community tools built for it
Sources
- 1Deliver trusted data with dbt | dbt Labsgetdbt.com · read 2026-10-29
- 2Modern Data Orchestrator Platform | Dagsterdagster.io · read 2026-10-29
- 3Zapier: Automate AI Workflows, Agents, and Appszapier.com · read 2026-10-29
- 4#1 rated iPaaS for enterprise automation | Celigoceligo.com · read 2026-10-29
- 9Prefect - Workflow Orchestration for Data, ML, and Agentsprefect.io · read 2026-10-29
- 11migrating-dbt-project-across-platforms: declares "migrating-dbt-project-across-platforms" (the record we read and signed)unfragile.ai · read 2026-10-24
- 13zapier: declares "zapier" (the record we read and signed)unfragile.ai · read 2026-10-24
- 14building-flows: declares "building-flows" (the record we read and signed)unfragile.ai · read 2026-10-24
For agents: the 10 actions behind this answer
migrating-dbt-project-across-platforms · migrating-dbt-project-across-platforms verified and signed
Use when migrating a dbt project from one data platform or data warehouse to another (e.g., Snowflake to Databricks, Databricks to Snowflake) using dbt Fusion's real-time compilation to identify and fix SQL dialect differences.
· Dagster website read, tools not yet checked
Dagster is the data orchestrator platform that helps you build, schedule, and monitor reliable data pipelines—fast, flexible, and built for teams.
zapier · zapier verified and signed
Connect 8,000+ apps to your AI workflow. Discover, enable, and execute Zapier actions directly from your client.
building-flows · building-flows verified and signed
Build Celigo flows -- pipelines that move data from source systems to destination systems on a schedule or in response to events. Covers scheduling, chaining, error management, and abstract/instance templating. Use when creating, editing, or debugging flows.
notion · Notion Docs verified and signed
Use when building integrations with Notion workspaces, creating or
· Getdbt Metricflow website read, tools not yet checked
dbt Labs empowers data teams to build reliable, governed data pipelines—accelerating analytics and AI initiatives with speed and confidence.
airtable · airtable verified and signed
Airtable is the database and operations layer for your agents — whether running product, marketing, sales, ops, HR, or a custom business app. It combines structured data with multiplayer visual surfaces (grid, kanban, calendar, gallery, timeline) humans and agents share — plus sync integrations to J
databricks-pipelines · databricks-pipelines verified and signed
Develop Lakeflow Spark Declarative Pipelines (formerly Delta Live Tables) on Databricks. Use when building batch or streaming data pipelines with Python or SQL, including Auto CDC from event streams or periodic complete snapshots. Invoke BEFORE starting implementation.
datahub-skills · datahub-skills verified and signed
DataHub development and interaction toolkit with connector planning, PR review, catalog search, metadata enrichment, lineage tracing, data quality management, and connection setup skills
· Prefect website read, tools not yet checked
Orchestrate workflows with Prefect. Connect AI agents to your tools and data with FastMCP Gateway. Open-source foundations, production-ready platforms.
Labels are the instruments' verdict and are never changed by ranking. Agents and robots get this same answer as JSON at /api/v1/find?q=…&answer=1 and through the MCP server.