Databases

MotherDuck integrates directly with popular databases to help you build data pipelines and applications.

Amazon Athena

Query the same S3 data you query with Amazon Athena from MotherDuck by attaching the AWS Glue Data Catalog, reading files directly, or using Athena UNLOAD.

Amazon Redshift

Move data from Amazon Redshift into MotherDuck by unloading Parquet to S3, or read Redshift Spectrum tables in place through the AWS Glue Data Catalog.

BigQuery

Load data from Google BigQuery into MotherDuck using the duckdb-bigquery community extension.

MongoDB

Load MongoDB collections into MotherDuck with dlt, by exporting newline-delimited JSON, or through a managed connector, and flatten documents into columns.

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.

Neon

Load data from Neon serverless Postgres into MotherDuck with DuckDB's PostgreSQL extension, and run the read against a Neon read replica to keep analytics off your application branch.

PlanetScale

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.

PostgreSQL

Advanced open-source relational database with powerful features and extensibility.

Snowflake

Move data from Snowflake into MotherDuck with a Python job that copies tables over Arrow, by unloading Parquet to object storage, or by attaching an Iceberg catalog both engines can read.

SQL Server

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.

Supabase

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.