# duckdb/pg_duckdb

DuckDB-powered Postgres for high performance apps & analytics.

Repository: https://github.com/duckdb/pg_duckdb
Canonical: https://ross.abutalabs.com/products/pg_duckdb
Language: C++
License: MIT
License Family: permissive
Last push: 2026-07-17T12:03:01+00:00

## Health v2 (maintenance only)
Score: 72/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 93, release rhythm 50, longevity 64
- inputs: {"age_days": 896, "days_push": 47, "days_rel": 259, "gap_med": 65, "n_releases_24m": 6}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3210, forks 200 (observed 2026-08-28T04:07:48.701252+00:00)

## What it is
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
- artifact type: plugin
- maturity: active
- function: database, analytics, etl
- domain: databases, analytics, big-data
- platform: self-hosted, cloud
- tags: postgresql-extension, duckdb, columnar-analytics, data-lake, parquet, olap, query-engine, data-engineering, linux, macos, docker

## Member repositories
- duckdb/pg_duckdb (main) score 72

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:48.701252+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:44:57.367702+00:00, confidence not recorded.
  - readme: https://github.com/duckdb/pg_duckdb (fetched 2026-08-28T04:07:48.701252+00:00, sha 5b91b1e8af85)
- Data as of 2026-08-30T08:39:29.467469+00:00.