Tinybird
DevelopmenttinybirdTinybird is an Agent Skill for development published in the MapleTechLabs/maple repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.
Tinybird file formats, SQL rules, optimization patterns, and best practices for datasources, pipes, endpoints, and materialized views.
QUICK START
How to use this skill
Bring this guide into your coding agent with a prompt tailored to the tool you use.
- Open your project in Codex.
- Copy and paste the prompt below.
- Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/MapleTechLabs/maple/blob/HEAD/.agents/skills/tinybird/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/tinybird, but wait for my approval before writing files or running scripts.
Copying this prompt does not install or run the skill. Review third-party files before use.
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.mdrules/pipe-files.mdrules/endpoint-files.mdrules/materialized-files.mdrules/materialized-join-prefilter.mdrules/sink-files.mdrules/copy-files.mdrules/connection-files.mdrules/sql.mdrules/endpoint-optimization.mdrules/tests.mdrules/deduplication-patterns.md
Quick Reference
- Project local files are the source of truth.
- Build target comes from
tinybird.config.jsondev_mode(localorbranch). tb deploytargets Tinybird Cloud production.- Commands like
tb sqlandtb logsdefault to local unless--cloudor--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.