Registro público
Informe de salud del softwareesquema 0.27.0 · métricas 1.13.0 · 2026-07-25 19:28 UTC

melihbirim / csvql

SQL queries for CSV files. Ultra-fast CSV query engine in Zig with SIMD parsing and parallel execution. CLI: csvql.

ZigMIT★ 20 estrellas⑂ 1 forkdesde feb 2026Ver en GitHub ↗

melihbirim/csvql tiene un índice de salud de 62 sobre 100, lo que lo sitúa en la banda Moderado. Su puntuación más alta es Engineering Quality (81/100) y la más baja, AI Readiness (42/100). Se actualizó por última vez hoy. Una sola persona concentra la mayor parte del trabajo reciente.

62
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.

62
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

Melih BirimCuenta personal
26 seguidores60 repositorios públicosdesde sept 2010

Este repositorio pertenece a una cuenta personal. Un proyecto con un único propietario conlleva más riesgo de continuidad que uno respaldado por una organización.

Ecosistemas de paquetes

RegistroPaqueteVersiónDescargas / mesVersionesÚltima publicaciónEtiquetas
npmcsvql-query1.7.211999hace 0 díascsvsqlquerysimdfastetlparser
PyPIcsvql-query1.7.2-19hace 0 díascsvquerysqlfastsimd

Métricas por categoría

Vitalidad

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

78Bueno · 22% del índice global
Cómo se puntúa
36/36Recencia de push — último push hace 0 días
5.5/36Cadencia de commits — 8/52 semanas con commits
18/18Volumen de commits — 135 commits en el último año
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 28 issue activity found in the last 90 days -- score normalized to 10
Datos de entrada utilizados
commits_last_year135
human_commit_share1
days_since_last_push0
active_weeks_last_year8
Cómo se puntúa
27/27Publica versiones — 35 versiones publicadas
36/36Recencia de las versiones — última versión hace 0 días
27/27Cadencia de publicación — una versión cada ~2,8 días
0/10OpenSSF Scorecard: Signed-Releases — Project has not signed or included provenance with any releases.
Datos de entrada utilizados
releases_count35
latest_release_tagv1.7.2
releases_from_tagsno
days_since_latest_release0
mean_days_between_releases2,8

Comunidad y Adopción

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

46En riesgo · 18% del índice global
Cómo se puntúa
20.7/60Estrellas — 20 estrellas
0/25Forks — 1 forks
0/15Observadores — 0 observadores
Datos de entrada utilizados
forks1
stars20
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
0/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_conductno
has_pull_request_templateno
Cómo se puntúa
41.1/80Descargas mensuales — 1199 descargas/mes en npm, pypi
0/20Dependientes en el registro — no lo informa este ecosistema
Datos de entrada utilizados
packagescsvql-query, csvql-query
dependents
ecosystemsnpm, pypi
total_downloads
monthly_downloads1199
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?

56Moderado · 24% del índice global
Cómo se puntúa
9/54Factor bus — la mitad de los commits recae en 1 contribuyente(s)
0.2/22.5Distribución de commits — el principal contribuyente firma el 99% de los commits
2.7/13.5Amplitud de contribuyentes — 2 contribuyentes
0/10OpenSSF Scorecard: Contributors — project has 0 contributing companies or organizations -- score normalized to 0
Datos de entrada utilizados
bus_factor1
contributors_sampled2
top_contributor_share0,993
Cómo se puntúa
36.7/46.8Resolución de issues — 79% de issues cerradas
36.2/38.3Aceptación de PR — 35/37 PR decididos fusionados
0/15OpenSSF Scorecard: Code-Review — Found 1/30 approved changesets -- score normalized to 0
Datos de entrada utilizados
merged_prs35
open_issues9
closed_issues33
issue_closed_ratio0,786
closed_unmerged_prs2
Cómo se puntúa
10/30Respaldo de la propiedad — cuenta personal (usuario)
0/20Dominio verificado — no aplicable a cuentas de usuario
10.3/25Alcance del propietario — 26 seguidores de melihbirim
25/25Trayectoria — 60 repos públicos, cuenta de ~15 años
Datos de entrada utilizados
followers26
owner_typeUser
is_verified
owner_loginmelihbirim
public_repos60
account_age_days5793
Excluidos de la puntuación (sin datos o no aplicable): Dominio verificado. Los pesos restantes se han renormalizado.
Cómo se puntúa
25/25Publicado y resoluble — 2 paquete(s) en npm, pypi
35/35Recencia de publicación — última publicación hace 0 días
20/20Historial de versiones — 19 versiones en el registro
20/20No obsoleto — activo, ni obsoleto ni retirado
Datos de entrada utilizados
packagescsvql-query, csvql-query
ecosystemsnpm, pypi
any_deprecatedno
min_days_since_publish0

Calidad de Ingeniería

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

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

Documentación

100Excelente
Cómo se puntúa
30/30README
25/25Directorio de documentación
15/15Sitio de documentación / página del proyecto — https://melihbirim.github.io/csvql/
10/10Descripción del repositorio
10/10Topics — 13 topics
10/10Wiki
Datos de entrada utilizados
topicscsv, csv-parser, duckdb, sql, cli, command-line, data-processing, fast, query-engine, zig, ai-agents, llm, mcp
has_wiki
homepagehttps://melihbirim.github.io/csvql/
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?

45En 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 — 11 out of 11 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 1/30 approved changesets -- score normalized to 0
0/2.5Contributors — project has 0 contributing companies or organizations -- score normalized to 0
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 28 issue activity found in the last 90 days -- score normalized to 10
5/5Packaging — packaging workflow detected
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
0/5SAST — SAST tool is not run on all commits -- score normalized to 0
5/5Security-Policy — security policy file detected
0/7.5Signed-Releases — Project has not signed or included provenance with any releases.
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
7.5/7.5Vulnerabilities — 0 existing vulnerabilities detected
Datos de entrada utilizados
sourceopenssf_scorecard
checks_evaluated18
scorecard_versionv5.5.0
checks_inconclusive0
scorecard_aggregate4,5

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.

42En riesgo · 0% del índice global
Cómo se puntúa
0/45Instrucciones para agentes — sin CLAUDE.md / AGENTS.md / reglas de editor
0/15Documentación legible por máquinas (llms.txt)
40/40Historial de commits legible — 97 de 100 commits humanos declaran su intención (asunto estructurado o cuerpo explicativo)
Datos de entrada utilizados
has_llms_txtno
legible_history_share0,97
agent_instruction_files
agent_instruction_max_bytes
Cómo se puntúa
0/18Arranque con un solo comando
22/22Pruebas automatizadas
0/11Configuración de lint / formato
0/11Verificación estática de tipos
10/10Entorno reproducible — lockfile
8/10Práctica demostrada con agentes — 4 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
lockfilespackage-lock.json
has_dockerfileno
typed_languageno
bootstrap_files
has_devcontainerno
has_linter_configno
typecheck_configs
agent_commit_share0,04
toolchain_manifests
dependency_bot_commit_share0
Cómo se puntúa
0/45Código verificable por tipos — Zig sin configuración de verificación de tipos
55/55Tamaños de archivo manejables — 0/12 archivos fuente de más de 60 KB
Datos de entrada utilizados
primary_languageZig
largest_source_bytes19.418
source_files_sampled12
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

