Version 0.6.1

DuckDB has a number of extensions available for use. Not all of them are included by default in every distribution, but DuckDB has a mechanism that allows for remote installation.

Remote installation

If a given extensions is not available with your distribution, you can do the following to make it available.

INSTALL 'fts';
LOAD 'fts';

If you are using the Python API client, you can install and load them with the load_extension(name: str) and install_extension(name: str) methods.

Unsigned extensions

All verified extensions are signed, if you wish to load your own extensions or extensions from untrusted third-parties you’ll need to enable the allow_unsigned_extensions flag.
To load unsigned extensions using the CLI, you’ll need to pass the -unsigned flag to it on startup.

Listing extensions

You can check the list of core and installed extensions with the following query:

select * from duckdb_extensions();

All available extensions

Extension name Description Aliases
fts Adds support for Full-Text Search Indexes  
httpfs Adds support for reading and writing files over a HTTP(S) connection http, https, s3
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  
parquet Adds support for reading and writing parquet files  
postgres_scanner Adds support for reading from a Postgres database postgres
sqlite_scanner Adds support for reading SQLite database files sqlite, sqlite3
substrait Adds support for the Substrait integration  
tpcds Adds TPC-DS data generation and query support  
tpch Adds TPC-H data generation and query support  

Pages in this Section

Search Shortcut cmd + k | ctrl + k