Skip to content
91

Awesome DuckDB

🦆 A curated list of awesome DuckDB resources

2.5k stars274 forks451 entriesLast push Nov 16, 2026 (today)License CC0-1.0

This page lists names, links and short descriptions. The original list on GitHub is the source and belongs to its authors.

General

DuckDB

is an analytical in-process SQL database management system.

In 8 listsDetails

Resources

Official documentation

Official DuckDB documentation.

In 2 lists

Official blog

Official DuckDB blog.

DuckDB RSS feed

Feed for the official DuckDB blog.

DuckDB clients

Client APIs for DuckDB.

DuckDB documentation PDF

The DuckDB documentation as a single PDF file.

DuckDB documentation MD

The DuckDB documentation as a single Markdown file.

DuckLake

A lakehouse format from the team behind DuckDB.

duckdb-docker

Official Docker image for the DuckDB CLI.

DuckDB setup

GitHub Action to install DuckDB in CI.

In 14 listsDetails

Serverless DuckDB over S3

Running DuckDB over a data lake on S3 using lambda.

DuckDB snippets

Collection of snippets curated by MotherDuck.

DuckDB tldr page

DuckDB's entry in tldr pages, available in CLI via the tldr duckdb command.

DuckDB AWS Lambda layer (Node.js)

Run DuckDB in AWS Lambda functions.

DuckDB AWS Lambda layer (Python)

Run DuckDB in AWS Lambda functions using Python.

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.

Observable notebooks

Notebooks using DuckDB on the Observable data visualization platform.

duckdb-nf

Example uses of DuckDB with Nextflow.

DuckERD CLI

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

SQLNotebook

SQL notebooks by TimerStored powered by DuckDB.

DuckDB execution plan visualizer

Visualizing and understanding DuckDB EXPLAIN plans made easy.

Awesome DuckLake

A curated list of awesome DuckLake tools and resources.

DuckDB in Science

A collection of scientific papers building on DuckDB.

Prepare.sh DuckDB sandbox

Free browser-based sandbox on a dedicated cloud VM with DuckDB 2.0 or 1.5 and 200,000 sample rows as Parquet, CSV and JSON for comparing formats.

Installers

Official installation page

Brew formula

DuckDB version manager (duckman)

Cross-platform installer and version manager for DuckDB.

Snap package

Snap package of DuckDB, e.g., for Ubuntu Linux.

Chocolatey packages

Chocolatey package for Windows.

Newsletters

DuckDB Newsletter

Monthly newsletter by MotherDuck.

Learn DuckDB by example

Newsletter by Tobias Müller.

Logos and Icons

Logos

DuckDB logos.

Iconify

Monochrome DuckDB icon in Iconify.

Client APIs

C

C++

CLI

Go

Haskell

Julia

Node.js

Python

R

Ruby

Rust

Swift

WebAssembly (Wasm)

ADBC

ODBC

.NET

Common Lisp

Common Lisp CFFI wrapper around the DuckDB C API. MIT.

In 2 lists

PowerShell

Dart

PHP

PHP (PDO)

PHP (native extension)

Native PHP extension for DuckDB with a typed API, streaming results, and asynchronous queries.

Tools Powered by DuckDB >Business Intelligence & Dashboards

Definite

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. (pricing)

In 2 lists

Basedash

AI-native business intelligence platform that turns plain-English questions into SQL, charts and dashboards. Its managed warehouse runs on DuckDB, and MotherDuck can be connected as a data source. (pricing)

Evidence

Generate reports using SQL and markdown. The DuckDB connector allows querying across DuckDB, CSV, Parquet and JSON. (Evidence Cloud)

In 4 listsDetails

Rill Data

Tool for effortlessly transforming data sets into powerful, opinionated dashboards using SQL. (Rill Cloud)

In 2 lists

Shaper

Open-source SQL-driven data dashboards, powering Taleshape, built on DuckDB. (managed hosting)

Pondview

Open-source, DuckDB-powered BI workspace for AI-assisted analysis, SQL, charts, and dashboards.

DUX

Self-hosted analytics stack with a semantic model, DAX-inspired queries compiled to DuckDB SQL, DuckLake storage and dashboards.

CloudBridge

Open-source desktop app for analyzing cloud and AI costs, with a local DuckDB ledger, spending dashboards, and configurable alerts.

Excellent Bi

Duck Powered simple analysis and business intelligence dashboard. Load excel, csv, parquet files, instantly query your data in the query analyzer tool, make multiple simple dashboards. Data stays local in OPFS local browser storage which is native to Edge and Chrome. (proprietary; free to use)

ReportBurster

Business Intelligence Done Right - ReportBurster uses DuckDB as its in-process analytics database engine, and for larger workloads, supports ClickHouse too. (SSPL v1, source-available)

Tools Powered by DuckDB >Data Exploration & Visualization

Totsum Data Explorer

Desktop app (Windows, macOS) for a first look at CSV, Excel, JSON and Parquet files: plain-language questions are turned into DuckDB SQL by a language model that runs on the user's own machine. Can work on a computer with no network connection. (pricing)

SelfSync

Build a DuckDB database with all the activities (i.e. FIT files) contained in a Garmin data export for local analysis with any compatible client or AI assistants.

Enso Analytics

Dual visual/textual programming language and analytics platform, allowing DuckDB to be used as a data engine for its visual analytics and low-code workflows. (Enso Cloud)

Latitude

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

Kavla

Infinite canvas for exploratory data analysis. Real time collaboration in the cloud version kavla.dev

LightlyStudio

Computer vision dataset explorer that uses a local DuckDB file as its default database. (LightlyStudio Enterprise)

In 4 listsDetails

Apple Embedding Atlas

A tool that provides interactive visualizations for large embeddings. Uses DuckDB.

Cloudspecs

Live visualization tool that enables cloud system architects to answer specific instance selection questions, powered by DuckDB-Wasm.

Dex

Agent skills for profiling DuckDB databases, verifying joins, and mapping schemas through a read-only engine, with a seeded local DuckDB demo.

In 11 listsDetails

Cosmograph

Beautiful visualization and analytics right in the browser. (proprietary app with a free non-commercial tier; its cosmos.gl library is open source)

Datakit

The privacy-first data analysis toolkit. (proprietary; free tier)

OpenSheet

Spreadsheet-style data tool with visual canvas, inline editing, and AI commands for SQL transformations. (proprietary; free to use)

Unwrap

