Cardano address dump?

English Community Technical Support
1

Hi there. I have a seed phrase from 2023 that I used for Cardano, and it appears that I wrote it down wrong, because importing it to any wallet gives me “invalid mnemonics” errors. I figured the best course of action is to try btcrecover to unscramble the seed phrase, but because I don’t remember my address, I would need a full list of funded addresses (I should have some funds left over). So far I have only found advice to run my own node, but my resources (hard drive space, bandwidth) are limited. Is there any place I can download such an address dump? Surprisingly blockchair.com doesn’t have one for ADA.

2

I still use this every time I feel the need to get what I think you are looking for:

This never made it into Cardano’s recognised tool portfolio since it was considered to be little else beyond a Blockfrost query to get these details. I was involved in that review (though I voted to include the tool because of its interest to nontechnical users) and resolved to get such a best-practice way of doing it: but actually never did.

I looked over the Python code in that period, including the last couple of revisions, and didn’t personally see anything alarming about it & also was in brief contact with the developer who seemed responsible. At least at that point it didn’t do anything but that query & then convert the results (as some would say, trivially) into CSV for a spreadsheet.

3

Thanks for the quick reply! I’m a newbie when it comes to Python (thank God for AI which helps a lot), so it’s a bit difficult to understand everything right away… Am I correct in understanding that it’s possible to use that tool to get a full list of Shelley addresses with >0 transactions (or funded addresses)? Since the list would include millions of entries, wouldn’t an API key reach its limit almost immediately when querying? Sorry if I sound stupid lol.

4

@nucsil I was afraid I may have misunderstood you & it appears I have. From my reading of your post above I thought you knew your wallet address already & were looking for other addresses it had transactions with. You are indeed considering a much more global query. :grimacing:

5

Just a heads‑up any DM you get about this is almost certainly a phishing attempt.

6

Thank you for the heads-up, @lodl_de It is extremely important to remind everyone that no one from the community should ever ask for your seed phrase or offer ‘recovery services’ via DM. Please, @nucsil be extremely cautious and ignore any direct messages promising to ‘fix’ your wallet, they are almost certainly scammers. Stay safe and stick to official community resources only. :handshake:

7

Thanks for all the replies, I guess what I need is someone running a Cardano node who can get me this:



COPY (
    SELECT DISTINCT address
    FROM tx_out
    WHERE address IS NOT NULL
) TO '/tmp/cardano_addresses.txt';

My lack of technical skills or server with the required 60GB of RAM are keeping me from doing it myself.

8

They’re currently required to run cardano-db-sync for the Midnight stack, and there are several in the Cardano community running Midnight nodes… so you might get a hit if asking over there: https://discord.com/invite/midnightnetwork