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 web clients (webassembly) 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
- 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.
- Amphi ETL
Low-code data pipelines for structured and unstructured data. SQL transformations are powered by 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.
- Apple Embedding Atlas
A tool that provides interactive visualizations for large embeddings. Uses DuckDB.
- Arc
Time-series data warehouse built on DuckDB.
- Bauplan
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
- 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.
Resources
- Awesome DuckLake
A curated list of awesome DuckLake tools and resources.
- Compatible DuckDB extensions for AWS Lambda
Extensions specifically compiled for the AWS Lambda runtime (GLIBC 2.26).
- 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 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.
Libraries Powered by DuckDB
- BemiDB
PostgreSQL read replica optimized for analytics, using DuckDB.
- DuckDB.EFCoreProvider
Entity Framework Core provider for DuckDB and DuckLake, with LINQ, writes, migrations, bulk ingestion, and Parquet-backed tiered storage for .NET.
- duckdb_fdw
DuckDB Foreign Data Wrapper for PostgreSQL.
- 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.
- Fugue
A unified interface for distributed computing. Fugue executes SQL, Python, Pandas, and Polars code on Spark, Dask and Ray without any rewrites.
- Ibis Project
A DataFrame API for interacting with DuckDB (and other compute engines).
Showing a sample of 302 resources. View the full list on GitHub →