Opens unfamiliar CSV, JSON, Excel and ZIP exports in the browser and profiles them locally in an in-memory DuckDB workspace (WebAssembly); file contents are never uploaded. (proprietary; free to use)

Tools Powered by DuckDB >ETL, Pipelines & Orchestration

Bauplan

A serverless data transformation platform for data lakes. (pricing)

SQLMesh

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

In 2 lists

DBTrail

Analytical replica for MySQL: follows the binlog like a replica and keeps the tables as Parquet snapshots in a folder or S3 bucket, with a generated views.sql so DuckDB queries them as tables. Also answers the same SQL on a MySQL-protocol port backed by DuckDB, and keeps every version of every…

In 2 lists

AnkaFlow

YAML-based data pipeline framework that runs both locally and fully in-browser designed for data engineers, ML teams, and SaaS developers who need flexible, SQL-powered pipelines.

DatalakeStudio

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

Duckle

Local-first visual ETL/ELT studio. Drag sources, transforms and sinks onto a canvas; it compiles to plain DuckDB SQL and runs entirely on DuckDB. Open source desktop app, with a built-in MCP server for generating and running pipelines from natural language.

In 3 lists

ETLX

DuckDB-powered ETL tool written in Go, inspired by evidence.dev's syntax. It uses a structured Markdown config where heading levels define nested blocks, yaml code blocks specify metadata, and sql code blocks handle data interactions. Enables clean, code-light orchestration with minimal setup.

yato

The smallest DuckDB SQL orchestrator on Earth.

Renart

Local-first open source data platform for SQL and Python pipelines, notebooks and dashboards, with DuckDB support and declarative workflow definitions in Git.

Ternlux

Open-source desktop app for ETL and data analysis. Joins databases, files and APIs in one step, running the join locally in DuckDB or pushing it down to the source database. An AI assistant drafts the plan and SQL for review before anything runs, using your own API key or a local model.

Amphi ETL

Low-code data pipelines for structured and unstructured data. SQL transformations are powered by DuckDB. (Elastic License 2.0, source-available)

In 2 lists

Tools Powered by DuckDB >Query Engines, Federation & Warehouses

Boiling Data

Serverless data analytics overlay on top of S3 Data Lakes. (pricing)

DBConvert Streams

Database IDE and migration tool with DuckDB-powered federated SQL. (pricing)

In 3 lists

Greybeam

Routes your Snowflake queries to a DuckDB powered warehouse to reduce costs and speed up queries. (pricing)

Varan

Desktop SQL client that runs one query across PostgreSQL, MySQL, DuckDB and CSV/Excel files, allowing multi-source JOINs and data versioning powered by a local-first DuckDB engine. (pricing)

Altertable

A DuckDB-powered context lakehouse combining real-time ingestion, federated SQL, and governed data access for analytics, applications, and AI agents. (pricing)

Arc

Time-series data warehouse built on DuckDB. (commercial license)

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. (Spice.ai Cloud)

DataSpoc Lens

Virtual warehouse over cloud Parquet. SQL shell, Jupyter/Marimo notebooks, AI natural language queries, and local cache — all powered by DuckDB.

In 2 lists

Hugr

An data mesh platform and high-performance GraphQL backend powered by DuckDB.

UniverSQL

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

crossql

CLI that attaches Postgres, MySQL, SQLite and DuckDB databases plus CSV/Parquet/JSON files to DuckDB read-only, so one SQL query can join across them, and snapshots named queries into a SQLite/DuckDB file or Parquet folder for BI tools. (AGPL-3.0)

Boilstream

Manage with SQL, like for creating topics (tables) and derived topics (materialised views) - all landing on object storage in DuckLake as optimised Parquet files. (proprietary core shipped as binaries, free-forever community tier; SDKs are open source)

Tools Powered by DuckDB >Data APIs, Integration & AI Access

Bonnard

Business intelligence through MCP-compatible AI clients, with charts and dashboards over connected databases, including DuckDB on MotherDuck. (pricing)

In 2 lists

Census

Census's dataset diffing for incremental syncs is powered by DuckDB. (pricing — Census was acquired by Fivetran)

In 5 listsDetails

VulcanSQL

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.

CNEquity

Self-hosted China A-share market data lake; DuckDB views over its Parquet datasets back SQL queries from the CLI and a read-only run_sql tool in its MCP server for AI agents.

In 2 lists

PocketDuck

Single-binary backend pairing PocketBase (auth, files, realtime) with an embedded DuckDB runtime: read-only analytics API, cross-source joins over Parquet/CSV/SQLite/PostgreSQL/MySQL, and exports to Parquet, PostgreSQL and Excel.

duckdb-vectors

MCP or embeddable semantic-search building block for agentic systems — hybrid vector + exact-token search over a local DuckDB file, no external vector database.

schemagate

Python library and MCP server for text-to-SQL agents that gives the model only the tables a question needs and the caller may read. Reflects a DuckDB file through duckdb-engine.

In 2 lists

sqrail

Single-binary C++20 CLI around embedded DuckDB that runs one read-only SQL query over explicitly bound CSV, TSV, JSON, JSONL, and Parquet files with resource limits, streaming JSONL or atomic file output, and a 195-word contract for coding agents. MIT.

Tools Powered by DuckDB >Product, Web & Application Analytics

HitKeep

Open-source, privacy-first web analytics for traffic, funnels, ecommerce, Search Console, and AI visibility. Runs as a single Go binary with embedded DuckDB. (HitKeep Cloud)

Phoenix Analytics

Plug and play analytics for Phoenix applications, powered by DuckDB.

stratif.io

Open-source, self-hosted, warehouse-native product analytics. Runs funnels, retention, and paths on DuckDB (and Postgres, Snowflake, ClickHouse, Databricks).

In 3 lists

Tools Powered by DuckDB >Geospatial

Honeycomb Maps

A browser-based geospatial analysis tool leveraging DuckDB-Wasm. (pricing)

In 2 lists

Kepler.gl

Kepler.gl is a powerful open-source geospatial analysis tool for large-scale data sets, now embeds duckdb wasm to create geospatial layers.

In 4 listsDetails

Whereabouts

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

duck soup

Config-driven geospatial ETL: a YAML pipeline (or visual web editor) of sources, spatial/attribute joins, geoprocessing and field mapping compiles to a chain of DuckDB spatial SQL views and writes GeoPackage or GeoParquet. Reads GeoJSON, Shapefile, FileGDB, WFS, OGC API Features, ArcGIS REST,…

In 2 lists

Tools Powered by DuckDB >Observability, Logs & Security

Tailpipe

