Extensions

Integrate Lance (modern columnar data format for ML implemented in Rust) with DuckDB.

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

SQLAlchemy driver for DuckDB.

LLM & RAG extension to combine analytics and semantic analysis

Integrate language model (LLM) capabilities directly into your queries and workflows.

Read and write Google Sheets using SQL.

Queries Apache Arrow Flight services from DuckDB SQL.

Run PRQL commands directly within DuckDB.

Provides a hello world example demo

DuckDB HTTP API Server and Query Interface.

Adds support for the H3 discrete global grid system.

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

Distributed execution for DuckDB queries.

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

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

A DuckDB extension for graph data analytics.

A DuckDB extension for in-database inference.

Connect DuckDB to Microsoft SQL Server via native TDS (including TLS).

QuackStore - Smart Block-Based Caching for Remote Files. Speed up repeated queries on remote data with intelligent block-level caching.

Provides a hello world example demo from the Rust-based extension template

Fully local data canvas and dashboarding app within DuckDB.

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

Support for PSQL, a piped SQL dialect for DuckDB

Query OpenTelemetry traces, logs, and metrics with SQL — or stream live OTLP/HTTP into DuckDB, DuckLake, or Iceberg

Allows shell commands to be used for input and output.

ClickHouse SQL Dialect macros for DuckDB.

DuckDB extension to allow running SQL on arbitrary data sources.

Allows the consumption and production of the Apache Arrow interprocess communication (IPC) format, both from files and directly from stream buffers.

Store writable DuckDB databases in local or S3-compatible object storage through SlateDB

DuckDB extension to read data directly from databases supporting the ODBC interface.

DuckLineage automatically captures data lineage from every DuckDB query and emits OpenLineage events.

Makes HTTP GET and POST requests from SQL.

An Excel/WPS/OpenDocument Spreadsheets file reader for DuckDB

Comprehensive processing extension for web markup languages (XML and HTML) with SAX streaming for large files, intelligent schema inference, XPath-based data extraction, and HTML table parsing.

Read files within zip archives

Allows conversion execution of Substrait query plans

Model Context Protocol (MCP) extension for DuckDB that enables seamless integration between SQL databases and MCP servers. Provides both client capabilities for accessing remote MCP resources via SQL and server capabilities for exposing database content as MCP resources.

HNSW vector search with ACORN-1 filtered search, RaBitQ quantization, metadata joins, and grouped nearest neighbors

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

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

Snowflake data source extension - query Snowflake databases directly from DuckDB

Query Zarr array stores (v2 and v3) with SQL — read xarray-convention datasets as tables

DuckDB SAP connector using RFC, ODP, or BICS.

Interact with LLMs with a simple DuckDB Extension

DuckDB extension for reading and writing geospatial raster data using SQL.

Queries Apache Kafka topics from DuckDB SQL.

Integrates DuckDB with MongoDB, enabling direct SQL queries and writes over MongoDB collections without ETL

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.

Fast, parallel Excel (XLSX) loading with low memory overhead.

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

Build native DuckDB extensions in C#.

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

Adds ISO GQL graph querying and graph algorithms to DuckDB

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

Connect to any ODBC-compatible database and query data directly from DuckDB

Connects DuckDB to any database that has an Arrow Database Connectivity (ADBC) driver.

Global spatial data processing on the sphere

Query Apache Paimon tables directly from DuckDB

Read and dissect PCAP files from DuckDB

Statistical timeseries forecasting in DuckDB. Supports ARIMA, ETS, Theta, TBATS, MFLES, MSTL, Croston, GARCH, and other models.

WebSocket and Redis Pub/Sub messaging from SQL.

Read and write RDF, query using SPARQL

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

Integrates DuckDB with DeepSeek 3FS distributed file system.

Extension that allows parsing the data model embedded in PowerBI (pbix) files

Schema-less JSON and OTEL ingestion shredder for DuckDB

Versioned DuckDB databases - snapshots, time travel, branches, clones and S3 export over native storage

Bindings to ggsql — Grammar of Graphics based visualizations in SQL

A Zig & Nix toolkit template for building extensions against multiple versions of DuckDB using Zig, C or C++.

Read data sets from SAS, Stata, and SPSS with ReadStat

Parse and analyze source code ASTs from 28 programming languages with tree-sitter grammars, pattern matching, and structural search

Extension that adds support for reading data from EUROSTAT database using SQL.

