Dune MCP Skill for Openclaw

A powerful tool for AI agents to discover, query, and visualize blockchain data directly from Dune Analytics.

jolestar
v1.0.0
Mar 8, 2026
0
831
0

Install & Download

1. ClawHub CLI

The fastest way to install a skill directly from the registry.

npx clawhub@latest install dune-mcp-skill

2. Manual Installation

Copy the skill folder to one of these locations

Global
~/.openclaw/skills/
Workspace
<project>/skills/

Priority: Workspace > Local > Bundled

3. Prompt Installation

Copy this prompt to OpenClaw to install it automatically.

Help me install dune-mcp-skill using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).

Prefer to download?

Get the raw skill files in a ZIP archive.

What is Dune MCP Skill?

The Dune MCP Skill enables seamless interaction with Dune Analytics through the Model Context Protocol (MCP) and uxc command-line tool. It allows developers and AI agents to probe blockchain schemas, manage the full lifecycle of SQL queries, and retrieve execution results with high efficiency.

By integrating this skill, users can leverage Openclaw Skills to automate data discovery across multiple chains and protocols while maintaining strict control over API credits and authentication security. It serves as a bridge between LLM-driven reasoning and the vast datasets available on Dune, facilitating help-first schema inspection and guarded operations.

Dune MCP Skill Use Cases

  • Discovering blockchain tables and contract addresses for protocol-specific analysis.
  • Automating the creation and execution of temporary SQL queries for real-time data insights.
  • Integrating blockchain data visualization into AI-driven dashboards and reports.
  • Monitoring protocol usage and table sizes across different blockchains.
  • Streamlining the data-to-insight workflow within Openclaw Skills environments.

How Dune MCP Skill Works

  1. Endpoint Probing: Confirm protocol compatibility and available operations using help-first discovery.
  2. Credential Configuration: Set up secure API key bindings using uxc for repeatable, authenticated calls.
  3. CLI Linking: Create a dedicated dune-mcp-cli command to simplify tool invocation within the agent environment.
  4. Schema Inspection: Analyze operation schemas (like searchTables or executeQueryById) before execution to ensure parameter accuracy.
  5. Execution Lifecycle: Perform read-only discovery first, followed by query creation and credit-consuming execution upon user confirmation.
  6. Result Retrieval: Fetch and parse structured JSON output for analysis or visualization.

Dune MCP Skill Setup

To get started with this skill, ensure uxc is installed and follow these steps:

# Configure your Dune API credentials
uxc auth credential set dune-mcp --auth-type api_key --header "x-dune-api-key={{secret}}" --secret-env DUNE_API_KEY

# Bind the credential to the Dune MCP endpoint
uxc auth binding add --id dune-mcp --host api.dune.com --path-prefix /mcp/v1 --scheme https --credential dune-mcp --priority 100

# Create a local command link for easier access
uxc link dune-mcp-cli https://api.dune.com/mcp/v1

Dune MCP Skill Data Schema & Taxonomy

The Dune MCP Skill organizes data around several core entities and returns them in a structured JSON envelope. This ensures high compatibility with other Openclaw Skills.

Entity Key Attributes Purpose
Discovery table_name, blockchain, contract_address Identifying the correct data sources
Query query_id, sql_text, is_private, is_temp Managing SQL definitions and visibility
Execution execution_id, state, submitted_at Tracking query progress and results
Result data, metadata, columns Consuming the final dataset

All responses include stable fields: ok, kind, protocol, and data for robust error handling and automation.

Dune MCP Skill Advanced Features

  • Partition-aware SQL guards: Encourages using block_date or evt_block_date to optimize query performance and cost.
  • Automatic Type Conversion: Supports direct numeric argument passing for query IDs and execution limits via key=value pairs.
  • Explicit Credit Guardrails: Requires user confirmation before performing operations that consume Dune credits.
  • Multi-Chain Discovery: Seamlessly switch between blockchains using the listBlockchains and searchTables operations.
  • Visualization Integration: Ability to generate high-level visualizations directly from query results for better data storytelling.
  • Secure Secret Management: Integrates with environment variables or 1Password via uxc within the Openclaw Skills ecosystem.

SKILL.md


Loading

Related Openclaw Skills

METADATA

Github Stars: 0
forks: 0

Featured*