Meet the Flockers

Discover the power of partnership with motherduck’s extensive ecosystem

Technology Partners

All Ingestion Reverse ETL Business Intelligence Data Science & AI Orchestration Data Quality Dev Tools Transformation Data Apps

INGESTION

Airbyte

Airbyte is an open-source data integration platform that enables the seamless transfer of data from various sources to data warehouses, lakes, and other destinations. It supports a vast range of connectors and provides an intuitive interface for managing data pipelines, ensuring data consistency and reliability. Airbyte offers both a community edition and a cloud service, allowing flexibility in deployment and scalability. ## Airbyte + MotherDuck Airbyte integrates with MotherDuck by facilitating the extraction, transformation, and loading (ETL) of data from numerous sources directly into the MotherDuck cloud data warehouse. Utilizing Airbyte's extensive library of connectors, users can automate and streamline the process of moving data into MotherDuck, ensuring that their cloud data warehouse remains up-to-date and easily accessible for analysis.

ORCHESTRATION

AirFlow

Apache Airflow is an open-source platform designed to programmatically author, schedule, and monitor workflows. It allows users to define tasks and their dependencies as code, enabling dynamic pipeline generation and complex data orchestration. Airflow supports a rich set of integrations and extensibility through custom plugins and operators. ## Apache Airflow + MotherDuck Apache Airflow integrates with MotherDuck by leveraging custom operators to connect to the MotherDuck cloud data warehouse. This allows users to execute SQL queries and manage data workflows directly within the Airflow environment, utilizing DuckDB's efficient analytical capabilities in a cloud-native setting.

INGESTION

Artie

Artie is the modern data infrastructure layer for the AI era — a fully managed CDC streaming platform that keeps production data continuously in sync with your warehouse. As companies activate their warehouses for real-time AI workloads, analytics, and customer-facing data products, they're standardizing on infrastructure that's fast, reliable, and built for scale. Artie automates the entire ingestion lifecycle — change capture, merges, backfills, and observability — with zero engineering maintenance and deploys in minutes. Leaders like Substack, ClickUp, and Alloy use Artie not just to solve today's pipeline issues, but to future-proof their data stack as their AI strategy accelerates. ## Artie + MotherDuck With Artie's MotherDuck integration, you can stream data from sources like PostgreSQL, SQL Server, and MySQL into your MotherDuck data warehouse–perfect for running analytical queries on your application data or integrating with third-party data in a single warehouse.

TRANSFORMATION

INGESTION

Ascend

Ascend.io is an intelligent data pipeline automation platform that streamlines the creation, operation, and maintenance of data workflows. It provides end-to-end automation, ensuring data engineers can build scalable data pipelines with minimal effort. Ascend.io leverages a unified data ingestion, transformation, and orchestration layer to simplify complex data engineering tasks. ## Ascend.io + MotherDuck Ascend.io integrates with MotherDuck by enabling seamless data pipeline automation that connects directly to MotherDuck's cloud data warehouse. This integration allows users to effortlessly ingest, transform, and orchestrate data within MotherDuck, leveraging DuckDB’s high-performance querying capabilities to optimize data processing and analytics workflows.

ORCHESTRATION

Astronomer

Astronomer Airflow is a managed service for Apache Airflow, providing robust orchestration and scheduling of complex data workflows. It offers scalability, reliability, and ease of use with features such as auto-scaling, monitoring, and a user-friendly interface. Designed for data engineers and analysts, it simplifies the deployment and management of Airflow environments, ensuring seamless data pipeline execution. ## Astronomer Airflow + MotherDuck Astronomer Airflow can be integrated with MotherDuck by orchestrating data workflows that involve querying, analyzing, and transforming data within the MotherDuck cloud data warehouse. Using Airflow operators, users can automate and schedule SQL queries and data processing tasks directly on MotherDuck, facilitating efficient data pipeline management and execution.

ORCHESTRATION

INGESTION

DATA QUALITY

Bruin

Bruin is an end-to-end data platform that brings together data ingestion, transformation using SQL and Python, data quality and governance. - Ingestion: You can ingest data from a variety of sources such as databases, marketing platforms, CRM tools, and more. - Transformation: You can transform your data inside the data warehouse using SQL and Python. Built-in materialization strategies, incremental processing, Jinja templating, and more. - Data Quality: Bruin allows you to ensure your data is accurate on a regular basis, whether it comes in externally or you built it. You can run column-level and custom quality checks, track the distribution of your data, run cross-table quality checks, and get alerts automatically. - Data Governance: Bruin allows scaling your data infrastructure via built-in governance reports, glossaries, metadata policies, cost reports, and more. You can run all Bruin checks in your CI/CD pipelines, ensuring your data pipelines always fit what you expect.

INGESTION

TRANSFORMATION

Bytewax

Open source framework and distributed stream processing engine. Build streaming data pipelines and real-time apps with everything you need: recovery, scalability, windowing, aggregations, and connectors.

REVERSE ETL

Census

Census is a reverse ETL tool that allows businesses to sync data from their data warehouse directly into the apps they use, such as CRMs, marketing platforms, and other SaaS tools. It helps ensure that all teams have access to the most up-to-date, actionable data by automating the data sync process. Census supports a wide range of data warehouses and enables data-driven workflows without requiring manual data exports or custom integrations. ## Census + MotherDuck Census integrates with MotherDuck by using MotherDuck's cloud data warehouse capabilities built on DuckDB. This integration allows users to easily sync and transform data stored in MotherDuck to various business applications and SaaS tools. Consequently, data teams can leverage MotherDuck's robust querying and analytics features while ensuring that actionable insights are seamlessly propagated to operational tools via Census.

INGESTION

CloudQuery

