Extensions
Installing More Extensions
Optionally a repository can be provided where the extension should be installed from, by appending `FROM <repository>` to the `INSTALL`/`FORCE INSTALL` command.
This repository can either be an alias, such as [`community`](#docs:extensions:community_extensions), or it can be a direct URL, provided as a single-quoted string.  
After installing/loading an extension, the [`duckdb_extensions` function](#::listing-extensions) can be used to get more information.  
#### Autoloading Extensions {#docs:extensions:overview::autoloading-extensions}  
For many of DuckDB's core extensions, explicitly loading and installing extensions is not necessary. DuckDB contains an autoloading mechanism
which can install and load the core extensions as soon as they are used in a query. For example, when running:  
```sql
SELECT *
FROM 'https://raw.githubusercontent.com/duckdb/duckdb-web/main/data/weather.csv';
```  
DuckDB will automatically install and load the [`httpfs`](#docs:extensions:httpfs:overview) extension. No explicit `INSTALL` or `LOAD` statements are required.  
Not all extensions can be autoloaded. This can have various reasons: some extensions make several changes to the running DuckDB instance, making autoloading technically not (yet) possible. For others, it is preferred to have users opt-in to the extension explicitly before use due to the way they modify behavior in DuckDB.  
To see which extensions can be autoloaded, check the [core extensions list](#docs:extensions:core_extensions).  
#### Community Extensions {#docs:extensions:overview::community-extensions}  
DuckDB supports installing third-party [Community Extensions](#docs:extensions:community_extensions).
These are contributed by community members but they are built, signed, and distributed in a centralized repository.  
#### Installing Extensions through Client APIs {#docs:extensions:overview::installing-extensions-through-client-apis}  
For many clients, using SQL to load and install extensions is the preferred method. However, some clients have a dedicated
API to install and load extensions. For example the [Python API client](#docs:api:python:overview::loading-and-installing-extensions),
which has dedicated `install_extension(name: str)` and `load_extension(name: str)` methods. For more details on a specific Client API, refer
to the [Client API docs](#docs:api:overview)