Dune Analytics MCP Server

1# Dune Analytics MCP Server
2 
3[![smithery badge](https://smithery.ai/badge/@kukapay/dune-analytics-mcp)](https://smithery.ai/server/@kukapay/dune-analytics-mcp)
4 
5A mcp server that bridges Dune Analytics data to AI agents.
6 
7## Features
8 
9- **Tools**: 
10  - `get_latest_result`: Fetch the latest results of a Dune query by ID.
11  - `run_query`: Execute a Dune query by ID and retrieve results.
12- **CSV Output**: All results are returned as CSV-formatted strings for easy processing.
13 
14## Prerequisites
15 
16- Python 3.10+
17- A valid Dune Analytics API key (get one from [Dune Analytics](https://dune.com/settings/api))
18 
19## Installation
20 
21### Installing via Smithery
22 
23To install Dune Analytics for Claude Desktop automatically via [Smithery](https://smithery.ai/server/@kukapay/dune-analytics-mcp):
24 
25```bash
26npx -y @smithery/cli install @kukapay/dune-analytics-mcp --client claude
27```
28 
29### Manual Installation
30 
311. **Clone the Repository**:
32   ```bash
33   git clone https://github.com/kukapay/dune-analytics-mcp.git
34   cd dune-analytics-mcp
35   ```
36 
372. **Set Up Environment Variables**:
38   Create a `.env` file in the project root:
39   ```
40   DUNE_API_KEY=your_api_key_here
41   ```
42   Alternatively, set it as a system environment variable:
43   ```bash
44   export DUNE_API_KEY="your_api_key_here"
45   ```
46 
47## Usage
48 
49### Running the Server
50 
51- **Development Mode**:
52  ```bash
53  mcp dev main.py
54  ```
55  This starts the server with hot reloading for development.
56 
57- **Install for Claude Desktop**:
58  ```bash
59  mcp install main.py --name "Dune Analytics"
60  ```
61  Installs the server as a service for use with Claude Desktop.
62 
63### Tool Usage
64 
651. **`get_latest_result(query_id)`**
66   - **Description**: Retrieves the latest results of a specified Dune query.
67   - **Input**: `query_id` (int) - The ID of the Dune query.
68   - **Output**: CSV-formatted string of the query results.
69   - **Example**:
70     ```
71     get_latest_result(query_id=4853921)
72     ```
73 
742. **`run_query(query_id)`**
75   - **Description**: Executes a Dune query and returns the results.
76   - **Input**: `query_id` (int) - The ID of the Dune query to run.
77   - **Output**: CSV-formatted string of the query results.
78   - **Example**:
79     ```
80     run_query(query_id=1215383)
81     ```
82 
83### Example Commands in Claude Desktop
84 
85- "Get latest results for dune query 1215383"
86- "Run dune query 1215383"
87 
88 
89## License
90 
91This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.
92