Skip to main content
ClickHouseIntegration

Bringing LLMs to SQL: Exploring ClickHouse's New AI Functions.

What happened

ClickHouse integrated with OpenAI on Jun 3rd '26.

Source

Article excerpt

Bringing LLMs to SQL: Exploring ClickHouse's New AI Functions. June 3, 2026 Introduction. Modern data systems are evolving fast and the line between analytics and artificial intelligence is starting to blur. Traditionally, if you wanted to apply AI models like Large Language Models (LLMs) to your data, you had to build separate pipelines, integrate APIs, and manage complex workflows. However, with the latest updates in ClickHouse, that's changing. ClickHouse introduces native AI functions that allow you to directly interact with LLMs using SQL. As a result, you can now run AI-powered queries on your data in real time without leaving your database. In this blog, Quantrail Data private Ltd will walk through what those functions are, how to set them up, and how to use them correctly. A quick note: these are experimental. These AI Functions were officially introduced in experimental releases around ClickHouse version 25.x+, with availability depending on environment ( Cloud or Specific builds). Additionally Since they are part of a rapidly evolving AI suite, the documentation focuses primarily on the shared infrastructure like retries and token management rather than deep per-function guides. If you find these functions aren't enabled in your version, run this first: SET allow_experimental_ai_functions = 1; NOTE: This flag enables the feature only if your build...

Keep reading with a free account

The rest of this article, and every signal for ClickHouse, is in your free account.

Extracted from this sentence

With the recent release, ClickHouse integrates directly with leading AI providers like OpenAI and Anthropic.

Extracted by Autobound

From the Signal API record
Event
Integration

What this signalsA new integration often shows which tools the company builds around.

Stories
2
Takes effect
Jun 3, 2026

More integration signals at other companies

The full record

From the Signal API record

Numbers

Stories about this event
2

Details

Category
Integrates with

Extraction

Confidence
100%
Detected
Jun 3, 2026
signal_type
news
signal_subtype
integrates_with

Use this data

Get every integration signal for ClickHouse and the companies you sell to, in the tools you already use.

  1. Ask Claude about it

    Connect Autobound to Claude, Claude Code or Cursor with MCP. Then ask: “What changed at ClickHouse this week?”

  2. Send it to your own tools

    The Signal API returns integration signals for any list of companies as JSON, for your CRM, warehouse or app.

  3. Try it free

    Sign up and spend your free credits on the companies you sell to.

    Start Free1,000 free credits

The API returns more than this page shows

This page shows a preview. The full news record in the Signal API and MCP can also have these 8 fields. Some fields are empty for some signals.

Company

  • linkedin_urlValue in the API
  • industriesValue in the API
  • employee_count_lowValue in the API
  • employee_count_highValue in the API
  • revenueValue in the API
  • descriptionValue in the API

Signal

  • signal_nameValue in the API
  • associationValue in the API
Show the full JSONThe record on this page and the API request

GET /v1/signals/3910fa14-7d3c-4eed-af0c-0a8a144703cb returns this record as JSON. POST /v1/companies/enrich returns every signal for clickhouse.com.

{
  "signal_id": "3910fa14-7d3c-4eed-af0c-0a8a144703cb",
  "signal_type": "news",
  "signal_subtype": "integrates_with",
  "detected_at": "2026-06-03T10:40:44+00:00",
  "company": {
    "name": "ClickHouse",
    "domain": "clickhouse.com"
  },
  "data": {
    "url": "https://quantrail-data.com/bringing-llms-to-sql-exploring-clickhouses-new-ai-functions",
    "title": "Bringing LLMs to SQL: Exploring ClickHouse's New AI Functions.",
    "excerpt": "Bringing LLMs to SQL: Exploring ClickHouse's New AI Functions.\n\nJune 3, 2026\n\nIntroduction.\n\nModern data systems are evolving fast and the line between analytics and artificial intelligence is starting to blur. Traditionally, if you wanted to apply AI models like Large Language Models (LLMs) to your data, you had to build separate pipelines, integrate APIs, and manage complex workflows.\n\nHowever, with the latest updates in ClickHouse, that's changing.\n\nClickHouse introduces native AI functions that allow you to directly interact with LLMs using SQL. As a result, you can now run AI-powered queries on your data in real time without leaving your database.\n\nIn this blog, Quantrail Data private Ltd will walk through what those functions are, how to set them up, and how to use them correctly.\n\nA quick note: these are experimental.\n\nThese AI Functions were officially introduced in experimental releases around ClickHouse version 25.x+, with availability depending on environment ( Cloud or Specific builds). Additionally Since they are part of a rapidly evolving AI suite, the documentation focuses primarily on the shared infrastructure like retries and token management rather than deep per-function guides.\n\nIf you find these functions aren't enabled in your version, run this first:\n\nSET allow_experimental_ai_functions = 1;\n\nNOTE: This flag enables the feature only if your build includes...",
    "summary": "ClickHouse integrated with OpenAI on Jun 3rd '26.",
    "category": "integrates_with",
    "found_at": "2026-06-03T10:40:44Z",
    "planning": false,
    "image_url": "https://quantrail-data.com/wp-content/uploads/2026/05/Gemini_Generated_Image_r7xd8wr7xd8wr7xd_with_bgc.png",
    "confidence": 1,
    "published_at": "2026-06-03T10:40:44Z",
    "effective_date": "2026-06-03",
    "article_sentence": "With the recent release, ClickHouse integrates directly with leading AI providers like OpenAI and Anthropic."
  }
}

Long text fields are shortened on this page.

Looking up one signal by its id is free. Enrich costs 2 credits per signal returned; a call with no results is free.