公开记录中等
软件健康报告模式 0.27.0 · 指标 1.13.0 · 2026-07-23 00:33 UTC
obsessiondb / chkit
ClickHouse schema and migration CLI for TypeScript projects
obsessiondb/chkit 的健康指数为 100 分中的 58 分，处于「中等」区间。 其得分最高的类别是Engineering Quality（86/100），最低的是Security（46/100）。 最近一次更新在 2 天前。 近期的大部分工作由 1 位贡献者完成。
58
总分 / 100软件健康指数
指标归入加权类别，统一采用 1–100 量表。总体分先取类别加权平均；当公开证据触发高风险司法辖区政策时，评级会按政策调整，并设置 49（有风险）的上限。AI 就绪度不计入总体分。
58
优秀85-100堪称典范；基本满足所有检验标准
良好70-84健康；仅有轻微不足
中等50-69可接受，但存在明显不足；建议进行审查
存在风险30-49存在重大薄弱环节；采用时应保持审慎
危急1-29问题严重（项目被弃置、仅有单一维护者、缺乏基本工程规范）
评分画像
每条轴代表一个类别。形状比平均值更重要——健康的对象会填满整个图形，而“一峰一谷”式画像意味着某一维度的优势正掩盖另一维度的风险。
所有权
软件包生态系统
| 注册表 | 软件包 | 版本 | 月下载量 | 版本数 | 最近发布 | 标签 |
|---|---|---|---|---|---|---|
| npm | chkit | 0.1.2-beta.5 | 2,708 | 32 | 5 天前 | clickhouseschemamigrationstypescriptdatabasecli |
| npm | @chkit/core | 0.1.2-beta.5 | 3,803 | 37 | 5 天前 | clickhouseschemamigrationstypescriptdatabase |
| npm | @chkit/codegen | 0.1.2-beta.5 | 3,169 | 36 | 5 天前 | clickhousecodegenmigrations |
| npm | @chkit/clickhouse | 0.1.2-beta.5 | 3,991 | 37 | 5 天前 | clickhousedatabaseclient |
| npm | @chkit/plugin-pull | 0.1.2-beta.5 | 3,358 | 36 | 5 天前 | clickhouseintrospectionschemachkit-plugin |
| npm | create-chkit | 0.1.2-beta.5 | 1,279 | 11 | 5 天前 | clickhouseschemamigrationstypescriptscaffoldcreatechkit |
| npm | @chkit/plugin-codegen | 0.1.2-beta.5 | 3,143 | 33 | 5 天前 | clickhousetypescriptcodegenzodchkit-plugin |
| npm | @chkit/plugin-backfill | 0.1.2-beta.5 | 2,715 | 36 | 5 天前 | clickhousebackfilldata-migrationchkit-plugin |
按类别列示的指标
活力
项目是否仍有生命——是否仍在编写代码，是否仍在发布版本？
47
开发活跃度
78良好
评分方式
| 36/36 | 推送新近度 — 最近一次推送于 2 天前 |
| 14.5/36 | 提交节奏 — 52 周中有 21 周有提交 |
| 18/18 | 提交量 — 最近一年 297 次提交 |
| 10/10 | OpenSSF Scorecard：Maintained — 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10 |
所用输入
| commits_last_year | 297 |
| human_commit_share | 1 |
| days_since_last_push | 2 |
| active_weeks_last_year | 21 |
发布纪律
1危急
评分方式
| 0/27 | 有发布版本 — 未发布任何发布版本 |
| 0/36 | 发布时效 — 没有发布版本 |
| 0/27 | 发布节奏 — 没有发布版本 |
| 0/10 | OpenSSF Scorecard：Signed-Releases — 无数据 |
所用输入
| releases_count | 0 |
已排除计分（无数据或不适用）：OpenSSF Scorecard：Signed-Releases。 其余权重已重新归一化。
社区与采用
项目是否拥有用户、下载量与关注度，并具备欢迎贡献者参与的配置？
56
流行度与采用
21危急
评分方式
| 21.1/60 | 星标 — 21 个星标 |
| 0/25 | 复刻 — 2 个复刻 |
| 0/15 | 关注者 — 0 位关注者 |
所用输入
| forks | 2 |
| stars | 21 |
| watchers | 0 |
| growth_state | unverified |
| growth_factor_pct | 100 |
| growth_unverified_reason | no_history |
社区健康
85优秀
评分方式
| 22.5/22.5 | README |
| 22.5/22.5 | 许可证 — 可识别的许可证（MIT） |
| 18/18 | CONTRIBUTING 指南 |
| 13.5/13.5 | 行为准则 |
| 0/7.2 | 议题模板 |
| 0/6.3 | PR 模板 |
所用输入
| has_readme | 是 |
| has_license | 是 |
| has_contributing | 是 |
| has_issue_template | 否 |
| has_code_of_conduct | 是 |
| has_pull_request_template | 否 |
生态采用（下载量）
73良好
评分方式
| 58.4/80 | 月度下载量 — npm 合计每月 24,166 次下载 |
| 0/20 | 注册表被依赖数 — 该生态系统不报告此项 |
所用输入
| packages | chkit, @chkit/core, @chkit/codegen, @chkit/clickhouse, @chkit/plugin-pull, create-chkit, @chkit/plugin-codegen, @chkit/plugin-backfill |
| dependents | — |
| ecosystems | npm |
| total_downloads | — |
| monthly_downloads | 24,166 |
已排除计分（无数据或不适用）：注册表被依赖数。 其余权重已重新归一化。
可持续性与治理
项目能否在其成员之外延续——巴士系数、响应能力、由谁支持，以及软件包的维护状况？
55
维护者韧性（巴士系数）
26危急
评分方式
| 9/54 | 巴士系数 — 1 位贡献者贡献了半数提交 |
| 2.5/22.5 | 提交分布 — 头号贡献者编写了 89% 的提交 |
| 4.1/13.5 | 贡献者广度 — 3 位贡献者 |
| 10/10 | OpenSSF Scorecard：Contributors — project has 5 contributing companies or organizations |
所用输入
| bus_factor | 1 |
| contributors_sampled | 3 |
| top_contributor_share | 0.889 |
议题与 PR 响应能力
63中等
评分方式
| 27.3/46.8 | 议题解决 — 58% 的议题已关闭 |
| 36/38.3 | PR 接受 — 已裁定的 PR 中 174/185 已合并 |
| 0/15 | OpenSSF Scorecard：Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
所用输入
| merged_prs | 174 |
| open_issues | 5 |
| closed_issues | 7 |
| issue_closed_ratio | 0.583 |
| closed_unmerged_prs | 11 |
所有权与托管责任
44存在风险
评分方式
| 30/30 | 所有权背书 — 组织持有 |
| 0/20 | 已验证域名 |
| 7.8/25 | 所有者影响力 — obsessiondb 有 11 位关注者 |
| 6.7/25 | 既往记录 — 5 个公开仓库，账户约 0 年 |
所用输入
| followers | 11 |
| owner_type | Organization |
| is_verified | — |
| owner_login | obsessiondb |
| public_repos | 5 |
| account_age_days | 181 |
软件包维护
100优秀
评分方式
| 25/25 | 已发布且可解析 — npm 上有 8 个软件包 |
| 35/35 | 发布时效 — 最近一次发布于 5 天前 |
| 20/20 | 版本历史 — 37 个已发布版本 |
| 20/20 | 未被弃用 — 活跃，未被弃用或撤回 |
所用输入
| packages | chkit, @chkit/core, @chkit/codegen, @chkit/clickhouse, @chkit/plugin-pull, create-chkit, @chkit/plugin-codegen, @chkit/plugin-backfill |
| ecosystems | npm |
| any_deprecated | 否 |
| min_days_since_publish | 5 |
工程质量
基础的工程与文档实践是否到位？
86
工程实践
84良好
评分方式
| 24/24 | CI 工作流 — 1 个工作流 |
| 24/24 | 存在测试 |
| 16/16 | Linter 配置 — biome.json |
| 0/9.6 | Pre-commit 钩子 |
| 0/6.4 | .editorconfig |
| 20/20 | OpenSSF Scorecard：CI-Tests — 20 out of 20 merged PRs checked by a CI test -- score normalized to 10 |
所用输入
| has_ci | 是 |
| has_tests | 是 |
| has_editorconfig | 否 |
| has_linter_config | 是 |
| has_precommit_config | 否 |
文档
90优秀
评分方式
| 30/30 | README |
| 25/25 | 文档目录 |
| 15/15 | 文档 / 主页站点 — https://chkit.obsessiondb.com |
| 10/10 | 仓库描述 |
| 10/10 | 主题标签 — 7 个主题标签 |
| 0/10 | Wiki |
所用输入
| topics | cli, clickhouse, clickhouse-migrations, database, migrations, schema, typescript |
| has_wiki | 否 |
| homepage | https://chkit.obsessiondb.com |
| has_readme | 是 |
| has_docs_dir | 是 |
| has_description | 是 |
安全
可见的安全与供应链实践是否稳固，且不存在未解决的高风险司法辖区暴露？
46
安全态势
46存在风险
评分方式
| 7.5/7.5 | Binary-Artifacts — no binaries found in the repo |
| 0/7.5 | Branch-Protection — branch protection not enabled on development/release branches |
| 2.5/2.5 | CI-Tests — 20 out of 20 merged PRs checked by a CI test -- score normalized to 10 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 0/7.5 | Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
| 2.5/2.5 | Contributors — project has 5 contributing companies or organizations |
| 10/10 | Dangerous-Workflow — no dangerous workflow patterns detected |
| 0/7.5 | Dependency-Update-Tool — no update tool detected |
| 0/5 | Fuzzing — project is not fuzzed |
| 2.5/2.5 | 许可证 — license file detected |
| 7.5/7.5 | Maintained — 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10 |
| 0/5 | Packaging — 无数据 |
| 0/5 | Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
| 5/5 | SAST — SAST tool is run on all commits |
| 5/5 | Security-Policy — security policy file detected |
| 0/7.5 | Signed-Releases — 无数据 |
| 0/7.5 | Token-Permissions — detected GitHub workflow tokens with excessive permissions |
| 0/7.5 | Vulnerabilities — 51 existing vulnerabilities detected |
所用输入
| source | openssf_scorecard |
| checks_evaluated | 16 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 2 |
| scorecard_aggregate | 4.6 |
已排除计分（无数据或不适用）：packaging, signed_releases。 其余权重已重新归一化。
AI 就绪度
该仓库在多大程度上具备与 AI 编码代理协同开发与维护的条件？这是一枚独立的实验性徽章——权重为 0.0，因此单独呈现，不影响总体健康评分。
72
AI 代理上下文与指引
85优秀
评分方式
| 45/45 | 代理指令 — CLAUDE.md |
| 0/15 | 机器可读文档（llms.txt） |
| 40/40 | 可读的提交历史 — 100 次人类提交中有 92 次说明了意图（结构化标题或解释性正文） |
所用输入
| has_llms_txt | 否 |
| legible_history_share | 0.92 |
| agent_instruction_files | CLAUDE.md |
| agent_instruction_max_bytes | 4,596 |
评分方式
| 0/18 | 一条命令的引导启动 |
| 22/22 | 自动化测试 |
| 11/11 | Lint / 格式化配置 — biome.json |
| 11/11 | 静态类型检查 — apps/docs/tsconfig.json, packages/cli/tsconfig.json, packages/clickhouse/tsconfig.json, packages/codegen/tsconfig.json, packages/core/tsconfig.json, packages/create-chkit/tsconfig.json, packages/plugin-backfill/tsconfig.json, packages/plugin-codegen/tsconfig.json, packages/plugin-obsessiondb/tsconfig.json, packages/plugin-pull/tsconfig.json, tsconfig.json |
| 10/10 | 可复现环境 — Dockerfile |
| 10/10 | 已体现的代理实践 — 最近 100 次提交中有 17 次由代理编写或署名代理 |
| 0/8 | 自动化维护 — 未观察到自动依赖更新 |
| 0/10 | OpenSSF Scorecard：Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
所用输入
| has_nix | 否 |
| has_tests | 是 |
| lockfiles | — |
| has_dockerfile | 是 |
| typed_language | 是 |
| bootstrap_files | — |
| has_devcontainer | 否 |
| has_linter_config | 是 |
| typecheck_configs | apps/docs/tsconfig.json, packages/cli/tsconfig.json, packages/clickhouse/tsconfig.json, packages/codegen/tsconfig.json, packages/core/tsconfig.json, packages/create-chkit/tsconfig.json, packages/plugin-backfill/tsconfig.json, packages/plugin-codegen/tsconfig.json, packages/plugin-obsessiondb/tsconfig.json, packages/plugin-pull/tsconfig.json, tsconfig.json |
| agent_commit_share | 0.17 |
| toolchain_manifests | — |
| dependency_bot_commit_share | 0 |
面向模型的代码可读性
100优秀
评分方式
| 45/45 | 可类型检查的代码 — TypeScript（静态类型） |
| 55/55 | 可控的文件大小 — 采样的 276 个源文件中有 0 个超过 60KB |
所用输入
| primary_language | TypeScript |
| largest_source_bytes | 56,670 |
| source_files_sampled | 276 |
| oversized_source_files | 0 |
机器可读接口
40存在风险
评分方式
| 0/40 | API 模式（OpenAPI/GraphQL/proto） |
| 0/20 | MCP 服务器 |
| 40/40 | 可运行示例 — examples |
所用输入
| example_dirs | examples |
| has_mcp_signal | 否 |
| api_schema_files | — |
关键数据
21GitHub 星标
3贡献者
297最近 12 个月提交数
2距最近推送天数
0发布版本数
1巴士系数（bus factor）
5开放议题
npm软件包生态系统数
数据采集警告
- Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
- GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository
- deps.dev does not index npm:chkit@0.1.2-beta.5; advisories assessed against the repository dependency graph instead
更多细节
Star 与 Fork 历史 0 ★ / 2 ⇿
0Star
2Fork
每颗 star 和每个 fork 的添加时间，来自 GitHub 并按天汇总。累计增长位于其构成来源——每日新增——的正上方，二者可相互对照：稳定的自然增长与短暂的突增形态截然不同。当这一差别可被衡量时，它会作为增长真实性予以报告。
OpenSSF Scorecard 4.6 / 10
4.6综合
来自开源项目 OpenSSF Scorecard 的独立、工具无关的安全评估。每项检查奖励的是安全实践本身，而非特定供应商的工具。Scorecard 无法判定的检查项标记为 不适用，并从安全评分中剔除（绝不按零分计）。
| 10 | Binary-Artifacts | no binaries found in the repo |
| 0 | Branch-Protection | branch protection not enabled on development/release branches |
| 10 | CI-Tests | 20 out of 20 merged PRs checked by a CI test -- score normalized to 10 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 0 | Code-Review | Found 0/30 approved changesets -- score normalized to 0 |
| 10 | Contributors | project has 5 contributing companies or organizations |
| 10 | Dangerous-Workflow | no dangerous workflow patterns detected |
| 0 | Dependency-Update-Tool | no update tool detected |
| 0 | Fuzzing | project is not fuzzed |
| 10 | License | license file detected |
| 10 | Maintained | 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10 |
| 不适用 | Packaging | packaging workflow not detected |
| 0 | Pinned-Dependencies | dependency not pinned by hash detected -- score normalized to 0 |
| 10 | SAST | SAST tool is run on all commits |
| 10 | Security-Policy | security policy file detected |
| 不适用 | Signed-Releases | no releases found |
| 0 | Token-Permissions | detected GitHub workflow tokens with excessive permissions |
| 0 | Vulnerabilities | 51 existing vulnerabilities detected |
直接依赖 33
| 注册表 | 软件包 | 版本约束 | 清单文件 |
|---|---|---|---|
| npm | fast-glob | ^3.3.2 | packages/cli/package.json |
| npm | @chkit/clickhouse | workspace:* | packages/cli/package.json |
| npm | @chkit/codegen | workspace:* | packages/cli/package.json |
| npm | @chkit/core | workspace:* | packages/cli/package.json |
| npm | @logtape/logtape | ^2.0.5 | packages/cli/package.json |
| npm | @chkit/core | workspace:* | packages/clickhouse/package.json |
| npm | @clickhouse/client | ^1.18.0 | packages/clickhouse/package.json |
| npm | @logtape/logtape | ^2.0.5 | packages/clickhouse/package.json |
| npm | p-retry | ^7.1.1 | packages/clickhouse/package.json |
| npm | @chkit/core | workspace:* | packages/codegen/package.json |
| npm | fast-glob | ^3.3.2 | packages/core/package.json |
| npm | jiti | ^2.7.0 | packages/core/package.json |
| npm | @chkit/plugin-obsessiondb | workspace:* | packages/create-chkit/package.json |
| npm | @clack/prompts | ^1.4.0 | packages/create-chkit/package.json |
| npm | commander | ^14.0.3 | packages/create-chkit/package.json |
| npm | giget | ^3.2.0 | packages/create-chkit/package.json |
| npm | picocolors | ^1.1.1 | packages/create-chkit/package.json |
| npm | @chkit/clickhouse | workspace:* | packages/plugin-backfill/package.json |
| npm | @chkit/core | workspace:* | packages/plugin-backfill/package.json |
| npm | @logtape/logtape | ^2.0.5 | packages/plugin-backfill/package.json |
| npm | p-map | ^7.0.4 | packages/plugin-backfill/package.json |
| npm | zod | ^4.3.6 | packages/plugin-backfill/package.json |
| npm | @chkit/core | workspace:* | packages/plugin-codegen/package.json |
| npm | @chkit/clickhouse | workspace:* | packages/plugin-obsessiondb/package.json |
| npm | @chkit/core | workspace:* | packages/plugin-obsessiondb/package.json |
| npm | @chkit/plugin-backfill | workspace:* | packages/plugin-obsessiondb/package.json |
| npm | @clack/prompts | ^1.4.0 | packages/plugin-obsessiondb/package.json |
| npm | @orpc/client | 1.13.4 | packages/plugin-obsessiondb/package.json |
| npm | @orpc/contract | 1.13.4 | packages/plugin-obsessiondb/package.json |
| npm | zod | ^4.3.6 | packages/plugin-obsessiondb/package.json |
| npm | @chkit/clickhouse | workspace:* | packages/plugin-pull/package.json |
| npm | @chkit/core | workspace:* | packages/plugin-pull/package.json |
| npm | zod | ^4.3.6 | packages/plugin-pull/package.json |
全部依赖 未采集
本报告未能采集到解析后的依赖集合：GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository
原始 JSON 报告 机器可读
{
"data": {
"repo": {
"topics": [
"cli",
"clickhouse",
"clickhouse-migrations",
"database",
"migrations",
"schema",
"typescript"
],
"is_fork": false,
"size_kb": 18441,
"has_wiki": false,
"homepage": "https://chkit.obsessiondb.com",
"languages": {
"CSS": 42009,
"MDX": 23977,
"HTML": 7561,
"Astro": 27563,
"Shell": 1163,
"JavaScript": 15421,
"TypeScript": 1488709
},
"pushed_at": "2026-07-20T15:59:22Z",
"created_at": "2026-02-09T16:06:39Z",
"owner_type": "Organization",
"updated_at": "2026-07-20T10:29:35Z",
"description": "ClickHouse schema and migration CLI for TypeScript projects",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "main",
"license_spdx_raw": "MIT",
"primary_language": "TypeScript",
"significant_languages": [
"TypeScript"
]
},
"owner": {
"blog": "https://obsessiondb.com/",
"name": "Obsession DB",
"type": "Organization",
"login": "obsessiondb",
"company": null,
"location": null,
"followers": 11,
"avatar_url": "https://avatars.githubusercontent.com/u/256621300?v=4",
"created_at": "2026-01-22T17:30:24Z",
"is_verified": null,
"public_repos": 5,
"account_age_days": 181
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [],
"recent_commits": [
{
"oid": "8296b8a9791cf9a6688fa2c6bf327d81c93ca525",
"body": "…ved primary key as clean (#198)",
"is_bot": false,
"headline": "fix(pull,drift): parse table clauses past the column list; treat deri…",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-07-20T10:29:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bbfac861f3c7c083dea7dc0e7935a95e245eb2d4",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-07-17T16:54:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3f1db03dafb0aa0abdf1b0df71df4db11fd3ea66",
"body": "…#193)",
"is_bot": false,
"headline": "fix(pull): capture index-only projections and render them correctly (…",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-07-17T14:49:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6e96e52b6e931ddf3a3cad90cb5ef7a9b0a7e5b7",
"body": "changeset version bumps package.json versions but never touches the\nlockfile. examples/* pin sibling chkit packages to exact published\nbetas, so once the workspace version moves past that pin bun can no\nlonger dedupe them onto the local copies and must record fresh registry\nresolutions. Without rege\n[…]\nversion-packages so the\n release commit carries the updated resolutions.\n- Add bun install --frozen-lockfile to the release guards so a stale\n lockfile fails the release locally before it is pushed.",
"is_bot": false,
"headline": "fix(release): regenerate lockfile after version bump and guard it (#189)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-07-09T07:15:59Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "a3c7006e92b28de5e467ca0b1bd5e0f393849ea9",
"body": "The last release bumped workspace packages to 0.1.2-beta.4, but\nexamples/clickbench still pins its chkit deps to the published\n0.1.2-beta.2. Once the workspace version no longer satisfied that exact\npin, bun could no longer dedupe those deps onto the local workspace\ncopies and had to resolve them from the registry — entries absent from\nthe committed lockfile, so 'bun install --frozen-lockfile' failed in CI.\n\nRegenerate the lockfile so it carries the registry resolutions.",
"is_bot": false,
"headline": "fix(ci): regenerate bun.lock to match bumped workspace versions",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-07-08T16:45:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b4c88490b53ad4770fed4178edfca4bf44131203",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-07-08T10:13:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f85f5680f9f6c4b6b0917a32a5f51798021ed967",
"body": "…otstrap (#187) (#188)",
"is_bot": false,
"headline": "fix(backfill): chunk mv_replay from the MV source so empty targets bo…",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-07-08T10:03:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "21b4e56c54aa1f952411ee7a00c1e31876bcf7a0",
"body": null,
"is_bot": false,
"headline": "docs: link ObsessionDB Jobs page from the backfill jobs guide (#186)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-07-07T22:17:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9c6730a468792c356d25a4b7c61c79cf2706159a",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-07-07T17:09:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3f9a2461b5d117864512b6a7f520bbfd948e93fe",
"body": "… (#185)",
"is_bot": false,
"headline": "fix(backfill): replay every MV feeding the target, not just the first…",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-07-07T14:38:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5466f9c6dba752728e9e4a630617e8ceb01d6c7b",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-07-07T08:10:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "278e4fa5be21b9f5acde3338f068c59013e2c3c0",
"body": "* docs: add migration workflow guide\n\nExplain chkit's ahead-of-time migration architecture from first\nprinciples: what snapshot.json holds, which files to commit, and how a\nteam ships schema changes when only some developers can reach production.\n\n- New guide at guides/migration-workflow.mdx with a \n[…]\nose .sql is missing.\nReword to say the checks validate committed artifacts, and committing both\nfiles is a code-review discipline the tooling can't enforce.\n\nAddresses Codex review comment on PR #182.",
"is_bot": false,
"headline": "docs: add migration workflow guide (#182)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-07-07T07:53:24Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "9ee242c78d68661bc9a99e5dc031ad5f7d57861d",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-07-06T17:14:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3c008f4d11a18ba18ac17a342594f07f027cbc47",
"body": "…t(core): cover sql-splitter (#180)\n\n* refactor(pull): split renderSchemaFile into per-object renderers\n\nExtract per-object renderers (table / view / materialized view) plus\nshared helpers (declaration header, column, index, projection, settings,\ncodec) from renderSchemaFile, which had grown to cogn\n[…]\n (-- and /* */), statements\nwithout trailing semicolons, empty/whitespace-only input, and the\nmigration-metadata comment contract relied on by migrate/apply.ts.\n\nTests only; the splitter is unchanged.",
"is_bot": false,
"headline": "refactor(pull): split renderSchemaFile into per-object renderers; tes…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-07-06T14:19:59Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "9d9c06e61b5d2343b93e82d988d708fff3e8441d",
"body": "…le (#181)\n\nBreak the ~200-line cmdMigrate (cognitive complexity 71) into named phase\nfunctions and move all json/text rendering into a sibling output.ts,\nfollowing the commands/check/ pattern (command.ts orchestrates; output.ts\nowns emit/render functions).\n\nBehavior is byte-identical: same console output, same --json payload shapes,\nsame exit codes (0/1/3), same prompt and CI/background handling.",
"is_bot": false,
"headline": "refactor(cli): split cmdMigrate into phases with separate output modu…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-07-06T14:19:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5a8d80575c87ee5a3a5850da0d04bfe7b8f124cd",
"body": "* fix(core): allow function expressions in primaryKey/orderBy\n\nFunction expressions like toDate(ts) or toStartOfHour(session_end) are valid\nClickHouse ORDER BY / PRIMARY KEY clauses but were rejected by validation as\nmissing columns, and the SQL renderer backtick-quoted the whole expression as\nan id\n[…]\ncreate. Strip identifier backticks\n(preserving single/double-quoted string literals) in the comparison, alongside\nthe existing whitespace stripping. Comparison-only; rendering is unchanged.\n\nRefs #176",
"is_bot": false,
"headline": "fix(core): allow function expressions in primaryKey/orderBy (#178)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-07-06T14:18:23Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "9ad23f98e5a26258ee6098a27f1b4d6d61dbe9a7",
"body": "Fold the four cloned quote/paren-skipping scan loops into one shared\nscanSqlTokens primitive, with findTopLevelKeywords and splitTopLevel built\non top. Split the oversized rewriteSelectColumns (cyclomatic 54) into\nfindSelectProjectionBounds/splitProjectionPrefix/buildAliasMap/findColumnAlias,\nand de\n[…]\ntegration) and bun run verify pass. Adds focused unit tests for the scanner\nand rewriteSelectColumns edge cases (quoted SELECT/FROM, escaped quotes,\nnested subqueries, missing FROM, trailing clauses).",
"is_bot": false,
"headline": "refactor(backfill): extract shared SQL scanner in chunking/sql.ts (#179)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-07-06T13:46:30Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "b501f5d6e042e1031ca2adef471a7f7f2c15497c",
"body": "* refactor: extract shared plugin command scaffolding into @chkit/core\n\nAdd createPluginRunner and withFactoryDefaults to @chkit/core and use\nthem in the backfill, codegen, and pull plugins, replacing the\nwrapPluginRun wiring repeated on all 9 commands and the byte-identical\nwithFactoryDefaults/isRe\n[…]\ne to import-graph\nanalysis) and exclude packages/core/src/model.ts from health analysis —\nits split-file target is driven by fan-in from type-only imports of the\npublic DSL surface, not real coupling.",
"is_bot": false,
"headline": "refactor: shared plugin command runner in @chkit/core (#175)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-07-06T13:12:54Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "b82c82ad3c612e4d400ca5610e475a774845c4e5",
"body": null,
"is_bot": false,
"headline": "docs: document backfill jobs (local vs managed ObsessionDB) (#177)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-07-06T10:56:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fc7a5de06d1b0eda77913c565b05cd8087d71939",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-07-03T12:20:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "20aca28889100f3ea33622782e19e11e960384a5",
"body": "The sync-resume e2e asserted migration_completed=1 with an immediate\nFINAL read right after the CLI exited 0. On managed ClickHouse the\njournal write races propagation, so under full-suite load the read\nreturned 0 (passed in isolation). Add a generic waitForRows polling\nhelper to the shared testkit and use it here, matching the existing\nwaitFor* convention.",
"is_bot": false,
"headline": "test(e2e): poll for journal completion in sync-resume test",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-07-02T22:11:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d831ce82993e28dc062b97a67bf73c5e1f6bcfbb",
"body": "The dry-run version preview passed an absolute path to `changeset status\n--output`, which resolves it relative to cwd and double-prepended the\nworking dir (…/chkit/Users/marc/…/status.json), failing with ENOENT.\nPass a cwd-relative path so the dry run completes.",
"is_bot": false,
"headline": "fix(release): pass cwd-relative path to changeset status --output",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-07-02T21:30:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6b87e6d7bdb88979c6955314d2c3c3cb36640311",
"body": "* feat: add ClickHouse cluster (ON CLUSTER) support\n\nSet `clickhouse.cluster` to run all generated DDL ON CLUSTER and store the\nmigration journal in a replicated engine — for self-managed multi-node clusters.\n\n- core: applyOnClusterToPlan() stamps ON CLUSTER onto the finished plan as a\n single post\n[…]\nort 9000 → 8123, document the {shard}/{replica}\n macro expectation\n- test/cluster README: describe actual e2e invocation (no CHKIT_CLUSTER_E2E\n gate exists); assert generate exit code in cluster e2e",
"is_bot": false,
"headline": "feat: ClickHouse cluster (ON CLUSTER) support (#168)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-07-02T19:54:36Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "c1d8d0d7b1eb119717034872e41ee5704650928a",
"body": "…ssionDB jobs (#173)",
"is_bot": false,
"headline": "feat(backfill): chkit backfill submit — run backfills as managed Obse…",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-30T12:49:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6be08c53609a1d14956aadccfd4aa510cc5457fc",
"body": null,
"is_bot": false,
"headline": "test(plugin-backfill): live e2e for the backfill execute loop (#172)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-30T09:33:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2d89a0231e4450a3c53f2e34d7c9fa1eaefea20f",
"body": "… (#171)\n\nMove it under Getting Started in the sidebar (URL unchanged), lift the\ncopy-paste prompt to the top for humans who land here, and add a\nthree-question decision flow mirroring the CLI onboarding (new vs existing\nproject, pull existing tables, four-way connect choice) mapped to the\ndeterministic create-chkit / chkit init / obsessiondb connect commands.",
"is_bot": false,
"headline": "docs: make For AI Agents page an explicit, question-driven setup flow…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-30T08:28:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7080d25f171caf6e196ab1d3618d3ed1d1c0e022",
"body": "Add an agent-facing /ai-agents onboarding page (decision tree, skill install, guardrails, pasteable setup prompt) and a \"Let an agent set it up\" copy-prompt on getting-started.\n\nServe every docs page as raw Markdown at a clean .md URL via the Pages Function (no Accept header needed), generate an llms.txt index, and advertise each page's Markdown with a rel=alternate link gated to routes that actually have a source doc. Also fixes the index-page slug bug in the raw-markdown sitemap.",
"is_bot": false,
"headline": "docs: agent onboarding page, llms.txt, and clean .md URLs (#169)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-30T07:15:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4f8d33911c7c31ad7891dddda64271730c078543",
"body": "Adds the @astrojs/sitemap integration so the docs site emits sitemap-index.xml / sitemap-0.xml, plus a robots.txt pointing crawlers at it. Previously 'site' was set but no sitemap integration was installed, so no sitemap was generated.",
"is_bot": false,
"headline": "docs: add XML sitemap via @astrojs/sitemap (#170)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-30T07:12:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "143c35d342495be759fa8f9c64f142be9779e53a",
"body": "On-brand hero (chkit Tungsten identity) at the top of the README: split layout with the ch-kit wordmark, headline, feature bullets, and a terminal showing the generate -> migrate -> check flow. Language support (TypeScript, Python soon) shown as understated chips rather than the lead. Includes the editable HTML source (assets/hero.source.html) with repo-relative font paths so it can be regenerated.",
"is_bot": false,
"headline": "docs: add README hero image (#167)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-29T07:43:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "39656cd1e0e7353d27490be5b726597fa8777c52",
"body": null,
"is_bot": false,
"headline": "Merge branch 'main' of github.com:obsessiondb/chkit",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-06-25T13:35:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9fdb70fe7ce1852aec7f07cbe049bc178aa8516c",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-06-25T13:35:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "12a86514d70546070cf003a0a17ed71f93f441df",
"body": "Docs/landing redesign",
"is_bot": false,
"headline": "Merge pull request #165 from obsessiondb/docs/landing-redesign",
"author_name": "Lucas García de Viedma Pérez",
"author_login": "Lucasgvdii",
"committed_at": "2026-06-25T13:08:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "74dd378fce52f97198da1323d620e97f691c67c9",
"body": null,
"is_bot": false,
"headline": "Merge branch 'main' into docs/landing-redesign",
"author_name": "Lucas García de Viedma Pérez",
"author_login": "Lucasgvdii",
"committed_at": "2026-06-25T13:06:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d99012d78ac76608191db9e86896f9f054c876ec",
"body": "Wire up the starlight-blog plugin: blog at /blog, authors, reading time, and\nan RSS feed via the new canonical `site` URL. Use navigation: 'none' so the\nplugin keeps our custom SiteTitle/ThemeSelect, and add a dedicated \"Blog\"\nheader link instead. Register the blog content collection, and refresh the\nHeader, SiteTitle, SocialIcons, and custom CSS for the landing redesign.",
"is_bot": false,
"headline": "docs(site): add the blog and refresh the header/landing styling",
"author_name": "Lucas García de Viedma Pérez",
"author_login": "Lucasgvdii",
"committed_at": "2026-06-25T13:04:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "530427e62b310e84e056c55208f10c535d79ce80",
"body": "Announce ch-kit (schema-as-code, migrations, and guardrails for ClickHouse).\nFlow: the hand-written-DDL problem, the TypeScript schema DSL, diff-based\nmigrations, apply-time guardrails (destructive blocks, checksums, CI), drift\ndetection + the `check` gate, any-ClickHouse support (with the Obsession\n[…]\nstarted section covering\n`npm create`, `chkit init`, and `chkit pull`. Closes with a \"want more\"\ndocs CTA, the upcoming Python port, and links.\n\nConsistent npm/npx commands, `sh` fences, no em dashes.",
"is_bot": false,
"headline": "docs(blog): ch-kit launch post — \"OLAP deserves better tooling\"",
"author_name": "Lucas García de Viedma Pérez",
"author_login": "Lucasgvdii",
"committed_at": "2026-06-25T13:01:31Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "9ae7a7dfc698af6032341fd14ac6e96fe5c4a31e",
"body": "Adds a --stable flag that graduates the current beta line to a GA\nrelease: exits changesets pre mode (so accumulated patch changesets\ncollapse into a single non-prerelease bump), publishes directly under\nthe latest tag, and refuses to publish if any version still carries a\nprerelease suffix. The default beta path is unchanged.",
"is_bot": false,
"headline": "chore(release): add --stable GA mode to manual-release script",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-06-25T12:35:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "89cf65b15e8a38546aff729f51538fc7240256ec",
"body": "…e accuracy (#164)\n\n* docs: add linear \"first schema\" tutorial under new Tutorials category\n\nWalk from an empty folder to a live, version-controlled table using the\nevents table that `chkit init` scaffolds: claim a free ObsessionDB instance,\ngenerate + migrate, verify, insert/query rows, then add a \n[…]\nps); correct the claim example to note it still prompts\n for the emailed code and link the scripted two-step OTP flow.\n\n---------\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "docs: add first-schema tutorial, reorganize sidebar, and fix referenc…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-25T10:57:24Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "bd5cf3671c23e1949f6c6a453a1d27c1d6df3838",
"body": null,
"is_bot": false,
"headline": "chore: update PR creation skill",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-06-25T08:35:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bb62cd0841f0c95e5b51f015bc8a443bb432e5a1",
"body": "* fix(obsessiondb): emit structured --json envelopes, never a bare string\n\nUnder --json, whoami/logout/login/service-list/service-select printed a\nJSON-encoded *string* (e.g. \"Not logged in…\") instead of an object: the\nserializer JSON.stringify'd whatever it received, and those commands never\nthread\n[…]\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: KeKs0r <marc.hoeffl@laserfocus.io>\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix/onboarding cli findings (#163)",
"author_name": "Lucas García de Viedma Pérez",
"author_login": "Lucasgvdii",
"committed_at": "2026-06-25T08:21:21Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "0016a11264f259cfd3ef904901e1a0ce285272b6",
"body": "…#162)\n\nHonors --json on `signup` and `service claim` so non-interactive callers\ncan chain the auth flow without parsing prose. Each terminal/pause state\nemits a single { command, schemaVersion, status, next } object via the\nalready-json-aware print channel; failures emit an ok:false error envelope.\n[…]\nule — statuses are derived inline. Text-mode output is\nunchanged. Onboarding's connect menu intentionally keeps its prose runbook.\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat(obsessiondb): structured --json next envelope for signup/claim (…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-24T07:52:46Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "713176e54f0c37f944304723d10d7246e8f99ce4",
"body": "… (#161)\n\n* fix(plugin-obsessiondb): sanitize auto-derived default org name\n\nStrip the email +subaddress and non-display characters when deriving the\npersonal org name during signup, so a plus-addressed email like\nmarc+clisignup@numia.xyz yields \"marc\" instead of \"marc+clisignup\".\nKeeps the playgrou\n[…]\n printing the manual command instead of crashing.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix(onboarding): sanitize default org name + make fresh init runnable…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-24T06:18:36Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "bd65e9a99aedfa01d6be9d28df6224710c5f7a83",
"body": "…2e race (#160)\n\n* perf(cli): parallelize test suite and fix flaky obsessiondb e2e race\n\nRun the cli tests with Bun's `--parallel` (files across worker processes)\nin addition to `--concurrent`. Local wall time drops ~260s -> ~110s\n(243 tests, 0 fail).\n\n`--parallel` implies `--isolate`, which surface\n[…]\nanged).\n\nAddresses Codex review feedback on #160.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "perf(cli): parallelize test suite (~2.4x) and fix flaky obsessiondb e…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-24T03:48:57Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "13afc7e86e09c29880842d1067d3dc777115b81c",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-06-23T17:36:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8f4e062f69b407180681c7fbaabe3f9e0629cca8",
"body": null,
"is_bot": false,
"headline": "Merge branch 'main' of github.com:obsessiondb/chkit",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-06-23T17:20:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "72c3fdd062d8c014723b5dc67ded50ad71db454a",
"body": "…aw error leak (#159)\n\n* Make them minor releases\n\n* fix(clickhouse): silence built-in @clickhouse/client logger\n\nThe @clickhouse/client DefaultLogger defaults to WARN since v1.18, which\nlogs the full raw server remediation blurb to stderr on any connection\nERROR, leaking past chkit's clean one-line\n[…]\n shipped behavior matches what\nconsumers resolve.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix(clickhouse): silence built-in @clickhouse/client logger to stop r…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-23T17:20:29Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "96a996916708f8ab98770b0a9103d31e23314366",
"body": null,
"is_bot": false,
"headline": "Make them minor releases",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-06-23T16:23:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "83553c4f9a3043dc92ae95293af5cd01ff35904f",
"body": "…ructive scan (#158)\n\nCover recently-shipped, undocumented features (NUM-7396):\n\n- CHKIT_DEBUG structured logging in cli/overview.md (new Environment variables section)\n- mode=async long-running migration operations in cli/migrate.md, linked to the\n existing -- log: metadata header\n- hand-written d\n[…]\nguration/overview.md\n- light mention of plugin lifecycle hooks in plugins/overview.md (full authoring\n docs deferred to NUM-7397)\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "docs: document CHKIT_DEBUG, mode=async, profile config fallback, dest…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-23T16:20:55Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "99136def7ad10c530b62cc1d9b70475e19bc185b",
"body": "…ev instance) + migrate fix (#157)\n\n* feat(obsessiondb): non-interactive onboarding runbooks + two-step OTP signup\n\nAdd ObsessionDB onboarding to `chkit init` and `create-chkit` (3-way connect\nprompt, passwordless signup, free-instance claim), and make the flows legible\nto non-interactive callers (a\n[…]\nich holds only the selected service and aliases).\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat(obsessiondb): CLI onboarding (passwordless signup + claim free d…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-23T16:04:35Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "d7be1e4dfb133814539ddc4c4bb82a4554ef274e",
"body": "… defineConfig import (#156)\n\n* docs: correct status read-only claim, journal column, --table flag, defineConfig import\n\nTargeted CLI-docs fixes on top of current main (the journal-in-ClickHouse\nrewrite already landed in #137):\n\n- status: it is not strictly read-only — the first run creates the\n _c\n[…]\nhole-command scoping.\nAddresses Codex P2 on #156.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "docs: fix status read-only claim, chkit_version column, --table flag,…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-23T07:34:56Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "dfaa8fa27129e51eed3772b1be5119393517ddae",
"body": "…urce guard (#154)\n\n* docs: document pre-1.0 versioning policy and lock-step package versions\n\nAdd a \"Versioning & releases\" section to the chkit README covering the\npre-1.0 0.x contract, the beta-as-latest channel policy, public vs internal\npackage surface, and the 1.0 SemVer commitment. Configure \n[…]\nll zod alongside the plugin.\n\nRefs NUM-7316 (#26)\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "chkit versioning & release: policy docs, lockstep versions, Zod 4, so…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-22T16:25:09Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "fea565cf47b59f760a8970ab9a1e2df1416015da",
"body": null,
"is_bot": false,
"headline": "fix: distinct warning for destructive table recreate (#153)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-22T11:58:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5ee4afc34cd935469bb7767c6651c22ca1e02619",
"body": null,
"is_bot": false,
"headline": "fix: order materialized-view creates by dependsOn (#152)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-22T11:48:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6789850777f56ed830f3026199fda44fa9b0539e",
"body": null,
"is_bot": false,
"headline": "fix: don't silently skip unmarked migrations under --table (#151)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-22T11:45:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "62652d896b0ced6f7ab3f81397850beef35ace2f",
"body": "… (#150)",
"is_bot": false,
"headline": "fix: scope status Applied count to the project's own migrations (#31)…",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-22T10:47:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6593f8ecfb8561a8ae2dec2cd8a2a0b6856903e4",
"body": "docs: redesign landing hero, header, and footer",
"is_bot": false,
"headline": "Merge pull request #149 from obsessiondb/docs/landing-redesign",
"author_name": "Lucas García de Viedma Pérez",
"author_login": "Lucasgvdii",
"committed_at": "2026-06-17T16:02:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0773f59b523da5e96eb41472bfce078718e0c45b",
"body": "Rework the docs site chrome into a Drizzle-inspired landing while keeping\nthe Tungsten/V5 visual identity.\n\nHero & landing\n- Split hero: punchy headline + tagline, \"BACKED BY ObsessionDB\" credit,\n TypeScript / Python (coming soon) badges linking to npm / PyPI, and a\n 2x2 action card grid under a \"\n[…]\nion overlay is gated to import.meta.env.DEV so prod drops it.\n\nMisc\n- Self-host Goldman; add provider logos; remove the \"Introduction\" sidebar\n entry; align the header logo flush to the shell gutter.",
"is_bot": false,
"headline": "docs: redesign landing hero, header, and footer",
"author_name": "Lucas García de Viedma Pérez",
"author_login": "Lucasgvdii",
"committed_at": "2026-06-17T15:39:09Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "0df966659364e48a6f33275b7f605a9856bf68fa",
"body": null,
"is_bot": false,
"headline": "fix: clearer migration and config errorr (#148)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-11T12:27:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "17b8a272f8cc35a78e87803bd85dd7d4dafc6753",
"body": "…(#146)",
"is_bot": false,
"headline": "fix: ship @chkit/clickhouse/e2e-testkit from dist, not unshipped src …",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-11T08:49:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ed321dacb61cc82c8685ebfcbb1f9e1936163cc3",
"body": "…database, sidebar) (#144)",
"is_bot": false,
"headline": "docs: correct CLI docs drift (query JSON, install, filenames, create_…",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-11T08:49:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7c07673348e2f4e61df70e3ffd51ff38d5df2c5c",
"body": null,
"is_bot": false,
"headline": "docs: add Troubleshooting and ClickHouse compatibility pages (#145)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-11T08:48:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d9d503817610bd73559d4816b57e4c7b5184227e",
"body": null,
"is_bot": false,
"headline": "fix: polish error messages and noisy outputs (#147)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-11T08:47:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f4e5a59cd6666cc335d5b18678db67efa95edd8d",
"body": null,
"is_bot": false,
"headline": "fix: clean one-line message on ClickHouse authentication failure (#139)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-10T10:18:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1af6ef68ed8a2812f0a65043ef4cb60f241bdf03",
"body": null,
"is_bot": false,
"headline": "feat: stable JSON error envelope for --json mode (#140)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-10T10:16:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2b51cfcbd2905991a53357a88f74c9266df042df",
"body": null,
"is_bot": false,
"headline": "fix: scan executable SQL for destructive statements (#141)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-10T09:06:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8d5878a7de88364fc703f9d2b4eeb7d7a0fbddd4",
"body": "…tatement 1 (#142)",
"is_bot": false,
"headline": "fix: resume partial sync (DDL) migrations instead of replaying from s…",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-10T09:04:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ff1cd3117c3f0b6c6c7dc4c6e0767eb45bebe5b4",
"body": null,
"is_bot": false,
"headline": "fix: don't report unmanaged tables as drift by default (#143)",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-09T18:59:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0aa2c28750dd2d5eb757e15474258be9f64aaec0",
"body": "…) (#138)",
"is_bot": false,
"headline": "feat: load .ts config and schema files under plain Node (not just Bun…",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-09T11:41:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "89663720224c5a2b8bf15e28ef72bd6b27d70e04",
"body": "…ion) (#137)",
"is_bot": false,
"headline": "docs: fix journal-in-ClickHouse references (status/migrate/configurat…",
"author_name": "Álvaro",
"author_login": "alvarogar4",
"committed_at": "2026-06-09T11:05:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7e3d77db1dda219e4d655efa5a2f30423b811925",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-06-08T15:18:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "776c6f39baa0c4ea94d4526b5ecc59157d2591b7",
"body": null,
"is_bot": false,
"headline": "Stabilize live check e2e (#136)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-08T15:05:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ca968d9db0ec96494bd6f0ffd6beab705afeab2e",
"body": "* Fix stale internal dep pins in published packages\n\nThe publish resolver only rewrote workspace: specifiers in\ndependencies/devDependencies, skipping optionalDependencies — where chkit\ndeclares @chkit/plugin-obsessiondb — so the CLI shipped bundling a\none-version-old plugin. Extract shared workspac\n[…]\nM context) <noreply@anthropic.com>\n\n* test: skip flaky live check in CI\n\n* chore: remove unused dependency field export\n\n---------\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix stale internal dependency pins in published packages (#135)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-06-08T14:24:12Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "7b92a59b71ae50760bfc589776cbf5ccd71d74aa",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-05-30T08:12:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "75bf34806224f21617a18819298bc7601b85b65b",
"body": "…134)\n\n* Fix ObsessionDB plugin for serviceId → serviceSlug contract change\n\nThe ObsessionDB platform moved every service-scoped RPC input from\nserviceId to serviceSlug, which broke migrate/generate/status/drift/\ncheck/query and remote backfill against ObsessionDB targets.\n\nRefresh the bundled oRPC \n[…]\no\n--service-slug.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>\n\n* Fix fallow dead export alert\n\n---------\n\nCo-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix ObsessionDB plugin for serviceId → serviceSlug contract change (#…",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-30T08:01:40Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "95e6dbb82aec558cf6325cd6c0dcf899bc816e1b",
"body": "* Detect streamed ClickHouse exceptions\n\n* Check streamed exception headers before decoding body\n\nClickHouse can return HTTP 200, set x-clickhouse-exception-code, then\nappend a plain-text exception block after partial JSON rows when\nsend_progress_in_http_headers=1. Decoding the body first would thro\n[…]\nils .json() to prove the\nheader check runs first.\n\nCo-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.7 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "Detect streamed ClickHouse exceptions (#132)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-27T07:31:24Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "5a62874b8b7714c79d24762d029538fd6c8c24b4",
"body": null,
"is_bot": false,
"headline": "Add async migration operation mode (#133)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-27T07:24:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "414322053c849a961af05fb2a74c682a28c615a1",
"body": null,
"is_bot": false,
"headline": "Prompt for create-chkit examples and reorganize docs (#131)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-27T07:22:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0578882ceb22e61f916e388b1f9226f4d9466f1f",
"body": "Fallow analysis is an agentic linter useful as PR feedback but not as a\ndeploy gate on main. The SARIF upload was also failing on main due to\nmissing security-events permissions, blocking deploys. Gate both Fallow\nsteps to pull_request events only.",
"is_bot": false,
"headline": "ci: skip Fallow on main pushes (#129)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-26T10:28:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "21c58b4c285e9a1a6e4e3050705a07a9a05c3cf3",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-05-26T10:17:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "500b7bac5a6288a5a687a112bb873d4c9901dfe9",
"body": "* Add ClickBench example\n\nAdds examples/clickbench/ with the full ClickBench hits schema and a\nload migration that ingests the public ClickBench dataset via the\nClickHouse url() table function. Targets ObsessionDB via the\nplugin-obsessiondb plugin.\n\nIncludes a .gitignore exception so example clickho\n[…]\nditions are backwards-compatible. The ClickBench load migration\nuses the new key to advertise its 3-5 minute duration.\n\n* Pin create-chkit examples to release tag\n\n* Use main for create-chkit examples",
"is_bot": false,
"headline": "Add ClickBench example and create-chkit scaffold (#128)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-26T10:04:10Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "3ecaaae22063c1f98da45d4b72045cfdcb38fceb",
"body": null,
"is_bot": false,
"headline": "Add docs link to CLI help (#125)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-21T13:35:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "268a8c30c0bd288933b049783f1063c0ddf9a403",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-05-21T12:58:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0011d856932df71c72ebc2bc2a609d5b0c6acc56",
"body": "* Rework ObsessionDB service commands\n\n* Fix plugin subcommand routing\n\n* Revert query routing changeset wording",
"is_bot": false,
"headline": "Rework ObsessionDB service commands (#124)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-21T12:45:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a795c39f3b1972f8a803fa8b27483cadb0601c78",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-05-21T11:35:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "461361912781ac1dfeb6c25c818027c5100f98c8",
"body": null,
"is_bot": false,
"headline": "Make the bump a patch",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-05-21T11:31:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5856d4853169fe07b563a1ab47c457fdd300d2cc",
"body": "* Add user profile config fallback\n\n* feat: layer profile config defaults\n\n* refactor(cli): streamline plugin framework\n\nCollapse asymmetries in the plugin/command layer into a single coherent\nmodel: one inline plugin registration shape, one dispatch path, two-layer\noption resolution, and framework-\n[…]\nte together.\n\nCo-Authored-By: Claude Opus 4.7 <noreply@anthropic.com>\n\n* fix ci verification failures\n\n* Fix fallow dead-code issues\n\n---------\n\nCo-authored-by: Claude Opus 4.7 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Add user profile config fallback (#123)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-21T11:29:36Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "6313f6cc17251f63d81d4b0418913c94f7316a0b",
"body": null,
"is_bot": false,
"headline": "fix release dist tags (#122)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-20T22:53:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f159c1b1130608c24db9dac033a090ab5a7a5da3",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-05-20T22:33:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e7f95acc56f8c0e840c28e2e3b7162f94b5d26a9",
"body": "* chore(cli): Phase 1 cleanup — consolidate tests, drop dead barrel\n\n- Move all *.test.ts and e2e-testkit.ts into packages/cli/src/test/\n (mirroring source structure under src/test/bin/ where relevant) so\n production code and tests stop sharing the top-level directory.\n- Delete the unused src/bin/\n[…]\naths.\n\nCo-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>\n\n* fix(cli): repair moved test helper roots\n\n---------\n\nCo-authored-by: Claude Opus 4.7 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "[codex] Restructure CLI source layout (#121)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-20T22:26:21Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "f4ff75d4821a4ef81e7e732270c34b361c5d261f",
"body": "* Add chkit query command and --service override\n\nIntroduces `chkit query \"<sql>\"` as a core CLI command that runs\nad-hoc SQL through the active executor (default ClickHouse, or any\nplugin override). When the ObsessionDB plugin is loaded, all\nClickHouse-bound commands accept `--service <name>` to ro\n[…]\nub.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.7 (1M context) <noreply@anthropic.com>\nCo-authored-by: Copilot Autofix powered by AI <62310815+github-advanced-security[bot]@users.noreply.github.com>",
"is_bot": false,
"headline": "Add chkit query command with ObsessionDB --service override (#120)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-20T20:01:12Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "2273dc2e9e20316173d5928d1b26b28302d2525b",
"body": null,
"is_bot": false,
"headline": "Merge branch 'main' of github.com:obsessiondb/chkit",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-05-20T18:56:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8ac9f2e29885f4eff85fe8df9d3314e7f0e0d572",
"body": null,
"is_bot": false,
"headline": "ignore clickhouse.config.ts",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-05-20T18:56:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ffdcdb9bf6518877d2ecc4c03f006968bee8353d",
"body": null,
"is_bot": false,
"headline": "Add compressed ingest helpers (#119)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-13T15:50:09Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f0117d08bd23ea6fcfceaa03b20e8d93a86526c8",
"body": null,
"is_bot": false,
"headline": "remove .entire folder (#118)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-13T15:06:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aecb106a4a576ff5bf8518818af27401ed5301ef",
"body": "Set application: chkit/<version> on all ClickHouse clients so requests\nemit User-Agent like \"chkit/0.1.0-beta.21 clickhouse-js/...\", making\nchkit traffic filterable in ClickHouse query logs.\n\nCo-authored-by: Claude Opus 4.7 <noreply@anthropic.com>",
"is_bot": false,
"headline": "identify chkit in ClickHouse requests via User-Agent (#117)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-13T09:30:47Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "0f5f4c6765299e19507e06b014bcdbbe6317e714",
"body": "* docs: rename CHX to chkit in apps/docs/README\n\n* docs: remove internal documentation-structure page from public site\n\nThis page leaked the internal 'planning/' directory and used the legacy\n'CHX' name. It belongs in maintainer-facing docs, not the public site.\n\n* docs(getting-started): use bunx ch\n[…]\n first-run already auto-prompts to install the\n AI agent skill (the npx command is the manual fallback).\n- Gitignore CLAUDE.local.md for ObsessionDB positioning context that\n shouldn't be committed.",
"is_bot": false,
"headline": "chkit open-source readiness (NUM-7170) (#116)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-05-12T10:43:41Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "117f632149c3ee2f3627da959b2327ae5d200cf5",
"body": null,
"is_bot": false,
"headline": "fix fallow dead code (#115)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-04-23T15:00:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "18899032ea10450ba657bb670a544b6301138f04",
"body": "* configure fallow analysis\n\n* make fallow CI advisory",
"is_bot": false,
"headline": "[codex] configure fallow analysis (#114)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-04-23T10:00:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8befd05bdc9986cdd0a51924f601b4ccc442f48f",
"body": null,
"is_bot": false,
"headline": "chore: version packages",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-04-22T11:41:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d80824b72fe48a28e25fabf989b9d68c0a9e1000",
"body": null,
"is_bot": false,
"headline": "Skip index structured-args patch",
"author_name": "KeKs0r",
"author_login": "KeKs0r",
"committed_at": "2026-04-22T11:32:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "03d6f57cd978ed26283446da23df768c9df7fadd",
"body": "* Avoid overwriting same-second migrations\n\n* Use stateless executor for parallel metadata polling\n\n* Stabilize timeout-prone e2e tests",
"is_bot": false,
"headline": "[codex] Avoid overwriting same-second migrations (#112)",
"author_name": "Marc Höffl",
"author_login": "KeKs0r",
"committed_at": "2026-04-22T11:31:15Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 0,
"commits_last_year": 297,
"latest_release_at": null,
"latest_release_tag": null,
"releases_from_tags": false,
"days_since_last_push": 2,
"active_weeks_last_year": 21,
"days_since_latest_release": null,
"mean_days_between_releases": null
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": true,
"health_percentage": 75,
"has_issue_template": false,
"has_code_of_conduct": true,
"has_pull_request_template": false
},
"ecosystem": {
"packages": [
{
"name": "chkit",
"exists": true,
"license": "MIT",
"keywords": [
"clickhouse",
"schema",
"migrations",
"typescript",
"database",
"cli"
],
"ecosystem": "npm",
"matches_repo": true,
"registry_url": "https://www.npmjs.com/package/chkit",
"is_deprecated": false,
"latest_version": "0.1.2-beta.5",
"repository_url": "https://github.com/obsessiondb/chkit",
"versions_count": 32,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": 1,
"monthly_downloads": 2708,
"first_published_at": "2026-02-19T10:34:49.698000Z",
"latest_published_at": "2026-07-17T16:53:33.344000Z",
"latest_version_yanked": null,
"days_since_latest_publish": 5
},
{
"name": "@chkit/core",
"exists": true,
"license": "MIT",
"keywords": [
"clickhouse",
"schema",
"migrations",
"typescript",
"database"
],
"ecosystem": "npm",
"matches_repo": true,
"registry_url": "https://www.npmjs.com/package/@chkit/core",
"is_deprecated": false,
"latest_version": "0.1.2-beta.5",
"repository_url": "https://github.com/obsessiondb/chkit",
"versions_count": 37,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": 1,
"monthly_downloads": 3803,
"first_published_at": "2026-02-15T22:42:20.553000Z",
"latest_published_at": "2026-07-17T16:53:30.318000Z",
"latest_version_yanked": null,
"days_since_latest_publish": 5
},
{
"name": "@chkit/codegen",
"exists": true,
"license": "MIT",
"keywords": [
"clickhouse",
"codegen",
"migrations"
],
"ecosystem": "npm",
"matches_repo": true,
"registry_url": "https://www.npmjs.com/package/@chkit/codegen",
"is_deprecated": false,
"latest_version": "0.1.2-beta.5",
"repository_url": "https://github.com/obsessiondb/chkit",
"versions_count": 36,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": 1,
"monthly_downloads": 3169,
"first_published_at": "2026-02-15T22:42:20.850000Z",
"latest_published_at": "2026-07-17T16:53:35.592000Z",
"latest_version_yanked": null,
"days_since_latest_publish": 5
},
{
"name": "@chkit/clickhouse",
"exists": true,
"license": "MIT",
"keywords": [
"clickhouse",
"database",
"client"
],
"ecosystem": "npm",
"matches_repo": true,
"registry_url": "https://www.npmjs.com/package/@chkit/clickhouse",
"is_deprecated": false,
"latest_version": "0.1.2-beta.5",
"repository_url": "https://github.com/obsessiondb/chkit",
"versions_count": 37,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": 1,
"monthly_downloads": 3991,
"first_published_at": "2026-02-15T22:42:20.850000Z",
"latest_published_at": "2026-07-17T16:53:27.874000Z",
"latest_version_yanked": null,
"days_since_latest_publish": 5
},
{
"name": "@chkit/plugin-pull",
"exists": true,
"license": "MIT",
"keywords": [
"clickhouse",
"introspection",
"schema",
"chkit-plugin"
],
"ecosystem": "npm",
"matches_repo": true,
"registry_url": "https://www.npmjs.com/package/@chkit/plugin-pull",
"is_deprecated": false,
"latest_version": "0.1.2-beta.5",
"repository_url": "https://github.com/obsessiondb/chkit",
"versions_count": 36,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": 1,
"monthly_downloads": 3358,
"first_published_at": "2026-02-15T22:42:20.779000Z",
"latest_published_at": "2026-07-17T16:53:40.137000Z",
"latest_version_yanked": null,
"days_since_latest_publish": 5
},
{
"name": "create-chkit",
"exists": true,
"license": "MIT",
"keywords": [
"clickhouse",
"schema",
"migrations",
"typescript",
"scaffold",
"create",
"chkit"
],
"ecosystem": "npm",
"matches_repo": true,
"registry_url": "https://www.npmjs.com/package/create-chkit",
"is_deprecated": false,
"latest_version": "0.1.2-beta.5",
"repository_url": "https://github.com/obsessiondb/chkit",
"versions_count": 11,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": 1,
"monthly_downloads": 1279,
"first_published_at": "2026-05-26T10:17:04.302000Z",
"latest_published_at": "2026-07-17T16:53:42.228000Z",
"latest_version_yanked": null,
"days_since_latest_publish": 5
},
{
"name": "@chkit/plugin-codegen",
"exists": true,
"license": "MIT",
"keywords": [
"clickhouse",
"typescript",
"codegen",
"zod",
"chkit-plugin"
],
"ecosystem": "npm",
"matches_repo": true,
"registry_url": "https://www.npmjs.com/package/@chkit/plugin-codegen",
"is_deprecated": false,
"latest_version": "0.1.2-beta.5",
"repository_url": "https://github.com/obsessiondb/chkit",
"versions_count": 33,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": 1,
"monthly_downloads": 3143,
"first_published_at": "2026-02-17T04:31:29.188000Z",
"latest_published_at": "2026-07-17T16:53:44.623000Z",
"latest_version_yanked": null,
"days_since_latest_publish": 5
},
{
"name": "@chkit/plugin-backfill",
"exists": true,
"license": "MIT",
"keywords": [
"clickhouse",
"backfill",
"data-migration",
"chkit-plugin"
],
"ecosystem": "npm",
"matches_repo": true,
"registry_url": "https://www.npmjs.com/package/@chkit/plugin-backfill",
"is_deprecated": false,
"latest_version": "0.1.2-beta.5",
"repository_url": "https://github.com/obsessiondb/chkit",
"versions_count": 36,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": 1,
"monthly_downloads": 2715,
"first_published_at": "2026-02-15T22:42:20.947000Z",
"latest_published_at": "2026-07-17T16:53:47.269000Z",
"latest_version_yanked": null,
"days_since_latest_publish": 5
}
]
},
"popularity": {
"forks": 2,
"stars": 21,
"watchers": 0,
"fork_history": {
"days": [
{
"date": "2026-07-03",
"count": 1
},
{
"date": "2026-07-15",
"count": 1
}
],
"complete": true,
"collected": 2,
"total_forks": 2
},
"star_history": null,
"open_issues_and_prs": 10
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [
"examples"
],
"has_llms_txt": false,
"has_dockerfile": true,
"has_mcp_signal": false,
"bootstrap_files": [],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [
"apps/docs/tsconfig.json",
"packages/cli/tsconfig.json",
"packages/clickhouse/tsconfig.json",
"packages/codegen/tsconfig.json",
"packages/core/tsconfig.json",
"packages/create-chkit/tsconfig.json",
"packages/plugin-backfill/tsconfig.json",
"packages/plugin-codegen/tsconfig.json",
"packages/plugin-obsessiondb/tsconfig.json",
"packages/plugin-pull/tsconfig.json",
"tsconfig.json"
],
"toolchain_manifests": [],
"largest_source_bytes": 56670,
"source_files_sampled": 276,
"oversized_source_files": 0,
"agent_instruction_files": [
"CLAUDE.md"
],
"agent_instruction_max_bytes": 4596
},
"dependencies": {
"manifests": [
"package.json"
],
"advisories": {
"error": null,
"scope": null,
"source": null,
"findings": [],
"collected": false,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 0,
"malicious_count": 0,
"assessed_package": null,
"unassessed_count": 0,
"direct_affected_count": 0
},
"ecosystems": [
"npm"
],
"dependencies": [
{
"name": "fast-glob",
"manifest": "packages/cli/package.json",
"ecosystem": "npm",
"version_constraint": "^3.3.2"
},
{
"name": "@chkit/clickhouse",
"manifest": "packages/cli/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@chkit/codegen",
"manifest": "packages/cli/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@chkit/core",
"manifest": "packages/cli/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@logtape/logtape",
"manifest": "packages/cli/package.json",
"ecosystem": "npm",
"version_constraint": "^2.0.5"
},
{
"name": "@chkit/core",
"manifest": "packages/clickhouse/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@clickhouse/client",
"manifest": "packages/clickhouse/package.json",
"ecosystem": "npm",
"version_constraint": "^1.18.0"
},
{
"name": "@logtape/logtape",
"manifest": "packages/clickhouse/package.json",
"ecosystem": "npm",
"version_constraint": "^2.0.5"
},
{
"name": "p-retry",
"manifest": "packages/clickhouse/package.json",
"ecosystem": "npm",
"version_constraint": "^7.1.1"
},
{
"name": "@chkit/core",
"manifest": "packages/codegen/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "fast-glob",
"manifest": "packages/core/package.json",
"ecosystem": "npm",
"version_constraint": "^3.3.2"
},
{
"name": "jiti",
"manifest": "packages/core/package.json",
"ecosystem": "npm",
"version_constraint": "^2.7.0"
},
{
"name": "@chkit/plugin-obsessiondb",
"manifest": "packages/create-chkit/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@clack/prompts",
"manifest": "packages/create-chkit/package.json",
"ecosystem": "npm",
"version_constraint": "^1.4.0"
},
{
"name": "commander",
"manifest": "packages/create-chkit/package.json",
"ecosystem": "npm",
"version_constraint": "^14.0.3"
},
{
"name": "giget",
"manifest": "packages/create-chkit/package.json",
"ecosystem": "npm",
"version_constraint": "^3.2.0"
},
{
"name": "picocolors",
"manifest": "packages/create-chkit/package.json",
"ecosystem": "npm",
"version_constraint": "^1.1.1"
},
{
"name": "@chkit/clickhouse",
"manifest": "packages/plugin-backfill/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@chkit/core",
"manifest": "packages/plugin-backfill/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@logtape/logtape",
"manifest": "packages/plugin-backfill/package.json",
"ecosystem": "npm",
"version_constraint": "^2.0.5"
},
{
"name": "p-map",
"manifest": "packages/plugin-backfill/package.json",
"ecosystem": "npm",
"version_constraint": "^7.0.4"
},
{
"name": "zod",
"manifest": "packages/plugin-backfill/package.json",
"ecosystem": "npm",
"version_constraint": "^4.3.6"
},
{
"name": "@chkit/core",
"manifest": "packages/plugin-codegen/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@chkit/clickhouse",
"manifest": "packages/plugin-obsessiondb/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@chkit/core",
"manifest": "packages/plugin-obsessiondb/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@chkit/plugin-backfill",
"manifest": "packages/plugin-obsessiondb/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@clack/prompts",
"manifest": "packages/plugin-obsessiondb/package.json",
"ecosystem": "npm",
"version_constraint": "^1.4.0"
},
{
"name": "@orpc/client",
"manifest": "packages/plugin-obsessiondb/package.json",
"ecosystem": "npm",
"version_constraint": "1.13.4"
},
{
"name": "@orpc/contract",
"manifest": "packages/plugin-obsessiondb/package.json",
"ecosystem": "npm",
"version_constraint": "1.13.4"
},
{
"name": "zod",
"manifest": "packages/plugin-obsessiondb/package.json",
"ecosystem": "npm",
"version_constraint": "^4.3.6"
},
{
"name": "@chkit/clickhouse",
"manifest": "packages/plugin-pull/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "@chkit/core",
"manifest": "packages/plugin-pull/package.json",
"ecosystem": "npm",
"version_constraint": "workspace:*"
},
{
"name": "zod",
"manifest": "packages/plugin-pull/package.json",
"ecosystem": "npm",
"version_constraint": "^4.3.6"
}
],
"all_dependencies": {
"error": "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository",
"source": null,
"packages": [],
"collected": false,
"truncated": false,
"total_count": null,
"direct_count": null,
"indirect_count": null
}
},
"maintainership": {
"issues": {
"open_prs": 5,
"merged_prs": 174,
"open_issues": 5,
"closed_ratio": 0.583,
"closed_issues": 7,
"closed_unmerged_prs": 11
},
"bus_factor": 1,
"bot_contributors": 1,
"top_contributors": [
{
"type": "User",
"login": "KeKs0r",
"commits": 263,
"avatar_url": "https://avatars.githubusercontent.com/u/2970814?v=4"
},
{
"type": "User",
"login": "alvarogar4",
"commits": 26,
"avatar_url": "https://avatars.githubusercontent.com/u/66673617?v=4"
},
{
"type": "User",
"login": "Lucasgvdii",
"commits": 7,
"avatar_url": "https://avatars.githubusercontent.com/u/72617878?v=4"
}
],
"contributors_sampled": 3,
"top_contributor_share": 0.889
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"ci.yml"
],
"has_docs_dir": true,
"linter_configs": [
"biome.json"
],
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": false
},
"security_signals": {
"lockfiles": [],
"scorecard": {
"checks": [
{
"name": "Binary-Artifacts",
"score": 10,
"reason": "no binaries found in the repo",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
},
{
"name": "Branch-Protection",
"score": 0,
"reason": "branch protection not enabled on development/release branches",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 10,
"reason": "20 out of 20 merged PRs checked by a CI test -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
},
{
"name": "CII-Best-Practices",
"score": 0,
"reason": "no effort to earn an OpenSSF best practices badge detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
},
{
"name": "Code-Review",
"score": 0,
"reason": "Found 0/30 approved changesets -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 10,
"reason": "project has 5 contributing companies or organizations",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": 10,
"reason": "no dangerous workflow patterns detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 0,
"reason": "no update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 10,
"reason": "30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
},
{
"name": "Packaging",
"score": null,
"reason": "packaging workflow not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
},
{
"name": "Pinned-Dependencies",
"score": 0,
"reason": "dependency not pinned by hash detected -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
},
{
"name": "SAST",
"score": 10,
"reason": "SAST tool is run on all commits",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
},
{
"name": "Security-Policy",
"score": 10,
"reason": "security policy file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
},
{
"name": "Signed-Releases",
"score": null,
"reason": "no releases found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
},
{
"name": "Token-Permissions",
"score": 0,
"reason": "detected GitHub workflow tokens with excessive permissions",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
},
{
"name": "Vulnerabilities",
"score": 0,
"reason": "51 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "8296b8a9791cf9a6688fa2c6bf327d81c93ca525",
"ran_at": "2026-07-23T00:32:58Z",
"aggregate_score": 4.6,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": true,
"has_dependabot_config": false
},
"contribution_flow": {
"collected": true,
"ci_last_run_at": "2026-07-20T10:30:43Z",
"oldest_open_prs": [
{
"number": 191,
"created_at": "2026-07-14T10:26:29Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 192,
"created_at": "2026-07-15T12:13:19Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 199,
"created_at": "2026-07-20T11:27:44Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 200,
"created_at": "2026-07-20T11:41:14Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 201,
"created_at": "2026-07-20T11:57:29Z",
"last_comment_at": "2026-07-20T15:59:47Z",
"last_comment_author": "alvarogar4"
}
],
"last_merged_pr_at": "2026-07-20T10:29:30Z",
"ci_last_conclusion": "SUCCESS",
"oldest_open_issues": [
{
"number": 126,
"created_at": "2026-05-25T15:11:41Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 195,
"created_at": "2026-07-17T14:36:46Z",
"last_comment_at": "2026-07-20T11:20:06Z",
"last_comment_author": "alvarogar4"
},
{
"number": 196,
"created_at": "2026-07-17T14:37:10Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 197,
"created_at": "2026-07-17T14:37:55Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 202,
"created_at": "2026-07-22T11:06:27Z",
"last_comment_at": null,
"last_comment_author": null
}
]
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/obsessiondb/chkit",
"host": "github.com",
"name": "chkit",
"owner": "obsessiondb"
},
"metrics": {
"overall": {
"key": "overall",
"band": "moderate",
"name": "Overall health",
"note": null,
"notes": [],
"value": 58,
"inputs": {
"security": 46,
"vitality": 47,
"community": 56,
"governance": 55,
"engineering": 86
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "at_risk",
"name": "Vitality",
"value": 47,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "good",
"name": "Development activity",
"note": null,
"notes": [],
"value": 78,
"inputs": {
"commits_last_year": 297,
"human_commit_share": 1,
"days_since_last_push": 2,
"active_weeks_last_year": 21
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 2 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "push_recency",
"params": {
"days": 2
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "21/52 weeks with commits",
"points": 14.5,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 21
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "297 commits in the last year",
"points": 18,
"status": "met",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 297
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "critical",
"name": "Release discipline",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 1,
"inputs": {
"releases_count": 0
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "no releases published",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_releases_published",
"params": {}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "no releases",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_releases",
"params": {}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "no releases",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_releases",
"params": {}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "abandonment",
"band": "excellent",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"cap": null,
"state": "unverified",
"guards": [],
"signals": [],
"red_flag": false,
"multiplier_pct": 100,
"declared_reason": null,
"unverified_reason": "repository_too_young",
"unanswered_open_prs": null,
"unanswered_open_issues": null,
"days_since_last_merged_pr": null,
"days_since_last_human_commit": null,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "maintenance record not established from the collected data",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_unverified",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "moderate",
"name": "Community & Adoption",
"value": 56,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "critical",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 21,
"inputs": {
"forks": 2,
"stars": 21,
"watchers": 0,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "21 stars",
"points": 21.1,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 21
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "2 forks",
"points": 0,
"status": "missed",
"details": [
{
"code": "forks",
"params": {
"count": 2
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "0 watchers",
"points": 0,
"status": "missed",
"details": [
{
"code": "watchers",
"params": {
"count": 0
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "excellent",
"name": "Community health",
"note": null,
"notes": [],
"value": 85,
"inputs": {
"has_readme": true,
"has_license": true,
"has_contributing": true,
"has_issue_template": false,
"has_code_of_conduct": true,
"has_pull_request_template": false
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 22.5,
"status": "met",
"details": [],
"max_points": 22.5
},
{
"key": "license",
"name": "License",
"detail": "recognized license (MIT)",
"points": 22.5,
"status": "met",
"details": [
{
"code": "license_standard",
"params": {}
},
{
"code": "license_spdx",
"params": {
"spdx": "MIT"
}
}
],
"max_points": 22.5
},
{
"key": "contributing_guide",
"name": "CONTRIBUTING guide",
"detail": null,
"points": 18,
"status": "met",
"details": [],
"max_points": 18
},
{
"key": "code_of_conduct",
"name": "Code of conduct",
"detail": null,
"points": 13.5,
"status": "met",
"details": [],
"max_points": 13.5
},
{
"key": "issue_template",
"name": "Issue template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.2
},
{
"key": "pr_template",
"name": "PR template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.3
}
]
},
{
"key": "ecosystem_adoption",
"band": "good",
"name": "Ecosystem adoption (downloads)",
"note": "Excluded from scoring (no data or not applicable): Registry dependents. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"registry_dependents"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 73,
"inputs": {
"packages": [
"chkit",
"@chkit/core",
"@chkit/codegen",
"@chkit/clickhouse",
"@chkit/plugin-pull",
"create-chkit",
"@chkit/plugin-codegen",
"@chkit/plugin-backfill"
],
"dependents": null,
"ecosystems": "npm",
"total_downloads": null,
"monthly_downloads": 24166
},
"components": [
{
"key": "monthly_downloads",
"name": "Monthly downloads",
"detail": "24,166 downloads/month across npm",
"points": 58.4,
"status": "partial",
"details": [
{
"code": "downloads_monthly",
"params": {
"count": 24166,
"ecosystems": "npm"
}
}
],
"max_points": 80
},
{
"key": "registry_dependents",
"name": "Registry dependents",
"detail": "not reported by this ecosystem",
"points": 0,
"status": "excluded",
"details": [
{
"code": "not_reported_by_this_ecosystem",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "moderate",
"name": "Sustainability & Governance",
"value": 55,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "critical",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 26,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 3,
"top_contributor_share": 0.889
},
"components": [
{
"key": "bus_factor",
"name": "Bus factor",
"detail": "1 contributor(s) cover half of all commits",
"points": 9,
"status": "partial",
"details": [
{
"code": "bus_factor",
"params": {
"count": 1
}
}
],
"max_points": 54
},
{
"key": "commit_distribution",
"name": "Commit distribution",
"detail": "top contributor authored 89% of commits",
"points": 2.5,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 89
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "3 contributors",
"points": 4.1,
"status": "partial",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 3
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 5 contributing companies or organizations",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "moderate",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 63,
"inputs": {
"merged_prs": 174,
"open_issues": 5,
"closed_issues": 7,
"issue_closed_ratio": 0.583,
"closed_unmerged_prs": 11
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "58% of issues closed",
"points": 27.3,
"status": "partial",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 58
}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "174/185 decided PRs merged",
"points": 36,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 174,
"decided": 185
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 0/30 approved changesets -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "at_risk",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 44,
"inputs": {
"followers": 11,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "obsessiondb",
"public_repos": 5,
"account_age_days": 181
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "organization-owned",
"points": 30,
"status": "met",
"details": [
{
"code": "owner_organization",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "11 followers of obsessiondb",
"points": 7.8,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 11,
"login": "obsessiondb"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "5 public repos, account ~0 yr old",
"points": 6.7,
"status": "partial",
"details": [
{
"code": "public_repos",
"params": {
"count": 5
}
},
{
"code": "account_age_years",
"params": {
"years": 0
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "excellent",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"chkit",
"@chkit/core",
"@chkit/codegen",
"@chkit/clickhouse",
"@chkit/plugin-pull",
"create-chkit",
"@chkit/plugin-codegen",
"@chkit/plugin-backfill"
],
"ecosystems": "npm",
"any_deprecated": false,
"min_days_since_publish": 5
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "8 package(s) on npm",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 8,
"ecosystems": "npm"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 5 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 5
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "37 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 37
}
}
],
"max_points": 20
},
{
"key": "not_deprecated",
"name": "Not deprecated",
"detail": "active, not deprecated or yanked",
"points": 20,
"status": "met",
"details": [
{
"code": "package_not_deprecated",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "excellent",
"name": "Engineering Quality",
"value": 86,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "good",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 84,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "1 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 1
}
}
],
"max_points": 24
},
{
"key": "tests_present",
"name": "Tests present",
"detail": null,
"points": 24,
"status": "met",
"details": [],
"max_points": 24
},
{
"key": "linter_config",
"name": "Linter config",
"detail": "biome.json",
"points": 16,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "biome.json"
}
}
],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 9.6
},
{
"key": "editorconfig",
"name": ".editorconfig",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "20 out of 20 merged PRs checked by a CI test -- score normalized to 10",
"points": 20,
"status": "met",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "excellent",
"name": "Documentation",
"note": null,
"notes": [],
"value": 90,
"inputs": {
"topics": [
"cli",
"clickhouse",
"clickhouse-migrations",
"database",
"migrations",
"schema",
"typescript"
],
"has_wiki": false,
"homepage": "https://chkit.obsessiondb.com",
"has_readme": true,
"has_docs_dir": true,
"has_description": true
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 30,
"status": "met",
"details": [],
"max_points": 30
},
{
"key": "documentation_directory",
"name": "Documentation directory",
"detail": null,
"points": 25,
"status": "met",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": "https://chkit.obsessiondb.com",
"points": 15,
"status": "met",
"details": [],
"max_points": 15
},
{
"key": "repository_description",
"name": "Repository description",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "topics",
"name": "Topics",
"detail": "7 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 7
}
}
],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "at_risk",
"name": "Security",
"value": 46,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "at_risk",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Packaging, Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"packaging",
"signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 46,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 16,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 2,
"scorecard_aggregate": 4.6
},
"components": [
{
"key": "binary_artifacts",
"name": "Binary-Artifacts",
"detail": "no binaries found in the repo",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "branch_protection",
"name": "Branch-Protection",
"detail": "branch protection not enabled on development/release branches",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "20 out of 20 merged PRs checked by a CI test -- score normalized to 10",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "cii_best_practices",
"name": "CII-Best-Practices",
"detail": "no effort to earn an OpenSSF best practices badge detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "code_review",
"name": "Code-Review",
"detail": "Found 0/30 approved changesets -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 5 contributing companies or organizations",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no dangerous workflow patterns detected",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "dependency_update_tool",
"name": "Dependency-Update-Tool",
"detail": "no update tool detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow not detected",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "pinned_dependencies",
"name": "Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is run on all commits",
"points": 5,
"status": "met",
"details": [],
"max_points": 5
},
{
"key": "security_policy",
"name": "Security-Policy",
"detail": "security policy file detected",
"points": 5,
"status": "met",
"details": [],
"max_points": 5
},
{
"key": "signed_releases",
"name": "Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "token_permissions",
"name": "Token-Permissions",
"detail": "detected GitHub workflow tokens with excessive permissions",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "51 existing vulnerabilities detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "excellent",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"review_only_matches": 0,
"assessed_self_published_locations": 4
},
"components": [
{
"key": "policy_exposure_multiplier",
"name": "Policy exposure multiplier",
"detail": "no confirmed policy-scope location match",
"points": 100,
"status": "met",
"details": [
{
"code": "jurisdiction_no_match",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "good",
"name": "AI Readiness",
"value": 72,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "excellent",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 85,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.92,
"agent_instruction_files": [
"CLAUDE.md"
],
"agent_instruction_max_bytes": 4596
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "CLAUDE.md",
"points": 45,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "CLAUDE.md"
}
}
],
"max_points": 45
},
{
"key": "machine_readable_docs_llms_txt",
"name": "Machine-readable docs (llms.txt)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "legible_commit_history",
"name": "Legible commit history",
"detail": "92 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 40,
"status": "met",
"details": [
{
"code": "legible_history",
"params": {
"legible": 92,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "moderate",
"name": "Verify loop (build / test / typecheck)",
"note": null,
"notes": [],
"value": 64,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": true,
"typed_language": true,
"bootstrap_files": [],
"has_devcontainer": false,
"has_linter_config": true,
"typecheck_configs": [
"apps/docs/tsconfig.json",
"packages/cli/tsconfig.json",
"packages/clickhouse/tsconfig.json",
"packages/codegen/tsconfig.json",
"packages/core/tsconfig.json",
"packages/create-chkit/tsconfig.json",
"packages/plugin-backfill/tsconfig.json",
"packages/plugin-codegen/tsconfig.json",
"packages/plugin-obsessiondb/tsconfig.json",
"packages/plugin-pull/tsconfig.json",
"tsconfig.json"
],
"agent_commit_share": 0.17,
"toolchain_manifests": [],
"dependency_bot_commit_share": 0
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 18
},
{
"key": "automated_tests",
"name": "Automated tests",
"detail": null,
"points": 22,
"status": "met",
"details": [],
"max_points": 22
},
{
"key": "lint_format_config",
"name": "Lint / format config",
"detail": "biome.json",
"points": 11,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "biome.json"
}
}
],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": "apps/docs/tsconfig.json, packages/cli/tsconfig.json, packages/clickhouse/tsconfig.json, packages/codegen/tsconfig.json, packages/core/tsconfig.json, packages/create-chkit/tsconfig.json, packages/plugin-backfill/tsconfig.json, packages/plugin-codegen/tsconfig.json, packages/plugin-obsessiondb/tsconfig.json, packages/plugin-pull/tsconfig.json, tsconfig.json",
"points": 11,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "apps/docs/tsconfig.json, packages/cli/tsconfig.json, packages/clickhouse/tsconfig.json, packages/codegen/tsconfig.json, packages/core/tsconfig.json, packages/create-chkit/tsconfig.json, packages/plugin-backfill/tsconfig.json, packages/plugin-codegen/tsconfig.json, packages/plugin-obsessiondb/tsconfig.json, packages/plugin-pull/tsconfig.json, tsconfig.json"
}
}
],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": "Dockerfile",
"points": 10,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Dockerfile"
}
}
],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "17 of the last 100 commits agent-authored or agent-credited",
"points": 10,
"status": "met",
"details": [
{
"code": "agent_authored_commits",
"params": {
"count": 17,
"sampled": 100
}
}
],
"max_points": 10
},
{
"key": "automated_maintenance",
"name": "Automated maintenance",
"detail": "no automated dependency updates observed",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_dependency_automation",
"params": {}
}
],
"max_points": 8
},
{
"key": "openssf_scorecard_pinned_dependencies",
"name": "OpenSSF Scorecard: Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "excellent",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"primary_language": "TypeScript",
"largest_source_bytes": 56670,
"source_files_sampled": 276,
"oversized_source_files": 0
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "TypeScript (statically typed)",
"points": 45,
"status": "met",
"details": [
{
"code": "statically_typed_language",
"params": {
"language": "TypeScript"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "0/276 source files over 60KB",
"points": 55,
"status": "met",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 276,
"oversized": 0
}
}
],
"max_points": 55
}
]
},
{
"key": "ai_interfaces",
"band": "at_risk",
"name": "Machine-readable interfaces",
"note": null,
"notes": [],
"value": 40,
"inputs": {
"example_dirs": [
"examples"
],
"has_mcp_signal": false,
"api_schema_files": []
},
"components": [
{
"key": "api_schema_openapi_graphql_proto",
"name": "API schema (OpenAPI/GraphQL/proto)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 40
},
{
"key": "mcp_server",
"name": "MCP server",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "runnable_examples",
"name": "Runnable examples",
"detail": "examples",
"points": 40,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "examples"
}
}
],
"max_points": 40
}
]
}
],
"description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
}
],
"metrics_version": "1.13.0"
},
"warnings": [
"Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
"GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository",
"deps.dev does not index npm:chkit@0.1.2-beta.5; advisories assessed against the repository dependency graph instead"
],
"report_type": "repository",
"generated_at": "2026-07-23T00:33:12.660992Z",
"schema_version": "0.27.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/o/obsessiondb/chkit.svg",
"full_name": "obsessiondb/chkit",
"license_state": "standard",
"license_spdx": "MIT"
}