⚙Tool
Tinybird Tools
Run SQL queries and list pipes and data sources in your Tinybird workspace.
Tinybird is a real-time analytics platform for building APIs over large-scale data. These tools let a workflow run SQL queries against your Tinybird workspace and enumerate its pipes and data sources, so you can pull live analytics into a run or discover available resources before querying them.
Overview
| Property | Value |
|---|---|
| Provider | tinybird |
| Category | tools |
| Auth | Bearer Token (Tinybird API token) |
Operations
| Operation | Tool ID | Description |
|---|---|---|
| Query | tinybird_query | Run a SQL query against Tinybird and return JSON results |
| List pipes | tinybird_list_pipes | List all pipes in the Tinybird workspace |
| List data sources | tinybird_list_datasources | List all data sources in the Tinybird workspace |
Configuration
tinybird_query
Run a SQL query against Tinybird and return JSON results.
| Parameter | Type | Required | Description |
|---|---|---|---|
apiKey | string | Yes | Tinybird API token. Secret — provide via an environment variable, e.g. {{TINYBIRD_API_KEY}}. Sent as a Bearer token. (visibility: user-only) |
sql | string | Yes | The SQL query to execute. (visibility: user-or-llm) |
tinybird_list_pipes
List all pipes in the Tinybird workspace.
| Parameter | Type | Required | Description |
|---|---|---|---|
apiKey | string | Yes | Tinybird API token. Secret — provide via an environment variable, e.g. {{TINYBIRD_API_KEY}}. Sent as a Bearer token. (visibility: user-only) |
tinybird_list_datasources
List all data sources in the Tinybird workspace.
| Parameter | Type | Required | Description |
|---|---|---|---|
apiKey | string | Yes | Tinybird API token. Secret — provide via an environment variable, e.g. {{TINYBIRD_API_KEY}}. Sent as a Bearer token. (visibility: user-only) |
Outputs
tinybird_query
data(json) — The Tinybird result object ({ meta, data, rows }).metadata(json) — Query metadata.metadata.count(number) — Number of rows returned.
tinybird_list_pipes
data(json) — The Tinybird response object ({ pipes }).metadata(json) — List metadata.metadata.count(number) — Number of pipes returned.
tinybird_list_datasources
data(json) — The Tinybird response object ({ datasources }).metadata(json) — List metadata.metadata.count(number) — Number of data sources returned.
YAML Example
tinybird_1:
type: tinybird
name: "Tinybird"
inputs:
operation: "tinybird_query"
sql: "SELECT * FROM my_pipe LIMIT 10"
apiKey: "{{TINYBIRD_API_KEY}}"
connections:
outgoing:
- target: next-block-idTips
- Auth uses a Tinybird API token sent as a Bearer token. Generate a token in your Tinybird workspace (Tokens section) and store it as an environment variable, then reference it as
{{TINYBIRD_API_KEY}}so the secret never appears inline. - The
sqlparameter isuser-or-llm, so an agent can generate the query at runtime. Usetinybird_list_pipesandtinybird_list_datasourcesfirst to discover queryable resources, then feed their names into atinybird_querycall (e.g.{{tinybird_1.data}}). - All three operations call
https://api.tinybird.co/v0/.... If your workspace lives in a different region, the host may differ — confirm the API region matches the token before relying on results. - For
tinybird_query, the full Tinybird payload (meta,data,rows) is underdata, whilemetadata.countis the convenience row count derived fromdata.data.