The SQL API is a zero-infrastructure indexing solution that allows any developer to pull real-time and historical onchain data on Base using custom SQL queries. Unlike Wallet History API which provides fixed endpoints for wallet data, SQL API gives you complete flexibility to query any blockchain data.Developers can access our SQL API through either the CDP SDK or CDP’s REST endpoints.
Payment Service Providers: Track real-time stablecoin transactions for merchants, consumers, and marketplaces.
Portfolio & Treasury: Give users and institutions a live view of wallet balances and historical flows. Build dashboards that update instantly as funds move across chains, protocols, and counterparties.
Onchain Games: Track player inventory, asset upgrades, and progression in real time as NFT metadata evolves. Enable game mechanics that reflect actual onchain state — not stale snapshots.
Onchain Social: Monitor user interactions like tips, follows, and reactions across decentralized social graphs. Surface meaningful engagement and value transfer between users, apps, and agents.
Join #onchain-data in the CDP Discord to access FAQs, schedule project discussions, and connect with other developers. We welcome your feedback and suggestions for improvement.