Registro público
Informe de salud del softwareesquema 0.27.0 · métricas 1.13.0 · 2026-07-23 00:33 UTC

obsessiondb / chkit

ClickHouse schema and migration CLI for TypeScript projects

TypeScriptMIT★ 21 estrellas⑂ 2 forksdesde feb 2026Ver en GitHub ↗

obsessiondb/chkit tiene un índice de salud de 58 sobre 100, lo que lo sitúa en la banda Moderado. Su puntuación más alta es Engineering Quality (86/100) y la más baja, Security (46/100). Se actualizó por última vez hace 2 días. Una sola persona concentra la mayor parte del trabajo reciente.

58
global / 100
Moderado

Índice de salud del software

Las métricas se agrupan en categorías ponderadas sobre una escala de 1 a 100. El resultado global parte de su media; cuando la evidencia pública activa la Política de Jurisdicciones de Alto Riesgo, la calificación se ajusta y recibe el límite 49 (En riesgo). Preparación para IA queda fuera.

58
Excelente85-100Ejemplar; cumple prácticamente todos los criterios evaluados
Bueno70-84Saludable; carencias menores
Moderado50-69Aceptable con carencias notables; se recomienda revisión
En riesgo30-49Debilidades significativas; su adopción exige cautela
Crítico1-29Problemas graves (proyecto abandonado, un solo mantenedor, sin higiene)
VitalidadComunidad yAdopciónSostenibilidady GobernanzaCalidad deIngenieríaSeguridadPreparaciónpara IA

Perfil de puntuación

Cada eje es una categoría. La forma importa más que la media: un proyecto sano llena toda la figura, mientras que un perfil de picos y cráteres indica que la fortaleza en una dimensión enmascara el riesgo en otra.

Titularidad

Obsession DBOrganización
11 seguidores5 repositorios públicosdesde ene 2026

Este repositorio está respaldado por una organización: una custodia compartida y responsable que puede sobrevivir a cualquier mantenedor individual.

Ecosistemas de paquetes

RegistroPaqueteVersiónDescargas / mesVersionesÚltima publicaciónEtiquetas
npmchkit0.1.2-beta.5270832hace 5 díasclickhouseschemamigrationstypescriptdatabasecli
npm@chkit/core0.1.2-beta.5380337hace 5 díasclickhouseschemamigrationstypescriptdatabase
npm@chkit/codegen0.1.2-beta.5316936hace 5 díasclickhousecodegenmigrations
npm@chkit/clickhouse0.1.2-beta.5399137hace 5 díasclickhousedatabaseclient
npm@chkit/plugin-pull0.1.2-beta.5335836hace 5 díasclickhouseintrospectionschemachkit-plugin
npmcreate-chkit0.1.2-beta.5127911hace 5 díasclickhouseschemamigrationstypescriptscaffoldcreatechkit
npm@chkit/plugin-codegen0.1.2-beta.5314333hace 5 díasclickhousetypescriptcodegenzodchkit-plugin
npm@chkit/plugin-backfill0.1.2-beta.5271536hace 5 díasclickhousebackfilldata-migrationchkit-plugin

Métricas por categoría

Vitalidad

¿Está vivo el proyecto: se escribe código y se publican versiones?

47En riesgo · 22% del índice global
Cómo se puntúa
36/36Recencia de push — último push hace 2 días
14.5/36Cadencia de commits — 21/52 semanas con commits
18/18Volumen de commits — 297 commits en el último año
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
Datos de entrada utilizados
commits_last_year297
human_commit_share1
days_since_last_push2
active_weeks_last_year21
Cómo se puntúa
0/27Publica versiones — sin versiones publicadas
0/36Recencia de las versiones — sin versiones
0/27Cadencia de publicación — sin versiones
0/10OpenSSF Scorecard: Signed-Releases — sin datos
Datos de entrada utilizados
releases_count0
Excluidos de la puntuación (sin datos o no aplicable): OpenSSF Scorecard: Signed-Releases. Los pesos restantes se han renormalizado.

Comunidad y Adopción

¿Tiene el proyecto usuarios, descargas, atención y unas condiciones acogedoras para quienes contribuyen?

