clickhouse-deploy-integration

Featured

Deploy ClickHouse-backed applications to Vercel, Fly.io, and Cloud Run with connection pooling, secrets, and health checks. Use when deploying applications that connect to ClickHouse Cloud, configuring platform secrets, or setting up deployment pipelines. Trigger: "deploy clickhouse app", "clickhouse Vercel", "clickhouse Cloud Run", "clickhouse production deploy", "clickhouse Fly.io".

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 Deploy Integration ## Overview Deploy applications that connect to ClickHouse Cloud from serverless and container platforms with proper connection management and secrets handling. ## Prerequisites - ClickHouse Cloud instance (or self-hosted with public endpoint) - Platform CLI installed (vercel, fly, or gcloud) - Application tested locally against ClickHouse ## Instructions ### Step 1: ClickHouse Connection Module (Platform-Agnostic) ```typescript // src/db.ts — singleton for serverless-safe connections import { createClient, ClickHouseClient } from '@clickhouse/client'; let client: ClickHouseClient | null = null; export function getClickHouse(): ClickHouseClient { if (!client) { client = createClient({ url: process.env.CLICKHOUSE_HOST!, // https://<host>:8443 username: process.env.CLICKHOUSE_USER!, password: process.env.CLICKHOUSE_PASSWORD!, database: process.env.CLICKHOUSE_DATABASE ?? 'default', request_timeout: 30_000, max_open_connections: 5, // Low for serverless (many cold starts) compression: { request: true, // Saves egress bandwidth response: true, }, }); } return client; } ``` ### Step 2: Vercel (Serverless Functions) ```bash # Set secrets vercel env add CLICKHOUSE_HOST production vercel env add CLICKHOUSE_USER production vercel env add CLICKHOUSE_PASSWORD production vercel env add CLICKHOUSE_DATABASE production ``` ```typescript // api/events...

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