What is Dune Analytics

The Dune Analytics MCP Server is a tool that bridges Dune Analytics data with AI agents, allowing for easy access and manipulation of Dune query results.

Use cases

This server can be used to retrieve the latest results of Dune queries or execute specific queries programmatically, making it ideal for data analysis, reporting, and integrating Dune’s capabilities into larger applications or workflows.

How to use

To use the server, install it via Smithery or manually clone the repository, set your Dune API key in an environment variable, and run the server in development mode or install it as a service for Claude Desktop. You can invoke tools like ‘get_latest_result’ and ‘run_query’ to interact with Dune queries.

Key features

Key features include tools to fetch the latest results from Dune queries and execute specific queries, with all results formatted as CSV strings for easy processing.

Where to use

This server is suitable for developers and analysts working with Dune Analytics data who want to streamline their workflows through AI interactions, particularly within Claude Desktop or similar environments.

Dune Analytics MCP Server

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.