Provides a hello world example demo from the C/C++ C API template

Provides access to faiss indices from DuckDB.

Navigate and explore the local filesystem using SQL.

Performs fuzzy string matching for autocompletion.

DuckDB GCS Extension

Read, analyze, and write Markdown files with block-level document representation and inline element support

Cryptographic hash functions and HMAC.

ERPL Web is a DuckDB extension that connects API-based ecosystems via standard interfaces like OData, GraphQL, and REST.

Extensions providing OAuth and OpenID primitives for authentication and authorization for the DuckDB quack server.

A DuckDB extension written in Rust for querying, analysing and inspecting AI coding agents history. Read conversations, plans, todos, history, and usage stats directly from your local agent data directories.

Plugin for querying encoded protobuf messages (both sequences and individual messages per file).

Query DuckDB from PostgreSQL and Arrow Flight SQL clients, including psql, ADBC, and Airport

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.

Efficiently query large chess game collections

Smart Development Intelligence for DuckDB - Git-aware data analysis capabilities that allow querying git history, accessing files at any revision, and performing version-aware data analysis with SQL.

Exposes functions for parsing referenced tables and usage context from SQL queries using DuckDB's native parser.

Extension that adds support for manipulating point cloud data using SQL.

Probability distributions, random sampling and statistical functions.

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

Read OpenStreetMap data from OSM XML and PBF files

Evaluates the Rhai scripting language as part of SQL.

Transpile SQL from 34 different dialects into DuckDB SQL

Interactive chart visualization for DuckDB - faster than pandas with Plotly-like charts

DuckDB WireGuard Extension to Quack & Ducklake over Tailscale/Headscale

DuckDB extension for reading data from SpatioTemporal Asset Catalogs (STAC) using SQL.

Queries other databases from DuckDB using ADBC drivers.

Compact geometry storage with coordinate quantization and delta encoding.

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

Query Elasticsearch indices directly using SQL.

Provides a spreadsheet-style pivot_table function

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

Query Common Crawl and Wayback Machine web archive CDX APIs directly from SQL

A DuckDB extension for data quality, validation and anomaly detection in SQL - 18 data quality checks (volume, nulls, freshness, schema drift, regex and value-set compliance, duplicates, referential integrity, time-aware baselines) with a table-driven check-suite runner, column profiling and correlations including nested types, hash- and join-based table diffing, anomaly detection with Isolation Forest (categorical, Extended IF, SCiForest), DBSCAN and explainable OutlierTree, PII detection and masking (17 types including IBAN, credit cards, API keys and NER-based names, organizations and locations), email validation with DNS/SMTP checks, international address parsing (libpostal), phone number validation (libphonenumber), EU VAT validation (28 countries), and currency-aware money arithmetic.

ClickHouse Native Client & File Reader for chsql

Query NATS JetStream message streams directly with SQL

DuckDB Pyroscope Extension for Continuous Profiling

Read YAML files into DuckDB with native YAML type support, comprehensive extraction functions, and seamless JSON interoperability

Connecting duckdb to the mlpack C++ machine learning library

Automatic query privatization using the PAC Privacy framework

DuckDB extension for reading HTS file formats via htslib

A DuckDB extension for working with Kaggle datasets.

Semantic views -- a declarative layer for dimensions, metrics, and relationships

A DuckDB extension for statistical regression and inference in SQL - OLS, Ridge, Elastic Net, LARS/LassoLars, WLS, recursive least squares, robust estimators (Huber, RANSAC, Theil-Sen), GLMs (Poisson, Negative Binomial, Binomial, Tweedie, Gamma, Logistic) with offset support, mixed-effects/hierarchical GLMs with random slopes and crossed/nested factors, AFT survival regression, explicit priors with Laplace intervals, empirical-Bayes shrinkage, and time-series regression, all with full diagnostics and inference.

This extension allows you to connect DuckDB to Microsoft Fabric OneLake workspaces and lakehouses, enabling you to query data stored in OneLake directly from DuckDB.

Plugin for reading DuckDB spatial tables in QGIS software.

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

Fuzzy string matching and edit-distance functions using RapidFuzz.

Pentagon-based geospatial indexing with the A5 global grid.

The DNS Extension enables DNS lookups and reverse DNS lookups from within DuckDB

Stream changes from your DuckLake — durable consumer cursors, single-reader windows, typed DDL events.

