ClickHouse Cloud Management

概要

Automates user and permission management for ClickHouse Cloud instances. This skill uses SQL commands sent via the public HTTP interface to create database users, grant or revoke privileges, and test connectivity. It clarifies the distinction between SQL users and Cloud API keys, provides secure credential retrieval patterns from 1Password, and offers troubleshooting guidance for common connection and authentication errors.

主な機能

• Creates and manages database users with SQL (CREATE/DROP USER)
• 1 GitHub stars
• Provides secure credential retrieval patterns using the 1Password CLI
• Defines password policies and connection protocol best practices
• Grants and revokes permissions for specific databases and tables
• Troubleshoots authentication and connection issues over the HTTPS interface

ユースケース

• Diagnosing why a client application cannot connect to a ClickHouse Cloud instance
• Granting an application INSERT and SELECT permissions on a specific table
• Creating a new read-only database user for an analytics application