← all publishers

duneanalytics

@duneanalytics source repo

Report this profile Claim this profile

• 8 skills
• 0 followers
• 11 hours ago last updated

1. ▌
   Catalyst Dex Integration · duneanalytics

   Add a DEX project to dex.trades for a chain (sources, base trades, chain unions, seed, dex_info)
   0
   installs
2. ▌
   Catalyst Gas And Transfers · duneanalytics

   Add gas fees and token transfer models for a new chain (hourly_spellbook + tokens)
   0
   installs
3. ▌
   Catalyst Foundational Metadata · duneanalytics

   Set up new chain foundational metadata (evms_info, prices, base sources, evms_blockchains_list)
   0
   installs
4. ▌
   Debug CI · duneanalytics

   Diagnose failed Spellbook PR CI workflows, dbt slim CI steps, missing seeds, stale manifests, cluster issues, and CI test table queries.
   0
   installs
5. ▌
   Review Spell · duneanalytics

   Review Spellbook spell contributions for config blocks, schema YAML, SQL style, Jinja, performance, seeds, architecture, and compile/test readiness.
   0
   installs
6. ▌
   Run Dbt Commands · duneanalytics

   Run dbt CLI commands (compile, ls, test, run, etc.) in the spellbook repo. Use when the user asks to compile, list, test, or run dbt models, or when you need to validate SQL by compiling a model.
   0
   installs
7. ▌
   Dbt Prod CI Regression · duneanalytics bundle

   Designs and runs DuneSQL regression queries comparing CI tables (`dune.<schema>.<table>`) to production spells after pipeline-only dbt changes; after SQL is tailored to the to execute queries and validate parity. Use for prod vs CI regression, lineage parity checks, or row/metric validation when data should not drift; invoke manually per branch—not on every edit.
   0
   installs
8. ▌
   Sim · duneanalytics bundle

   Dune Sim API for real-time blockchain wallet and token lookups across EVM and SVM chains. Use when user asks about wallet balances, token prices, NFT holdings, DeFi positions, transaction history, wallet activity, token holders, stablecoins, or any real-time on-chain data for a specific address. Triggers: 'check wallet', 'token balance', 'NFT holdings', 'DeFi positions', 'transaction history', 'token holders', 'token price', 'stablecoin balance', 'wallet activity', or any request involving a blockchain address (0x... or Solana base58).
   1
   install