Choose a file via native file dialog

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

Call LLMs from SQL to classify, summarize, extract typed fields, embed and search text, or query your tables, with local models or 35+ hosted APIs

R dplyr pipeline syntax support for DuckDB - transpiles dplyr verbs to SQL

The FakeIt Extension enables generation of realistic fake/test data directly in SQL queries

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

Reads and writes Redis data from SQL.

Behavioral analytics functions inspired by ClickHouse (sessionize, retention, window_funnel, window_funnel_events, sequence_match, sequence_count, sequence_match_events, sequence_next_node)

SQL-native web crawler with HTML extraction and MERGE support

Cheminformatics with RDKit for DuckDB - SMILES/SDF molecules, substructure search, and molecular descriptors.

DuckDB extension for querying Power BI Semantic Models with DAX.

Allows the consumption FIX protocol format logs, from all supported duckdb filesystems.

Bert-based embedding extension.

Raster analytics on Raquet files with QUADBIN spatial indexing, raster ingestion, and PostGIS-style functions

Loads SQL macros from remote URLs.

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

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

Runs JavaScript from SQL using the QuickJS-NG engine.

Query Arrow Flight SQL servers that expose DuckLake-based catalogs and tables directly from DuckDB using standard SQL — including PostHog's managed data warehouse via [Duckgres](https://github.com/PostHog/duckgres).

Extension for locality-sensitive hashing (LSH)

Evaluate Lua scripts within queries

Extension that allows DuckDB to connect to Microsoft SQL Server Analysis Services (SSAS) and other OLAP data sources using the MSOLAP provider

Read PCAP files from DuckDB

Predictive queries as SQL. TRAIN a model on the tables you already have, PREDICT with it, BACKTEST it.

Allows reading and writing files over SSH

Read AnnData (.h5ad) files for single-cell genomics data analysis, with support for local and remote (HTTP/HTTPS/S3) files

Render charts and dashboards straight from SQL — the ggplot-rs grammar of graphics, emitted as SVG.

Ask your tables questions in plain language — filter, rank and classify rows with a condition you write as a sentence

Connect DuckDB directly to Oracle databases for reading and writing tables, with catalog integration, pushdown, spatial geometry, and vector support

System monitoring & SQL query routing for DuckDB - 25+ table functions for CPU, memory, disk, network, processes, Docker, GPU. Execute queries on remote databases via PostgreSQL wire protocol with SQLGlot dialect translation (PostgreSQL, MySQL, ClickHouse, Snowflake, BigQuery).

Secure remote secrets storage with OPAQUE PAKE authentication, email/password registration, MFA login, and automatic ducklake mounting

Export DuckLake catalog tables to Delta Lake format

Read HDF5 files from DuckDB

DuckLake with its catalog in Microsoft SQL Server or Azure SQL - embedded DuckLake, native TDS through the mssql extension.

Read, OCR, inspect, transform, and write PDFs in SQL

SQL parsing and introspection for IDEs, editors, and developer tools

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

Read multiple geospatial files

glob, open and read files within `.tar` archives

Speech-to-text transcription using whisper.cpp, OpenAI's Whisper model

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

Live SQL Queries on Blockchain

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

Read, write, and query CityJSON, CityJSONSeq, FlatCityBuf, and CityParquet 3D city model files.

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

Approximate nearest-neighbor vector indexes (HNSW / IVF / DiskANN / SPANN) with pluggable quantizers (Flat / RaBitQ / PQ / ScaNN)

Zero-shot tabular machine learning inside DuckDB — classification, regression, synthetic-data generation and imputation with real tabular foundation models (Mitra, TabDPT, TabPFN v2/2.5/2.6/3, TabICL, Orion-BiX/MSP, TabFM, LimiX-2M, Causilo) on ONNX Runtime, no training loop

Retrieve geo ip data from MMDB database

DuckDB geospatial visualization with deck.gl and MapLibre

String case conversion, pluralization and singularization functions.

Optimized-plan inspection and cross-system SQL transpilation

In-process LuaJIT UDFs for DuckDB — JIT-compiled, parallel (per-thread states), trusted sandbox, GROUP BY aggregates, LIST/STRUCT/MAP bridges, embedded Fennel compiler

Bioinformatics extension for microbiome research - read/write FASTQ, SAM/BAM, BIOM, GFF, Newick trees, query NCBI, and more.

