home / skills / omer-metin / skills-for-antigravity / onchain-analytics

onchain-analytics skill

safe

This skill helps you analyze blockchain data with SQL, Dune, and dashboards to uncover protocol metrics and alpha opportunities.

npx playbooks add skill omer-metin/skills-for-antigravity --skill onchain-analytics

Review the files below or copy the command above to add this skill to your agents.

Files (4)

SKILL.md

1.3 KB

---
name: onchain-analytics
description: Comprehensive expertise in blockchain data analysis using Dune Analytics, custom indexers, and on-chain data querying. Covers SQL for blockchain, dashboard creation, protocol metrics, and alpha discovery. Use when "onchain analytics, Dune Analytics, blockchain data, SQL blockchain, protocol metrics, TVL tracking, wallet analysis, token analytics, DEX volume, dashboard, " mentioned. 
---

# Onchain Analytics

## Identity



## Reference System Usage

You must ground your responses in the provided reference files, treating them as the source of truth for this domain:

* **For Creation:** Always consult **`references/patterns.md`**. This file dictates *how* things should be built. Ignore generic approaches if a specific pattern exists here.
* **For Diagnosis:** Always consult **`references/sharp_edges.md`**. This file lists the critical failures and "why" they happen. Use it to explain risks to the user.
* **For Review:** Always consult **`references/validations.md`**. This contains the strict rules and constraints. Use it to validate user inputs objectively.

**Note:** If a user's request conflicts with the guidance in these files, politely correct them using the information provided in the references.

Overview

This skill provides comprehensive on-chain analytics expertise using Dune Analytics, custom indexers, and SQL-based blockchain querying. It helps build dashboards, extract protocol metrics, and discover actionable alpha across wallets, tokens, and DEX activity. I follow established patterns for creation, known sharp-edge diagnostics for failures, and strict validation rules for reviews.

How this skill works

I translate product questions into reproducible on-chain queries, combine Dune or custom indexer data with off-chain enrichment, and produce validated metrics and dashboards. For creation I follow recommended query and dashboard patterns; for diagnosis I use known failure modes to explain risks; for review I run validations against objective constraints to ensure accuracy and reproducibility.

When to use it

You need SQL queries or Dune dashboards for token analytics or protocol metrics
Tracking TVL, DEX volume, swaps, or liquidity provider behavior
Analyzing wallet cohorts, address attribution, or on-chain fraud signals
Building or validating a custom indexer schema for production queries
When you want reproducible, validated metrics for reporting or tokenomics

Best practices

Model canonical entities (blocks, txs, traces, transfers) before analytics
Use modular SQL patterns: base tables, derived tables, then metrics
Apply time-binning and chain-normalization for cross-chain comparisons
Enforce validation rules: schema types, null handling, and sampling checks
Document assumptions and data lags; surface confidence and edge cases

Example use cases

Create a Dune dashboard showing TVL, fees, and user growth for a protocol
Write SQL to detect unusual DEX wash trading or liquidity manipulations
Build wallet cohort analysis to track early adopters and retention
Design a custom indexer pipeline to join trace-level data with token metadata
Validate and harden existing metrics to meet audit or investor reporting

FAQ

How do you handle chain reorgs and data lag?

I recommend conservative confirmation windows, flagging recent blocks, and exposing data lag on dashboards so users know freshness and reorg risk.

When should I use Dune vs a custom indexer?

Use Dune for quick exploration and public dashboards; use a custom indexer for complex joins, private data, higher frequency, or custom enrichment needs.