Skip to main content

🦆 A curated list of awesome DuckDB resources

2.5k
GitHub Stars
327
Curated Resources
16
Categories
5 hours ago
Last Refreshed
ResourcesInstallersNewslettersLogos and IconsClient APIsTools Powered by DuckDBBackendsLibraries Powered by DuckDBDuckDB Clients and UIsSQL Clients and IDE that Support DuckDBProjects Powered by DuckDBIntegrationsClient-Server SetupsExtensionsTutorialsMedia

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

Client-Server Setups

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.

Libraries Powered by DuckDB

  • AVA

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

  • BemiDB

    PostgreSQL read replica optimized for analytics, using DuckDB.

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

Resources

Showing a sample of 327 resources. View the full list on GitHub →