Summary
Connects Claude to ClickHouse databases in read-only mode for safe analytics exploration. You get table inspection, schema discovery, query execution, and cluster health checks without worrying about accidental writes. Reach for this when you want an AI assistant to help analyze your ClickHouse data, generate reports, or troubleshoot performance issues by examining table sizes and system metrics. The read-only constraint makes it safer to expose production analytics databases to AI agents that need to answer business intelligence questions or explore your data warehouse.
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →
Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Tools
Public tool metadata for what this MCP can expose to an agent.
13 tools
get_clickpipeReturns the specified ClickPipe.3 params
Returns the specified ClickPipe.
Parameters* required
clickPipeIdstringID of the requested ClickPipe
organizationIdstringID of the organization that owns the service
serviceIdstringID of the service that owns the ClickPipe
get_organizationsRetrieves all accessible ClickHouse Cloud organizations.
Retrieves all accessible ClickHouse Cloud organizations.
No parameter schema in public metadata yet.
run_select_queryExecutes 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.3 params
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.
Parameters* required
querystringA valid ClickHouse SQL SELECT query string
serviceIdstringThe unique identifier of the ClickHouse service
timeoutSecondsintegerMaximum time in seconds to wait for the query to complete. Defaults to 300 (5 minutes), maximum is 3600 (1 hour). Use lower values for simple queries and higher values for complex analytical queries.
list_databasesRetrieves all databases available in a ClickHouse service.1 params
Retrieves all databases available in a ClickHouse service.
Parameters* required
serviceIdstringlist_tablesRetrieves a comprehensive list of tables in a ClickHouse database, including columns.4 params
Retrieves a comprehensive list of tables in a ClickHouse database, including columns.
Parameters* required
databasestringName of the database to list tables from
likestringOptional SQL LIKE pattern to filter tables by name (e.g., "events_%")
notLikestringOptional SQL LIKE pattern to exclude tables by name
serviceIdstringThe unique identifier of the ClickHouse service
get_services_listRetrieves all services in a ClickHouse Cloud organization.1 params
Retrieves all services in a ClickHouse Cloud organization.
Parameters* required
organizationIdstringID of the organization whose services are to be listed
get_organization_detailsReturns details of a single organization. The auth key must belong to the organization.1 params
Returns details of a single organization. The auth key must belong to the organization.
Parameters* required
organizationIdstringID of the organization to retrieve
get_service_detailsReturns a service that belongs to the organization.2 params
Returns a service that belongs to the organization.
Parameters* required
organizationIdstringID of the organization
serviceIdstringID of the service to retrieve
list_clickpipesRetrieves all ClickPipes configured for a specific service.2 params
Retrieves all ClickPipes configured for a specific service.
Parameters* required
organizationIdstringID of the organization
serviceIdstringID of the service to list ClickPipes for
list_service_backupsReturns a list of all backups for the service. The most recent backups comes first in the list.2 params
Returns a list of all backups for the service. The most recent backups comes first in the list.
Parameters* required
organizationIdstringID of the organization
serviceIdstringID of the service to list backups for
get_organization_costRetrieves 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).3 params
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).
Parameters* required
from_datestringStart date for the report, e.g. 2024-12-19 (YYYY-MM-DD)
organizationIdstringThe unique identifier of the organization
to_datestringEnd date (inclusive) for the report, e.g. 2024-12-20 (YYYY-MM-DD). Cannot be more than 30 days after from_date.
get_service_backup_detailsReturns a single backup info.3 params
Returns a single backup info.
Parameters* required
backupIdstringID of the backup
organizationIdstringID of the organization that owns the service
serviceIdstringID of the service
get_service_backup_configurationReturns the service backup configuration.2 params
Returns the service backup configuration.
Parameters* required
organizationIdstringID of the organization that owns the service
serviceIdstringID of the service
Featured
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Categories
Registryactive
Package@infoinlet/mcp-clickhouse
TransportSTDIO
UpdatedMay 29, 2026
