TechPrufer
Get started
PlanetScale
PlanetScale logoPlanetScale · Feature trail

DuckDB Integration for Analytics

1 post · Dec 2025

What this trail covers

PlanetScale now supports the pg_duckdb extension, allowing users to run DuckDB analytics queries directly within their PlanetScale Postgres databases. This enables seamless integration of OLTP and OLAP workloads, with the option to offload query execution to MotherDuck's cloud data warehouse. This feature simplifies data movement and unifies the experience of combining analytics results with relational data.

All PlanetScale trails
  1. Using MotherDuck with PlanetScaleThis post introduces the integration of the pg_duckdb extension with PlanetScale Postgres databases. It details how to enable the extension, grant necessary permissions, and configure it to work with MotherDuck. The post explains the benefits of combining DuckDB's column-store analytics engine with Postgres's OLTP capabilities, and how offloading queries to MotherDuck can separate analytical compute from application performance.