Публічний реєстр
Звіт про здоров'я програмного забезпеченнясхема 0.27.0 · метрики 1.13.0 · 2026-07-23 00:33 UTC

obsessiondb / chkit

ClickHouse schema and migration CLI for TypeScript projects

TypeScriptMIT★ 21 зірка⑂ 2 форкиз лют. 2026 р.Переглянути на GitHub ↗

obsessiondb/chkit має індекс здоров’я 58 зі 100, що відповідає смузі «Помірний». Найвищий показник — Engineering Quality (86/100), найнижчий — Security (46/100). Останнє оновлення було 2 дні тому. Більшість нещодавньої роботи виконує один учасник.

58
загалом / 100
Помірний

Індекс здоров'я програмного забезпечення

Метрики згруповано у зважені категорії на шкалі 1–100. Загальна оцінка починається як їхнє середнє; коли публічні дані активують Політику юрисдикцій високого ризику, рейтинг коригується й отримує верхню межу 49 («Під ризиком»). Готовність до ШІ не входить до індексу.

58
Відмінний85-100Зразковий; відповідає практично всім перевіреним критеріям
Добрий70-84Здоровий; незначні прогалини
Помірний50-69Прийнятний, але з помітними прогалинами; рекомендовано перевірку
У зоні ризику30-49Суттєві слабкі місця; впровадження потребує обережності
Критичний1-29Серйозні проблеми (покинутий, єдиний мейнтейнер, без базової гігієни)
ЖиттєздатністьСпільнота тавпровадженняСталість таврядуванняІнженернаякістьБезпекаГотовність доШІ

Профіль оцінок

Кожна вісь — окрема категорія. Форма важить більше, ніж середнє: здоровий об'єкт заповнює всю фігуру, тоді як профіль із піками та провалами означає, що сила в одному вимірі маскує ризик в іншому.

Власність

Obsession DBОрганізація
11 підписників5 публічних репозиторіївз січ. 2026 р.

За цим репозиторієм стоїть організація — спільна, підзвітна опіка, здатна пережити будь-якого окремого мейнтейнера.

Пакетні екосистеми

РеєстрПакетВерсіяЗавантажень / місВерсіїОстання публікаціяТеги
npmchkit0.1.2-beta.52 708325 днів томуclickhouseschemamigrationstypescriptdatabasecli
npm@chkit/core0.1.2-beta.53 803375 днів томуclickhouseschemamigrationstypescriptdatabase
npm@chkit/codegen0.1.2-beta.53 169365 днів томуclickhousecodegenmigrations
npm@chkit/clickhouse0.1.2-beta.53 991375 днів томуclickhousedatabaseclient
npm@chkit/plugin-pull0.1.2-beta.53 358365 днів томуclickhouseintrospectionschemachkit-plugin
npmcreate-chkit0.1.2-beta.51 279115 днів томуclickhouseschemamigrationstypescriptscaffoldcreatechkit
npm@chkit/plugin-codegen0.1.2-beta.53 143335 днів томуclickhousetypescriptcodegenzodchkit-plugin
npm@chkit/plugin-backfill0.1.2-beta.52 715365 днів томуclickhousebackfilldata-migrationchkit-plugin

Метрики за категоріями

Життєздатність

Чи живий проєкт — чи пишеться код і чи виходять релізи?

47У зоні ризику · 22% загального індексу
Як обчислюється оцінка
36/36Свіжість push — останній push 2 дн. тому
14.5/36Ритм комітів — 21/52 тижнів із комітами
18/18Обсяг комітів — 297 комітів за останній рік
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
Використані вхідні дані
commits_last_year297
human_commit_share1
days_since_last_push2
active_weeks_last_year21
Як обчислюється оцінка
0/27Випускає релізи — релізів не опубліковано
0/36Свіжість релізів — релізів немає
0/27Ритм релізів — релізів немає
0/10OpenSSF Scorecard: Signed-Releases — немає даних
Використані вхідні дані
releases_count0
Виключено з оцінювання (немає даних або не застосовно): OpenSSF Scorecard: Signed-Releases. Залишкові ваги перенормовано.