Read Iceberg tables written by moonlink in real time

Query AiM MP4, Cosworth PDS, MoTeC LD, Racelogic VBOX and .telemetry recordings directly in DuckDB, with stint-aware laps

A collection of virtual filesystems for working with scalars

Renders Tera templates from SQL.

DuckDB extension for routing and travel time calculations using Valhalla routing engine

DuckDB extension for converting GEOMETRY/WKB to and from GeoArrow native encodings, powered by geoarrow-c.

Query files in Google Drive directly with a gdrive:// filesystem

Evaluates JSONata expressions against JSON values in SQL.

Read MaxMind databases (GeoLite, GeoIP, and more)

Query a DuckDB behind NAT from anywhere, over an encrypted peer-to-peer connection

WHATWG URLPattern API for matching and extracting components from URLs using pattern syntax

Git-like branching for analytical databases. Attach isolated what-if scenarios as catalogs, edit them with ordinary SQL on copy-on-write delta storage, branch, diff, and merge them back.

Cloud-Optimized ZIP reader for DuckDB

Diff two relations (tables, queries) off a primary key, reporting per-key status (identical/different/left_only/right_only), a JSON summary of changed columns, and per-column left/right values.

Parse and analyze test results, build outputs, and CI/CD pipeline logs from 110+ formats with severity filtering, format auto-detection, and context extraction

Remote storage filesystem for DuckDB via Apache OpenDAL — S3, GCS, Azure, Hugging Face, WebDAV, SFTP, and more, with DuckDB secret-based auth.

Intelligent query result caching between DuckDB and Snowflake with TTL and smart refresh

SQL-native quant finance functions for DuckDB

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

libmagic/file utilities ported to DuckDB

Renders Jinja-compatible templates from SQL using MiniJinja.

Pokemon data native in DuckDB

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

>-

Technical Analysis Library (TA-Lib) functions for DuckDB -- 100+ indicators for financial market analysis

Zero-shot probabilistic time-series forecasting in SQL with Mistral's Timestral models, on CPU via ONNX Runtime

Compressed vector search for DuckDB — Google TurboQuant quantization, IVF indexing, incremental CRUD, cosine/L2/dot

DuckDB Extension for Delta Sharing

Query Oracle Fusion from DuckDB through BI Publisher, with SSO, an ATTACH-able catalog and cached metadata

The Apache Ossie (incubating) extension for DuckDB. Reads Ossie

A DuckDB extension that implements Predicate Transfer: derives filters from join keys and propagates them across the join graph of a multi-join query, so probe-side rows that can't survive downstream joins are pruned early.

Phonetic, text normalization and address matching functions for record linkage.

Generates time-sorted unique identifiers.

Parse WARC (Web ARChive) records for Common Crawl data processing

Read and write .zim (Kiwix / openZIM) archives directly in DuckDB via libzim, from local files or remote S3/HTTP — offline Wikipedia, WikiMed, Stack Exchange, iFixit, and more, with a zim:// filesystem, full-text search, and COPY TO for building archives from any query.

Combinatorial decision algorithms as SQL — bin packing, knapsack, wave batching, sequencing, scheduling, assortment and portfolio selection

Extension that adds support special decimal arithmetic functions

Attach a directory of Delta tables as a single DuckDB database with automatic schema discovery

DuckDB extension to read JFR (Java Flight Recorder) files directly.

The long-awaited Dutch localization of DuckDB's SQL dialect

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.

Read Garmin .fit files using DuckDB - GPS tracks, heart rate, power metrics, and fitness device data

Experimental gh:// filesystem support

Read HDF5 datasets and attributes

Read X12 EDI 835 remittance files as tables, losslessly, and write tables back into an 835

Graph algorithms for DuckDB — PageRank, shortest path, SCC, MST, and more via petgraph

Read and write PLINK 2 genomics file formats and run common genetic analyses directly in SQL

Query Prometheus-compatible HTTP APIs directly from DuckDB

Query ISO 20022 (camt, pacs, pain) and SWIFT MT financial messages as SQL

Read line-based text files with line numbers and efficient subset extraction. Supports glob patterns, line selection with context, and GitHub-style '#L12-24' fragments so a line range can be attached to any path, including URIs served by other extensions.

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

Query and write Apache TsFile table-model files from DuckDB

Read Zeek network security monitor log files with automatic schema detection and type-aware parsing

