uho-indexing

Index Solana program events from an Anchor IDL into PostgreSQL schemas with REST and WebSocket APIs.

Updated Feb 9, 2026
One-click install
npx skills add https://github.com/zhivkoto/uho-indexing --skill uho-indexing
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: uho-indexing
Source: https://github.com/zhivkoto/uho-indexing/tree/main
Command: npx skills add https://github.com/zhivkoto/uho-indexing --skill uho-indexing

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Uho automates the end-to-end process of indexing Solana program events by consuming an Anchor IDL, generating per-program PostgreSQL schemas, and serving a typed REST API plus WebSocket streams. It eliminates the need to handcraft decoders, schemas, or integration glue, enabling rapid onboarding of new programs.

Core Features & Use Cases

  • IDL-driven schema generation: converts an Anchor IDL into per-program database tables and state tracking.
  • Auto-generated REST API + WebSocket streams: provides typed, filterable endpoints and real-time event delivery.
  • Multi-tenant data isolation: each user gets a separate PostgreSQL schema and isolated endpoints.
  • Rapid onboarding: deploy a new program and start querying events within minutes.

Example: Onboard a new Solana program by uploading its IDL and immediately start querying events via REST and subscribing to live data via WebSocket.

Quick Start

Register your account, upload an IDL, and start indexing to expose your typed API.

Frequently Asked Questions about uho-indexing

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I index Solana program events from an Anchor IDL?

To index Solana program events, provide an Anchor IDL to automatically generate typed PostgreSQL schemas, REST endpoints, and WebSocket streams without handcrafting decoders. This automates the end-to-end indexing process for rapid program onboarding.

Can I get real-time WebSocket streams for Solana program data?

Yes, real-time WebSocket streams are automatically generated alongside typed REST API endpoints when you index Solana program events. This provides immediate live event delivery with filtering capabilities and per-user data separation.

Does this Solana indexing solution support multi-tenant data isolation?

Yes, multi-tenant data isolation is supported by assigning each user a separate PostgreSQL schema and isolated endpoints. This ensures per-user data separation when querying indexed Solana program events via the API.

What's the best way to automate database schema generation for Solana IDLs?

The best way to automate database schema generation is using an IDL-driven approach that converts an Anchor IDL into per-program PostgreSQL tables. This eliminates the need to manually create schemas or write integration glue for new programs.

Do I need to write custom decoders to index Solana events?

No, you do not need to write custom decoders to index Solana events. The system provides zero-dependency decoders by parsing the Anchor IDL, automatically handling event decoding and state tracking for the indexed program.

Can I use PostgreSQL for querying indexed Solana blockchain events?

Yes, PostgreSQL is used to store indexed Solana events by automatically generating per-program database tables from the IDL. You can query these events through the auto-generated REST API with multi-tenant isolation.