20estrellas de GitHub
2contribuidores
135commits en los últimos 12 meses
0días desde el último push
35versiones publicadas
1factor bus
9issues abiertas
npm, PyPIecosistemas 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:csvql-query@1.7.2; advisories assessed against the repository dependency graph instead

Más detalle

OpenSSF Scorecard 4.5 / 10
4.5agregado

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-25 19:28 UTC

10Binary-Artifactsno binaries found in the repo
0Branch-Protectionbranch protection not enabled on development/release branches
10CI-Tests11 out of 11 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 1/30 approved changesets -- score normalized to 0
0Contributorsproject has 0 contributing companies or organizations -- score normalized to 0
10Dangerous-Workflowno dangerous workflow patterns detected
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
10Maintained30 commit(s) and 28 issue activity found in the last 90 days -- score normalized to 10
10Packagingpackaging workflow detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
0SASTSAST tool is not run on all commits -- score normalized to 0
10Security-Policysecurity policy file detected
0Signed-ReleasesProject has not signed or included provenance with any releases.
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
10Vulnerabilities0 existing vulnerabilities detected
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": [
        "csv",
        "csv-parser",
        "duckdb",
        "sql",
        "cli",
        "command-line",
        "data-processing",
        "fast",
        "query-engine",
        "zig",
        "ai-agents",
        "llm",
        "mcp"
      ],
      "is_fork": false,
      "size_kb": 11039,
      "has_wiki": true,
      "homepage": "https://melihbirim.github.io/csvql/",
      "languages": {
        "Zig": 682985,
        "Shell": 75743,
        "Python": 15515,
        "JavaScript": 63808
      },
      "pushed_at": "2026-07-25T19:20:24Z",
      "created_at": "2026-02-23T10:37:50Z",
      "owner_type": "User",
      "updated_at": "2026-07-25T19:20:25Z",
      "description": "SQL queries for CSV files. Ultra-fast CSV query engine in Zig with SIMD parsing and parallel execution. CLI: csvql.",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "main",
      "license_spdx_raw": "MIT",
      "primary_language": "Zig",
      "significant_languages": [
        "Zig"
      ]
    },
    "owner": {
      "blog": null,
      "name": "Melih Birim",
      "type": "User",
      "login": "melihbirim",
      "company": null,
      "location": "London",
      "followers": 26,
      "avatar_url": "https://avatars.githubusercontent.com/u/398797?v=4",
      "created_at": "2010-09-14T12:15:33Z",
      "is_verified": null,
      "public_repos": 60,
      "account_age_days": 5793
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": true
    },
    "activity": {
      "releases": [
        {
          "tag": "v1.7.2",
          "kind": "patch",
          "published_at": "2026-07-25T19:21:37Z"
        },
        {
          "tag": "v1.7.1",
          "kind": "patch",
          "published_at": "2026-07-20T15:23:42Z"
        },
        {
          "tag": "v1.7.0",
          "kind": "minor",
          "published_at": "2026-07-17T14:41:02Z"
        },
        {
          "tag": "v1.6.1",
          "kind": "patch",
          "published_at": "2026-07-17T13:41:55Z"
        },
        {
          "tag": "v1.6.0",
          "kind": "minor",
          "published_at": "2026-07-14T08:26:06Z"
        },
        {
          "tag": "v1.5.13",
          "kind": "patch",
          "published_at": "2026-06-30T22:24:16Z"
        },
        {
          "tag": "v1.5.12",
          "kind": "patch",
          "published_at": "2026-06-30T22:17:43Z"
        },
        {
          "tag": "v1.5.11",
          "kind": "patch",
          "published_at": "2026-06-30T17:43:42Z"
        },
        {
          "tag": "v1.5.10",
          "kind": "patch",
          "published_at": "2026-06-30T17:34:47Z"
        },
        {
          "tag": "v1.5.9",
          "kind": "patch",
          "published_at": "2026-06-30T17:15:45Z"
        },
        {
          "tag": "v1.5.8",
          "kind": "patch",
          "published_at": "2026-06-30T17:09:51Z"
        },
        {
          "tag": "v1.5.7",
          "kind": "patch",
          "published_at": "2026-06-30T16:41:11Z"
        },
        {
          "tag": "v1.5.6",
          "kind": "patch",
          "published_at": "2026-06-30T16:35:44Z"
        },
        {
          "tag": "v1.5.5",
          "kind": "patch",
          "published_at": "2026-06-30T16:14:08Z"
        },
        {
          "tag": "v1.5.4",
          "kind": "patch",
          "published_at": "2026-06-30T15:52:23Z"
        },
        {
          "tag": "v1.5.3",
          "kind": "patch",
          "published_at": "2026-06-30T15:34:59Z"
        },
        {
          "tag": "v1.5.2",
          "kind": "patch",
          "published_at": "2026-06-30T14:50:29Z"
        },
        {
          "tag": "v1.5.1",
          "kind": "patch",
          "published_at": "2026-05-05T11:00:48Z"
        },
        {
          "tag": "v1.5.0",
          "kind": "minor",
          "published_at": "2026-05-05T10:46:23Z"
        },
        {
          "tag": "v1.4.0",
          "kind": "minor",
          "published_at": "2026-05-05T09:39:23Z"
        },
        {
          "tag": "v1.3.0",
          "kind": "minor",
          "published_at": "2026-04-14T17:02:28Z"
        },
        {
          "tag": "v1.2.2",
          "kind": "patch",
          "published_at": "2026-04-14T16:56:10Z"
        },
        {
          "tag": "v1.2.1",
          "kind": "patch",
          "published_at": "2026-04-14T16:44:52Z"
        },
        {
          "tag": "v1.2.0",
          "kind": "minor",
          "published_at": "2026-04-14T16:39:23Z"
        },
        {
          "tag": "v1.1.1",
          "kind": "patch",
          "published_at": "2026-04-14T15:32:29Z"
        },
        {
          "tag": "v1.1.0",
          "kind": "minor",
          "published_at": "2026-04-14T10:41:41Z"
        },
        {
          "tag": "v1.0.1",
          "kind": "patch",
          "published_at": "2026-04-14T10:07:01Z"
        },
        {
          "tag": "v1.0.0",
          "kind": "major",
          "published_at": "2026-04-14T09:59:13Z"
        },
        {
          "tag": "v0.6.0",
          "kind": "minor",
          "published_at": "2026-03-13T21:49:52Z"
        },
        {
          "tag": "v0.5.0",
          "kind": "minor",
          "published_at": "2026-03-13T18:31:34Z"
        },
        {
          "tag": "v0.4.0",
          "kind": "minor",
          "published_at": "2026-03-09T09:58:04Z"
        },
        {
          "tag": "v0.3.0",
          "kind": "minor",
          "published_at": "2026-03-09T09:55:24Z"
        },
        {
          "tag": "v0.2.1",
          "kind": "patch",
          "published_at": "2026-02-24T23:23:29Z"
        },
        {
          "tag": "v0.2.0",
          "kind": "minor",
          "published_at": "2026-02-24T16:52:58Z"
        },
        {
          "tag": "v0.1.0",
          "kind": "minor",
          "published_at": "2026-02-24T11:43:14Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "ef72b5469926b3172ba01cf9387dadc3a77f6dae",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.7.2",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-25T19:20:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8fc9b62b6ce03523cfad90c74befe83790c64348",
          "body": "Closes #68 #69.",
          "is_bot": false,
          "headline": "feat: SPLIT_PART and GREATEST/LEAST scalar functions",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-25T19:19:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b2960914a2c671fa3dedf5028925ecf099bec078",
          "body": "Closes #67.",
          "is_bot": false,
          "headline": "feat: REPLACE(col, 'from', 'to') scalar function",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-25T19:08:53Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "402a6b640945f99cb543e8d4286d5962b26b01e1",
          "body": null,
          "is_bot": false,
          "headline": "docs: link the website in README nav",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-25T18:57:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cb2d70a5cb7ce8f4c4d4f1739cf9826599c4e2eb",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.7.1",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-20T15:22:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "902e6e7901f8b33bd281a7f6c30527aacc9714d4",
          "body": "Landing page at docs/index.html.",
          "is_bot": false,
          "headline": "docs: GitHub Pages landing site",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-20T15:17:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3d7cdd1e77b465b0c3a5b3837be7071003385526",
          "body": "Closes #77.",
          "is_bot": false,
          "headline": "feat: --no-input-header support for JOIN",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-20T15:12:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "10966a63b8efcf779767052a4d50d84fbe25e98a",
          "body": null,
          "is_bot": false,
          "headline": "docs: refresh roadmap with v1.7.0 features and planned work",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-17T15:06:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "43c372258de784899b57ac6507c3d866e00fa069",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.7.0",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-17T14:39:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d7a717d827538e11f6d2d17e24bcc9ecd3625f63",
          "body": "Closes #62.",
          "is_bot": false,
          "headline": "feat: --audit query log for compliance",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-17T14:38:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4059b09ea2076a28e9dd9da6f029f5886ca3c0df",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.6.1",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-17T13:40:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5acd9ff768ef350ad0194fc01a6ef3c6a1660910",
          "body": "Closes #61.",
          "is_bot": false,
          "headline": "docs: add SECURITY.md",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-16T21:26:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c42068664c9057c7e8a9d44f5804c95f68149ebe",
          "body": "Closes #49. Treat row 0 as data, auto-name columns c1..cN. Centralizes mmap header parsing into csv.resolveMmapHeader; streaming paths retain row 0. +1 test.",
          "is_bot": false,
          "headline": "feat: --no-input-header for headerless CSVs (c1..cN)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-16T10:05:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3d3350ec2d22687140a1d9ebff6226bd3418a743",
          "body": "* feat: add threads option for parallel execution\n\n* fix: address thread handling review feedback",
          "is_bot": false,
          "headline": "feat: add --threads option for parallel execution (#64)",
          "author_name": "Ehtasham Yasin",
          "author_login": "Ehtasham-Yasin",
          "committed_at": "2026-07-15T16:05:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "85df9662659f6fb5e934c2de079970155c23688e",
          "body": null,
          "is_bot": false,
          "headline": "docs: link good first issues in Contributing",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-15T08:13:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5b95afa9684fdb7bc562432ff24795cb8e1e3ca3",
          "body": "Closes #58. Confines file access to allowed dirs (blocks traversal/symlink escape); enforced across CLI + MCP. README on-prem SSH model + read-only posture. +1 test.",
          "is_bot": false,
          "headline": "feat: --root path sandbox + on-prem/SSH docs (security)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-14T08:52:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7eb9027c71a4c18762bc9ed4741346c3abcc4d94",
          "body": null,
          "is_bot": false,
          "headline": "docs: read-only + on-prem positioning as next north star",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-14T08:38:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ebf8b39d6e89922d5f1362f24cdee9a4b4c30b6b",
          "body": null,
          "is_bot": false,
          "headline": "ci: build and attach per-platform .mcpb bundles to releases",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-14T08:26:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "95593ee101027ab20ffeeba424d86e3b9214954b",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.6.0",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-14T08:24:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ac21b8a247a26c71d10588e25654bfb2f8ecf7de",
          "body": "… (drop DuckDB)",
          "is_bot": false,
          "headline": "docs: realign logo badges to identity — tokens, agent/MCP, zero-setup…",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-14T08:23:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b359da00410fb5115a834edb3c0e7e4a8752616c",
          "body": "… token economics\n\nDuckDB moves from the headline to the Performance section (a benchmark, not the identity). Intro now: identity, token economics, in-place query example.",
          "is_bot": false,
          "headline": "docs: reposition intro — analytical CSV engine + agent MCP, lead with…",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-14T08:21:34Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "459fad12937a60d4da2074f41427d6fed1c500f0",
          "body": null,
          "is_bot": false,
          "headline": "docs: add north-star positioning to README intro",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-14T08:19:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b867ac49a4e6a8de4b0588ab4639b17f21d28dbd",
          "body": null,
          "is_bot": false,
          "headline": "docs: note csvql reads raw CSV at OS read-ceiling speed (== cat)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-14T08:18:53Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a0200b2fb100e3eb21ecf2ca8837eb08e3910679",
          "body": "… 230M)",
          "is_bot": false,
          "headline": "docs: agent/token hero — query files instead of pasting (43 tokens vs…",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-14T08:11:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "182d73904f9a183cf1763aa571eda952dad137f0",
          "body": null,
          "is_bot": false,
          "headline": "docs: add DuckDB benchmark writeup (published on Medium)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-13T13:36:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "364a4f7fa00af62efef176fd6d3cfbacff17c9b2",
          "body": "…undle\n\nCloses #54 #55 #56. csv_query row+byte caps, csvql install (Code+Desktop), .mcpb bundle, cross-platform temp fix, logo refresh, +5 tests.",
          "is_bot": false,
          "headline": "feat: MCP for Claude — token guardrails, one-command install, .mcpb b…",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-13T13:36:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "61a24cb30d16c5978f1bd0717fb13d398eee9bc7",
          "body": "…nchmarks (speed/memory/tokens)\n\nFixes #46 #47 #48. Adds DATE_PART(), bench_taxi.sh (speed + --resources), bench_tokens.py, README benchmark tables, +3 tests (130 total).",
          "is_bot": false,
          "headline": "fix: GROUP BY ROUND + ORDER BY aggregates; add DATE_PART, NYC-taxi be…",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-07-13T12:50:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3b834622e5b8afbf5f9ffbe348a8918a9a0b5e03",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.13",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T22:22:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "35d9e75a94bf550e1926345cae3e112d1a0f2a4c",
          "body": null,
          "is_bot": false,
          "headline": "docs: add README for npm package",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T22:21:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0be4c9850244133145116a262b8e118522672926",
          "body": null,
          "is_bot": false,
          "headline": "fix: force npm 11.5.1+ for OIDC trusted publishing",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T22:14:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f1a015eebb45bb4b23b0235086966dbb2df65729",
          "body": null,
          "is_bot": false,
          "headline": "fix: delete empty _authToken from npmrc to unblock OIDC exchange",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T22:09:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "133fa9e2b764a8c3299372e37ef7e1dcbd36703d",
          "body": null,
          "is_bot": false,
          "headline": "fix: remove registry-url from setup-node to unblock OIDC auth",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T22:01:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0f675cf8d96da88981c0fd65cc77395395efba0a",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.12",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:51:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b8cb4444aa22f401cb60a817425c938e71286b42",
          "body": "…OIDC",
          "is_bot": false,
          "headline": "fix: add publishConfig provenance, use NPM_CONFIG_PROVENANCE env for …",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:51:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1ef1be6fed14cf1b40acf6859240dcd144319405",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.11",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:42:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9e9ee73a3d4e182e29a28b7dbe8660411aa418a8",
          "body": null,
          "is_bot": false,
          "headline": "fix: use Node 24 for npm publish (requires npm v11.5.1+ for OIDC)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:41:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0502e8a00c6e793c7c20050b0adefa6bd679146c",
          "body": null,
          "is_bot": false,
          "headline": "ci: merge npm publish into release workflow",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:40:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "caf7a1df8ab1648b8ed8d4ade7f2a9bb7639586e",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.10",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:33:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "abcd53b6334a6514b3c4527b9c4c4c44eb47b284",
          "body": "…facts",
          "is_bot": false,
          "headline": "ci: build node addons in release workflow, npm-publish downloads arti…",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:26:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0c000726d8abd880eb0cb4019739d993ad8f5b0a",
          "body": null,
          "is_bot": false,
          "headline": "ci: add workflow_dispatch for manual npm-publish runs",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:21:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b1dc10a65555545f970d330e229a597e3adee88f",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.9",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:14:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fed9ffa2da97a5bba27dca915a71419eb01872d1",
          "body": null,
          "is_bot": false,
          "headline": "fix: normalize repository url in package.json",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:13:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cf88d29bdd79b48524301eca5152c39aca388338",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.8",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T17:08:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "617cc2ef20f54d20d56bc2bf953a0f6c81e5ab13",
          "body": null,
          "is_bot": false,
          "headline": "fix: download node headers tarball directly on Windows",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T16:59:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8878599f6cacf950ca2b093276437ae28b4812b2",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.7",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T16:39:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "dea2041623d88a9bde1f4d157fe17cc6c6a87422",
          "body": null,
          "is_bot": false,
          "headline": "fix: fetch node headers on Windows before building addon",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T16:39:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7c9bb4c5946015c282d0050d755daf0fcff94814",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.6",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T16:34:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "025fa9377313364ef68bf9273e1d3bcc3c5fc8c5",
          "body": null,
          "is_bot": false,
          "headline": "feat: single npm package with all platform binaries bundled",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T16:33:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e3075368511c36b39e1d07274766a12a3777fd97",
          "body": null,
          "is_bot": false,
          "headline": "revert: remove NPM_TOKEN, keep pure OIDC trusted publishing",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T16:29:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "85a811badf8ac10ffecaa9c0e3822d4c8a10a641",
          "body": "…packages)",
          "is_bot": false,
          "headline": "ci: add NPM_TOKEN for initial package creation (OIDC cant create new …",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T16:17:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "63a0f42149a7d33bc3d51c78d41f3fc8f82fcff9",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.5",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T16:12:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "84c4067295d7f25f566e7bbff7d4d77ced4e05a4",
          "body": "…lability)",
          "is_bot": false,
          "headline": "ci: replace macos-13 runners with macos-14 cross-compile (faster avai…",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T16:10:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f35a0c8e76d7551684f7d9bddfdf9d5f86498e6b",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.4",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T15:50:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "be304bb4ffc442117d0e97a216b7e949a1e51e16",
          "body": null,
          "is_bot": false,
          "headline": "fix: use correct platform dir names in npm-publish workflow",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T15:46:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b90137bf80f61bfaca12d5fbeb1a525ab603f784",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.3",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T15:33:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3132632367fa762b4f7330440448909583be39e1",
          "body": "…mples",
          "is_bot": false,
          "headline": "fix: Windows compat in mcp.zig, lib.zig, node_binding.zig, bench, exa…",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T15:28:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c2ab39bcf75f158bd4d973c764edb53dbec9850a",
          "body": null,
          "is_bot": false,
          "headline": "fix: mmap Windows compat in mmap_engine.zig",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T15:20:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "146038718564da7dc74e0c498056775d905a2767",
          "body": null,
          "is_bot": false,
          "headline": "fix: cross-platform stdin/stdout/stderr and mmap for Windows",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T15:15:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "92f4c6e54da1e97b46992318907cf5e292d8663e",
          "body": null,
          "is_bot": false,
          "headline": "fix: GetStdHandle returns error union in Zig 0.15, use try",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T15:05:53Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "60e306d766d2e071d707be0c7802431dd08700ab",
          "body": null,
          "is_bot": false,
          "headline": "fix: use Windows HANDLE for stdin on Windows, POSIX fd elsewhere",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T15:01:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a84626793633e7b4e703ad5285bf6512d5386d2e",
          "body": null,
          "is_bot": false,
          "headline": "ci: add Windows to test matrix",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:56:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d6a8a08fa479cc48d4fd545417816d45d3cfbb74",
          "body": null,
          "is_bot": false,
          "headline": "ci: bump softprops/action-gh-release to v2 (Node 24)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:54:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4482b2d3532a37fe31d84850cb55a063557e3cc6",
          "body": null,
          "is_bot": false,
          "headline": "fix: apply zig fmt to build.zig",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:53:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c580f18865dd563708cdc5d2f22c27066b72d07e",
          "body": null,
          "is_bot": false,
          "headline": "ci: pin macos runners to macos-14 to avoid Zig/macOS 15 linker breakage",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:52:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "801cc8c428f41046ee2d98727bea75ec53621cc0",
          "body": null,
          "is_bot": false,
          "headline": "ci: add Windows x86_64 CLI binary to release",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:50:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "514de52bc67589c4322f7f3302356f70a7739a9f",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.2",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:48:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "eb6ed699e08376c82ab8481231cea9d56514e5f0",
          "body": null,
          "is_bot": false,
          "headline": "chore: sync npm packages to v1.5.1, fix release.sh to bump npm versions",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:47:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8b77a95b198a3a5daf318c17a44ee2fc60c7fe1c",
          "body": null,
          "is_bot": false,
          "headline": "ci: switch npm publish to OIDC trusted publishing (no token)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:42:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6a4d94fa1c7b129e05652271546716e24b10dcca",
          "body": "Platform packages (csvql-query-{platform}-{arch}):\n  darwin-arm64, darwin-x64, linux-x64, linux-arm64, win32-x64\n  Each has os/cpu fields so npm installs only the matching one.\n  Binary (csvql.node) is dropped in by CI at publish time.\n\nMain package (csvql-query):\n  Lists all platform packages as op\n[…]\n ubuntu-24.04-arm.\n  Each runner builds csvql.node natively, publishes its platform package.\n  Main package published after all platform packages succeed.\n  Requires NPM_TOKEN secret in repo settings.",
          "is_bot": false,
          "headline": "feat: npm publish infrastructure for csvql-query",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:29:17Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "0cf2d4a85f7fb9b27f02f43c68b44a76b196c4c2",
          "body": "find(file, opts) translates simple options to SQL internally,\nso users who don't know SQL can still use the engine.\n\n  csvql.find('employees.csv', {\n      columns: ['name', 'city', 'salary'],\n      where:   'salary>100000 AND department=Engineering',\n      orderBy: 'salary:desc',\n      limit:   10,\n\n[…]\nesc' / 'col:asc'\n  limit    — max rows\n  + delimiter, comment, skipEmptyLines from QueryOptions\n\nFor GROUP BY / aggregates / JOIN, use query() instead.\n18/18 tests pass. README and index.d.ts updated.",
          "is_bot": false,
          "headline": "feat(nodejs): add find() — no-SQL API for CSV querying",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:23:32Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "9ae1ab7f467053245c71517e5bfc0d80437933c8",
          "body": "Explains the csv-parse vs csvql difference for the most common\nreal-world pattern: CSV → filter → database insert.\n\nCovers:\n- Why csv-parse must load all rows before filtering (parser only)\n- The cast:true boolean string footgun (silent 0 results)\n- How csvql pushes WHERE into the engine (heap scales with result, not file)\n- Comparison table: 100k rows, csv-parse 200ms +31MB vs csvql 22ms +3MB\n- On a 10GB file: csv-parse OOM, csvql same cost",
          "is_bot": false,
          "headline": "docs: add ETL section to Node.js library docs in README",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:20:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c703a25c6e90c788253f2b78ccb477cf8f677c83",
          "body": "node --experimental-sqlite example_etl.js\n\nShows csv-parse vs csvql for the most common real-world pattern:\nread CSV, filter rows, insert into database.\n\ncsv-parse: must load all 100k rows into memory as JS objects first,\nthen .filter() in JS (200ms, +31 MB heap).\n\ncsvql: WHERE clause runs inside th\n[…]\n+3 MB heap).\n\nAlso documents a csv-parse footgun: cast:true converts numbers\nbut leaves boolean strings as-is, so r.active === true silently\nreturns 0 rows. Must compare against 'true' string instead.",
          "is_bot": false,
          "headline": "feat(nodejs): ETL example — CSV filter → SQLite insert",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:19:31Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "5e50eec31cec6b1d7ff748490dd2f72ab792b353",
          "body": "node nodejs/example.js\n\nCovers:\n  1. SELECT * LIMIT\n  2. WHERE filter + ORDER BY\n  3. GROUP BY + COUNT + AVG\n  4. Top-N (ORDER BY LIMIT)\n  5. JOIN two CSV files\n  6. TSV file ({ delimiter: '\\t' })\n  7. Skip comment/blank lines ({ comment: '#', skipEmptyLines: true })\n  8. queryCsv — return CSV string\n  9. queryCsv — write result to file",
          "is_bot": false,
          "headline": "feat(nodejs): add example.js — runnable usage samples",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:07:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8b4375d6487bc8564deeeb9f49dd684ac026fef7",
          "body": "README: new Language Libraries section with Node.js + Python.\n  - query() / queryCsv() examples\n  - options table (delimiter, comment, skipEmptyLines)\n  - memory comparison note\n  - bench.js / compare.js pointers\n\nindex.js: full JSDoc with @typedef QueryOptions, @param, @returns,\n  @throws, and @example blocks for every function.\n\nindex.d.ts: QueryOptions interface + typed signatures for both exports.",
          "is_bot": false,
          "headline": "docs: document Node.js library in README and improve JSDoc",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T14:06:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7a9d927b2ca20392272ff9cc7547a455ee5f736b",
          "body": "query(sql, { delimiter: '\\t' })          — TSV / pipe / any separator\nquery(sql, { comment: '#' })             — skip comment rows\nquery(sql, { skipEmptyLines: true })     — skip blank lines\n\nWorks for JOIN queries too — all file paths in the SQL get preprocessed.\nDelimiter conversion is quote-aware (handles quoted fields containing the delimiter).\n13/13 tests pass.",
          "is_bot": false,
          "headline": "feat(nodejs): add delimiter, comment, skipEmptyLines options",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T12:52:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f652741d613b83670eeda7e87a5823c1f005feb7",
          "body": "Covers 10 real tasks: basic parse, type casting, custom delimiters,\nskip blank/comment rows, filter, aggregate, sort, JOIN, CSV writing,\nstreaming. Each shows code + actual output for all three libraries.",
          "is_bot": false,
          "headline": "feat(nodejs): functionality comparison script (compare.js)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T12:42:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ef8a362bedbf4bec56505b9561345cf22ce89029",
          "body": null,
          "is_bot": false,
          "headline": "bench(nodejs): show code + time + heap together per query",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T10:58:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "18b346b42a3fd326c8242ab7010a3429772c5fe8",
          "body": "Results on 42 MB / 1M row file:\n  GROUP BY:   csvql 10ms  +0 MB  vs csv-parse 1386ms +277 MB (143x faster)\n  ORDER BY:   csvql 23ms  +0 MB  vs csv-parse 1872ms +290 MB  (80x faster)\n  WHERE:      csvql 103ms +58 MB vs csv-parse 1357ms +289 MB  (13x faster)\n  LIMIT 5:    csvql 3ms   +0 MB  vs papaparse 389ms  +309 MB  (papaparse reads whole file)\n\nFeature table updated: csvql sync API stays ~5 MB;\ncsv-parse/papaparse sync APIs materialize all rows as JS objects.",
          "is_bot": false,
          "headline": "bench(nodejs): 1M rows, add heap memory tracking",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T10:53:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "313d2d7e1449ae2f2ad31cedafffb6c5e479287a",
          "body": "node bench.js — 200k rows, 4 queries, timing + feature matrix\n\nResults (8.3 MB file):\n  LIMIT 5      csvql 1.9ms  vs csv-parse 3.1ms  (1.6x faster)\n  GROUP BY     csvql 9ms    vs csv-parse 357ms   (39x faster)\n  WHERE        csvql 38ms   vs csv-parse 344ms   (9x faster)\n  ORDER BY     csvql 52ms   vs csv-parse 376ms   (7x faster)\n\nFeature diff: csvql has SQL; csv-parse/papaparse have streaming,\ncustom delimiters, browser support.",
          "is_bot": false,
          "headline": "feat(nodejs): benchmark vs csv-parse and papaparse",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T10:50:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e443b2358d9c88cec91a67faea1460806687a50d",
          "body": "Build: zig build node -Doptimize=ReleaseFast\nOutput: zig-out/lib/csvql.node\n\nAPI (mirrors Python package):\n  const { query, queryCsv } = require('csvql-query')\n  const rows = query(\"SELECT * FROM 'data.csv' WHERE salary > 100000\")\n  const csv  = queryCsv(\"SELECT city, COUNT(*) FROM 'data.csv' GROUP \n[…]\n at build time\n\nFiles:\n  nodejs/index.js     - JS entry point + loader\n  nodejs/index.d.ts   - TypeScript types\n  nodejs/package.json - npm package (csvql-query)\n  nodejs/test.js      - 8/8 tests pass",
          "is_bot": false,
          "headline": "feat: Node.js N-API addon (csvql.node)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T10:47:09Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "b25c80477dc1fdc02b615f2136367cfe73175e91",
          "body": null,
          "is_bot": false,
          "headline": "cleanup: remove generated CSVs, stale benchmarks, unused examples",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-06-30T10:30:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cf44a67c5c1d73aa98edcee67a24c3d7bfa9f0ae",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.1",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-05-05T10:58:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ace9e0d8328830be3c4019639649166f11468617",
          "body": "Co-authored-by: Copilot <copilot@github.com>",
          "is_bot": false,
          "headline": "enhance help text and schema options",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-05-05T10:58:22Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "49c138978f19b6a6d88e0320d1676be247641fcf",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.5.0",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-05-05T10:44:53Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ee5e8828ccd3d3ba49aba3024a1285e70aa5a73a",
          "body": "display for wrap text is updated\n\nCo-authored-by: Copilot <copilot@github.com>",
          "is_bot": false,
          "headline": "zigtable moved to inner lib from dependency",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-05-05T10:44:16Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "1bbd32643fc1d10961ffe2f3e663a443052334eb",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.4.0",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-05-05T09:37:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c54c1aeb1f9ba9c6122856057b67470b80982885",
          "body": "Co-authored-by: Copilot <copilot@github.com>",
          "is_bot": false,
          "headline": "multiline support added",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-05-05T09:37:17Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "5e150e366a349750c09ac260df1fa53440893730",
          "body": "Co-authored-by: Copilot <copilot@github.com>",
          "is_bot": false,
          "headline": "double quote reading, query and bulk reading fix (#45)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-05-01T14:42:22Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "e4114470105ff5bca59b4b8166335ed5a27ff543",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.3.0",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T17:00:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8e19323ff79a34e438cf1e81426b70e30e34ff06",
          "body": null,
          "is_bot": false,
          "headline": "fix: inject version from git tag into pyproject.toml during wheel build",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T17:00:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "229de6a1ef03272fa73872e71c89e83ac3f1a8a4",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.2.2",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T16:54:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "41b1b8ed8e96c31297af15ba46ca50fbe1657d73",
          "body": null,
          "is_bot": false,
          "headline": "docs: add PyPI project description (python/README.md)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T16:54:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8639d446888e858e52a820227bbb8c7c75e9f1e8",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.2.1",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T16:43:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "87135a810547638c181e5a7d215e3918cbc97daa",
          "body": null,
          "is_bot": false,
          "headline": "fix: use setuptools.build_meta backend, upgrade setuptools in CI",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T16:42:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a939400e101e4f035257888b366b33ed8282881a",
          "body": null,
          "is_bot": false,
          "headline": "chore: fix .gitignore (add __pycache__, fix corrupted line)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T16:37:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "253a62d1db1de69c91c9de7cb3d7d597bb14604e",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.2.0",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T16:36:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6f1acefe0990759b1af5840ecd8c4c4508cb06bc",
          "body": "* feat: add Python library (csvql-query) with ctypes\n\n* chore: remove __pycache__ from tracking, add to .gitignore\n\n* ci: add PyPI wheel build and publish jobs to release workflow",
          "is_bot": false,
          "headline": "Feat/python lib (#41)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T16:34:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cb304fef0e094c0f0590ba38f93b0e34bbc065db",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.1.1",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T15:31:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1393cc3682460dd251d8218cbc4939be799142f0",
          "body": "* updated paralel memory map implementation to match the 30GB file loads.\n\n* ci: trigger CI for PR #38",
          "is_bot": false,
          "headline": "feat: pread-based parallel I/O + zigtable terminal output (#40)",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T15:29:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5c0a58f934d956a10481de0b21a4373af3b30d0a",
          "body": null,
          "is_bot": false,
          "headline": "chore: bump version to 1.1.0",
          "author_name": "Melih Birim",
          "author_login": "melihbirim",
          "committed_at": "2026-04-14T10:40:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 35,
      "commits_last_year": 135,
      "latest_release_at": "2026-07-25T19:21:37Z",
      "latest_release_tag": "v1.7.2",
      "releases_from_tags": false,
      "days_since_last_push": 0,
      "active_weeks_last_year": 8,
      "days_since_latest_release": 0,
      "mean_days_between_releases": 2.8
    },
    "community": {
      "has_readme": true,
      "has_license": true,
      "has_description": true,
      "has_contributing": true,
      "health_percentage": 71,
      "has_issue_template": false,
      "has_code_of_conduct": false,
      "has_pull_request_template": false
    },
    "ecosystem": {
      "packages": [
        {
          "name": "csvql-query",
          "exists": true,
          "license": "MIT",
          "keywords": [
            "csv",
            "sql",
            "query",
            "simd",
            "fast",
            "etl",
            "parser"
          ],
          "ecosystem": "npm",
          "matches_repo": true,
          "registry_url": "https://www.npmjs.com/package/csvql-query",
          "is_deprecated": false,
          "latest_version": "1.7.2",
          "repository_url": "https://github.com/melihbirim/csvql",
          "versions_count": 9,
          "total_downloads": null,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": 1,
          "monthly_downloads": 1199,
          "first_published_at": "2026-06-30T14:43:55.747000Z",
          "latest_published_at": "2026-07-25T19:23:38.911000Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 0
        },
        {
          "name": "csvql-query",
          "exists": true,
          "license": "MIT",
          "keywords": [
            "csv",
            "query",
            "sql",
            "fast",
            "simd",
            "Development Status :: 4 - Beta",
            "Intended Audience :: Developers",
            "Intended Audience :: Science/Research",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.10",
            "Programming Language :: Python :: 3.11",
            "Programming Language :: Python :: 3.12",
            "Topic :: Database",
            "Topic :: Scientific/Engineering"
          ],
          "ecosystem": "pypi",
          "matches_repo": true,
          "registry_url": "https://pypi.org/project/csvql-query/",
          "is_deprecated": false,
          "latest_version": "1.7.2",
          "repository_url": "https://github.com/melihbirim/csvql",
          "versions_count": 19,
          "total_downloads": null,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": null,
          "first_published_at": "2026-04-14T16:48:25.442252Z",
          "latest_published_at": "2026-07-25T19:24:41.137470Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 0
        }
      ]
    },
    "popularity": {
      "forks": 1,
      "stars": 20,
      "watchers": 0,
      "fork_history": {
        "days": [
          {
            "date": "2026-07-14",
            "count": 1
          }
        ],
        "complete": true,
        "collected": 1,
        "total_forks": 1
      },
      "star_history": null,
      "open_issues_and_prs": 9
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [
        "examples"
      ],
      "has_llms_txt": false,
      "has_dockerfile": false,
      "has_mcp_signal": false,
      "bootstrap_files": [],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [],
      "toolchain_manifests": [],
      "largest_source_bytes": 19418,
      "source_files_sampled": 12,
      "oversized_source_files": 0,
      "agent_instruction_files": [],
      "agent_instruction_max_bytes": null
    },
    "dependencies": {
      "manifests": [
        "nodejs/package.json",
        "python/pyproject.toml",
        "python/setup.py"
      ],
      "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",
        "pypi"
      ],
      "dependencies": [],
      "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": 0,
        "merged_prs": 35,
        "open_issues": 9,
        "closed_ratio": 0.786,
        "closed_issues": 33,
        "closed_unmerged_prs": 2
      },
      "bus_factor": 1,
      "bot_contributors": 1,
      "top_contributors": [
        {
          "type": "User",
          "login": "melihbirim",
          "commits": 134,
          "avatar_url": "https://avatars.githubusercontent.com/u/398797?v=4"
        },
        {
          "type": "User",
          "login": "Ehtasham-Yasin",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/278709000?v=4"
        }
      ],
      "contributors_sampled": 2,
      "top_contributor_share": 0.993
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "ci.yml",
        "release.yml"
      ],
      "has_docs_dir": true,
      "linter_configs": [],
      "has_editorconfig": false,
      "has_linter_config": false,
      "has_precommit_config": false
    },
    "security_signals": {
      "lockfiles": [
        "package-lock.json"
      ],
      "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": "11 out of 11 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 1/30 approved changesets -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 0,
            "reason": "project has 0 contributing companies or organizations -- score normalized to 0",
            "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 28 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": 10,
            "reason": "packaging workflow 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": 0,
            "reason": "SAST tool is not run on all commits -- score normalized to 0",
            "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": 0,
            "reason": "Project has not signed or included provenance with any releases.",
            "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": 10,
            "reason": "0 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "ef72b5469926b3172ba01cf9387dadc3a77f6dae",
        "ran_at": "2026-07-25T19:28:16Z",
        "aggregate_score": 4.5,
        "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-25T19:24:46Z",
      "oldest_open_prs": [],
      "last_merged_pr_at": "2026-07-25T19:19:55Z",
      "ci_last_conclusion": "SUCCESS",
      "oldest_open_issues": [
        {
          "number": 50,
          "created_at": "2026-07-13T10:09:09Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 60,
          "created_at": "2026-07-14T08:38:30Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 65,
          "created_at": "2026-07-15T08:08:53Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 66,
          "created_at": "2026-07-15T08:08:54Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 69,
          "created_at": "2026-07-15T08:08:58Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 70,
          "created_at": "2026-07-15T08:08:59Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 71,
          "created_at": "2026-07-15T08:09:01Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 72,
          "created_at": "2026-07-15T08:09:02Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 73,
          "created_at": "2026-07-15T08:09:03Z",
          "last_comment_at": null,
          "last_comment_author": null
        }
      ]
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/melihbirim/csvql",
    "host": "github.com",
    "name": "csvql",
    "owner": "melihbirim"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "moderate",
      "name": "Overall health",
      "note": null,
      "notes": [],
      "value": 62,
      "inputs": {
        "security": 45,
        "vitality": 78,
        "community": 46,
        "governance": 56,
        "engineering": 81
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "good",
        "name": "Vitality",
        "value": 78,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "good",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 70,
            "inputs": {
              "commits_last_year": 135,
              "human_commit_share": 1,
              "days_since_last_push": 0,
              "active_weeks_last_year": 8
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 0 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "8/52 weeks with commits",
                "points": 5.5,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 8
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "135 commits in the last year",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 135
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "30 commit(s) and 28 issue activity found in the last 90 days -- score normalized to 10",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "release_discipline",
            "band": "excellent",
            "name": "Release discipline",
            "note": null,
            "notes": [],
            "value": 90,
            "inputs": {
              "releases_count": 35,
              "latest_release_tag": "v1.7.2",
              "releases_from_tags": false,
              "days_since_latest_release": 0,
              "mean_days_between_releases": 2.8
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "35 releases published",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "releases_published",
                    "params": {
                      "count": 35
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 0 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~2.8 days",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 2.8
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "openssf_scorecard_signed_releases",
                "name": "OpenSSF Scorecard: Signed-Releases",
                "detail": "Project has not signed or included provenance with any releases.",
                "points": 0,
                "status": "missed",
                "details": [],
                "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": "at_risk",
        "name": "Community & Adoption",
        "value": 46,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "critical",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 21,
            "inputs": {
              "forks": 1,
              "stars": 20,
              "watchers": 0,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "20 stars",
                "points": 20.7,
                "status": "partial",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 20
                    }
                  }
                ],
                "max_points": 60
              },
              {
                "key": "forks",
                "name": "Forks",
                "detail": "1 forks",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "forks",
                    "params": {
                      "count": 1
                    }
                  }
                ],
                "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": "good",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 70,
            "inputs": {
              "has_readme": true,
              "has_license": true,
              "has_contributing": true,
              "has_issue_template": false,
              "has_code_of_conduct": false,
              "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": 0,
                "status": "missed",
                "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": "moderate",
            "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": 51,
            "inputs": {
              "packages": [
                "csvql-query",
                "csvql-query"
              ],
              "dependents": null,
              "ecosystems": "npm, pypi",
              "total_downloads": null,
              "monthly_downloads": 1199
            },
            "components": [
              {
                "key": "monthly_downloads",
                "name": "Monthly downloads",
                "detail": "1,199 downloads/month across npm, pypi",
                "points": 41.1,
                "status": "partial",
                "details": [
                  {
                    "code": "downloads_monthly",
                    "params": {
                      "count": 1199,
                      "ecosystems": "npm, pypi"
                    }
                  }
                ],
                "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": 56,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "critical",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 12,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 2,
              "top_contributor_share": 0.993
            },
            "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 99% of commits",
                "points": 0.2,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 99
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "2 contributors",
                "points": 2.7,
                "status": "partial",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 2
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 0 contributing companies or organizations -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "good",
            "name": "Issue & PR responsiveness",
            "note": null,
            "notes": [],
            "value": 73,
            "inputs": {
              "merged_prs": 35,
              "open_issues": 9,
              "closed_issues": 33,
              "issue_closed_ratio": 0.786,
              "closed_unmerged_prs": 2
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "79% of issues closed",
                "points": 36.7,
                "status": "partial",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 79
                    }
                  }
                ],
                "max_points": 46.75
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "35/37 decided PRs merged",
                "points": 36.2,
                "status": "partial",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 35,
                      "decided": 37
                    }
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 1/30 approved changesets -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              }
            ]
          },
          {
            "key": "stewardship",
            "band": "moderate",
            "name": "Ownership & stewardship",
            "note": "Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "verified_domain"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 57,
            "inputs": {
              "followers": 26,
              "owner_type": "User",
              "is_verified": null,
              "owner_login": "melihbirim",
              "public_repos": 60,
              "account_age_days": 5793
            },
            "components": [
              {
                "key": "ownership_backing",
                "name": "Ownership backing",
                "detail": "personal (user) account",
                "points": 10,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_personal",
                    "params": {}
                  }
                ],
                "max_points": 30
              },
              {
                "key": "verified_domain",
                "name": "Verified domain",
                "detail": "not applicable to user accounts",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "not_applicable_to_user_accounts",
                    "params": {}
                  }
                ],
                "max_points": 20
              },
              {
                "key": "owner_reach",
                "name": "Owner reach",
                "detail": "26 followers of melihbirim",
                "points": 10.3,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 26,
                      "login": "melihbirim"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "60 public repos, account ~15 yr old",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 60
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 15
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "excellent",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "packages": [
                "csvql-query",
                "csvql-query"
              ],
              "ecosystems": "npm, pypi",
              "any_deprecated": false,
              "min_days_since_publish": 0
            },
            "components": [
              {
                "key": "published_resolvable",
                "name": "Published & resolvable",
                "detail": "2 package(s) on npm, pypi",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "packages_published",
                    "params": {
                      "count": 2,
                      "ecosystems": "npm, pypi"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "publish_recency",
                "name": "Publish recency",
                "detail": "latest publish 0 days ago",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "19 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 19
                    }
                  }
                ],
                "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": "good",
        "name": "Engineering Quality",
        "value": 81,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "moderate",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 68,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": false,
              "has_precommit_config": false
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "2 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 2
                    }
                  }
                ],
                "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": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "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": "11 out of 11 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": 100,
            "inputs": {
              "topics": [
                "csv",
                "csv-parser",
                "duckdb",
                "sql",
                "cli",
                "command-line",
                "data-processing",
                "fast",
                "query-engine",
                "zig",
                "ai-agents",
                "llm",
                "mcp"
              ],
              "has_wiki": true,
              "homepage": "https://melihbirim.github.io/csvql/",
              "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://melihbirim.github.io/csvql/",
                "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": "13 topics",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "topics_count",
                    "params": {
                      "count": 13
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "wiki",
                "name": "Wiki",
                "detail": null,
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          }
        ],
        "description": "Are baseline engineering and documentation practices in place?"
      },
      {
        "key": "security",
        "band": "at_risk",
        "name": "Security",
        "value": 45,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "at_risk",
            "name": "Security posture",
            "note": null,
            "notes": [],
            "value": 45,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 18,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 0,
              "scorecard_aggregate": 4.5
            },
            "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": "11 out of 11 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 1/30 approved changesets -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 0 contributing companies or organizations -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "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 28 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 detected",
                "points": 5,
                "status": "met",
                "details": [],
                "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 not run on all commits -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "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": "Project has not signed or included provenance with any releases.",
                "points": 0,
                "status": "missed",
                "details": [],
                "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": "0 existing vulnerabilities detected",
                "points": 7.5,
                "status": "met",
                "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": 3
            },
            "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": "at_risk",
        "name": "AI Readiness",
        "value": 42,
        "weight": 0,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "at_risk",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 40,
            "inputs": {
              "has_llms_txt": false,
              "legible_history_share": 0.97,
              "agent_instruction_files": [],
              "agent_instruction_max_bytes": null
            },
            "components": [
              {
                "key": "agent_instructions",
                "name": "Agent instructions",
                "detail": "no CLAUDE.md / AGENTS.md / editor rules",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_agent_instructions",
                    "params": {}
                  }
                ],
                "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": "97 of 100 human commits state their intent (structured subject or explanatory body)",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 97,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "at_risk",
            "name": "Verify loop (build / test / typecheck)",
            "note": null,
            "notes": [],
            "value": 40,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [
                "package-lock.json"
              ],
              "has_dockerfile": false,
              "typed_language": false,
              "bootstrap_files": [],
              "has_devcontainer": false,
              "has_linter_config": false,
              "typecheck_configs": [],
              "agent_commit_share": 0.04,
              "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": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 11
              },
              {
                "key": "reproducible_environment",
                "name": "Reproducible environment",
                "detail": "lockfile",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "lockfile"
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "demonstrated_agent_practice",
                "name": "Demonstrated agent practice",
                "detail": "4 of the last 100 commits agent-authored or agent-credited",
                "points": 8,
                "status": "partial",
                "details": [
                  {
                    "code": "agent_authored_commits",
                    "params": {
                      "count": 4,
                      "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": "moderate",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 55,
            "inputs": {
              "primary_language": "Zig",
              "largest_source_bytes": 19418,
              "source_files_sampled": 12,
              "oversized_source_files": 0
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "Zig without a type-check config",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_typecheck_config_language",
                    "params": {
                      "language": "Zig"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "0/12 source files over 60KB",
                "points": 55,
                "status": "met",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 12,
                      "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:csvql-query@1.7.2; advisories assessed against the repository dependency graph instead"
  ],
  "report_type": "repository",
  "generated_at": "2026-07-25T19:28:26.790635Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/m/melihbirim/csvql.svg",
  "full_name": "melihbirim/csvql",
  "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, PyPI.