GDAL-free Cloud-Optimized GeoTIFF (COG) reader — query remote rasters in place over HTTP range reads, with STAC catalog integration

Compose fast bounded judgments, semantic resolution, and selective LLM reasoning with provenance

Data quality assertion framework — SQL-native expect_* rules, profiling, and persisted quality reports

Define and run data-quality tests inside DuckDB

Build, transform, validate, and extract content from structured documents using the duck_block type

The most efficient way to query Delta Lake tables directly from DuckDB via the Delta Sharing protocol.

Browser-based BI dashboard extension for DuckDB. Run SQL queries and build interactive dashboards with drag-and-drop charts, all from the DuckDB CLI.

Asset-centric data orchestration with JSON ingestion, partitions, declarative automation sensor, Snowflake-compatible CREATE DYNAMIC ASSET, MCP server, lineage and OpenLineage emission — all on DuckDB

Turn DuckDB into a node of a trustless peer-to-peer query grid — SQL is cross-checked by independent hosts to a verifiable quorum over QUIC, with optional pay-per-query compute settled on TON

Reach any TCP service from DuckDB through an SSH bastion, Tailscale or NetBird — and publish local ports back onto those networks.

The first Firebird extension in the DuckDB Community Extensions registry. Federated read-only access to Firebird (3.0/4.0/5.0) databases from DuckDB, with projection + filter pushdown, INT128 / DECIMAL(38) / TIMESTAMP_TZ support, native ATTACH, and CHARACTER SET NONE handling (default win1252; strict / iso8859_1 / blob also available) with filter-pushdown correctness on transcoded columns.

Dynamic function invocation - call any scalar function or macro by name at runtime

Authorization for untrusted read-only SQL from tenants, LLM agents, and dashboard builders. Validate a statement without executing it, or enforce a lockable policy on the connection itself, with an audit log of every decision.

Attach Apache Hive Metastore as a native DuckDB catalog and read/write the data inside with ease!

Read AWS Ion data and write Ion text or binary with typed mappings

Validate, decode, and extract OAST (Out-of-Band Application Security Testing) domains in SQL

Read and write Oracle Database with no Oracle client

Overture Maps helpers for DuckDB - geocoding, category normalization, spatial tiling, and reader macros for places, buildings, roads, and addresses

Read DBF (dBase) files with support for general DBF formats and field types.

Query SharePoint lists and Excel workbooks directly from DuckDB

Provides table functions to access system-level statistics for monitoring purpose

Observability into DuckDB storage internals at the database, table, and column levels

Multi-modal product similarity search for manufacturing supply chain planning. Find similar materials by BOM component overlap (Jaccard), graph-structural similarity (Weisfeiler-Lehman kernel), text embeddings, and transactional patterns, with predecessor detection and cold-start analog matching for demand forecasting.

This extension is an alias to the nanoarrow extension. Allows the consumption and production of the Apache Arrow interprocess communication (IPC) format, both from files and directly from stream buffers.

Astronomical calculations + FITS file I/O - coordinate transforms, photometry, cosmology, dust extinction, sidereal time

Graph routing for DuckDB - shortest paths, flow, spanning trees and more, following pgRouting's semantics and powered by the Boost Graph Library.

Cheminformatics and CPU numerical analytics for DuckDB - molecular formats, descriptors, fingerprints, similarity, regression, statistical inference, experimental design, time series, reliability and model evaluation from SQL

Compile C from SQL into scalar, aggregate, and table functions in-process with an embedded TinyCC; no compiler or runtime files needed

Adds a dynamodb_scan function that enables querying DynamoDB tables.

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

Query Google Cloud Firestore directly from DuckDB using SQL

HTTP client extension for DuckDB with GET/POST/PUT/PATCH/DELETE and byte-range requests

Call LLM APIs (OpenAI, Gemini, Cloudflare) directly from SQL with structured output support.

A DuckDB extension for reading Apache ORC files, written in pure Rust. Supports all ORC primitives, struct, list, map types and all compression codecs (Zlib, Snappy, LZO, LZ4, ZSTD).

Read documents natively into the duck_block vocabulary -- DOCX, ODT, EPUB, RTF, LaTeX, Org, RST, ipynb, MediaWiki and Textile -- and write them back as Pandoc JSON, without linking Pandoc

