tinybird

Guidance for Tinybird file formats, SQL rules, optimization patterns, and data modeling. Use this skill when creating or editing Tinybird datafiles. - Creating or updating Tinybird resources (.datasource, .pipe, .connection) - Writing or optimizing SQL queries - Designing endpoint schemas and data models - Working with materialized views or copy pipes - Implementing deduplication patterns - Reviewing or refactoring Tinybird project files - rules/project-files.md - rules/datasource-files.md - rules/pipe-files.md - rules/endpoint-files.md - rules/materialized-files.md - rules/sink-files.md - rules/copy-files.md - rules/connection-files.md - rules/sql.md - rules/endpoint-optimization.md - rules/tests.md - rules/deduplication-patterns.md - Project local files are the source of truth. - SQL is SELECT-only with Tinybird templating rules and strict parameter handling. - Use MergeTree by default; AggregatingMergeTree for materialized targets. - Filter early, select only needed columns, push complex work later in the pipeline.