turbo-transforms

Write and debug SQL transforms for Turbo data pipelines.

8|12|Updated Dec 9, 2025
One-click install
npx skills add https://github.com/NEAR-DevHub/treasury26 --skill turbo-transforms-near-devhub
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: turbo-transforms
Source: https://github.com/NEAR-DevHub/treasury26/tree/main/.agents/skills/turbo-transforms
Command: npx skills add https://github.com/NEAR-DevHub/treasury26 --skill turbo-transforms-near-devhub

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill empowers users to write, understand, and debug complex SQL transformations for data pipelines, enabling efficient data processing and analysis.

Core Features & Use Cases

  • SQL Transform Generation: Create SQL queries for decoding EVM logs, filtering events, casting data types, and chaining multiple data processing steps.
  • Data Transformation Logic: Understand and build logic for combining data using UNION ALL or handling complex data manipulation.
  • Use Case: You need to decode raw Ethereum logs for ERC-20 Transfer events, extract sender, receiver, and amount, and then combine them with Approval events into a single unified stream for analysis.

Quick Start

Use the turbo-transforms skill to write a SQL query that decodes raw EVM logs for ERC-20 Transfer events.

Frequently Asked Questions about turbo-transforms

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

FAQPage Schema
How do I write SQL transforms to decode EVM logs for ERC-20 Transfer events?

To write SQL transforms for EVM logs, use Goldsky SQL functions to decode raw Ethereum logs, extract event parameters like sender and receiver, and filter specific events for pipeline processing.

Can I combine multiple events like Transfer and Approval into a single data stream using SQL?

Yes, you can combine multiple events into a single data stream by using the UNION ALL operator within your SQL transform to merge decoded Transfer and Approval event data for unified analysis.

What is the best way to debug complex data transformation logic in a data pipeline?

The best way to debug data transformation logic is to break down complex SQL queries into chained transforms, verifying data type casting and event filtering steps individually before combining outputs.

How do I chain multiple SQL transforms together in a Turbo data pipeline?

You can chain multiple SQL transforms together by structuring your data pipeline logic sequentially, allowing the output of one data manipulation step to serve as the input for the next filtering or casting operation.

Does this approach support standard SQL functions alongside Goldsky SQL for data pipelines?

Yes, this approach supports advanced data processing logic by allowing you to combine standard SQL functions with specialized Goldsky SQL functions to manipulate and cast types within Turbo data pipelines.

Why do I need to cast data types when decoding raw Ethereum logs?

You need to cast data types when decoding raw Ethereum logs to ensure extracted EVM event parameters, such as amounts and addresses, are properly formatted for downstream data transformation and analysis.