Tinybird

Tinybird Query API

Execute SQL queries against pipes and data sources

GitHub OpenAPI
Business capability
Analytics & BI Management BC-610.50

Operations 2

GET /v0/sql Execute SQL Query (GET) #
POST /v0/sql Execute SQL Query (POST) #

Documentation

📖
Documentation
https://www.tinybird.co/docs/api-reference
📖
GettingStarted
https://www.tinybird.co/docs/get-started
📖
Authentication
https://www.tinybird.co/docs/api-reference/token-api

Specifications

⚙
OpenAPI
https://artifacts.apis.io/tinybird/openapi/tinybird-query-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://artifacts.apis.io/tinybird/json-schema/tinybird-data-source-schema.json
📊
JSONStructure
https://artifacts.apis.io/tinybird/json-structure/tinybird-data-source-structure.json

Other Resources

🔗
JSONLDContext
https://artifacts.apis.io/tinybird/json-ld/tinybird-context.jsonld
🔗
SpectralRules
https://artifacts.apis.io/tinybird/rules/tinybird-rules.yml

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/tinybird:tinybird-query-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

tinybird-query-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Tinybird Query API
  description: Tinybird is a real-time data platform that allows you to ingest, process, and expose data through low-latency, high-concurrency APIs. The Tinybird API provides endpoints for managing data sources, pipes, queries, tokens, jobs, organizations, events, environment variables, and sink pipes.
  version: v0
  contact:
    name: Tinybird Support
    url: https://www.tinybird.co/docs
  x-logo:
    url: https://www.tinybird.co/logo.png
servers:
- url: https://api.tinybird.co
  description: Europe (Frankfurt) - Default
- url: https://api.us-east.tinybird.co
  description: US East (Virginia)
- url: https://api.europe-west2.gcp.tinybird.co
  description: Europe (London)
- url: https://api.northamerica-northeast2.gcp.tinybird.co
  description: North America (Toronto)
security:
- bearerAuth: []
tags:
- name: Query
  description: Execute SQL queries against pipes and data sources
paths:
  /v0/sql:
    get:
      operationId: querySql
      summary: Execute SQL Query (GET)
      description: Execute a SQL query using the Tinybird query engine via GET request.
      tags:
      - Query
      parameters:
      - name: q
        in: query
        required: true
        description: SQL query string to execute
        schema:
          type: string
      - name: format
        in: query
        description: Output format
        schema:
          type: string
          enum:
          - JSON
          - CSV
          - NDJSON
          - Parquet
      responses:
        '200':
          description: Query results
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryResponse'
    post:
      operationId: querySqlPost
      summary: Execute SQL Query (POST)
      description: Execute a SQL query using the Tinybird query engine via POST request, supporting templated queries.
      tags:
      - Query
      requestBody:
        content:
          application/json:
            schema:
              type: object
              required:
              - q
              properties:
                q:
                  type: string
                  description: SQL query string
                format:
                  type: string
                  enum:
                  - JSON
                  - CSV
                  - NDJSON
                  - Parquet
      responses:
        '200':
          description: Query results
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryResponse'
components:
  schemas:
    QueryResponse:
      type: object
      properties:
        meta:
          type: array
          items:
            type: object
            properties:
              name:
                type: string
              type:
                type: string
        data:
          type: array
          items:
            type: object
        rows:
          type: integer
        statistics:
          type: object
          properties:
            elapsed:
              type: number
            rows_read:
              type: integer
            bytes_read:
              type: integer
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      description: Tinybird authentication token