This page lists the Community Extensions available for the latest stable DuckDB release (v2.0.0).
Note that Community Extensions that support old DuckDB releases are currently not listed.
Please check the community-extensions GitHub repository for a complete list including legacy extensions.
| Name | GitHub | Description |
|---|---|---|
| a5 | GitHub | Hierarchical pentagonial indexing for geospatial data that is equal-area and millimeter accurate. |
| adbc | GitHub | Connects DuckDB to any database that has an Arrow Database Connectivity (ADBC) driver. |
| adbc_scanner | GitHub | An ADBC client extension for DuckDB that can access ADBC provided data sources. |
| agent_data | GitHub | 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. |
| ai | GitHub | 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 |
| airport | GitHub | The Airport extension brings Arrow Flight support to DuckDB, enabling DuckDB to query, modify, and store data from Arrow Flight servers. |
| aixchess | GitHub | Efficiently query large chess game collections |
| altertable | GitHub | Query Altertable's lakehouse directly from your local DuckDB. |
| anndata | GitHub | Read AnnData (.h5ad) files for single-cell genomics data analysis, with support for local and remote (HTTP/HTTPS/S3) files |
| anofox_decide | GitHub | 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 |
| anofox_forecast | GitHub | Statistical timeseries forecasting in DuckDB. Supports ARIMA, ETS, Theta, TBATS, MFLES, MSTL, Croston, GARCH, and other models. |
| anofox_optimize | GitHub | Combinatorial decision algorithms as SQL — bin packing, knapsack, wave batching, sequencing, scheduling, assortment and portfolio selection |
| anofox_scenario | GitHub | 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. |
| anofox_similarity | GitHub | 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. |
| anofox_statistics | GitHub | 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. |
| anofox_tabfm | GitHub | 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) on ONNX Runtime, no training loop |
| anofox_tabular | GitHub | 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. |
| anofox_visualization | GitHub | Render charts and dashboards straight from SQL — the ggplot-rs grammar of graphics, emitted as SVG. |
| apart | GitHub | Evaluate affine decision trees in SQL |
| nanoarrow | GitHub | Allows the consumption and production of the Apache Arrow interprocess communication (IPC) format, both from files and directly from stream buffers. |
| astro | GitHub | Astronomical calculations + FITS file I/O - coordinate transforms, photometry, cosmology, dust extinction, sidereal time |
| behavioral | GitHub | Behavioral analytics functions inspired by ClickHouse (sessionize, retention, window_funnel, window_funnel_events, sequence_match, sequence_count, sequence_match_events, sequence_next_node) |
| bigquery | GitHub | Integrates DuckDB with Google BigQuery, allowing direct querying and management of BigQuery datasets |
| bitfilters | GitHub | Provides high-performance, space-efficient probabilistic data structures—including quotient, XOR, and binary fuse filters—for fast approximate set membership testing with no false negatives and configurable false positive rates. |
| blockduck | GitHub | Live SQL Queries on Blockchain |
| boilstream | GitHub | Secure remote secrets storage with OPAQUE PAKE authentication, email/password registration, MFA login, and automatic ducklake mounting |
| brew | GitHub | Get locally homebrew casks, packages and formulas and their dependencies as nicely typed tables |
| bvh2sql | GitHub | BVH (BioVision Hierarchy) motion capture file parser for DuckDB |
| cache_httpfs | GitHub | Read cached filesystem for httpfs |
| cache_prewarm | GitHub | Prewarm data blocks into DuckDB's buffer pool or OS page cache for faster queries |
| capi_quack | GitHub | Provides a hello world example demo from the C/C++ C API template |
| cassandra | GitHub | 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. |
| celestial | GitHub | Astronomical coordinates utilities |
| chaos | GitHub | Creates chaos! ⋆✴︎˚｡⋆ Chaos allows you to throw any type of DuckDB exception, or to raise a SIGSEGV, SIGABRT, or SIGBUS signal. |
| chess | GitHub | A DuckDB extension for parsing and analyzing chess games in PGN format. |
| chsql | GitHub | ClickHouse SQL Macros for DuckDB |
| chsql_native | GitHub | ClickHouse Native Client & File Reader for chsql |
| cityjson | GitHub | Read, write, and query CityJSON, CityJSONSeq, FlatCityBuf, and CityParquet 3D city model files. |
| clamp | GitHub | 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. |
| clickhouse_scanner | GitHub | Read and write ClickHouse tables directly from DuckDB. |
| cloudfront | GitHub | AWS CloudFront signed cookie authentication for DuckDB httpfs |
| cloudwatch | GitHub | Read and write Amazon CloudWatch telemetry with OTLP-shaped SQL tables |
| cog | GitHub | GDAL-free Cloud-Optimized GeoTIFF (COG) reader — query remote rasters in place over HTTP range reads, with STAC catalog integration |
| compression_fs | GitHub | Adds LZ4, Snappy, Brotli, Bzip2, and XZ file compression support |
| cozip | GitHub | Cloud-Optimized ZIP reader for DuckDB |
| crawler | GitHub | SQL-native web crawler with HTML extraction and MERGE support |
| cronjob | GitHub | DuckDB HTTP Cronjob Extension |
| crypto | GitHub | Cryptographic hash functions and HMAC |
| curl_httpfs | GitHub | httpfs with connection pool, HTTP/2 and async IO. |
| cwiqduck | GitHub | DuckDB filesystem extension for CWIQ FS |
| dash | GitHub | A fully visual data explorer and GUI for DuckDB. Create interactive dashboards and DAG pipelines. |
| databricks | GitHub | Read and write Databricks tables directly from DuckDB. |
| datadog | GitHub | Read logs from the Datadog Logs Search API into OTLP-shaped tables |
| datasketches | GitHub | By utilizing the Apache DataSketches library this extension can efficiently compute approximate distinct item counts and estimations of quantiles, while allowing the sketches to be serialized. |
| dazzleduck | GitHub | Arrow IPC over HTTP client with array functions and bloom filters |
| dc | GitHub | Compose fast bounded judgments, semantic resolution, and selective LLM reasoning with provenance |
| decide | GitHub | Filter, classify, and score text using OpenAI Decisions from SQL |
| decimal_arithmetic | GitHub | Extension that adds support special decimal arithmetic functions |
| delta_classic | GitHub | Attach a directory of Delta tables as a single DuckDB database with automatic schema discovery |
| delta_export | GitHub | Export DuckLake catalog tables to Delta Lake format |
| dicom | GitHub | DuckDB integration with medical imaging data (DICOM - Digital Imaging and Communication in Medicine). |
| differential | GitHub | Versioned DuckDB databases - snapshots, time travel, branches, clones and S3 export over native storage |
| dns | GitHub | The DNS Extension enables DNS lookups and reverse DNS lookups from within DuckDB |
| documentdb | GitHub | DuckDB extension for DocumentDB metadata and SQL integration, with schema inference scaffolding and collection access helpers. |
| dplyr | GitHub | R dplyr pipeline syntax support for DuckDB - transpiles dplyr verbs to SQL |
| dq | GitHub | Data quality assertion framework — SQL-native expect_* rules, profiling, and persisted quality reports |
| dqtest | GitHub | Define and run data-quality tests inside DuckDB |
| dta | GitHub | Read and write Stata .dta files (formats 117-121, Stata 13-18) with full type mapping, value labels, and strL support. |
| duck_block_utils | GitHub | Build, transform, validate, and extract content from structured documents using the duck_block type |
| duck_delta_share | GitHub | DuckDB Extension for Delta Sharing |
| duck_dggs | GitHub | DuckDB extension for discrete global grid systems (DGGS) powered by DGGRID v9. |
| duck_diff | GitHub | 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. |
| duck_geoarrow | GitHub | DuckDB extension for converting GEOMETRY/WKB to and from GeoArrow native encodings, powered by geoarrow-c. |
| duck_hunt | GitHub | Parse and analyze test results, build outputs, and CI/CD pipeline logs from 110+ formats with severity filtering, format auto-detection, and context extraction |
| duck_lineage | GitHub | DuckLineage automatically captures data lineage from every DuckDB query and emits OpenLineage events. |
| duck_lk | GitHub | Query LabKey Server tables with automatic local Parquet caching |
| duck_pinyin | GitHub | Chinese pinyin conversion, polyphonic phrase disambiguation, and ordered pinyin matching |
| duck_tails | GitHub | 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. |
| duckboost | GitHub | SQL-native histogram GBDT in DuckDB with vendor dump import and plain-SQL export |
| duckbridge | GitHub | 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 |
| duckdb_delta_sharing | GitHub | The most efficient way to query Delta Lake tables directly from DuckDB via the Delta Sharing protocol. |
| duckdb_geoip_rs | GitHub | Retrieve geo ip data from MMDB database |
| duckdb_mcp | GitHub | 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. |
| duckdb_object_storage | GitHub | Store writable DuckDB databases in local or S3-compatible object storage through SlateDB |
| duckdb_opendalfs | GitHub | Remote storage filesystem for DuckDB via Apache OpenDAL — S3, GCS, Azure, Hugging Face, WebDAV, SFTP, and more, with DuckDB secret-based auth. |
| duckdb_rdkit | GitHub | Cheminformatics with RDKit for DuckDB - SMILES/SDF molecules, substructure search, and molecular descriptors. |
| duckdb_rphonetic | GitHub | Phonetic algorithms for German and European name matching |
| duckdbi | GitHub | Browser-based BI dashboard extension for DuckDB. Run SQL queries and build interactive dashboards with drag-and-drop charts, all from the DuckDB CLI. |
| duckflight | GitHub | Query DuckDB from PostgreSQL and Arrow Flight SQL clients, including psql, ADBC, and Airport |
| duckfn_kuva | GitHub | 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) |
| duckfn_open | GitHub | 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 |
| duckfn_quantstats | GitHub | Complete quantstats HTML tearsheets from SQL - one long table in, one full report per instrument out, benchmarks included |
| duckfn_statrs | GitHub | Statistical functions from the Rust statrs crate - 34 aggregates and 509 scalars covering every statrs module |
| duckgl | GitHub | DuckDB geospatial visualization with deck.gl and MapLibre |
| duckgql | GitHub | Adds ISO GQL graph querying and graph algorithms to DuckDB |
| duckherder | GitHub | Run duckdb query on remote server |
| duckhog | GitHub | 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. |
| duckhts | GitHub | DuckDB extension for reading HTS file formats via htslib |
| ducklake_cdc | GitHub | Stream changes from your DuckLake — durable consumer cursors, single-reader windows, typed DDL events. |
| duckorch | GitHub | 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 |
| duckpgq | GitHub | Extension that adds support for SQL/PGQ and graph algorithms |
| duckrouting | GitHub | Graph routing for DuckDB - shortest paths, flow, spanning trees and more, following pgRouting's semantics and powered by the Boost Graph Library. |
| ducksassy | GitHub | Approximate DNA, IUPAC and ASCII string matching with SIMD Sassy kernels, including CRISPR guide search |
| ducksmiles | GitHub | 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 |
| ducksync | GitHub | Intelligent query result caching between DuckDB and Snowflake with TTL and smart refresh |
| ducktinycc | GitHub | Compile C from SQL into scalar, aggregate, and table functions in-process with an embedded TinyCC; no compiler or runtime files needed |
| dynamodb | GitHub | Adds a dynamodb_scan function that enables querying DynamoDB tables. |
| eeagrid | GitHub | Extension that adds support for working with the EEA Reference Grid System. |
| eenddb | GitHub | The long-awaited Dutch localization of DuckDB's SQL dialect |
| elasticsearch | GitHub | Query Elasticsearch indices directly using SQL |
| erpl_idoc | GitHub | Read & write SAP IDoc files (flat + IDoc-XML) as SQL in DuckDB — a community extension in the erpl family. |
| erpl_odata | GitHub | (Formerly erpl_web.) ERPL is a DuckDB extension to connect to API based ecosystems via standard interfaces like OData, GraphQL and REST. This works e.g. for SAP ERP, SAP Ariba, SAP C4C, Microsoft Dynamics and many more. |
| erpl_tunnel | GitHub | Reach any TCP service from DuckDB through an SSH bastion, Tailscale or NetBird — and publish local ports back onto those networks. |
| erpl_odata | GitHub | (Formerly erpl_web.) ERPL is a DuckDB extension to connect to API based ecosystems via standard interfaces like OData, GraphQL and REST. This works e.g. for SAP ERP, SAP Ariba, SAP C4C, Microsoft Dynamics and many more. |
| eurostat | GitHub | Extension that adds support for reading data from EUROSTAT database using SQL. |
| evalexpr_rhai | GitHub | Evaluate the Rhai scripting language in DuckDB |
| events | GitHub | A extension that hooks into database events and sends JSON-formatted notifications to external programs. |
| eviltransform | GitHub | WGS84, GCJ02 and BD09 coordinate transformations and exact Jenks natural breaks |
| faiss | GitHub | Provides access to faiss indices from DuckDB. |
| fakeit | GitHub | The FakeIt Extension enables generation of realistic fake/test data directly in SQL queries |
| file_dialog | GitHub | Choose a file via native file dialog |
| finance | GitHub | SQL-native quant finance functions for DuckDB |
| finetype | GitHub | Semantic type classification — detects 251 data types (emails, URLs, dates, UUIDs, currencies, etc.) from raw strings |
| fire_duck_ext | GitHub | Query Google Cloud Firestore directly from DuckDB using SQL |
| firebird | GitHub | 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. |
| fit | GitHub | Read Garmin .fit files using DuckDB - GPS tracks, heart rate, power metrics, and fitness device data |
| fivetran | GitHub | Pack sparse join build side into compact variants. |
| flock | GitHub | LLM & RAG extension to combine analytics and semantic analysis |
| fsquery | GitHub | Query filesystem metadata using SQL with recursive directory traversal |
| func_apply | GitHub | Dynamic function invocation - call any scalar function or macro by name at runtime |
| fusion_scanner | GitHub | Query Oracle Fusion from DuckDB through BI Publisher, with SSO, an ATTACH-able catalog and cached metadata |
| fuzzycomplete | GitHub | Fuzzy matching based autocompletion |
| fxmacrodata | GitHub | Official macroeconomic, FX and central-bank data for 22 currencies as typed SQL tables, with the time each figure was published |
| gaggle | GitHub | A DuckDB extension for working with Kaggle datasets |
| gatekeeper | GitHub | 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. |
| gcloud_observability | GitHub | Query Google Cloud logs, metrics, alerts, and service topology from DuckDB |
| gcs | GitHub | DuckDB GCS Extension |
| gdrive | GitHub | Query files in Google Drive directly with a gdrive:// filesystem |
| gdx | GitHub | Read GAMS GDX files directly into DuckDB |
| geography | GitHub | Global spatial data processing on the sphere |
| geosilo | GitHub | Compact geometry encoding using delta-encoded coordinates. Achieves 3-4x smaller geometry storage and wire transfer compared to WKB. |
| ggsql | GitHub | Bindings to ggsql — Grammar of Graphics based visualizations in SQL |
| gh | GitHub | Experimental gh:// filesystem support |
| gorz | GitHub | Read GORpipe .gorz and .gord files and write .gorz as native DuckDB tables |
| gpudb | GitHub | 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. First SQL execution engine that targets Apple Silicon GPUs. |
| gridpin_ext | GitHub | Offline geocoding from a single country file — forward and reverse, no server, no network |
| gsheets | GitHub | Read and write Google Sheets using SQL |
| h3 | GitHub | Hierarchical hexagonal indexing for geospatial data |
| h5db | GitHub | Read HDF5 datasets and attributes |
| hashfuncs | GitHub | Non-cryptographic hash functions, xxHash, rapidhash and Murmurhash3 |
| healthkit_export | GitHub | Read Apple Health app exports (HealthKit export.zip / export.xml) as typed DuckDB tables (records, workouts, activity rings, workout routes and GPX points). |
| hedged_request_fs | GitHub | Provides hedged request for filesystem operations |
| hex9 | GitHub | Hex9 hierarchical hexagonal DGGS — point encoding, layer binning, cell geometry as WKB, labels, k-rings, Hamiltonian-curve ordering, and grid enumeration |
| hive_metastore | GitHub | Attach Apache Hive Metastore as a native DuckDB catalog and read/write the data inside with ease! |
| holtfs | GitHub | Holt-backed metadata indexes for fast DuckDB file discovery |
| hostfs | GitHub | Navigate and explore the filesystem using SQL |
| html_query | GitHub | Query HTML using CSS selectors, extract JSON from LD+JSON, JavaScript variables, and Next.js RSC |
| html_readability | GitHub | Extract readable content from HTML using Mozilla's Readability algorithm |
| http_client | GitHub | DuckDB HTTP Client Extension |
| http_request | GitHub | HTTP client extension for DuckDB with GET/POST/PUT/PATCH/DELETE and byte-range requests |
| httpfs_timeout_retry | GitHub | Add per-operation timeout and retry for httpfs extension |
| httpserver | GitHub | DuckDB HTTP API Server Extension |
| hudi | GitHub | 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. |
| huggingface | GitHub | Discover, query, profile, and estimate the storage of Hugging Face datasets |
| improv | GitHub | Improv's spreadsheet formula language (674 functions) and multidimensional models (categories, measures, formulas over them) on DuckDB tables |
| infera | GitHub | A DuckDB extension for in-database inference |
| inflector | GitHub | Powerful string case transformation and inflection capabilities directly to your SQL queries. |
| interlis | GitHub | Native INTERLIS model introspection and streaming XTF support for DuckDB |
| ion | GitHub | Read AWS Ion data and write Ion text or binary with typed mappings |
| jev | GitHub | Ask your tables questions in plain language — filter, rank and classify rows with a condition you write as a sentence |
| json_schema | GitHub | Adds support for validating JSON data with JSON schemas. |
| jsonata | GitHub | The JSONata extension for DuckDB enables expressive, JSON-focused querying and transformation directly within SQL using the powerful JSONata expression language. |
| jsono | GitHub | Analytics-optimized JSON storage — parse one time and read many times, and shred hot paths into typed columns for pushdown and row-group pruning |
| keboola | GitHub | DuckDB extension for Keboola Storage — query and write Keboola tables using standard SQL |
| lakemon | GitHub | Smart DuckLake table maintain (adaptive rewrite + merge) and catalog-global expire/cleanup |
| lance_conversion | GitHub | Stream any DuckDB query into Lance datasets with Blob v2 storage and scalar, vector, text, and Bloom filter indexes |
| latency_injection_fs | GitHub | Used to inject simulated latency to filesystem operations |
| laterite_ags4 | GitHub | 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). |
| ldbc_data_gen | GitHub | Generate LDBC SNB BI datasets directly from DuckDB |
| lerobot | GitHub | Query and create LeRobot v3 datasets, including frame data, images, and video observation windows. |
| level_pivot | GitHub | Storage extension wrapping LevelDB with pivot semantics for structured relational tables over key-value pairs |
| lindel | GitHub | Linearization/Delinearization, Z-Order, Hilbert and Morton Curves |
| livetennis | GitHub | Query the Live Tennis API from SQL - live matches, upcoming fixtures and player search as table functions |
| llm | GitHub | Call LLM APIs (OpenAI, Gemini, Cloudflare) directly from SQL with structured output support. |
| lpts | GitHub | Optimized-plan inspection and cross-system SQL transpilation |
| lsh | GitHub | Extension for locality-sensitive hashing (LSH) |
| lua | GitHub | Evaluate Lua scripts within queries |
| luajit | GitHub | In-process LuaJIT UDFs for DuckDB — JIT-compiled, parallel (per-thread states), trusted sandbox, GROUP BY aggregates, LIST/STRUCT/MAP bridges, embedded Fennel compiler |
| magic | GitHub | libmagic/file utilities ported to DuckDB |
| marc21 | GitHub | Read, write, validate and edit MARC 21 bibliographic data (ISO 2709, MARCXML, MARC-in-JSON, breaker, Aleph; UTF-8 and MARC-8) |
| marisa | GitHub | Adds MARISA (Matching Algorithm with Recursively Implemented StorAge) trie functionality for DuckDB. MARISA is a static and space-efficient trie data structure that enables fast string lookups, prefix searches, and predictive text operations. |
| markdown | GitHub | Read, analyze, and write Markdown files with block-level document representation and inline element support |
| maxmind | GitHub | Read MaxMind databases (GeoLite, GeoIP, and more) |
| mentat | GitHub | Datomic-compatible Datalog query engine as a DuckDB extension |
| midi | GitHub | 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. |
| miint | GitHub | Bioinformatics extension for microbiome research - read/write FASTQ, SAM/BAM, BIOM, GFF, Newick trees, query NCBI, and more. |
| minijinja | GitHub | Adds templating to DuckDB, enabling dynamic generation of text, HTML, and reports directly within SQL queries using the MiniJinja engine. |
| miniplot | GitHub | Interactive chart visualization for DuckDB - faster than pandas with Plotly-like charts |
| ml | GitHub | Lightweight, columnar-native ML for DuckDB — train + inference, 34 algorithms, zero Python deps |
| mlpack | GitHub | Connecting duckdb to the mlpack C++ machine learning library |
| mmcif | GitHub | Read and write protein structure mmcif files using SQL |
| monetary | GitHub | Currency-aware monetary values with parsing, arithmetic, and real-time exchange rates |
| mongo | GitHub | Integrates DuckDB with MongoDB, enabling direct SQL queries and writes over MongoDB collections without ETL |
| mooncake | GitHub | Read Iceberg tables written by moonlink in real time |
| motorsport_telemetry | GitHub | Query AiM MP4, Cosworth PDS, MoTeC LD, Racelogic VBOX and .telemetry recordings directly in DuckDB, with stint-aware laps |
| msolap | GitHub | Extension that allows DuckDB to connect to Microsoft SQL Server Analysis Services (SSAS) and other OLAP data sources using the MSOLAP provider |
| mssql | GitHub | Connect DuckDB to Microsoft SQL Server via native TDS (including TLS). |
| mssql_ducklake | GitHub | DuckLake with its catalog in Microsoft SQL Server or Azure SQL - embedded DuckLake, native TDS through the mssql extension. |
| nanoarrow | GitHub | Allows the consumption and production of the Apache Arrow interprocess communication (IPC) format, both from files and directly from stream buffers. |
| nanodbc | GitHub | Connect to any ODBC-compatible database and query data directly from DuckDB |
| nats_js | GitHub | Query NATS JetStream message streams directly with SQL |
| netquack | GitHub | DuckDB extension for parsing, extracting, and analyzing domains, URIs, and paths with ease. |
| ng_postcode | GitHub | Parse, validate, format, and group Nigeria's NIPOST digital postcode (NDAPS) |
| nsv | GitHub | Read and write NSV (Newline-Separated Values) files |
| oast | GitHub | Validate, decode, and extract OAST (Out-of-Band Application Security Testing) domains in SQL |
| observefs | GitHub | Provides IO observability to filesystem |
| onager | GitHub | A DuckDB extension for graph data analytics |
| open_prompt | GitHub | Interact with LLMs with a simple DuckDB Extension |
| opendal | GitHub | Access S3, local filesystem, and other storage services through Apache OpenDAL |
| oracle | GitHub | Connect DuckDB directly to Oracle databases for reading and writing tables, with catalog integration, pushdown, spatial geometry, and vector support |
| oracle_scanner | GitHub | Read and write Oracle Database with no Oracle client |
| oraduck | GitHub | Fast COPY of query results into Oracle through the OCI Direct Path API |
| orc | GitHub | 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). |
| osmium | GitHub | Read OpenStreetMap data from OSM XML and PBF files |
| ossie | GitHub | The Apache Ossie (incubating) extension for DuckDB. Reads Ossie semantic model files in YAML or JSON and answers semantic queries against the tables in DuckDB, from a single binary, with no infrastructure. Also exposes the semantic layer via MCP. |
| otlp | GitHub | Query OpenTelemetry traces, logs, and metrics with SQL — or stream live OTLP/HTTP into DuckDB, DuckLake, or Iceberg |
| oxedi | GitHub | Read X12 EDI 835 remittance files as tables, losslessly, and write tables back into an 835 |
| pac | GitHub | Automatic query privatization using the PAC Privacy framework |
| paimon | GitHub | Query Apache Paimon tables directly from DuckDB |
| panduck | GitHub | 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 |
| parser_tools | GitHub | Exposes functions for parsing referenced tables and usage context from SQL queries using DuckDB's native parser. |
| pbi_scanner | GitHub | DuckDB extension for querying Power BI Semantic Models with DAX. |
| pbix | GitHub | Extension that allows parsing the data model embedded in PowerBI (pbix) files |
| pdal | GitHub | Extension that adds support for manipulating point cloud data using SQL. |
| GitHub | Read, OCR, inspect, transform, and write PDFs in SQL | |
| petgraph_ext | GitHub | Graph algorithms for DuckDB — PageRank, shortest path, SCC, MST, and more via petgraph |
| pfc | GitHub | Read PFC-JSONL compressed log files directly in DuckDB with block-level timestamp filtering |
| pgvfs | GitHub | 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 |
| pic2vec | GitHub | Picture-to-vector — image embeddings from SQL via tract-onnx (Rust). Bundles Meta's EUPE ViT-T/16; works with any ONNX vision model. |
| pintail | GitHub | Lightweight Geohash utilities for DuckDB, including coordinate and geometry encoding, cell decoding, bounding boxes, and neighbors. |
| pivot_table | GitHub | Provides a spreadsheet-style pivot_table function |
| plinking_duck | GitHub | Read and write PLINK 2 genomics file formats and run common genetic analyses directly in SQL |
| polyglot | GitHub | Transpile SQL from 34 different dialects into DuckDB SQL |
| pql | GitHub | Predictive queries as SQL. TRAIN a model on the tables you already have, PREDICT with it, BACKTEST it. |
| prometheus | GitHub | Query Prometheus-compatible HTTP APIs directly from DuckDB |
| protoduck | GitHub | Deserialize Protocol Buffer messages stored in DuckDB columns |
| prql | GitHub | Support for PRQL, the Pipelined Relational Query Language |
| psql | GitHub | Support for PSQL, a piped SQL dialect for DuckDB |
| pst | GitHub | Read and edit in place Microsoft PST files with rich schemas for common MAPI types (emails, contacts, appointments, tasks) |
| psyduck | GitHub | Pokemon data native in DuckDB |
| px | GitHub | Extension for querying Px-files with DuckDB. |
| python_udf | GitHub | Embedded CPython UDFs for DuckDB — py_eval, py_agg, py_scan, py_register, py_call, py_map |
| quack_flamegraph | GitHub | Query Brendan Gregg folded CPU/allocation profiles as DuckDB tables |
| quack_oauth | GitHub | Extensions providing OAuth and OpenID primitives for authentication and authorization for the DuckDB quack server. |
| quackapi | GitHub | FastAPI-class HTTP framework inside DuckDB — CREATE ROUTE turns SQL into typed, validated endpoints; one process is DB + HTTP (+ PDF/renderer via companion extensions). |
| quackformers | GitHub | Bert-based embedding extension. |
| quackhole | GitHub | Query a DuckDB behind NAT from anywhere, over an encrypted peer-to-peer connection |
| quackiso | GitHub | Query ISO 20022 (camt, pacs, pain) and SWIFT MT financial messages as SQL |
| quackscale | GitHub | DuckDB WireGuard Extension to Quack & Ducklake over Tailscale/Headscale |
| quackstats | GitHub | Time series forecasting and statistics for DuckDB |
| quackstore | GitHub | QuackStore - Smart Block-Based Caching for Remote Files. Speed up repeated queries on remote data with intelligent block-level caching. |
| querio_jev | GitHub | Classify, filter and score table rows with TypeSafe Jev from SQL, with dedupe, a disk cache and concurrent requests. |
| query_condition_cache | GitHub | This extension provides a cache for query conditions, which is useful for repeated-query workloads like metrics monitoring dashboards, log investigations, etc. |
| query_limiter | GitHub | Reject queries before physical execution when estimated table scans exceed a configured row budget |
| quickjs | GitHub | DuckDB QuickJS Runtime Extension |
| qvd | GitHub | Read (streaming) and write Qlik QVD files |
| qvd_next | GitHub | Read (streaming) and write Qlik QVD files - next-generation build of qvd on the DuckDB C API v2 |
| radio | GitHub | Allow interaction with event buses like Websocket and Redis publish/subscribe servers. |
| rapidfuzz | GitHub | Provides adds high-performance fuzzy string matching functions, powered by the RapidFuzz C++ library. |
| raquet | GitHub | Raster analytics on Raquet files with QUADBIN spatial indexing, raster ingestion, and PostGIS-style functions |
| raster | GitHub | DuckDB extension for reading and writing geospatial raster data using SQL. |
| rate_limit_fs | GitHub | Perform rate and burst limit on filesystem operations |
| rawduck | GitHub | Schema-less JSON and OTEL ingestion shredder for DuckDB |
| razobill | GitHub | High-performance lossless log parsing, analytical database compaction, and information-theoretic semantic accounting. |
| rdf | GitHub | Read and write RDF, query using SPARQL |
| read_dbf | GitHub | Read DBF (dBase) files with support for general DBF formats and field types. |
| read_lines | GitHub | 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. |
| read_stat | GitHub | Read data sets from SAS, Stata, and SPSS with ReadStat |
| redis | GitHub | Redis compatible Client for DuckDB |
| redis_adbc | GitHub | Stream Redis SQL results through an embedded Arrow ADBC driver |
| rocket | GitHub | ROCKET random convolutional kernel features for time-series classification |
| rusty_quack | GitHub | Provides a hello world example demo from the Rust-based extension template |
| rusty_sheet | GitHub | An Excel/WPS/OpenDocument Spreadsheets file reader for DuckDB |
| s2raster | GitHub | S2 geography + GeoTIFF raster for DuckDB — cell covering, pixel read, stats, histogram |
| salesforce | GitHub | 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. |
| sazgar | GitHub | 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). |
| scalarfs | GitHub | A collection of virtual filesystems for working with scalars |
| se3 | GitHub | Provides SE(3) rigid transformations (combinations of rotations and translations in 3D) as DuckDB scalar functions. |
| semantic_profile | GitHub | 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 |
| semantic_views | GitHub | Semantic views – a declarative layer for dimensions, metrics, and relationships |
| sharepoint | GitHub | Query files in SharePoint / OneDrive directly with a sharepoint:// filesystem |
| sheetreader | GitHub | Fast, parallel Excel (XLSX) loading with low memory overhead. |
| shellfs | GitHub | Allow shell commands to be used for input and output |
| sitemap | GitHub | Parse XML sitemaps from websites with automatic discovery via robots.txt |
| sitting_duck | GitHub | Parse and analyze source code ASTs from 28 programming languages with tree-sitter grammars, pattern matching, and structural search |
| snowflake | GitHub | Snowflake data source extension - query Snowflake databases directly from DuckDB |
| splink_udfs | GitHub | Phonetic, text normalization and address matching functions for record linkage. |
| splunk | GitHub | Read logs from a Splunk search REST API into OTLP-shaped tables |
| spxlsx | GitHub | Query SharePoint lists and Excel workbooks directly from DuckDB |
| sshfs | GitHub | Allows reading and writing files over SSH |
| st_read_multi | GitHub | Read multiple geospatial files |
| stac | GitHub | DuckDB extension for reading data from SpatioTemporal Asset Catalogs (STAC) using SQL. |
| stats_duck | GitHub | A statistical computing toolkit for DuckDB — descriptive statistics, hypothesis tests, R-style distribution functions (d/p/q/r), OLS regression with HC and cluster-robust standard errors, grammar-of-graphics charts (VISUALIZE → Vega-Lite), and first-class readers/writers for SAS, SPSS, and Stata files, all directly in SQL. |
| stochastic | GitHub | Add comprehensive statistical distribution functions to DuckDB, enabling advanced statistical analysis, probability calculations, and random sampling directly within SQL queries. |
| storage_compat | GitHub | Read DuckDB database files written in a newer storage format than this DuckDB supports |
| substrait | GitHub | Allows conversion execution of Substrait query plans |
| subtoken | GitHub | Text becomes tokens, tokens become vectors. Inside DuckDB, with no network, no key and no bill |
| sudan | GitHub | Unified SQL access to Sudan's humanitarian, development, and geospatial data from 5 international APIs (World Bank, WHO, FAO, UNHCR, ILO) |
| superhuman_docs | GitHub | Attach Superhuman Docs documents as DuckDB databases and query or modify their tables with SQL |
| system_stats | GitHub | Provides table functions to access system-level statistics for monitoring purpose |
| table_guard | GitHub | Enforces table-level access control via an allowlist mechanism, blocking queries to unauthorized tables with a PermissionException |
| table_inspector | GitHub | Observability into DuckDB storage internals at the database, table, and column levels |
| talib | GitHub | Technical Analysis Library (TA-Lib) functions for DuckDB – 100+ indicators for financial market analysis |
| tantivy | GitHub | BM25 full-text search for DuckDB — tokenization and Snowball stemming via tantivy, through DuckDB's C Extension API (quack-rs), no Arrow IPC |
| tera | GitHub | Adds templating to DuckDB, enabling dynamic generation of text, HTML, and reports directly within SQL queries using the Tera engine. |
| textplot | GitHub | Enables text-based data visualization directly in SQL queries, including ASCII/Unicode bar charts, density plots, and sparklines for lightweight analytics and dashboards. |
| three_d | GitHub | 3D solid processing for city models — enclosed volume, validation, distance, and measurement of polyhedral solids. |
| tick | GitHub | QuestDB's TICK interval syntax for time filters, e.g. WHERE ts IN '[2025-01]T09:30@America/New_York#workday;6h30m' |
| timestral | GitHub | Zero-shot probabilistic time-series forecasting in SQL with Mistral's Timestral models, on CPU via ONNX Runtime |
| title_mapper | GitHub | Efficiently standardizes scraped job titles to Bureau of Labor Statistics (BLS) titles using a high-performance TF-IDF algorithm. |
| toml | GitHub | Parse TOML documents into JSON |
| tributary | GitHub | Enable DuckDB to interact with Apache Kafka |
| trino_parity | GitHub | 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 |
| tsfile | GitHub | Query and write Apache TsFile table-model files from DuckDB |
| tsid | GitHub | DuckDB Time-Sortable ID generator |
| turbovec | GitHub | Compressed vector search for DuckDB — Google TurboQuant quantization, IVF indexing, incremental CRUD, cosine/L2/dot |
| typed_ai | GitHub | 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. |
| urlpattern | GitHub | WHATWG URLPattern API for matching and extracting components from URLs using pattern syntax |
| us_address_standardizer | GitHub | US address parsing and standardization (PAGC + Rust addrust) |
| usd | GitHub | Query Universal Scene Description (USD) files with SQL |
| valhalla_routing | GitHub | DuckDB extension for routing and travel time calculations using Valhalla routing engine |
| waddle | GitHub | Provides a hello world example demo |
| warc | GitHub | Parse WARC (Web ARChive) records for Common Crawl data processing |
| web_archive | GitHub | Query Common Crawl and Wayback Machine web archive CDX APIs directly from SQL |
| web_search | GitHub | Query Google Custom Search API directly from SQL with filter pushdowns |
| webbed | GitHub | 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. |
| webdavfs | GitHub | Allows reading and writing files over WebDAV protocol |
| webmacro | GitHub | Load DuckDB Macros from the web |
| whisper | GitHub | Speech-to-text transcription using whisper.cpp, OpenAI's Whisper model |
| yaml | GitHub | Read YAML files into DuckDB with native YAML type support, comprehensive extraction functions, and seamless JSON interoperability |
| yardstick | GitHub | Measure-aware SQL implementing Julian Hyde's 'Measures in SQL' paper |
| yorc | GitHub | 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. |
| zarr | GitHub | Query Zarr array stores (v2 and v3) with SQL — read xarray-convention datasets as tables |
| zeek | GitHub | Read Zeek network security monitor log files with automatic schema detection and type-aware parsing |
| zim | GitHub | 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. |
| zipfs | GitHub | Read files within zip archives |