56Moderado · 18% del índice global
Cómo se puntúa
21.1/60Estrellas — 21 estrellas
0/25Forks — 2 forks
0/15Observadores — 0 observadores
Datos de entrada utilizados
forks2
stars21
watchers0
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
Cómo se puntúa
22.5/22.5README
22.5/22.5Licencia — licencia reconocida (MIT)
18/18Guía CONTRIBUTING
13.5/13.5Código de conducta
0/7.2Plantilla de issues
0/6.3Plantilla de PR
Datos de entrada utilizados
has_readme
has_license
has_contributing
has_issue_templateno
has_code_of_conduct
has_pull_request_templateno
Cómo se puntúa
58.4/80Descargas mensuales — 24.166 descargas/mes en npm
0/20Dependientes en el registro — no lo informa este ecosistema
Datos de entrada utilizados
packageschkit, @chkit/core, @chkit/codegen, @chkit/clickhouse, @chkit/plugin-pull, create-chkit, @chkit/plugin-codegen, @chkit/plugin-backfill
dependents
ecosystemsnpm
total_downloads
monthly_downloads24.166
Excluidos de la puntuación (sin datos o no aplicable): Dependientes en el registro. Los pesos restantes se han renormalizado.

Sostenibilidad y Gobernanza

¿Sobrevivirá el proyecto a sus personas: factor bus, capacidad de respuesta, quién lo respalda y mantenimiento del paquete?

55Moderado · 24% del índice global
Cómo se puntúa
9/54Factor bus — la mitad de los commits recae en 1 contribuyente(s)
2.5/22.5Distribución de commits — el principal contribuyente firma el 89% de los commits
4.1/13.5Amplitud de contribuyentes — 3 contribuyentes
10/10OpenSSF Scorecard: Contributors — project has 5 contributing companies or organizations
Datos de entrada utilizados
bus_factor1
contributors_sampled3
top_contributor_share0,889
Cómo se puntúa
27.3/46.8Resolución de issues — 58% de issues cerradas
36/38.3Aceptación de PR — 174/185 PR decididos fusionados
0/15OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0
Datos de entrada utilizados
merged_prs174
open_issues5
closed_issues7
issue_closed_ratio0,583
closed_unmerged_prs11
Cómo se puntúa
30/30Respaldo de la propiedad — propiedad de una organización
0/20Dominio verificado
7.8/25Alcance del propietario — 11 seguidores de obsessiondb
6.7/25Trayectoria — 5 repos públicos, cuenta de ~0 años
Datos de entrada utilizados
followers11
owner_typeOrganization
is_verified
owner_loginobsessiondb
public_repos5
account_age_days181
Cómo se puntúa
25/25Publicado y resoluble — 8 paquete(s) en npm
35/35Recencia de publicación — última publicación hace 5 días
20/20Historial de versiones — 37 versiones en el registro
20/20No obsoleto — activo, ni obsoleto ni retirado
Datos de entrada utilizados
packageschkit, @chkit/core, @chkit/codegen, @chkit/clickhouse, @chkit/plugin-pull, create-chkit, @chkit/plugin-codegen, @chkit/plugin-backfill
ecosystemsnpm
any_deprecatedno
min_days_since_publish5

Calidad de Ingeniería

¿Existen unas prácticas mínimas de ingeniería y documentación?

86Excelente · 20% del índice global
Cómo se puntúa
24/24Flujos de trabajo de CI — 1 flujo(s) de trabajo
24/24Pruebas presentes
16/16Configuración de linter — biome.json
0/9.6Hooks de pre-commit
0/6.4.editorconfig
20/20OpenSSF Scorecard: CI-Tests — 20 out of 20 merged PRs checked by a CI test -- score normalized to 10
Datos de entrada utilizados
has_ci
has_tests
has_editorconfigno
has_linter_config
has_precommit_configno

Documentación

90Excelente
Cómo se puntúa
30/30README
25/25Directorio de documentación
15/15Sitio de documentación / página del proyecto — https://chkit.obsessiondb.com
10/10Descripción del repositorio
10/10Topics — 7 topics
0/10Wiki
Datos de entrada utilizados
topicscli, clickhouse, clickhouse-migrations, database, migrations, schema, typescript
has_wikino
homepagehttps://chkit.obsessiondb.com
has_readme
has_docs_dir
has_description

Seguridad

¿Son sólidas las prácticas visibles de seguridad y de cadena de suministro, sin exposición jurisdiccional de alto riesgo sin resolver?

