Setup & Installation
npx skills add https://github.com/tinybirdco/tinybird-agent-skills --skill tinybird-best-practices
https://github.com/tinybirdco/tinybird-agent-skills/tree/main/skills/tinybird-best-practices
View on GitHubWhat This Skill Does
Encodes Tinybird file format rules, SQL constraints, and optimization patterns for datasources, pipes, endpoints, materialized views, and deduplication. Covers the full resource lifecycle from local development to cloud deployment.
Tinybird has its own templating syntax, strict SELECT-only SQL rules, and file format conventions that aren't in standard SQL or ClickHouse docs, so having the rules inline prevents constant context-switching to documentation.
When to use it
- Writing .datasource and .pipe files that match Tinybird format requirements
- Optimizing SQL queries by filtering early and selecting only needed columns
- Setting up AggregatingMergeTree targets for materialized view pipelines
- Configuring copy pipes and sink files without manual spec lookup
- Applying deduplication patterns to avoid duplicate rows in high-volume ingestion