agentsclimarketplace
Sign in

Skill

Skill srivtx/solana-indexer-skill/skill

Build custom Solana indexers end-to-end. Geyser gRPC plugins, backfill strategies, Postgres schema design, real-time streaming, cost optimization, testing with LiteSVM/Surfpool, and production operations. Use when designing a new indexer, choosing between Geyser/WebSocket/webhooks/polling, designing a schema, planning a backfill, reducing RPC costs, or operating an indexer in production.From its SKILL.md

Install
npx -y skills add srivtx/solana-indexer-skill --skill skill

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

3.8 KB, 853 tokens by cl100k_base, as published. Nobody here has run it

Solana Indexer — Skill Hub

Routes to the right reference based on intent. Read only the section you need; the references are designed for progressive loading.

Quick Routing

IntentRead first
"I need to build an indexer for X"references/indexer-architecture.md — decision tree for the right approach
"Geyser / Yellowstone gRPC / Rust plugin"references/geyser-plugins.md
"Postgres schema for [swaps / NFTs / pools / vaults]"references/postgres-schemas.md
"How do I backfill [N days] of historical data"references/backfill-strategies.md
"Real-time WebSocket / gRPC streaming patterns"references/real-time-streaming.md
"Reduce RPC costs / credit usage"references/cost-optimization.md
"Test my indexer"references/testing-indexers.md
"Run in production — slot lag, alerts, failover"references/production-ops.md
"Where are the official docs"references/resources.md

Examples

See examples/ for runnable code:

  • examples/minimal-indexer-ts/ — 100-line TypeScript indexer using Helius webhooks → Postgres. Runnable against devnet.
  • examples/geyser-plugin/skeleton/ — Rust Geyser plugin skeleton (filter ProgramSubscribe → batched Postgres writes).
  • examples/subgraph-template/ — The Graph subgraph manifest for Solana (compressed subgraph).

When to use this skill

Activate when:

  • User wants to build, modify, debug, or operate a Solana data indexer
  • User asks about Geyser, Yellowstone, account subscriptions, program subscriptions
  • User asks about historical data backfill, slot ranges, replay
  • User asks about RPC cost optimization, polling vs streaming tradeoffs
  • User asks about dApp backend architecture involving on-chain data aggregation
  • User wants to add a new table/schema for tracking Solana protocol state
  • User wants to test indexer logic without hitting mainnet

Do NOT use for:

  • One-off RPC queries (use Helius/QuickNode skills directly)
  • Wallet integration / signing (use ext/solana-dev/frontend-framework-kit)
  • Program development (Anchor/Pinocchio patterns are in ext/solana-dev/programs/)
  • Frontend dashboards that consume indexed data (not the indexer itself)

Routing rules

  • Primary: this skill for all building/operating an indexer questions
  • Composes with: ext/helius (for using Helius APIs inside the indexer), ext/sendai/skills/quicknode (for using QuickNode), ext/cloudflare (for deploying the indexer on Workers)
  • Source precedence: this skill covers Geyser plugin authoring. For consuming Yellowstone gRPC streams (not authoring), defer to ext/sendai/skills/quicknode or ext/helius.

Defaults (2026 stack)

  • Streaming: Yellowstone gRPC (Triton, Helius Laserstream, QuickNode Streams)
  • Polling fallback: Helius enhanced transactions API
  • Storage: Postgres 16, optional TimescaleDB for time-series aggregations
  • Backfill: Snapshot + incremental replay
  • Test: LiteSVM (unit), Surfpool fork (integration)
  • Local validator: Surfpool
  • Migrations: sqlx-cli (Rust) or Drizzle/Knex (TS)
  • Service: Docker + k8s, Prometheus, PagerDuty

What ships with it: 23 files

146.0 KB alongside SKILL.md, 2 of them executable

examples/

references/

Keep looking

Skills are one crate of 326,499. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.