awesome-duckdb
github.com/davidgasquez/awesome-duckdb ↗🦆 A curated list of awesome DuckDB resources
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me file viewers & pivot tables resources from awesome-duckdb"
Installation instructions →What's inside
SQL Clients and IDE that Support DuckDB
- 1bench
Paid cross-platform desktop client supporting DuckDB alongside two dozen other databases, including relational, document, key-value, vector and search engines.
- AmoxSQL
The Modern Codex for Local Data Analysis. A high-performance, local-first IDE built specifically for DuckDB.
- Beekeeper Studio
Free, open-source SQL editor and database manager with native support for DuckDB, MySQL, Postgres, SQLite, SQL Server, and more.
- Dataflare
Simple easy-to-use database manager, supports DuckDB, PostgreSQL, MySQL, SQL Server, SQLite etc.
- DataGrip
Paid SQL IDE by JetBrains that supports many different database technologies, including DuckDB.
- DBeaver
DBeaver is a universal database access and development tool that can be used to connect almost any type of database.
Tools Powered by DuckDB
- ADPivotFile Viewers & Pivot Tables
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.
- Amphi ETLETL, Pipelines & Orchestration
Low-code data pipelines for structured and unstructured data. SQL transformations are powered by DuckDB. (Elastic License 2.0, source-available)
- AnkaFlowFun & Demos
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.
- Apple Embedding AtlasData Exploration & Visualization
A tool that provides interactive visualizations for large embeddings. Uses DuckDB.
- ArcQuery Engines, Federation & Warehouses
Time-series data warehouse built on DuckDB. (
- BauplanETL, Pipelines & Orchestration
A serverless data transformation platform for data lakes. (
Integrations
- Airbyte DuckDB destination
Load data to DuckDB with Airbyte.
- Bruin
Data pipeline CLI that runs SQL and Python transformations with built-in quality checks, using DuckDB as one of its supported platforms.
- Cloudflare R2 Data Catalog connector
Connect to Cloudflare R2 Data Catalog with DuckDB.
- data load tool - DuckDB destination
Extract and load data from APIs to DuckDB using dlt.
- dbt-duckdb
DuckDB dbt adapter.
- DuckDBExcelAddin
Native Excel XLL add-in for DuckDB with parameter binding, async execution and Excel range table functions.
Client-Server Setups
- AliSQL
A MySQL branch originated from Alibaba Group. Integrates DuckDB as a native storage engine.
- Crunchy Data Warehouse
Fully managed DBaaS based in PostgreSQL integrated with DuckDB.
- GizmoSQL - Arrow Flight SQL Server
A C++ implementation of the
Projects Powered by DuckDB
- 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.
- Caso Abierto
Detective game where each case file is a set of Parquet tables queried with SQL, running DuckDB-WASM in the browser.
- database
Daily dumps of endoflife.date data.
- Datadex
Open-source and local-friendly data platform to collaborate on Open Data using DuckDB, Dagster, dbt, and Quarto.
- datagenerator2
Generates random data, allowing to define dependencies between individual fields and varying/definable distribution of field values.
- 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.
Resources
- Awesome DuckLake
A curated list of awesome DuckLake tools and resources.
- 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.
- DuckDB clients
Client APIs for DuckDB.
- duckdb-docker
Official Docker image for the DuckDB CLI.
- DuckDB documentation MD
The DuckDB documentation as a single Markdown file.
DuckDB Clients and UIs
- BedevereWeb Clients (WebAssembly)
Tabular data visualizer and DuckDB SQL editor on DuckDB-Wasm: open CSV/Parquet/JSON/Arrow locally, chart results with a grammar-of-graphics
- CodapiWeb Clients (WebAssembly)
Embed executable code snippets directly into your product documentation, online course or blog post.
- csvtodashboardWeb Clients (WebAssembly)
Free SQL-on-CSV in the browser via DuckDB-Wasm — no signup, no upload, files stay on-device.
- DBConvert Parquet ViewerWeb Clients (WebAssembly)
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
- dbxliteWeb Clients (WebAssembly)
DuckDB workbench for native & browser.
- DuckDB TerminalWeb Clients (WebAssembly)
Online DuckDB shell powered by DuckDB WASM and Ghostty.
Showing a sample of 317 resources. View the full list on GitHub →