clickhouse avatar

Clickhousectl Local Dev

Walks you through spinning up ClickHouse locally from zero to working tables. Installs clickhousectl, downloads the binary, starts a background server in your project directory, and sets up a folder structure for tables, materialized views, and seed data. Covers the full init flow including schema application and verification queries. Good for when you need an analytical database locally and want the opinionated happy path instead of reading docs. The step-by-step is thorough enough that you won't get stuck on PATH issues or wonder where your data lives.

skills.sh installs
4.5K
GitHub stars
565
last updated
Aug 21, 2026

Install

$ npx -y skills add clickhouse/agent-skills --skill clickhousectl-local-dev --agent claude-code

Installs into .claude/skills of the current project.

Files

Walks you through spinning up ClickHouse locally from zero to working tables. Installs clickhousectl, downloads the binary, starts a background server in your project directory, and sets up a folder structure for tables, materialized views, and seed data. Covers the full init flow including schema application and verification queries. Good for when you need an analytical database locally and want the opinionated happy path instead of reading docs. The step-by-step is thorough enough that you won't get stuck on PATH issues or wonder where your data lives.

Browse the repository on GitHub

Sponsors

Details

Repository
github.com/clickhouse/agent-skills
Categories
Backend & APIs, DevOps & CI/CD, AI & Agent Building, Databases
First seen
May 16, 2026

More from clickhouse/agent-skills

All 10
1jeffallan avatarmcp-developerjeffallan/claude-skillsUse when building, debugging, or extending MCP servers or clients that connect AI systems with external tools and data sources. Invoke to implement tool handler4.4Kskills.sh installs
2medusajs avatarbuilding-storefrontsmedusajs/medusa-agent-skillsLoad automatically when planning, researching, or implementing Medusa storefront features (calling custom API routes, SDK integration, React Query patterns, dat4.4Kskills.sh installs
3giuseppe-trisciuoglio avatartypescript-docsgiuseppe-trisciuoglio/developer-kitGenerates comprehensive TypeScript documentation using JSDoc, TypeDoc, and multi-layered documentation patterns for different audiences. Use when creating API d4.4Kskills.sh installs
4getsentry avatargh-review-requestsgetsentry/skillsFetch unread GitHub notifications for open PRs where review is requested from a specified team or opened by a team member. Use when asked to "find PRs I need to4.3Kskills.sh installs
5starchild-ai-agent avatarcomposiostarchild-ai-agent/official-skillsComposio gateway: act on 1000+ connected apps like Gmail, Slack, GitHub, Calendar. Use when the user wants to act in a connected SaaS app (e.g. send Gmail, crea4.3Kskills.sh installs
6dpearson2699 avatarswiftui-liquid-glassdpearson2699/swift-ios-skillsImplement, review, or improve SwiftUI Liquid Glass effects for iOS 26+. Covers glassEffect modifier, GlassEffectContainer, glass button styles, glass toolbar/ta4.3Kskills.sh installs