Search Shortcut cmd + k | ctrl + k
Search cmd+k ctrl+k
Dark Mode
1.1 (stable)
Core Extensions

List of Core Extensions

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

Default Extensions

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

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. Starting with version 0.10.1, jemalloc is a built-in extension on Linux x86_64 (AMD64) distributions, while it will be optionally available on Linux ARM64 distributions and on macOS (via compiling from source). On Windows, it is not available.