Спільнота та впровадження

Чи має проєкт користувачів, завантаження, увагу та влаштовані умови для контриб’юторів?

56Помірний · 18% загального індексу
Як обчислюється оцінка
21.1/60Зірки — 21 зірок
0/25Форки — 2 форків
0/15Спостерігачі — 0 спостерігачів
Використані вхідні дані
forks2
stars21
watchers0
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
Як обчислюється оцінка
22.5/22.5README
22.5/22.5Ліцензія — визнана ліцензія (MIT)
18/18Настанови CONTRIBUTING
13.5/13.5Кодекс поведінки
0/7.2Шаблон issue
0/6.3Шаблон PR
Використані вхідні дані
has_readmeтак
has_licenseтак
has_contributingтак
has_issue_templateні
has_code_of_conductтак
has_pull_request_templateні
Як обчислюється оцінка
58.4/80Щомісячні завантаження — 24 166 завантажень/місяць у npm
0/20Залежні пакети в реєстрі — ця екосистема цього не повідомляє
Використані вхідні дані
packageschkit, @chkit/core, @chkit/codegen, @chkit/clickhouse, @chkit/plugin-pull, create-chkit, @chkit/plugin-codegen, @chkit/plugin-backfill
dependents
ecosystemsnpm
total_downloads
monthly_downloads24 166
Виключено з оцінювання (немає даних або не застосовно): Залежні пакети в реєстрі. Залишкові ваги перенормовано.

Сталість та врядування

Чи переживе проєкт своїх людей — бас-фактор, реактивність, хто за ним стоїть і як супроводжуються пакети?

55Помірний · 24% загального індексу
Як обчислюється оцінка
9/54Бас-фактор — на 1 контриб’ютор(ів) припадає половина всіх комітів
2.5/22.5Розподіл комітів — головний контриб’ютор — автор 89% комітів
4.1/13.5Широта контриб’юторів — 3 контриб’юторів
10/10OpenSSF Scorecard: Contributors — project has 5 contributing companies or organizations
Використані вхідні дані
bus_factor1
contributors_sampled3
top_contributor_share0,889
Як обчислюється оцінка
27.3/46.8Вирішення issue — закрито 58% issue
36/38.3Прийняття PR — злито 174/185 вирішених PR
0/15OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0
Використані вхідні дані
merged_prs174
open_issues5
closed_issues7
issue_closed_ratio0,583
closed_unmerged_prs11

Власність та опіка

44У зоні ризику
Як обчислюється оцінка
30/30Підтримка власника — у власності організації
0/20Верифікований домен
7.8/25Охоплення власника — 11 підписників у obsessiondb
6.7/25Послужний список — 5 публічних репозиторіїв, вік облікового запису ~0 р.
Використані вхідні дані
followers11
owner_typeOrganization
is_verified
owner_loginobsessiondb
public_repos5
account_age_days181

Супровід пакетів

100Відмінний
Як обчислюється оцінка
25/25Опубліковано й доступно — 8 пакет(ів) у npm
35/35Свіжість публікацій — остання публікація 5 дн. тому
20/20Історія версій — 37 опублікованих версій
20/20Не застарілий — активний, не deprecated і не yanked
Використані вхідні дані
packageschkit, @chkit/core, @chkit/codegen, @chkit/clickhouse, @chkit/plugin-pull, create-chkit, @chkit/plugin-codegen, @chkit/plugin-backfill
ecosystemsnpm
any_deprecatedні
min_days_since_publish5

Інженерна якість

Чи наявні базові інженерні практики та документація?

