user7415: I am trying to find a way using either Cardano-cli, Ogmios, or Cardano-DB-Sync to get a list of token holders (addresses) for a particularly token, ideally in JSON format.
What is the best way to do this without using an explorer or API like blockfrost?

user252: You can use Koios endpoint documented here, and if you run a dbsync instance, you can find the dbsync query used here

user5926: "List of holders" is rather unclear. If you want names, addresses and other KYC/AML stuff you won't be able to get it. Tokens are held in Cardano addresses, and any person could have more than one address, and given two addresses, there is no general way to validate that the addresses do or do not belong to the same person.
However, you can get all the addresses that hold a particular token from cardano-db-sync with a relatively simple SQL query.

7415: <p>I am trying to find a way using either Cardano-cli, Ogmios, or Cardano-DB-Sync to get a list of token holders (addresses) for a particularly token, ideally in JSON format.</p>
<p>What is the best way to do this <strong>without</strong> using an explorer or API like blockfrost?</p>
 252: <p>You can use Koios endpoint documented <a href="https://api.koios.rest/#get-/asset_address_list" rel="nofollow noreferrer">here</a>, and if you run a dbsync instance, you can find the dbsync query used <a href="https://github.com/cardano-community/guild-operators/blob/alpha/files/grest/rpc/assets/asset_address_list.sql" rel="nofollow noreferrer">here</a></p>
 5926: <p>&quot;List of holders&quot; is rather unclear. If you want names, addresses and other KYC/AML stuff you won't be able to get it. Tokens are held in Cardano addresses, and any person could have more than one address, and given two addresses, there is no general way to validate that the addresses do or do not belong to the same person.</p>
<p>However, you can get all the addresses that hold a particular token from <code>cardano-db-sync</code> with a relatively simple SQL query.</p>
