• RAW DATA
  • PIPELINES
  • ANALYSIS
  • HUMAN

How to run ad-hoc SQL queries with your AI

Connect Tinybird to your AI client to turn natural language questions into live data insights. Your agent handles the heavy lifting of querying your real-time data streams.

Ask AI about this page

Short answer

How can I run SQL queries with my AI?

Your AI uses the Tinybird MCP to execute custom ClickHouse SQL or run specific Pipe queries. You get immediate data insights by asking questions in plain English.

Where every insight lands.

The outcomes of your queries

Depending on how you phrase your request, your AI delivers data in different formats.

RAW DATA

Direct SQL results

When you ask for specific table lookups, the AI runs a query and returns the raw rows you need.

PIPELINES

Processed Pipe data

If you need data that has already been transformed, the AI pulls from your existing Tinybird Pipes.

ANALYSIS

Summarized insights

The AI takes the returned data and interprets it, giving you trends or counts instead of just a list of numbers.

HUMAN

Manual verification

If a query is too complex or the schema is unclear, the AI will ask you to clarify the specific columns or logic needed.

The workflow

What your AI does when a query arrives.

The AI acts as the bridge between your conversation and your Tinybird data streams.

  1. Interpret intent

    The agent analyzes your question to decide if you need a standard SQL statement or a pre-built Pipe query.

    execute_sql_queryquery_pipe_data

  2. Execute SQL

    For custom requests, the AI writes and runs the necessary ClickHouse code against your data.

    execute_sql_query

  3. Fetch Pipe data

    If you have existing data transformations, the AI pulls the results from those specific Pipes.

    query_pipe_data

  4. Format response

    The agent takes the resulting dataset and presents it as a readable answer in your chat window.

    query_pipe_data

Try it

Copy these to start.

Use these prompts to test the connection.

Starting points

These are examples. Swap out the table names and column names for your actual Tinybird schema.

Tinybird Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_e9MOySIFrTyItsoZeoVkFv0IVVN3MSGs8AJqsvq5/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Tinybird capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "tinybird-data-platform-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_e9MOySIFrTyItsoZeoVkFv0IVVN3MSGs8AJqsvq5/mcp"
    }
  }
}
Copy into chat04

  • Run a SQL query to show me the last 10 events from the user_logs table.

  • What is the current count of active sessions according to the session_pipeline pipe?

  • Execute a SQL query to find the top 5 most frequent error codes in the telemetry table.

  • Pull the data from the daily_active_users pipe and tell me if there was a spike yesterday.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Tinybird once, then ask.

Just provide your Tinybird credentials through the Vinkius interface. Your connection is secure, and you can start querying immediately in any compatible client.

Connect Tinybird to your AI

FAQ

How the queries behave

  • 01

    Can the AI change my data in Tinybird?

    No. The tools only allow for reading data through SQL or Pipes. The AI cannot perform INSERT, UPDATE, or DELETE operations.

  • 02

    Can I use my own custom SQL?

    Yes. You can ask the AI to write and run specific ClickHouse SQL queries for any data available in your account.

  • 03

    Does the AI see my entire database?

    The AI only sees the data it can access through the specific tools provided. It doesn't have unrestricted access to your entire infrastructure.

  • 04

    What happens if a query fails?

    If the SQL is invalid or the Pipe is broken, the AI will report the error message from Tinybird so you can fix the logic.

  • 05

    Can the AI create new Pipes for me?

    No. The AI can only query existing Pipes or run raw SQL. It cannot create or modify the structure of your Tinybird Pipes.

  • More questions about Tinybird? See everything the Tinybird Connector can do

Connect Tinybird to Claude, Cursor, ChatGPT & more