Which integrations are available for this server?

Provides access to [Ethereum](/mcp/servers/integrations/ethereum) blockchain data including transactions, logs, traces, and decoded protocol events through Dune Analytics' data platform. Provides access to [Optimism](/mcp/servers/integrations/optimism) blockchain data including transactions and other chain-specific data through Dune Analytics' data platform. Provides access to [Polygon](/mcp/servers/integrations/polygon) blockchain data including transactions, logs, and other chain-specific data through Dune Analytics' data platform. Provides access to [Solana](/mcp/servers/integrations/solana) blockchain data including DEX trades through Dune Analytics' data platform. Executes DuneSQL queries using [Trino](/mcp/servers/integrations/trino) syntax for blockchain data analysis, including data types, functions, and SQL operations.

Dune MCP Server

A comprehensive MCP (Model Context Protocol) server for interacting with Dune Analytics - the leading platform for blockchain data analysis.

Features

Tools

This server exposes all major Dune Analytics API endpoints as MCP tools:

SQL Execution

execute_sql - Execute raw SQL queries against Dune's data engine
get_execution_status - Check query execution status
get_execution_results - Retrieve query results (JSON)
get_execution_results_csv - Retrieve query results (CSV)
cancel_execution - Cancel a running query

Saved Query Management

execute_query - Execute a saved query by ID
get_query - Get query details
get_query_results - Get latest cached results without re-executing
get_query_results_csv - Get latest results as CSV
create_query - Create and save a new query
update_query - Update an existing query
archive_query - Archive a query
make_query_private / make_query_public - Change query visibility

Data Upload

upload_csv - Upload CSV data to create/update a table
create_table - Create a new table with schema
insert_table_rows - Insert rows into an existing table
clear_table - Clear all data from a table
delete_table - Permanently delete a table

Resources

The server exposes comprehensive documentation as MCP resources to help LLMs write valid DuneSQL queries:

Resource URI	Description
`dune://guide/sql-syntax`	DuneSQL (Trino) syntax reference, data types, functions
`dune://guide/tables`	Available tables: dex.trades, prices.usd, chain-specific tables
`dune://guide/query-patterns`	Common analytics patterns: volume, holders, whales, gas
`dune://guide/parameters`	How to use query parameters
`dune://guide/errors`	Common errors and troubleshooting

Installation

cd dune-mcp pip install -e .

Configuration

Set your Dune API key as an environment variable:

export DUNE_API_KEY="your-api-key-here"

Get your API key from Dune Settings.

Usage

Running the Server

# Direct execution python server.py # Or via installed script dune-mcp

Claude Desktop Configuration

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

{ "mcpServers": { "dune": { "command": "python", "args": ["/path/to/dune-mcp/server.py"], "env": { "DUNE_API_KEY": "your-api-key-here" } } } }

Or using uv:

{ "mcpServers": { "dune": { "command": "uv", "args": ["run", "--directory", "/path/to/dune-mcp", "python", "server.py"], "env": { "DUNE_API_KEY": "your-api-key-here" } } } }

Example Queries

Simple DEX Volume Query

# Using execute_sql tool result = await execute_sql( sql=""" SELECT project, SUM(amount_usd) as volume FROM dex.trades WHERE block_time > now() - interval '24' hour GROUP BY 1 ORDER BY 2 DESC LIMIT 10 """, performance="medium" )

Cross-Chain Analysis

result = await execute_sql( sql=""" SELECT blockchain, COUNT(*) as tx_count, SUM(amount_usd) as volume_usd FROM dex.trades WHERE block_time > now() - interval '7' day GROUP BY 1 ORDER BY 3 DESC """ )

Create Parameterized Query

result = await create_query( name="Token Volume Analysis", query_sql=""" SELECT DATE_TRUNC('day', block_time) as day, SUM(amount_usd) as volume FROM dex.trades WHERE token_bought_symbol = '{{token}}' AND block_time > now() - interval '{{days}}' day GROUP BY 1 ORDER BY 1 """, parameters=[ {"key": "token", "value": "UNI", "type": "text"}, {"key": "days", "value": "30", "type": "number"} ] )

Available Tables

Curated (Cross-Chain)

dex.trades - DEX trades across all EVM chains
dex_solana.trades - Solana DEX trades
nft.trades - NFT trades
prices.usd - Token prices
tokens.erc20 - ERC20 token metadata

Chain-Specific

ethereum.transactions, ethereum.logs, ethereum.traces
polygon.transactions, polygon.logs, etc.
arbitrum.transactions, optimism.transactions, base.transactions

Decoded Protocol Tables

uniswap_v3_ethereum.Pair_evt_Swap
aave_v3_ethereum.Pool_evt_Supply
And many more...

API Reference

See Dune API Documentation for complete API details.

License

MIT

Install Server

A

security – no known vulnerabilities

A

license - permissive license

A

quality - confirmed to work

How are these scores calculated?

Resources

GitHub Repository

Need Help?

Report Issue

Related Servers

Tools

View all tools

dune-mcp

Dune MCP Server

Features

Tools

SQL Execution

Saved Query Management

Data Upload

Resources

Installation

Configuration

Usage

Running the Server

Claude Desktop Configuration

Example Queries

Simple DEX Volume Query

Cross-Chain Analysis

Create Parameterized Query

Available Tables

Curated (Cross-Chain)

Chain-Specific

Decoded Protocol Tables

API Reference

License

Resources

Tools

New MCP Servers

Latest Blog Posts

MCP directory API