tinybird
Tinybird configuration rules, SQL patterns, and optimization guidance for datasources, pipes, endpoints, and materialized views.
- Covers 13 rule categories including project structure, datasource and pipe design, endpoint schemas, materialized views, copy pipes, connections, SQL best practices, and deduplication patterns
- Emphasizes local files as source of truth, MergeTree as default table engine, and SELECT-only SQL with strict parameter handling
- Provides optimization strategies: filter early, select only needed columns, and defer complex work downstream in the pipeline
- Includes guidance on build targets, deployment workflows, and testing patterns for Tinybird Cloud projects
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.mdrules/build-deploy.mdrules/datasource-files.md
More from tinybirdco/tinybird-agent-skills
tinybird-cli-guidelines
Tinybird CLI commands, workflows, and operations. Use when running tb commands, managing local development, deploying, or working with data operations.
425tinybird-typescript-sdk-guidelines
Tinybird TypeScript SDK for defining datasources, pipes, and queries with full type inference. Use when working with @tinybirdco/sdk, TypeScript Tinybird projects, or type-safe data ingestion and queries.
391tinybird-python-sdk-guidelines
Tinybird Python SDK for defining datasources, pipes, and queries in Python. Use when working with tinybird-sdk, Python Tinybird projects, or data ingestion and queries in Python.
165