An open-source SIEM for instant log insights. (commercial license)

Sloggo

Minimal RFC 5424 syslog collector and viewer based on DuckDB. Runs as a single, resource-friendly process.

Fanout

Self-hosted OpenTelemetry backend that stores traces, logs and metrics as Parquet and queries them with embedded DuckDB. Runs as a single binary.

In 2 lists

Tools Powered by DuckDB >Data Quality & Governance

DataCharter

Local, contract-governed data explorer. Federates files and databases (Postgres, Snowflake, BigQuery, Excel, and more) through DuckDB — SQL editor, charts, profiling — then hands AI agents a PII-masked, read-only query surface over MCP. Apache-2.0.

DataOps TestGen

Open-source data quality tool that profiles tables and generates and runs data quality tests; connects to DuckDB databases and uses DuckDB to profile and test CSV, Parquet, and JSON files locally, in Amazon S3, or in Azure Blob Storage. Apache 2.0.

In 4 listsDetails

Data Contract CLI

Command-line tool to test data against data contracts in the Open Data Contract Standard (ODCS). Converts from and to formats such as SQL DDL, dbt, Avro, and JSON Schema. Uses DuckDB to run schema and quality checks on sources such as CSV, Parquet and JSON files (local, S3, GCS, Azure), DuckDB…

In 3 lists

DQOps

Data quality platform for data engineers, data quality teams and data operations. (Business Source License 1.1, source-available)

Tools Powered by DuckDB >File Viewers & Pivot Tables

ADPivot

No code tool built on top of DuckDB-Wasm and Pyodide that helps build pivot tables from databases of any size with a few clicks.

duckdb.yazi

Preview csv/tsv, json, and Parquet files in the yazi file manager using duckdb. View the raw data, or a "summarized" view with data-types, min, max, avg etc. for all columns.

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!

Parquet Explorer

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

Link may be dead

Folio

Serves a folder of markdown and data files as browser pages, using DuckDB to open CSV, JSON Lines, Parquet and DuckDB files as sortable tables and to run SQL written in the documents. GPL-3.0.

Tools Powered by DuckDB >Notebooks & Embedded Engines

SpurLab

Desktop Jupyter notebook for agent-driven data exploration that runs Python, SQL, and DuckDB cells against an embedded local DuckDB. (no published license; free to use)

Hex Dataframe SQL

Hex's Dataframe SQL cells are powered by DuckDB. (pricing)

Mode

Mode uses DuckDB for their in-memory data engine. (pricing)

Tools Powered by DuckDB >SQL Tooling & Language Engines

geol

A command line tool to efficiently show end-of-life dates for a number of products in your terminal using the endoflife.date API, makes it possible to export the whole endoflife.date database as a fully featured DuckDB file.

Malloy

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

SQLGlot

Python transpiler that translates between 24 different SQL dialects including DuckDB.

In 5 listsDetails

KoliLang

A SAS language engine (DATA step, macros, PROCs) that translates programs to DuckDB SQL — runs natively or fully in the browser on DuckDB-Wasm. (no published license; free to use)

Tools Powered by DuckDB >Fun & Demos

connections.duckdb

Play the New York Times Connections Puzzle with DuckDB.

ReportBurster

Business Intelligence Done Right - ReportBurster uses DuckDB as its in-process analytics database engine, and for larger workloads, supports ClickHouse too. (SSPL v1, source-available)

DataSpoc Lens

Virtual warehouse over cloud Parquet. SQL shell, Jupyter/Marimo notebooks, AI natural language queries, and local cache — all powered by DuckDB.

In 2 lists

stratif.io

Open-source, self-hosted, warehouse-native product analytics. Runs funnels, retention, and paths on DuckDB (and Postgres, Snowflake, ClickHouse, Databricks).

In 3 lists

DBConvert Streams

Database IDE and migration tool with DuckDB-powered federated SQL. (pricing)

In 3 lists

Duckle

Local-first visual ETL/ELT studio. Drag sources, transforms and sinks onto a canvas; it compiles to plain DuckDB SQL and runs entirely on DuckDB. Open source desktop app, with a built-in MCP server for generating and running pipelines from natural language.

In 3 lists

HitKeep

Open-source, privacy-first web analytics for traffic, funnels, ecommerce, Search Console, and AI visibility. Runs as a single Go binary with embedded DuckDB. (HitKeep Cloud)

AnkaFlow

YAML-based data pipeline framework that runs both locally and fully in-browser designed for data engineers, ML teams, and SaaS developers who need flexible, SQL-powered pipelines.

KoliLang

A SAS language engine (DATA step, macros, PROCs) that translates programs to DuckDB SQL — runs natively or fully in the browser on DuckDB-Wasm. (no published license; free to use)

DataCharter

Local, contract-governed data explorer. Federates files and databases (Postgres, Snowflake, BigQuery, Excel, and more) through DuckDB — SQL editor, charts, profiling — then hands AI agents a PII-masked, read-only query surface over MCP. Apache-2.0.

Pondview

Open-source, DuckDB-powered BI workspace for AI-assisted analysis, SQL, charts, and dashboards.

Varan

Desktop SQL client that runs one query across PostgreSQL, MySQL, DuckDB and CSV/Excel files, allowing multi-source JOINs and data versioning powered by a local-first DuckDB engine. (pricing)

Totsum Data Explorer

Desktop app (Windows, macOS) for a first look at CSV, Excel, JSON and Parquet files: plain-language questions are turned into DuckDB SQL by a language model that runs on the user's own machine. Can work on a computer with no network connection. (pricing)

DuckDB OPFS Todo List App

A fully-functional todo list application that demonstrates DuckDB WASM OPFS (Origin Private File System) persistence using a pure functional programming approach. (no LICENSE file in repo)

Backends

DuckDB API

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

Mosaic DuckDB Server

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

duckdb-server

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

Link may be dead

Hydra ETL

Declarative YAML ETL engine that can run each transformation step on DuckDB or pandas.

In 3 lists

Libraries Powered by DuckDB

Ibis Project

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

Narwhals

Lightweight and extensible compatibility layer between dataframe libraries, supports DuckDB.

In 3 lists

SQLFrame

Implements the PySpark DataFrame API in order to enable running transformation pipelines directly on database engines such as DuckDB.

Mosaic

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.

In 2 lists

Splink

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.

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.

In 4 lists

PyGWalker

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

flapi

An API Framework that 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.

smallpond

A distributed data processing framework by DeepSeek built on DuckDB and 3FS.

BemiDB

