The Database Inside Your Lakehouse: A DuckLake Architecture Deep DiveLivestream July 9

START FREE

Meet the Flockers

Discover the power of partnership with motherduck’s extensive ecosystem

Technology Partners

AllIngestionBusiness IntelligenceData Science & AIReverse ETLAI AgentsOrchestrationData QualityTransformationDev ToolsData Apps

Airbyte's logo

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.

Docs

Blog

AirFlow's logo

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.

Docs

Artie's logo

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.

Docs

Want to join the flock?

Bring your product or expertise to the MotherDuck ecosystem and reach a growing community of data teams.

Astrato Analytics's logo

Astrato Analytics

Astrato is a warehouse-native BI platform that lets teams build pixel-perfect, interactive dashboards directly on their cloud data. Purpose-built for customer-facing and embedded analytics, Astrato combines a semantic layer, white-labelling, and automated reporting so BI teams can ship governed analytics to external stakeholders without writing code. ## Astrato + MotherDuck Astrato integrates with MotherDuck to deliver production-grade embedded analytics using an intuitive drag-and-drop builder. Teams create pixel-perfect, white-labelled dashboards that query MotherDuck in real time – zero data extracts, zero infrastructure to manage. The integration is built for teams that want to monetize their data: building customer-facing analytics products, offering premium data experiences, or embedding interactive reporting directly into their applications. Astrato queries MotherDuck live, keeping governance intact while MotherDuck's per-second billing ensures costs stay predictable as you scale. Key capabilities: pixel-perfect dashboarding, multi-tenant security with SSO pass-through, automated scheduled reporting (branded PDF, Excel, PowerPoint), and iframe embedding — all without code.

Astronomer's logo

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.

Blog

Docs

Bruin's logo

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.

Docs

Docs

ChatGPT's logo

AI AGENTS

ChatGPT

ChatGPT is OpenAI's conversational AI assistant, powered by the GPT family of large language models. Used by hundreds of millions of people for analysis, coding, content generation, and research, ChatGPT is available through chatgpt.com, the OpenAI API, and a growing ecosystem of connectors and integrations. ## ChatGPT + MotherDuck MotherDuck integrates with ChatGPT in two complementary ways. First, MotherDuck is available as a connector for ChatGPT, allowing users to connect their MotherDuck data warehouse directly to ChatGPT and explore their data with natural language — no SQL required. ChatGPT acts as an AI-powered data analyst, iterating through exploration, validation, and visualization to surface answers from your MotherDuck databases. Second, GPT models — the same models that power ChatGPT — can be used as a provider for MotherDuck's in-database AI SQL functions (such as `prompt()`), letting analysts call GPT directly from SQL to summarize, classify, extract, and enrich data at the row level without moving data out of the warehouse. Together, these integrations combine ChatGPT's frontier intelligence with MotherDuck's serverless DuckDB engine to make data analysis accessible to every team member.

Docs

Docs

Claude's logo

AI AGENTS

Claude

Claude is Anthropic's family of large language models, designed to be helpful, harmless, and honest. Used across industries for tasks ranging from analysis and coding to content generation and research, Claude is available through claude.ai, the Claude API, and a growing ecosystem of connectors and integrations. ## Claude + MotherDuck MotherDuck is available as a connector on Claude.ai, allowing users to connect their MotherDuck data warehouse directly to Claude. With this integration, users can explore and analyze their data using natural language — no SQL skills required. Claude acts as an AI-powered data analyst, iterating through exploration, validation, and visualization to surface useful answers from your MotherDuck databases. The connector provides safe, read-only access and works with messy, real-world data without requiring a semantic model or pre-configuration. Whether you're listing tables, querying top customers by revenue, or searching your data catalog for churn-related datasets, Claude and MotherDuck together make data accessible to every team member.

Docs

Docs

CloudQuery's logo

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.

Blog

Cube's logo

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.

Blog

Video

Docs

Cursor's logo

AI AGENTS

Cursor

Cursor is an AI code editor built for pair-programming with large language models. It combines a familiar VS Code-style editing experience with deeply integrated AI features — codebase-aware chat, multi-file edits, and agentic workflows — letting developers move from intent to working code without leaving the editor. ## Cursor + MotherDuck Cursor connects to MotherDuck through the Model Context Protocol (MCP). By adding MotherDuck's MCP server to Cursor, the editor's AI agent can explore database schemas, run SQL queries, and reason about real data while writing or refactoring code. This integration combines Cursor's agentic coding capabilities with MotherDuck's serverless DuckDB engine, so developers can build data-aware applications and analytics workflows with live feedback from their warehouse.

Docs

Dagster's logo

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.

Docs

Blog

Datagrip's logo

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.

Docs

Docs

DataLab's logo

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.

Docs

dbt's logo

TRANSFORMATION

dbt

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.

Blog

Video

Video

Docs

Video

Video

Case Study

dlt's logo

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.

Blog

Estuary's logo

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.

Blog

Docs

Evidence's logo

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.

Docs

Video

Video

Fivetran's logo

INGESTION

REVERSE ETL

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.

Docs

Blog

GoodData's logo

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.

Docs

Docs

Blog

Google CoLab's logo

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.

Hevo's logo

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.

Docs

