Agent skill

Gorse Clickhouse Cloud Incompatible

by divinevideo in divinevideo/divine-mobile

Fix Gorse recommendation engine failing to connect to ClickHouse Cloud with EOF errors.

MPL-2.0Auto-check passedDatabases

Install Gorse Clickhouse Cloud Incompatible

skills CLI
$ npx skills add divinevideo/divine-mobile --skill gorse-clickhouse-cloud-incompatible -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install divinevideo/divine-mobile gorse-clickhouse-cloud-incompatible --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/divinevideo/divine-mobile.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/gorse-clickhouse-cloud-incompatible .claude/skills/gorse-clickhouse-cloud-incompatible && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
gorse-clickhouse-cloud-incompatible
GitHub stars
266
Token cost
~810 tokens
SKILL.md length
307 words
Files
1
Skills in repo
103
Repo updated
First seen
Licence
MPL-2.0

At a glance

Fix Gorse recommendation engine failing to connect to ClickHouse Cloud with EOF errors.

  • Gorse pods crash with failed to connect data database and EOF error
  • SKILL.md covers Problem, Context / Trigger Conditions, Root Cause and Solution Options, plus 2 more sections
  • Calls kubectl
  • Using ClickHouse Cloud (.clickhouse.cloud) as Gorse data store

What it does

Gorse Clickhouse Cloud Incompatible is an agent skill from divinevideo/divine-mobile. Fix Gorse recommendation engine failing to connect to ClickHouse Cloud with EOF errors. Use when: (1) Gorse pods crash with "failed to connect data database" and "EOF" error, (2) Using ClickHouse Cloud (.clickhouse.cloud) as Gorse data store, (3) TLS connection works (verified with openssl) but Gorse still fails, (4) Tried secure=true, different ports (8443, 9440), timeout params without success. The Gorse ClickHouse driver is incompatible with ClickHouse Cloud's native protocol.

Its SKILL.md is about 810 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering Data warehousing. It works with ClickHouse. The licence is MPL-2.0.

When your agent uses it

  • Gorse pods crash with failed to connect data database and EOF error
  • Using ClickHouse Cloud (.clickhouse.cloud) as Gorse data store
  • TLS connection works (verified with openssl) but Gorse still fails
  • Tried secure=true

Example prompts

  • “failed to connect data database”
  • “/gorse-clickhouse-cloud-incompatible”

What it can do on your machine

Read from SKILL.md and the folder at commit c3d6f7e. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • kubectl

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md. Its commands use kubectl, which can reach the network depending on how they are called.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Gorse Clickhouse Cloud Incompatible loads about 810 tokens when it runs. Until then it costs about 130 tokens; SKILL.md has 307 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~130
When it runs · the whole SKILL.md, loaded when a task matches
~810

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from divinevideo/divine-mobile at commit c3d6f7e, republished under its MPL-2.0 licence (© divinevideo). 307 words, ~810 tokens.