PostgreSQL read replica optimized for analytics, using DuckDB.

jsqltranspiler

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

SQLRooms

An open-source react framework for single-node data analytics powered by DuckDB.

Omilayers

A Python library for efficient data management that wraps the APIs of SQLite and DuckDB and offers a high-level interface analytical tasks that involve fast storage, processing and retrieval of data.

Unleasharp.DB.DuckDB

Lightweight DuckDB query-building client for C#.

Snowflake Emulator

A lightweight Snowflake emulator built with Go and DuckDB for local development and testing.

In 2 lists

DuckDB.EFCoreProvider

Entity Framework Core provider for DuckDB and DuckLake, with LINQ, writes, migrations, bulk ingestion, and Parquet-backed tiered storage for .NET.

Vane

A multimodal-native engine for AI workloads, built on a DuckDB fork with Python and SQL interfaces.

ds-agent-playbook

Autonomous, zero-bloat recipes for Data Science pipelines: automated EDA, deterministic data cleansing, and feature hypothesis synthesis powered by Polars & DuckDB.

In 2 lists

SQLProvider

F# type provider for SQL databases with a DuckDB provider (SQLProvider.DuckDb): typed LINQ queries and CRUD over the database schema.

In 2 lists

AVA

A TypeScript framework for natural-language data analysis and visualization, using DuckDB for SQL execution and data profiling in Node.js.

In 3 lists

DuckDB Clients and UIs >Web Clients (WebAssembly)

Online DuckDB Shell

Online DuckDB shell powered by DuckDB-Wasm.

SQL Workbench

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.

DuckDB Terminal

Online DuckDB shell powered by DuckDB WASM and Ghostty.

SQL Workbench Embedded

A lightweight JavaScript library that turns SQL code blocks into interactive, browser-based database environments. Powered by DuckDB WASM.

Sekuel Playground

Query your local Parquet, CSV, JSON. Your data will not be sent out of the device you are using.

Codapi

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

QuackDB

Open-source in-browser DuckDB SQL playground and editor.

Sidequery

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

Duck-UI

Duck-UI is a web-based interface for interacting with DuckDB with a SQL editor, data import/export, data explorer, query history, theme toggle and keyboard shortcuts.

SQLRooms

An open-source react framework for single-node data analytics powered by DuckDB.

PondPilot

Open-source, 100% client-side data exploration tool that enables users to analyze local and remote data using SQL. Zero-copy direct access to local datasets sets PondPilot apart from similar tools. It runs entirely in the browser—no servers, no cloud uploads, and no setup required.

Preswald

WASM packager for Python-based interactive data apps.

In 2 lists

Medama

Self-hostable, privacy-focused website analytics.

In 2 lists

dbxlite

Open-source (MIT) SQL workbench for DuckDB that runs in the browser on DuckDB-Wasm, or as the UI for duckdb -ui via npx dbxlite-ui to query files on disk with native DuckDB. Also supports BigQuery and Snowflake.

DuckQuery

Open-source visual SQL workbench to query local files (CSV/Excel/Parquet/JSON) and remote databases (MySQL/PostgreSQL) in one cross-source JOIN, plus AI text-to-SQL. Browser demo runs on DuckDB-Wasm; the full version self-hosts via Docker.

csvtodashboard

Free SQL-on-CSV in the browser via DuckDB-Wasm — no signup, no upload, files stay on-device.

ParquetKit

Browser-based Parquet viewer, SQL workbench and converter powered by DuckDB-Wasm. Fully client-side — files never leave your device.

In 2 lists

Bedevere

Tabular data visualizer and DuckDB SQL editor on DuckDB-Wasm: open CSV/Parquet/JSON/Arrow locally, chart results with a grammar-of-graphics VISUALIZE syntax, and embed it anywhere via npm component or a one-line iframe.

Telemetry SQL Playground

Browser-based, read-only SQL playground powered by DuckDB-Wasm, with synthetic structured-event datasets.

ExploreMyData

Browser-based data explorer on DuckDB-Wasm: open CSV, Excel, JSON, Parquet, Arrow, Avro, SQLite and DuckDB files up to 1GB, chain filter/join/pivot/aggregate steps that each emit DuckDB SQL, write SQL directly, chart, and export. Files never leave the device.

DBConvert Parquet Viewer

Browser-based Parquet viewer on DuckDB-Wasm. Reads the schema, row groups, compression codecs and column statistics, runs read-only SQL over the file and exports results as CSV. A JSONL/NDJSON viewer uses the same engine. Files are opened through a browser file handle and are not uploaded.

Parquetly

Browser-based Parquet viewer on DuckDB-Wasm. Shows the schema, row groups and column chunk statistics, runs SQL over the file, and exports to CSV or JSON. Files are read locally and are not uploaded.

SQL Clients and IDE that Support DuckDB

Harlequin

The DuckDB IDE (TUI) for your terminal.

qStudio

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

DuckDB SQL Tools

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

Link may be dead

VSCode SQLTools

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

Link may be dead

DBeaver

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

In 2 lists

DataGrip

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

In 8 listsDetails

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.

SQL DATA LENS

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

Dataflare

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

In 3 lists

rainfrog

A database TUI with experimental support for DuckDB.

In 3 lists

marimo

Unified data & AI platform that lets you work with SQL and Python with native support for DuckDB.

jupysql

Run SQL in Jupyter/IPython via a %sql and %%sql magics, with support for DuckDB.

magic_duckdb

DuckDB native %dql and %%dql magics for Jupyter/IPython.

AmoxSQL

The Modern Codex for Local Data Analysis. A high-performance, local-first IDE built specifically for DuckDB.

tuitab

A Rust TUI for fast, in-depth analytics on large datasets (CSV, JSON, Parquet, Excel, SQLite) powered by DuckDB.

Tad

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

In 3 lists

Mongrel

Paid desktop database workbench with DuckDB support, including isolated transactions, transactional migrations, physical backups, and remote import from Parquet and CSV.

DuckDB Lens

Read-only DuckDB database file viewer for JetBrains IDEs: schema tree, paged tables of any size, constant memory. Sibling Lens viewers cover SQLite, Parquet, Excel and Jupyter files.

1bench

Paid cross-platform desktop client supporting DuckDB alongside two dozen other databases, including relational, document, key-value, vector and search engines.

LibreDB Studio

Browser-based SQL IDE that opens DuckDB database files alongside PostgreSQL, MySQL, ClickHouse and other engines, with a schema explorer and JSON EXPLAIN plans. MIT licensed, runs as a container or Helm chart.

