Публічний реєстр
Звіт про здоров'я програмного забезпеченнясхема 0.27.0 · метрики 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 зірок⑂ 1 форкз лют. 2026 р.Переглянути на GitHub ↗

melihbirim/csvql має індекс здоров’я 62 зі 100, що відповідає смузі «Помірний». Найвищий показник — Engineering Quality (81/100), найнижчий — AI Readiness (42/100). Останнє оновлення — сьогодні. Більшість нещодавньої роботи виконує один учасник.

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

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

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

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

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

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

Власність

Melih BirimОсобистий обліковий запис
26 підписників60 публічних репозиторіївз вер. 2010 р.

Цей репозиторій належить особистому обліковому запису. Проєкт з єдиним власником несе більший ризик безперервності, ніж підтримуваний організацією.

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

РеєстрПакетВерсіяЗавантажень / місВерсіїОстання публікаціяТеги
npmcsvql-query1.7.21 19990 днів томуcsvsqlquerysimdfastetlparser
PyPIcsvql-query1.7.2-190 днів томуcsvquerysqlfastsimd

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

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

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

78Добрий · 22% загального індексу
Як обчислюється оцінка
36/36Свіжість push — останній push 0 дн. тому
5.5/36Ритм комітів — 8/52 тижнів із комітами
18/18Обсяг комітів — 135 комітів за останній рік
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 28 issue activity found in the last 90 days -- score normalized to 10
Використані вхідні дані
commits_last_year135
human_commit_share1
days_since_last_push0
active_weeks_last_year8
Як обчислюється оцінка
27/27Випускає релізи — опубліковано 35 релізів
36/36Свіжість релізів — останній реліз 0 дн. тому
27/27Ритм релізів — реліз кожні ~2,8 дн.
0/10OpenSSF Scorecard: Signed-Releases — Project has not signed or included provenance with any releases.
Використані вхідні дані
releases_count35
latest_release_tagv1.7.2
releases_from_tagsні
days_since_latest_release0
mean_days_between_releases2,8

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

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

46У зоні ризику · 18% загального індексу
Як обчислюється оцінка
20.7/60Зірки — 20 зірок
0/25Форки — 1 форків
0/15Спостерігачі — 0 спостерігачів
Використані вхідні дані
forks1
stars20
watchers0
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
Як обчислюється оцінка
22.5/22.5README
22.5/22.5Ліцензія — визнана ліцензія (MIT)
18/18Настанови CONTRIBUTING
0/13.5Кодекс поведінки
0/7.2Шаблон issue
0/6.3Шаблон PR
Використані вхідні дані
has_readmeтак
has_licenseтак
has_contributingтак
has_issue_templateні
has_code_of_conductні
has_pull_request_templateні
Як обчислюється оцінка
41.1/80Щомісячні завантаження — 1 199 завантажень/місяць у npm, pypi
0/20Залежні пакети в реєстрі — ця екосистема цього не повідомляє
Використані вхідні дані
packagescsvql-query, csvql-query
dependents
ecosystemsnpm, pypi
total_downloads
monthly_downloads1 199
Виключено з оцінювання (немає даних або не застосовно): Залежні пакети в реєстрі. Залишкові ваги перенормовано.

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

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

56Помірний · 24% загального індексу
Як обчислюється оцінка
9/54Бас-фактор — на 1 контриб’ютор(ів) припадає половина всіх комітів
0.2/22.5Розподіл комітів — головний контриб’ютор — автор 99% комітів
2.7/13.5Широта контриб’юторів — 2 контриб’юторів
0/10OpenSSF Scorecard: Contributors — project has 0 contributing companies or organizations -- score normalized to 0
Використані вхідні дані
bus_factor1
contributors_sampled2
top_contributor_share0,993
Як обчислюється оцінка
36.7/46.8Вирішення issue — закрито 79% issue
36.2/38.3Прийняття PR — злито 35/37 вирішених PR
0/15OpenSSF Scorecard: Code-Review — Found 1/30 approved changesets -- score normalized to 0
Використані вхідні дані
merged_prs35
open_issues9
closed_issues33
issue_closed_ratio0,786
closed_unmerged_prs2
Як обчислюється оцінка
10/30Підтримка власника — особистий (користувацький) обліковий запис
0/20Верифікований домен — не застосовно до користувацьких облікових записів
10.3/25Охоплення власника — 26 підписників у melihbirim
25/25Послужний список — 60 публічних репозиторіїв, вік облікового запису ~15 р.
Використані вхідні дані
followers26
owner_typeUser
is_verified
owner_loginmelihbirim
public_repos60
account_age_days5 793
Виключено з оцінювання (немає даних або не застосовно): Верифікований домен. Залишкові ваги перенормовано.

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

