dune-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DUNE_API_KEY | Yes | Your Dune Analytics API key | |
| GITHUB_TOKEN | No | Optional GitHub token for accessing Spellbook repository | |
| DUNE_USER_HANDLE | No | Your Dune username (optional, used to auto-detect your queries) |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| analyze_query_errorC | Analyze failed queries and suggest fixes (e.g. for 'Column not found'). |
| get_account_statusA | Check remaining credits and budget limits. |
| get_session_budgetB | Check remaining queries/credits for this session. |
| search_public_queriesB | Search public queries by keyword. Use this to discover table names from existing SQL. |
| get_query_detailsB | Get SQL and parameters for a query ID. |
| get_table_schemaA | |
| create_queryA | Save a new query to Dune. Returns Query ID. (Requires Paid Plan) |
| update_queryC | Update SQL/description of an existing query. (Requires Paid Plan) |
| archive_queryC | Archive/Delete a query. (Requires Paid Plan) |
| execute_queryC | Execute a query by ID. Returns Job ID. |
| get_job_statusC | Check query execution status. Polls for 30s. |
| get_job_results_summaryB | Get result preview (5 rows) and stats. |
| analyze_resultsC | |
| export_results_to_csvC | Download full query results to local CSV. |
| list_user_queriesC | List queries by user handle. |
| search_spellbookA | Search GitHub Spellbook for official tables (.sql/.yml). Zero-credit schema discovery. |
| get_spellbook_file_contentC | Fetch raw content of a Spellbook file from GitHub. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/nice-bills/dune-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server