Skip to main content
Glama
SAK1337

Dune Analytics MCP Server

by SAK1337
proposal.md814 B
# Change: Add MCP Prompts for SQL Generation and Result Analysis ## Why Writing valid DuneSQL requires specific knowledge of Trino dialect, table naming conventions, and bytea array syntax. MCP Prompts provide reusable templates that guide the LLM's behavior, reducing SQL errors and improving result interpretation. ## What Changes - Add `generate_dune_sql` prompt for constructing valid DuneSQL queries - Add `analyze_result` prompt for interpreting query output - Include dialect instructions, bytearray syntax, date handling, and table naming conventions ## Impact - Affected specs: mcp-prompts (new capability) - Affected code: server.py (add prompt definitions) - Dependencies: Requires core-server capability (proposal 1) - **Benefit**: Significantly reduces SQL syntax errors from LLM-generated queries

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