Dune Analytics MCP Server

A Model Context Protocol (MCP) server that provides seamless integration with Dune Analytics. Execute queries, manage tables, work with materialized views, and access blockchain analytics data directly through the MCP protocol.

Features

- Query Execution: Execute Dune queries with parameters, get results in JSON or CSV format
- Query Management: Create, update, archive, and manage Dune queries programmatically
- Custom Tables: Create and manage custom data tables in your Dune namespace
- Materialized Views: Set up and manage materialized views with automatic refresh schedules
- Custom Endpoints: Access custom API endpoints for specialized data retrieval
- Full API Coverage: Comprehensive support for the Dune Analytics API

Prerequisites

You need a Dune Analytics API key to use this MCP server.

Get your API key from dune.com/settings/api. You'll need to:
1. Sign up or log in to Dune Analytics
2. Navigate to Settings → API
3. Create a new API key
4. Copy the key for use in the installation steps below

Installation

$3

``bash
claude mcp add --transport stdio dune-analytics-tools --env DUNE_API_KEY=your_api_key_here -- npx -y dune-analytics-mcp
`

Replace your_api_key_here with your actual Dune API key from dune.com/settings/api.

$3

Add to your Claude Desktop configuration (~/Library/Application Support/Claude/claude_desktop_config.json on macOS):

`json
{
"mcpServers": {
"dune": {
"command": "npx",
"args": ["-y", "dune-analytics-mcp"],
"env": {
"DUNE_API_KEY": "your_api_key_here"
}
}
}
}
`

$3

`bash
npm install dune-analytics-mcp
`

Or install globally:

`bash
npm install -g dune-analytics-mcp
`

Available Tools

$3

- execute_query - Start a query execution (returns execution_id)
- get_execution_status - Check status of a running query
- get_execution_results - Get results of a completed query (JSON)
- get_execution_results_csv - Get results in CSV format
- cancel_execution - Cancel a running query
- run_query - Execute query and wait for results (convenience method)
- get_latest_results - Get cached results without using credits
- get_latest_results_csv - Get cached results in CSV format

$3

- create_query - Create a new Dune query
- update_query - Update an existing query
- read_query - Read query metadata and SQL
- archive_query - Archive a query
- unarchive_query - Restore an archived query
- make_query_private - Make a query private
- make_query_public - Make a query public

$3

- create_table - Create a custom data table
- insert_table - Insert data into a table (CSV/JSON/NDJSON)
- delete_table - Delete a table

$3

- list_materialized_views - List all materialized views
- upsert_materialized_view - Create or update a materialized view
- delete_materialized_view - Delete a materialized view
- refresh_materialized_view - Manually trigger a refresh

$3

- get_custom_results - Access custom API endpoints by username/slug

API Coverage

This MCP server provides complete coverage of the Dune Analytics API:

- ✅ Query Execution API
- ✅ Query Management API
- ✅ Table Management API
- ✅ Materialized Views API
- ✅ Custom Endpoints API

Development

`bash


Clone the repository

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

Install dependencies

npm install

Build

npm run build

Run locally

DUNE_API_KEY=your_key node dist/index.js
``

Requirements

- Node.js >= 20.0.0 (LTS)
- Dune Analytics API key

Links

- Dune Analytics
- Dune API Documentation
- Model Context Protocol

License

MIT License - see LICENSE file for details

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

Support

For issues and questions:
- GitHub Issues