Manages ClickHouse Cloud users, permissions, and connections using SQL over the HTTP interface.
About
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
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
Use Cases
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