In 8 listsDetails

Beekeeper Studio

Free, open-source SQL editor and database manager with native support for DuckDB, MySQL, Postgres, SQLite, SQL Server, and more.

In 10 listsDetails

VisuaLeaf

Visual database workspace with DuckDB support, featuring a visual SQL query builder, data editor, ERD diagrams, and database management tools for DuckDB, PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, and more.

DGopher

Free, open-source native desktop database client with DuckDB built in that also connects to PostgreSQL, MySQL, ClickHouse, SQLite and Redis. Drop a CSV, Parquet or JSON file on the window to query it in place. Apache 2.0 licensed, for Linux, macOS and Windows.

DBine

Free, open-source (Apache 2.0) desktop database manager for macOS, Windows and Linux. It opens DuckDB databases alongside 130+ databases and cloud services, and its notebooks join query results from several databases locally with DuckDB SQL.

SQLly

Commercial cross-platform SQL client with IntelliSense and schema intelligence that opens DuckDB databases alongside PostgreSQL, MySQL, SQL Server, SQLite, Redis and more.

Tabularis

Free, open-source desktop SQL client for Windows, macOS and Linux. Its installable DuckDB plugin supports local and in-memory databases, schema browsing, SQL queries and row editing.

In 2 lists

Pilotbase

Database client that opens DuckDB files alongside PostgreSQL, MySQL, SQLite, MongoDB and vector databases, with a SQL editor, schema tree and SQL export. MIT licensed, runs in Docker or as a desktop app.

DuckLocal

Open-source desktop workspace built on DuckDB for querying local CSV, Parquet, JSON, Excel, and DuckDB files, with a SQL editor, visualizations, and interactive dashboards.

dbxlite for VS Code

Freemium VS Code extension with DuckDB 2.0 bundled. Queries CSV, Parquet, JSON, Excel and DuckDB files and S3, and joins them with PostgreSQL and MySQL sources. Also connects to SQLite and Databricks.

NiceDB

Open-source desktop database client with DuckDB support, including query plans and Parquet import and export.

OrcaQ

Free, open-source (MIT) desktop database editor that opens DuckDB files alongside PostgreSQL, MySQL, SQLite and more, with streamed query results, schema diff between two DuckDB files and a read-only MCP server.

DbSchema

Commercial visual database designer with a free Community Edition. Opens DuckDB files to draw ER diagrams of tables and views, run SQL queries and generate HTML schema documentation.

aantje

Free, open-source (MIT) VS Code extension for exploring DuckLake catalogs backed by DuckDB, SQLite or PostgreSQL: browse schemas, tables and snapshots, run SQL with IntelliSense, and monitor table health, storage and growth.

QoreDB

Open-core desktop SQL client built with Rust and Tauri that opens DuckDB files and MotherDuck databases and queries local CSV and Parquet files. Its paid tier uses DuckDB to join data across connections to other databases.

Projects Powered by DuckDB

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.

endoflife.date database

Daily dumps of endoflife.date data.

Link may be dead

transfermarkt-datasets

Curated football datasets from Transfermarkt.

In 2 lists

duckdb-embedding-search

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

DuckDB PyPI stats live dashboard

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

PyStack't

Python package that supports data preparation for object-centric process mining.

Georgia State University Book Prices

DuckDB powered WASM app where you can search how much students spend on books at Georgia State University.

duckdb-claude-slack

A Slack data analysis agent powered by DuckDB and Claude Code.

Ducklings

A minimal DuckDB WASM build for browsers and serverless environments like Cloudflare Workers.

msgvault

Archive a lifetime of email and chat. Offline search, analytics, and AI query over your full message history. Powered by DuckDB.

datagenerator2

Generates random data, allowing to define dependencies between individual fields and varying/definable distribution of field values.

Overture Places UA

Extract all Ukrainian POIs from Overture Maps releases into CSV or Parquet with a single DuckDB query.

dlt-dbt-duckdb-evidence

End-to-end pipeline over seven public data sources in a single DuckDB file, using dlt, dbt, Polars, Dagster and Evidence. Rebuilds from live sources on every push and publishes the DuckDB file and per-table Parquet monthly.

Caso Abierto

Detective game where each case file is a set of Parquet tables queried with SQL, running DuckDB-WASM in the browser.

SixSentences

Self-hostable research workspace that compiles boolean literature-search queries to SQL and runs them offline with DuckDB over versioned Parquet snapshots of a scholarly corpus.

In 2 lists

GTFS Scorecard

Data-quality grades for 2,400+ public transit (GTFS) feed records. DuckDB builds the cross-agency query layer and a public Parquet table that DuckDB can query over HTTP, and the site's SQL page runs DuckDB-WASM in the browser.

In 2 lists

PH Catalog

Resumable local Product Hunt catalogue and analytics pipeline that normalizes records into DuckDB and exports verified Parquet snapshots.

AskCSV

Ask questions about a CSV in plain English. The file is loaded into DuckDB-WASM in the browser, a model writes a read-only DuckDB query from the schema alone, and failed queries are repaired automatically.

GitHub Repo Analytics

GitHub Actions template that collects a repository's traffic, stars, downloads, and issue/PR activity into a DuckDB file, modeled with dbt and MetricFlow, keeping traffic history beyond GitHub's 14-day limit.

Dublin bikes + weather pipeline

Example pipeline that loads Dublinbikes station snapshots and Met Éireann weather into DuckDB, models them with dbt into a tested star schema, and publishes the marts as Parquet with an in-browser DuckDB-WASM query console.

Qiita-MIINT

Qiita is a scalable, multi-omic platform for managing, processing, and analyzing microbiome data, built entirely around DuckDB and the MIINT extension.

Integrations

dbt-duckdb

DuckDB dbt adapter.

data load tool - DuckDB destination

Extract and load data from APIs to DuckDB using dlt.

target-duckdb

Load data to DuckDB based on Singer spec.

Airbyte DuckDB destination

Load data to DuckDB with Airbyte.

Kestra DuckDB plugin

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. MindsDB integrates with DuckDB, making data from DuckDB accessible to a diverse range of AI/ML models.

In 8 listsDetails

sqlite2duckdb

A CLI tool to convert SQLite database to DuckDB.

nodbi

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

duckplyr

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

kwack

In-Memory Analytics for Kafka using DuckDB.

PowerShell

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.

Hasura DuckDB Connector

Allows connecting to a DuckDB database or a MotherDuck-hosted DuckDB database through a GraphQL API.

Ontop