DuckLake and DuckDB databases on PostgreSQL - pgvfs:// stores data files as PostgreSQL rows for many writers and readers; pgdb:// stores a DuckDB database for one writer and many readers

3D solid processing for city models — enclosed volume, validation, distance, and measurement of polyhedral solids.

Efficiently standardizes scraped job titles to Bureau of Labor Statistics (BLS) titles using a high-performance TF-IDF algorithm.

US address parsing and standardization (PAGC + Rust addrust)

Natural-language decisions on your data inside DuckDB — yes/no probabilities, one-of-N choices and ordinal scores with the answer sets written in the query, from hosted (TypeSafe Jev, Liquid AI D1), local-server and in-process ONNX decision models, plus calibration metrics

Astronomical coordinates utilities

A DuckDB extension for parsing and analyzing chess games in PGN format.

>

DuckDB filesystem extension for CWIQ FS

Read logs from the Datadog Logs Search API into OTLP-shaped tables

Lazy Machine Learning Imputation Architecture in DuckDB.

"Pure C DuckDB extension exposing a DuckDB-backed SQL and RPC server over NNG using Arrow IPC — with framed RPC, custom HTTP routes, TLS support, body codec layer, and admission controls"

Read & write SAP IDoc files (flat + IDoc-XML) as SQL in DuckDB — a community extension in the erpl family.

WGS84, GCJ02 and BD09 coordinate transformations and exact Jenks natural breaks

Read GeoTIFF rasters as (cell_id, value) via GDAL

Query Apache Hudi COW and MOR tables directly in DuckDB — full scans, time-travel (as_of), incremental windows, and table metadata — powered by the Rust hudi-rs kernel.

Largest-Triangle-Three-Buckets and related time-series downsampling aggregate functions.

Read, write, validate and edit MARC 21 bibliographic data (ISO 2709, MARCXML, MARC-in-JSON, breaker, Aleph; UTF-8 and MARC-8)

Read Oracle tables in parallel (ATTACH, oraduck_scan) and load query results into Oracle through the OCI Direct Path API

Lightweight Geohash utilities for DuckDB, including coordinate and geometry encoding, cell decoding, bounding boxes, and neighbors.

Time series forecasting and statistics for DuckDB

Perform rate and burst limit on filesystem operations

Read-only access to Salesforce orgs as DuckDB SQL tables over the official REST and Bulk APIs — OAuth refresh-token or JWT-bearer auth (credentials from inline options, environment variables, or an SFDX auth URL), native ATTACH, projection + predicate pushdown, COUNT pushdown, explicit server-side aggregates with GROUP BY, lazy/auto/Bulk transports with PK chunking (Bulk blob/base64 compatibility guard), a per-job API quota governor, parent + grandparent relationship STRUCT columns with diagnostics, queryAll (archived + deleted), Tooling-API fast schema, and metadata helpers (manual cache refresh, picklist values, record types). Requires DuckDB v1.5.4 or newer.

Query Slovenia's SiStat (SURS PX-Web API) open data directly from DuckDB with SQL.

Parse XML sitemaps from websites with automatic discovery via robots.txt

Enforces table-level access control via an allowlist mechanism, blocking queries to unauthorized tables with a PermissionException

Get locally homebrew casks, packages and formulas and their dependencies as nicely typed tables

Connect to Apache Cassandra, ScyllaDB, and DataStax Astra databases directly from DuckDB. Query Cassandra tables using SQL with support for all major Cassandra data types, SSL/TLS connections, and cloud deployments.

Creates chaos! ⋆✴︎˚｡⋆ Chaos allows you to throw any type of DuckDB exception, or to raise a SIGSEGV, SIGABRT, or SIGBUS signal.

Provides mathematical clamp functions for numeric types in DuckDB, including general clamping, saturate, and others. Ensures values stay within a specified range and handles NULLs and NaNs correctly.

AWS CloudFront signed cookie authentication for DuckDB httpfs

Read and write Amazon CloudWatch telemetry with OTLP-shaped SQL tables

Read and write Databricks tables directly from DuckDB.

|

Read and write Stata .dta files (formats 117-121, Stata 13-18) with full type mapping, value labels, and strL support.

DuckDB extension for discrete global grid systems (DGGS) powered by DGGRID v9.1.

Chinese pinyin conversion, polyphonic phrase disambiguation, and ordered pinyin matching

SQL-native histogram GBDT in DuckDB with vendor dump import and plain-SQL export

