<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>

CC BY-SA 4.0
2022-08-22T18:15:15.617Z
Sorry let me clarify, I am looking for a list of cardano addresses
Barney Chambers
CC BY-SA 4.0
2022-08-20T05:02:49.833Z
2022-08-20T05:02:49.833Z
Erik de Castro Lopo
<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>

CC BY-SA 4.0
2022-08-21T03:04:04.560Z
2022-08-21T03:04:04.560Z
RdLrT
<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>

<cardano-cli><cardano-db-sync><token><query>
Get list of holders of a token using Cardano-cli or Cardano-DB-Sync or Ogmios
# Get list of holders of a token using Cardano-cli or Cardano-DB-Sync or Ogmios

(Asked by: username_0 on 2022-08-19)

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?

**Tags:** cardano-cli, cardano-db-sync, token, query

---

## 2 answers

### Answer by username_1 on 2022-08-20. Score: 2

"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.

> **Comments:**
> **username_0**: Sorry let me clarify, I am looking for a list of cardano addresses  

---

### Answer by username_2 on 2022-08-21. Score: 1

You can use Koios endpoint documented [here](https://api.koios.rest/#get-/asset_address_list), and if you run a dbsync instance, you can find the dbsync query used [here](https://github.com/cardano-community/guild-operators/blob/alpha/files/grest/rpc/assets/asset_address_list.sql)


---

