Integrations
MotherDuck integrates with a lot of common tools from the modern data stack.
If you would like to create a new integration, see this guide.
Below, you will find a comprehensive list of integrations that work with MotherDuck. Each integration includes links to either our own detailed tutorials, the integrator's documentation, or insightful articles and blogs that can help you get started.
info
When working with integrations, it may be useful to be aware of the different connection string parameters you can use to connect to MotherDuck.
Supported Integrations
Use the search box to find specific integrations or click on category tags to filter the table.
Filter by category
| Integration | Category | Description | Resources |
|---|---|---|---|
Airbyte | Ingestion | Airbyte is a data integration platform for connecting data sources to warehouses. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Airflow | Orchestration | Open-source data orchestration and scheduling platform for building ETL pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. | |
Amazon S3 | Cloud Storage | Amazon S3 is a Data Sources/Sinks service for storing and retrieving data. | |
Apache Iceberg | File Formats | MotherDuck supports the Apache Iceberg format through the DuckDB Iceberg extension. The extension is loaded automatically when Iceberg functions or catalogs are used in your current MotherDuck session. | |
Artie | Ingestion | Artie is a fully managed CDC streaming platform that allows you to replicate data from your source database to your destination in real-time. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Ascend.io | Ingestion | Ascend.io is a data integration platform for connecting data sources to warehouses. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Astronomer | Orchestration | Astronomer is a platform for authoring, scheduling, and monitoring workflows. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. | |
AWS Glue | Ingestion | AWS Glue is a serverless data integration service for preparing and moving data with Spark jobs, crawlers, and the AWS Glue Data Catalog. AWS Glue jobs can connect to MotherDuck through the MotherDuck Postgres endpoint using Glue's PostgreSQL JDBC support. | |
Azure Blob | Cloud Storage | Azure Blob is a Data Sources/Sinks service for storing and retrieving data. | |
Bacalhau | Orchestration | Bacalhau is a platform for running and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. | |
BigQuery | Databases | BigQuery is Google Cloud's fully-managed, serverless data warehouse that enables SQL queries using the processing power of Google's infrastructure. | |
Bytewax | Ingestion | Bytewax is a stream processing platform for building and managing data pipelines. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Cloudflare R2 | Cloud Storage | Cloudflare R2 is a Data Sources/Sinks service for storing and retrieving data. | |
Cloudflare Workers | Serverless Compute | Cloudflare Workers is an edge compute platform for running serverless functions globally. Workers can connect to MotherDuck through the Postgres endpoint using the pg npm package. | |
CloudQuery | Ingestion | CloudQuery is a data integration platform for connecting data sources to warehouses. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
CSV | File Formats | CSV is a simple text format for tabular data. DuckDB can read CSV files from local paths, HTTPS URLs, and supported cloud storage locations, then load the results into MotherDuck tables. | |
Cube | Business Intelligence Tools | Cube is a semantic layer for building and visualizing data. It integrates with MotherDuck for dashboards, semantic models, and embedded analytics workflows. | |
Dagster | Orchestration | Dagster is a platform for authoring, scheduling, and monitoring workflows. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. | |
Data Wisp | Business Intelligence Tools | Data Wisp is an AI data assistant for answering business questions in natural language. It integrates with MotherDuck for conversational analytics workflows. | |
DataGrip | SQL IDEs | JetBrains DataGrip is a cross-platform IDE for working with SQL and noSQL databases. It includes a DuckDB integration, which makes connecting to MotherDuck easy. | |
Datalab | Data Science & AI | Interactive data science platform for exploring and analyzing data with MotherDuck. It integrates with MotherDuck for notebooks, assistants, and AI-powered analysis workflows. | |
DBeaver | SQL IDEs | DBeaver Community is a free cross-platform database integrated development environment (IDE). It includes a DuckDB integration, so it is a great choice for querying MotherDuck. | |
dbt cloud | Data Transformation | dbt cloud is a managed service for dbt core. MotherDuck is used with dbt cloud by deploying a Postgres proxy with pg_duckdb installed. | |
dbt core | Data Transformation | Data Build Tool (dbt) is an open-source command-line tool that enables data analysts and engineers to transform data in their warehouses by defining SQL in model files. It bring the composability of programming languages to SQL while automating the mechanics of updating tables. | |
Delta Lake | File Formats | MotherDuck supports querying data in the Delta Lake format. The Delta DuckDB extension is loaded automatically when any of the supported Delta Lake functions are called. | |
dlt | Ingestion | dlt is an open-source Python library that loads data from various, often messy data sources into well-structured, live datasets. It offers a lightweight interface for extracting data from REST APIs, SQL databases, cloud storage, Python data structures, and many more. | |
Dot | Business Intelligence Tools | AI data analyst that answers questions and provides insights through conversational analytics. It integrates with MotherDuck for dashboards, semantic models, and embedded analytics workflows. | |
DuckDB UI | SQL IDEs | DuckDB UI is a local SQL interface for DuckDB. You can use it with MotherDuck when you want a lightweight SQL workspace backed by the DuckDB CLI and an md: connection. | |
DuckLake | File Formats | DuckLake is an integrated data lake and catalog format for large scale data analytics. | |
Estuary | Ingestion | Real-time data integration platform for streaming data between systems. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Evidence | Business Intelligence Tools | Evidence is an open source, code-based alternative to drag-and-drop BI tools. Build polished data products with just SQL and markdown. | |
Excel | File Formats | Excel workbooks can be loaded through DuckDB's Excel extension and stored in MotherDuck for repeatable SQL analysis. | |
Expanso | Ingestion | Data integration platform for connecting data sources to warehouses. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Explo | Business Intelligence Tools | Explo is a platform for embedded analytics, AI analytics, and data sharing in customer-facing products. It integrates with MotherDuck as a data source. | |
Fabi.ai | Data Science & AI | Fabi.ai is an AI-native notebook and BI workspace for Python, SQL, dashboards, and workflows. It integrates with MotherDuck for exploration and analysis. | |
Fivetran | Ingestion | Automated data integration platform for connecting data sources to warehouses. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Fivetran Activations (formerly Census) | Reverse ETL | Fivetran Activations, formerly Census, syncs modeled data from a warehouse or database into operational and customer engagement tools. MotherDuck is available as a source in Fivetran Activations, which means Activations can read from MotherDuck and sync selected data to supported activation destinations. | |
Go Driver | Language APIs and Drivers | Official Go driver for MotherDuck, enabling seamless integration with Go applications. The go-duckdb driver supports MotherDuck out of the box! | |
Gooddata | Business Intelligence Tools | Enterprise analytics platform for building data products and embedded analytics. It integrates with MotherDuck for dashboards, semantic models, and embedded analytics workflows. | |
Google Colab | Data Science & AI | Google Colab notebooks can query MotherDuck by installing DuckDB and opening an md: connection from Python. | |
Google Data Sources/Sinks | Cloud Storage | With MotherDuck, you can access files in a private Google Cloud Storage (GCS) bucket. This leverages the GCS S3 compatible connection. | |
Google Sheets | File Formats | Google Sheets is a hosted spreadsheet application for collaborative tabular data. | |
Grafana | Business Intelligence Tools | Grafana is an observability and dashboarding platform for building dashboards, alerts, and exploratory views. The MotherDuck-maintained DuckDB data source plugin lets Grafana query local DuckDB files and MotherDuck databases. | |
Great Expectations | Data Quality Tools | Great Expectations is a data quality management platform combining data quality and data governance. It integrates with MotherDuck for table monitoring as part of data quality and observability workflows. | |
Hetzner Object Storage | Cloud Storage | Hetzner Object Storage is a S3-compatible object storage service. | |
Hevo | Ingestion | Hevo is a data integration platform for connecting data sources to warehouses. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Hex | Data Science & AI | Hex is a software platform for collaborative data science and analytics using Python, SQL and no-code. | |
Holistics | Business Intelligence Tools | 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. It integrates with MotherDuck for dashboards, semantic models, and embedded analytics workflows. | |
InfinyOn | Ingestion | Real-time data integration platform for streaming data between systems. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
JDBC | Language APIs and Drivers | Java Database Connectivity (JDBC) driver for connecting Java applications to MotherDuck. The official DuckDB JDBC driver supports MotherDuck out of the box! | |
JSON | File Formats | JSON is a common format for semi-structured data. DuckDB can read JSON files and load the results into MotherDuck for SQL analytics. | |
Jupyter | Data Science & AI | Jupyter notebooks can query MotherDuck through the DuckDB Python package and an md: connection string. | |
Kestra | Orchestration | Open-source data orchestration and scheduling platform for building ETL pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. | |
LangChain | Data Science & AI | LangChain is a framework for building and deploying language models. It integrates with MotherDuck for notebooks, assistants, and AI-powered analysis workflows. | |
LlamaIndex | Data Science & AI | LlamaIndex is a framework for building and deploying language models. It integrates with MotherDuck for notebooks, assistants, and AI-powered analysis workflows. | |
Mage | Ingestion | Mage is a data integration platform for connecting data sources to warehouses. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Marimo | Data Science & AI | 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. | |
MCP Server | Data Science & AI | MotherDuck's fully managed remote MCP server, hosted at https://api.motherduck.com/mcp. A self-hosted local MCP server is also available for local DuckDB files and custom configurations. | |
Metabase | Business Intelligence Tools | Metabase is an open source analytics/BI platform that provides intuitive data visualization and exploration capabilities. This guide details how to connect Metabase to both local DuckDB databases and MotherDuck. | |
Microsoft Excel | Business Intelligence Tools | Use Excel's 'Get Data' flow with the DuckDB ODBC driver to load MotherDuck data into Excel. This setup works well for recurring reporting, analysis, ad hoc SQL exploration, finance models, and operational dashboards without relying on exported CSVs. | |
Monte Carlo | Data Quality Tools | End-to-end data observability platform for monitoring data quality and reliability. It integrates with MotherDuck for table monitoring as part of data quality and observability workflows. | |
MySQL | Databases | MySQL is a relational database commonly used for application data. DuckDB's MySQL extension can read from MySQL-compatible databases, which lets you copy selected data into MotherDuck from a DuckDB client. | |
Node.js | Language APIs and Drivers | The DuckDB Node.js client can connect to MotherDuck with an md: connection string, so JavaScript and TypeScript applications can query MotherDuck directly. | |
Obsidian | Dev Tools | Run DuckDB and MotherDuck SQL inside Obsidian notes and freeze the results as markdown tables. | |
Omni | Business Intelligence Tools | Modern business intelligence platform for creating interactive dashboards and data visualizations. It integrates with MotherDuck for dashboards, semantic models, and embedded analytics workflows. | |
OneSignal | Reverse ETL | Customer engagement platform for delivering personalized, real-time messages across multiple channels based on user behavior. It integrates with MotherDuck for syncing modeled MotherDuck data into operational and customer engagement tools. | |
Orchestra | Orchestration | Orchestra is a platform for building and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. | |
Paradime | Data Transformation | Modern data transformation platform for building and managing data pipelines. It integrates with MotherDuck for running data transformation projects against MotherDuck. | |
Parquet | File Formats | Parquet is a columnar file format designed for analytics. DuckDB can query Parquet files directly and persist the result as a MotherDuck table. | |
PlanetScale | Databases | PlanetScale offers hosted PostgreSQL and MySQL Vitess Databases. MotherDuck supports PlanetScale Postgres via the pg_duckdb extension, as well as the Postgres Connector. In our internal benchmarking, pg_duckdb offers 100x or greater query acceleration for analytical queries when compared to vanilla Postgres. | |
Polytomic | Ingestion | Polytomic runs ETL and reverse ETL syncs between MotherDuck and SaaS apps, databases, cloud storage, and spreadsheets. | |
PostgreSQL | Databases | Advanced open-source relational database with powerful features and extensibility. | |
Power BI | Business Intelligence Tools | Power BI is an interactive data visualization product developed by Microsoft. You can connect Power BI to MotherDuck through the built-in PostgreSQL database connector using MotherDuck's Postgres endpoint. | |
Prefect | Orchestration | Prefect is a platform for authoring, scheduling, and monitoring workflows. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. | |
Puppygraph | Dev Tools | Graph visualization tool for exploring and analyzing data relationships in DuckDB. It integrates with MotherDuck for development workflows that read from or write to MotherDuck. | |
Python | Language APIs and Drivers | Python is a programming language for building and deploying web applications. | |
R | Language APIs and Drivers | R is a language for statistical analysis. | |
Retool | Dev Tools | Low-code platform for building internal tools and custom business applications with drag-and-drop UI components. | |
Rill Data | Business Intelligence Tools | Rill Data is a data platform for building and visualizing data. It integrates with MotherDuck for dashboards, semantic models, and embedded analytics workflows. | |
Salesforce | Ingestion | Salesforce is a CRM platform for sales, marketing, service, and customer data. To analyze Salesforce data in MotherDuck, use an ingestion tool that supports Salesforce as a source and MotherDuck as a destination. | |
Secoda | Data Quality Tools | Data discovery and documentation platform for managing data quality and governance. It integrates with MotherDuck for table monitoring as part of data quality and observability workflows. | |
ShadowTraffic | Dev Tools | ShadowTraffic is a synthetic data generation tool for simulating production traffic to your backend. It integrates with MotherDuck for development workflows that read from or write to MotherDuck. | |
Sling | Ingestion | Data integration platform for connecting data sources to warehouses. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Soda | Data Quality Tools | Data quality platform for monitoring and managing data quality in your pipelines. It integrates with MotherDuck for table monitoring as part of data quality and observability workflows. | |
SQL Server | Databases | Use the SQL Server replication guide when you need to read tables or queries from SQL Server and write the results to MotherDuck. The guide covers Python, pyodbc, SQL Server authentication, and loading dataframe results into MotherDuck. | |
SQLAlchemy | Language APIs and Drivers | SQLAlchemy is a SQL toolkit and Object-Relational Mapping (ORM) system for Python, providing full support for SQL expression language constructs and various database dialects. A lot of Business Intelligence tools supports SQLAlchemy out of the box. | |
SQLMesh | Data Transformation | SQLMesh is a data transformation tool for building and managing data pipelines. It integrates with MotherDuck for running data transformation projects against MotherDuck. | |
Stacksync | Ingestion | Stacksync helps your teams access and manipulate CRM and ERP data through your existing databases. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Streamkap | Ingestion | Streamkap is a stream processing platform built for Change Data Capture (CDC) and event sources. It makes it easy to move operational data into analytics systems like MotherDuck with low latency and high reliability. Streamkap offers various sources, including PostgreSQL, MySQL, SQL Server, a range of SQL and NoSQL databases, Kafka, and other storage systems. | |
Streamlit | Web Development | Streamlit is a web development platform for building and visualizing data. It integrates with MotherDuck for applications that query MotherDuck through a supported server-side connection. | |
Supabase | Databases | Supabase is a Postgres platform for building applications with a managed database, APIs, authentication, storage, and realtime features. Supabase's documented DuckDB Wrapper can query MotherDuck from a Supabase Postgres database through a foreign data wrapper. | |
Superset | Business Intelligence Tools | Apache Superset is a powerful, open-source data exploration and visualization platform designed to be intuitive and interactive. It allows data professionals to quickly integrate and analyze data from various sources, creating insightful dashboards and charts for better decision making. | |
Tableau | Business Intelligence Tools | Tableau is a widely-used business intelligence and data visualization platform that enables data analysts to build interactive dashboards and reports. You can connect Tableau Cloud to MotherDuck through the built-in PostgreSQL connector using MotherDuck's Postgres endpoint. For Tableau Desktop and Server, use the DuckDB JDBC connector. | |
Tigris | Cloud Storage | With MotherDuck, you can access files in a private Tigris bucket. Tigris is a globally distributed S3-compatible object storage service that provides low latency anywhere in the world. | |
Union.ai | Orchestration | Union.ai is a platform for building and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. | |
Unstructured.io | Ingestion | Unstructured.io is an ingestion platform for processing unstructured data. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams. | |
Vanna | Dev Tools | Vanna is a data science and AI framework for building and sharing data applications. It integrates with MotherDuck for development workflows that read from or write to MotherDuck. | |
Vercel | Web Development | Vercel is a web development platform for building and deploying web applications. | |
WASM Client | Web Development | WebAssembly client for running MotherDuck in the browser. | |
Wasm SDK | Language APIs and Drivers | Wasm SDK lets your run apps in your browser in order to run MotherDuck in the browser. | |
Windmill | Orchestration | Windmill is a platform for building and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows. | |
Wobby | Data Science & AI | Wobby provides AI analysts for delivering business-ready insights in Slack or Teams. It integrates with MotherDuck for connecting those analysis workflows to your data. | |
Zenlytic | Business Intelligence Tools | Zenlytic is a data visualization platform for building and visualizing data. It integrates with MotherDuck for dashboards, semantic models, and embedded analytics workflows. |
note
See DuckDB documentation for the full list of supported client APIs and drivers.
Diagram: Modern Duck Stack
