ClickHouse

Explore ClickHouse Cloud

Category: Data & Analytics
Primary Subcategory: Cloud Data Warehouses & Query Engines

Integration details

Description

ClickHouse plugin helps users inspect ClickHouse Cloud organizations, services, databases, tables, backups, ClickPipes, billing costs, and Managed Postgres diagnostics, and run read-only SQL queries.

Integration type: Plugin
Verification status: Not applicable
Platform: ChatGPT
Category: Data & Analytics
Primary Subcategory: Cloud Data Warehouses & Query Engines
Secondary Subcategories: None listed
Brand: ClickHouse
Access: Account required
First tracked: 2026-08-15
Tool count: 17
Geography: US

ChatGPT Plugin Discovery Score

ChatGPT Plugin discovery is coming soon

ChatGPT can surface a Plugin when it matches a user's request.Your Plugin Discovery Score measures how often yours appears.

No spam. Unsubscribe any time.

ChatGPT recommends Airtable when a user asks it to update a CRM. — ChatGPT surfaces Airtable because it matches the user's request.

Primary Subcategory

Competing in ChatGPT Cloud Data Warehouses & Query Engines

View Category

Listed in alphabetical order

Primary Subcategory

AWS Data AnalyticsDiscoverability Score not live yetGet notified when it goes live

ClickHouseDiscoverability Score not live yetGet notified when it goes live

MotherDuckDiscoverability Score not live yetGet notified when it goes live

Tools

17 tools agents can invoke

Returns the specified ClickPipe.
get_clickpipe
Retrieves billing and usage cost data for a ClickHouse Cloud organization. Returns a grand total and a list of daily, per-entity organization usage cost records for the organization in the queried time period (maximum 31 days).
get_organization_cost
Returns details of a single organization. The auth key must belong to the organization.
get_organization_details
Retrieves all accessible ClickHouse Cloud organizations.
get_organizations
Returns bucketed time-series metrics for a Postgres service over a time window (CPU, memory, disk, network, connections, cache hit ratio, throughput, transactions, and more). Each metric has a key, name, unit, description, and one series per label dimension, where each series is a list of (timestamp, value) data points. Timestamps are Unix seconds at the bucket start. Provide fromDate and toDate to bound the window; omit bucketSizeSeconds to let the server pick a bucket granularity for the window. Use this to chart or analyze how a service behaved over time.
get_postgres_metrics
Returns up to the 10 most recent individual executions for a single Postgres slow query pattern from the last 24 hours, plus aggregate metrics for the pattern when available. For exact drill-down from list_postgres_slow_query_patterns, pass queryId, dbName, dbUser, dbOperation, and app exactly as returned; pass app as an empty string when the selected pattern has no application_name. Omit app only when intentionally querying across all applications. Each execution includes duration, rows, buffer/temp/WAL/JIT/CPU counters, and the error message and SQLSTATE if it failed. Durations are in microseconds. The execution sample is capped at 10 rows, so when aggregate is present rely on its fields for totals.
get_postgres_slow_query_pattern_details
Returns the service backup configuration.
get_service_backup_configuration
Returns a single backup info.
get_service_backup_details
Returns a service that belongs to the organization. Supports both ClickHouse services and Managed Postgres services; the service type is detected automatically from the service id and is reported in the `serviceType` field of the response.
get_service_details
Retrieves all ClickHouse and Managed Postgres services in a ClickHouse Cloud organization.
get_services_list
Retrieves all ClickPipes configured for a specific service.
list_clickpipes
Retrieves all databases available in a ClickHouse service.
list_databases
Lists the slowest query patterns observed on a Postgres service in a time window, with aggregate metrics per pattern (call count, total/avg/p50/p95/p99/max duration, rows, shared buffer cache hits and reads, CPU time, WAL bytes, error count). Durations are in microseconds. Use this first to find which queries dominate execution time, CPU, I/O, or WAL, then pass a selected pattern queryId, dbName, dbUser, dbOperation, and app exactly as returned to get_postgres_slow_query_pattern_details for its recent executions. Pass app as an empty string when the selected pattern has no application_name; omit the app filter only when intentionally querying across all applications. The queryText is normalized with $1-style placeholders.
list_postgres_slow_query_patterns
Returns a list of all backups for the service. The most recent backups comes first in the list.
list_service_backups
Retrieves a comprehensive list of tables in a ClickHouse database, including columns.
list_tables
Executes a read-only SELECT query against a Postgres service. The query is routed through the Postgres query endpoint with the read-only role and only read-style statements are permitted.
run_postgres_select_query
Executes a SELECT query against a ClickHouse service. Runs a read-only SELECT query on the specified ClickHouse service via the Query API endpoint. This function provides direct access to database content through SQL queries while ensuring that only read operations are permitted.
run_select_query

ClickHouse FAQ

How do I improve a ChatGPT Plugin's discoverability?

The levers are the listing surface agents actually read: names, descriptions, keywords, tool metadata, and registry health. Which lever matters depends on where discovery breaks, which is what continuous measurement shows.

What are ClickHouse alternatives on ChatGPT?

As of 2026-08-29, ClickHouse competes with AWS Data Analytics, MotherDuck in ChatGPT Cloud Data Warehouses & Query Engines, ranked by public Discoverability Score.

Where is this profile measured?

This profile uses the geography attached to the latest public registry snapshot: US. Locale tags are intentionally omitted.