Happy slice of mcp pizzaMCP.pizza
Fire in da houseTop Tip:Paying $100+ per month for Perplexity, MidJourney, Runway, ChatGPT and other tools is crazy - get all your AI tools in one site starting at $15 per month with Galaxy AI Fire in da houseCheck it out free

dune-analytics-mcp

MCP.Pizza Chef: kukapay

The dune-analytics-mcp is an MCP server that connects Dune Analytics data to AI agents, enabling them to fetch and run Dune queries by ID. It returns query results as CSV-formatted strings for easy integration and processing. This server requires Python 3.10+ and a valid Dune Analytics API key, facilitating real-time access to blockchain analytics data within AI workflows.

Use This MCP server To

Fetch latest results of a Dune Analytics query by ID Run Dune Analytics queries and retrieve CSV results Integrate blockchain analytics data into AI agent workflows Automate data retrieval from Dune Analytics for reporting Enable AI models to access real-time blockchain query data

README

Dune Analytics MCP Server

smithery badge

A mcp server that bridges Dune Analytics data to AI agents.

Features

  • Tools:
    • get_latest_result: Fetch the latest results of a Dune query by ID.
    • run_query: Execute a Dune query by ID and retrieve results.
  • CSV Output: All results are returned as CSV-formatted strings for easy processing.

Prerequisites

  • Python 3.10+
  • A valid Dune Analytics API key (get one from Dune Analytics)

Installation

Installing via Smithery

To install Dune Analytics for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @kukapay/dune-analytics-mcp --client claude

Manual Installation

  1. Clone the Repository:

    git clone https://github.com/kukapay/dune-analytics-mcp.git
cd dune-analytics-mcp

  2. Set Up Environment Variables: Create a .env file in the project root:

    DUNE_API_KEY=your_api_key_here

    Alternatively, set it as a system environment variable:

    export DUNE_API_KEY="your_api_key_here"

Usage

Running the Server

  • Development Mode:

    mcp dev main.py

    This starts the server with hot reloading for development.

  • Install for Claude Desktop:

    mcp install main.py --name "Dune Analytics"

    Installs the server as a service for use with Claude Desktop.

Tool Usage

  1. get_latest_result(query_id)

    • Description: Retrieves the latest results of a specified Dune query.
    • Input: query_id (int) - The ID of the Dune query.
    • Output: CSV-formatted string of the query results.
    • Example: 
      get_latest_result(query_id=4853921)

  2. run_query(query_id)

    • Description: Executes a Dune query and returns the results.
    • Input: query_id (int) - The ID of the Dune query to run.
    • Output: CSV-formatted string of the query results.
    • Example: 
      run_query(query_id=1215383)

Example Commands in Claude Desktop

  • "Get latest results for dune query 1215383"
  • "Run dune query 1215383"

License

This project is licensed under the MIT License - see the LICENSE file for details.

dune-analytics-mcp FAQ

How do I obtain a Dune Analytics API key?
You can get a valid API key by signing up and generating one at https://dune.com/settings/api.
What programming language is required to run dune-analytics-mcp?
The server requires Python 3.10 or higher to run properly.
How are query results returned by the server?
All query results are returned as CSV-formatted strings for easy processing and integration.
Can I use dune-analytics-mcp with different AI models?
Yes, it is compatible with various AI providers like OpenAI, Claude, and Gemini, as it serves data via MCP protocol.
How do I install dune-analytics-mcp?
You can install it manually by cloning the GitHub repo or automatically via Smithery CLI for supported clients like Claude Desktop.
What tools does dune-analytics-mcp provide?
It provides tools like get_latest_result to fetch the latest query results and run_query to execute queries by ID.