Clickhouse Pack
Claude Code skill pack for ClickHouse (24 skills)
- Type
- Plugin
- Repository
- jeremylongshore/tons-of-skills-marketplace
- GitHub stars
- 2.8k
- License
- MIT
- Repo last updated
- Sep 27, 2026
- Version
- 1.7.0
- Author
- Jeremy Longshore
What Clickhouse Pack is
Clickhouse Pack is a plugin published in the jeremylongshore/tons-of-skills-marketplace repository on GitHub, which has about 2.8k stars. The repository describes itself as: “Model-agnostic agent-skills platform with a harness-free canonical layer, verified adapters, and the ccpi package manager. Explore at tonsofskills.com.”
A plugin is a package that bundles skills, slash commands, subagents, hooks, and MCP connectors so they install together. Plugins are plain files with a manifest at .claude-plugin/plugin.json, and they work in both Claude Code and Claude Cowork.
Installing Clickhouse Pack adds everything it ships in one step. Connectors inside a plugin still need to be connected separately, and hooks and subagents only run in Cowork and Claude Code, not in regular chat.
How to install Clickhouse Pack
Claude Code
- Add the repository as a plugin marketplace: claude plugin marketplace add jeremylongshore/tons-of-skills-marketplace
- Install the plugin: claude plugin install clickhouse-pack@<marketplace-name>, using the marketplace name from the repository's .claude-plugin/marketplace.json.
- Restart the session if the new skills or commands don't appear straight away.
Claude Cowork
- Open Customize → Plugins and choose Add marketplace.
- Enter jeremylongshore/tons-of-skills-marketplace (the owner/repo shorthand works for GitHub).
- Find Clickhouse Pack in the list, click Install, then connect any connectors it needs from its Connectors tab.
New to extending Cowork? Our plugins guide and Customize guide explain how skills, plugins, and connectors fit together.
Inside the source file
An excerpt from plugins/saas-packs/clickhouse-pack/.claude-plugin/plugin.json, shared under the repository's MIT license. Read the full file on GitHub.
> 24 skills for building, operating, and scaling ClickHouse-powered analytics — real @clickhouse/client code, real SQL, real MergeTree engines.
Every skill uses the official ClickHouse Node.js client (@clickhouse/client with createClient), actual ClickHouse SQL syntax (MergeTree, ReplacingMergeTree, AggregatingMergeTree), real system tables (system.parts, system.query_log, system.merges), and production patterns (parameterized queries, streaming inserts, materialized views).
Links: tonsofskills.com | ClickHouse Docs | @clickhouse/client
Installation
/plugin install clickhouse-pack@claude-code-plugins-plusSkills (24)
Standard Skills (S01-S12)
Pro Skills (P13-P18)
Flagship Skills (F19-F24)
What Makes This Different
These are not generic SaaS API wrappers. Every skill is built from actual ClickHouse documentation and real-world patterns:
- Real imports: import { createClient } from '@clickhouse/client' (the official client)
- Real SQL: ENGINE = MergeTree() ORDER BY (tenant_id, event_type, created_at) PARTITION BY toYYYYMM(created_at)
- Real system tables: system.parts, system.query_log, system.merges, system.mutations
- Real error codes: 252 (TOO_MANY_PARTS), 241 (MEMORY_LIMIT_EXCEEDED), 62 (SYNTAX_ERROR)
- Real patterns: Streaming inserts with backpressure, materialized views with AggregateFunction states, parameterized queries with {name:Type} syntax
License
MIT
Before you install
- Read the whole file first. Skills, commands, and subagents are instructions Claude will follow, so make sure they match what you want.
- Check which tools, scripts, or MCP servers it uses. Local servers and scripts run with your permissions.
- Try it in a test project or a copy of your files before pointing it at real work.
- Pin the version you tested, and review changes before updating.
- Watch for instructions that fetch web content or run shell commands; those are where prompt injection risks start. See our prompt injection guide.
FAQ
What is Clickhouse Pack?
Clickhouse Pack is a plugin for Claude Code and Claude Cowork from the jeremylongshore/tons-of-skills-marketplace repository on GitHub. Claude Code skill pack for ClickHouse (24 skills)
How do I install Clickhouse Pack in Claude Code?
Add the repository as a plugin marketplace: claude plugin marketplace add jeremylongshore/tons-of-skills-marketplace Install the plugin: claude plugin install clickhouse-pack@<marketplace-name>, using the marketplace name from the repository's .claude-plugin/marketplace.json. Restart the session if the new skills or commands don't appear straight away.
Can I use Clickhouse Pack in Claude Cowork?
Open Customize → Plugins and choose Add marketplace. Enter jeremylongshore/tons-of-skills-marketplace (the owner/repo shorthand works for GitHub). Find Clickhouse Pack in the list, click Install, then connect any connectors it needs from its Connectors tab.
Is Clickhouse Pack safe to install?
It is a third-party community resource, not reviewed by Anthropic or this site. Read the source file first, check which tools and connectors it uses, and install only from sources you trust.
Similar resources
- Allpurpose Agent Implements code for any technology stack strictly from sprint spec files, then returns a structured IMPLEMENTATION REPORT with conformity status and deviations. Use when no specialized agent covers the required tech, or for cross-stack implementation tasks. Trigger with "implement sprint task", "build from specs". Subagent · jeremylongshore/tons-of-skills-marketplace
- Analyze Chain Comprehensive blockchain metrics monitoring and on-chain analytics system Slash Command · jeremylongshore/tons-of-skills-marketplace
- Ai Sdk Agents Multi-agent orchestration with AI SDK v5 - handoffs, routing, and coordination for any AI provider (OpenAI, Anthropic, Google) Plugin · jeremylongshore/tons-of-skills-marketplace
- Algolia Pack Algolia search integration pack with 24 operator skills Plugin · jeremylongshore/tons-of-skills-marketplace
- Clickup Pack Production-grade Claude Code operator workflows for governed ClickUp integrations (24 skills) Plugin · jeremylongshore/tons-of-skills-marketplace
- Cli Ux Tester Expert UX evaluator for command-line interfaces, CLIs, terminal tools, shell scripts, and developer APIs Plugin · jeremylongshore/tons-of-skills-marketplace
- Cloud Cost Optimizer Optimize cloud costs and generate cost reports Plugin · jeremylongshore/tons-of-skills-marketplace
- Cli Power Skills Agentic CLI tool skills for Claude Code — 7 domain-grouped skills covering 26 CLI tools Plugin · jeremylongshore/tons-of-skills-marketplace