Manages ClickHouse Cloud users, permissions, and connections using SQL over the HTTP interface.
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.
Key Features
01Creates and manages database users with SQL (CREATE/DROP USER)
021 GitHub stars
03Provides secure credential retrieval patterns using the 1Password CLI
04Defines password policies and connection protocol best practices
05Grants and revokes permissions for specific databases and tables
06Troubleshoots authentication and connection issues over the HTTPS interface
Use Cases
01Diagnosing why a client application cannot connect to a ClickHouse Cloud instance
02Granting an application INSERT and SELECT permissions on a specific table
03Creating a new read-only database user for an analytics application
