awesome-duckdb

Awesome DuckDB

A curated list of awesome DuckDB libraries, tools and resources.

DuckDB is an analytical in-process SQL database management system.

The Quack client-server protocol was released on 2026-05-12: see the Quack page.

DuckDB 1.5.0 was released on 2026-03-09: see the announcement blog post.

The DuckLake file format was released on 2025-05-27: see the website.

Contents

• Resources
• Installers
• Newsletters
• Logos and Icons
• Client APIs
• Tools Powered by DuckDB
• Backends
• Libraries Powered by DuckDB
• DuckDB Clients and UIs
  • Web Clients (WebAssembly)
• SQL Clients and IDE that Support DuckDB
• Projects Powered by DuckDB
• Integrations
• Client-Server Setups
• Extensions
  • Core Extensions
  • Community Extensions
  • Other Extensions
  • Extension Statistics
• Tutorials
• Media
  • Talks
  • Podcasts
  • Blog Posts
  • Books
• Contribute

Resources

• Official documentation - Official DuckDB documentation.
  • 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.
• 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.

Installers

• Official installation page
• Brew formula
• Third-party installation options. Note: these are not maintained by the core DuckDB team – proceed with caution.
  • 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
• 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

Commercial

• 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)

Open Core (Free & Open Source + Optional Paid/Hosted Tier)

• Evidence - Generate reports using SQL and markdown. The DuckDB connector allows querying across DuckDB, CSV, Parquet and JSON. (Evidence Cloud)
• Rill Data - Tool for effortlessly transforming data sets into powerful, opinionated dashboards using SQL. (Rill Cloud)
• Shaper - Open-source SQL-driven data dashboards, powering Taleshape, built on DuckDB. (managed hosting)

Free & Open Source

• 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.

Free (Proprietary / Source-Available)

• 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)

Data Exploration & Visualization

Commercial

• 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)

Open Core (Free & Open Source + Optional Paid/Hosted Tier)

• 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)

Free & Open Source

• 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.

Free (Proprietary / Source-Available)

• 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)
• Kavla - A collaborative data analysis tool. (proprietary; free to use)
• OpenSheet - Spreadsheet-style data tool with visual canvas, inline editing, and AI commands for SQL transformations. (proprietary; free to use)

ETL, Pipelines & Orchestration

Commercial

• Bauplan - A serverless data transformation platform for data lakes. (pricing)

Open Core (Free & Open Source + Optional Paid/Hosted Tier)

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

Free & Open Source

• 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.
• 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.

Free (Proprietary / Source-Available)

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

Query Engines, Federation & Warehouses

Commercial

• 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)
• 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)

Open Core (Free & Open Source + Optional Paid/Hosted Tier)

• 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)

Free & Open Source

• DataSpoc Lens - Virtual warehouse over cloud Parquet. SQL shell, Jupyter/Marimo notebooks, AI natural language queries, and local cache — all powered by DuckDB.
• Hugr - An data mesh platform and high-performance GraphQL backend 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.

Free (Proprietary / Source-Available)

• 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)

Data APIs, Integration & AI Access

Commercial

• Bonnard - Governed, multi-tenant MCP access to customer data. Connects DuckDB (and Snowflake, BigQuery, Postgres) to AI agents as a secure, per-customer MCP server. (pricing)
• Census - Census’s dataset diffing for incremental syncs is powered by DuckDB. (pricing — Census was acquired by Fivetran)

Free & Open Source

• 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.

Product, Web & Application Analytics

Open Core (Free & Open Source + Optional Paid/Hosted Tier)

• 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)

Free & Open Source

• 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).

Geospatial

Commercial

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

Free & Open Source

• 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.
• 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, Parquet, PostgreSQL and more.

Observability, Logs & Security

Open Core (Free & Open Source + Optional Paid/Hosted Tier)

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

Free & Open Source

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

Data Quality & Governance

