DuckDB and MotherDuck support for PlanetScale Postgres
We've added support for the pg_duckdb extension for PlanetScale Postgres databases, along with native integration with MotherDuck.
pg_duckdb brings DuckDB's columnar analytics engine into Postgres so you can run OLAP queries alongside your OLTP workloads, create DuckDB-backed temporary tables, and query external data sources like Parquet and Iceberg.
When combined with MotherDuck, you can offload heavy analytics queries from your PlanetScale Postgres database to MotherDuck's cloud warehouse while still querying from within Postgres.