List of Core Extensions
| Name | GitHub | Description | Stage | Aliases |
|---|---|---|---|---|
| autocomplete | Adds support for autocomplete in the shell | stable | ||
| avro | GitHub | Add support for reading Avro files | stable | |
| aws | GitHub | Provides features that depend on the AWS SDK | stable | |
| azure | GitHub | Adds a filesystem abstraction for Azure blob storage to DuckDB | stable | |
| delta | GitHub | Adds support for Delta Lake | experimental | |
| ducklake | GitHub | Adds support for DuckLake | experimental | |
| encodings | GitHub | Adds support for encodings available in the ICU data repository | experimental | |
| excel | GitHub | Adds support for reading and writing Excel files | experimental | |
| fts | GitHub | Adds support for full-text search indexes | experimental | |
| httpfs | GitHub | Adds support for reading and writing files over an HTTP(S) or S3 connection | stable | http, https, s3 |
| iceberg | GitHub | Adds support for Apache Iceberg | experimental | |
| icu | Adds support for time zones and collations using the ICU library | stable | ||
| inet | GitHub | Adds support for IP-related data types and functions | experimental | |
| jemalloc | Overwrites system the allocator with jemalloc | stable | ||
| json | Adds support for JSON operations | stable | ||
| mysql | GitHub | Adds support for reading from and writing to a MySQL database | stable | mysql_scanner |
| parquet | Adds support for reading and writing Parquet files | stable | ||
| postgres | GitHub | Adds support for reading from and writing to a PostgreSQL database | stable | postgres_scanner |
| spatial | GitHub | Geospatial extension that adds support for working with spatial data and functions | experimental | |
| sqlite | GitHub | Adds support for reading from and writing to SQLite database files | stable | sqlite_scanner, sqlite3 |
| tpcds | Adds TPC-DS data generation and query support | experimental | ||
| tpch | Adds TPC-H data generation and query support | stable | ||
| ui | GitHub | Adds local UI for DuckDB | experimental | |
| vss | GitHub | Adds support for vector similarity search queries | experimental |
The Stage column shows the lifecycle stage of the extension following the convention of the lifecycle stages used in tidyverse.
Default Extensions
Different DuckDB clients ship a different set of extensions. We summarize the main distributions in the table below.
| Name | CLI | Python | R | Java | Node.js |
|---|---|---|---|---|---|
| autocomplete | yes | ||||
| icu | yes | yes | yes | yes | |
| json | yes | yes | yes | yes | |
| parquet | yes | yes | yes | yes | yes |
The jemalloc extension's availability is based on the operating system. Please check the jemalloc page for details.
Pages in This Section
© 2025 DuckDB Foundation, Amsterdam NL