100Відмінний
Як обчислюється оцінка
25/25Опубліковано й доступно — 2 пакет(ів) у npm, pypi
35/35Свіжість публікацій — остання публікація 0 дн. тому
20/20Історія версій — 19 опублікованих версій
20/20Не застарілий — активний, не deprecated і не yanked
Використані вхідні дані
packagescsvql-query, csvql-query
ecosystemsnpm, pypi
any_deprecatedні
min_days_since_publish0

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

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

81Добрий · 20% загального індексу
Як обчислюється оцінка
24/24Процеси CI — 2 процес(ів) CI
24/24Наявні тести
0/16Конфігурація лінтера
0/9.6Pre-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
Використані вхідні дані
has_ciтак
has_testsтак
has_editorconfigні
has_linter_configні
has_precommit_configні

Документація

100Відмінний
Як обчислюється оцінка
30/30README
25/25Каталог документації
15/15Сайт документації / домашня сторінка — https://melihbirim.github.io/csvql/
10/10Опис репозиторію
10/10Теми — 13 тем
10/10Wiki
Використані вхідні дані
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так

Безпека

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

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

Стан безпеки

45У зоні ризику
Як обчислюється оцінка
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.5Ліцензія — 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
Використані вхідні дані
sourceopenssf_scorecard
checks_evaluated18
scorecard_versionv5.5.0
checks_inconclusive0
scorecard_aggregate4,5

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

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

42У зоні ризику · 0% загального індексу
Як обчислюється оцінка
0/45Інструкції для агентів — немає CLAUDE.md / AGENTS.md / правил редактора
0/15Машиночитана документація (llms.txt)
40/40Читабельна історія комітів — намір зазначено у 97 з 100 людських комітів (структурований заголовок або пояснювальний текст)
Використані вхідні дані
has_llms_txtні
legible_history_share0,97
agent_instruction_files
agent_instruction_max_bytes
Як обчислюється оцінка
0/18Розгортання однією командою
22/22Автоматизовані тести
0/11Конфігурація лінтера / форматера
0/11Статична перевірка типів
10/10Відтворюване середовище — lockfile
8/10Підтверджена практика роботи з агентами — 4 з останніх 100 комітів створено агентом або з його зазначенням
0/8Автоматизоване супроводження — автоматичних оновлень залежностей не виявлено
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Використані вхідні дані
has_nixні
has_testsтак
lockfilespackage-lock.json
has_dockerfileні
typed_languageні
bootstrap_files
has_devcontainerні
has_linter_configні
typecheck_configs
agent_commit_share0,04
toolchain_manifests
dependency_bot_commit_share0
Як обчислюється оцінка
0/45Типізований код — Zig без конфігурації перевірки типів
55/55Керовані розміри файлів — 0/12 файлів вихідного коду понад 60 КБ
Використані вхідні дані
primary_languageZig
largest_source_bytes19 418
source_files_sampled12
oversized_source_files0
Як обчислюється оцінка
0/40Схема API (OpenAPI/GraphQL/proto)
0/20Сервер MCP
40/40Придатні до запуску приклади — examples
Використані вхідні дані
example_dirsexamples
has_mcp_signalні
api_schema_files

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

20зірок GitHub
2контриб'юторів
135комітів за останні 12 місяців
0днів від останнього пушу
35релізів
1бас-фактор
9відкритих issue
npm, PyPIпакетних екосистем

Попередження щодо збору даних

  • 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

Докладніше

OpenSSF Scorecard 4.5 / 10
4.5сукупно

Незалежна, не прив'язана до інструментів оцінка безпеки від відкритого проєкту OpenSSF Scorecard. Кожна перевірка винагороджує практику безпеки, а не інструмент конкретного постачальника. Перевірки, які Scorecard не зміг визначити, позначено н/д і виключено з оцінки безпеки (вони ніколи не зараховуються як нуль).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
Усі залежності не зібрано

Не вдалося зібрати розв'язаний набір залежностей для цього звіту: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

Звіт у форматі JSON машиночитний
{
  "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"
}

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

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

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