Learn

Blockchain data infrastructure, explained

Guides to blockchain indexers, onchain data APIs, and the infrastructure underneath them. Written by the SQD team.

⌘K
Data access·8 min read

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.

Data access·9 min read

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.

Data access·9 min read

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.

Data access·9 min read

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.

Data access·9 min read

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.

Data access·10 min read

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.

Data access·9 min read

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.

Data access·10 min read

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.

Data access·9 min read

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.

Data access·10 min read

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.

Architecture·11 min read

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.

Concepts·9 min read

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.

Watch

Videos and podcasts

Talks, interviews, and podcast episodes from the team building SQD.

Browse videos

More guides land every few weeks. For step-by-step tutorials, browse the documentation. For news and case studies, see the blog.