Skip to main content
Glama
SAK1337

Dune Analytics MCP Server

by SAK1337
tasks.md1 kB
# Tasks: Add MCP Prompts for SQL Generation and Result Analysis ## 1. Generate DuneSQL Prompt - [x] 1.1 Implement generate_dune_sql prompt with @mcp.prompt decorator - [x] 1.2 Add intent and chain arguments - [x] 1.3 Include Trino/Presto dialect instructions - [x] 1.4 Include bytearray syntax guidance - [x] 1.5 Include date interval syntax - [x] 1.6 Include table naming conventions - [x] 1.7 Include LIMIT clause reminder ## 2. Analyze Result Prompt - [x] 2.1 Implement analyze_result prompt - [x] 2.2 Include instructions for identifying outliers - [x] 2.3 Include growth rate calculation guidance - [x] 2.4 Include Markdown table formatting instructions ## 3. Template Content - [x] 3.1 Write comprehensive SQL generation template text - [x] 3.2 Write result analysis template text - [x] 3.3 Ensure templates are clear and actionable ## 4. Validation - [x] 4.1 Test prompt retrieval via MCP client - [x] 4.2 Verify arguments are properly exposed - [x] 4.3 Validate template content is complete

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/SAK1337/dune-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server