Loading video...
Video Failed to Load
Most onchain research workflows: open Dune → write SQL → wait → export → paste chart into a doc → repeat. Here's what it looks like with the Dune MCP Prompt sent to Claude: "Give me a 30-day summary of Aave's TVL, active borrower count, and liquidation events across... show more
24,473 views • 1 month 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)
![I decided to share part of a prompt you can use to research any protocol in seconds using INFINIT Intelligence by INFINIT. As an example, I used Silo Labs, where I currently farm most of my stablecoin yields. 🔖 Bookmark this + read until the end for a bonus. Just replace [PROTOCOL NAME] with any protocol you want to research. Prompt: "Conduct thorough research on [PROTOCOL NAME] and answer the following questions: - What is the project building? - What problem does it solve, and for whom? - What makes it different from others? - What blockchain is it built on? - Is there a token? What’s its purpose? - How does the protocol work technically? - How does it make money or sustain itself? - What’s the staking model, emissions, burns, and treasury? - Who are the founders, and is the team public and credible? - Who funded it? Who holds most tokens? - Are users, TVL, and volume growing? - How strong is the ecosystem around it? - Who are the main competitors, and how does it compare? - Is the protocol audited? Any past hacks? - What are the best ways to use the protocol (strategies)? - What’s coming next? Key milestones or launches? - What are the biggest risks? - How strong is the community and social traction?" Bonus: Quote this post with a reason why you like INFINIT, and I’ll DM you the full version of the prompt within the next 24 hours.](https://image.24vids.com/tw-1945745343720968196/amplify_video_thumb/1945745289899540480/img/5mXpisRPPsoCxQuR.jpg)