duckdb/pg_duckdb

Health v2 · maintenance only

Adoption not part of the score

3210 stars · 200 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

pg_duckdb is an official PostgreSQL extension that embeds DuckDB's columnar-vectorized analytics engine inside Postgres. It lets users run analytical SQL queries directly against existing Postgres tables and external data lake files (Parquet, CSV, JSON, Iceberg, Delta Lake) without exporting data.

Use cases

• run fast analytical queries on existing postgres tables
• query parquet and csv files in s3 from postgres
• accelerate olap workloads without moving data out of postgres
• read iceberg and delta lake tables from a postgres database
• use motherduck as a compute provider from postgres
• build high performance analytics apps on postgres

When to choose

• you want in-database analytics acceleration on postgres without exporting data
• you need to query data lake files like parquet or iceberg directly from SQL
• you want duckdb's execution engine with postgres compatibility

When to avoid

• you need a standalone analytics database rather than a postgres extension
• your workload is purely transactional (OLTP) with no analytical queries
• you cannot install extensions on your managed postgres service

Facets

plugin · maturity active

database analytics etl databases analytics big-data self-hosted cloud postgresql-extension duckdb columnar-analytics data-lake parquet olap query-engine data-engineering linux macos docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="duckdb/pg_duckdb")