Loading Extensions

You can install and load DuckDB extensions when starting Harlequin, by passing the -e or --extension flag one or more times:

If you need to load a custom or otherwise unsigned extension, you can use the -unsigned flag just as you would with the DuckDB CLI, or -u for convenience:

You can also install extensions from custom repos, using the --custom-extension-repo option. For example, this combines the options above to load the unsigned prql extension:

Alternatively, you can use DuckDB’s SQL API for loading and installing extensions, either in Harlequin’s Query Editor or in an initialization script.