CloudQuery is an open-source data integration platform that enables the transformation of cloud assets into SQL-accessible databases. It helps organizations extract, transform, and load (ETL) data from various cloud providers into a format suitable for analysis and monitoring. CloudQuery supports a wide range of cloud services and offers a flexible configuration for custom data pipelines. ## CloudQuery + MotherDuck CloudQuery integrates with MotherDuck by allowing users to load and transform data from multiple cloud sources directly into the MotherDuck cloud data warehouse. This integration leverages CloudQuery’s ETL capabilities to efficiently funnel data into MotherDuck, making it accessible for advanced analytics and querying through DuckDB's SQL engine.

BUSINESS INTELLIGENCE

Cube

Cube is an API-first analytics platform that enables data engineers and developers to build data applications. It provides a semantic layer to unify data sources, caching, and pre-aggregation for fast query performance. Cube supports various data sources and visualization tools, making it a versatile solution for creating and managing analytical data workflows. ## Cube + MotherDuck Cube integrates with MotherDuck by leveraging its DuckDB-based architecture to efficiently query and analyze data stored in the MotherDuck cloud data warehouse. This integration enables Cube to utilize MotherDuck's high-performance SQL engine, providing fast and seamless access to large datasets for building robust data applications.

ORCHESTRATION

INGESTION

Dagster

Dagster is an open-source data orchestrator designed for the development, production, and observation of data assets. It helps data teams to define, schedule, and monitor complex data workflows, ensuring data reliability and quality. Dagster provides a rich development experience with type-safe pipelines, integrated testing, and seamless collaboration. ## Dagster + MotherDuck Dagster integrates with MotherDuck by leveraging DuckDB's capabilities within its orchestration workflows. This integration allows data engineers and analysts to run efficient, in-memory SQL queries on data stored in MotherDuck, enabling seamless data processing and analytics within Dagster's pipeline framework. The combined use of Dagster and MotherDuck enhances the ability to manage and analyze data workflows with high performance and flexibility. ## Customer Success Stories Teams orchestrate production data pipelines with Dagster and MotherDuck: - **[Gardyn](/case-studies/gardyn/)** uses Dagster Cloud for data ingestion, reducing daily pipeline execution from 24+ hours to under an hour. - **[UDisc](/case-studies/udisc-motherduck-sports-management/)** relies on Dagster for data orchestration, delivering analytics to millions of disc golf enthusiasts. - **[Trunkrs](/case-studies/trunkrs-same-day-delivery-motherduck-from-redshift/)** orchestrates their same-day delivery data workflows with Dagster and MotherDuck.

DEV TOOLS

Datagrip

DataGrip is a powerful database management tool developed by JetBrains, designed for SQL developers. It provides intelligent query completion, robust code analysis, and refactoring capabilities, supporting various databases like MySQL, PostgreSQL, and Oracle. DataGrip offers a unified interface, enabling users to manage and explore databases efficiently. ## DataGrip + MotherDuck DataGrip integrates with MotherDuck by leveraging its JDBC connector to connect to the MotherDuck cloud data warehouse. This enables users to execute queries, manage schemas, and analyze data stored in MotherDuck directly from the DataGrip interface.

DATA SCIENCE & AI

DataLab

DataLab is a collaborative data science platform designed for data analysts and scientists to explore, analyze, and visualize data in a unified workspace. It offers robust tools for data preparation, machine learning, and interactive dashboards, enabling teams to work seamlessly on shared projects. DataLab supports various data sources and integrates with popular programming languages like Python and R, streamlining the data workflow from ingestion to insights. ## DataLab + MotherDuck DataLab integrates with MotherDuck by allowing users to connect directly to MotherDuck's cloud data warehouse, leveraging DuckDB's efficient querying capabilities. This integration enables DataLab users to perform high-performance data analysis and visualization on large datasets stored in MotherDuck, enhancing their ability to derive actionable insights quickly.

BUSINESS INTELLIGENCE

Datawisp

Datawisp is a no code analytics platform that lets anyone analyze data and discover insights regardless of their technical knowledge. Its node-based interface allows users to combine different “blocks” to transform data, much like a developer would with code. Each block performs a different operation, such as filtering, sorting, or creating a chart, and linking even 3 or 4 of these blocks can transform and analyze data in powerful ways. Datawisp also features an AI-powered assistant, named Wispy, that takes natural language input from the user and automatically creates charts, tables, and more. Worksheets created by Wispy can be used as-is or can be subsequently edited manually by anyone with some knowledge of how blocks work. Datawisp runs in a browser and lets users collaborate in real time and share their work with both internal and external audiences.

TRANSFORMATION

dbt Core

dbt (data build tool) is a command-line tool that enables data analysts and engineers to transform data in their warehouse more effectively. It allows users to write modular SQL queries, test data integrity, and document data transformations, streamlining the analytics engineering workflow. dbt supports version control and collaboration, making it easier for teams to manage and deploy data models. ## dbt + MotherDuck dbt integrates with MotherDuck by allowing users to perform data transformations and analytics directly within the MotherDuck cloud data warehouse. By connecting dbt to MotherDuck, users can leverage DuckDB's efficient query execution engine for transforming and modeling data, ensuring seamless and optimized data workflows. This integration empowers teams to build, test, and document their data pipelines efficiently while utilizing MotherDuck's scalable and performant data infrastructure. Since both dbt and DuckDB can run locally, users can do development and testing using the same technologies they run in production. ## Customer Success Stories Data teams rely on dbt with MotherDuck for efficient transformations: - **[UDisc](/case-studies/udisc-motherduck-sports-management/)** reduced their dbt job runtime from 6 hours to just 30 minutes by switching to MotherDuck. - **[Gardyn](/case-studies/gardyn/)** uses dbt as part of their transformation layer, processing IoT and ecommerce data with 10x cost savings. - **[Trunkrs](/case-studies/trunkrs-same-day-delivery-motherduck-from-redshift/)** leverages dbt for data transformation in their same-day delivery analytics pipeline. - **[Reflex](/case-studies/reflex-careers-gig-economy-retail/)** builds analytics-ready tables with dbt, powering insights for gig economy retail.