46En riesgo · 16% del índice global
Cómo se puntúa
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — branch protection not enabled on development/release branches
2.5/2.5CI-Tests — 20 out of 20 merged PRs checked by a CI test -- score normalized to 10
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 0/30 approved changesets -- score normalized to 0
2.5/2.5Contributors — project has 5 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5Licencia — license file detected
7.5/7.5Maintained — 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
0/5Packaging — sin datos
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
5/5SAST — SAST tool is run on all commits
5/5Security-Policy — security policy file detected
0/7.5Signed-Releases — sin datos
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
0/7.5Vulnerabilities — 51 existing vulnerabilities detected
Datos de entrada utilizados
sourceopenssf_scorecard
checks_evaluated16
scorecard_versionv5.5.0
checks_inconclusive2
scorecard_aggregate4,6
Excluidos de la puntuación (sin datos o no aplicable): packaging, signed_releases. Los pesos restantes se han renormalizado.

Preparación para IA

¿Hasta qué punto está el repositorio preparado para desarrollarse y mantenerse con agentes de codificación de IA? Es una insignia independiente y experimental — peso 0,0, de modo que se presenta por separado y no afecta a la puntuación de salud global.

72Bueno · 0% del índice global
Cómo se puntúa
45/45Instrucciones para agentes — CLAUDE.md
0/15Documentación legible por máquinas (llms.txt)
40/40Historial de commits legible — 92 de 100 commits humanos declaran su intención (asunto estructurado o cuerpo explicativo)
Datos de entrada utilizados
has_llms_txtno
legible_history_share0,92
agent_instruction_filesCLAUDE.md
agent_instruction_max_bytes4596
Cómo se puntúa
0/18Arranque con un solo comando
22/22Pruebas automatizadas
11/11Configuración de lint / formato — biome.json
11/11Verificación estática de tipos — apps/docs/tsconfig.json, packages/cli/tsconfig.json, packages/clickhouse/tsconfig.json, packages/codegen/tsconfig.json, packages/core/tsconfig.json, packages/create-chkit/tsconfig.json, packages/plugin-backfill/tsconfig.json, packages/plugin-codegen/tsconfig.json, packages/plugin-obsessiondb/tsconfig.json, packages/plugin-pull/tsconfig.json, tsconfig.json
10/10Entorno reproducible — Dockerfile
10/10Práctica demostrada con agentes — 17 de los últimos 100 commits con autoría o crédito de agente
0/8Mantenimiento automatizado — no se observan actualizaciones automáticas de dependencias
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Datos de entrada utilizados
has_nixno
has_tests
lockfiles
has_dockerfile
typed_language
bootstrap_files
has_devcontainerno
has_linter_config
typecheck_configsapps/docs/tsconfig.json, packages/cli/tsconfig.json, packages/clickhouse/tsconfig.json, packages/codegen/tsconfig.json, packages/core/tsconfig.json, packages/create-chkit/tsconfig.json, packages/plugin-backfill/tsconfig.json, packages/plugin-codegen/tsconfig.json, packages/plugin-obsessiondb/tsconfig.json, packages/plugin-pull/tsconfig.json, tsconfig.json
agent_commit_share0,17
toolchain_manifests
dependency_bot_commit_share0
Cómo se puntúa
45/45Código verificable por tipos — TypeScript (tipado estático)
55/55Tamaños de archivo manejables — 0/276 archivos fuente de más de 60 KB
Datos de entrada utilizados
primary_languageTypeScript
largest_source_bytes56.670
source_files_sampled276
oversized_source_files0
Cómo se puntúa
0/40Esquema de API (OpenAPI/GraphQL/proto)
0/20Servidor MCP
40/40Ejemplos ejecutables — examples
Datos de entrada utilizados
example_dirsexamples
has_mcp_signalno
api_schema_files

Datos clave

21estrellas de GitHub
3contribuidores
297commits en los últimos 12 meses
2días desde el último push
0versiones publicadas
1factor bus
5issues abiertas
npmecosistemas de paquetes

Advertencias de recopilación de datos

  • 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

Más detalle

Historial de estrellas y forks 0 ★ / 2 ⇿
0Estrellas
2Forks

