How to Use the Dune Analytics (Web3 SQL Analytics API) MCP in CrewAI
Deploy a specialized agent crew for autonomous blockchain analysis using the Dune Analytics (Web3 SQL Analytics API) MCP Server.
Works with every AI agent you already use
…and any MCP-compatible client
Connect Dune Analytics (Web3 SQL Analytics API) MCP to CrewAI
Create your Vinkius account to connect Dune Analytics (Web3 SQL Analytics API) to CrewAI and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.
Autonomous query research
Assign a dedicated agent to run `execute_query` for deep blockchain research. The agent handles the SQL logic while other crew members prepare the findings. This setup allows for continuous monitoring of on-chain activity. Your agents act on data as soon as the results are available.
Collaborative result analysis
Share memory across your crew so agents can analyze the output of `get_execution_results` together. One agent pulls the data, another interprets the financial impact. This specialized approach ensures high-quality output. The agents work in sequence to ensure every query is reviewed before a final decision is made.
Intervention and cancellation
Use `cancel_execution` to stop runaway queries if your monitor agent detects an issue. This keeps your API usage efficient and prevents wasted cycles. Your crew stays lean and responsive. You set the rules, and the agents execute them without needing your constant supervision.
Set up Dune Analytics (Web3 SQL Analytics API) MCP in CrewAI
Prerequisites
- Python 3.10+ installed
-
crewaipackage (pip install crewai) - Active Vinkius subscription with a valid endpoint token
- 1
Install CrewAI
Run
pip install crewaito install the framework. MCP support is built-in via themcpsparameter. - 2
Add the MCP URL to your agent
Pass your Vinkius endpoint directly to the
mcpslist. Replace[YOUR_TOKEN_HERE]with your token from cloud.vinkius.com. CrewAI handles tool discovery and caching automatically. - 3
Kick off your crew
Create a
Crewwith your agent and tasks. Callcrew.kickoff()— the agent will automatically invoke Dune Analytics (Web3 SQL Analytics API) tools as needed.
from crewai import Agent, Task, Crew
agent = Agent(
role="Dune Analytics (Web3 SQL Analytics API) Analyst",
goal="Access and analyze Dune Analytics (Web3 SQL Analytics API) data via MCP.",
backstory="Expert analyst with direct Dune Analytics (Web3 SQL Analytics API) access.",
mcps=[
"https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
],
)
task = Task(
description="List recent Dune Analytics (Web3 SQL Analytics API) transactions",
agent=agent,
expected_output="A summary of recent activity",
)
crew = Crew(agents=[agent], tasks=[task])
result = crew.kickoff()
print(result) Prerequisites
- Python 3.10+ installed
-
crewai+crewai-toolspackages - Active Vinkius subscription with a valid endpoint token
- 1
Install dependencies
Run
pip install crewai crewai-tools. TheMCPServerAdapterhandles lifecycle management and tool conversion. - 2
Connect with MCPServerAdapter
Use
MCPServerAdapteras a context manager withSseServerParameterspointing to your Vinkius endpoint. The adapter automatically manages connection lifecycle. - 3
Assign tools and run
Pass the returned
mcp_toolsto your agent'stoolsparameter. The adapter converts MCP tools to nativeBaseToolobjects compatible with all CrewAI agents.
from crewai import Agent, Task, Crew
from crewai_tools import MCPServerAdapter
from mcp import SseServerParameters
server_params = SseServerParameters(
url="https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
)
with MCPServerAdapter(server_params) as mcp_tools:
agent = Agent(
role="Dune Analytics (Web3 SQL Analytics API) Analyst",
goal="Access and analyze Dune Analytics (Web3 SQL Analytics API) data via MCP.",
backstory="Expert analyst with direct Dune Analytics (Web3 SQL Analytics API) access.",
tools=mcp_tools,
)
task = Task(
description="List recent Dune Analytics (Web3 SQL Analytics API) transactions",
agent=agent,
expected_output="A summary of recent activity",
)
crew = Crew(agents=[agent], tasks=[task])
result = crew.kickoff()
print(result) Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Dune Analytics. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.
Why Choose Vinkius
Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.
Real-time monitoring
Live
visibility into every interaction
Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.
Built-in savings
60%
lower AI costs
Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.
Single dashboard
One
place for every integration
Every tool your AI connects to, managed from a single screen. One account, complete control.
Common questions about Dune Analytics (Web3 SQL Analytics API) MCP in CrewAI
Use it with your favorite AI tools
Connect this server to Cursor, Claude, VS Code, and more.
Start using the Dune Analytics (Web3 SQL Analytics API) MCP today
We host it, we monitor it, we maintain it. You just paste one token.