INGESTION

dlt

dlt is an open-source data loading tool that simplifies the process of moving data from various sources into data warehouses or lakes. It supports a wide range of data sources and destinations, offering seamless ETL (Extract, Transform, Load) capabilities with a focus on usability and flexibility. dltHub allows users to manage data pipelines efficiently, ensuring data integrity and consistency throughout the process. ## dlt + MotherDuck dlt integrates with MotherDuck by enabling users to load data directly into the MotherDuck cloud data warehouse. This integration leverages dltHub's flexible ETL capabilities to move data from multiple sources into MotherDuck, allowing for efficient data management and analysis within the MotherDuck environment. ## Customer Success Stories Teams build lightweight data pipelines with dlt and MotherDuck: - **[Reflex](/case-studies/reflex-careers-gig-economy-retail/)** implemented their entire data pipeline in about 15 lines of code using dlt, demonstrating the simplicity of loading data into MotherDuck.

BUSINESS INTELLIGENCE

Dot

🤖 Dot, the data bot is an intelligent virtual data assistance that answers business data questions, retrieves definitions and relevant data assets, and can even assist with data modelling. 🧠 Leverages the power of large language models combined with your data stack (Snowflake, BigQuery, Redshift, see all Integrations) and documentation of processes and metrics. ✅ Ships with a developer training space that ensures the data team is in the driver seat and results from Dot are validated. Say No to hallucinations.

INGESTION

Estuary

Estuary is a real-time CDC data integration platform that enables seamless data movement across various systems and applications. It offers tools for building, managing, and monitoring data pipelines, ensuring reliable and low-latency data transfers. Estuary supports a wide range of data sources, destinations, and transformations, making it a versatile solution for modern data workflows. ## Estuary + MotherDuck Estuary integrates with MotherDuck by enabling real-time data ingestion and synchronization into the MotherDuck cloud data warehouse. Users can set up seamless data pipelines from multiple sources to MotherDuck, ensuring efficient and timely data availability for analysis. This integration leverages Estuary's robust data movement capabilities to enhance the performance and utility of MotherDuck’s DuckDB-based architecture.

BUSINESS INTELLIGENCE

Evidence

Evidence is an open-source analytics tool that allows data teams to create and share reports using SQL and Markdown. It is designed to enable seamless collaboration and real-time data analysis, offering features like version control, interactive dashboards, and automated reporting. Evidence leverages a simple, intuitive interface to help analysts and engineers convert raw data into actionable insights without extensive coding. ## Evidence + MotherDuck Evidence integrates with MotherDuck by connecting directly to the MotherDuck cloud data warehouse. This allows users to run SQL queries on their data stored in MotherDuck, enabling them to build and share interactive reports and dashboards with real-time data fetched from the DuckDB-based backend. The integration ensures that data analysts and engineers can leverage the scalability and speed of MotherDuck while using Evidence's user-friendly reporting tools.

BUSINESS INTELLIGENCE

Explo

Explo is an embedded analytics platform that lets companies turn data into interactive dashboards and reports inside their products. Build and embed fully white-labeled dashboards or enable AI powered, self-serve analytics for your users directly in your application in a fraction of the time. EXPLO + MOTHERDUCK Explo connects directly to MotherDuck to provide high-latency embedded analytics for users. Teams can build and embed responsive dashboards powered by MotherDuck, without data movement or extra engineering.

DATA SCIENCE & AI

Fabi.ai

Fabi.ai combines SQL, Python and AI automation into one collaborative platform to help you conquer complex and ad hoc analyses, turning questions into answers. ## Fabi.ai + MotherDuck Fabi.ai integrates with MotherDuck by allowing users to connect their smartbooks and reports directly to MotherDuck's cloud data warehouse. This integration enables users to run SQL queries on MotherDuck's DuckDB-based backend, leveraging its high-performance and efficient data analytics capabilities within Fabi's collaborative environment.

INGESTION

Fivetran

Fivetran is a data integration tool that automates the process of extracting, loading, and transforming data from various sources into your data warehouse. It offers pre-built connectors for a wide range of data sources, ensuring reliable, consistent, and up-to-date data for analysis. Fivetran focuses on ease of use, requiring minimal maintenance while providing robust data pipeline solutions. ## Fivetran + MotherDuck Fivetran integrates with MotherDuck by seamlessly connecting to it as a destination for data ingestion. Users can set up Fivetran to automatically extract data from various sources and load it directly into MotherDuck, leveraging MotherDuck's high-performance analytical capabilities. This integration simplifies the data pipeline setup and ensures that data is consistently and accurately delivered to MotherDuck for analysis. ## Customer Success Stories Organizations trust Fivetran to load data into MotherDuck: - **[DoSomething](/case-studies/dosomething-non-profit-tco-cost-savings/)** was one of the first teams to use Fivetran with MotherDuck, benefiting from close collaboration to achieve significant TCO savings. - **[Gardyn](/case-studies/gardyn/)** uses Fivetran alongside Dagster for data ingestion, consolidating data from MySQL, Postgres, and MongoDB into MotherDuck.

BUSINESS INTELLIGENCE

GoodData

