Skills
.Work. You
Rest

substreams-sql

Official

Master SQL sinks for Substreams data.

Data & Analytics#analytics#postgresql#sql#clickhouse#cdc#materialized-views#substreams
Authorpinax-network
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Substreams produce complex data streams that must be stored in SQL databases for operational and analytical use. This Skill provides expert guidance for building SQL sinks with CDC, relational mappings, and materialized views for PostgreSQL, ClickHouse, and similar targets.

Core Features & Use Cases

  • CDC-driven data ingestion: stream row-level changes from blockchain events into SQL tables with transactional semantics.
  • Relational design & analytics: choose normalized or denormalized schemas to support joins, reporting, and dashboards.
  • Real-time analytics & materialized views: define pre-aggregated views to accelerate dashboards and queries.
  • Use Case Example: implement a real-time token transfer ledger in PostgreSQL and a token analytics store in ClickHouse.

Quick Start

Install and configure substreams-sink-sql in a project, define a manifest with a DSN for your database, run the setup to initialize the schema, and execute the sink to start streaming data into your SQL store.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: substreams-sql
Download link: https://github.com/pinax-network/substreams-solana/archive/main.zip#substreams-sql

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.