awesome-duckdb

Official DuckDB documentation

Official DuckDB blog

Client APIs for DuckDB

The DuckDB documentation as a single PDF file

The DuckDB documentation as a single Markdown file

docker-duckdb

Docker image for DuckDB CLI

GitHub Action to install DuckDB in CI

Serverless DuckDB over S3

Running DuckDB over a data lake on S3 using lambda

Collection of snippets curated by MotherDuck

DuckDB's entry in , available in CLI via the command

DuckDB AWS Lambda layer

Run DuckDB in AWS Lambda functions

Extensions specifically compiled for the AWS Lambda runtime (GLIBC 2.26)

Serverless DuckDB as API

Use DuckDB as API with Amazon API Gateway and AWS Lambda

Serverless Parquet Repartitioner

Use DuckDB to repartition data in S3-based Data Lakes

Notebooks using DuckDB on the Observable data visualization platform

duckdb-nf

Example uses of DuckDB with Nextflow

DuckDB version manager (duckman)

– Cross-platform installer and version manager for DuckDB

DuckERD CLI

– A CLI tool to create an ER Diagram from DuckDB database files

SQL notebooks by TimerStored powered by DuckDB

DuckDB logos

Monochrome DuckDB icon in Iconify

Rill Developer

Tool for effortlessly transforming data sets into powerful, opinionated dashboards using SQL

A DataFrame API for interacting with DuckDB (and other compute engines)

Serverless data analytics overlay on top of S3 Data Lakes

Hex's Dataframe SQL cells are powered by DuckDB

Mode uses DuckDB for their in-memory data engine

DuckDB can be used as a caching layer or a data connector in VulcanSQL, a Data API framework for data folks to create REST APIs by writing SQL templates

A fast, free, cross-platform tabular data viewer application powered by DuckDB

A browser-based geospatial analysis tool leveraging DuckDB Wasm

A serverless data transformation platform for data lakes

Malloy is an experimental language for describing data relationships and transformations. Malloy connects to BigQuery, Snowflake, Trino, and Postgres, and natively supports DuckDB

Generate reports using SQL and markdown. The DuckDB connector allows querying across DuckDB, csv, parquet and json

Latitude uses DuckDB to power data snapshots. Drop a CSV file and query it with SQL at the speed of light

Census's dataset diffing for incremental syncs is powered by DuckDB

Huey

Blazing-fast & intuitive pivot tables on .parquet, .csv, .json files and .duckdb tables in the browser based on DuckDB WASM. Open source (MIT). Zero install!

Visual Studio Code extension for exploring Parquet files with SQL, powered by DuckDB

Data quality platform for data engineers, data quality teams and data operations

DatalakeStudio

Load, explore, transform your datasets and expose them via API. Integration with external APIs, S3, PostgreSQL and ChatGPT

Spice.ai

A unified SQL query interface and portable runtime to locally materialize (using an embedded DuckDB), accelerate, and query datasets from any database, data warehouse, or data lake

Definite pulls all your data into a single place for analytics and dashboards. No engineering or SQL required. Get a managed data warehouse (DuckDB), ELT, data modeling / transformations and BI in a single platform

Amphi ETL

Low-code data pipelines for structured and unstructured data. SQL transformations are powered by DuckDB

Quackpipe

Serverless OLAP API/UI built on top of DuckDB with basic ClickHouse API compatibility and Motherduck support

UniverSQL

An implementation of Snowflake API, enables running queries on Snowflake tables locally with DuckDB without a running warehouse

Whereabouts

Fast, accurate, open-source geocoding in Python, using DuckDB

Phoenix Analytics

Plug and play analytics for Phoenix applications, powered by DuckDB

sqlglot

Python transpiler that translates between 23 different SQL dialects including DuckDB

yato

The smallest DuckDB SQL orchestrator on Earth

SQLMesh

A next-generation data transformation and modeling framework with support for DuckDB connections for state, transformations & running unit tests locally

Online DuckDB shell powered by WebAssembly

DuckDB-WASM based SQL Workbench for running queries on local or remote data, being able to show data as tables or visually as graphs, and sharing queries via URLs

Query your local parquet, csv, json. Your data will not be sent out of the device you are using

Free tool to explore and share insights from CSV files using SQL. Import data, write SQL, then instantly share it with anyone

Embed executable code snippets directly into your product documentation, online course or blog post

Open-source online DuckDB SQL playground and editor

WhatTheDuck is an open-source web application built on DuckDB. It allows users to upload CSV files, store them in tables, and perform SQL queries on the data

Sidequery is a privacy-preserving DuckDB-powered query editor & data exploration tool for local & remote data

DuckDB API