GoodData is a cloud-based analytics platform that enables organizations and data product builders to transform raw data into actionable insights. The platform offers robust capabilities including pipeline integration, data modeling and visualization, embedding, and AI capabilities, all of which can be managed as code or with an intuitive user interface. GoodData’s advanced tools for data visualization, reporting, and dashboard creation help users make informed, data-driven decisions. The platform supports a wide range of data sources to deliver flexible and scalable analytics solutions. GoodData can be deployed in any public or private cloud, data center, or region to ensure seamless integration into various environments while maximizing accessibility and performance. ## GoodData + MotherDuck GoodData integrates with MotherDuck by leveraging MotherDuck's DuckDB-powered cloud data warehouse capabilities. The integration allows GoodData users to seamlessly query and visualize data stored in MotherDuck, combining the high-performance analytics of DuckDB with GoodData's powerful visualization and reporting tools. The result is a streamlined and efficient workflow for data analysis and business intelligence. ## Key Benefits - **Ease of Use:** Compatibility across all programming languages and the ability to run in the web browser ensures a user-friendly experience - **Increased Speed:** Faster queries reduce the cost of ownership by optimizing performance - **Feature-Rich Database:** The GoodData platform supports standard SQL, rich integrations, and advanced capabilities like GROUP BY ALL to support complex data needs - **Flexible and Extensible:** Load data from various sources for seamless integration into existing pipelines - GoodData’s open-source nature delivers extreme flexibility for customization The integration empowers users to maximize their data's potential and extract valuable insights and drive informed business decisions.

DATA SCIENCE & AI

Google CoLab

Google Colab is a free cloud-based Jupyter notebook environment that allows users to write and execute Python code through the browser. It provides free access to GPU and TPU computing resources, making it ideal for machine learning, data analysis, and scientific computing. Colab supports collaborative editing and integrates seamlessly with Google Drive for easy access to files and notebooks. ## Google Colab + MotherDuck Google Colab can integrate with MotherDuck by utilizing the DuckDB Python API within the Colab environment. Analysts and data scientists can connect to the MotherDuck cloud data warehouse directly from their Colab notebooks to execute SQL queries, perform data analysis, and leverage the computational power provided by MotherDuck. This integration enables seamless data processing and analysis within a familiar and accessible interface.

INGESTION

Hevo

Hevo data is a no-code, fully managed data integration platform that empowers teams to extract, load, and transform data from different sources to their destinations in just a few clicks. It uses smart automation to ensure accurate and uninterrupted data ingestion, so teams can focus on delivering valuable data insights and driving better business decisions. ## HEVO + MOTHERDUCK Hevo integrates with MotherDuck by moving data from 150+ sources via Amazon S3 into MotherDuck’s cloud data warehouse, keeping datasets fresh and instantly queryable. Hevo’s automated schema handling, near real-time replication, and monitoring facilitate reliable pipelines, while MotherDuck delivers fast, collaborative SQL without warehouse ops; giving teams a low-maintenance, cost-predictable path from source systems to business insights.

BUSINESS INTELLIGENCE

Hex

Hex is a collaborative data workspace that allows data scientists, analysts, and engineers to create, share, and run complex data workflows. It combines powerful data notebooks with a rich set of visualization tools and integrations, enabling seamless collaboration and exploration of data. Hex supports SQL, Python, and no-code data manipulation, making it versatile for various data tasks. ## Hex + MotherDuck Hex integrates with MotherDuck by allowing users to connect their Hex notebooks directly to MotherDuck's cloud data warehouse. This integration enables users to run SQL queries on MotherDuck's DuckDB-based backend, leveraging its high-performance and efficient data analytics capabilities within Hex's collaborative environment. ## Customer Success Stories Leading companies use Hex with MotherDuck to power their analytics: - **[Emora Health](/case-studies/emora-health/)** uses Hex as their company-wide analytics interface, enabling every team member to explore data directly—slicing, dicing, and asking new questions with MotherDuck as the backend. - **[UDisc](/case-studies/udisc-motherduck-sports-management/)** leverages Hex as part of their dashboard front-end, delivering sports management analytics to millions of disc golf players. - **[Gardyn](/case-studies/gardyn/)** combines Hex with their modern data stack to analyze IoT telemetry, ecommerce, and operational data. - **[ATM.com](/case-studies/atm-com-analytics-costs-sql-expressibility/)** uses Hex for building ML models powered by data in MotherDuck.

BUSINESS INTELLIGENCE

Holistics

Holistics helps data teams set up self-service BIs that are reliable and easy to maintain. Everyone can now self-serve data with confidence by applying software's best practices.

INGESTION

Inecta ETL

inectaETL provides a comprehensive set of pre-configured data transformations from Microsoft Business Central, quickly pipelined into MotherDuck within minutes, so you can: - Easily extend the pipeline by adding more datasets as needed - Seamlessly integrate new data sources without interrupting operations - Ensure complete, accurate, and up-to-date data is always visible

ORCHESTRATION

Kestra

Kestra is an open-source orchestration and scheduling platform designed to automate complex data workflows. It provides a user-friendly interface for managing tasks, real-time monitoring, and error handling, making it easier to streamline data operations. Kestra supports a wide range of plugins, enabling seamless integration with various data systems and tools. ## Kestra + MotherDuck Kestra integrates with MotherDuck by leveraging its flexible plugin system to connect with the cloud data warehouse capabilities of MotherDuck. This integration allows users to orchestrate and manage data workflows that involve querying and processing data stored in MotherDuck, utilizing DuckDB's efficient analytics database engine to optimize performance.

DATA SCIENCE & AI

LangChain

LangChain is a framework designed to facilitate the development of applications leveraging large language models (LLMs). It provides tools for building, managing, and deploying LLM-powered applications, enabling seamless integration with various data sources and workflows. LangChain supports features such as prompt management, model evaluation, and API connectivity to streamline the development process for data-driven applications. ## LangChain + MotherDuck LangChain integrates with MotherDuck to enable seamless interaction between LLM-powered applications and the cloud data warehouse capabilities of MotherDuck. By leveraging DuckDB's efficient in-process querying and MotherDuck's scalable cloud infrastructure, LangChain applications can perform complex data manipulations and analytics in real-time. This integration ensures that data scientists and analysts can harness the power of LLMs while maintaining robust, scalable, and efficient data workflows.

BUSINESS INTELLIGENCE

Livedocs