Allows to create Virtual Knowledge Graphs directly from DuckDB.

jOOQ

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

manifold-sql (DuckDB for Java)

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

In 3 lists

The Quack is Back: SAS/ACCESS Meets DuckDB

SAS/ACCESS engine support for DuckDB.

duckdb-teradata

Teradata connector.

Kotlin DataFrame

Supports reading from DuckDB databases using JDBC.

Sidemantic

A semantic layer with DuckDB integration.

Cloudflare R2 Data Catalog connector

Connect to Cloudflare R2 Data Catalog with DuckDB.

Enrich.sh

Lightweight event ingestion that stores JSON events as Parquet in R2, queryable directly from DuckDB.

In 2 listsLink may be dead

DuckDB VBA

Excel/VBA integration for DuckDB using the native C API through a lightweight DLL bridge. Supports Range/Array ingestion, dictionary lookups, Parquet/CSV/JSON workflows, SQLite/PostgreSQL connectivity, and Access-to-DuckDB migration.

OrionBelt Semantic Layer

Open-source semantic sidecar that compiles YAML semantic models to optimized SQL across 8 engines including DuckDB. Ships with an ob-duckdb driver, REST + Arrow Flight SQL + Postgres wire surfaces, and a baked-in DuckDB quickstart on Colab.

In 2 lists

DuckDBExcelAddin

A native Microsoft Excel XLL add-in for querying Excel ranges with DuckDB SQL and parameter binding. Supports DuckDB 2.0.

Bruin

Data pipeline CLI that runs SQL and Python transformations with built-in quality checks, using DuckDB as one of its supported platforms.

In 6 listsDetails

ingestr

CLI tool to copy data between databases and SaaS sources, with DuckDB supported as both a source and a destination.

In 6 listsDetails

omniload

Polyglot data loader for ETL, warehousing and more, based on dlt. Supports 140+ source/destination adapters. Derived from ingestr v0 (MIT).

In 2 lists

Scherlok

Data quality monitoring CLI that profiles tables and detects anomalies (volume, freshness, schema drift, NULL rates, distributions) without configuration; DuckDB is one of its connectors and backs its built-in demo.

In 3 lists

Filament MotherDuck sink

Load data from databases and SaaS APIs to MotherDuck with Filament, using full, incremental or CDC replication. Writes through DuckDB's native MotherDuck extension and appender.

Client-Server Setups

Crunchy Data Warehouse

Fully managed DBaaS based in PostgreSQL integrated with DuckDB.

MotherDuck

A serverless cloud data warehouse powered by DuckDB.

In 2 lists

MyDuck Server

A server wrapping DuckDB with MySQL and PostgreSQL wire protocol support.

pg_analytics

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

pg_duckdb

DuckDB-powered PostgreSQL for high-performance apps & analytics.

pg_mooncake

A PostgreSQL extension that adds native column store tables with DuckDB.

GizmoSQL - Arrow Flight SQL Server

A C++ implementation of the Arrow Flight SQL protocol that runs in a client-server setup with DuckDB or SQLite as backends.

Porter

A Go-based implementation of a DuckDB Arrow Flight SQL Server.

Termux DuckDB package

DuckDB CLI client for the Termux Android terminal emulator.

pg_lake

pg_lake integrates Iceberg and data lake files into Postgres. Uses DuckDB to execute queries.

AliSQL

A MySQL branch originated from Alibaba Group. Integrates DuckDB as a native storage engine.

In 2 lists

rawquery

Managed analytical platform pairing DuckDB compute with Iceberg storage on S3. Postgres wire protocol, CLI, and Python API.

In 3 lists

Layerbase

Managed DuckDB 2 hosting with a browser query console, REST API and CLI, plus DuckLake with a PostgreSQL catalog and Cloudflare R2 or AWS S3 storage, alongside 18 other database engines under one account. Databases scale to zero when idle and wake on connect.

VillageSQL

Aggregate Parquet, CSV and JSON in object storage from SQL, with DuckDB embedded in MySQL.

Hardcharger

An open-source DuckDB server using Chargewire (HTTP and Apache Arrow), with authentication, concurrent sessions, a desktop app for macOS and Windows, and ADBC, JDBC, ODBC, and JavaScript clients.

SlackerDB

Java-based service that exposes DuckDB over the PostgreSQL wire protocol.

GizmoData Cloud

Managed Hardcharger (DuckDB) and GizmoSQL servers on AWS, Google Cloud or Azure. Create DuckLake catalogs or connect an existing Apache Iceberg REST catalog (such as Apache Polaris or Lakekeeper), and mount them on any number of clusters.

Quack on Demand

Multi-tenant gateway serving DuckDB and DuckLake over Arrow Flight SQL and DuckDB's native Quack protocol, with pluggable authentication (DB/JWT/OIDC), table-, row- and column-level security, and read/write-aware routing across pools of DuckDB nodes.

ducktape

Lightweight REST API for DuckDB with HTTP/2 streaming support.

Extensions >Core Extensions

arrow

A zero-copy data integration between Apache Arrow and DuckDB.

avro

For reading Avro files.

aws

For handling AWS credentials.

azure

For using the Azure Blob storage.

delta

For Delta Lake support.

ducklake

For DuckLake support.

In 2 lists

fts

To support full-text search.

iceberg

For reading Iceberg tables.

inet

For storing and handling IPv4 and IPv6 Internet addresses.

json

For reading and writing JSON data.

mysql

To read from and write to MySQL databases.

parquet

For reading and writing Parquet data.

postgres

To read from and write to PostgreSQL databases.

spatial

Enables geospatial processing.

sqlite

To read from and write to SQLite databases.

vss

Add support for vector similarity search.

Extensions >Community Extensions

3fs

Integrates DuckDB with DeepSeek 3FS distributed file system.

a5

Pentagon-based geospatial indexing with the A5 global grid.

acp

Embeds AI agents such as Claude Code inside of DuckDB via Agent Client Protocol.

adbc_scanner

Queries other databases from DuckDB using ADBC drivers.

airport

Queries Apache Arrow Flight services from DuckDB SQL.

bigquery

Integrates DuckDB with Google BigQuery, allowing direct querying and management of BigQuery datasets.

bitfilters

Builds and queries probabilistic membership filters, including XOR, binary fuse, quotient and Bloom filters.

cache_httpfs

Adds a read caching layer to duckdb filesystem to improve query performance and reduce egress cost.

cache_prewarm

A Preloads table data blocks into the buffer pool or OS page cache, inspired by PostgreSQL's pg_prewarm extension.

