Agent skill · software engineering · tinybirdco

tinybird

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

Why this skill is useful

Provides specific optimization patterns and SQL rules for Tinybird that the AI wouldn't reliably generate on its own.

What it needs

Requires tinybird account access. About 1k tokens when loaded. Last updated 2026-07-29. 20 stars on the source repository.

What this skill does

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 devmode (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.

How to use it

Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:

@skills tinybirdco/tinybird-best-practices

View the source on GitHub

Browse the @skills marketplace