Livedocs is an AI-native analytics workspace built around autonomous data agents. Instead of starting with dashboards or SQL, users can work in agent mode: ask a question in plain English, and an agent plans the analysis, writes SQL or Python, runs it on real data, builds charts, and iterates until it reaches an answer. For deeper work, Livedocs also supports full SQL and Python notebooks, reactive execution, scheduling, and shareable data apps—so teams can move seamlessly from exploration to production. ## Livedocs + MotherDuck Livedocs integrates directly with MotherDuck’s DuckDB-based cloud platform. Data agents operate on MotherDuck as their execution engine—inspecting schemas, generating and optimizing SQL, joining datasets, and creating charts automatically. The result is an AI-native experience where agents continuously analyze and maintain analytics on top of MotherDuck, while teams collaborate through notebooks and share results as interactive apps.

DATA SCIENCE & AI

LlamaIndex

LlamaIndex.ai is a data framework designed to facilitate the ingestion, transformation, and querying of unstructured data using large language models (LLMs). It simplifies the process of building applications that utilize natural language processing and machine learning by providing a suite of tools for seamless data integration and analysis. ## LlamaIndex.ai + MotherDuck LlamaIndex.ai integrates with MotherDuck by leveraging DuckDB's capabilities to query structured data efficiently within the MotherDuck cloud data warehouse environment. This integration allows users to combine unstructured data handling from LlamaIndex.ai with the high-performance querying and storage solutions provided by MotherDuck, enabling comprehensive data analysis workflows.

ORCHESTRATION

INGESTION

Mage

Mage is an open-source data pipeline tool designed to simplify the process of building, running, and managing data pipelines. It offers a user-friendly interface, supports scheduling and monitoring, and integrates seamlessly with various data sources and destinations. Mage provides built-in features for data transformations, ensuring efficient and reliable data workflows. They call themselves the modern replacement for Airflow. ## Mage + MotherDuck Mage integrates with MotherDuck by allowing users to create data pipelines that connect to MotherDuck's cloud data warehouse. This integration enables seamless data ingestion, transformation, and analysis within MotherDuck, leveraging DuckDB's high-performance query engine for efficient data processing.

DATA SCIENCE & AI

Marimo

marimo is a reactive notebook for Python and SQL that models notebooks as dataflow graphs. When you run a cell or interact with a UI element, marimo automatically runs affected cells (or marks them as stale), keeping code and outputs consistent and preventing bugs before they happen. Every marimo notebook is stored as pure Python, executable as a script, and deployable as an app. ## marimo + MotherDuck marimo integrates with MotherDuck to provide an interactive and seamless data analysis experience. Users can connect directly to their MotherDuck data warehouse using marimo's SQL cells or using the DuckDB Python API, allowing them to: - Create dynamic visualizations of data stored in MotherDuck using marimo with your favorite plotting library for Python - Leverage marimo's reactive execution to automatically keep queries and visualizations up to date - Build interactive dashboards and apps that query MotherDuck data in real-time - Mix-and-match Python and SQL to perform complex data transformations on MotherDuck tables - Use AI to generate SQL queries and visualizations of your MotherDuck tables The integration enables data scientists and analysts to create reproducible, interactive data workflows that scale seamlessly from local development to production deployments. marimo's dataflow graph ensures data consistency while MotherDuck provides enterprise-grade data storage and querying capabilities.

INGESTION

Meltano

Meltano is an open-source data integration platform designed for data teams to manage their ELT pipelines with ease. It supports a plug-and-play architecture, offering compatibility with various data sources and destinations, and allows for the orchestration of complex data workflows. Meltano emphasizes declarative code-first model, flexibility, and collaboration, making it a robust tool for streamlining data operations. ## Meltano + MotherDuck Meltano integrates with MotherDuck by utilizing its ability to connect to DuckDB-based data warehouses. This seamless integration allows data teams to extract, load, and transform data directly within MotherDuck's scalable cloud environment, leveraging DuckDB's performance capabilities to optimize data workflows. ## Customer Success Stories Data teams extract and load data with Meltano into MotherDuck: - **[Trunkrs](/case-studies/trunkrs-same-day-delivery-motherduck-from-redshift/)** uses Meltano for data extraction and orchestration, migrating from Redshift to achieve snappier query response times for their logistics operations.

BUSINESS INTELLIGENCE

Metabase

Metabase is an open-source business intelligence tool that enables users to easily create dashboards, generate reports, and ask questions about their data without needing to write SQL queries. It provides a user-friendly interface that allows data exploration and visualization, making it accessible for both technical and non-technical users. Metabase connects to various databases and data warehouses, offering robust analytics capabilities. ## Metabase + MotherDuck Metabase integrates with MotherDuck by connecting directly to the MotherDuck cloud data warehouse. Users can leverage Metabase's intuitive interface to query, visualize, and analyze data stored in MotherDuck, taking advantage of DuckDB's fast analytical query performance. This integration allows seamless data exploration and reporting, enabling efficient data-driven decision-making. ## Customer Success Stories Startups build self-serve analytics with Metabase and MotherDuck: - **[Reflex](/case-studies/reflex-careers-gig-economy-retail/)** uses Metabase for business intelligence and reporting, achieving robust analytics capabilities without expensive enterprise BI tools.

BUSINESS INTELLIGENCE

Microsoft Power BI

Microsoft Power BI is a business analytics service that delivers insights to enable fast, informed decisions. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. Power BI connects to a wide variety of data sources, offering robust data preparation, data discovery, and interactive reporting. ## Power BI + MotherDuck Microsoft Power BI integrates with MotherDuck by connecting to the cloud data warehouse capabilities provided by MotherDuck, which is based on DuckDB. This integration allows users to leverage Power BI's powerful visualization and analytics tools to explore and analyze data stored in MotherDuck, ensuring seamless data access and real-time insights.

DATA QUALITY

Monte Carlo

