ClickHouse Cloud Management
Manages ClickHouse Cloud users, permissions, and connections using SQL over the HTTP interface.
The source repository doesn't declare a license. Check its terms before reusing the code.
Key features
- Creates and manages database users with SQL (CREATE/DROP USER)
- 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
FAQ
When should I use this skill?
Use this skill for routine database administration tasks like creating a new read-only user for an application, setting up developer access to specific tables, or quickly testing connectivity and permissions for a service account.
What does the ClickHouse Cloud Management skill do?
This skill empowers Claude to manage users and permissions in your ClickHouse Cloud instance. It can create and delete database users, grant or revoke access to tables, and troubleshoot connection issues using SQL over the secure HTTP interface.
What are its key capabilities?
Its main capabilities are creating and dropping users (`CREATE/DROP USER`), managing permissions (`GRANT/REVOKE`), testing connections, and providing secure credential retrieval patterns using the 1Password CLI. It also understands the distinction between database users and cloud API keys.
How does this skill improve my workflow?
It streamlines database administration by letting you perform user management tasks directly in your chat with Claude. This automates the process of writing SQL and curl commands, securely retrieves credentials, and reduces context switching, speeding up DevOps and development cycles.
Related skills
PostGIS Geospatial Development
Implements best practices for querying and managing geospatial data in PostgreSQL with PostGIS.
Database Management12 ptsSupabase Database Integration
Query and interact with Supabase databases using real-time subscriptions and PostgreSQL-compatible syntax while respecting Row Level Security policies.
Database Management12 ptsDatabase Connection Pooling
Optimizes database performance and reliability by configuring robust connection pools for SQLAlchemy across traditional and serverless architectures.
Database Management12 pts