86Відмінний · 20% загального індексу
Як обчислюється оцінка
24/24Процеси CI — 1 процес(ів) CI
24/24Наявні тести
16/16Конфігурація лінтера — biome.json
0/9.6Pre-commit-хуки
0/6.4.editorconfig
20/20OpenSSF 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/30README
25/25Каталог документації
15/15Сайт документації / домашня сторінка — https://chkit.obsessiondb.com
10/10Опис репозиторію
10/10Теми — 7 тем
0/10Wiki
Використані вхідні дані
topicscli, clickhouse, clickhouse-migrations, database, migrations, schema, typescript
has_wikiні
homepagehttps://chkit.obsessiondb.com
has_readmeтак
has_docs_dirтак
has_descriptionтак

Безпека

Чи міцні видимі практики безпеки й ланцюга постачання, без непослабленої пов’язаності з юрисдикціями високого ризику?

46У зоні ризику · 16% загального індексу

Стан безпеки

46У зоні ризику
Як обчислюється оцінка
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — branch protection not enabled on development/release branches
2.5/2.5CI-Tests — 20 out of 20 merged PRs checked by a CI test -- score normalized to 10
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 0/30 approved changesets -- score normalized to 0
2.5/2.5Contributors — project has 5 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5Ліцензія — license file detected
7.5/7.5Maintained — 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
0/5Packaging — немає даних
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
5/5SAST — SAST tool is run on all commits
5/5Security-Policy — security policy file detected
0/7.5Signed-Releases — немає даних
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
0/7.5Vulnerabilities — 51 existing vulnerabilities detected
Використані вхідні дані
sourceopenssf_scorecard
checks_evaluated16
scorecard_versionv5.5.0
checks_inconclusive2
scorecard_aggregate4,6
Виключено з оцінювання (немає даних або не застосовно): packaging, signed_releases. Залишкові ваги перенормовано.

Готовність до ШІ

Наскільки репозиторій оснащений для розробки та супроводу за участі ШІ-агентів? Незалежний, експериментальний бейдж — вага 0.0, тож він подається окремо і не впливає на загальний індекс здоров'я.

72Добрий · 0% загального індексу
Як обчислюється оцінка
45/45Інструкції для агентів — CLAUDE.md
0/15Машиночитана документація (llms.txt)
40/40Читабельна історія комітів — намір зазначено у 92 з 100 людських комітів (структурований заголовок або пояснювальний текст)
Використані вхідні дані
has_llms_txtні
legible_history_share0,92
agent_instruction_filesCLAUDE.md
agent_instruction_max_bytes4 596
Як обчислюється оцінка
0/18Розгортання однією командою
22/22Автоматизовані тести
11/11Конфігурація лінтера / форматера — 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Підтверджена практика роботи з агентами — 17 з останніх 100 комітів створено агентом або з його зазначенням
0/8Автоматизоване супроводження — автоматичних оновлень залежностей не виявлено
0/10OpenSSF 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_configsapps/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_share0,17
toolchain_manifests
dependency_bot_commit_share0
Як обчислюється оцінка
45/45Типізований код — TypeScript (статично типізована)
55/55Керовані розміри файлів — 0/276 файлів вихідного коду понад 60 КБ
Використані вхідні дані
primary_languageTypeScript
largest_source_bytes56 670
source_files_sampled276
oversized_source_files0
Як обчислюється оцінка
0/40Схема API (OpenAPI/GraphQL/proto)
0/20Сервер MCP
40/40Придатні до запуску приклади — examples
Використані вхідні дані
example_dirsexamples
has_mcp_signalні
api_schema_files

Ключові факти

21зірок GitHub
3контриб'юторів
297комітів за останні 12 місяців
2днів від останнього пушу
0релізів
1бас-фактор
5відкритих issue
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

Докладніше

Історія зірок і форків 0 ★ / 2 ⇿
0Зірки
2Форки

Коли додано кожну зірку й форк — зібрано з GitHub і згруповано за днями. Кумулятивне зростання розміщено просто над денними додаваннями, з яких воно складається, тож їх видно одне проти одного: рівномірне органічне накопичення виглядає зовсім інакше, ніж різкий короткочасний сплеск. Там, де цю різницю можна виміряти, її подано як автентичність росту.