Monte Carlo is a data observability platform designed to help organizations monitor and ensure the reliability of their data pipelines. It provides automated monitoring, alerting, and root cause analysis to detect and resolve data quality issues in real-time. Monte Carlo supports integration with various data warehouses, ETL tools, and BI platforms to provide end-to-end data reliability. ## Monte Carlo + MotherDuck Monte Carlo integrates with MotherDuck to offer comprehensive data observability for data stored and processed within the MotherDuck cloud data warehouse. Through this integration, Monte Carlo can monitor data quality, lineage, and performance metrics, ensuring that data in MotherDuck is reliable and any issues are promptly identified and addressed. This seamless integration helps data teams maintain trust in their data and streamline the issue resolution process.

DATA SCIENCE & AI

Ollama

Ollama is a free, open-source platform that allows users to run large language models (LLMs) on their local machine. It's designed to make LLM technology more accessible and customizable, and can be used for a variety of tasks beyond coding ## Ollama + MotherDuck Ollama can use MotherDuck as a DuckDB-based backend for Retrieval Augmented Generation of LLM results.

BUSINESS INTELLIGENCE

Omni

Omni is a comprehensive data analytics platform that provides tools for data preparation, visualization, and advanced analytics. It enables users to seamlessly integrate and analyze data from various sources, offering intuitive dashboards and powerful reporting features. Omni supports collaborative workspaces, making it easier for teams to share insights and drive data-driven decisions. ## Omni + MotherDuck Omni integrates with MotherDuck by allowing users to connect directly to MotherDuck's cloud data warehouse. This integration facilitates efficient querying and analysis of large datasets stored in MotherDuck, leveraging DuckDB's high-performance capabilities. Users can pull data from MotherDuck into Omni for further processing, visualization, and reporting within a unified platform. ## Customer Success Stories Investment and healthcare teams choose Omni with MotherDuck: - **[Kultura Capital](/case-studies/kultura-capital/)** enables analysts to explore data without code expertise, using Omni's native MotherDuck integration for frictionless financial analysis. - **[PriceMedic](/case-studies/pricemedic-hypertenancy-healthcare-transparency/)** replaced Amazon QuickSight with Omni, gaining powerful visualization capabilities on top of MotherDuck's serverless architecture.

REVERSE ETL

OneSignal

OneSignal is a omnichannel solution that helps you improve conversion, boost engagement, and retain users. It feeds events from MotherDuck to power: - Push Notifications - In-App Messages - Email - SMS

ORCHESTRATION

Orchestra

Orchestra is a Modern Data Orchestration Platform, that gives you everything you need to build end to end AI and Data Workflows using MotherDuck. The Orchestra x Motherduck integration allows data teams to easily move data to Motherduck using duckdb/python, execute queries on Motherduck directly and even run dbt-core on Motherduck. No infrastructure to manage, no learning curve, instant set-up.

TRANSFORMATION

Paradime

Paradime is a collaborative development environment designed for data teams to manage dbt™ projects efficiently. It provides features such as version control, testing, and documentation to streamline the development and deployment of data transformations. Paradime integrates seamlessly with various data warehouses and tools, enhancing the workflow of data analysts, engineers, and scientists. ## Paradime + MotherDuck Paradime dbt platform integrates with MotherDuck by allowing users to connect their dbt projects directly to the MotherDuck cloud data warehouse. This integration facilitates efficient data transformations and analytics, leveraging MotherDuck's scalable and high-performance querying capabilities to optimize data workflows and ensure seamless data management.

INGESTION

REVERSE ETL

Polytomic

Polytomic is a single platform for moving data in both directions between data warehouses, databases, SaaS applications like Salesforce, spreadsheets, cloud storage buckets like S3, and arbitrary HTTP APIs. ELT, ETL, CDC streaming, and Reverse ETL workloads are all reliably and scalably supported through both an intuitive no-code interface as well as a full API (with Terraform support). Polytomic can be accessed either through the cloud version or a self-hosted version using Docker. Polytomic’s sync engine can also be embedded in your products using Polytomic Connect, the white label sync API. ## Polytomic + MotherDuck Polytomic can sync data with MotherDuck in both directions: - Sync from other databases (e.g. PostgreSQL) into MotherDuck (high-scale CDC streaming supported too). - Sync from SaaS applications like Stripe, Zendesk, Salesforce, and others into MotherDuck - Sync from MotherDuck into SaaS applications like Salesforce, HubSpot, Zendesk, and others. - Sync in both directions between spreadsheets (e.g. Google Sheets, Airtable) and MotherDuck.

BUSINESS INTELLIGENCE

Preset

Preset is a modern data exploration and visualization platform built on Apache Superset. It enables users to create, share, and collaborate on interactive dashboards and reports with ease. With robust support for SQL-based querying and a variety of visualization options, Preset is designed to empower data analysts and scientists to gain insights quickly. ## Preset + MotherDuck Preset integrates with MotherDuck by connecting to it as a SQL-based data source. Users can easily query data stored in MotherDuck's cloud data warehouse using Preset's interface, enabling seamless data visualization and exploration. This integration leverages MotherDuck's efficient, high-performance querying capabilities to enhance the overall data analysis experience.

DEV TOOLS

PuppyGraph

PuppyGraph is a graph analytics platform designed for handling and visualizing complex network data. It provides tools for constructing, querying, and analyzing graph structures, making it easier to uncover relationships and patterns within large datasets. PuppyGraph supports various graph algorithms and offers a user-friendly interface for both technical and non-technical users. ## PuppyGraph + MotherDuck PuppyGraph integrates with MotherDuck by utilizing DuckDB's efficient analytical capabilities as a backend for storing and querying graph data. This integration allows seamless data flow between MotherDuck's cloud data warehouse and PuppyGraph, enabling users to perform advanced graph analytics on data stored in MotherDuck. This combination leverages the high-performance querying of DuckDB with the specialized graph processing features of PuppyGraph.

BUSINESS INTELLIGENCE

Querio

