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 | ||||||
| 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.
© Copyright 2018–2024 Stichting DuckDB Foundation
Licensed under the MIT License.
https://duckdb.org/docs/extensions/core_extensions.html