Loading video...
Video Failed to Load
base's builder code dune now has app names🔥 check out apps making the most daily impact across - trading volume - transaction count and fees - transacting addresses L28D table at the bottom too s/o Kofi for his wizardry, and Dune for the tooling!
25,828 views • 5 months ago •via X (Twitter)
0 Comments
No comments available
Comments from the original post will appear here
![Dune analytics MCP.. Claude becomes your on chain SQL analyst.. No dashboard has every query you'll ever need. dune does but writing SQL is a skill, and most of you would skip it.. i know this MCP fixes that. Claude writes the query, runs it on dune, and explains what the data actually means. with this MCP wired in, you don't need to know SQL. you describe what you want in plain english and Claude does the rest. like "Claude, which wallets bought $RAVE in last few weeks and still hold?" "Claude, show me the top 50 ETH wallets by stablecoin inflows last 7 days." "Claude, what's the median gas paid by ARB users in the last 24h?" Questions no dashboard can answer. one prompt away.. Setup (3 minutes) ▫️Step 1: grab a free dune API key → ▫️Step 2: add this to ~/.claude/settings.json or .mcp.json: { "mcpServers": { "dune": { "command": "npx", "args": ["-y", "dune-analytics-mcp"], "env": { "DUNE_API_KEY": "your-key-here" } } } } ▫️Step 3: restart claude. you'll see the dune tool load in your tool menu. that's it. you now have onchain SQL on tap. How to actually use it: 3 prompts i use: 1) Smart money watchlist: "claude, pull the top 20 wallets by realized pnl on $TOKEN in the last 30 days. show me which ones are still holding." gives you a clean leaderboard of who's actually winning on that token. add them to your etherscan watchlist. 2) accumulation vs distribution "claude, compare net inflows vs outflows for $TOKEN across all CEX wallets in the last 14 days." if whales are moving off exchanges → accumulation. onto exchanges → distribution. you see the rotation before the candle. 3) narrative heat check "claude, which 10 tokens saw the biggest % increase in unique new holders this week?" finds where fresh money is flowing. before this MCP i'd either, pay for a pro dune account + write queries manually, or look at someone else's dashboard and hope it answers my question… now claude writes it for me, in seconds, custom to my thesis. no dashboard in existence beats that. free tier covers most of what you need. upgrade if you're querying heavy. ( built a quick $RAVE post mortem dashboard using a prompt as shown in the video ) MORE SUCH USEFUL MCP for traders below.. 👇](https://image.24vids.com/tw-2045657064299786341/amplify_video_thumb/2045656912549863424/img/a2zxbHfmRxNlfgPl.jpg)
