Wallet Database
The Wallet Database is every active wallet on Solana, queried directly. You describe the wallet you want as conditions on the same 164 metrics Data Import shows, run the query, and get every wallet that matches as a Data Import list. No bot commands, no files to upload. Part of the Wallet Database + API plan; on the Plus plan the page shows a lock and a link to the plans.
flowchart LR
A["Condition"] --> B["Group (AND / OR)"] --> C["Get Wallets"] --> D["Save as a Data Import list"]Build a query
Open Wallet Database in the sidebar. The page is called Wallet Database Search Builder. A query is one or more groups, and a group is one or more conditions; Group 1 is waiting for you with one empty condition.
Write the first condition
In the first row of Group 1, pick a metric in the first dropdown and an operator in the second, then type the value; the minus and plus next to it step the number. The operators depend on the kind of metric:
- Numbers: Equal, Not Equal, Greater Than, Less Than, Greater or Equal, Less or Equal, Between.
- Dates: Equal, Before, After, Between. A calendar with a time picker opens for the value.
- Text: Equal, Not Equal, Contains, Starts With, Ends With.
Between asks for two values.
Add conditions to the group
Click the green plus in the group's header to add a condition. Every condition inside a group is joined by the same word: AND means all of them must be true, OR means any one of them is enough. One group, one word; you cannot mix the two inside a group. The red cross removes the whole group.
Add a group when you need to mix
Click Add Group. The new group carries an AND / OR switch in its corner that joins it to the groups above it, and has its own AND or OR inside. Two levels is all there is: conditions inside groups, groups joined together. That covers most questions; if you need more, split the query into two presets.
Choose a limit and run
In the Limit box next to Get Wallets, pick how many wallets you want back: 100, 500, 1,000, 5,000, 10,000, 50,000 or 100,000. The default is 100,000. Click Get Wallets.
A first query that works well, one group joined with AND: win rate over the last 7 days Greater or Equal 60, profit over the last 7 days Greater Than 5,000, average holding time over the last 7 days Between 10 minutes and 6 hours. Then a second group, joined with OR, for the same numbers over the last 30 days.
Read the count and save the list
A window shows what the query found:
- No results found. Loosen a condition and run again.
- Found N results, with N at or under your limit. Type a name for the list and click Save. The wallets become a Data Import list and the list opens like any other: every metric a column, filters, presets, export.
- Found N results, with N above your limit. The window says the list will be built from the first wallets up to the limit and suggests narrowing the filters. Save it as it is, or Cancel, tighten the query and run again.
Each run saves a new list. To keep a running database, export the list from Data Import and add it to another list with Import Wallets.
Save the query as a preset
Click Presets at the top right. Type a name and click Save as new. The preset joins the list; click it to load it, and the builder fills in every group and condition. While a preset is loaded:
- Change something and an amber dot appears next to the name: unsaved changes. Click Update to write them into the preset, or Save as new to keep both.
- The trash icon, shown when you hover a preset, deletes it.
The limit is not part of a preset; set it each time. A preset is yours alone.
A preset per thesis, run every morning, is the fastest way to a fresh shortlist. The Wallet Database is recomputed hourly, so the same query gives you today's wallets, not last week's.
Reuse the query in the API
Reset, at the top right, clears the builder. Query Preview, under the builder, shows the query as JSON while you build it, with Copy JSON. That JSON is exactly the body the Wallet Database endpoint of the REST API accepts: build and test a query here, paste it into your script, and the API returns the same wallets.
Was this page helpful?
Related articles
Data Import
Upload up to 100,000 Solana wallets and get every metric per wallet in a table you can sort, filter, export and save as presets, refreshed hourly.
Wallet Deep Dive
One Solana wallet in full: profit, win rate and ROI over 1, 7 or 30 days, every swap, the result per token, related wallets, and a shareable PnL card.
Copy Trader Checker
Paste one Solana wallet and see whether it is the master or a copy trader, who copies it, and who gets in faster or slower, before you follow it.
Token Creators
Filter the database of token creators by their track record, export the ones you trust, and load the list into your trading bot as a deployer whitelist.
Built with Helpnode