Dune Analytics

What is Dune Analytics?

The server bridges Dune Analytics data to AI agents, exposing two primary tools—get_latest_result and run_query—that return query outcomes in CSV format.

How to use Dune Analytics?

1. Install via Smithery (recommended):

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

2. Set the API key in a .env file or as an environment variable:

   DUNE_API_KEY=your_api_key_here
   

3. Run the server in development mode:

   mcp dev main.py
   

4. Invoke tools from an AI agent or Claude Desktop:
   • get_latest_result(query_id=4853921)
   • run_query(query_id=1215383)

Key Features

• Two dedicated tools: quick fetch of latest results and full query execution.
• CSV output: results are returned as ready‑to‑process CSV strings.
• Simple installation via Smithery or manual cloning.
• Python 3.10+ compatibility.

Use Cases

• Enabling AI agents to answer data‑driven queries with up‑to‑date blockchain analytics.
• Automating report generation where CSV data can be fed into downstream pipelines.
• Integrating Dune insights into custom dashboards or chatbot responses.

FAQ

• Do I need a Dune account? Yes, a valid Dune Analytics API key is required.
• What language is the server written in? Python.
• Can I run the server in production? Yes, use mcp install main.py --name "Dune Analytics" to register it as a service.
• What format are the results? Plain CSV strings, easy to parse in any environment.
• Is there a license? The project is licensed under the MIT License.

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.