# A Hands-On Guide to Building Streaming Transformation with Estuary Derivation Agent Skills

DevFeed: [A Hands-On Guide to Building Streaming Transformation with Estuary Derivation Agent Skills](<https://devfeed.tech/articles/a-hands-on-guide-to-building-streaming-transformation-with-estuary-derivation-agent-skills-82103.md>)

Original publisher: [Read original article](<https://estuary.dev/blog/estuary-agent-skills-streaming-data-transformations>)

Author: Ruhee Shrestha

Published: 2026-08-20T13:51:25Z

Content type: tutorial

Language: en

Sources: [Estuary](<https://devfeed.tech/sources/estuary.md>)

Topics: [Agent Skills](<https://devfeed.tech/topics/agent-skills.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Streaming](<https://devfeed.tech/topics/streaming.md>), [Event-Streaming](<https://devfeed.tech/topics/event-streaming.md>), [Loop Engineering](<https://devfeed.tech/topics/loop-engineering.md>), [Snowflake streaming data architecture](<https://devfeed.tech/topics/snowflake-streaming-data-architecture.md>)

Tags: [agent-skills](<https://devfeed.tech/tags/agent-skills.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agent](<https://devfeed.tech/tags/ai-agent.md>), [ai-assistant](<https://devfeed.tech/tags/ai-assistant.md>), [ai-assistants](<https://devfeed.tech/tags/ai-assistants.md>), [ai-coding-assistant](<https://devfeed.tech/tags/ai-coding-assistant.md>), [ai-coding-assistants](<https://devfeed.tech/tags/ai-coding-assistants.md>), [ai-development](<https://devfeed.tech/tags/ai-development.md>), [ai-powered](<https://devfeed.tech/tags/ai-powered.md>), [build](<https://devfeed.tech/tags/build.md>), [building](<https://devfeed.tech/tags/building.md>), [data](<https://devfeed.tech/tags/data.md>), [estuary](<https://devfeed.tech/tags/estuary.md>), [guide](<https://devfeed.tech/tags/guide.md>), [natural-language](<https://devfeed.tech/tags/natural-language.md>), [published](<https://devfeed.tech/tags/published.md>), [python](<https://devfeed.tech/tags/python.md>), [skills](<https://devfeed.tech/tags/skills.md>), [streaming](<https://devfeed.tech/tags/streaming.md>), [streaming-data](<https://devfeed.tech/tags/streaming-data.md>), [using](<https://devfeed.tech/tags/using.md>)

## AI overview

This tutorial demonstrates Estuary Derivation Agent Skills for building streaming data transformations from natural-language prompts. Using a PostgreSQL banking dataset, it walks through filtering, aggregation, stateful metrics, joins, array flattening, rolling windows, and Python-based merchant classification before materializing results in ClickHouse. It also highlights production concerns such as reviewing generated logic and schemas, handling updates in CDC streams, bounding state, and checking multi-shard behavior.

## Source excerpt

Build streaming data transformations with Estuary Agent Skills using natural-language prompts, from filtering and joins to stateful logic, windowing, and Python.