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
- Data exploration: List databases and tables, then run targeted SELECT queries to inspect Clickhouse data.
- Infrastructure visibility: Inspect Clickpipes, services, backups, and organization-level cost and configuration details.