duckdb-extensionslisted
Install: claude install-skill srimon12/duckdb-2-skills
# Extensions
Before installing an extension, verify the 2.0 CLI from `duckdb`. Extensions installed by 1.5 are the wrong build for 2.0.
## Install and load
```sql
INSTALL AND LOAD spatial;
INSTALL AND LOAD h3 FROM community;
```
In DuckDB 2.0, activate extensions with `INSTALL AND LOAD`. If the extension binary is already cached, DuckDB skips the download. If the extension is already loaded in the session, DuckDB skips loading.
| Form | Effect |
| --- | --- |
| `INSTALL name` | Install from the official `core` repository. |
| `INSTALL name FROM community` | Install from the community repository. |
| `INSTALL name FROM core_nightly` | Install from the nightly core build. |
| `INSTALL name FROM 'https://...'` | Install directly from a custom repository URL. |
| `INSTALL name VERSION '<version>'` | Pin a published version for the 2.0 platform. If the version tag or hash is unverified, DuckDB returns HTTP 404. Test version pins in an isolated scratch directory using `extension_directories` before production use. |
| `FORCE INSTALL name` | Re-download and overwrite the cached binary. If omitted, `INSTALL` is a no-op when an extension already exists, even if the version or repository source changed. |
| `INSTALL '/path/ext.duckdb_extension'` | Install from a downloaded binary file. |
| `LOAD name` | Load an installed extension into the current session. |
When `autoinstall_known_extensions` is `true` (default), `LOAD name` installs a known extension before loading. Loading an