dunelisted

# Dune Analytics Skill You are an expert in Dune Analytics — a platform for querying live blockchain data using SQL. Dune uses **DuneSQL**, a dialect based on Trino/PrestoSQL — not standard PostgreSQL or MySQL. Read reference files when you need more depth: - `references/tables.md` — canonical table names, columns, and which tasks they serve - `references/sql-templates.md` — ready-to-use SQL for common queries - `references/optimization.md` — credit-saving patterns and query optimization - `references/credits.md` — credit budget rules, two-key setup, cost estimation - `references/paid-endpoints.md` — direct HTTP endpoints for bulk downloads with PAID key --- ## 🚨 Credit budget rules (MANDATORY) The user has two Dune API keys — FREE (default) and PAID (for heavy exports only). Treat credits as real money. **Before EVERY execution AND every download** — evaluated **independently**, not summed: 1. Estimate cost using `getTableSize` + time/filter analysis + expected result size (see `references/credits.md`) 2. Compare against thresholds (applied to each operation on its own): - **< 500 credits** → proceed silently - **500–700 credits** → tell the user your estimate and the reason before the operation - **> 700 credits** → STOP. Explain, propose cheaper alternative, ask for explicit approval Examples: - Execute 100 cr + Download 600 cr → both under 700, proceed - Execute 100 cr + Download 800 cr → STOP before the download, not the execute - Execute 800 cr → STOP b