Official Extensions
Version dev
Version:

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 a HTTP(S) 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_scanner GitHub Adds support for reading from a Postgres database postgres
spatial GitHub Geospatial extension that adds support for working with spatial data and functions  
sqlite_scanner GitHub Adds support for reading SQLite database files sqlite, 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 Julia Node.JS
autocomplete yes yes          
excel yes            
fts yes   yes        
httpfs     yes        
icu yes yes yes   yes yes yes
json yes yes yes   yes yes yes
parquet yes 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 and macOS versions, while on Windows, it is not available.

Search Shortcut cmd + k | ctrl + k