SKILL.md
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
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
rules/endpoint-optimization.md
rules/tests.md
rules/deduplication-patterns.md
Quick Reference
- Project local files are the source of truth.
- Build target comes from
tinybird.config.jsondev_mode(localorbranch).
tb deploytargets Tinybird Cloud production.
- Commands like
tb sqlandtb logsdefault to local unless--cloudor--branch=<branch-name>is set.
- 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.