skills.rest
goldsky-io
goldsky-ioOFFICIAL
Explore all skills by this author →
Website𝕏@goldskyioGitHub

turbo-transforms

Decode blockchain logs with SQL and TypeScript transforms.

8|Updated Feb 26, 2026
Search Tags:#typescript#sql#blockchain#etl#transform#logs-decoding#dynamic-tables
One-click install
npx skills add https://github.com/goldsky-io/goldsky-agent --skill turbo-transforms
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: turbo-transforms
Source: https://github.com/goldsky-io/goldsky-agent/tree/main/skills/turbo-transforms
Command: npx skills add https://github.com/goldsky-io/goldsky-agent --skill turbo-transforms

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Turbo transforms simplify building data pipelines for blockchain analytics by allowing you to express transformations in SQL and TypeScript, handling decoding, type casting, and lookups in a deterministic, testable way.

Core Features & Use Cases

  • SQL-based transforms for log decoding: decode raw logs using _gs_log_decode and project fields for downstream sinks.
  • TypeScript/WASM script transforms: for custom logic, enrichment, or stateful processing beyond SQL.
  • Dynamic tables and lookups: perform dynamic join-like lookups without streaming joins, enabling flexible reference data.
  • Chaining, UNION ALL, and multi-event pipelines: compose steps and combine outputs into a single stream for sinks.
  • Real-world scenario: decode ERC-20 Transfer events and enrich with metadata before writing to a database.

Quick Start

Create a new turbo-transforms workflow by decoding raw logs with _gs_log_decode in a SQL transform and then chain downstream transforms to a sink.

Frequently Asked Questions about turbo-transforms

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

FAQPage Schema
How do I decode raw blockchain logs into structured data using SQL?▼

You can decode raw blockchain logs using SQL transforms with the _gs_log_decode function, which casts types and projects fields for downstream sinks to reconstruct events like ERC-20 transfers.

Can I use TypeScript to transform blockchain event data beyond what SQL supports?▼

Yes, TypeScript/WASM script transforms allow custom logic, enrichment, or stateful processing for blockchain event data beyond SQL capabilities.

What is the best way to chain multiple blockchain data transforms into a single output?▼

The best way to chain multiple blockchain data transforms is by composing steps and combining outputs using UNION ALL to merge multi-event pipelines into a single stream for sinks.

Does this approach support lookups for blockchain metadata without streaming joins?▼

Yes, dynamic tables perform dynamic join-like lookups for blockchain metadata without streaming joins, enabling flexible reference data enrichment.

Can I reconstruct Solana instructions alongside ERC-20 transfers in the same pipeline?▼

Yes, you can reconstruct Solana instructions and ERC-20 transfer events in the same pipeline by applying multi-chain datasets and chaining multiple transforms into a single output.

Related Skills

Explore More Data & Analytics Skills→
cyoteecyotee

Voltaire Effect Streaming

Stream blockchain block and event data with reorg detection via Effect pipelines.

Community
Advanced
simplefarmer69simplefarmer69
2

ac-oracle-dune-335

Stream Ethereum on-chain blockchain events through the Dune analytics platform.

Community
Intermediate
Akhan521Akhan521
1

query-writing

Convert natural-language questions into validated, read-only SQL queries and execute them.

Community
Intermediate
NEAR-DevHubNEAR-DevHub
8

turbo-transforms

Write and debug SQL transforms for Turbo data pipelines.

Official
Advanced