MCP Servers

Dune Analytics MCP Server

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

kukapay

Research & Data

README

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

Clone the Repository:

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

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

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)
```
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.

Recommended Servers

Sequential Thinking MCP Server

This server facilitates structured problem-solving by breaking down complex issues into sequential steps, supporting revisions, and enabling multiple solution paths through full MCP integration.

Crypto Price & Market Analysis MCP Server

A Model Context Protocol (MCP) server that provides comprehensive cryptocurrency analysis using the CoinCap API. This server offers real-time price data, market analysis, and historical trends through an easy-to-use interface.

MCP PubMed Search

Server to search PubMed (PubMed is a free, online database that allows users to search for biomedical and life sciences literature). I have created on a day MCP came out but was on vacation, I saw someone post similar server in your DB, but figured to post mine.

dbt Semantic Layer MCP Server

A server that enables querying the dbt Semantic Layer through natural language conversations with Claude Desktop and other AI assistants, allowing users to discover metrics, create queries, analyze data, and visualize results.

mixpanel

Connect to your Mixpanel data. Query events, retention, and funnel data from Mixpanel analytics.

Vectorize

Vectorize MCP server for advanced retrieval, Private Deep Research, Anything-to-Markdown file extraction and text chunking.

Nefino MCP Server

Provides large language models with access to news and information about renewable energy projects in Germany, allowing filtering by location, topic (solar, wind, hydrogen), and date range.

MATLAB MCP Server

Integrates MATLAB with AI to execute code, generate scripts from natural language, and access MATLAB documentation seamlessly.

Macrostrat MCP Server

Enables Claude to query comprehensive geologic data from the Macrostrat API, including geologic units, columns, minerals, and timescales through natural language.

MCP Word Counter

A Model Context Protocol server that provides tools for analyzing text documents, including counting words and characters. This server helps LLMs perform text analysis tasks by exposing simple document statistics functionality.