ClickHouse

By ClickHouse Inc

Get New App Alerts

Open in ChatGPT

Open in Claude

Overview

Connect Claude to your ClickHouse Cloud databases. Browse organizations, services, databases, and table schemas. Run read-only SQL queries against your data and get instant analytical answers. Monitor service backups, review billing costs, and inspect ClickPipe configurations - all through natural conversation.

Tools

get_clickpipe

ChatGPT

Returns the specified ClickPipe.

get_organization_cost

ChatGPT

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_details

ChatGPT

Returns details of a single organization. The auth key must belong to the organization.

get_organizations

ChatGPT

Retrieves all accessible ClickHouse Cloud organizations.

get_postgres_metrics

ChatGPT

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_slow_query_pattern_details

ChatGPT

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_service_backup_configuration

ChatGPT

Returns the service backup configuration.

get_service_backup_details

ChatGPT

Returns a single backup info.

get_service_details

ChatGPT

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_services_list

ChatGPT

Retrieves all ClickHouse and Managed Postgres services in a ClickHouse Cloud organization.

list_clickpipes

ChatGPT

Retrieves all ClickPipes configured for a specific service.

list_databases

ChatGPT

Retrieves all databases available in a ClickHouse service.

list_postgres_slow_query_patterns

ChatGPT

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_service_backups

ChatGPT

Returns a list of all backups for the service. The most recent backups comes first in the list.

list_tables

ChatGPT

Retrieves a comprehensive list of tables in a ClickHouse database, including columns.

run_postgres_select_query

ChatGPT

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_select_query

ChatGPT

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.