メニュー
Executes SQL queries on Dune Analytics and writes results as CSV to /tmp. Use when the user needs blockchain data from Dune or wants to run a saved Dune query by ID. Triggers: "dune query", "dune sql", "query dune", "blockchain data"
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Manages issues via the br CLI (beads), a local-first tracker stored in .beads/ (SQLite + JSONL). Use when capturing issues, finding ready work, claiming issues, managing dependencies, or syncing changes. Triggers: "br", "beads", "issue tracking".
Review, rewrite, and debug LLM prompts. Use when asked to: (1) improve an existing prompt, (2) design a new system or developer prompt, (3) add few-shot examples, (4) define output schemas and success criteria, (5) diagnose prompt failures from transcripts. Not for: model policy workarounds, producing domain answers without context, or guaranteeing model-specific behavior.
Creates or updates mala.yaml project configuration files for the local mala orchestrator. Use when asked to initialize, generate, write, edit, validate, fix, or explain a mala.yaml config, including presets, commands, coverage, evidence checks, validation triggers, or review settings.
Simplifies and refines code for clarity, consistency, and maintainability while preserving all functionality. Focuses on recently modified code unless instructed otherwise. Triggers: simplify, refine, clean up code.
Automates browser interactions for web testing, form filling, screenshots, and data extraction. Use when the user needs to navigate websites, interact with web pages, fill forms, take screenshots, or extract information from web pages.
Explore Python import graphs and enforce layered architecture using grimp.
| name | querying-dune |
| description | Executes SQL queries on Dune Analytics and writes results as CSV to /tmp. Use when the user needs blockchain data from Dune or wants to run a saved Dune query by ID. Triggers: "dune query", "dune sql", "query dune", "blockchain data" |
| compatibility | Python 3.10+, Bash, DUNE_API_KEY in .env or environment |
If there is any uncertainty about how to run a query or what data is available: use Web tools to find the answer in the Dune docs:
Run scripts/run.sh to execute SQL:
SKILL_DIR="$HOME/.agents/skills/dune-sql"
# Basic query (saves to /tmp/dune_result.csv)
"$SKILL_DIR/scripts/run.sh" "SELECT * FROM ethereum.transactions LIMIT 100"
# Custom output filename
"$SKILL_DIR/scripts/run.sh" -o txns.csv "SELECT * FROM ethereum.blocks LIMIT 10"
# Large performance tier
"$SKILL_DIR/scripts/run.sh" -p large "SELECT * FROM ethereum.transactions LIMIT 1000"
Run scripts/query.sh to execute a saved query:
# Run a saved query by ID
"$SKILL_DIR/scripts/query.sh" 1215383
# With custom output
"$SKILL_DIR/scripts/query.sh" -o my_query.csv 1215383
# With parameters (JSON format, types inferred)
"$SKILL_DIR/scripts/query.sh" --params '{"token": "USDC", "min_amount": 1000}' 1215383
0 → Query succeeded, CSV written1 → Error (SQL error, API error, config error)2 → Query timed out or failedScripts:
Documentation: