Connect ClickHouse with Hookshot™ and your stack

ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support

Tools and triggers

What Agents can do in ClickHouse

Available tools and events after ClickHouse is connected.

  • Execute ClickHouse Query

    Execute a SQL query in ClickHouse and return the results. This is the primary action for querying data from ClickHouse databases.

  • Get ClickHouse Play Interface

    Get the ClickHouse Play web user interface for interactive query execution. Returns HTML page with Monaco Editor for writing queries and visualizing results.

  • Get Database Schema

    Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. Essential for AI agents to understand the complete database structure in a single call.

  • Get Table Schema

    Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. This is essential for AI agents to understand table structure before constructing queries.

  • List ClickHouse Databases

    List all databases in the ClickHouse instance. Useful for discovering available databases before querying tables.

  • List ClickHouse Tables

    List tables in ClickHouse databases. Returns information about tables including their engine, size, and row count.

Setup

Connect ClickHouse in Hookshot™

Pick a scope, then confirm what can start a Protege and what it can do.

Trigger Access

What can start a Protege from this app.

Tool Access

What a Protege can do after it starts.

Connection scope

Prefer team for production.

Team

Shared credential for production and unattended runs.

Personal

Tied to one user—only when the workflow needs their account.

Chat

Team-scoped for supported chat surfaces.

Full setup guide

Build with us

See Hookshot™ in your stack.

Request early access or book a live walkthrough with the team.

Request Demo
Hookshot™ setup screen — AI agent workflow configuration with model selection, trigger status, and governance controls.