Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

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...

24,521 Aufrufe • vor 3 Monaten •via X (Twitter)

0 Kommentare

Keine Kommentare verfügbar

Kommentare vom Original-Post werden hier angezeigt

Ähnliche Videos

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.. 👇

Axel Bitblaze 🪓

32,016 Aufrufe • vor 4 Monaten

20 days ago, I connected Claude Code to my newly created instagram handle.. I gained 4.3M views and 6500+ followers in less than a month [ i post Ai generated animated stories ] Full workflow: i let claude study my account before i write another reel.. This is the cleanest content workflow i've built on claude. give it your IG first. 4 prompts handle the rest.. niche research, the reel script, the hook, and the daily automation.. the whole loop is basically, give claude your IG → find what's working → write retention-optimized scripts → engineer the hook → automate the daily output.. ▫️ Setup: give claude your instagram open claude code. claude code has a built-in web tool that browses any public URL. or install any agentic browser like Browser Harness or Firecrawl or Comet browser paste this with your handle filled in: "Browse and pull the last 30 reels and posts. Analyze my recurring topics, top-performing hooks, formats, and engagement patterns. Then map out my actual audience and what they consistently respond to." claude reads your profile, pulls every reel down, and now has the context to personalize every prompt below to YOUR account, not a generic niche. if you're on claude desktop, the same works with firecrawl MCP connected. ▫️ Prompt 1 find what actually goes viral in your niche: "Analyze the highest-performing Instagram Reels, TikToks, and Reddit posts in the [niche] niche from the last 30 days. Identify repeating hooks, visual styles, emotional triggers, and content formats that consistently generate high engagement. Then summarize the 5 strongest content angles optimized for AI-generated content and short-form videos." run this after the setup. you get 5 angles backed by what's already working in your niche, cross-checked against what's already working on YOUR account. ▫️ Prompt 2 write a high-retention reel script "Write a short-form Instagram Reel script about [topic] with an aggressive hook in the first 2 seconds. Create immediate curiosity, tension, or controversy to stop scrolling, then deliver a fast and satisfying payoff. Keep it under 30 seconds and optimize the structure for watch time, replays, comments, and shares. Finish with a subtle CTA." the line that matters: "optimize the structure for watch time, replays, comments, and shares." claude writes for the metrics, not just the word count. ▫️ Prompt 3 engineer better hooks "Study the top-performing Reels in [niche] and break down the hook structure, pacing, and emotional triggers used in the first 3 seconds. Then generate 5 new hook variations that are even more curiosity-driven, emotionally charged, and optimized to stop scrolling instantly. Focus on triggers like surprise, fear, ego, urgency, or desire." most reels die in the first 2 seconds. this prompt has claude reverse-engineer what already works, then give you 5 sharper versions to swap in. ▫️ Prompt 4 automate the whole workflow "Build a complete AI-powered content workflow for Instagram in the [niche] niche. The system should identify trending topics daily, generate high-retention scripts, create matching AI visuals, turn them into short-form videos, and generate optimized captions and hashtags. Structure everything as a repeatable workflow designed for consistent daily posting and growth." once the niche and script structure are validated, this turns it into a daily loop. one prompt that handles topic → script → visual → video → caption. these 4 prompts are the building blocks. the setup is what makes them yours. your real value is in the [niche] you plug in. content workflow built in one weekend, daily posting on autopilot from monday.

Axel Bitblaze 🪓

199,569 Aufrufe • vor 2 Monaten

I just built a Claude Cowork skill that turns your Google Ads data into a visual performance dashboard in 60 seconds 🤯 One prompt → campaign breakdowns, CPA trends, spend vs conversions charts, and hourly conversion patterns, all rendered as an interactive HTML dashboard you open in Chrome. All inside Claude Cowork. Perfect for DTC brands and agencies who are pulling Google Ads data into spreadsheets every week, manually building charts, and spending an hour formatting a report that's outdated by the time you send it. If you're managing Google Ads and your weekly reporting workflow looks like this — export a CSV, open Google Sheets, build a pivot table, copy the numbers into a slide deck, manually create charts, format everything, realize you forgot a campaign, start over ... This skill does the whole thing in one prompt: → Connects to your live Google Ads data via MCP → Pulls spend, conversions, CPA, ROAS, CTR across every campaign → Builds an interactive HTML dashboard → Summary cards at the top: total spend, total conversions, avg CPA, avg ROAS → Bar chart comparing spend vs conversions by campaign → CPA trend line over the last 30 days → Campaign table ranked by performance, color-coded green/yellow/red → Opens in Chrome: hover over charts, compare campaigns, screenshot for your team No spreadsheets. No manual chart building. No hour-long formatting sessions. What you get: → A visual dashboard from live data in under 60 seconds → Campaign performance you can actually see, not just read in a table → CPA trends that show you where things are heading, not just where they are → A dashboard you can screenshot and drop into Slack, a client report, or a team standup → Reusable — run it weekly and the data updates automatically One prompt. Live data. A finished dashboard you open in your browser. I put together a playbook with the full skill file, the setup, and the exact prompts to customize the dashboard for your account. Want it for free? > Like this post > Comment "DASH" And I'll send it over (must be following so I can DM)

Mike Futia

38,846 Aufrufe • vor 4 Monaten