← all publishers

obsessiondb

@obsessiondb source repo

Report this profile Claim this profile

• 12 skills
• 0 followers
• 16 hours ago last updated

1. ▌
   Clickhouse Schema Design · obsessiondb

   15+ schema rules for ClickHouse tables. ALWAYS LOAD when creating or modifying tables. Achieves sub-second queries, 10x compression, and automated data lifecycle.
   0
   installs
2. ▌
   Clickhouse Materialized Views · obsessiondb

   10+ patterns for ClickHouse Materialized Views. Load when creating MVs for real-time aggregation, data transformation, or query optimization. Covers SummingMergeTree, AggregatingMergeTree, and common pitfalls.
   0
   installs
3. ▌
   Clickhouse Query Optimization · obsessiondb

   20+ optimization rules for ClickHouse queries. Load when writing queries, debugging slow queries, fixing memory errors, or optimizing JOINs. Achieves 10-100x faster queries, 90% less memory usage.
   0
   installs
4. ▌
   Chkit · obsessiondb

   ClickHouse schema management with chkit. Use when working with chkit CLI commands, ClickHouse table/view/materialized view definitions, migration generation, drift detection, or clickhouse.config.ts files. Trigger on chkit commands, @chkit/core imports, or schema definition tasks.
   0
   installs
5. ▌
   Pr Creation · obsessiondb

   Use when creating a pull request. Ensures changesets are created for user-facing changes, verification passes, and PR metadata is correct. Invoke this skill BEFORE committing or pushing PR code.
   0
   installs
6. ▌
   Testing Bun · obsessiondb

   CRITICAL - Invoke before writing or modifying tests in this repo. Use for `bun:test` test files, new test cases, and test refactors. Enforces no try/catch in positive tests, no early returns, and no hidden skips.
   0
   installs
7. ▌
   Library Docs · obsessiondb

   Fetch real-time, official library docs instead of relying on stale memory. Use whenever implementing against external libraries/frameworks/packages.
   0
   installs
8. ▌
   Code Architecture · obsessiondb

   Code architecture patterns for this monorepo. Use when organizing code, refactoring modules, designing service structure, or extracting/moving code to new files. Enforces clean function ordering, service functions over classes, and explicit dependency injection.
   0
   installs
9. ▌
   Typescript Standards · obsessiondb

   TypeScript coding standards for this monorepo. Use when writing/refactoring/reviewing TypeScript.
   0
   installs
10. ▌
    Environment Variables · obsessiondb

    Environment variable management for this monorepo. Use when adding new env vars/secrets, debugging missing env errors, CI mismatches, or Turborepo env passthrough issues.
    0
    installs
11. ▌
    Documentation Authoring · obsessiondb bundle

    You are assisting with documentation authoring for the chkit docs site. Use this skill whenever the user wants to create, edit, reorganize, move, or delete documentation pages for chkit. Trigger this skill when the user mentions docs, documentation, doc pages, the docs site, writing guides, updating CLI references, or any work involving files in apps/docs/. Also trigger when the user asks about the docs site structure, how pages are organized, or how to add content to the chkit website.
    0
    installs
12. ▌
    Clickhouse Query · obsessiondb bundle

    Query ClickHouse databases using the chcli CLI tool. Use when the user wants to run SQL queries against ClickHouse, explore database schemas, inspect tables, or extract data from ClickHouse.
    0
    installs