duckdb/dbt-duckdb

Health v2 · maintenance only

Adoption not part of the score

1341 stars · 145 forks observed · 2026-08-28

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

dbt-duckdb is the dbt adapter plugin for DuckDB, an embedded OLAP database. It lets you run dbt data transformation pipelines in SQL or Python against DuckDB files or in-memory databases, enabling a 'modern data stack in a box'.

Use cases

• run dbt transformations on a local duckdb file
• build a modern data stack in a box
• transform csv and parquet files with dbt
• test data pipelines locally or in CI
• build a simple data lakehouse with python and sql
• persist dbt docs as duckdb column comments

When to choose

• you want dbt-based analytics transformations without a server or cloud warehouse
• you work with local CSV, JSON, or Parquet files and want SQL-based modeling
• you need fast, lightweight pipelines for local development or CI testing

When to avoid

• you need a distributed, multi-user warehouse like Snowflake, BigQuery, or Spark
• your pipelines require concurrent writers to the same DuckDB file
• you don't use dbt for data transformations

Facets

plugin · maturity active

etl database data-science developer-tools analytics databases developer-tools python cli cross-platform dbt duckdb sql analytics-engineering data-transformation adapter data-engineering

Member repositories

For agents

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