tinybird

SKILL.md

Tinybird configuration rules, SQL patterns, and optimization guidance for datasources, pipes, endpoints, and materialized views.

Covers 13 rule categories including project structure, datasource and pipe design, endpoint schemas, materialized views, copy pipes, connections, SQL best practices, and deduplication patterns

Emphasizes local files as source of truth, MergeTree as default table engine, and SELECT-only SQL with strict parameter handling

Provides optimization strategies: filter early, select only needed columns, and defer complex work downstream in the pipeline

Includes guidance on build targets, deployment workflows, and testing patterns for Tinybird Cloud projects

Tinybird Best Practices

Guidance for Tinybird file formats, SQL rules, optimization patterns, and data modeling. Use this skill when creating or editing Tinybird datafiles.

When to Apply

Creating or updating Tinybird resources (.datasource, .pipe, .connection)

Writing or optimizing SQL queries

Designing endpoint schemas and data models

Organizing project structure and data layers

Working with materialized views or copy pipes

Implementing deduplication patterns

Reviewing or refactoring Tinybird project files

Rule Files