How to Use the Dune Analytics (Web3 SQL Analytics API) MCP in Mastra AI

Q: How does Dune Analytics (Web3 SQL Analytics API) handle tool approval in Mastra AI?

Use the requireToolApproval setting in your agent. You will get a prompt before any SQL query is sent to the database.

Automate complex blockchain workflows in Mastra AI with the Dune Analytics (Web3 SQL Analytics API) MCP Server.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Dune Analytics (Web3 SQL Analytics API) MCP to Mastra AI

Create your Vinkius account to connect Dune Analytics (Web3 SQL Analytics API) to Mastra AI and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Dune Analytics (Web3 SQL Analytics API) with Mastra AI

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Automated SQL execution workflows

Build agentic pipelines that run queries and handle the results automatically. Use `execute_query` as the starting point for any multi-step analysis. Mastra AI manages the sequence. If a query takes time, the agent waits or performs other tasks until the status is ready for the next step.

Conditional query logic

Branch your workflow based on the output of `get_execution_status`. You can define retries or fallback queries if a specific execution hits a failure state. This keeps your agent operations moving forward. You never have to manually restart a failed data pull because the logic is baked into your agent configuration.

Reliable data retrieval

Pull verified data rows using `get_execution_results` only after the agent confirms success. This ensures your downstream actions receive consistent, accurate information. Your agents rely on this validation to make decisions. It removes the guesswork from handling raw blockchain metrics in your automated processes.

Setup guide

Set up Dune Analytics (Web3 SQL Analytics API) MCP in Mastra AI

Prerequisites

Node.js 18+ and a TypeScript project
@mastra/mcp + @mastra/core packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies
Run npm install @mastra/mcp @mastra/core plus your preferred model provider (e.g. @ai-sdk/openai).
2

Configure the MCPClient
Create an MCPClient with your Vinkius endpoint as a URL object. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.
3

Discover and inject tools
Call mcpClient.listTools() and spread the result into your agent's tools object. All Dune Analytics (Web3 SQL Analytics API) tools become native Mastra tools.
4

Run with any model
Swap openai("gpt-4o") for any AI SDK-compatible provider. Call agent.generate() and the agent routes tool calls through MCP automatically.

agent.ts

import { MCPClient } from "@mastra/mcp";
import { Agent } from "@mastra/core/agent";
import { openai } from "@ai-sdk/openai";

const mcpClient = new MCPClient({
  id: "dune-analytics-web3-sql-analytics-api-mcp-client",
  servers: {
    "dune-analytics-web3-sql-analytics-api-mcp": {
      url: new URL(
        "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
      ),
    },
  },
});

const agent = new Agent({
  name: "Dune Analytics (Web3 SQL Analytics API) Agent",
  model: openai("gpt-4o"),
  instructions: "You have access to Dune Analytics (Web3 SQL Analytics API) tools.",
  tools: {
    ...(await mcpClient.listTools()),
  },
});

const result = await agent.generate(
  "List recent Dune Analytics (Web3 SQL Analytics API) transactions"
);
console.log(result.text);

Get your connection token →

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.

Connect Dune Analytics (Web3 SQL Analytics API) now

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 Mastra AI

Include the server URL in your agent definition. Once initialized, the tools are available for your agents to call during their standard execution cycles.

Yes. You can write a workflow that checks the status and triggers a retry if the query fails. The toolset integrates with the built-in retry engine.

Use the `requireToolApproval` setting in your agent. You will get a prompt before any SQL query is sent to the database.

Vinkius manages all auth tokens. Your agent only communicates with the server through an authenticated, encrypted channel.

It stores nothing. Every request is ephemeral, and only the queried SQL and resulting blockchain data rows pass through the session.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.