Looking for asset metadata

I have a node and db-sync running. I have a list of assets with policy id’s from the postgreSql database. Now I need the metadata of the assets. I didn’t find this data in the database so I think it’s somewhere offchain. Found this api https://tokens.cardano.org/metadata but was unable to make a working request. The repo looks old. What is the best way to get metadata like name and image url for native coins?