Substreams Skills

Agent Skills for Substreams development - open-source expertise packages for AI assistants.

What is this?

This is a Claude Code Plugin that provides AI assistants with expert knowledge about Substreams - a high-performance blockchain data indexing and transformation technology.

When installed, Claude gains deep expertise in:

• Building Substreams projects with substreams.yaml manifests
• Writing Rust modules (map, store, index types)
• Creating protobuf schemas for blockchain data
• Performance optimization and debugging

Available Skills

✅ Substreams Development (substreams-dev)

Cross-cutting Substreams development for any chain:

• Creating and configuring substreams.yaml manifests
• Module graphs (map, store, index)
• Protobuf schema design and code generation
• Performance optimization and avoiding excessive cloning
• Debugging and skill routing to chain-specific packs

✅ Substreams Ethereum (substreams-ethereum)

Develop Substreams for Ethereum and other EVM contracts:

• ABI codegen (build.rs) and event decoding (match_and_decode)
• Raw topic0 / no-ABI decoding
• eth_call / RpcBatch and token-metadata stores
• Uniswap-style pool indexing patterns

✅ Substreams Solana (substreams-solana)

Develop Substreams for Solana programs:

• walk_instructions() (CPI-safe) vs top-level-only pitfalls
• Program filters with b58!, SPL Token, Anchor discriminators
• Instruction data + account layout parsing with or without IDL

✅ Substreams SQL (substreams-sql)

Expert knowledge for building SQL database sinks from Substreams data. Covers both mapping modes:

• Database Changes (CDC) — row-level INSERT/UPDATE/UPSERT/DELETE + delta aggregations (PostgreSQL)
• From proto definition — proto annotations → generated tables, insert-only (PostgreSQL and ClickHouse)
• Choosing — mutable state and delta ops need PostgreSQL + Database Changes; everything else is from-proto
• ClickHouse — from-proto DDL, single-PK rule, ORDER BY prefix, cursor-on-disk, analytics MVs
• Schema design — primary keys, injected columns, and schema evolution against a live sink

✅ Substreams Sink (substreams-sink)

Expert knowledge for consuming Substreams data in custom applications. Use when integrating Substreams outputs directly into Go, JavaScript, Python, or Rust code:

• Go sink — cursor management, reorg handling, gRPC streaming
• JavaScript sink — Node.js integration and event handling
• Python / Rust — SDK usage and production patterns

✅ Substreams Sink Deployment — Self-Managed (substreams-sink-deploy-local)

Expert operational guide for running Substreams sink binaries yourself (on your own machine, server, or container). Covers:

• Sink selection — decision tree for SQL, Files, PubSub, Webhook, ProtoJSON, Subgraph
• SQL sink — DSN formats, schema setup, cursor management, reorg handling (Postgres + ClickHouse)