Cuándo se añadió cada estrella y fork, recopilado de GitHub y agrupado por día. El crecimiento acumulado se sitúa justo encima de las adiciones diarias que lo componen, de modo que ambos se leen en conjunto: la acumulación orgánica sostenida no se parece en nada a un pico abrupto y efímero. Cuando esa diferencia es medible, se informa como autenticidad del crecimiento.

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

Evaluación de seguridad independiente y agnóstica en cuanto a herramientas, procedente del proyecto de código abierto OpenSSF Scorecard. Cada comprobación premia una práctica de seguridad, no la herramienta de un proveedor concreto. Las comprobaciones que Scorecard no pudo determinar se marcan como n/d y se excluyen de la puntuación de seguridad (nunca se cuentan como cero).Scorecard v5.5.0 · 2026-07-23 00:32 UTC

10Binary-Artifactsno binaries found in the repo
0Branch-Protectionbranch protection not enabled on development/release branches
10CI-Tests20 out of 20 merged PRs checked by a CI test -- score normalized to 10
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/30 approved changesets -- score normalized to 0
10Contributorsproject has 5 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
10Maintained30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10
n/dPackagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
10SASTSAST tool is run on all commits
10Security-Policysecurity policy file detected
n/dSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
0Vulnerabilities51 existing vulnerabilities detected
Dependencias directas 33
RegistroPaqueteRestricción de versiónManifiesto
npmfast-glob^3.3.2packages/cli/package.json
npm@chkit/clickhouseworkspace:*packages/cli/package.json
npm@chkit/codegenworkspace:*packages/cli/package.json
npm@chkit/coreworkspace:*packages/cli/package.json
npm@logtape/logtape^2.0.5packages/cli/package.json
npm@chkit/coreworkspace:*packages/clickhouse/package.json
npm@clickhouse/client^1.18.0packages/clickhouse/package.json
npm@logtape/logtape^2.0.5packages/clickhouse/package.json
npmp-retry^7.1.1packages/clickhouse/package.json
npm@chkit/coreworkspace:*packages/codegen/package.json
npmfast-glob^3.3.2packages/core/package.json
npmjiti^2.7.0packages/core/package.json
npm@chkit/plugin-obsessiondbworkspace:*packages/create-chkit/package.json
npm@clack/prompts^1.4.0packages/create-chkit/package.json
npmcommander^14.0.3packages/create-chkit/package.json
npmgiget^3.2.0packages/create-chkit/package.json
npmpicocolors^1.1.1packages/create-chkit/package.json
npm@chkit/clickhouseworkspace:*packages/plugin-backfill/package.json
npm@chkit/coreworkspace:*packages/plugin-backfill/package.json
npm@logtape/logtape^2.0.5packages/plugin-backfill/package.json
npmp-map^7.0.4packages/plugin-backfill/package.json
npmzod^4.3.6packages/plugin-backfill/package.json
npm@chkit/coreworkspace:*packages/plugin-codegen/package.json
npm@chkit/clickhouseworkspace:*packages/plugin-obsessiondb/package.json
npm@chkit/coreworkspace:*packages/plugin-obsessiondb/package.json
npm@chkit/plugin-backfillworkspace:*packages/plugin-obsessiondb/package.json
npm@clack/prompts^1.4.0packages/plugin-obsessiondb/package.json
npm@orpc/client1.13.4packages/plugin-obsessiondb/package.json
npm@orpc/contract1.13.4packages/plugin-obsessiondb/package.json
npmzod^4.3.6packages/plugin-obsessiondb/package.json
npm@chkit/clickhouseworkspace:*packages/plugin-pull/package.json
npm@chkit/coreworkspace:*packages/plugin-pull/package.json
npmzod^4.3.6packages/plugin-pull/package.json
Todas las dependencias no recopilado

No fue posible recopilar el conjunto de dependencias resuelto para este informe: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

Informe JSON sin procesar legible por máquina
{
  "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"
}

Las puntuaciones son señales, no garantías. Reflejan prácticas públicamente visibles en GitHub; no son una auditoría de código ni una garantía de seguridad.

Los datos ausentes se excluyen y los pesos se renormalizan; nunca se puntúan como cero. La metodología es versionada y abierta: métricas v1.13.0, esquema v0.27.0 — metodología completa · wiki de métricas.

Cómo se sitúa un resultado dentro del registro general: estadísticas agregadasnpm.