tinybird

Tinybird configuration rules, SQL patterns, and optimization guidance for datasources, pipes, endpoints, and materialized views. Guidance for Tinybird file formats, SQL rules, optimization patterns, and data modeling. Use this skill when creating or editing Tinybird datafiles. - 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 - 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/build-deploy.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 -...