Learn
Blockchain data infrastructure, explained
Guides to blockchain indexers, onchain data APIs, and the infrastructure underneath them. Written by the SQD team.
Connect Claude or Cursor to onchain data: the Portal MCP server
Wire the keyless SQD Portal MCP server into Claude Code, Cursor, or VS Code, then run three real onchain queries and read the rows back.
One query shape, every VM: declarative cross-chain data
The same JSON-shaped request reads EVM logs, Solana instructions, and Bitcoin inputs and outputs, with no schema, no deploy, and no sync wait.
Hyperliquid data for agents: perp analytics through one tool family
An agent answers whole-market Hyperliquid perp questions through the same analytics, OHLC, and query tools it uses for every other chain.
Following Bitcoin money through UTXOs: one declarative query
Bitcoin inputs and outputs are first-class in the same declarative query shape, so you trace UTXO flows from sender to recipient without running a node.
Decoding Solana program activity declaratively, including the calls that failed
One declarative query reads Solana program activity by program ID and discriminator, and surfaces the failed and uncommitted calls most tools drop.
An AI-assisted onchain investigation: from an address to a fund-flow path
How an agent triages a wallet, follows the trace, and cites block-level evidence at each hop, with an investigation envelope that names the next step.
RWA monitoring agents: tracking tokenized-asset events across chains
Permissioned tokens emit compliance events a stablecoin never does. Monitor freezes, pauses, and recoveries across every chain an asset lives on.
Stablecoin data: tracking cross-chain flows and peg health
Following stablecoin transfers across every chain they live on with one query model, aligning windows across chains by timestamp, and reading peg health from DEX trades.
Hyperliquid perps data: fills, positions, and realized PnL
The Hyperliquid fills dataset: what a fill record holds, maker and taker fees, realized PnL from closing trades, and how to separate crypto markets from the TradFi and HIP-3 listings on the same venue.
Internal transactions explained: traces and the cost of getting them
What an internal transaction is, why event logs and the transaction list miss it, what a trace record contains, and why traces are one of the most expensive things to pull from an RPC node.
Build a Hyperliquid trader leaderboard with the Pipes SDK
A worked Pipes SDK example: stream the full Hyperliquid fills tape into your own ClickHouse, rank traders by realized PnL, and split volume into crypto versus TradFi markets.
What is onchain analytics?
How blockchain history feeds analytics dashboards. The data pipeline, the common metrics, and how this is done in tools like Dune and in-house BI.
Videos and podcasts
Talks, interviews, and podcast episodes from the team building SQD.
More guides land every few weeks. For step-by-step tutorials, browse the documentation. For news and case studies, see the blog.