Search Shortcut cmd + k | ctrl + k
Official Extensions

List of Official Extensions

Extension name Description Aliases
arrow GitHub A zero-copy data integration between Apache Arrow and DuckDB  
autocomplete Adds support for autocomplete in the shell  
aws GitHub Provides features that depend on the AWS SDK  
azure GitHub Adds a filesystem abstraction for Azure blob storage to DuckDB  
excel Adds support for Excel-like format strings  
fts Adds support for Full-Text Search Indexes  
httpfs Adds support for reading and writing files over an HTTP(S) or S3 connection http, https, s3
iceberg GitHub Adds support for Apache Iceberg  
icu Adds support for time zones and collations using the ICU library  
inet Adds support for IP-related data types and functions  
jemalloc Overwrites system allocator with jemalloc  
json Adds support for JSON operations  
mysql GitHub Adds support for reading from and writing to a MySQL database  
parquet Adds support for reading and writing Parquet files  
postgres GitHub Adds support for reading from and writing to a Postgres database postgres_scanner
spatial GitHub Geospatial extension that adds support for working with spatial data and functions  
sqlite GitHub Adds support for reading from and writing to SQLite database files sqlite_scanner, sqlite3
substrait GitHub Adds support for the Substrait integration  
tpcds Adds TPC-DS data generation and query support  
tpch Adds TPC-H data generation and query support  

Default Extensions

Different DuckDB clients ship a different set of extensions. We summarize the main distributions in the table below.

Extension name CLI (duckdb.org) CLI (Homebrew) Python R Java Node.js
autocomplete yes yes        
excel yes          
fts yes   yes      
httpfs     yes      
icu yes yes yes   yes yes
json yes yes yes   yes yes
parquet yes yes yes yes yes yes
tpcds     yes      
tpch yes   yes      

The jemalloc extension’s availability is based on the operating system. It is a built-in extension on Linux versions and optionally available on macOS (via compiling from source). On Windows, it is not available.

About this page

Last modified: 2024-03-02