user2864: I am currently starting out with cardano db sync and wanted to ask if it is possible to obtain all native and nft tokens and their metadata using cardano db sync? could someone guide me? I can't seem to find sufficient resources for beginner like me.

user382: You can join the ma_tx_mint and ma_tx_out tables to utxo_view. This will only get you the policyid and asset name (hex encoded) for an asset though and you need to query the metadata server to get any other information about the tokens.

2864: <p>I am currently starting out with cardano db sync and wanted to ask if it is possible to obtain all native and nft tokens and their metadata using cardano db sync? could someone guide me? I can't seem to find sufficient resources for beginner like me.</p>
 382: <p>You can join the ma_tx_mint and ma_tx_out tables to utxo_view. This will only get you the policyid and asset name (hex encoded) for an asset though and you need to query the metadata server to get any other information about the tokens.</p>