Querio is an AI-driven business intelligence and analytics workspace that lets teams query, explore, visualize, and report on data at any technical level. It treats analytics like software with reactive notebooks that run SQL and Python, and stores reusable logic as versioned context. Querio combines AI agents and interactive dashboards to make data exploration fast, flexible, and accessible to both technical and non-technical users. ## Querio + MotherDuck Querio integrates with MotherDuck by allowing users to connect their Querio workspace directly to MotherDuck’s cloud data warehouse. With this integration, users can run SQL against MotherDuck’s DuckDB-based backend, bringing high-performance analytics into Querio’s collaborative environment. This lets teams ask questions, generate insights, and build reports on live data stored in MotherDuck without moving or duplicating datasets.

BUSINESS INTELLIGENCE

Rill Data

Rill Data provides real-time analytics and visualizations, enabling users to create interactive dashboards and monitor key metrics with minimal latency. Built for speed and simplicity, Rill Data allows data teams to ingest, transform, and analyze streaming data efficiently. Its platform is designed to handle high-throughput data streams and deliver insights in real time. ## Rill Data + MotherDuck Rill Data integrates with MotherDuck by leveraging its cloud-based DuckDB architecture to store and query large datasets efficiently. This integration enables seamless real-time data ingestion and analytics, allowing users to perform complex queries on streaming data while benefiting from MotherDuck's robust cloud infrastructure and performance optimization.

DATA QUALITY

Secoda

Secoda is a unified data discovery and management platform designed to help data teams efficiently organize, document, and collaborate on their data assets. It offers features such as data cataloging, automated documentation, and data lineage tracking, simplifying the process of making data easily accessible and understandable for all stakeholders. Secoda is built to enhance productivity and transparency within data-driven organizations. ## Secoda + MotherDuck Secoda integrates with MotherDuck by allowing users to catalog and manage data stored in the MotherDuck cloud data warehouse. Through this integration, data teams can leverage Secoda’s capabilities to document, discover, and track the lineage of data within MotherDuck, providing a seamless experience for organizing and understanding cloud-based data assets.

INGESTION

Sling Data

Sling Data is a modern data integration platform that enables seamless data movement across various sources and destinations. It offers robust ETL capabilities, real-time data streaming, and transformation tools to ensure data is always accessible and up-to-date. With its intuitive interface and extensive connector library, Sling Data simplifies the process of integrating and managing complex data pipelines. ## Sling Data + MotherDuck Sling Data integrates with MotherDuck by leveraging its comprehensive connector library to facilitate seamless data transfer and synchronization between various data sources and the MotherDuck cloud data warehouse. This integration allows users to efficiently load, transform, and query data within MotherDuck, utilizing DuckDB's powerful analytical capabilities.

DATA QUALITY

Soda

Soda is a data quality platform that enables data teams to detect, diagnose, and resolve data issues. It offers tools for monitoring, testing, and managing data quality, ensuring reliable data across the data pipeline. The platform supports integrations with various data sources and provides actionable insights to maintain data integrity. ## Soda + MotherDuck Soda integrates with MotherDuck to ensure high data quality within the MotherDuck cloud data warehouse environment. By connecting to MotherDuck, Soda can monitor and test data stored in MotherDuck, allowing data teams to identify and address data quality issues promptly. This integration helps maintain accurate and reliable data for analytics and decision-making processes.

TRANSFORMATION

SQLMesh

SQLMesh is a data transformation framework designed to simplify the development and management of data pipelines. It offers a flexible architecture that supports version control, testing, and deployment of SQL-based workflows. SQLMesh helps ensure data quality and consistency by automating the maintenance of dependencies, scheduling, and monitoring of data transformation jobs. ## SQLMesh + MotherDuck SQLMesh integrates with MotherDuck by leveraging DuckDB's capabilities within the MotherDuck cloud data warehouse. This integration enables SQLMesh users to perform efficient data transformations and analytics directly on the data stored in MotherDuck. Through this integration, users can benefit from streamlined data workflows and enhanced performance for their data projects. ## Customer Success Stories Analytics teams manage transformations with SQLMesh and MotherDuck: - **[ATM.com](/case-studies/atm-com-analytics-costs-sql-expressibility/)** uses SQLMesh as their transformation tool, managing analytics pipelines that power fintech insights with MotherDuck's serverless architecture.

INGESTION

Streamkap

Streamkap is streaming ETL and change data capture built on Apache Kafka and Flink. Sub-second latency, easy to use, zero maintenance.

DATA APPS

Streamlit

Streamlit is an open-source app framework designed for creating and sharing data apps. It allows users to build and deploy interactive web applications in Python effortlessly. With a minimal amount of code, data scientists and analysts can turn their data scripts into rich, functional apps that can be shared and iterated on quickly. ## Streamlit + MotherDuck Streamlit can be integrated with MotherDuck to create interactive data applications that leverage the power of DuckDB in the cloud. By connecting Streamlit apps to MotherDuck, users can query, analyze, and visualize data stored in MotherDuck's cloud data warehouse, enabling seamless and efficient data workflows directly within Streamlit's user-friendly interface.

BUSINESS INTELLIGENCE

Superset

Apache Superset is an open-source data exploration and visualization platform designed for modern data teams. It offers a rich set of data visualization capabilities, a user-friendly interface, and robust integration options for various data sources. Superset allows users to create and share dashboards, run SQL queries, and gain insights from their data in real-time. ## Superset + MotherDuck Superset integrates with MotherDuck by connecting to it as a SQL-based data source. Users can configure Superset to query data stored in MotherDuck's cloud data warehouse, leveraging DuckDB's efficient query processing engine. This integration enables seamless data visualization and exploration directly from MotherDuck within the Superset interface. MotherDuck also supports Preset, which is a commercial cloud platform based on the Apache Superset open source project.

BUSINESS INTELLIGENCE

Tableau

