{"slug":"oualib/chmcp","name":"ClickHouse Cloud & On-Prem","description":"A server for managing ClickHouse databases and ClickHouse Cloud services.","category":"database","tags":[],"official":false,"stars":7,"transport":"http","install":[{"cmd":"pip install .","imports":[]}],"tools":[{"name":"list_databases","description":"List all databases in the ClickHouse instance with detailed metadata"},{"name":"list_tables","description":"List all tables in a specific database with column types, row counts, and table structures"},{"name":"execute_select_query","description":"Execute SELECT queries with safety guarantees (read-only mode)"},{"name":"list_organizations","description":"List all organizations in ClickHouse Cloud"},{"name":"get_organization_settings","description":"Get settings for a specific organization"},{"name":"get_organization_metrics","description":"Get metrics for a specific organization"},{"name":"list_private_endpoints","description":"List private endpoints for an organization"},{"name":"create_service","description":"Create a new ClickHouse Cloud service"},{"name":"scale_service","description":"Scale an existing ClickHouse Cloud service"},{"name":"start_service","description":"Start a stopped ClickHouse Cloud service"},{"name":"stop_service","description":"Stop a running ClickHouse Cloud service"},{"name":"configure_service","description":"Configure an existing ClickHouse Cloud service"},{"name":"delete_service","description":"Delete a ClickHouse Cloud service"},{"name":"list_services","description":"List all ClickHouse Cloud services"},{"name":"get_service","description":"Get details of a specific ClickHouse Cloud service"},{"name":"list_api_keys","description":"List all API keys for ClickHouse Cloud"},{"name":"create_api_key","description":"Create a new API key for ClickHouse Cloud"},{"name":"get_api_key","description":"Get details of a specific API key"},{"name":"update_api_key","description":"Update an existing API key"},{"name":"delete_api_key","description":"Delete an API key"},{"name":"list_members","description":"List all members of an organization"},{"name":"invite_member","description":"Invite a new member to an organization"},{"name":"remove_member","description":"Remove a member from an organization"},{"name":"list_invitations","description":"List all pending invitations"},{"name":"cancel_invitation","description":"Cancel a pending invitation"},{"name":"resend_invitation","description":"Resend a pending invitation"},{"name":"update_member_role","description":"Update the role of a member"},{"name":"list_backups","description":"List all backups for a service"},{"name":"create_backup","description":"Create a new backup for a service"},{"name":"get_backup","description":"Get details of a specific backup"},{"name":"delete_backup","description":"Delete a backup"},{"name":"list_clickpipes","description":"List all ClickPipes for a service"},{"name":"create_clickpipe","description":"Create a new ClickPipe"},{"name":"get_clickpipe","description":"Get details of a specific ClickPipe"},{"name":"update_clickpipe","description":"Update an existing ClickPipe"},{"name":"delete_clickpipe","description":"Delete a ClickPipe"},{"name":"start_clickpipe","description":"Start a ClickPipe"},{"name":"stop_clickpipe","description":"Stop a ClickPipe"},{"name":"get_usage_analytics","description":"Get usage analytics for an organization"},{"name":"get_costs","description":"Get cost information for an organization"},{"name":"get_audit_logs","description":"Get audit logs for an organization"},{"name":"list_private_endpoints","description":"List private endpoints for a service"},{"name":"create_private_endpoint","description":"Create a new private endpoint"},{"name":"get_private_endpoint","description":"Get details of a specific private endpoint"},{"name":"delete_private_endpoint","description":"Delete a private endpoint"},{"name":"list_network_policies","description":"List network policies for an organization"},{"name":"create_network_policy","description":"Create a new network policy"}],"env_vars":["CLICKHOUSE_HOST","CLICKHOUSE_PORT","CLICKHOUSE_CLOUD_KEY_ID","CLICKHOUSE_CLOUD_KEY_SECRET","CLICKHOUSE_CLOUD_API_URL"],"auth_type":"none","github":"https://github.com/oualib/chmcp","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Thu May 28"}