Tinybird Agent Skills

Official Tinybird skills: datafile and SQL rules, the tb CLI, and the TypeScript and Python SDKs

SkillLow risk

tinybirdco/tinybird-agent-skills

Install

npx skills add tinybirdco/tinybird-agent-skills

Update with npx skills update

This is third-party code. Review the repository files before installing.

What it does

Four skills teach the agent to work correctly with Tinybird projects. The best practices skill holds rules for .datasource, .pipe and .connection files, SQL, endpoints, materialized views, deployment and tests. The CLI skill covers tb commands for local development, deploys and data operations. Two SDK skills explain typed datasource and pipe definitions in TypeScript and Python and migration from legacy datafiles.

Who it is for. For developers and data engineers building analytics APIs on Tinybird.

Good fit when

  • The agent creates or edits Tinybird datasources, pipes and endpoints
  • You need to optimize an endpoint for latency
  • The project is migrating from legacy datafiles to the SDK

Not a fit when

  • The project does not use Tinybird
  • You need the agent to access data directly rather than rules

Example request

Create a datasource for user events and an endpoint with top pages per day

Limitations

The skills are instructions only; Tinybird itself is a cloud service that needs an account. Availability of Tinybird Cloud from Russia is unverified.

How to disable. Delete the tinybird-* skill folders from the agent's skills directory.

Security check

  • The skills consist only of instructions and rules

README in short

The README describes four Agent Skills and when to use each. Install and update run through npx skills. It recommends which skills to keep enabled and gives sample prompts. Each skill consists of SKILL.md and a rules folder with individual guidance files.

SKILL.md

---
name: tinybird
description: Tinybird file formats, SQL rules, optimization patterns, and best practices for datasources, pipes, endpoints, and materialized views.
---

# 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.

FAQ

Which skills should I enable?

Always best practices, the CLI skill when using tb, and the SDK skill for your project's language.

How do I update?

Run npx skills update.

Editors’ pick

166 skills for scientific work: bioinformatics, cheminformatics, clinical data, geospatial analysis and 100+ databases

SkillMedium risk44.9K
Editors’ pick

Google's open-source MCP server for databases: ready tools for Postgres, MySQL, BigQuery, Spanner and more, plus custom tools in tools.yaml

MCP serverHigh risk16.4K
Editors’ pick

Official Hugging Face skills: Hub operations via the hf CLI, datasets, model training, Spaces, evals and deployment

SkillHigh risk11K
Editors’ pick

A token-lean MCP server for PostgreSQL, MySQL, MariaDB, SQL Server and SQLite with a read-only mode

MCP serverHigh risk3.5K