a TypeScript-based Docker image containing DuckDB, and a Hono framework REST API with JSON or streaming Arrow responses

A Python-based server that runs a local DuckDB instance and support queries over Web Sockets or HTTP, returning data in either Apache Arrow or JSON format

A Rust-based server that runs a local DuckDB instance and support queries over Web Sockets or HTTP/HTTPS, returning data in either Apache Arrow or JSON format

An extensible framework for linking databases and interactive views

Fugue

A unified interface for distributed computing. Fugue executes SQL, Python, Pandas, and Polars code on Spark, Dask and Ray without any rewrites

A free Python library for fast, accurate data deduplication and record linkage

Simple-data-analysis

Easy-to-use and high-performance JavaScript library for data analysis

pg_analytics

PostgreSQL extension embedding DuckDB-in-Postgres for fast on-disk and remote object storage analytics from Postgres. Built as a Foreign Data Wrapper with full query pushdown to DuckDB

duckdb_fdw

DuckDB Foreign Data Wrapper for PostgreSQL

@jetblack/duckdb-react

A context manager for React and duckdb-wasm

QuackOSM

A Python library for downloading and transforming raw OpenStreetMap data into GeoParquet files

A Python library that turns your dataframe into an interactive UI for data visualization

[ API Framework heavily relies on the power of DuckDB and DuckDB extensions. Ready to build performant and cost-efficient APIs on top of BigQuery or Snowflake for AI Agents and Data Apps

The DuckDB IDE for your terminal. ( )

A free SQL tool specialized for data analysts. It runs on every operating system and allows easy browsing of tables and charting of results

Free DuckDB SQL Tools for VS Code IDE. with advanced features

Free open-source VSCode extension to query and explore your DuckDB databases with latest DuckDB support

DBeaver is a universal database access and development tool that can be used to connect almost any type of database

Paid SQL IDE by Jetbrains that supports many different database technologies, including DuckDB

Duckling

A fast viewer for CSV/Parquet files and DuckDB/SQLite, based on Tauri

rsql

CLI for DuckDB, LibSQL, MariaDB, MySQL, PostgreSQL, SQLite3 and SQL Server

jsqltranspiler

Rewrite BigQuery, Redshift, Snowflake and Databricks queries into DuckDB compatible SQL

Type safe querying of DuckDB (and many other RDBMS) from Java. A from and to DuckDB is also available

A lightweight, commercial SQL IDE that supports different DBMS, including DuckDB. The focus on performance and special DBMS features

Simple easy-to-use database manager, supports DuckDB, PostgreSQL, MySQL, SQL Server, SQLite etc

manifold-sql (DuckDB for Java)

Use native DuckDB SQL of any complexity directly & type-safely in Java source with comprehensive IntelliJ support

DuckDB CLI client for the Termux Android terminal emulator

NBA Monte Carlo

Monte Carlo simulation of the NBA season, leveraging Meltano, dbt, DuckDB and Evidence

Datadex

Open source and local friendly data platform to collaborate on Open Data using DuckDB, Dagster, dbt, and Quarto

Daily dumps of endoflife.date data

transfermarkt-datasets

Curated football datasets from

duckDB-embedding-search

A search engine for DuckDB that uses embedding vectors to find similar documents

( ) - Live dashboard of PyPI downloads using DuckDB, dbt, Evidence and MotherDuck with code source to build your own

Specter

Specter is a CLI tool to search and monitor Databricks audit logs

dbt-duckdb

DuckDB dbt adapter

Extract and load data from APIs to DuckDB using dlt

Load data to DuckDB based on Singer spec

Load data to DuckDB with Airbyte

Run queries with DuckDB to schedule data transformations and process automations, and run event-driven anomaly detection pipelines

SQLFlow

Enables SQL-based stream-processing, powered by DuckDB

nf-sqldb

This plugin provides support for interacting with SQL databases in Nextflow scripts

MindsDB

The platform for customizing AI from enterprise data. , making data from DuckDB accessible to a diverse range of AI/ML models

Sqlite2Duckdb

A CLI tool to convert SQLite database to DuckDB

NoSQL Database Connector for R, providing a common API across Elasticsearch, CouchDB, MongoDB, SQLite, PostgreSQL, and DuckDB

Drop-in replacement for dplyr in R that uses DuckDB for performance

kwack

In-Memory Analytics for Kafka using DuckDB

PSDuckDB

A PowerShell module for DuckDB integration

duckdb-tableau-connector

DuckDB Tableau connector

duckdb-power-query-connector

DuckDB Power Query Custom Connector

metabase_duckdb_driver

Metabase DuckDB Driver shipped as 3rd party plugin

xlDuckDb

Excel addin to run DuckDB queries in Excel

Fully managed DBaaS based in Postgres integrated with DuckDB

A serverless cloud data warehouse powered by DuckDB

MyDuck Server

A server wrapping DuckDB with MySQL and PostgreSQL wire protocol support

ParadeDB

Postgres for Search and Analytics, powered by DuckDB-embedded-in-Postgres

pg_duckdb

DuckDB-powered Postgres for high performance apps & analytics

pg_mooncake

A PostgreSQL extension that adds native column store tables with DuckDB

SQLFlite - Arrow Flight SQL Server

An example implementation of the that runs in a client-server setup with DuckDB or SQLite as backends

arrow

A zero-copy data integration between Apache Arrow and DuckDB

aws

For handling AWS credentials

azure

For using the Azure Blob storage

delta

For Delta Lake support

To support full text search

iceberg

For reading Iceberg tables

inet

For storing and handling IPv4 and IPv6 Internet addresses

To read from and write to MySQL databases

To read from and write to PostgreSQL databases

Enables geospatial processing

To read from and write to SQLite databases

Add support for vector similarity search

chsql

ClickHouse SQL Dialect macros for DuckDB

crypto

Cryptographic hash functions and HMAC

duckpgq

Graph workloads that supports the SQL/PGQ standard

evalexpr_rhai

Evaluates the scripting language as part of SQL

fuzzycomplete

Performs fuzzy string matching for autocompletion

h3

Adds support for the H3 discrete global grid system

lindel

Linearization/Delinearization, Z-Order, Hilbert and Morton Curves

prql

Run PRQL commands directly within DuckDB

scrooge

A set of aggregation functions and data scanners on financial data

shellfs

Allows shell commands to be used for input and output

ulid

ULID data type for DuckDB. A ULID is similar to a UUID except that it also contains a timestamp component

gsheets

Read and write Google Sheets using SQL

httpserver

DuckDB HTTP API Server and Query Interface

DuckDB Extension Radar

Repository that contains DuckDB extensions on GitHub. Refreshed daily

duckdb-bigquery

Enables seamless integration and querying of BigQuery datasets within DuckDB

duckdb-engine

SQLAlchemy driver for DuckDB

duckdb-extension-template-zig

A Zig & Nix toolkit template for building extensions against multiple versions of DuckDB using Zig, C or C++

duckdb-jfr-extension

DuckDB extension to read JFR (Java Flight Recorder) files directly

duckdb-protobuf

Plugin for querying encoded protobuf messages (both sequences and individual messages per file)

duckdb-pytables

DuckDB extension to allow running SQL on arbitrary data sources

DuckDB SAP connector using RFC, ODP, or BICS

Kùzu

Scan DuckDB tables in Kùzu, an embeddable property graph database management system

Integrate Lance (modern columnar data format for ML implemented in Rust) with DuckDB

ODBC Scanner DuckDB Extension

DuckDB extension to read data directly from databases supporting the ODBC interface

Plugin for reading DuckDB spatial tables in QGIS software

uc_catalog

Proof-of-concept extension combining the extension with Unity Catalog

duckdb-flockmtl

Integrate language model (LLM) capabilities directly into your queries and workflows

erpl-web

ERPL WEB is a DuckDB extension that connects API-based ecosystems via standard interfaces like OData, GraphQL, and REST

Gábor Szárnyas

Hannes Mühleisen and Mark Raasveldt

Hannes Mühleisen

Gábor Szárnyas

Pedro Holanda

Hannes Mühleisen

Pedro Holanda

Hannes Mühleisen & Mark Raasveldt

Pedro Holanda & Sam Ansmink

Hannes Mühleisen

Hannes Mühleisen

Mark Needham

Mehdi Ouazza

Edmund Miller

Mihai Bojin

James McNeill

Khalil Muhammad

Hannes Mühleisen

Mark Raasveldt

Hannes Mühleisen

Hannes Mühleisen

Jordan Tigani

Fast, free, and open-source Modern Data Stack deployed on a laptop using the combination of DuckDB, Meltano, dbt, and Apache Superset

How DuckDB can transform data, mask sensitive PII information, detect anomalies in event-driven workflows, and streamline reporting use cases

What are key differences between them, and when to choose each of these options

For Nix users and Zig developers familiar with DuckDB looking to extend its capabilities with custom extensions

Example project using DuckDB to persist API data, but also explains how to use DuckDB as a versatile data manipulation tool in data wrangling scripts

How to make a DuckDB extension to fetch data from external sources

How ParadeDB embedded DuckDB in Postgres to achieve fast analytics and Apache Iceberg compatibility from Postgres

DuckDB in Action will show you how to quickly get your hands dirty with DuckDB

A practical guide for accelerating your data science, data analytics, and data engineering workflows