Free & Open Source

• 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.

Free (Proprietary / Source-Available)

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

File Viewers & Pivot Tables

Free & Open Source

• 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.

Notebooks & Embedded Engines

Commercial

• Hex Dataframe SQL - Hex’s Dataframe SQL cells are powered by DuckDB. (pricing)
• Mode - Mode uses DuckDB for their in-memory data engine. (pricing)

SQL Tooling & Language Engines

Free & Open Source

• 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.

Free (Proprietary / Source-Available)

• 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)

Fun & Demos

Free & Open Source

• 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.
• DataSpoc Lens - Virtual warehouse over cloud Parquet. SQL shell, Jupyter/Marimo notebooks, AI natural language queries, and local cache — all 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).
• DBConvert Streams - Database IDE and migration tool with DuckDB-powered federated SQL.
• 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.
• 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.
• 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.
• 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.
• 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.

Free (Proprietary / Source-Available)

• 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.
• Hydra ETL - Declarative YAML ETL engine that can run each transformation step on DuckDB or pandas.

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.
• 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.
• 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.
• 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.
• 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.

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 – React app framework for small to mid-sized data analytics powered by DuckDB-WASM.
• 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.
• Medama - Self-hostable, privacy-focused website analytics.
• dbxlite - DuckDB workbench for native & browser.
• Joinery - Privacy-first local data analytics with a modern SQL editor, multi-format support (CSV, Excel, JSON, Parquet), and parameterized saved queries. Available as browser app and Tauri desktop client.
• 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.
• 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.
• VSCode SQLTools - Free open-source VSCode extension to query and explore your DuckDB databases with latest DuckDB support.
• DBeaver - DBeaver is a universal database access and development tool that can be used to connect almost any type of database.
• DataGrip - 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.
• 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.
• rainfrog - A database TUI with experimental support for DuckDB.
• 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.
• 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.
• Beekeeper Studio - Free, open-source SQL editor and database manager with native support for DuckDB, MySQL, Postgres, SQLite, SQL Server, and more.
• 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.

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.
• transfermarkt-datasets - Curated football datasets from Transfermarkt.
• 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.
• 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.
• 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.

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.
• 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.
• 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.
• 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.
• 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.
• 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.
• DuckDBExcelAddin - Native Excel XLL add-in for DuckDB with parameter binding, async execution and Excel range table functions.
• Bruin - Data pipeline CLI that runs SQL and Python transformations with built-in quality checks, using DuckDB as one of its supported platforms.
• ingestr - CLI tool to copy data between databases and SaaS sources, with DuckDB supported as both a source and a destination.
• omniload - Polyglot data loader for ETL, warehousing and more, based on dlt. Supports 140+ source/destination adapters. Derived from ingestr v0 (MIT).
• 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.

Client-Server Setups

• Crunchy Data Warehouse - Fully managed DBaaS based in PostgreSQL integrated with DuckDB.
• MotherDuck - A serverless cloud data warehouse powered by DuckDB.
• 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.
• rawquery - Managed analytical platform pairing DuckDB compute with Iceberg storage on S3. Postgres wire protocol, CLI, and Python API.
• Layerbase - Managed DuckDB hosting with a browser query console, REST API and CLI, alongside 17 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.

Extensions

Core Extensions

Official DuckDB extensions, which can installed via INSTALL ⟨extension_name⟩.

• 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.
• 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.

Community Extensions

Community-contributed DuckDB extensions, which can be installed via INSTALL ⟨extension_name⟩ FROM community.

• 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.
• 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.
• minijinja - Renders Jinja-compatible templates from SQL using MiniJinja.
• 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.
• 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.
• 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.

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.
• 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.

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.

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.

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.

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.
• DuckDB: The Rising Star in the Big Data Landscape
• 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.

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.
• 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.

Contribute

Contributions welcome! Read the contribution guidelines first.

This site is open source. Improve this page.