DeFi Builder Queries 90 Lending Protocols With One GraphQL Query

Peter Zhang Apr 21, 2026 16:43

PaulieB leverages standardized subgraphs and AI-driven MCP tech to query 90 DeFi protocols across 15 chains, simplifying DeFi data analysis.

DeFi Builder Queries 90 Lending Protocols With One GraphQL Query

DeFi data fragmentation has long been a headache for developers, but a recent breakthrough by community builder PaulieB may signal a turning point. Using standardized subgraphs from Messari and The Graph’s decentralized network, PaulieB developed an open-source server capable of querying 90 DeFi lending protocols across 15 chains with a single GraphQL query—no custom adapters, no manual coding. The implications for developers and traders alike are significant.

A Persistent Problem in DeFi

DeFi protocols speak different "languages." Aave refers to its markets as reserves, Compound calls them markets, and MakerDAO uses vaults. Developers historically had to write custom adapters for each protocol to aggregate data, a tedious process that made cross-protocol comparisons rare. While the data was always on-chain, accessing it in a consistent format wasn’t practical.

Messari, a key contributor to DeFi analytics, tackled this issue with standardized subgraphs. Backed by a $12.5 million grant from The Graph Foundation in 2022, Messari created unified schemas for lending, DEXs, and other DeFi categories. For lending protocols, this means entities like LendingProtocol (holding TVL, revenue, and user counts) now share the same structure across platforms. This standardization paved the way for tools like PaulieB’s Model Context Protocol (MCP) server.

How It Works

The graph-lending-mcp server, built by PaulieB, takes advantage of these standardized subgraphs. By firing a single GraphQL query to all supported subgraphs, the MCP server pulls live data from protocols like Aave, Compound, MakerDAO, and Venus. For users, it’s as simple as asking an AI assistant to compare USDC borrow rates across the market. The system returns side-by-side results in plain English, eliminating the need for manual data parsing or technical expertise.

The tool supports 65 live subgraph deployments at any time and covers the full lifecycle of DeFi lending. Users can query interest rates, retrieve liquidation data, compare protocols by TVL, and more. It even includes an escape hatch for raw GraphQL queries if the pre-built tools don’t cover a specific need.

The Implications

For traders, this consolidation of data could streamline decision-making. Comparing interest rates or tracking liquidation opportunities across multiple protocols is now instantaneous. Developers benefit even more. With the infrastructure already in place, they can spend less time wrangling data and more time building applications.

PaulieB’s work also highlights the growing role of AI in DeFi. By integrating The Graph’s deterministic data layer with AI-friendly tools like MCP, the system demonstrates how blockchain data can become more accessible for automated decision-making. This could accelerate the adoption of autonomous trading strategies and liquidity optimization tools.

Subgraphs vs. Substreams: Choosing the Right Tool

The Graph’s infrastructure offers two distinct products: Subgraphs and Substreams. Subgraphs, as used by PaulieB’s project, are ideal for querying pre-indexed data. They require no infrastructure setup and deliver structured, reliable outputs—perfect for AI agents working with existing data.

Substreams, on the other hand, cater to larger-scale operations requiring custom pipelines. Projects like Theoriq use Substreams to process real-time data for liquidity management, showcasing how platforms can build on The Graph to power AI-driven operations at scale.

What’s Next?

The graph-lending-mcp server is open source and available on npm, allowing anyone with a free API key from The Graph’s Subgraph Studio to start querying DeFi lending data immediately. Developers can extend its functionality or replicate the approach for other DeFi categories like DEXs or governance.

Messari’s standardized subgraphs have already transformed how DeFi data is structured and accessed. With tools like PaulieB’s MCP server, the next wave of innovation could focus on making that data actionable for both humans and machines. The infrastructure is live; now it’s up to builders to leverage it.

Image source: Shutterstock