28 ClickHouse best practices rules organized by schema design, query optimization, and data ingestion strategy.
Create detailed user stories, acceptance criteria, and feature specs
Example: Generate user stories for 'password reset feature' with acceptance criteria, edge cases, and test scenarios
Reduce spec writing time by 50%, ensure comprehensive coverage
Research competitors, compare features, identify gaps
Example: Analyze 5 competitor products, create feature comparison matrix, suggest differentiation opportunities
Complete competitive research in 2 hours instead of 2 days
Evaluate features using frameworks (RICE, ICE, Kano) and create prioritized backlogs
Example: Score 20 feature ideas using RICE framework, generate prioritized roadmap with rationale
Make data-driven prioritization decisions faster
Draft PRDs, status updates, and stakeholder presentations
Example: Create executive summary of Q3 roadmap, monthly progress report, feature launch announcement
Save 3-5 hours/week on communication overhead
Submit your Claude Code skill and start earning
epx add clickhouse/agent-skills --skill clickhouse-best-practicesCompatible with
Supported agents
Covers three critical areas: primary key and data type selection (immutable design decisions), JOIN and query optimization, and insert batching with mutation avoidance
Includes 28 rules prioritized by impact, with schema design and query optimization rules marked CRITICAL due to ClickHouse's columnar storage and sparse index mechanics
Provides structured review procedures f
AI-first code editor with Composer
Before installing skills in Cursor, ensure your development environment meets these requirements:
node --versionclickhouse-best-practicesExecute the skills CLI command in your project's root directory to begin installation:
epx add clickhouse/agent-skills --skill clickhouse-best-practicesFetches clickhouse-best-practices from clickhouse/agent-skills and configures it for Cursor.
The CLI shows a list of agents. Use arrow keys and space to select Cursor:
Confirm successful installation by checking the skill directory location:
.cursor/skills/clickhouse-best-practices
Restart Cursor to activate clickhouse-best-practices. Access via /clickhouse-best-practicesin your agent's command palette.
Learn more:View source on GitHubSkills CLI docsAbout CursorWhat are agent skills?
Time estimate: 30-60 minutes to see productivity improvements
Prerequisites
Steps
Common Pitfalls
✓ Do
✗ Don't
💡 Pro Tips
✓ Use when
Use for user story writing, competitive research, roadmap prioritization, stakeholder communication, and PRD drafting. Best for reducing repetitive documentation and research work.
✗ Avoid when
Avoid for strategic product vision (requires deep customer empathy), pricing decisions (needs market and financial expertise), or when face-to-face customer discovery is more valuable than speed.
grill-me
mattpocock/skills · Productivity · same category
nutritional-specialist
ailabs-393/ai-labs-claude-skills · Productivity · same category
travel-planner
ailabs-393/ai-labs-claude-skills · Productivity · same category
framer-motion
pproenca/dot-skills · Productivity · same category
reverse-engineering-tools
gmh5225/awesome-game-security · Productivity · same category
cmux-browser
manaflow-ai/cmux · Productivity · same category
I recommend clickhouse-best-practices for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.
I recommend clickhouse-best-practices for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.
Useful defaults in clickhouse-best-practices — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.
Keeps context tight: clickhouse-best-practices is the kind of skill you can hand to a new teammate without a long onboarding doc.
I recommend clickhouse-best-practices for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.
Keeps context tight: clickhouse-best-practices is the kind of skill you can hand to a new teammate without a long onboarding doc.
Useful defaults in clickhouse-best-practices — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.
clickhouse-best-practices has been reliable in day-to-day use. Documentation quality is above average for community skills.
clickhouse-best-practices reduced setup friction for our internal harness; good balance of opinion and flexibility.
Registry listing for clickhouse-best-practices matched our evaluation — installs cleanly and behaves as described in the markdown.
showing 1-10 of 42