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

Stream real-time blockchain data into your Vercel AI SDK interface using 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 Vercel AI SDK

Create your Vinkius account to connect Dune Analytics (Web3 SQL Analytics API) to Vercel AI SDK 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 Vercel AI SDK

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Live blockchain data streams

Pipe raw SQL results directly into your frontend components as they finish. You trigger `execute_query` and watch the data arrive in your UI without waiting for a stale state. This MCP Server handles the async heavy lifting, so your Vercel AI SDK build keeps the interface snappy. Users see the numbers populate as soon as the execution hits completion.

Full query lifecycle management

Control your data flow by checking `get_execution_status` before pulling records. This prevents your app from rendering incomplete sets or hitting unnecessary API errors. When a user needs to stop a heavy operation, `cancel_execution` halts the process instantly. You maintain a clean state across every query cycle.

Structured result retrieval

Fetch finalized rows from `get_execution_results` once your agent confirms the status is set. This keeps your application logic predictable and your data sources strictly typed. Your AI client interprets these results immediately. It avoids the mess of manual parsing by pulling clean, column-indexed data directly from the source.

Setup guide

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

Prerequisites

Node.js 18+ and a TypeScript project
ai + @modelcontextprotocol/sdk packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies

Run npm install ai @modelcontextprotocol/sdk plus your preferred model provider (e.g. @ai-sdk/openai).
2

Create the Streamable HTTP transport

Use StreamableHTTPClientTransport with your Vinkius endpoint URL. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.
3

Discover and use tools

Call mcpClient.tools() to auto-discover all Dune Analytics (Web3 SQL Analytics API) tools. Pass them directly to generateText() or streamText() — no manual schema definitions needed.
4

Works with any model provider

Swap openai("gpt-4o") for any AI SDK provider — Anthropic, Google, Mistral. The MCP tools work identically across all supported models.

index.ts

import { experimental_createMCPClient as createMCPClient } from "ai";
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp";
import { generateText } from "ai";
import { openai } from "@ai-sdk/openai";

const transport = new StreamableHTTPClientTransport(
  new URL("https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp")
);

const mcpClient = await createMCPClient({ transport });
const tools = await mcpClient.tools();

const { text } = await generateText({
  model: openai("gpt-4o"),
  tools,
  prompt: "List recent Dune Analytics (Web3 SQL Analytics API) transactions",
});

console.log(text);
await mcpClient.close();

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 Vercel AI SDK

Install the MCP client packages in your project. Configure the transport URL to point at your Vinkius endpoint, then pass the tools directly into your `generateText` or `streamText` functions.

Yes. The transport layer is designed for low-latency communication. You can execute SQL queries within your edge routes without hitting timeout limits.

You can write custom SQL in your query string to filter data before it hits your app. The tool returns exactly what your query specifies.

Check the status field returned by the status tool. If a query fails, the error message from the API is passed through to your agent for immediate handling.

Vinkius uses a secure sandbox for your connections. Only the SQL query text and the resulting blockchain rows traverse the connection between your agent and the database.

Use it with your favorite AI tools

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

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript