# tinybird

Guides agents when authoring Tinybird data files, fine-tuning analytical queries, and structuring data processing pipelines.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 1700 installs · ★ 22
- Author: tinybirdco
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/tinybirdco/tinybird-agent-skills/tree/HEAD/skills/tinybird-best-practices/SKILL.md
- Updated: 2026-07-29
- HTML: https://affpapa.org/en/nevibecode/skills/tinybird

## What it does

This skill provides coding assistants with guidelines for `.pipe`, `.datasource`, and `.connection` resources. It outlines conventions for schema architecture, test files, and data workflows where workspace files serve as the source of truth.

Queries are restricted to SELECT statements that comply with Tinybird templating rules and parameter parsing. Standard data targets use MergeTree, switching to AggregatingMergeTree for materialized destinations. Pipelines must filter rows early while deferring heavy computations to subsequent nodes.

Workspace orchestration relies on `tinybird.config.json`, which determines the target through `dev_mode` settings (`local` or `branch`). CLI utilities like `tb sql` and `tb logs` execute locally by default. Connecting to remote instances requires passing `--cloud` or `--branch=<branch-name>`.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add tinybirdco/tinybird-agent-skills --skill tinybird -a claude-code
```
```bash
npx skills add tinybirdco/tinybird-agent-skills --skill tinybird-best-practices -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/tinybird-best-practices/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/tinybird-best-practices/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add tinybirdco/tinybird-agent-skills --skill tinybird-best-practices -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/tinybird-best-practices/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add tinybirdco/tinybird-agent-skills --skill tinybird-best-practices -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/tinybird-best-practices/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install tinybirdco/tinybird-agent-skills tinybird-best-practices
```

2. **Manually: put the files in place**
- File: `.github/skills/tinybird-best-practices/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add tinybirdco/tinybird-agent-skills --skill tinybird-best-practices -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/tinybirdco/tinybird-agent-skills --path skills/tinybird-best-practices
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/tinybird-best-practices/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add tinybirdco/tinybird-agent-skills --skill tinybird-best-practices -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/tinybirdco/tinybird-agent-skills/tree/HEAD/skills/tinybird-best-practices/SKILL.md

## When to use it
- structure data sources and analytical pipes
- write templated SELECT queries according to Tinybird syntax
- configure materialized views using AggregatingMergeTree
- apply deduplication rules and endpoint optimizations

## Example prompts
- Generate a `.pipe` definition that aggregates metrics into an AggregatingMergeTree target
- Review my `.datasource` schema and check if the filtering happens early in the pipe
- Set up a deduplication query pattern for incoming event streams

## Similar
- [xlsx](https://affpapa.org/en/nevibecode/skills/xlsx.md) — skill · 187223 installs
- [google-agents-cli-observability](https://affpapa.org/en/nevibecode/skills/google-agents-cli-observability.md) — skill · 511300 installs
- [caveman-evidence-review](https://affpapa.org/en/nevibecode/skills/caveman-evidence-review.md) — skill · 104500 installs
- [migration](https://affpapa.org/en/nevibecode/skills/migration.md) — skill · 103900 installs
- [performance-optimization](https://affpapa.org/en/nevibecode/skills/performance-optimization.md) — skill · 65200 installs
- [supabase](https://affpapa.org/en/nevibecode/skills/supabase.md) — skill · 8 installs

From the same set: [tinybirdco/tinybird-agent-skills](https://affpapa.org/en/nevibecode/by/tinybirdco/tinybird-agent-skills.md) — 2 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md