chsql

ClickHouse SQL Dialect macros for DuckDB.

cronjob

Schedules SQL queries with cron expressions while the DuckDB process is running.

crypto

Cryptographic hash functions and HMAC.

curl_httpfs

Enhanced HTTP file system with connection pooling, HTTP/2 support, and asynchronous I/O operations.

dash

Fully local data canvas and dashboarding app within DuckDB.

datasketches

Approximate distinct counts, quantiles and frequent items using Apache DataSketches.

duckherder

Distributed execution for DuckDB queries.

duckpgq

Add supports for SQL/PGQ (Property Graph Queries) introduced in the SQL:2023 standard.

elasticsearch

Query Elasticsearch indices directly using SQL.

evalexpr_rhai

Evaluates the Rhai scripting language as part of SQL.

events

Forwards DuckDB query, transaction and connection events to external programs.

finetype

Detects the semantic type of text columns and values (emails, dates, IP addresses, currency amounts) and reports the DuckDB type each can be cast to.

fuzzycomplete

Performs fuzzy string matching for autocompletion.

gaggle

A DuckDB extension for working with Kaggle datasets.

geosilo

Compact geometry storage with coordinate quantization and delta encoding.

gpudb

GPU-accelerated plain DuckDB SQL on Apple Silicon Metal and NVIDIA CUDA: GROUP BY, joins, filters and top-k run on the GPU when measured faster, with the same answers.

gridpin_ext

Offline forward and reverse geocoding in SQL from a local per-country data file built from Overture Maps data.

gsheets

Read and write Google Sheets using SQL.

h3

Adds support for the H3 discrete global grid system.

hashfuncs

Non-cryptographic hash functions including xxHash, MurmurHash3 and RapidHash.

hostfs

Navigate and explore the local filesystem using SQL.

http_client

Makes HTTP GET and POST requests from SQL.

httpserver

DuckDB HTTP API Server and Query Interface.

infera

A DuckDB extension for in-database inference.

inflector

String case conversion, pluralization and singularization functions.

json_schema

JSON Schema draft-07 validation and default-value enrichment.

jsonata

Evaluates JSONata expressions against JSON values in SQL.

lindel

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

marisa

Builds and queries compact MARISA tries for string lookup and prefix search.

miint

Open, SQL-native tools for microbiome data, from raw sequence and alignment to phylogeny, diversity, and mass spectrometry, built for the scale of modern multi-omic studies.

minijinja

Renders Jinja-compatible templates from SQL using MiniJinja.

ml

Lightweight, columnar-native ML for DuckDB — train + inference, 34 algorithms, zero Python deps.

netquack

Parsing, extracting, and analyzing domains, URIs, and paths with ease.

observefs

I/O observability for DuckDB filesystems with latency statistics and external file cache access insights.

onager

A DuckDB extension for graph data analytics.

orc

Reads Apache ORC files in pure Rust — all primitives, struct, list, map types and every compression codec (Zlib, Snappy, LZO, LZ4, ZSTD).

orkidea

Extension to attach Oracle Database and query, join, and write its tables from DuckDB, running filters, joins, and aggregates in Oracle. Built on a Rust ADBC driver that reads Arrow directly, so it needs no Oracle Instant Client.

pfc

Read block-indexed PFC-compressed JSONL logs with timestamp filtering — 25% smaller than gzip with minimal S3 egress.

prql

Run PRQL commands directly within DuckDB.

pst

Read Microsoft PST files in-place with rich schemas for emails, contacts, appointments, tasks, and more.

python_udf

Embedded CPython UDFs for DuckDB — py_eval, py_agg, py_scan, py_register, py_call, py_map.

query_condition_cache

Caches query conditions to improve performance for repeated-query workloads.

quickjs

Runs JavaScript from SQL using the QuickJS-NG engine.

radio

WebSocket and Redis Pub/Sub messaging from SQL.

rapidfuzz

Fuzzy string matching and edit-distance functions using RapidFuzz.

redis

Reads and writes Redis data from SQL.

scrooge

A set of aggregation functions and data scanners on financial data.

shellfs

Allows shell commands to be used for input and output.

stats_duck

Statistics for tabular and clinical data: descriptive tables (table_one), linear models with robust/clustered standard errors, meta-analysis, bootstrap, and a grammar-of-graphics VISUALIZE clause that turns queries into Vega-Lite charts.

stochastic

Probability distributions, random sampling and statistical functions.

tera

Renders Tera templates from SQL.

textplot

Renders text-based bars, sparklines and density plots in query results.

tributary

Queries Apache Kafka topics from DuckDB SQL.

tsid

Generates time-sorted unique identifiers.

ulid

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

webmacro

Loads SQL macros from remote URLs.

yardstick

Implements Measures in SQL paper as a DuckDB extension for centralized metric definitions / en embedded semantic layer.

Extensions >Other Extensions

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.

ERPL

DuckDB SAP connector using RFC, ODP, or BICS.

Kùzu

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

In 4 listsDetails

Lance

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.

QDuckDB

Plugin for reading DuckDB spatial tables in QGIS software.

UC Catalog Extension

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

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.

quack-zig

The infamous DuckDB quack extension rewritten in C and built with Zig. Proof that you can develop DuckDB extensions without drowning in boilerplate.

DuckDB.ExtensionKit

Build native DuckDB extensions in C#.

template-duckdb-extension-zig

A template for developing DuckDB extensions in Zig using DuckDB's C API.

go-duckfs

A Go library that mounts io/fs file systems as DuckDB virtual file systems, sandboxing all I/O through the Go runtime.

duckdb-fxmacrodata

Rust extension with table functions that return FXMacroData's official-source macroeconomic releases and release calendars as typed rows, with the publication timestamp of each figure.

VGI

Exposes external workers as DuckDB catalogs, tables and functions using Apache Arrow IPC.

Extensions >Extension Statistics

DuckDB Extension Radar

Repository that contains DuckDB extensions on GitHub. Refreshed daily.

Tutorials

DBQuacks

An interactive SQL tutorial powered by DuckDB.

GeoSQL

Interactive spatial SQL problems powered by DuckDB-WASM, running entirely in the browser.

U.S. bank cohort analysis with DuckDB

A reproducible notebook using DuckDB to query bank financial Parquet, join institution identities, and check aggregates and null counts against Polars.

In 3 lists

Media >Talks

DuckLake - The SQL-Powered Lakehouse Format for the Rest of Us

Hannes Mühleisen.

Introducing DuckLake

Hannes Mühleisen and Mark Raasveldt.

