Öffentliches Register
Software-GesundheitsberichtSchema 0.27.0 · Metriken 1.13.0 · 2026-07-23 00:33 UTC

obsessiondb / chkit

ClickHouse schema and migration CLI for TypeScript projects

TypeScriptMIT★ 21 Sterne⑂ 2 Forksseit Feb. 2026Auf GitHub ansehen ↗

obsessiondb/chkit erreicht einen Gesundheitsindex von 58 von 100 und liegt damit im Bereich Mittel. Am stärksten schneidet es bei Engineering Quality (86/100) ab, am schwächsten bei Security (46/100). Zuletzt vor 2 Tagen aktualisiert. Ein einzelner Mitwirkender trägt den Großteil der jüngsten Arbeit.

58
gesamt / 100
Mittel

Software-Gesundheitsindex

Metriken werden auf einer Skala von 1–100 in gewichtete Kategorien gruppiert. Der Gesamtwert beginnt als ihr Mittel; sobald öffentliche Evidenz die Richtlinie für Hochrisikojurisdiktionen auslöst, wird die Bewertung angepasst und erhält die Obergrenze 49 (Gefährdet). AI Readiness liegt außerhalb.

58
Exzellent85-100Vorbildlich; erfüllt im Wesentlichen alle geprüften Kriterien
Gut70-84Gesund; geringfügige Lücken
Mittel50-69Akzeptabel mit deutlichen Lücken; Überprüfung empfohlen
Gefährdet30-49Erhebliche Schwächen; eine Übernahme erfordert Vorsicht
Kritisch1-29Schwerwiegende Probleme (aufgegeben, nur ein Maintainer, keine Hygiene)
VitalitätCommunity &VerbreitungNachhaltigkeit &GovernanceEngineering-QualitätSicherheitAI Readiness

Bewertungsprofil

Jede Achse ist eine Kategorie. Die Form zählt mehr als der Durchschnitt — ein gesundes Projekt füllt die gesamte Fläche, während ein Profil aus Spitzen und Kratern bedeutet, dass Stärke in einer Dimension Risiken in einer anderen verdeckt.

Eigentümerschaft

Obsession DBOrganisation
11 Follower5 öffentliche Reposseit Jan. 2026

Dieses Repository wird von einer Organisation getragen — geteilte, rechenschaftspflichtige Trägerschaft, die jeden einzelnen Maintainer überdauern kann.

Paket-Ökosysteme

RegistryPaketVersionDownloads / MonatVersionenZuletzt veröffentlichtTags
npmchkit0.1.2-beta.52.70832vor 5 Tagenclickhouseschemamigrationstypescriptdatabasecli
npm@chkit/core0.1.2-beta.53.80337vor 5 Tagenclickhouseschemamigrationstypescriptdatabase
npm@chkit/codegen0.1.2-beta.53.16936vor 5 Tagenclickhousecodegenmigrations
npm@chkit/clickhouse0.1.2-beta.53.99137vor 5 Tagenclickhousedatabaseclient
npm@chkit/plugin-pull0.1.2-beta.53.35836vor 5 Tagenclickhouseintrospectionschemachkit-plugin
npmcreate-chkit0.1.2-beta.51.27911vor 5 Tagenclickhouseschemamigrationstypescriptscaffoldcreatechkit
npm@chkit/plugin-codegen0.1.2-beta.53.14333vor 5 Tagenclickhousetypescriptcodegenzodchkit-plugin
npm@chkit/plugin-backfill0.1.2-beta.52.71536vor 5 Tagenclickhousebackfilldata-migrationchkit-plugin

Metriken nach Kategorie

Vitalität

Lebt das Projekt — wird Code geschrieben und werden Releases ausgeliefert?

47Gefährdet · 22 % des Gesamtindex
Wie die Bewertung erfolgt
36/36Push-Aktualität — letzter Push vor 2 Tagen
14.5/36Commit-Rhythmus — 21/52 Wochen mit Commits
18/18Commit-Volumen — 297 Commits im letzten Jahr
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
Verwendete Eingangsdaten
commits_last_year297
human_commit_share1
days_since_last_push2
active_weeks_last_year21
Wie die Bewertung erfolgt
0/27Liefert Releases aus — keine Releases veröffentlicht
0/36Release-Aktualität — keine Releases
0/27Release-Rhythmus — keine Releases
0/10OpenSSF Scorecard: Signed-Releases — keine Daten
Verwendete Eingangsdaten
releases_count0
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): OpenSSF Scorecard: Signed-Releases. Die verbleibenden Gewichte wurden renormalisiert.

Community & Verbreitung

Hat das Projekt Nutzer, Downloads, Aufmerksamkeit und ein einladendes Umfeld für Beitragende?

