con <- DBI::dbConnect(duckdb::duckdb(dbdir = tempfile()))
# List all available extensions
list_extensions(con)
DBI::dbDisconnect(con)List MotherDuck/DuckDB Extensions
Source: R/utils-md.R
Retrieves all available DuckDB or MotherDuck extensions along with their descriptions, installation and load status.
Usage
list_extensions(.con)Arguments
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()