Agent skill

Dune MCP Skill

by holon-run in holon-run/uxc

Use Dune MCP through UXC for blockchain table discovery, SQL query creation/execution, execution result retrieval, and visualization with help-first schema inspection, explicit auth binding, and…

MITAuto-check passedDatabases

Install Dune MCP Skill

skills CLI
$ npx skills add holon-run/uxc --skill dune-mcp-skill -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install holon-run/uxc dune-mcp-skill --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/holon-run/uxc.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/dune-mcp-skill .claude/skills/dune-mcp-skill && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
dune-mcp-skill
GitHub stars
116
Token cost
~1.2k tokens
SKILL.md length
430 words
Files
4 (incl. scripts, references)
Skills in repo
62
Repo updated
First seen
Licence
MIT

At a glance

Use Dune MCP through UXC for blockchain table discovery, SQL query creation/execution, execution result retrieval, and visualization with help-first schema inspection, explicit auth binding, and…

  • Works in 5 steps: Confirm endpoint and protocol with… → Configure credential/binding for… → Use fixed link command by default → …
  • Tasks that involve MCP servers
  • SKILL.md covers Prerequisites, Core Workflow, Capability Map and Recommended Usage Pattern, plus 3 more sections
  • Runs Shell scripts from its folder; reaches api.dune.com; needs DUNE_API_KEY

What it does

Dune MCP Skill is an agent skill from holon-run/uxc. Use Dune MCP through UXC for blockchain table discovery, SQL query creation/execution, execution result retrieval, and visualization with help-first schema inspection, explicit auth binding, and guarded credit-consuming operations.

Its SKILL.md is about 1.2k tokens, which your agent loads only when the skill is triggered. The skill folder holds 6 other files, including scripts and reference files (for example `agents/openai.yaml`, `references/usage-patterns.md` and `scripts/validate.sh`).

It sits in Databases, covering MCP servers and SQL. It works with Model Context Protocol and SQL. The repository describes itself as: A unified CLI for discovering and invoking tools across OpenAPI, MCP, GraphQL, gRPC, and JSON-RPC. The licence is MIT.

When your agent uses it

  • Tasks that involve MCP servers
  • Tasks that involve SQL

Example prompts

  • “/dune-mcp-skill”

Requirements

  • A Bash shell
  • A credential in DUNE_API_KEY

Workflow steps

5 steps, taken from the first numbered list in SKILL.md.

  1. Confirm endpoint and protocol with help-first probing
  2. Configure credential/binding for repeatable auth
  3. Use fixed link command by default
  4. Inspect operation schema before execution
  5. Prefer read/discovery operations first, then query creation or credit-consuming execution.

What it can do on your machine

Read from SKILL.md and the folder at commit 562d47c. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships 1 file in scripts/ (Shell), which the agent can run.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Hosts in commands or code, which the agent is likely to contact:

    • api.dune.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names these keys or tokens, usually read from environment variables:

    • DUNE_API_KEY

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Dune MCP Skill loads about 1.2k tokens when it runs, and up to ~2.2k if it reads all its reference files. Until then it costs about 62 tokens; SKILL.md has 430 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~62
When it runs · the whole SKILL.md, loaded when a task matches
~1.2k
With references · SKILL.md plus every file in references/, read only if the agent opens them
~2.2k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from holon-run/uxc at commit 562d47c, republished under its MIT licence (© holon-run). 430 words, ~1,152 tokens.