56Mittel · 18 % des Gesamtindex
Wie die Bewertung erfolgt
21.1/60Stars — 21 Stars
0/25Forks — 2 Forks
0/15Watcher — 0 Watcher
Verwendete Eingangsdaten
forks2
stars21
watchers0
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
Wie die Bewertung erfolgt
22.5/22.5README
22.5/22.5Lizenz — anerkannte Lizenz (MIT)
18/18CONTRIBUTING-Leitfaden
13.5/13.5Verhaltenskodex
0/7.2Issue-Vorlage
0/6.3PR-Vorlage
Verwendete Eingangsdaten
has_readmeja
has_licenseja
has_contributingja
has_issue_templatenein
has_code_of_conductja
has_pull_request_templatenein
Wie die Bewertung erfolgt
58.4/80Downloads pro Monat — 24.166 Downloads/Monat über npm
0/20Abhängige in der Registry — von diesem Ökosystem nicht ausgewiesen
Verwendete Eingangsdaten
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
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): Abhängige in der Registry. Die verbleibenden Gewichte wurden renormalisiert.

Nachhaltigkeit & Governance

Überdauert das Projekt die Menschen, die es tragen — Bus-Faktor, Reaktionsfähigkeit, Trägerschaft und Paketpflege?

55Mittel · 24 % des Gesamtindex
Wie die Bewertung erfolgt
9/54Bus-Faktor — 1 Beitragende decken die Hälfte aller Commits ab
2.5/22.5Commit-Verteilung — wichtigste beitragende Person verfasste 89 % der Commits
4.1/13.5Breite der Beitragenden — 3 Beitragende
10/10OpenSSF Scorecard: Contributors — project has 5 contributing companies or organizations
Verwendete Eingangsdaten
bus_factor1
contributors_sampled3
top_contributor_share0,889
Wie die Bewertung erfolgt
27.3/46.8Issue-Lösungsquote — 58 % der Issues geschlossen
36/38.3PR-Annahme — 174/185 entschiedene PRs gemergt
0/15OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0
Verwendete Eingangsdaten
merged_prs174
open_issues5
closed_issues7
issue_closed_ratio0,583
closed_unmerged_prs11
Wie die Bewertung erfolgt
30/30Organisatorische Trägerschaft — im Besitz einer Organisation
0/20Verifizierte Domain
7.8/25Reichweite des Inhabers — 11 Follower von obsessiondb
6.7/25Kontohistorie — 5 öffentliche Repos, Kontoalter ca. 0 Jahre
Verwendete Eingangsdaten
followers11
owner_typeOrganization
is_verified
owner_loginobsessiondb
public_repos5
account_age_days181

Paketpflege

100Exzellent
Wie die Bewertung erfolgt
25/25Veröffentlicht & auflösbar — 8 Paket(e) auf npm
35/35Veröffentlichungsaktualität — letzte Veröffentlichung vor 5 Tagen
20/20Versionshistorie — 37 veröffentlichte Versionen
20/20Nicht veraltet — aktiv, nicht veraltet oder zurückgezogen
Verwendete Eingangsdaten
packageschkit, @chkit/core, @chkit/codegen, @chkit/clickhouse, @chkit/plugin-pull, create-chkit, @chkit/plugin-codegen, @chkit/plugin-backfill
ecosystemsnpm
any_deprecatednein
min_days_since_publish5

Engineering-Qualität

Sind grundlegende Engineering- und Dokumentationspraktiken vorhanden?

86Exzellent · 20 % des Gesamtindex
Wie die Bewertung erfolgt
24/24CI-Workflows — 1 Workflow(s)
24/24Tests vorhanden
16/16Linter-Konfiguration — biome.json
0/9.6Pre-Commit-Hooks
0/6.4.editorconfig
20/20OpenSSF Scorecard: CI-Tests — 20 out of 20 merged PRs checked by a CI test -- score normalized to 10
Verwendete Eingangsdaten
has_cija
has_testsja
has_editorconfignein
has_linter_configja
has_precommit_confignein

Dokumentation

90Exzellent
Wie die Bewertung erfolgt
30/30README
25/25Dokumentationsverzeichnis
15/15Dokumentations-/Homepage-Site — https://chkit.obsessiondb.com
10/10Repository-Beschreibung
10/10Topics — 7 Topics
0/10Wiki
Verwendete Eingangsdaten
topicscli, clickhouse, clickhouse-migrations, database, migrations, schema, typescript
has_wikinein
homepagehttps://chkit.obsessiondb.com
has_readmeja
has_docs_dirja
has_descriptionja

Sicherheit

Sind die sichtbaren Sicherheits- und Lieferkettenpraktiken belastbar, ohne ungeklärte Exposition gegenüber Hochrisikojurisdiktionen?

46Gefährdet · 16 % des Gesamtindex

Sicherheitslage

