# lending-analysis

> Claude/Codex skill by [@allium-labs](https://omgskills.com/library/allium-labs/index.md) · 0 stars · Updated 2026-10-23

Methodology playbook for analyzing DeFi lending protocol data on Allium — Aave, Morpho, Fluid, Euler, Maple, Compound-style forks, and per-chain lending markets. Use whenever a question touches deposits, borrows, liquidations, collateral swaps, utilization, TVL, or leverage on a lending protocol — even if the user just names a protocol/asset or asks to compare two lending metrics tables. Covers the table-per-event-type join gotchas, column-naming inconsistencies, and liquidation-fill double-counting that come up repeatedly before you write the SQL.

## Install

```sh
git clone https://github.com/allium-labs/allium-claude-plugin /tmp/allium-claude-plugin && ln -s /tmp/allium-claude-plugin/skills/lending-analysis ~/.claude/skills/lending-analysis
```

## From README

Lending Analysis Lending schemas split activity across several event-type tables (deposits/withdrawals/loans/repayments/liquidations) rather than one unified "lending event" table. Most mistakes come from querying only one of them, or joining them wrong. Coverage is broader than Aave, and uneven across event types Lending tables typically cover many protocols and forks beyond the obvious flagship (Aave) — Morpho Blue, Fluid, Euler, Maple, and a long tail of forks. Don't scope a query to "Aave only" by default; check what's actually in scope first. Coverage isn't uniform across event types, either — a narrower table like flashloans may only support a subset of protocols (e.g. just the ones with native flash-loan functions) even when the broader deposits/loans tables cover many more. If you're joining flash-loan data to general lending activity, you've implicitly narrowed your protocol scope to whatever flashloans supports — say so.

## Links

- HTML page: https://omgskills.com/library/allium-labs/allium-claude-plugin/skills/lending-analysis/
- GitHub: https://github.com/allium-labs/allium-claude-plugin
- Author: [@allium-labs](https://omgskills.com/library/allium-labs/index.md)

## More from this repo

- [allium-investigation](https://omgskills.com/library/allium-labs/allium-claude-plugin/skills/allium-investigation/index.md) — Investigate an onchain entity, protocol, market, or wallet question with Allium.
   - [@allium-labs](https://omgskills.com/library/allium-labs/index.md) · 0 stars
- [bridge-analysis](https://omgskills.com/library/allium-labs/allium-claude-plugin/skills/bridge-analysis/index.md) — Methodology playbook for analyzing cross-chain bridge and messaging-protocol data on Allium — CCTP, LayerZero,...
   - [@allium-labs](https://omgskills.com/library/allium-labs/index.md) · 0 stars
- [dashboard-design](https://omgskills.com/library/allium-labs/allium-claude-plugin/skills/dashboard-design/index.md) — Used to build and update Allium Explorer dashboards with set\_dashboard.
   - [@allium-labs](https://omgskills.com/library/allium-labs/index.md) · 0 stars