motherduck (version 0.2.0)

list_extensions: List MotherDuck/DuckDB Extensions

Description

Retrieves all available DuckDB or MotherDuck extensions along with their descriptions, installation and load status.

Usage

list_extensions(.con)

Value

A tibble with one row per extension and columns describing its metadata and current status.

Arguments

.con

A valid DBI connection (DuckDB / MotherDuck).

Details

The list_extensions() function queries the database for all extensions that are available in the current DuckDB or MotherDuck connection. The returned tibble includes information such as:

• extension_name: Name of the extension.

• description: Short description of the extension.

• installed: Logical indicating if the extension is installed.

• loaded: Logical indicating if the extension is currently loaded.

This is useful for determining which extensions can be installed or loaded using install_extensions() or load_extensions().

See Also

Other db-list: list_all_databases(), list_all_tables(), list_current_schemas(), list_current_tables(), list_fns(), list_setting(), list_shares()

Examples

if (FALSE) {
con <- DBI::dbConnect(duckdb::duckdb(dbdir = tempfile()))

# List all available extensions
list_extensions(con)

DBI::dbDisconnect(con)
}