111222212026-072026-072026-07
OpenSSF Scorecard 4.6 / 10
4.6сукупно

Незалежна, не прив'язана до інструментів оцінка безпеки від відкритого проєкту OpenSSF Scorecard. Кожна перевірка винагороджує практику безпеки, а не інструмент конкретного постачальника. Перевірки, які Scorecard не зміг визначити, позначено н/д і виключено з оцінки безпеки (вони ніколи не зараховуються як нуль).Scorecard v5.5.0 · 2026-07-23 00:32 UTC

10Binary-Artifactsno binaries found in the repo
0Branch-Protectionbranch protection not enabled on development/release branches
10CI-Tests20 out of 20 merged PRs checked by a CI test -- score normalized to 10
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/30 approved changesets -- score normalized to 0
10Contributorsproject has 5 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
10Maintained30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
н/дPackagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
10SASTSAST tool is run on all commits
10Security-Policysecurity policy file detected
н/дSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
0Vulnerabilities51 existing vulnerabilities detected
Прямі залежності 33
РеєстрПакетОбмеження версіїМаніфест
npmfast-glob^3.3.2packages/cli/package.json
npm@chkit/clickhouseworkspace:*packages/cli/package.json
npm@chkit/codegenworkspace:*packages/cli/package.json
npm@chkit/coreworkspace:*packages/cli/package.json
npm@logtape/logtape^2.0.5packages/cli/package.json
npm@chkit/coreworkspace:*packages/clickhouse/package.json
npm@clickhouse/client^1.18.0packages/clickhouse/package.json
npm@logtape/logtape^2.0.5packages/clickhouse/package.json
npmp-retry^7.1.1packages/clickhouse/package.json
npm@chkit/coreworkspace:*packages/codegen/package.json
npmfast-glob^3.3.2packages/core/package.json
npmjiti^2.7.0packages/core/package.json
npm@chkit/plugin-obsessiondbworkspace:*packages/create-chkit/package.json
npm@clack/prompts^1.4.0packages/create-chkit/package.json
npmcommander^14.0.3packages/create-chkit/package.json
npmgiget^3.2.0packages/create-chkit/package.json
npmpicocolors^1.1.1packages/create-chkit/package.json
npm@chkit/clickhouseworkspace:*packages/plugin-backfill/package.json
npm@chkit/coreworkspace:*packages/plugin-backfill/package.json
npm@logtape/logtape^2.0.5packages/plugin-backfill/package.json
npmp-map^7.0.4packages/plugin-backfill/package.json
npmzod^4.3.6packages/plugin-backfill/package.json
npm@chkit/coreworkspace:*packages/plugin-codegen/package.json
npm@chkit/clickhouseworkspace:*packages/plugin-obsessiondb/package.json
npm@chkit/coreworkspace:*packages/plugin-obsessiondb/package.json
npm@chkit/plugin-backfillworkspace:*packages/plugin-obsessiondb/package.json
npm@clack/prompts^1.4.0packages/plugin-obsessiondb/package.json
npm@orpc/client1.13.4packages/plugin-obsessiondb/package.json
npm@orpc/contract1.13.4packages/plugin-obsessiondb/package.json
npmzod^4.3.6packages/plugin-obsessiondb/package.json
npm@chkit/clickhouseworkspace:*packages/plugin-pull/package.json
npm@chkit/coreworkspace:*packages/plugin-pull/package.json
npmzod^4.3.6packages/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"
}

Оцінки — це сигнали, а не гарантії. Вони відображають публічно видимі практики на GitHub — це не аудит коду й не гарантія безпеки.

Відсутні дані виключаються, а ваги перенормовуються — нуль за відсутність ніколи не ставиться. Методологія версіонована й відкрита: метрики v1.13.0, схема v0.27.0 — повна методологія · вікі метрик.

Як окремий результат виглядає на тлі всього реєстру: сукупна статистикаnpm.