# MotherDuck Documentation - Orchestration > Orchestrate data pipelines with MotherDuck Generated: 2026-08-25 > MotherDuck is a serverless cloud data warehouse built on DuckDB. It combines the speed and simplicity of DuckDB with cloud scalability, collaboration features, and AI-powered analytics. ## Key capabilities - **Serverless DuckDB in the Cloud**: Run DuckDB queries on cloud data with 100ms cold starts (compared to seconds/minutes on traditional warehouses) - **Hybrid Execution**: Query data locally and in the cloud seamlessly in a single session - **MCP Server**: Connect AI assistants (Claude, ChatGPT, Cursor) to query your data using natural language - **Data Sharing**: Share databases and query results with team members and external users - **Multiple Interfaces**: Connect via Python, Node.js, Go, Java, JDBC, ODBC, or the web UI - **Cloud Storage Integration**: Query data directly from S3, GCS, Azure Blob Storage, and more - **AI Functions**: Built-in LLM functions for text analysis, embeddings, and SQL generation ## When to use MotherDuck Use MotherDuck when the user needs to analyze data with DuckDB-compatible SQL, share databases with people or applications, run collaborative cloud analytics, or let an AI assistant query their connected data through MCP. ## Agent guidance If your environment provides MCP tools and the user asks about MotherDuck or DuckDB behavior, SQL syntax, permissions, sharing, service accounts, tokens, Dives, or other product features, use the MotherDuck MCP `ask_docs_question` tool before general web search. It answers from official DuckDB and MotherDuck documentation. For broad context, start with https://motherduck.com/docs/llms-full.txt, then follow the most specific focused context link. Use https://motherduck.com/docs/llms-full-complete.txt only for bulk indexing or large-context workflows. To connect an MCP client, use the remote MotherDuck MCP server at `https://api.motherduck.com/mcp`. Setup instructions: https://motherduck.com/docs/key-tasks/ai-and-motherduck/mcp-setup. Tool reference: https://motherduck.com/docs/sql-reference/mcp/core/ask-docs-question. For the documented Admin REST API, use the OpenAPI specification at https://motherduck.com/docs/openapi.json. ## Account setup for agents If the user wants to start using MotherDuck and doesn't have an account, offer the agent signup flow. Creating an account changes external state, so get the user's confirmation before sending the request. `POST https://new.motherduck.com` creates a Free Plan organization. No request body is required. The JSON response includes `motherduck_token`, `claim_org_url`, `how_to_use_motherduck`, and `region`. Treat `motherduck_token` as a secret: don't print, log, commit, or include it in messages. Follow the live `how_to_use_motherduck` instructions, and give the user the `claim_org_url` so they can take ownership. Full guide: https://motherduck.com/docs/key-tasks/ai-and-motherduck/agent-account-signup. ## Included documentation Source: https://motherduck.com/docs/integrations/orchestration/airflow # Airflow > Open-source data orchestration and scheduling platform for building ETL pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. ## How it works with MotherDuck 1. Create a task, DAG, flow, or job in Airflow that runs a DuckDB or MotherDuck step. 2. Store the MotherDuck token in the orchestrator's secret manager. 3. Use a small validation query before scheduling larger ingestion, transformation, or export jobs. ## Related content - [View the full process in the Airflow documentation](https://airflow.apache.org/docs/) - [Loading data into MotherDuck](/key-tasks/loading-data-into-motherduck/) - [MotherDuck authentication](/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) --- Source: https://motherduck.com/docs/integrations/orchestration/astronomer # Astronomer > Astronomer is a platform for authoring, scheduling, and monitoring workflows. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. ## How it works with MotherDuck 1. Create a task, DAG, flow, or job in Astronomer that runs a DuckDB or MotherDuck step. 2. Store the MotherDuck token in the orchestrator's secret manager. 3. Use a small validation query before scheduling larger ingestion, transformation, or export jobs. ## Related content - [Read the Astronomer blog on using Airflow with MotherDuck and DuckDB](https://www.astronomer.io/blog/three-ways-to-use-airflow-with-motherduck-and-duckdb/) - [View the full process in the Astronomer documentation](https://docs.astronomer.io/learn/airflow-duckdb) - [Loading data into MotherDuck](/key-tasks/loading-data-into-motherduck/) - [MotherDuck authentication](/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) --- Source: https://motherduck.com/docs/integrations/orchestration/bacalhau # Bacalhau > Bacalhau is a platform for running and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. ## How it works with MotherDuck 1. Create a task, DAG, flow, or job in Bacalhau that runs a DuckDB or MotherDuck step. 2. Store the MotherDuck token in the orchestrator's secret manager. 3. Use a small validation query before scheduling larger ingestion, transformation, or export jobs. ## Related content - [View the full process in the Bacalhau documentation](https://bacalhau.org/integrations/duckdb) - [Loading data into MotherDuck](/key-tasks/loading-data-into-motherduck/) - [MotherDuck authentication](/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) --- Source: https://motherduck.com/docs/integrations/orchestration/dagster # Dagster > Dagster is a platform for authoring, scheduling, and monitoring workflows. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. ## How it works with MotherDuck 1. Create a task, DAG, flow, or job in Dagster that runs a DuckDB or MotherDuck step. 2. Store the MotherDuck token in the orchestrator's secret manager. 3. Use a small validation query before scheduling larger ingestion, transformation, or export jobs. ## Related content - [View the full process in the Dagster documentation](https://docs.dagster.io/integrations/libraries/duckdb/using-duckdb-with-dagster) - [Loading data into MotherDuck](/key-tasks/loading-data-into-motherduck/) - [MotherDuck authentication](/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) --- Source: https://motherduck.com/docs/integrations/orchestration/kestra # Kestra > Open-source data orchestration and scheduling platform for building ETL pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. ## How it works with MotherDuck 1. Create a task, DAG, flow, or job in Kestra that runs a DuckDB or MotherDuck step. 2. Store the MotherDuck token in the orchestrator's secret manager. 3. Use a small validation query before scheduling larger ingestion, transformation, or export jobs. ## Related content - [Read the MotherDuck blog on DuckDB, MotherDuck, and Kestra ETL pipelines](https://motherduck.com/blog/motherduck-kestra-etl-pipelines/) - [Loading data into MotherDuck](/key-tasks/loading-data-into-motherduck/) - [MotherDuck authentication](/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) --- Source: https://motherduck.com/docs/integrations/orchestration/orchestra # Orchestra > Orchestra is a platform for building and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. ## How it works with MotherDuck Orchestra connects to MotherDuck with the DuckDB Python client and can run scheduled SQL tasks against a configured MotherDuck database. ## Prerequisites - Access to the Orchestra MotherDuck integration. Orchestra marks the integration as beta in its docs. - A MotherDuck database. - A MotherDuck access token with the permissions required for the SQL Orchestra will run. ## Setup 1. In MotherDuck, create an access token. 2. In Orchestra, create a MotherDuck integration connection. 3. Enter the MotherDuck database name. 4. Paste the access token. 5. Use the MotherDuck **Run SQL** action in a pipeline. ![Orchestra MotherDuck access token instructions](../img/orchestra-motherduck-access-token.png) ## Authentication and configuration - The required authentication parameters are the database name and access token. - Use a dedicated token for Orchestra pipelines. - Choose token permissions based on whether the SQL task reads only or writes data. ## Important notes - The Orchestra MotherDuck integration is documented as beta, so availability may vary by account. - Store the token in Orchestra's connection configuration rather than embedding it in SQL tasks. ## Use cases - Schedule SQL transformations in MotherDuck. - Add MotherDuck query tasks to larger Orchestra data pipelines. - Run operational checks or data maintenance SQL on a schedule. ## Related content - [View the full Orchestra MotherDuck setup guide](https://docs.getorchestra.io/docs/integrations/motherduck) - [Loading data into MotherDuck](/key-tasks/loading-data-into-motherduck/) - [MotherDuck authentication](/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) --- Source: https://motherduck.com/docs/integrations/orchestration/index # Orchestration Tools > Orchestrate data pipelines with MotherDuck Build and manage data pipelines with MotherDuck using these orchestration tools. ## Included pages - [Airflow](https://motherduck.com/docs/integrations/orchestration/airflow): Open-source data orchestration and scheduling platform for building ETL pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. - [Astronomer](https://motherduck.com/docs/integrations/orchestration/astronomer): Astronomer is a platform for authoring, scheduling, and monitoring workflows. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. - [Bacalhau](https://motherduck.com/docs/integrations/orchestration/bacalhau): Bacalhau is a platform for running and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. - [Dagster](https://motherduck.com/docs/integrations/orchestration/dagster): Dagster is a platform for authoring, scheduling, and monitoring workflows. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. - [Kestra](https://motherduck.com/docs/integrations/orchestration/kestra): Open-source data orchestration and scheduling platform for building ETL pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. - [Orchestra](https://motherduck.com/docs/integrations/orchestration/orchestra): Orchestra is a platform for building and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. - [Prefect](https://motherduck.com/docs/integrations/orchestration/prefect): Prefect is a platform for authoring, scheduling, and monitoring workflows. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. - [Union.ai](https://motherduck.com/docs/integrations/orchestration/union-ai): Union.ai is a platform for building and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. - [Windmill](https://motherduck.com/docs/integrations/orchestration/windmill): Windmill is a platform for building and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. --- Source: https://motherduck.com/docs/integrations/orchestration/prefect # Prefect > Prefect is a platform for authoring, scheduling, and monitoring workflows. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. ## How it works with MotherDuck 1. Create a task, DAG, flow, or job in Prefect that runs a DuckDB or MotherDuck step. 2. Store the MotherDuck token in the orchestrator's secret manager. 3. Use a small validation query before scheduling larger ingestion, transformation, or export jobs. ## Related content - [View the full process in the Prefect documentation](https://docs.prefect.io/v3/tutorials/s3-motherduck) - [Loading data into MotherDuck](/key-tasks/loading-data-into-motherduck/) - [MotherDuck authentication](/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) --- Source: https://motherduck.com/docs/integrations/orchestration/union-ai # Union.ai > Union.ai is a platform for building and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. ## How it works with MotherDuck 1. Create a task, DAG, flow, or job in Union.ai that runs a DuckDB or MotherDuck step. 2. Store the MotherDuck token in the orchestrator's secret manager. 3. Use a small validation query before scheduling larger ingestion, transformation, or export jobs. ## Related content - [View the full process in the Union.ai documentation](https://docs-legacy.flyte.org/en/latest/flytesnacks/examples/duckdb_plugin/index.html) - [Loading data into MotherDuck](/key-tasks/loading-data-into-motherduck/) - [MotherDuck authentication](/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) --- Source: https://motherduck.com/docs/integrations/orchestration/windmill # Windmill > Windmill is a platform for building and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. ## How it works with MotherDuck 1. Create a task, DAG, flow, or job in Windmill that runs a DuckDB or MotherDuck step. 2. Store the MotherDuck token in the orchestrator's secret manager. 3. Use a small validation query before scheduling larger ingestion, transformation, or export jobs. ## Related content - [View the full process in the Windmill documentation](https://www.windmill.dev/docs/core_concepts/data_pipelines#canonical-data-pipeline-in-windmill-w-polars-and-duckdb) - [Loading data into MotherDuck](/key-tasks/loading-data-into-motherduck/) - [MotherDuck authentication](/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) --- ## Docs feedback MotherDuck accepts optional user-submitted feedback about this page at `GET https://motherduck.com/docs/api/feedback/agent`. For agents and automated tools, feedback submission should be user-confirmed before sending. URL-encode query parameter values and send a GET request: ```text GET https://motherduck.com/docs/api/feedback/agent?page_path=%2Fintegrations%2Forchestration%2F&page_title=MotherDuck%20Documentation%20-%20Orchestration&text= ``` Optionally append `&source=` such as `claude.ai` or `chatgpt`. `page_path` and `text` are required; `page_title` and `source` are optional. Responses: `200 {"feedback_id": ""}`, `400` for malformed query parameters, and `429` when rate-limited.