// the find
messari/subgraphs
Standardized subgraphs for blockchain data
A collection of standardized subgraphs for major DeFi protocols (Aave, Uniswap, Curve, MakerDAO, etc.) built on The Graph, defining shared schemas across protocol types like DEX, lending, yield aggregators, bridges, and perpetuals. Aimed at analysts and data teams who want normalized on-chain metrics without writing their own indexers from scratch. Messari used these internally to power their Protocol Explorer product.
The shared schema design is the real value — having a single GraphQL interface for all lending protocols means you can query Aave and Compound with the same code. The docs are genuinely good: separate files for methodology, oracle price handling, performance, and error patterns, not just a wall-of-text README. The price oracle abstraction (`/abis/Prices/`) handles the ugly reality of getting token prices on-chain across multiple chains without each subgraph reinventing it. 246 forks signals real adoption — people are building on top of this, not just starring it.
Last push was March 2025 and the broader DeFi subgraph ecosystem has been fairly static, so coverage of newer protocols (post-2023) is spotty or missing entirely. The Graph's AssemblyScript runtime is the underlying constraint here — debugging indexing failures is painful, and the toolchain hasn't improved much. The deployment.json file as source-of-truth for deployment status is a fragile pattern; it's easy for it to drift from reality when subgraphs fail silently. The Python Streamlit apps in /apps look like one-off analytics experiments that nobody maintains alongside the main schemas.