Design optimal ClickHouse schemas with MergeTree engines, ingest data at scale via Node.js/Python clients, run analytical queries, optimize performance and costs, secure deployments with RBAC and quotas, integrate CI/CD testing and monitoring, troubleshoot errors/incidents, and manage migrations/upgrades for production analytics workloads.
Configure ClickHouse enterprise RBAC — SQL-based users, roles, row policies, column-level grants, and quota management. Use when setting up multi-user access control, implementing tenant isolation, or configuring enterprise security for ClickHouse. Trigger: "clickhouse RBAC", "clickhouse roles", "clickhouse permissions", "clickhouse row policy", "clickhouse enterprise access", "clickhouse GRANT".
Create your first ClickHouse table, insert data, and run analytical queries. Use when starting a new ClickHouse project, learning MergeTree basics, or testing your ClickHouse connection with real operations. Trigger: "clickhouse hello world", "first clickhouse table", "clickhouse quick start", "create clickhouse table", "clickhouse example".
ClickHouse incident response — triage, diagnose, and remediate server issues using system tables, kill stuck queries, and execute recovery procedures. Use when ClickHouse is slow, unresponsive, or producing errors in production. Trigger: "clickhouse incident", "clickhouse outage", "clickhouse down", "clickhouse emergency", "clickhouse on-call", "clickhouse broken".
Install @clickhouse/client and configure authentication to ClickHouse Cloud or self-hosted. Use when setting up a new ClickHouse project, configuring connection strings, or initializing the official Node.js client. Trigger: "install clickhouse", "setup clickhouse client", "clickhouse auth", "connect to clickhouse", "clickhouse credentials".
Run ClickHouse locally with Docker, configure test fixtures, and iterate fast. Use when setting up a local ClickHouse dev environment, writing integration tests, or running ClickHouse in Docker Compose. Trigger: "clickhouse local dev", "clickhouse docker", "clickhouse dev environment", "run clickhouse locally", "clickhouse docker compose".
Own this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimOwn this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimBased on adoption, maintenance, documentation, and repository signals. Not a security audit or endorsement.
416 plugins, 2,574 skills, 154 agents, 16 community contributors — validated and ready to install.
pnpm add -g @intentsolutionsio/ccpi # Install the CLI
ccpi install devops-automation-pack # Install any plugin
Or use Claude's built-in command:
/plugin marketplace add jeremylongshore/claude-code-plugins
Browse the marketplace | Explore plugins | Download bundles
Killer Skill of the Week — token-optimizer by Alex Greenshpun (@alexgreensh)
Ghost tokens eat your context. Find them. Fix them. Prevent rot.
Claude gets measurably dumber as your context fills. Compaction destroys 60-70% of your conversation. Ghost tokens burn through your rate limits on every message. Token Optimizer tracks all of it: live quality scoring on your status line, smart compaction that saves your decisions before they're lost, full analytics dashboard with per-session cost breakdowns, and 6 parallel audit agents that optimize your entire setup. Not a one-time scan. An ongoing intelligence layer for your Claude Code workflow.
"My Claude Code kept leaking tokens. So I built this. Now my limits last longer, context stays fresh, and I have full visibility and control over my usage & setup." — Alex Greenshpun
Grade: A | Week of March 23, 2026 | Install from GitHub
Previous picks: executive-assistant-skills, skill-creator, cursor-pack, crypto-portfolio-tracker. See all at tonsofskills.com.
Option 1: CLI (Recommended)
pnpm add -g @intentsolutionsio/ccpi
ccpi search devops # Find plugins by keyword
ccpi install devops-automation-pack
ccpi list --installed # See what's installed
ccpi update # Pull latest versions
Option 2: Claude Built-in Commands
/plugin marketplace add jeremylongshore/claude-code-plugins
/plugin install devops-automation-pack@claude-code-plugins-plus
Already using an older install? Run
/plugin marketplace remove claude-code-pluginsand re-add with the command above to switch to the new slug.
Browse the catalog: Visit tonsofskills.com or explore plugins/
Agent Skills are instruction files (SKILL.md) that teach Claude Code when and how to perform specific tasks. Unlike commands that require explicit /slash triggers, skills activate automatically when Claude detects relevant conversation context.
1. INSTALL /plugin install ansible-playbook-creator@claude-code-plugins-plus
2. STARTUP Claude reads SKILL.md frontmatter → learns trigger phrases
3. ACTIVATE You say "create an ansible playbook for Apache"
4. EXECUTE Claude matches trigger → reads full skill → follows instructions
---
name: ansible-playbook-creator
description: |
Generate production-ready Ansible playbooks. Use when automating server
configuration or deployments. Trigger with "ansible playbook" or
"create playbook for [task]".
allowed-tools: Read, Write, Bash(ansible:*), Glob
version: 2.0.0
author: Jeremy Longshore <[email protected]>
license: MIT
---
# Ansible Playbook Creator
## Overview
Generates idempotent Ansible playbooks following infrastructure-as-code best practices.
## Instructions
1. Gather target host details and desired state
2. Select appropriate Ansible modules
3. Generate playbook with proper variable templating
4. Validate syntax with `ansible-lint`
## Output
- Complete playbook YAML ready for `ansible-playbook` execution
npx claudepluginhub jeremylongshore/claude-code-plugins-plus-skills --plugin clickhouse-packClaude Code skill pack for Hex (18 skills)
AI-powered contract review, risk analysis, document generation, and compliance auditing with 12 skills and 5 parallel agents
Claude Code skill pack for CoreWeave (24 skills)
Claude Code skill pack for StackBlitz (18 skills)
Claude Code skill pack for Together AI (18 skills)
28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact
Comprehensive operations manager for FairDB managed PostgreSQL service - SOPs, incident response, monitoring, and automation
Build ClickHouse tables with sub-second queries, 10x compression, and zero full table scans
Specialized assistance for the chmonitor dashboard - a real-time monitoring dashboard for ClickHouse clusters
SQL optimization, query tuning, and database performance expert for production systems
Create, connect, and interact with a Cloud SQL for PostgreSQL database and data.