Skip to contents

List MotherDuck/DuckDB Extensions

list_extensions.Rd

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

Usage

list_extensions(.con)

Arguments

.con

A valid DBI connection (DuckDB / MotherDuck).

Value

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

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) { # \dontrun{
con <- DBI::dbConnect(duckdb::duckdb())

# List all available extensions
list_extensions(con)

DBI::dbDisconnect(con)
} # }