How can I get a list of packages that require a specific packages? Specifically I'm trying to find all packages that require astroid
This is currently not possible at the time of writing as PyPI package metadata does not contain this information.
As noted in the comments, you can download all packages and analyse the contents but there is no PyPI API yet that allows you to fetch this information from PyPI.