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,266 stars 315 forks Updated today 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
7 months ago
Last Updated
today
Language
Python
License
MIT

Integrates with

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Featured

clickup-deploy-integration

Deploy ClickUp API integrations to Vercel, Fly.io, and Cloud Run with secure secrets management and health checks. Trigger: "deploy clickup", "clickup Vercel", "clickup production deploy", "clickup Cloud Run", "clickup Fly.io", "clickup hosting".

2,266 Updated today
jeremylongshore
AI & Automation Featured

hubspot-deploy-integration

Deploy HubSpot integrations to Vercel, Fly.io, and Cloud Run platforms. Use when deploying HubSpot-powered applications, configuring platform secrets, or setting up deployment pipelines with HubSpot access tokens. Trigger with phrases like "deploy hubspot", "hubspot Vercel", "hubspot Cloud Run", "hubspot Fly.io", "hubspot production deploy".

2,266 Updated today
jeremylongshore
AI & Automation Featured

klaviyo-deploy-integration

Deploy Klaviyo integrations to Vercel, Fly.io, and Cloud Run platforms. Use when deploying Klaviyo-powered applications to production, configuring platform-specific secrets, or setting up deployment pipelines. Trigger with phrases like "deploy klaviyo", "klaviyo Vercel", "klaviyo production deploy", "klaviyo Cloud Run", "klaviyo Fly.io".

2,266 Updated today
jeremylongshore
AI & Automation Featured

hootsuite-deploy-integration

Deploy Hootsuite integrations to Vercel, Fly.io, and Cloud Run platforms. Use when deploying Hootsuite-powered applications to production, configuring platform-specific secrets, or setting up deployment pipelines. Trigger with phrases like "deploy hootsuite", "hootsuite Vercel", "hootsuite production deploy", "hootsuite Cloud Run", "hootsuite Fly.io".

2,266 Updated today
jeremylongshore
AI & Automation Solid

hex-deploy-integration

Deploy Hex integrations to Vercel, Fly.io, and Cloud Run platforms. Use when deploying Hex-powered applications to production, configuring platform-specific secrets, or setting up deployment pipelines. Trigger with phrases like "deploy hex", "hex Vercel", "hex production deploy", "hex Cloud Run", "hex Fly.io".

2,266 Updated today
jeremylongshore