As a developer, I'd like to have a service that retrieves the information of a stake pool based on its ticker (or all the stake pools with that ticker, I know there can be duplicates).

I'm thinking that with graphql I need to query first the list of stakePools (which is huge) and then filter that by ticker, which is inside the metadata of the pool.

Is there a way to do this in a more performing way or a service already solving this for me?

1 Answer 1


The list of stake pools should only be a couple of thousand which is tiny in comparison to number of blocks or even worse the number of transactions.

It can be done with a relatively simple SQL query on the database maintained by cardano-db-sync.

  • Is it possible to query the ticker of a pool directly from the db? Or should I have to get first the URL of the metadata? I understand that the ticker is not a field in the stake pools database. Am I right? Thank you. Jun 27, 2022 at 6:12
  • 2
    The ticker is stored in the db. You want the ticker_name field of the pool_offline_data table, Jun 28, 2022 at 7:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.