Load portable WebAssembly extension modules into DuckDB from SQL

Extension that adds support for working with the EEA Reference Grid System.

Query filesystem metadata using SQL with recursive directory traversal

Query Google Cloud logs, metrics, alerts, and service topology from DuckDB

NYC address, BBL, and BIN geocoding with explicitly versioned Geosupport engine and data bundles

Provides hedged request for filesystem operations

HiGHS - High Performance Optimization Software

Holt-backed metadata indexes for fast DuckDB file discovery

Query HTML using CSS selectors, extract JSON from LD+JSON, JavaScript variables, and Next.js RSC

Improv's spreadsheet formula language (681 functions) and multidimensional models (categories, measures, formulas over them) on DuckDB tables

Analytics-optimized JSON storage — parse one time and read many times, and shred hot paths into typed columns for pushdown and row-group pruning

Read AGS4 geotechnical data files as typed, UUID-keyed tables directly from SQL — born-typed columns, deterministic content-addressed keys that join across groups by construction, and an embedded AGS dictionary. A read-only SQL surface. Local, http(s):// and s3:// (with httpfs).

Query and create LeRobot v3 datasets, including frame data, images, and video observation windows.

Datomic-compatible Datalog query engine as a DuckDB extension

Access S3, local filesystem, and other storage services through Apache OpenDAL

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

Read (streaming) and write Qlik QVD files

ROCKET random convolutional kernel features for time-series classification

Query files in SharePoint / OneDrive directly with a sharepoint:// filesystem

Read logs from a Splunk search REST API into OTLP-shaped tables

Attach Superhuman Docs documents as DuckDB databases and query or modify their tables with SQL

Use TypeSafe Jev (or another AI, even a free one on your laptop) to sort, filter and check the text in your tables. Get yes or no, pick one, or a rating, see how sure it is, and never spend more than your limit.

Query Altertable's lakehouse directly from your local DuckDB.

Evaluate affine decision trees in SQL

BVH (BioVision Hierarchy) motion capture file parser for DuckDB

Read and write ClickHouse tables directly from DuckDB.

Adds LZ4, Snappy, Brotli, Bzip2, and XZ file compression support

Arrow IPC over HTTP client with array functions and bloom filters

Read Databento DBN (Databento Binary Encoding) market-data files, including Zstd-compressed .dbn.zst captures, directly as SQL tables

DuckDB extension for DocumentDB metadata and SQL integration, with schema inference scaffolding and collection access helpers.

Phonetic algorithms for German and European name matching

Complete quantstats HTML tearsheets from SQL - one long table in, one full report per instrument out, benchmarks included

Pack sparse join build side into compact variants.

Read GAMS GDX files directly into DuckDB

Read GORpipe .gorz and .gord files and write .gorz as native DuckDB tables

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

>-

Hex9 hierarchical hexagonal DGGS — point encoding, layer binning, cell geometry as WKB, labels, k-rings, Hamiltonian-curve ordering, and grid enumeration

Better HTTP statistics for DuckDB

Reads and parses Apache HTTP server log files

Add per-operation timeout and retry for httpfs extension

Discover, query, profile, and estimate the storage of Hugging Face datasets

DuckDB extension for Keboola Storage — query and write Keboola tables using standard SQL

Smart DuckLake table maintain (adaptive rewrite + merge) and catalog-global expire/cleanup

Reader for the Lastra columnar time-series format

Used to inject simulated latency to filesystem operations

Generate LDBC SNB BI datasets directly from DuckDB

Query the Live Tennis API from SQL - live matches, upcoming fixtures and player search as table functions

Read and write protein structure mmcif files using SQL

Read and write FIS Prophet files (.rpt, .prn, .fac)

Read and write NSV (Newline-Separated Values) files

>

Picture-to-vector — image embeddings from SQL via tract-onnx (Rust). Bundles Meta's EUPE ViT-T/16; works with any ONNX vision model.

Deserialize Protocol Buffer messages stored in DuckDB columns

Query Brendan Gregg folded CPU/allocation profiles as DuckDB tables

Reject queries before physical execution when estimated table scans exceed a configured row budget

S2 geography + GeoTIFF raster for DuckDB — cell covering, pixel read, stats, histogram

Provides SE(3) rigid transformations (combinations of rotations and translations in 3D) as DuckDB scalar functions.

Read DuckDB database files written in a newer storage format than this DuckDB supports

