ClickHouse Cloud & On-Prem
JSON →A server for managing ClickHouse databases and ClickHouse Cloud services.
Install
pip install . Tools · 47
- list_databases List all databases in the ClickHouse instance with detailed metadata
- list_tables List all tables in a specific database with column types, row counts, and table structures
- execute_select_query Execute SELECT queries with safety guarantees (read-only mode)
- list_organizations List all organizations in ClickHouse Cloud
- get_organization_settings Get settings for a specific organization
- get_organization_metrics Get metrics for a specific organization
- list_private_endpoints List private endpoints for an organization
- create_service Create a new ClickHouse Cloud service
- scale_service Scale an existing ClickHouse Cloud service
- start_service Start a stopped ClickHouse Cloud service
- stop_service Stop a running ClickHouse Cloud service
- configure_service Configure an existing ClickHouse Cloud service
- delete_service Delete a ClickHouse Cloud service
- list_services List all ClickHouse Cloud services
- get_service Get details of a specific ClickHouse Cloud service
- list_api_keys List all API keys for ClickHouse Cloud
- create_api_key Create a new API key for ClickHouse Cloud
- get_api_key Get details of a specific API key
- update_api_key Update an existing API key
- delete_api_key Delete an API key
- list_members List all members of an organization
- invite_member Invite a new member to an organization
- remove_member Remove a member from an organization
- list_invitations List all pending invitations
- cancel_invitation Cancel a pending invitation
- resend_invitation Resend a pending invitation
- update_member_role Update the role of a member
- list_backups List all backups for a service
- create_backup Create a new backup for a service
- get_backup Get details of a specific backup
- delete_backup Delete a backup
- list_clickpipes List all ClickPipes for a service
- create_clickpipe Create a new ClickPipe
- get_clickpipe Get details of a specific ClickPipe
- update_clickpipe Update an existing ClickPipe
- delete_clickpipe Delete a ClickPipe
- start_clickpipe Start a ClickPipe
- stop_clickpipe Stop a ClickPipe
- get_usage_analytics Get usage analytics for an organization
- get_costs Get cost information for an organization
- get_audit_logs Get audit logs for an organization
- list_private_endpoints List private endpoints for a service
- create_private_endpoint Create a new private endpoint
- get_private_endpoint Get details of a specific private endpoint
- delete_private_endpoint Delete a private endpoint
- list_network_policies List network policies for an organization
- create_network_policy Create a new network policy
Environment variables
CLICKHOUSE_HOSTCLICKHOUSE_PORTCLICKHOUSE_CLOUD_KEY_IDCLICKHOUSE_CLOUD_KEY_SECRETCLICKHOUSE_CLOUD_API_URL
Links
★ 7 GitHub stars