Profile My skills Saved Collections Edit profile Submit a skill

← all publishers

subsquid-labs

@subsquid-labs source repo

5 published skills

  1. ▌
    Bigquery Blockchain Datasets · subsquid-labs bundle
    Query the BigQuery public blockchain datasets — Ethereum, Polygon, Arbitrum, Optimism, Avalanche, Cronos and TRON (goog_blockchain_*_us), plus crypto_ethereum and crypto_bitcoin — with correct SQL at controlled cost. Use before writing any SQL against bigquery-public-data blockchain tables, when the user names one of these datasets, or for on-chain analytics on these chains: blocks, transactions, logs and events, traces and internal transactions, token transfers and holders, wallet history, gas fees, ETH balances, contracts, NFT activity, USDT on TRON, Bitcoin UTXOs. Not for private BigQuery datasets, Dune/Flipside SQL, or other bigquery-public-data crypto_* datasets (Solana, Litecoin, …).
    0
    installs
  2. ▌
    Portal · subsquid-labs bundle
    Query blockchain data across 130+ networks with SQD Portal, including EVM, Solana, Substrate, Bitcoin, Tron, and Hyperliquid, and choose the right execution path: Portal MCP for bounded answers, Portal Stream API/curl for raw exports, or Pipes/Squid for durable pipelines.
    0
    installs
  3. ▌
    Pipes Sdk · subsquid-labs bundle
    Build, configure, deploy, and troubleshoot durable blockchain indexers with the Subsquid Pipes SDK (EVM, Solana, Tron, Bitcoin, Hyperliquid) when Portal MCP or curl previews are insufficient for backfills, recurring syncs, joins, app-owned data, or production analytics.
    0
    installs
  4. ▌
    Squid Perf · subsquid-labs bundle
    Compare sync-time performance across one or more Squid SDK deployments. Fetches logs via sqd CLI, parses per-service progress, and generates a self-contained HTML report plus a Markdown summary with wall-clock/active-time/downtime breakdowns at percentage-based block breakpoints. Supports single-indexer mode (metrics only, no comparison). Use when the user invokes "/squid-perf", asks to compare Squid deployment sync times, or references squid performance profiling.
    0
    installs
  5. ▌
    Migrate To Portal · subsquid-labs bundle
    Migrate an existing Squid SDK indexer (EVM or Solana) off the v2 gateway and onto the Portal data source. Covers the package swap (`@subsquid/evm-processor` → `@subsquid/evm-stream` + `@subsquid/evm-objects` + `@subsquid/batch-processor` for EVM; `@subsquid/solana-stream@^0.x` → `^1.x` for Solana), the API/type shape changes, and field-selection changes. Use when the user mentions migrating, porting, upgrading, or converting a v2 squid to Portal; references `v2.archive.subsquid.io`, `setGateway`, `setDataSource`, `lookupArchive`, or `SolanaRpcClient`; or hits TS errors on `EvmBatchProcessor`, `evmLog`, or `block.header.slot` after a `@subsquid/*` bump.
    0
    installs