BM25 full-text search for DuckDB — tokenization and Snowball stemming via tantivy, through DuckDB's C Extension API (quack-rs), no Arrow IPC

Parse TOML documents into JSON

Your company login, your role's secrets: S3, Postgres, APIs and more from a secrets service, with nothing on the laptop.

Native Trino-compatible scalar functions (trino_*) for the cases where DuckDB's built-ins diverge from Trino on Unicode and byte-level inputs — Trino's simple per-code-point case mapping, code-point reverse, Java-whitespace trim, NFC normalize, and raw-bytes xxhash64/sha512/hmac_sha256

Allows reading and writing files over WebDAV protocol

Read Azure Blob / ADLS Gen2 (abfss/az/wasbs) over HTTPS+SAS, without the Azure SDK (Wasm-friendly)

|

Filter, classify, and score text with OpenAI Decisions or Cloudflare Clef

Differential-privacy publishing in SQL — dp_count/dp_sum/dp_mean with the classic Laplace mechanism (pure SQL macros, deterministic reproducible noise)

Estimate Parquet scan bytes for SELECT queries without executing them

Query LabKey Server tables with automatic local Parquet caching

Bridge between SQL Server and DuckDB - import a SQL Server database, run T-SQL on DuckDB through a built-in translator, export back as a live load, a restorable .bak, PostgreSQL or Parquet

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.

Search Slack messages directly from DuckDB

Statistical plotting in SQL - a thin wrapper around the Rust library kuva, with the statistical semantics of seaborn and ggplot2 but no Python or R environment, on every platform DuckDB runs (console, JVM, Python, Node, browser)

Wrap Rust's open and sanitize-filename crates for SQL — open a path, a URL or the output of a query with your desktop's own program, and turn a string into a usable file name

Statistical functions from the Rust statrs crate - 34 aggregates and 509 scalars covering every statrs module

Approximate DNA, IUPAC and ASCII string matching with SIMD Sassy kernels, including CRISPR guide search

ASK() — natural-language SQL for DuckDB, grounded in your dbt Semantic Layer

Answers count, sum, avg, min, max and GROUP BY over many-to-many equi-join graphs without materialising the join

Read and write hdfs:// URLs via a native HDFS filesystem — no JVM or libhdfs required

Extract readable content from HTML using Mozilla's Readability algorithm

Native INTERLIS model introspection and streaming XTF support for DuckDB

Decode and work with JWT (JSON Web Token) in SQL queries

Stream any DuckDB query into Lance datasets with Blob v2 storage and scalar, vector, text, and Bloom filter indexes

Storage extension wrapping LevelDB with pivot semantics for structured relational tables over key-value pairs

Query Grafana Loki from DuckDB in plain SQL, with label/time/line-filter pushdown into LogQL

Read, analyze, generate, and play MIDI files with SQL. Provides table functions for parsing Standard MIDI Files, scalar functions for note/frequency conversion, and macOS playback via AudioToolbox.

Currency-aware monetary values with parsing, arithmetic, and real-time exchange rates

Parse, validate, format, and group Nigeria's NIPOST digital postcode (NDAPS)

Extension for querying Px-files with DuckDB.

High-performance lossless log parsing, analytical database compaction, and information-theoretic semantic accounting.

Read and write Rerun .rrd recording files, including live recordings

Profiles what the values in a table mean rather than what shape they are — semantic type per column, PII and format drift, and cross-column contradictions

Text becomes tokens, tokens become vectors. Inside DuckDB, with no network, no key and no bill

Unified SQL access to Sudan's humanitarian, development, and geospatial data from 5 international APIs (World Bank, WHO, FAO, UNHCR, ILO)

QuestDB's TICK interval syntax for time filters, e.g. WHERE ts IN '[2025-01]T09:30@America/New_York#workday;6h30m'

Generate TPC-H data as DuckDB tables or Parquet files, powered by the pure-Rust tpchgen-rs generators

Query Universal Scene Description (USD) files with SQL

Query Google Custom Search API directly from SQL with filter pushdowns

Cultivate your research identity and networks: read and convert ORCID v3.0 researcher records, XML and JSON (API documents and the ORCID Public Data File dumps), as tables. An independent open-source project, not affiliated with, endorsed by or sponsored by ORCID, Inc.; no access to the ORCID Sandbox or the ORCID Member API, and no requests to ORCID.