obsessiondb/chkit holds a health index of 58 out of 100, placing it in the Moderate band. It scores highest on Engineering Quality (86/100) and lowest on Security (46/100). It was last updated 2 days ago. A single contributor accounts for most of its recent work.
58
overall / 100
Moderate
Software health index
Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At risk ceiling of 49. AI Readiness sits outside the overall score.
58
Excellent85-100Exemplary; meets essentially all checked criteria
Good70-84Healthy; minor gaps
Moderate50-69Acceptable with notable gaps; review recommended
At risk30-49Significant weaknesses; adoption warrants caution
Critical1-29Severe problems (abandoned, single-maintainer, no hygiene)
Score profile
Each axis is a category. The shape matters more than the average — a healthy subject fills the whole shape, while a spike-and-crater profile means strength in one dimension is masking risk in another.
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.
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
More detail
Star and fork history 0 ★ / 2 ⇿
0Stars
2Forks
When each star and fork was added, collected from GitHub and bucketed by day. Cumulative growth sits directly above the daily additions it is made of, so the two read against each other: steady organic accretion looks nothing like an abrupt, short-lived burst. Where that difference is measurable, it is reported as growth authenticity.
OpenSSF Scorecard 4.6 / 10
4.6aggregate
Independent, tool-agnostic security assessment from the open-source OpenSSF Scorecard. Each check rewards a security practice, not a specific vendor's tool. Checks Scorecard could not determine are marked n/a and excluded from the security score (never counted as zero).Scorecard v5.5.0 · 2026-07-23 00:32 UTC
The resolved dependency set could not be collected for this report: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository
Raw JSON report machine-readable
{
"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"
}
Scores are signals, not warranties. They reflect publicly visible practices on GitHub — not a code audit, and not a security guarantee.
Missing data is excluded and weights renormalized, never scored as zero. Methodology is versioned and open: metrics v1.13.0, schema v0.27.0 — full methodology · metrics wiki.
