clickhouse-multi-env-setup

Featured

Configure ClickHouse across dev, staging, and production with environment-specific settings, secrets management, and infrastructure-as-code patterns. Use when setting up per-environment ClickHouse instances, managing connection configs, or deploying to multiple environments. Trigger: "clickhouse environments", "clickhouse dev staging prod", "clickhouse multi-env", "clickhouse environment config", "clickhouse staging setup".

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# ClickHouse Multi-Environment Setup ## Overview Configure separate ClickHouse instances for development, staging, and production with proper secrets management, environment detection, and infrastructure-as-code. ## Prerequisites - ClickHouse Cloud account or self-hosted instances per environment - Secret management solution (Vault, AWS Secrets Manager, GCP Secret Manager) - CI/CD pipeline with environment variables ## Instructions ### Step 1: Environment Strategy | Environment | Instance | Purpose | Data | |-------------|----------|---------|------| | Development | Docker local | Fast iteration | Synthetic seed data | | Staging | ClickHouse Cloud (Dev tier) | Pre-prod validation | Sampled prod copy | | Production | ClickHouse Cloud (Prod tier) | Live traffic | Real data | ### Step 2: Configuration Module ```typescript // src/config/clickhouse.ts interface ClickHouseEnvConfig { url: string; username: string; password: string; database: string; maxConnections: number; requestTimeout: number; compression: boolean; } const configs: Record<string, ClickHouseEnvConfig> = { development: { url: 'http://localhost:8123', username: 'default', password: process.env.CLICKHOUSE_PASSWORD ?? 'dev_password', database: 'app_dev', maxConnections: 5, requestTimeout: 60_000, // Longer for debugging compression: false, // Easier to debug raw }, staging: { url: process.env.CLICKHOUSE_HOST ?? 'https://staging.clickhouse.cloud:...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category