DuckCon #6 playlist

DuckDB: Crunching data anywhere from laptops to servers @ GOTO Amsterdam 2024

Gábor Szárnyas.

DuckDB – Overview and latest developments @ DuckCon #5

Hannes Mühleisen and Mark Raasveldt.

DuckCon #5 playlist

DuckCon #4 playlist

DuckCon #3 playlist

In-Process Analytical Data Management with DuckDB @ PyData Amsterdam

Hannes Mühleisen.

DuckDB: The Power of a Data Warehouse in your Python Process @ PyData Yerevan

Gábor Szárnyas.

DuckDB: Bringing analytical SQL directly to your Python shell @ EuroPython

Pedro Holanda.

DuckDB keynote @ Data + AI Summit 2023

Hannes Mühleisen.

DuckDB: Bringing Analytical SQL Directly To Your Python Shell @ FOSDEM

Pedro Holanda.

State of the Duck @ DuckCon #2

Hannes Mühleisen & Mark Raasveldt.

DuckDB Extensions @ DuckCon

Pedro Holanda & Sam Ansmink.

Developing Systems in Academia: The Good, the Bad, and the not-so-Ugly Duckling @ CIDR

Hannes Mühleisen.

DuckDB An Embeddable Analytical Database @ FOSDEM

Hannes Mühleisen.

DuckDB tutorials playlist by Learn Data with Mark

Mark Needham.

DuckDB tutorials playlist by MotherDuck

Mehdi Ouazza.

Nextflow and database uses: powering data engineering, exploring DuckDB, and beyond

Edmund Miller.

Why should you care about DuckDB? @ Dublin DuckDB meetup

Mihai Bojin.

Exploring Monte Carlo Simulations With DuckDB @ Dublin DuckDB meetup

James McNeill.

DuckDB and recommenders: A lightning fast synergy @ Dublin DuckDB meetup

Khalil Muhammad.

Media >Podcasts

Developer Voices: Implementing Hardware-Friendly Databases

Hannes Mühleisen.

The Geek Narrator: DuckDB Internals

Mark Raasveldt.

Software Engineering Daily: DuckDB

Hannes Mühleisen.

Data Engineering Podcast: Move Your Database To The Data And Speed Up Your Analytics With DuckDB

Hannes Mühleisen.

The Analytics Engineering Podcast: The Personal Data Warehouse

Jordan Tigani.

DuckDB in Research

Series in Disseminate, the Computer Science Research Podcast, with host Jack Waudby.

Media >Blog Posts

Duck Takes Flight: Streaming Data in DuckDB

Adding concurrent read/write to DuckDB with Arrow Flight.

Modern Data Stack in a Box

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

How to use DuckDB, Motherduck and Kestra for ETL

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

DuckDB vs. MotherDuck — how do they compare

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

Building DuckDB Extensions with Zig and Nix

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

Exploring StarCraft 2 data with Airflow, DuckDB and Streamlit

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.

Link may be dead

DuckDB: The Rising Star in the Big Data Landscape

Link may be dead

DuckDB Doesn't Need Data To Be a Database

How DuckDB can provide a view over data stored in S3.

Securing DuckDB, Improving Startup Time, and Working Offline

How to set up DuckDB and how to work with extensions in an offline (and potentially sensitive) environment.

Datalore 2025.2 Is Out With Report Tabs, Extended DuckDB Support, and Snowflake Key Pair Authentication

Improved DuckDB support in JetBrains' Datalore collaborative data science platform

Using DuckDB WASM + Cloudflare R2 to host and query big data (for almost free)

Demo of using Cloudflare R2 hosting and a WASM DuckDB application to store and query data

SwanLake

An Arrow Flight SQL Datalake Service Built on DuckDB + DuckLake

DuckDB-Wasm on a Plain Static Host — Without Breaking AdSense

Why a static site ships the single-threaded build: SharedArrayBuffer, COOP/COEP, and the cross-origin isolation tradeoff.

Building duckdb-pst

How to go from 0 to a production-ready DuckDB extension for Outlook PSTs, including table functions, MAPI schema serialization, projection/statistics pushdown, concurrent planning, and late materialization.

How to Query Reservoir's Hyperliquid Data

Using DuckDB's httpfs extension and read_parquet to query Hyperliquid fills, candles and order book snapshots stored as Parquet in a requester-pays S3 bucket, pulling only the columns and time ranges a query needs.

DuckDB Explained: When a Database on Your Laptop Beats SQLite, Polars and BigQuery

Reproducible benchmark of DuckDB against SQLite, pandas and Polars on 11.2 million NYC taxi trips, where it replaces a warehouse and where it does not, with notes on DuckDB 2.0.

Five DuckDB recipes for market data CSV exports

DuckDB 1.x SQL examples using a synthetic CSV to check coverage and timestamp gaps, build UTC daily bars, and calculate close returns and rolling means.

Media >Books

DuckDB in Action

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

Getting Started with DuckDB

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

Link may be dead

Local-First Analytics

Building an analytics stack on one machine with DuckDB, Parquet and Arrow: performance, partitioning, data quality and orchestration, with runnable code. Chapter one is free to read online.

See category
99

Awesome DeepSeek Harness (DSH) Plugin

awesome-dsh-plugin/awesome-dsh-plugin

A curated list of plugins for DeepSeek Harness (dsh) · DeepSeek Harness 插件精选列表

Fresh★ 25k1416 entriesPushed today
98

Awesome OpenClaw Skills

VoltAgent/awesome-openclaw-skills

The awesome collection of OpenClaw skills. 5,400+ skills filtered and categorized from the official OpenClaw Skills Registry.🦞

Fresh★ 54k843 entriesPushed 16 days ago
96

Awesome Prompts

ai-boost/awesome-prompts

Curated prompts, frameworks and papers for LLMs and agents, with an engineering bias. Prompt engineering, context engineering, agent harnesses, red teaming.

Fresh★ 9.3k365 entriesPushed today
96

Awesome Open Source Alternatives

piotrkulpinski/open-source-alternatives

Curated list of open source alternatives to proprietary software.

Fresh★ 6.9k860 entriesPushed today
95

Awesome README

matiassingers/awesome-readme

A curated list of awesome READMEs

Fresh★ 22k144 entriesPushed 5 days ago
94

Awesome Persona Distill Skills

xixu-me/awesome-persona-distill-skills

Curated list of Agent Skills centered on people, relationships, commemorative scenes, and methodological perspectives

Fresh★ 4.7k72 entriesPushed today