skills.rest
OpenRouterTeam
OpenRouterTeamOFFICIAL
Explore all skills by this author →
Website𝕏@openrouterGitHub

seed-activity-explorer-data

Seeds deterministic ClickHouse usage data for Activity Explorer verification.

7|12|Updated Mar 26, 2026
Search Tags:#testing#analytics#seed data#local development#clerk#clickhouse#activity explorer
One-click install
npx skills add https://github.com/OpenRouterTeam/docs --skill seed-activity-explorer-data-openrouterteam
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: seed-activity-explorer-data
Source: https://github.com/OpenRouterTeam/docs/tree/main/.agents/skills/seed-activity-explorer-data
Command: npx skills add https://github.com/OpenRouterTeam/docs --skill seed-activity-explorer-data-openrouterteam

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? A fresh local development stack shows no activity on the Activity pages because ClickHouse contains no usage rows, making it impossible to verify Activity Explorer features like top-N charts, Other buckets, granularity rollups, and CSV exports. ## Core Features & Use Cases - Deterministic Seeding: Generates predictable usage data for a specific Clerk user and workspace with configurable date ranges, model counts, and empty days. - Scoped Re-runs: Clears only the selected user, workspace, and past date window before inserting, so re-seeding never duplicates rows or touches current-day data. - Verification Guidance: Documents ClickHouse query traps (DateTime offsets, 35-day TTL), server-side analytics caching, and UI verification steps for the Activity Explorer. - Use Case: After starting the local stack, seed 15 models across a date range with designated empty days, then confirm the chart's top-N and Other buckets, aggregate table statistics, and CSV export behave as expected. ## Quick Start Ask the assistant to seed deterministic Activity Explorer data for your Clerk user and workspace over a chosen date range, then verify the results at /activity/explore.

Frequently Asked Questions about seed-activity-explorer-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I seed ClickHouse activity data for local development?▼

Run the committed seeder from packages/clickhouse with bun run x scripts/seed-user-activity.ts, passing your Clerk user ID, workspace ID, date range, and model count. Set CLICKHOUSE_URL and Postgres connection environment variables first.

Why does my Activity Explorer show no data after seeding?▼

The analytics response is cached server-side per user and query for 5 minutes, so freshly seeded numbers can look stale. Wait out the TTL or change a control like the Top selector to force a cache miss.

Is the deterministic seed command safe to re-run?▼

Yes, it clears only the selected user's workspace and the requested past date window before inserting, so re-runs never duplicate rows. Today and later dates are never cleared, preserving current-day data.

Why does my ClickHouse count query miss the final day?▼

In user_activity_minute_v7 the date column is a DateTime with a minute offset, so date <= 'YYYY-MM-DD' silently drops the last day. Use date < '<toDate + 1 day>' instead; the daily table uses a real Date.

What are the limitations of the legacy no-argument seed path?▼

The no-argument path seeds every user over a full year and can exhaust a small local ClickHouse, hitting memory limit errors. It only appends rows, so prefer the scoped deterministic command for feature tests.

Related Skills

Explore More Software Engineering Skills→
domhhvdomhhv
3

clerk-testing

Automate Clerk authentication flow testing with Playwright or Cypress.

Community
Intermediate
rappdwrappdw

synthdata-compute

Transforms xlsx, csv, or json datasets into aggregated or scored tables.

Community
Advanced
khetansarveshkhetansarvesh
1

clickhouse-io

Guide ClickHouse schema design, query writing, ingestion, and aggregation workflows.

Community
Intermediate
JsplixJsplix

ibank-worklog-enrichment

Generate iBank worklog tag, evaluation, and skill seed data with referential integrity.

Community
Advanced