Community Extensions Download Metrics

What Do We Measure?

We use an estimate provided by Cloudflare for the INSTALL events of Community Extensions (as well as regular extensions) that triggered downloads from the http[s]://community-extensions.duckdb.org site.

We publish data about the total number of downloads, aggregated across DuckDB versions and platforms at the https://community-extensions.duckdb.org/downloads-last-week.json endpoint.

Analyzing Downloads

An example query to return the list of community extensions sorted by descending number of downloads would be:

UNPIVOT (
    SELECT 'community' AS repository, *
        FROM 'https://community-extensions.duckdb.org/downloads-last-week.json'
    )
ON COLUMNS(* EXCLUDE (_last_update, repository))
INTO NAME extension VALUE downloads_last_week
ORDER BY downloads_last_week DESC;

For example, to return the download counts for the weeks since January 4, 2026:

PIVOT (
    UNPIVOT (
        FROM read_json([
            printf(
                'https://community-extensions.duckdb.org/download-stats-weekly/%s/%s.json',
                week.strftime('%Y'),
                week.strftime('%V').regexp_replace('^0', '')
            )
            FOR week
            IN range(TIMESTAMP '2026-01-04', now()::TIMESTAMP, INTERVAL 1 WEEK)
            IF strftime(week, '%V') != '53'
        ], union_by_name := true)
    )
    ON COLUMNS(* EXCLUDE _last_update)
    INTO NAME extension VALUE downloads
)
ON date_trunc('day', _last_update::TIMESTAMP)
USING any_value(downloads)
ORDER BY extension;