I am currently working with cardano-db-sync and I am doing research to extract the metadata of all the native tokens. I found out the policy id and asset name can be extracted from cardano-db-sync but the remaining metadata info should be queried from the metadata server. I am not able to find anything useful related to metadata server. I mean to say what metadata server should I use or setup?
The current off-chain metadata registry is hosted by the Cardano Foundation.
Their endpoint is
https://tokens.cardano.org/metadata and you can find the registry itself along with the documentation hosted on github.com.
Right now, the software does not support setting up a mirror of the current registry, which might be annoying as their rate-limiting is pretty strict. At Blockforst, we have developed a tool to convert the current registry files to the output you are expecting - it is called
metadada and is open source.