Download SKILL.mdSave it as .claude/skills/gorse-clickhouse-cloud-incompatible/SKILL.md (or your agent's skills folder).
name
gorse-clickhouse-cloud-incompatible
description
Fix Gorse recommendation engine failing to connect to ClickHouse Cloud with EOF errors. Use when: (1) Gorse pods crash with "failed to connect data database" and "EOF" error, (2) Using ClickHouse Cloud (*.clickhouse.cloud) as Gorse data store, (3) TLS connection works (verified with openssl) but Gorse still fails, (4) Tried secure=true, different ports (8443, 9440), timeout params without success. The Gorse ClickHouse driver is incompatible with ClickHouse Cloud's native protocol.
author
Claude Code
version
1.0.0
date
2026-01-30

Gorse + ClickHouse Cloud Incompatibility

Problem

Gorse recommendation engine fails to connect to ClickHouse Cloud with EOF errors during protocol negotiation, even though TLS handshake succeeds.

Context / Trigger Conditions

  • Gorse master/server pods show CrashLoopBackOff
  • Logs show: failed to connect data database: EOF or transport failed to send a request to ClickHouse: EOF
  • Using ClickHouse Cloud (*.clickhouse.cloud) as the GORSE_DATA_STORE
  • TLS connection works when tested with openssl s_client
  • Tried various connection parameters without success

Root Cause

Despite the clickhouse:// URL scheme suggesting native protocol, Gorse actually uses the HTTP interface on port 8123 (not the native protocol on port 9000/9440). ClickHouse Cloud's HTTP interface on port 8443 has compatibility issues with Gorse's driver.

Key facts:

  • Gorse uses ClickHouse HTTP interface (port 8123), NOT native protocol (port 9000)
  • ClickHouse Cloud port 8443: HTTP/HTTPS protocol
  • ClickHouse Cloud port 9440: Native protocol with TLS
  • Gorse only accepts: clickhouse://, mysql://, postgres://, mongodb://
  • Gorse does NOT support https:// scheme (returns "unsupported data storage backend")
  • Redis is only for cache store, NOT data store
  • If you use port 9000 with in-cluster ClickHouse, you'll get: "Port 9000 is for clickhouse-client program. You must use port 8123 for HTTP."

Solution Options

Deploy ClickHouse Operator with an in-cluster instance for Gorse:

yaml
# Standard in-cluster connection works
GORSE_DATA_STORE: "clickhouse://user:password@clickhouse-host:8123/gorse"
Option 2: Use Different Database

Gorse supports MySQL and PostgreSQL as data stores:

yaml
GORSE_DATA_STORE: "mysql://user:password@host:3306/gorse"
# or
GORSE_DATA_STORE: "postgres://user:password@host:5432/gorse"
Option 3: Deploy ClickHouse Proxy

Set up a proxy (like chproxy) that translates between protocols.

Keep Gorse disabled and let the API fallback to popularity-based recommendations:

json
{"videos": [...], "source": "popular"}

Verification

After choosing a solution, check Gorse master logs:

bash
kubectl logs -l app=gorse-master -n gorse --tail=20

Should show successful connection instead of EOF errors.

Notes

  • The TLS layer works fine - the issue is at the ClickHouse protocol level
  • This may be fixed in future versions of the clickhouse-go driver
  • In-cluster ClickHouse doesn't have this issue because it uses plain connection on port 8123

© divinevideo, MPL-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .agents/skills/gorse-clickhouse-cloud-incompatible of divinevideo/divine-mobile.

Open the folder on GitHubat commit c3d6f7e

Compare with similar skills

Gorse Clickhouse Cloud Incompatible next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Gorse Clickhouse Cloud Incompatible compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Gorse Clickhouse Cloud Incompatible this skilldivinevideo/divine-mobile266—~810Automated safety check: PassMPL-2.0
Keeper Stress AnalysisClickHouse/ClickHouse50k—~4.7kAutomated safety check: PassApache-2.0
Perf ComparisonClickHouse/ClickHouse50k—~3.9kAutomated safety check: NotesApache-2.0
Patch Release CheckClickHouse/ClickHouse50k—~4kAutomated safety check: NotesApache-2.0
Clickhouse Architecture Advisorvemetric/vemetric3952 repos~791Automated safety check: PassApache-2.0
Decompress BinaryClickHouse/ClickHouse50k—~1.1kAutomated safety check: PassApache-2.0

Similar skills

  • Keeper Stress Analysis

    ClickHouse/ClickHouse

    Analyze ClickHouse Keeper stress-test results from play.clickhouse.com / keeperstresstests data warehouse.

    50k GitHub stars~4.7k tokensUpdated today
    DatabasesAuto-check passed
  • Perf Comparison

    ClickHouse/ClickHouse

    Evaluate ClickHouse performance test results from existing CI/dashboard data or local perf.py runs.

    50k GitHub stars~3.9k tokensUpdated today
    DatabasesAuto-check: notes
  • Patch Release Check

    ClickHouse/ClickHouse

    Check whether ClickHouse's supported versions (last 3 majors + latest LTS) have recent stable patch releases, diagnose why the scheduled AutoReleases pipeline failed, and identify which releases…

    50k GitHub stars~4k tokensUpdated today
    DatabasesAuto-check: notes
  • MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs.

    395 GitHub starsUsed in 2 repos~791 tokens
    DatabasesAuto-check passed
  • Decompress Binary

    ClickHouse/ClickHouse

    Extract the inner ELF from a ClickHouse self-extracting clickhouse binary, including when its architecture differs from the host (e.g.

    50k GitHub stars~1.1k tokensUpdated today
    DatabasesAuto-check passed
  • Good PRs

    ClickHouse/ClickHouse

    Show a report of open ClickHouse PRs whose only non-green CI check is "CH Inc sync" (or that are fully green) — i.e.

    50k GitHub stars~1.8k tokensUpdated today
    DatabasesAuto-check passed

More from divinevideo/divine-mobile

All 103 skills in this repo
  • Fix ArgoCD ExternalSecret deployment failing with "namespace X is not permitted in project Y".

    266 GitHub stars~931 tokensUpdated today
    Auto-check passed
  • Art Direct

    divinevideo/divine-mobile

    Art direction for any content — reads text, PDF, Word, HTML, PPT, then proposes 2-3 creative directions with photography style, mood, and visual language.

    266 GitHub stars~4.8k tokensUpdated today
    Auto-check passed
  • Async Await Null Race Condition

    divinevideo/divine-mobile

    Fix "Null check operator used on a null value" errors when an object is set to null during an async await.

    266 GitHub stars~881 tokensUpdated today
    Auto-check passed
  • AWS V4 Signing Custom Headers Gcs

    divinevideo/divine-mobile

    Add custom metadata headers (x-amz-meta-) to AWS v4 signed requests for GCS S3-compatible API.

    266 GitHub stars~1k tokensUpdated today
    Auto-check passed
  • Bash Herestring Newline Secrets

    divinevideo/divine-mobile

    Fix password/secret authentication failures caused by trailing newlines when creating Google Cloud secrets (or similar) with bash here-strings.

    266 GitHub stars~791 tokensUpdated today
    Auto-check passed
  • Fix silent video/media processing failures caused by URL extraction code that filters on file extensions (.mp4, .webm, .webp).

    266 GitHub stars~1.1k tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Gorse Clickhouse Cloud Incompatible

What does Gorse Clickhouse Cloud Incompatible do?

Fix Gorse recommendation engine failing to connect to ClickHouse Cloud with EOF errors. Gorse Clickhouse Cloud Incompatible is an agent skill from divinevideo/divine-mobile. Fix Gorse recommendation engine failing to connect to ClickHouse Cloud with EOF errors.

When should I use Gorse Clickhouse Cloud Incompatible?

Gorse Clickhouse Cloud Incompatible fits situations like: gorse pods crash with failed to connect data database and EOF error; using ClickHouse Cloud (.clickhouse.cloud) as Gorse data store; TLS connection works (verified with openssl) but Gorse still fails; tried secure=true.

How do I install Gorse Clickhouse Cloud Incompatible in Claude Code?

Run `npx skills add divinevideo/divine-mobile --skill gorse-clickhouse-cloud-incompatible -a claude-code`. Or copy the skill folder (.agents/skills/gorse-clickhouse-cloud-incompatible in divinevideo/divine-mobile) into .claude/skills/gorse-clickhouse-cloud-incompatible in your project. Claude Code loads it when a task matches its description.

How do I install Gorse Clickhouse Cloud Incompatible in Codex?

Run `npx skills add divinevideo/divine-mobile --skill gorse-clickhouse-cloud-incompatible -a codex`. Or copy the skill folder (.agents/skills/gorse-clickhouse-cloud-incompatible in divinevideo/divine-mobile) into .agents/skills/gorse-clickhouse-cloud-incompatible in your project. Codex loads it when a task matches its description.

Can I use Gorse Clickhouse Cloud Incompatible in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add divinevideo/divine-mobile --skill gorse-clickhouse-cloud-incompatible -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/gorse-clickhouse-cloud-incompatible, .gemini/skills/gorse-clickhouse-cloud-incompatible, .github/skills/gorse-clickhouse-cloud-incompatible and .opencode/skills/gorse-clickhouse-cloud-incompatible in your project.

What does Gorse Clickhouse Cloud Incompatible need to run?

Going by SKILL.md and its folder, Gorse Clickhouse Cloud Incompatible needs the command-line tools its instructions call (kubectl).

Does Gorse Clickhouse Cloud Incompatible access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Gorse Clickhouse Cloud Incompatible safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Gorse Clickhouse Cloud Incompatible use?

Gorse Clickhouse Cloud Incompatible is published under the MPL-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Gorse Clickhouse Cloud Incompatible use?

About 810 tokens (SKILL.md is roughly 3.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Gorse Clickhouse Cloud Incompatible?

Skills that share tags, products or a category with Gorse Clickhouse Cloud Incompatible: Keeper Stress Analysis (ClickHouse/ClickHouse, 50k stars), Perf Comparison (ClickHouse/ClickHouse, 50k stars), Patch Release Check (ClickHouse/ClickHouse, 50k stars) and Clickhouse Architecture Advisor (vemetric/vemetric, 395 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Gorse Clickhouse Cloud Incompatible?

divinevideo (a GitHub organization) maintains it in divinevideo/divine-mobile, which has 266 GitHub stars. The repository holds 103 skills in this directory. The repository was last updated on October 10, 2026.

Source: divinevideo/divine-mobile on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.