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) |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| analyze_query_error | Analyze failed queries and suggest fixes (e.g. for 'Column not found'). |
| get_account_status | Check remaining credits and budget limits. |
| get_session_budget | Check remaining queries/credits for this session. |
| search_public_queries | Search public queries by keyword. Use this to discover table names from existing SQL. |
| get_query_details | Get SQL and parameters for a query ID. |
| get_table_schema | Get columns for a table. Costs Credits (runs SELECT * LIMIT 0). |
| create_query | Save a new query to Dune. Returns Query ID. (Requires Paid Plan) |
| update_query | Update SQL/description of an existing query. (Requires Paid Plan) |
| archive_query | Archive/Delete a query. (Requires Paid Plan) |
| execute_query | Execute a query by ID. Returns Job ID. |
| get_job_status | Check query execution status. Polls for 30s. |
| get_job_results_summary | Get result preview (5 rows) and stats. |
| analyze_results | Detect outliers (Z-score > 3) and trends in query results. |
| export_results_to_csv | Download full query results to local CSV. |
| list_user_queries | List queries by user handle. |
| search_spellbook | Search GitHub Spellbook for official tables (.sql/.yml). Zero-credit schema discovery. |
| get_spellbook_file_content | 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 | |