Tableau is a leading visual analytics platform that transforms data into actionable insights through interactive and shareable dashboards. It connects to various data sources, enabling users to create and distribute visualizations with ease. Tableau supports real-time collaboration and offers robust analytical capabilities for data discovery and storytelling. ## Tableau + MotherDuck Tableau integrates with MotherDuck by allowing users to connect directly to their MotherDuck cloud data warehouse. This integration enables seamless data querying and visualization, leveraging DuckDB's efficient query engine for fast and interactive analytics. Data analysts, scientists, and engineers can thus utilize Tableau's powerful visualization tools to explore and present data stored in MotherDuck. Tableau desktop, the on-premise hosted product and Tableau Cloud are all supported. ## Customer Success Stories Non-profits and enterprises leverage Tableau with MotherDuck: - **[DoSomething](/case-studies/dosomething-non-profit-tco-cost-savings/)** uses Tableau Cloud with MotherDuck to deliver "familiar Business Intelligence at the speed of DuckDB," enabling faster insights for their social impact mission.

INGESTION

Unstructured

80% of enterprise data is locked in complex documents, untapped and unused. Every day, valuable insights remain buried in PDFs, presentations, and emails you haven't been able to access. Until now. Unstructured automatically transforms complex, unstructured data into clean, structured data for GenAI applications. Automatically. Continuously. Effortlessly.

BUSINESS INTELLIGENCE

Zenlytic

Zenlytic is a business intelligence tool designed for e-commerce and direct-to-consumer brands. It offers self-serve analytics capabilities, allowing users to gain insights from their data without needing technical expertise. The platform features natural language querying, making it accessible for teams to generate reports and visualizations quickly. ## Zenlytic + MotherDuck Zenlytic integrates with MotherDuck by leveraging MotherDuck's cloud data warehouse capabilities for efficient data storage and querying. This integration allows Zenlytic users to run complex analytical queries on large datasets stored in MotherDuck, utilizing DuckDB's high-performance SQL engine for fast and reliable data processing.

Consulting Partners

EUROPE

Artefact

Artefact is a leading global consulting company dedicated to accelerating the adoption of data and AI to positively impact people and organizations. We specialize in data transformation and data marketing to drive tangible business results across the entire enterprise value chain. Our 2,000 employees operate across 33 offices in 26 countries (Europe, Americas, Asia, Middle East Africa) and we partner with 1000 clients, including 300 major brands like Samsung, L’Oréal, Orange and Sanofi.

NORTH AMERICA

Astrodata

Astrodata provides expert data engineering, analytics, software engineering and AI services to develop data + product strategy, implement embedded analytics and AI products, build scalable infrastructure, and elevate your customers' experience.

DACH

Codecentric

codecentric AG is a leading German IT consultancy with deep expertise in Data & AI. With our focus on Data Effectiveness, we have spent over 20 years empowering organizations to turn complex data challenges into measurable business value. We provide practical solutions along the entire data value chain—from AI strategy and data architecture to the implementation and operation of modern data platforms. With us, you turn technical possibilities into sustainable business success.

FRANCE

Corail Analytics

Nous sommes votre partenaire pour conduire la transformation vers une organisation plus data-driven, en vous accompagnant à chaque étape du chemin. Comment nous y parvenons : 1. Le business avant tout Chaque solution commence par vos besoins métiers, et nous gardons cet objectif en tête tout au long de notre mission. 2. Des outils qui s’adaptent à vous Les outils doivent s’adapter à vos contraintes, et non l’inverse. Défenseurs du Modern Data Stack, nous exploitons sa flexibilité pour répondre à vos besoins—aujourd’hui comme demain. Que vous construisiez une infrastructure data de zéro ou optimisiez une solution existante, nous vous aidons à déployer vos outils et former votre équipe pour atteindre une parfaite maitrise en un temps record. 3. Autonomiser vos équipes La donnée doit être une source de pouvoir, pas de frustration. Grâce à des formations sur mesure, des ateliers et des sessions de questions/réponses pratiques, nous veillons à ce que vos équipes deviennent autonomes et compétentes en matière d’analytique. Notre mission est accomplie lorsque vos collaborateurs se sentent confiants avec les données—et capables de générer des insights par eux-mêmes. Nos expertises : Analyse de données & BI, Self-Service Analytics, Embedded Analytics Data Platform, Migration, Projet data de bout en bout Ce qui nous rend unique : Avoir une équipe resserrée nous impose de ne faire aucun compromis sur l’expertise de nos consultants. Grâce à la diversité de nos profils, nous pouvons vous accompagner dans le renforcement de vos équipes pour tous vos projets data : de la conception et de l’infrastructure à la modélisation et l’analyse des données.

NORTH AMERICA

CorrDyn

CorrDyn is a data-driven technology consultancy that enables scalable and affordable growth.

EUROPE

Crescent

We empower your journey with data by assessing where you are, defining a strategy of where to go, and developing using expert knowledge. ## Assess Designing and assessing your current landscape helps us plot the best path with you to maximizing your data assets. ## Define We help you define a path through the data landscape, and craft a strategy that helps you win with data. ## Develop Our experts are able to execute at an accelerated pace using the latest methodologies.

NORTH AMERICA

Endeavor Labs

Endeavor Labs helps organizations realize the potential of data and AI to power digital transformation.

NORTH AMERICA

Shearwater

Shearwater is a specialized data consultancy focused on Self-Service Analytics founded by Looker alumni with 15+ years of experience in BI.

EUROPE

Tasman

Tasman is an analytics agency that turns data into meaningful business value. We partner with ambitious teams to build modern infrastructure, unlock the right insights, tackle migrations and AI implementation, and grow in-house analytics capabilities. Think of us as your fractional data team - experts in cutting-edge tools and practices, focused on accelerating your growth.

EUROPE

Xebia

Xebia is a pioneering Software Engineering and IT consultancy company, transforming and executing at the intersection of Domain and Technology to create digital leaders for our people, clients, partners, and communities.