# Clickhouse MCP

> Connects to Clickhouse via Scalekit MCP to query databases and tables, inspect services, Clickpipes, backups, and organization details.

**URL:** https://caywork.com/learn/docs/node/clickhousemcp-node

## Content

The **Clickhouse MCP Node** integrates securely with Clickhouse through the Scalekit MCP gateway. It enables your AI agent to explore databases, list tables and Clickpipes, inspect services, backups, organization details, and run select queries.

## Parameters

### Required Parameters
* **action** (string): The target Clickhouse MCP tool action to run. Must be one of the enabled actions:
  * `clickhouse_get_clickpipe`: Get a Clickpipe.
  * `clickhouse_get_organization_cost`: Get organization cost details.
  * `clickhouse_get_organization_details`: Get organization details.
  * `clickhouse_get_organizations`: List organizations.
  * `clickhouse_get_service_backup_configuration`: Get service backup configuration.
  * `clickhouse_get_service_backup_details`: Get service backup details.
  * `clickhouse_get_service_details`: Get service details.
  * `clickhouse_get_services_list`: List services.
  * `clickhouse_list_clickpipes`: List Clickpipes.
  * `clickhouse_list_databases`: List databases.
  * `clickhouse_list_service_backups`: List service backups.
  * `clickhouse_list_tables`: List tables.
  * `clickhouse_oauth`: OAuth.
  * `clickhouse_run_select_query`: Run a select query.

### Optional Parameters
* **params** (object): A key-value dictionary containing action-specific inputs (e.g., `{'database': 'analytics', 'query': 'SELECT * FROM events LIMIT 10'}`).

## Practical Use Cases
1. **Data exploration**: List databases and tables, then run targeted SELECT queries to inspect Clickhouse data.
2. **Infrastructure visibility**: Inspect Clickpipes, services, backups, and organization-level cost and configuration details.