Download SKILL.mdSave it as .claude/skills/dune-mcp-skill/SKILL.md (or your agent's skills folder). This skill also uses 3 other files; get the full folder from GitHub.
name
dune-mcp-skill
description
Use Dune MCP through UXC for blockchain table discovery, SQL query creation/execution, execution result retrieval, and visualization with help-first schema inspection, explicit auth binding, and guarded credit-consuming operations.

Dune MCP Skill

Use this skill to run Dune MCP operations through uxc.

Reuse the uxc skill for shared protocol discovery, output parsing, and generic auth/binding flows.

Prerequisites

  • uxc is installed and available in PATH.
  • Network access to https://api.dune.com/mcp/v1.
  • Dune API key is available for authenticated calls.

Core Workflow

  1. Confirm endpoint and protocol with help-first probing:
    • uxc https://api.dune.com/mcp/v1 -h
  2. Configure credential/binding for repeatable auth:
    • uxc auth credential set dune-mcp --auth-type api_key --header "x-dune-api-key={{secret}}" --secret-env DUNE_API_KEY
    • uxc auth credential set dune-mcp --auth-type api_key --header "x-dune-api-key={{secret}}" --secret-op op://Engineering/dune/api-key
    • uxc auth binding add --id dune-mcp --host api.dune.com --path-prefix /mcp/v1 --scheme https --credential dune-mcp --priority 100
  3. Use fixed link command by default:
    • command -v dune-mcp-cli
    • If missing, create it: uxc link dune-mcp-cli https://api.dune.com/mcp/v1
    • dune-mcp-cli -h
  4. Inspect operation schema before execution:
    • dune-mcp-cli searchTables -h
    • dune-mcp-cli searchTablesByContractAddress -h
    • dune-mcp-cli createDuneQuery -h
    • dune-mcp-cli executeQueryById -h
    • dune-mcp-cli getExecutionResults -h
  5. Prefer read/discovery operations first, then query creation or credit-consuming execution.

Capability Map

  • Discovery:
    • searchDocs
    • searchTables
    • listBlockchains
    • searchTablesByContractAddress
  • Query lifecycle:
    • createDuneQuery
    • getDuneQuery
    • updateDuneQuery
    • executeQueryById
    • getExecutionResults
  • Analysis helpers:
    • generateVisualization
    • getTableSize
    • getUsage
  1. Find the right table first:
    • dune-mcp-cli searchTables query='uniswap swaps'
    • dune-mcp-cli searchTablesByContractAddress contractAddress=0x...
  2. Prefer higher-level spell tables when they already expose the metrics you need.
  3. Keep SQL partition-aware:
    • use block_date, evt_block_date, or another partition/date column in WHERE
  4. Create a temporary query only after confirming table choice and date range.
  5. Execute and fetch results by execution ID.
Show full SKILL.md (192 more words)Show less

Guardrails

  • Keep automation on JSON output envelope; do not rely on --text.
  • Parse stable fields first: ok, kind, protocol, data, error.
  • Use dune-mcp-cli as default command path.
  • dune-mcp-cli <operation> ... is equivalent to uxc https://api.dune.com/mcp/v1 <operation> ....
  • Discovery operations are read-only:
    • searchDocs
    • searchTables
    • listBlockchains
    • searchTablesByContractAddress
    • getDuneQuery
    • getExecutionResults
    • getTableSize
    • getUsage
  • Require explicit user confirmation before credit-consuming or state-changing operations:
    • createDuneQuery
    • updateDuneQuery
    • executeQueryById
    • generateVisualization
  • Be careful with privacy:
    • confirm before switching a query from private to public
    • temporary queries can still be visible; inspect is_private and is_temp
  • key=value input now supports automatic type conversion for numeric MCP arguments.
  • Numeric IDs can be passed directly with key=value, for example:
    • query_id=6794106
    • queryId=6794106
  • Positional JSON is still useful for nested objects or when mixing string and numeric fields precisely:
    • {"executionId":"01...","timeout":90,"limit":20}
  • For SQL passed via key=value, wrap the whole SQL string in double quotes so inner SQL single quotes survive shell parsing.
  • If listBlockchains returns a Dune-side schema/facet error, fall back to searchTables with blockchains filters.

Tested Real Scenario

The following flow was exercised successfully through uxc:

  • discover table: uniswap.uniswapx_trades
  • create temporary query for Base daily volume
  • execute query
  • fetch results

The successful SQL shape was:

sql
SELECT block_date,
       ROUND(SUM(amount_usd), 2) AS daily_volume_usd,
       COUNT(*) AS trades
FROM uniswap.uniswapx_trades
WHERE blockchain = 'base'
  AND block_date >= date_add('day', -7, CURRENT_DATE)
GROUP BY 1
ORDER BY 1 DESC
LIMIT 7

References

  • Invocation patterns:
    • references/usage-patterns.md

© holon-run, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 3 other files (scripts, references) in skills/dune-mcp-skill of holon-run/uxc.

  • SKILL.md
  • agents/openai.yaml
  • references/usage-patterns.md
  • scripts/validate.sh

Open the folder on GitHubat commit 562d47c

Compare with similar skills

Dune MCP Skill next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Dune MCP Skill compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Dune MCP Skill this skillholon-run/uxc116—~1.2kAutomated safety check: PassMIT
Tune Monitorsickn33/agentic-awesome-skills47k1 repos~3.3kAutomated safety check: PassApache-2.0
Sap Hana CLIsecondsky/sap-skills462—~3.1kAutomated safety check: NotesGPL-3.0
Nvidia Ontology QueryNVIDIA/skills3.6k—~1.7kAutomated safety check: PassApache-2.0
Semantic Analystsidequery/sidemantic129—~982Automated safety check: PassAGPL-3.0
Pytorch Clickhousepytorch/test-infra113—~2.8kAutomated safety check: PassCustom licence

Similar skills

  • Tune Monitor

    sickn33/agentic-awesome-skills

    Analyze a Monte Carlo monitor and recommend config changes to reduce alert noise.

    47k GitHub starsUsed in 1 repo~3.3k tokens
    DatabasesAuto-check passed
  • Sap Hana CLI

    secondsky/sap-skills

    Assists with SAP HANA Developer CLI (hana-cli) for database development and administration.

    462 GitHub stars~3.1k tokensUpdated 5 days ago
    DatabasesAuto-check: notes
  • Official

    Query Auto Ontology and validate generated SQL, rows, and answers.

    3.6k GitHub stars~1.7k tokensUpdated yesterday
    DatabasesAuto-check passed
  • Semantic Analyst

    sidequery/sidemantic

    Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer.

    129 GitHub stars~982 tokensUpdated 3 days ago
    DatabasesAuto-check passed
  • Pytorch Clickhouse

    pytorch/test-infra

    Load this FIRST whenever working with PyTorch CI data (any pytorch/ org repo), the torchci/HUD codebase, or the PyTorch HUD ClickHouse database.

    113 GitHub stars~2.8k tokensUpdated today
    DatabasesAuto-check passed
  • Relational Database MCP Cloudbase

    Microck/ordinary-claude-skills

    This is the required documentation for agents operating on the CloudBase Relational Database.

    404 GitHub starsUsed in 2 repos~1.3k tokens
    Agent WorkflowsAuto-check passed

More from holon-run/uxc

All 62 skills in this repo
  • Context7 MCP Skill

    holon-run/uxc

    Query up-to-date library documentation and code examples using Context7 MCP.

    116 GitHub stars~564 tokensUpdated 25 days ago
    Auto-check passed
  • Deepwiki MCP Skill

    holon-run/uxc

    Ask questions and read documentation about any GitHub repository using DeepWiki MCP.

    116 GitHub stars~700 tokensUpdated 25 days ago
    Auto-check passed
  • Operate Linear workspace issues, projects, and teams through Linear GraphQL API using UXC.

    116 GitHub stars~1.8k tokensUpdated 25 days ago
    Auto-check passed
  • Operate Notion Public API through UXC with a curated OpenAPI schema for search, block traversal, page reads, content writes, and data source/database inspection.

    116 GitHub stars~2.3k tokensUpdated 25 days ago
    Auto-check passed
  • Operate Alchemy Prices API reads through UXC with a curated OpenAPI schema, path-templated API-key auth, and read-first guardrails.

    116 GitHub starsUsed in 1 repo~1k tokens
    Auto-check passed
  • Uxc

    holon-run/uxc

    Discover and call remote schema-exposed interfaces with UXC.

    116 GitHub stars~1.8k tokensUpdated 25 days ago
    Auto-check passed

Questions about Dune MCP Skill

What does Dune MCP Skill do?

Use Dune MCP through UXC for blockchain table discovery, SQL query creation/execution, execution result retrieval, and visualization with help-first schema inspection, explicit auth binding, and…. Dune MCP Skill is an agent skill from holon-run/uxc. Use Dune MCP through UXC for blockchain table discovery, SQL query creation/execution, execution result retrieval, and visualization with help-first schema inspection, explicit auth binding, and guarded credit-consuming operations.

When should I use Dune MCP Skill?

Dune MCP Skill fits situations like: tasks that involve MCP servers; tasks that involve SQL.

How do I install Dune MCP Skill in Claude Code?

Run `npx skills add holon-run/uxc --skill dune-mcp-skill -a claude-code`. Or copy the skill folder (skills/dune-mcp-skill in holon-run/uxc) into .claude/skills/dune-mcp-skill in your project. Claude Code loads it when a task matches its description.

How do I install Dune MCP Skill in Codex?

Run `npx skills add holon-run/uxc --skill dune-mcp-skill -a codex`. Or copy the skill folder (skills/dune-mcp-skill in holon-run/uxc) into .agents/skills/dune-mcp-skill in your project. Codex loads it when a task matches its description.

Can I use Dune MCP Skill in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add holon-run/uxc --skill dune-mcp-skill -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/dune-mcp-skill, .gemini/skills/dune-mcp-skill, .github/skills/dune-mcp-skill and .opencode/skills/dune-mcp-skill in your project.

What does Dune MCP Skill need to run?

Going by SKILL.md and its folder, Dune MCP Skill needs a shell for the scripts in its folder and credentials named DUNE_API_KEY. Our summary lists: A Bash shell; A credential in DUNE_API_KEY.

Does Dune MCP Skill access the network?

SKILL.md names 1 domain. In commands or code: api.dune.com; the agent is likely to contact it when it follows the instructions. This is read from the text; nothing was executed.

Is Dune MCP Skill safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Dune MCP Skill use?

Dune MCP Skill is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Dune MCP Skill use?

About 1.2k tokens (SKILL.md is roughly 4.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 1k tokens, read only when the agent opens those files.

What are the alternatives to Dune MCP Skill?

Skills that share tags, products or a category with Dune MCP Skill: Tune Monitor (sickn33/agentic-awesome-skills, 47k stars), Sap Hana CLI (secondsky/sap-skills, 462 stars), Nvidia Ontology Query (NVIDIA/skills, 3.6k stars) and Semantic Analyst (sidequery/sidemantic, 129 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Dune MCP Skill?

holon-run (a GitHub organization) maintains it in holon-run/uxc, which has 116 GitHub stars. The repository holds 62 skills in this directory. The repository was last updated on September 15, 2026.

Source: holon-run/uxc on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.