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.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
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
serviceIdstringID of the service that owns the ClickPipe
clickPipeIdstringID of the requested ClickPipe
organizationIdstringID of the organization that owns the service
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
likestringOptional SQL LIKE pattern to filter tables by name (e.g., "events_%")
notLikestringOptional SQL LIKE pattern to exclude tables by name
databasestringName of the database to list tables from
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
serviceIdstringID of the service to retrieve
organizationIdstringID of the organization
list_clickpipesRetrieves all ClickPipes configured for a specific service.2 params
Retrieves all ClickPipes configured for a specific service.
Parameters* required
serviceIdstringID of the service to list ClickPipes for
organizationIdstringID of the organization
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
serviceIdstringID of the service to list backups for
organizationIdstringID of the organization
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
to_datestringEnd date (inclusive) for the report, e.g. 2024-12-20 (YYYY-MM-DD). Cannot be more than 30 days after from_date.
from_datestringStart date for the report, e.g. 2024-12-19 (YYYY-MM-DD)
organizationIdstringThe unique identifier of the organization
get_service_backup_detailsReturns a single backup info.3 params
Returns a single backup info.
Parameters* required
backupIdstringID of the backup
serviceIdstringID of the service
organizationIdstringID of the organization that owns the service
get_service_backup_configurationReturns the service backup configuration.2 params
Returns the service backup configuration.
Parameters* required
serviceIdstringID of the service
organizationIdstringID of the organization that owns the service
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →Categories
Registryactive
Package@infoinlet/mcp-clickhouse
TransportSTDIO
UpdatedMay 29, 2026