46Gefährdet
Wie die Bewertung erfolgt
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.5Lizenz — 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 — keine Daten
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 — keine Daten
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
0/7.5Vulnerabilities — 51 existing vulnerabilities detected
Verwendete Eingangsdaten
sourceopenssf_scorecard
checks_evaluated16
scorecard_versionv5.5.0
checks_inconclusive2
scorecard_aggregate4,6
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): packaging, signed_releases. Die verbleibenden Gewichte wurden renormalisiert.

AI Readiness

Wie gut ist das Repository dafür ausgestattet, mit KI-Coding-Agenten entwickelt und gepflegt zu werden? Ein unabhängiges, experimentelles Badge — Gewicht 0,0, es wird eigenständig ausgewiesen und verändert den Gesamt-Gesundheitswert nicht.

72Gut · 0 % des Gesamtindex
Wie die Bewertung erfolgt
45/45Agentenanweisungen — CLAUDE.md
0/15Maschinenlesbare Doku (llms.txt)
40/40Lesbare Commit-Historie — 92 von 100 menschlichen Commits benennen ihre Absicht (strukturierter Betreff oder erläuternder Text)
Verwendete Eingangsdaten
has_llms_txtnein
legible_history_share0,92
agent_instruction_filesCLAUDE.md
agent_instruction_max_bytes4.596
Wie die Bewertung erfolgt
0/18Bootstrap mit einem Befehl
22/22Automatisierte Tests
11/11Lint-/Format-Konfiguration — biome.json
11/11Statische Typprüfung — 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/10Reproduzierbare Umgebung — Dockerfile
10/10Belegte Agentenpraxis — 17 der letzten 100 Commits von Agenten verfasst oder ihnen zugeschrieben
0/8Automatisierte Wartung — keine automatisierten Abhängigkeits-Updates beobachtet
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Verwendete Eingangsdaten
has_nixnein
has_testsja
lockfiles
has_dockerfileja
typed_languageja
bootstrap_files
has_devcontainernein
has_linter_configja
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
Wie die Bewertung erfolgt
45/45Typprüfbarer Code — TypeScript (statisch typisiert)
55/55Handhabbare Dateigrößen — 0/276 Quelldateien über 60 KB
Verwendete Eingangsdaten
primary_languageTypeScript
largest_source_bytes56.670
source_files_sampled276
oversized_source_files0
Wie die Bewertung erfolgt
0/40API-Schema (OpenAPI/GraphQL/proto)
0/20MCP-Server
40/40Lauffähige Beispiele — examples
Verwendete Eingangsdaten
example_dirsexamples
has_mcp_signalnein
api_schema_files

Eckdaten

21GitHub-Sterne
3Mitwirkende
297Commits, letzte 12 Monate
2Tage seit letztem Push
0Releases
1Bus-Faktor
5offene Issues
npmPaket-Ökosysteme

Warnungen zur Datenerhebung

  • 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

Weitere Details

Stern- und Fork-Verlauf 0 ★ / 2 ⇿
0Sterne
2Forks

Wann jeder Stern und Fork hinzugefügt wurde, von GitHub erfasst und nach Tagen gruppiert. Das kumulierte Wachstum steht direkt über den täglichen Zugängen, aus denen es besteht, sodass beide gegeneinander lesbar sind: stetiger organischer Zuwachs sieht ganz anders aus als ein abrupter, kurzlebiger Ausschlag. Wo dieser Unterschied messbar ist, wird er als Wachstumsauthentizität ausgewiesen.

111222212026-072026-072026-07
OpenSSF Scorecard 4.6 / 10
4.6Gesamtwert

Unabhängige, werkzeugneutrale Sicherheitsbewertung durch das quelloffene OpenSSF Scorecard. Jede Prüfung honoriert eine Sicherheits-Praxis, nicht das Werkzeug eines bestimmten Anbieters. Prüfungen, die Scorecard nicht ermitteln konnte, sind mit k. A. markiert und vom Sicherheitswert ausgeschlossen (nie als null gezählt).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
k. A.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
k. A.Signed-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
0Vulnerabilities51 existing vulnerabilities detected
Direkte Abhängigkeiten 33
RegistryPaketVersionsvorgabeManifest
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
Alle Abhängigkeiten nicht erhoben

Der aufgelöste Abhängigkeitssatz konnte für diesen Bericht nicht erhoben werden: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

JSON-Rohbericht maschinenlesbar
{
  "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"
}

Bewertungen sind Signale, keine Garantien. Sie spiegeln öffentlich sichtbare Praxis auf GitHub wider — kein Code-Audit und keine Sicherheitsgarantie.

Fehlende Daten werden ausgeschlossen und die Gewichte neu normiert, nie als null bewertet. Die Methodik ist versioniert und offen: Metriken v1.13.0, Schema v0.27.0 — vollständige Methodik · Metriken-Wiki.

Wie ein einzelnes Ergebnis im Gesamtregister steht: aggregierte Statistikennpm.