Pipes SDK

One skill for the full Pipes SDK lifecycle: scaffold new indexers, diagnose runtime errors, optimize sync performance, and validate data quality.

When to Use This Skill

Activate when the user wants to:

• Create a new indexer — scaffold EVM, Solana, or Hyperliquid projects
• Fix runtime errors — compilation failures, DB issues, Portal timeouts, decoding errors
• Optimize sync performance — slow indexing, high memory, large ranges
• Validate data quality — NULL checks, gaps, malformed addresses, duplicate events
• Deploy an indexer — local Docker or ClickHouse Cloud

Common trigger phrases: "create a new indexer", "my indexer crashed", "error", "not working", "slow", "optimize", "deploy to ClickHouse Cloud", "track X events on Ethereum/Solana/Hyperliquid".

Critical Environment Constraints

Node.js: LTS only (v20 or v22). v25.x has zstd decompression bugs that crash during large Portal streams. See ENVIRONMENT_SETUP.md.