tinybird

★ 19

by tinybirdco · part of tinybirdco/tinybird-agent-skills

Tinybird file formats, SQL rules, optimization patterns, and best practices for datasources, pipes, endpoints, and materialized views.

🔥🔥🔥✓ VerifiedFreeQuick setup

#git

🧩 One of 5 skills in the tinybirdco/tinybird-agent-skills package — works on its own, and pairs well with its siblings.

This is the playbook your agent receives when the skill activates — you don't need to read it to use the skill, but it's here to audit before installing.

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/materialized-join-prefilter.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.json dev_mode (local or branch).
tb deploy targets Tinybird Cloud production.
Commands like tb sql and tb logs default to local unless --cloud or --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.