Hex's logo

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.

Video

Docs

Kestra's logo

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.

Blog

LangChain's logo

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.

Docs

Lightdash's logo

BUSINESS INTELLIGENCE

Lightdash

Lightdash is an open-source business intelligence tool that turns your dbt project into a full-featured BI platform. It lets data teams define metrics and dimensions directly in dbt, then explore, visualize, and share insights through interactive dashboards and charts—keeping the entire analytics layer version-controlled and governed as code. ## Lightdash + MotherDuck Lightdash integrates with MotherDuck, querying your data directly from the MotherDuck cloud. This integration lets teams build self-serve dashboards and explores on top of MotherDuck, combining Lightdash's dbt-native, metrics-as-code approach with MotherDuck's serverless DuckDB performance and scalable cloud analytics.

Docs

Livedocs's logo

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.

Docs

LlamaIndex's logo

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.

Docs

Looker's logo

BUSINESS INTELLIGENCE

Looker

Looker is a cloud-based business intelligence and analytics platform from Google Cloud that lets organizations explore, analyze, and share real-time business insights. It uses a semantic modeling layer (LookML) to define consistent metrics across the organization and supports interactive dashboards, embedded analytics, and a wide range of database connections. ## Looker + MotherDuck Looker integrates with MotherDuck through the Postgres endpoint, which exposes MotherDuck to Looker as a Postgres-compatible connection. This integration enables analytics teams to model their MotherDuck data in LookML and serve dashboards backed by MotherDuck's serverless DuckDB engine, combining Looker's governed semantic layer with the speed and cost efficiency of MotherDuck. ## Customer Success Stories Operations and analytics teams use Looker with MotherDuck: - **[Trunkrs](/case-studies/trunkrs-same-day-delivery-motherduck-from-redshift/)** migrated 700GB from Redshift to MotherDuck and uses pg_duckdb as a proxy for Looker, making live operational dashboards "a lot snappier" for their daily day-start meetings.

Docs

Case Study

Lovable's logo

AI AGENTS

Lovable

Lovable is an AI app builder that turns natural-language prompts into full-stack web applications. Developers and non-developers alike can describe what they want and Lovable's agent generates a working React + Vite + Tailwind app — iterating on UI, logic, and data layers through conversation rather than hand-written code. ## Lovable + MotherDuck Lovable connects to MotherDuck through the Model Context Protocol (MCP), letting Lovable's AI agent — and the apps it builds — access MotherDuck databases as a live data source. With MotherDuck's MCP server, Lovable can explore schemas, run SQL queries, and wire the results into the app being generated, all from a natural-language prompt. The result is AI-built data apps backed by MotherDuck's serverless DuckDB engine, with no manual connector code or boilerplate to write.

Docs

Mage's logo

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.

Blog

Marimo's logo

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.

Docs

Blog

Meltano's logo

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.

Video

Metabase's logo

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.

Docs

Docs

Microsoft Power BI's logo

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.

Docs

Monte Carlo's logo

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.

Docs

Blog

Omni's logo

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.

Blog

Docs

Paradime's logo

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.

Blog

Docs

Polytomic's logo

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.

Docs

Portable's logo

INGESTION

Portable

Portable is a no-code ELT platform specializing in long-tail data connectors for hard-to-reach SaaS and operational data sources. With a catalog of 1,300+ pre-built connectors and on-demand custom connector development, Portable lets data teams move data from niche applications into their warehouse without engineering effort. ## Portable + MotherDuck Portable integrates with MotherDuck by loading data from any of its connectors directly into a MotherDuck database. This integration enables analytics teams to centralize data from long-tail SaaS sources alongside their core operational data, combining Portable's breadth of connectors with MotherDuck's serverless DuckDB compute for fast, isolated analytics on a unified dataset.

Preset's logo

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.

Blog

Docs

Video

PuppyGraph's logo

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.

Blog

Docs

Querio's logo

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.

Docs

Retool's logo

DATA APPS

Retool

Retool is a low-code platform for building internal tools, dashboards, and data apps quickly. Developers compose UIs from a library of drag-and-drop components and wire them up to databases, APIs, and queries with JavaScript and SQL — turning back-end data into operational interfaces without building a full front-end from scratch. ## Retool + MotherDuck Retool integrates with MotherDuck as a native data source, letting builders connect a Retool app directly to a MotherDuck database and run SQL queries against it. This integration enables teams to ship internal tools and operational apps backed by MotherDuck's serverless DuckDB engine, combining Retool's UI-building speed with MotherDuck's fast, cost-efficient analytics.

Docs

Rill Data's logo

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.

Blog

Docs

Video

Sling Data's logo

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.

Docs

Soda's logo

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.

Docs

SQLMesh's logo

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.

Docs

Blog

Streamlit's logo

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.

Video

Video

Docs

Superset's logo

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.

Docs

Video

Tableau's logo

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.

Blog

Docs

Docs

Zenlytic's logo

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.

Docs

Consulting Partners

Artefact's logo

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.

Blog

Blog

Codecentric's logo

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.

Blog

Blog

Blog

Corail Analytics's logo

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.

Blog

Build with MotherDuck

Join the MotherDuck ecosystem and reach a fast-growing community of data teams.