SKILL.md

Analyzing On-Chain Data

Overview

Analyze DeFi protocol metrics, chain-level TVL, fee revenue, DEX volumes, yield opportunities, and stablecoin market caps using DeFiLlama as the primary data source. Designed for DeFi researchers, protocol analysts, and yield farmers who need programmatic access to on-chain analytics without writing custom subgraph queries.

Prerequisites

Python 3.8+ with requests library installed
DeFiLlama API access (free, no key required for most endpoints)
Optional: CoinGecko API key for supplementary token price data
onchain_analytics.py CLI script available in the plugin directory
data_fetcher.py and metrics_calculator.py modules for programmatic usage

Instructions

Run python onchain_analytics.py protocols to retrieve the top DeFi protocols ranked by total value locked (TVL).
Filter protocol results by category using --category lending, --category dex, or --category "liquid staking" to narrow the scope.
Filter by chain with --chain ethereum or --chain arbitrum to isolate chain-specific protocol data.
Sort results by alternative metrics using --sort market_share or --sort tvl_to_mcap to surface undervalued protocols.
Run python onchain_analytics.py chains to retrieve chain-level TVL rankings across all tracked networks.
Run python onchain_analytics.py fees --protocol aave to pull fee and revenue data for a specific protocol.
Run python onchain_analytics.py dex --chain ethereum to analyze DEX trading volumes filtered by chain.
Run python onchain_analytics.py yields --min-tvl 5000000 --chain ethereum to identify yield opportunities above a minimum TVL threshold.
Run python onchain_analytics.py trends --threshold 5 to detect protocols with significant TVL changes (threshold is percentage).

Error	Cause	Solution
`Request timeout`	DeFiLlama API slow or unreachable	Wait and retry; check for outages; use cached data if available
`Protocol not found: invalid-name`	Protocol slug does not match DeFiLlama database	Run `python onchain_analytics.py protocols` to find the exact slug; slugs are case-sensitive
`No data returned for query`	Filter too restrictive or data unavailable	Remove filters and retry; verify the category or chain exists; try a broader time range
`TVL data unavailable for some protocols`	New protocols or data collection gaps	Check DeFiLlama directly; data typically appears within 24 hours of listing
`Data may be stale (last updated: X hours ago)`	Local cache not refreshed	Clear cache with `rm ~/.onchain_analytics_cache.json`; use `--verbose` to check cache status
`Showing top 50 of 1000+ protocols`	Output truncated for readability	Use `--limit` to increase count or `--format json` for full untruncated data
`UnicodeEncodeError`	Terminal encoding mismatch	Use `--format json` for safe output or set `LANG=en_US.UTF-8`

analyzing-on-chain-data

Summary

SKILL.md

Analyzing On-Chain Data

Overview

Prerequisites

Instructions

Output

Error Handling

Examples

Daily DeFi Overview

Research a Lending Protocol

Find High-TVL Yield Opportunities on Ethereum

Resources

Related skills