Finding pip packages

Pypi doesn’t actually have a way to find all packages with a specific pattern - kinda annoying! But it turns out that pypi publishes all the packages to google bigquery. I found a great article on python.org that gives a great intro.

In my case, I wanted to find extensions to llm:

SELECT
  name,
  summary,
  MAX(upload_time) AS latest_upload_time
FROM
  `bigquery-public-data.pypi.distribution_metadata`
WHERE
  name LIKE 'llm-tools-%'
GROUP BY
  name, summary
ORDER BY
  latest_upload_time DESC

Here are a couple fun ones that I hadn’t seen on the main llm site:

• llm-tools-anki - manage your flash cards.
• llm-tools-kiwix - Search your own offline copies of archived wikis and q/a sites.