How to Use the Dune Analytics (Web3 SQL Analytics API) MCP in VS Code Copilot

Q: How do we share Dune Analytics (Web3 SQL Analytics API) across a team in VS Code Copilot?

You add the MCP server configuration to a .vscode/mcp.json file and commit it to your Git repository. Each developer on the team can then access the tools through Copilot Chat once they configure their local API keys.

Q: How do we fetch SQL results from Dune Analytics (Web3 SQL Analytics API) in VS Code Copilot?

Your agent first checks the run progress using getexecutionstatus. Once the query is complete, it calls getexecutionresults to pull the raw data directly into your active workspace.

Share live blockchain database tools across your engineering team by linking VS Code Copilot to Dune.

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 VS Code Copilot

Create your Vinkius account to connect Dune Analytics (Web3 SQL Analytics API) to VS Code Copilot 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 VS Code Copilot

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Team-Wide MCP Server Access in VS Code

This MCP Server uses `execute_query` to let your team run blockchain database queries directly from Copilot Chat. Your agent runs database executions using shared parameters committed to your repository configuration. Every developer on the team can run the same queries without manually sharing API keys or copying SQL code back and forth.

Manage Shared Query Executions

This MCP Server uses `get_execution_status` to check the progress of shared database runs. Your agent monitors active executions to ensure the team is writing code against completed, fresh datasets. This prevents developers from writing redundant code against stale data. The agent monitors the run state and alerts the team when the fresh dataset is ready.

Pull Real Datasets Into Your Workspace

This MCP Server uses `get_execution_results` to fetch completed database rows directly into your workspace files. Your agent retrieves the active dataset and formats it into JSON or CSV files. This makes it easy to write test suites and mock data parsers. You get direct access to live blockchain metrics without opening a browser or using external database clients.

Setup guide

Set up Dune Analytics (Web3 SQL Analytics API) MCP in VS Code Copilot

Prerequisites

VS Code 1.99 or later with GitHub Copilot extension
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Open the Command Palette (Cmd+Shift+P / Ctrl+Shift+P) and run "MCP: Add Server". Select HTTP (Streamable) as the server type. VS Code will create .vscode/mcp.json in your workspace.
2

Add the Dune Analytics (Web3 SQL Analytics API) MCP

Paste the JSON snippet shown on the right into your .vscode/mcp.json. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Switch to Agent mode

Open Copilot Chat (Cmd+Shift+I / Ctrl+Shift+I) and switch to Agent mode using the dropdown. MCP tools are only available in Agent mode — they do not appear in Edit or Ask modes.
4

Verify the connection

In the Copilot Chat input, type # to list available tools. You should see the Dune Analytics (Web3 SQL Analytics API) tools listed. Try asking: "List my recent Dune Analytics (Web3 SQL Analytics API) transactions" and Copilot will invoke them automatically.

.vscode/mcp.json

{
  "mcpServers": {
    "dune-analytics-web3-sql-analytics-api-mcp": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

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 VS Code Copilot

You add the MCP server configuration to a `.vscode/mcp.json` file and commit it to your Git repository. Each developer on the team can then access the tools through Copilot Chat once they configure their local API keys.

Yes, if a query is taking too long or wasting database resources, the agent can call `cancel_execution`. This stops the run immediately and saves your team's API credits.

Your agent first checks the run progress using `get_execution_status`. Once the query is complete, it calls `get_execution_results` to pull the raw data directly into your active workspace.

Yes, you need VS Code version 1.96 or higher to support custom MCP configurations. You must also enable Agent mode in the Copilot Chat interface.

The server processes your database queries and API keys locally without routing them through intermediate servers. All traffic to Dune is encrypted via TLS, keeping your SQL parameters and result rows private to your team's development environment.

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