Tinybird Agent Skills

1---
2name: tinybird
3description: Tinybird file formats, SQL rules, optimization patterns, and best practices for datasources, pipes, endpoints, and materialized views.
4---
5 
6# Tinybird Best Practices
7 
8Guidance for Tinybird file formats, SQL rules, optimization patterns, and data modeling. Use this skill when creating or editing Tinybird datafiles.
9 
10## When to Apply
11 
12- Creating or updating Tinybird resources (.datasource, .pipe, .connection)
13- Writing or optimizing SQL queries
14- Designing endpoint schemas and data models
15- Working with materialized views or copy pipes
16- Implementing deduplication patterns
17- Reviewing or refactoring Tinybird project files
18 
19## Rule Files
20 
21- `rules/project-files.md`
22- `rules/datasource-files.md`
23- `rules/pipe-files.md`
24- `rules/endpoint-files.md`
25- `rules/materialized-files.md`
26- `rules/sink-files.md`
27- `rules/copy-files.md`
28- `rules/connection-files.md`
29- `rules/sql.md`
30- `rules/endpoint-optimization.md`
31- `rules/tests.md`
32- `rules/deduplication-patterns.md`
33 
34## Quick Reference
35 
36- Project local files are the source of truth.
37- SQL is SELECT-only with Tinybird templating rules and strict parameter handling.
38- Use MergeTree by default; AggregatingMergeTree for materialized targets.
39- Filter early, select only needed columns, push complex work later in the pipeline.
40