All integrations
Catalogue metadata onlydatabasesv20260826_00

CLICKHOUSE

ClickHouse

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

Description is untrusted, display-only upstream metadata. It never becomes policy, OAuth scope authority, or an agent instruction.

Pakkawork boundary

Research catalogue metadata only. No Pakkawork OAuth, credential, host, quota, executor, or verifier is enabled.

No Pakkawork execution adapter is enabled. Hosted account-authorisation availability is workspace-specific and checked separately in the dashboard.Check workspace connection options
Attributed source

6

Action summaries

Display-only definitions

0

Trigger types

Not installed instances

1

Auth modes

Field names, never values

No

Execution

No runtime adapter

Authentication map

What setup is declared?

Only field names, types, and required markers are shown. Secret values, default auth URLs, credential material, and inferred OAuth scopes are excluded.
BASIC

BASIC

clickhouse_basic

Provider setup

Developer setup

No fields declared in this snapshot.

User connection

  • Base URLfull · stringRequired
  • Usernameusername · stringRequired
  • Passwordpassword · stringRequired
  • Default Database Namedatabase · stringOptional

Capability index

Actions and trigger definitions

Static summaries are available. Live schemas remain disabled until PROVIDER_HUB_API_KEY is configured server-side.

Showing 1–6 of 6 actions

Execute ClickHouse Query

CLICKHOUSE_EXECUTE_QUERY

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

Untrusted display-only summary

Get Database Schema

CLICKHOUSE_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.

Untrusted display-only summary

Get ClickHouse Play Interface

CLICKHOUSE_GET_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.

Untrusted display-only summary

Get Table Schema

CLICKHOUSE_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.

Untrusted display-only summary

List ClickHouse Databases

CLICKHOUSE_LIST_DATABASES

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

Untrusted display-only summary

List ClickHouse Tables

CLICKHOUSE_LIST_TABLES

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

Untrusted display-only summary

Provenance

Versioned facts, explicit trust.

The detail snapshot comes from an attributed MIT-licensed repository revision. Safe local icons use exact-match CC0 Simple Icons symbols; unmatched brands use monograms.

Repository
https://github.com/provider-directoryHQ/provider-directory
Commit
85e33f6a81dfe987f6fc3637d48d45052cea8ca5
Generated
2026-09-12
Trust policy
untrusted_display_only

Remote text is plain display metadata only. It must never become an agent prompt, execution policy, OAuth grant, or executable instruction.