公开记录优秀
软件健康报告模式 0.27.0 · 指标 2.3.1 · 2026-07-27 17:24 UTC
AfterShip / clickhouse-sql-parser
Go library and CLI that parses ClickHouse-dialect SQL into a typed AST. Supports lexing, parsing, AST walking, round-trip formatting, and beautification. Use for query linting, static analysis, rewriting, access-control enforcement, schema validation, and SQL formatting.
AfterShip/clickhouse-sql-parser 的健康指数为 100 分中的 86 分，处于「优秀」区间。 其得分最高的类别是Vitality（86/100），最低的是Community & Adoption（53/100）。 最近一次更新在 16 天前。 近期的大部分工作由 1 位贡献者完成。
86
总分 / 100软件健康指数
指标归入加权类别，统一采用 1–100 量表。总体分先取类别加权平均，再依据公开记录的分布进行校准，使各等级具有百分位含义；当公开证据触发高风险司法辖区政策时，评级会按政策调整，并设置 34（存在风险）的上限。
86
卓越93-100公开记录中的最高层级（约前 5%）；基本满足所有检验标准
优秀80-92各方面均表现强劲；仅有少量不足
良好65-79健康；不足之处有限且可控
中等50-64可接受，但存在明显不足；建议进行审查
薄弱35-49多个领域存在实质性薄弱环节
存在风险20-34存在重大薄弱环节；采用时应保持审慎
危急1-19问题严重（项目被弃置、仅有单一维护者、缺乏基本工程规范）
评分画像
每条轴代表一个类别。形状比平均值更重要——健康的对象会填满整个图形，而“一峰一谷”式画像意味着某一维度的优势正掩盖另一维度的风险。
加权总体分 72 经校准后在公布的指数量表上为 86（记录校准 2026-08-02）。
所有权
软件包生态系统
| 注册表 | 软件包 | 版本 | 月下载量 | 版本数 | 最近发布 |
|---|---|---|---|---|---|
| Go | github.com/AfterShip/clickhouse-sql-parser | v0.5.2 | - | 33 | 22 天前 |
按类别列示的指标
活力
项目是否仍有生命——是否仍在编写代码，是否仍在发布版本？
86
开发活跃度
77良好
评分方式
| 28.8/36 | 推送新近度 — 最近一次推送于 16 天前 |
| 20.1/36 | 提交节奏 — 52 周中有 29 周有提交 |
| 17.8/18 | 提交量 — 最近一年 95 次提交 |
| 10/10 | OpenSSF Scorecard：Maintained — 17 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10 |
所用输入
| commits_last_year | 95 |
| human_commit_share | 1 |
| days_since_last_push | 16 |
| active_weeks_last_year | 29 |
发布纪律
100卓越
评分方式
| 27/27 | 有发布版本 — 已发布 24 个发布版本 |
| 36/36 | 发布时效 — 最近一次发布版本于 16 天前 |
| 27/27 | 发布节奏 — 约每 35.3 天发布一次 |
| 0/10 | OpenSSF Scorecard：Signed-Releases — 无数据 |
所用输入
| releases_count | 24 |
| latest_release_tag | v0.5.2 |
| releases_from_tags | 否 |
| days_since_latest_release | 16 |
| mean_days_between_releases | 35.3 |
已排除计分（无数据或不适用）：OpenSSF Scorecard：Signed-Releases。 其余权重已重新归一化。
社区与采用
项目是否拥有用户、下载量与关注度，并具备欢迎贡献者参与的配置？
53
流行度与采用
56中等
评分方式
| 38.6/60 | 星标 — 242 个星标 |
| 14.2/25 | 复刻 — 51 个复刻 |
| 3.3/15 | 关注者 — 5 位关注者 |
所用输入
| forks | 51 |
| stars | 242 |
| watchers | 5 |
| growth_state | unverified |
| growth_factor_pct | 100 |
| growth_unverified_reason | no_history |
社区健康
50中等
评分方式
| 22.5/22.5 | README |
| 22.5/22.5 | 许可证 — 可识别的许可证（MIT） |
| 0/18 | CONTRIBUTING 指南 |
| 0/13.5 | 行为准则 |
| 0/7.2 | 议题模板 |
| 0/6.3 | PR 模板 |
所用输入
| has_readme | 是 |
| has_license | 是 |
| readme_badges | — |
| has_contributing | 否 |
| has_issue_template | 否 |
| has_code_of_conduct | 否 |
| readme_badge_services | — |
| has_pull_request_template | 否 |
可持续性与治理
项目能否在其成员之外延续——巴士系数、响应能力、由谁支持，以及软件包的维护状况？
72
维护者韧性（巴士系数）
41薄弱
评分方式
| 9/54 | 巴士系数 — 1 位贡献者贡献了半数提交 |
| 8.1/22.5 | 提交分布 — 头号贡献者编写了 64% 的提交 |
| 13.5/13.5 | 贡献者广度 — 31 位贡献者 |
| 10/10 | OpenSSF Scorecard：Contributors — project has 8 contributing companies or organizations |
所用输入
| bus_factor | 1 |
| contributors_sampled | 31 |
| top_contributor_share | 0.639 |
议题与 PR 响应能力
89优秀
评分方式
| 42/42 | 议题解决 — 100% 的议题已关闭 |
| 28.1/30 | PR 接受 — 已裁定的 PR 中 182/194 已合并 |
| 0/13 | Newcomer PR acceptance — 30 天内没有首次贡献者的 PR 得到裁决 |
| 7.5/15 | OpenSSF Scorecard：Code-Review — Found 15/30 approved changesets -- score normalized to 5 |
所用输入
| merged_prs | 182 |
| open_issues | 0 |
| closed_issues | 87 |
| prs_merged_7d | — |
| prs_decided_7d | — |
| prs_merged_30d | — |
| prs_decided_30d | — |
| issue_closed_ratio | 1 |
| closed_unmerged_prs | 12 |
| first_time_authors_30d | — |
| first_time_prs_merged_30d | — |
| first_time_prs_decided_30d | — |
已排除计分（无数据或不适用）：newcomer_pr_acceptance。 其余权重已重新归一化。
所有权与托管责任
71良好
评分方式
| 30/30 | 所有权背书 — 组织持有 |
| 0/20 | 已验证域名 |
| 16/25 | 所有者影响力 — AfterShip 有 169 位关注者 |
| 25/25 | 既往记录 — 81 个公开仓库，账户约 14 年 |
所用输入
| followers | 169 |
| owner_type | Organization |
| is_verified | — |
| owner_login | AfterShip |
| public_repos | 81 |
| account_age_days | 5,306 |
软件包维护
100卓越
评分方式
| 25/25 | 已发布且可解析 — go 上有 1 个软件包 |
| 35/35 | 发布时效 — 最近一次发布于 22 天前 |
| 20/20 | 版本历史 — 33 个已发布版本 |
| 20/20 | 未被弃用 — 活跃，未被弃用或撤回 |
所用输入
| packages | github.com/AfterShip/clickhouse-sql-parser |
| ecosystems | go |
| any_deprecated | 否 |
| min_days_since_publish | 22 |
工程质量
基础的工程与文档实践是否到位？
74
工程实践
84优秀
评分方式
| 24/24 | CI 工作流 — 1 个工作流 |
| 24/24 | 存在测试 |
| 16/16 | Linter 配置 — .golangci.yml |
| 0/9.6 | Pre-commit 钩子 |
| 0/6.4 | .editorconfig |
| 20/20 | OpenSSF Scorecard：CI-Tests — 23 out of 23 merged PRs checked by a CI test -- score normalized to 10 |
所用输入
| has_ci | 是 |
| has_tests | 是 |
| has_editorconfig | 否 |
| has_linter_config | 是 |
| has_precommit_config | 否 |
文档
60中等
评分方式
| 30/30 | README |
| 0/25 | 文档目录 |
| 0/15 | 文档 / 主页站点 |
| 10/10 | 仓库描述 |
| 10/10 | 主题标签 — 3 个主题标签 |
| 10/10 | Wiki |
所用输入
| topics | clickhouse, go, sql-parser |
| has_wiki | 是 |
| homepage | — |
| has_readme | 是 |
| has_docs_dir | 否 |
| has_description | 是 |
安全
可见的安全与供应链实践是否稳固，且不存在未解决的高风险司法辖区暴露？
70
安全态势
63中等
评分方式
| 7.5/7.5 | Binary-Artifacts — no binaries found in the repo |
| 0/7.5 | Branch-Protection — 无数据 |
| 2.5/2.5 | CI-Tests — 23 out of 23 merged PRs checked by a CI test -- score normalized to 10 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 3.8/7.5 | Code-Review — Found 15/30 approved changesets -- score normalized to 5 |
| 2.5/2.5 | Contributors — project has 8 contributing companies or organizations |
| 10/10 | Dangerous-Workflow — no dangerous workflow patterns detected |
| 0/7.5 | Dependency-Update-Tool — no update tool detected |
| 0/5 | Fuzzing — project is not fuzzed |
| 2.5/2.5 | 许可证 — license file detected |
| 7.5/7.5 | Maintained — 17 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10 |
| 0/5 | Packaging — 无数据 |
| 0/5 | Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
| 2.5/5 | SAST — SAST tool is not run on all commits -- score normalized to 5 |
| 0/5 | Security-Policy — security policy file not detected |
| 0/7.5 | Signed-Releases — 无数据 |
| 7.5/7.5 | Token-Permissions — GitHub workflow tokens follow principle of least privilege |
| 7.5/7.5 | Vulnerabilities — 0 existing vulnerabilities detected |
所用输入
| source | openssf_scorecard |
| checks_evaluated | 15 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 3 |
| scorecard_aggregate | 6.3 |
已排除计分（无数据或不适用）：branch_protection, packaging, signed_releases。 其余权重已重新归一化。
依赖安全公告
100卓越
评分方式
| 35/35 | 直接依赖不含已知公告 — 没有直接依赖携带已知公告 |
| 0/25 | 间接依赖不含已知公告 — 在此范围内，传递依赖集合无法与开发和测试依赖区分 |
| 0/40 | 没有长期未处理的公告 — 没有公告带有发布日期 |
所用输入
| source | osv |
| advisories | 0 |
| affected_packages | 0 |
| assessed_packages | 6 |
| unassessed_packages | 0 |
| affected_by_severity | none |
| direct_affected_packages | 0 |
已排除计分（无数据或不适用）：间接依赖不含已知公告, 没有长期未处理的公告。 其余权重已重新归一化。 已将 6 个已解析依赖与 OSV 比对。 该仓库未发布任何索引可解析的软件包，因此改为评估仓库依赖图。该图将开发与测试版本固定同交付的依赖混在一起，因此仅对声明的运行时依赖计分；传递性发现仅作为背景信息列出，不计入评分。 未对可达性进行分析。
AI 就绪度
该仓库在多大程度上具备与 AI 编码代理协同开发与维护的条件？权重刻意设小（4%）：代理工具链是一项真实的维护信号，但完全不具备的仓库仍可达到 100/100。
85
AI 代理上下文与指引
85优秀
评分方式
| 45/45 | 代理指令 — AGENTS.md |
| 0/15 | 机器可读文档（llms.txt） |
| 40/40 | 可读的提交历史 — 100 次人类提交中有 78 次说明了意图（结构化标题或解释性正文） |
所用输入
| has_llms_txt | 否 |
| legible_history_share | 0.78 |
| agent_instruction_files | AGENTS.md |
| agent_instruction_max_bytes | 3,523 |
评分方式
| 18/18 | 一条命令的引导启动 — Makefile |
| 22/22 | 自动化测试 |
| 11/11 | Lint / 格式化配置 — .golangci.yml |
| 11/11 | 静态类型检查 — Go（静态类型） |
| 10/10 | 可复现环境 — lockfile |
| 10/10 | 已体现的代理实践 — 最近 100 次提交中有 25 次由代理编写或署名代理 |
| 0/8 | 自动化维护 — 未观察到自动依赖更新 |
| 0/10 | OpenSSF Scorecard：Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
所用输入
| has_nix | 否 |
| has_tests | 是 |
| lockfiles | go.sum |
| has_dockerfile | 否 |
| typed_language | 是 |
| bootstrap_files | Makefile |
| has_devcontainer | 否 |
| has_linter_config | 是 |
| typecheck_configs | — |
| agent_commit_share | 0.25 |
| toolchain_manifests | go.mod |
| dependency_bot_commit_share | 0 |
面向模型的代码可读性
95卓越
评分方式
| 45/45 | 可类型检查的代码 — Go（静态类型） |
| 49.8/55 | 可控的文件大小 — 采样的 32 个源文件中有 3 个超过 60KB |
所用输入
| primary_language | Go |
| largest_source_bytes | 123,155 |
| source_files_sampled | 32 |
| oversized_source_files | 3 |
关键数据
242GitHub 星标
31贡献者
95最近 12 个月提交数
16距最近推送天数
24发布版本数
1巴士系数（bus factor）
0开放议题
Go软件包生态系统数
数据采集警告
- Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
更多细节
Star 与 Fork 历史 0 ★ / 51 ⇿
0Star
51Fork
23发布
每颗 star 和每个 fork 的添加时间，来自 GitHub 并按天汇总。累计增长位于其构成来源——每日新增——的正上方，二者可相互对照：稳定的自然增长与短暂的突增形态截然不同。当这一差别可被衡量时，它会作为增长真实性予以报告。
主版本 0次版本 2修订 21
每个点涵盖 3 天。
OpenSSF Scorecard 6.3 / 10
6.3综合
来自开源项目 OpenSSF Scorecard 的独立、工具无关的安全评估。每项检查奖励的是安全实践本身，而非特定供应商的工具。Scorecard 无法判定的检查项标记为 不适用，并从安全评分中剔除（绝不按零分计）。
| 10 | Binary-Artifacts | no binaries found in the repo |
| 不适用 | Branch-Protection | internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md |
| 10 | CI-Tests | 23 out of 23 merged PRs checked by a CI test -- score normalized to 10 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 5 | Code-Review | Found 15/30 approved changesets -- score normalized to 5 |
| 10 | Contributors | project has 8 contributing companies or organizations |
| 10 | Dangerous-Workflow | no dangerous workflow patterns detected |
| 0 | Dependency-Update-Tool | no update tool detected |
| 0 | Fuzzing | project is not fuzzed |
| 10 | License | license file detected |
| 10 | Maintained | 17 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10 |
| 不适用 | Packaging | packaging workflow not detected |
| 0 | Pinned-Dependencies | dependency not pinned by hash detected -- score normalized to 0 |
| 5 | SAST | SAST tool is not run on all commits -- score normalized to 5 |
| 0 | Security-Policy | security policy file not detected |
| 不适用 | Signed-Releases | no releases found |
| 10 | Token-Permissions | GitHub workflow tokens follow principle of least privilege |
| 10 | Vulnerabilities | 0 existing vulnerabilities detected |
直接依赖 2
| 注册表 | 软件包 | 版本约束 | 清单文件 |
|---|---|---|---|
| Go | github.com/sebdah/goldie/v2 | v2.5.3 | go.mod |
| Go | github.com/stretchr/testify | v1.8.4 | go.mod |
全部依赖 6
来自 GitHub 依赖图的完整解析依赖集合：2 个直接依赖与 4 个间接（传递）软件包。仓库提交锁文件时，传递闭包才是完整的。
| 注册表 | 软件包 | 版本 | 关系 |
|---|---|---|---|
| Go | github.com/sebdah/goldie/v2 | v2.5.3 | 直接 |
| Go | github.com/stretchr/testify | v1.8.4 | 直接 |
| Go | github.com/davecgh/go-spew | v1.1.1 | 间接 |
| Go | github.com/pmezard/go-difflib | v1.0.0 | 间接 |
| Go | github.com/sergi/go-diff | v1.0.0 | 间接 |
| Go | gopkg.in/yaml.v3 | v3.0.1 | 间接 |
依赖安全公告 0
该仓库未发布可被索引解析的包，因此评估的是其自身的依赖图——共 6 个包，其中也包含从不交付的开发与测试版本固定：0 个存在已知公告，0 个为直接依赖。
没有已知公告影响已评估的依赖。
公告表示依赖图中记录的版本落入某条公告的受影响范围。可达性未经分析，且依赖图包含开发与测试的版本固定——某项发现可能只涉及工具链而非交付的软件。
原始 JSON 报告 机器可读
{
"data": {
"repo": {
"topics": [
"clickhouse",
"go",
"sql-parser"
],
"is_fork": false,
"size_kb": 1724,
"has_wiki": true,
"homepage": null,
"languages": {
"Go": 562651,
"Makefile": 499
},
"pushed_at": "2026-07-11T07:11:11Z",
"created_at": "2023-09-22T02:56:16Z",
"owner_type": "Organization",
"updated_at": "2026-07-17T07:40:47Z",
"description": "Go library and CLI that parses ClickHouse-dialect SQL into a typed AST. Supports lexing, parsing, AST walking, round-trip formatting, and beautification. Use for query linting, static analysis, rewriting, access-control enforcement, schema validation, and SQL formatting.",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "master",
"license_spdx_raw": "MIT",
"primary_language": "Go",
"significant_languages": [
"Go"
]
},
"owner": {
"blog": "https://www.aftership.com",
"name": "AfterShip",
"type": "Organization",
"login": "AfterShip",
"company": null,
"location": "Hong Kong",
"followers": 169,
"avatar_url": "https://avatars.githubusercontent.com/u/1334231?v=4",
"created_at": "2012-01-16T16:27:21Z",
"is_verified": null,
"public_repos": 81,
"account_age_days": 5306
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v0.5.2",
"kind": "patch",
"published_at": "2026-07-11T07:11:11Z"
},
{
"tag": "v0.5.1",
"kind": "patch",
"published_at": "2026-04-21T03:40:57Z"
},
{
"tag": "v0.5.0",
"kind": "minor",
"published_at": "2026-03-18T02:34:31Z"
},
{
"tag": "v0.4.19",
"kind": "patch",
"published_at": "2026-01-26T10:15:35Z"
},
{
"tag": "v0.4.18",
"kind": "patch",
"published_at": "2025-12-25T04:01:42Z"
},
{
"tag": "v0.4.17",
"kind": "patch",
"published_at": "2025-11-20T04:06:51Z"
},
{
"tag": "v0.4.15",
"kind": "patch",
"published_at": "2025-11-01T06:08:32Z"
},
{
"tag": "v0.4.14",
"kind": "patch",
"published_at": "2025-10-10T05:36:51Z"
},
{
"tag": "v0.4.13",
"kind": "patch",
"published_at": "2025-09-17T02:06:48Z"
},
{
"tag": "v0.4.11",
"kind": "patch",
"published_at": "2025-08-27T05:40:15Z"
},
{
"tag": "v0.4.10",
"kind": "patch",
"published_at": "2025-06-10T10:12:25Z"
},
{
"tag": "v0.4.9",
"kind": "patch",
"published_at": "2025-05-08T13:56:18Z"
},
{
"tag": "v0.4.8",
"kind": "patch",
"published_at": "2025-04-23T11:13:44Z"
},
{
"tag": "v0.4.6",
"kind": "patch",
"published_at": "2025-04-18T04:14:41Z"
},
{
"tag": "v0.4.5",
"kind": "patch",
"published_at": "2025-03-24T11:08:27Z"
},
{
"tag": "v0.4.4",
"kind": "patch",
"published_at": "2025-02-28T03:07:04Z"
},
{
"tag": "v0.4.3",
"kind": "patch",
"published_at": "2025-02-19T09:11:19Z"
},
{
"tag": "v0.4.1",
"kind": "patch",
"published_at": "2024-12-25T07:04:48Z"
},
{
"tag": "v0.4.0",
"kind": "minor",
"published_at": "2024-11-29T09:12:06Z"
},
{
"tag": "v0.3.8",
"kind": "patch",
"published_at": "2024-10-08T01:50:29Z"
},
{
"tag": "v0.3.7",
"kind": "patch",
"published_at": "2024-09-26T10:21:42Z"
},
{
"tag": "v0.3.6",
"kind": "patch",
"published_at": "2024-09-04T07:03:46Z"
},
{
"tag": "v0.3.4",
"kind": "patch",
"published_at": "2024-06-29T11:59:31Z"
},
{
"tag": "v0.3.1",
"kind": "patch",
"published_at": "2024-01-09T07:55:40Z"
}
],
"recent_commits": [
{
"oid": "e4c6e11fcec9a7140ef53835fae0728b2f304a3c",
"body": null,
"is_bot": false,
"headline": "Fix traversal of semantic AST children (#285)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T07:23:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dcf2383959c8fbf160b77be4d7251a22f650e2e7",
"body": null,
"is_bot": false,
"headline": "Traverse JSON type options",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T06:49:09Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a1569691e05fbe2b6625e8f847ff78635ea4c2e8",
"body": "The two traversal engines each encode every node's children by hand, and\nthe existing drift test only asserts that both engines know the same\nnode TYPES - it cannot see a child FIELD one engine traverses and the\nother forgot. A new static test compares, per node type, the fields\nreferenced by Accept\n[…]\nd outside the destination's Enter/Leave bracket.\n The clause now owns its child, and its End() includes the schema.\n\nNo golden fixture changed.\n\nCo-authored-by: Claude Fable 5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix Accept/Walk field-level drift and InsertStmt End panic (#284)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T04:11:42Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "38158f99b1514f8599cdad42e0d5551d8e46cdf5",
"body": null,
"is_bot": false,
"headline": "Split keywords into reserved and non-reserved sets (#282)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T04:06:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4feeec5fb6921957ff35ba892d0c425c37a6604f",
"body": "…ionary nodes (#283)\n\nPositions are stamped from caller-supplied `pos` parameters or read\nafter the relevant token was already consumed, producing wrong or\noverlapping spans in several nodes:\n\n- parseRatioExpr passed the numerator's pos to the denominator too, so\n `SAMPLE 1/2` produced two literals\n[…]\nly position-field values plus the two\nnew fields (NullEnd, AttrEnd); no format output changed. Span\nassertions live in the new position_test.go.\n\nCo-authored-by: Claude Fable 5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix position tracking across ratio, IS NULL, GROUP BY, ALTER and dict…",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T03:02:12Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "6084020a9a7c9c62c6410565b22daf5a67900fc7",
"body": "…280)",
"is_bot": false,
"headline": "Fix number lexing, unterminated block comments and non-ASCII bytes (#…",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T02:46:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5c3069235a044b81c69aad90b00ad19db7371857",
"body": "The precedence table disagreed with ClickHouse in several places and two\noperators were unreachable. All of these misparses round-tripped to the\nsame SQL text, so the golden tests never caught them:\n\n- Lambda `->` bound tightest instead of loosest: `x -> x + 1` parsed as\n `(x -> x) + 1`. It now bin\n[…]\nBetweenClause.Not,\nSelectQuery.Intersect); no format output changed. New structural tests\nin precedence_test.go assert the tree shapes directly.\n\nCo-authored-by: Claude Fable 5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix expression precedence for lambda, ternary and NOT (#279)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-04T13:57:38Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "4932a6cbf9b58c1d2db1d91a100e893fc3e00853",
"body": "l.lastToken and p.last() actually hold the *current* lookahead token -\nthe one the parser is looking at but has not consumed - not a\npreviously-consumed token. Likewise l.current held the input byte\noffset, not a token. Rename for accuracy, no behavior change:\n\n- lexerState.current (int) -> offse\n[…]\nLexer.consumeToken used\nto disambiguate unary +/- - is named prevToken.\n\nAlso give TokenKindDot its missing TokenKind type annotation.\n---------\n\nCo-authored-by: Claude Fable 5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Rename lexer state to match what it holds (#277)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-14T03:39:26Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "558390dcbb3ef056e155d297a7efb74e448e98bf",
"body": "Accept/ASTVisitor and Walk/WalkFunc are two independent traversal\nengines that encode every node's children separately, so a new AST node\ntype added to one can silently be missing from the other. Add a static\ntest that parses the package source and asserts every type with an\nAccept method has both a\n[…]\ny\nafter visiting the sample ratio, so VisitJoinTableExpr was never called\nfor table expressions carrying a SAMPLE clause. Add a regression test.\n\nCo-authored-by: Claude Fable 5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Add drift test keeping ASTVisitor and Walk traversals in sync (#276)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-12T10:53:39Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "3c3822c5e43a9f04244d9599fc8a1c4bd7ba8e2d",
"body": "Replace the stringly-typed parse error and its per-error full-input\nrescan with a typed *ParseError that carries the byte offset, 1-based\nline/column, the offending token, and the expected token kinds/keyword.\n\n- error.go: ParseError type; Error() renders the line:col message plus a\n caret, matchin\n[…]\nrror\nmessages were reworded; callers can now errors.As(err, &ParseError{}).\n\nCo-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.8 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Add structured ParseError with O(log n) position lookup (#274)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-10T13:23:42Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "5df9a6cbb677119e4b3f58133b7e060b059881cd",
"body": "`wrapError` walks `p.lexer.input[i]` for `i < int(p.Pos())` to compute the\nerror line/column. At EOF `p.Pos()` can exceed `len(input)`, so on input like\n`CREATE--` (a trailing comment leaves the position past the end) it panics\nwith \"index out of range\".\n\nClamp the loop bound to `len(p.lexer.input)`\n[…]\n it panicked before\nthe fix and now returns a proper error.\n\nCo-authored-by: Claude Opus 4.8 <noreply@anthropic.com>\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>",
"is_bot": false,
"headline": "Fix index-out-of-range panic in wrapError at EOF (#272)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-10T06:55:13Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "4d7ccd6048d67b2fb2a741b1acedf9b30e5111f5",
"body": "`consumeMultiLineComment` looped on `!l.isEOF()` (which checks `l.current`)\nwhile only advancing the local index `i`, so on an unclosed comment like\n`/* unterminated` the lexer spun forever — a DoS hang.\n\nLoop on `l.peekOk(i)` instead so it terminates at end of input.\n\nAdd TestConsumeUnterminatedComment to reproduce: it drains the lexer in a\ngoroutine with a timeout, so a regression fails fast instead of hanging.\n\nCo-authored-by: Claude Opus 4.8 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix infinite loop on unterminated block comment (#271)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-10T06:49:32Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "35710d6df411a1eed5c3fc9abe435a9cfcaaacb1",
"body": "Error messages built with `fmt.Errorf(\"... %q\", p.last().String)` panic when\nthe lexer is at EOF, because `p.last()` is nil. Inputs like `ALTER `,\n`SELECT*FROM A(0A` and `SET A=` triggered this.\n\nAdd a nil-safe `lastTokenString()` helper (mirroring `lastTokenKind()`) that\nreturns \"<EOF>\" when there \n[…]\nare left untouched.\n\nAdd the inputs above to TestParser_InvalidSyntax to reproduce: they panicked\nbefore the fix and now return a proper error.\n\nCo-authored-by: Claude Opus 4.8 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix nil-pointer dereference when formatting errors at EOF (#273)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-10T06:46:56Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "88f462ccee248e6675fb2c8e3bd9828409cdf763",
"body": "…able in CREATE MATERIALIZED VIEW (#270)\n\n1. Column list before ENGINE (new):\n ClickHouse SHOW CREATE TABLE for refreshable materialized views with\n ENGINE (e.g. Memory) outputs the column list between REFRESH and ENGINE:\n\n CREATE MATERIALIZED VIEW db1.mv_name\n REFRESH EVERY 1 SECOND\n \n[…]\nialized_view_rmv_engine_with_columns.sql (column list + ENGINE)\n- create_materialized_view_rmv_depends_on_multi.sql (multi-table DEPENDS ON)\n- All 21 MV syntax variants tested, all existing tests pass",
"is_bot": false,
"headline": "Fix should allow column list before ENGINE and fix DEPENDS ON multi-t…",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2026-05-15T10:35:05Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "33c6bf25c7c5bd86bec60109e38db0b15a2cd3e7",
"body": "Extend keyword-as-identifier handling to recognize end-of-statement\n(EOF or `;`) as a disambiguator in expression position, so projections\nlike `SELECT case`, `SELECT case;`, or `SELECT limit` parse as bare\ncolumn refs — matching ClickHouse server (verified against 25.10.7.6,\nwhich returns UNKNOWN_I\n[…]\n, because\nmatchTokenKind(TokenKindIdent) coerces TokenKindKeyword and so\nparseIdent accepts keyword tokens as alias names; added a comment at\nthe AS branch of parseSelectItem to make that intentional.",
"is_bot": false,
"headline": "Allow reserved keywords as bare column names in SELECT list (#269)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2026-05-12T03:39:14Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "c1775906aa01bdf7c4b63112a0a9185ebc184ab2",
"body": "…(#268)\n\nClickHouse accepts `SELECT a, FROM t` (e.g. when a column is commented\nout with `--`). Break the SELECT-item loop after consuming a comma if\nthe next token is a clause-starting keyword (FROM, WHERE, GROUP, etc.).\nFixes incorrect AST for existing CREATE MATERIALIZED VIEW fixtures\nwhere FROM was previously consumed as a bare select expression.",
"is_bot": false,
"headline": "Fix should allow trailing comma in SELECT list before clause keyword …",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2026-05-11T09:37:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9f798c0f67a9c2c7ce58cdca9cd43b22408c1622",
"body": null,
"is_bot": false,
"headline": "Add support of REGEXP as binary operator (#267)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2026-05-11T02:02:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1930f34593d4559288e7ace62d1f6808baec78c3",
"body": null,
"is_bot": false,
"headline": "fix: ensure projections can have either an order by or a group by (#266)",
"author_name": "Mark deVilliers",
"author_login": "mdevilliers",
"committed_at": "2026-04-25T05:02:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8ce1476f64ea6b1504ba43802fc472f00771e9b7",
"body": "CREATE VIEW in ClickHouse supports COMMENT between the schema and AS SELECT:\n\n CREATE VIEW db.v (columns) COMMENT '{...}' AS SELECT ...\n\nThe parser previously failed with 'expected EOF or ; but got COMMENT'.\n\nChanges:\n- Add Comment field to CreateView struct (ast.go)\n- Parse COMMENT clause in parse\n[…]\nView before AS (parser_view.go)\n- Format COMMENT in CreateView.FormatSQL (format.go)\n- Add test case: create_view_with_comment.sql\n- Update golden files for existing view tests (new nil Comment field)",
"is_bot": false,
"headline": "Add COMMENT support to CREATE VIEW parser (#265)",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2026-04-17T15:15:09Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "d5e88a6635f346b9fbcbe8c149f17393432216d3",
"body": null,
"is_bot": false,
"headline": "Add support for CREATE USER VALID UNTIL clause (#264)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-04-16T06:17:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "120ff65369024b9ae49f98094e3c659d5fff05e3",
"body": "ClickHouse 26.2+ changed SHOW CREATE TABLE output to place COMMENT\nbefore AS SELECT, while 25.x places it after. The parser only\nsupported COMMENT after AS SELECT, causing parse failures on 26.2+.\n\nNow tries COMMENT in both positions:\n- Before AS SELECT (ClickHouse 26.2+ SHOW CREATE TABLE format)\n- After AS SELECT (ClickHouse 25.x SHOW CREATE TABLE format)\n\nThis closes #261.",
"is_bot": false,
"headline": "Support COMMENT before AS SELECT in CREATE MATERIALIZED VIEW (#262)",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2026-04-09T02:29:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5a72214bb365ba3e3d9d11e24fe6a3d1c933b09c",
"body": "Co-authored-by: Kemal Hadimli <disq@users.noreply.github.com>",
"is_bot": false,
"headline": "fix: Panic on invalid number as query (#260)",
"author_name": "Kemal",
"author_login": "disq",
"committed_at": "2026-03-28T02:35:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3d0a96950058795479f364e3ac8411f3b3ac95cc",
"body": null,
"is_bot": false,
"headline": "Add support for window names in WindowExpr (#259)",
"author_name": "Chinh Nguyen",
"author_login": "chinhnguyenh",
"committed_at": "2026-03-18T09:30:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4a3c96ea2fdf18439bc542808de83af96909dbca",
"body": "parseDistinctOn() was calling parseIdent() which only handles simple\nidentifiers. Queries like DISTINCT ON (t.id, t.name) would fail because\nthe dot was not recognized. Changed to parseExpr() so that any valid\ncolumn expression (including table.column references) is accepted.",
"is_bot": false,
"headline": "Support expressions (dotted column refs) in `DISTINCT ON` (#258)",
"author_name": "Kemal",
"author_login": "disq",
"committed_at": "2026-03-17T01:44:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d468e13bb73958e72f7b24bbc0a6909fee6bdfeb",
"body": null,
"is_bot": false,
"headline": "Fix SQL code block formatting in README",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-14T13:45:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5d7a71f04bbe2df11949b2dd47e8546b1fcb7c28",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add beautify format for ALTER ROLE and CREATE ROLE SETTINGS (#256)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-14T13:43:18Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "461102b0a504c2ae55bc6ed7b63f9b5efbd92d1f",
"body": null,
"is_bot": false,
"headline": "Improve CREATE LIVE VIEW format",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T09:06:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "af5073cb95c77cc02c9aa731990bbe5d6c6ca952",
"body": null,
"is_bot": false,
"headline": "Improve ALTER TABLE CLEAR * format",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T08:54:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "74e0ba3421fabf351f747103f895585eff3c1cd5",
"body": null,
"is_bot": false,
"headline": "Fix IF EXISTS order in ALTER TABLE",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T08:44:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "089230e39f9b6ef20f649da93d9146865982d989",
"body": null,
"is_bot": false,
"headline": "Improve the ALTER TABLE format",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T08:37:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ece3a1156a682625c379019489f710c4da858bce",
"body": null,
"is_bot": false,
"headline": "Improve the CREATE MATERIALIZED VIEW format",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T07:51:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a8128443e0ec06c5e01185b7b37401031f6d2528",
"body": null,
"is_bot": false,
"headline": "Improve the CREATE DIRECTORY format",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T06:51:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bf5be1223055e9f0acadb022d9d0ea6394499420",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add beautify format support for CREATE DICTIONARY statements (#253)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T06:37:42Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "17e829da71577dc907179e4c0a7575c9e9c8957d",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add line breaks for ON CLUSTER and ALTER clauses in beautify mode (#251)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T06:29:21Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "b2d2addf27bd3a308c96fafa41dd2b0007fd43b3",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Document `-beautify` flag with example (#249)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T04:14:56Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "3b8db2800ecd1373ee213ff59bebac0c9b573914",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add chaining methods to formatter for customizable indentation (#248)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T03:58:19Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "4b92d7051063f32120136134a5211b1a669175da",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add beautify format support for CREATE USER statements (#247)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T03:57:09Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "033e8735215a618cd6cc81ca473630d28d18ae1f",
"body": "…#245)\n\n---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>\nCo-authored-by: hulk <hulk.website@gmail.com>",
"is_bot": false,
"headline": "Add line break and indentation for SETTINGS clause in beautify mode (…",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T03:54:17Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "1cf1e3d21420b15990fca76c07dfb522926cec93",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add line break before column list in INSERT INTO formatting (#246)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T03:43:29Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "6d0175c1622d39c3d6d55c4b708cb38a1cfdc112",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add line break and indentation to FROM clause formatting (#244)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T03:25:36Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "50c0046c45cecb74ec09fea1b88c2cc73798589e",
"body": null,
"is_bot": false,
"headline": "Add ident format for JOIN",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T02:07:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2588297e03fd083e7946b7a2132723150e302fe2",
"body": null,
"is_bot": false,
"headline": "Add ident format for GROUP BY",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-12T13:54:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "95a195fc6baf73b5a24a35df7d8684e14183debe",
"body": null,
"is_bot": false,
"headline": "Add the beautify format SQL gold files",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-12T13:47:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "925428d81eb74cbb0922aa51fc08a60d3231dffb",
"body": null,
"is_bot": false,
"headline": "Update AGNETS.md",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-12T02:29:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9275c63ba11b26ac10573d824620edb647ed1496",
"body": null,
"is_bot": false,
"headline": "Introduce `FormatSQL` API to allow customizing different formats",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-11T12:33:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e5d75c5c2d9e30a9028f9577a4074428c3ea7169",
"body": "Co-authored-by: Telman Rzaev <ttrzaev@avito.ru>",
"is_bot": false,
"headline": "Add support for CREATE NAMED COLLECTION statements (#235) (#236)",
"author_name": "Telman",
"author_login": "St0rmPetrel",
"committed_at": "2026-01-29T02:37:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "078beb471ccc1266720e35a4f1a5e46d0c90b60b",
"body": null,
"is_bot": false,
"headline": "Add support for nested named/unnamed tuple types (#233)",
"author_name": "James Riley Wilburn",
"author_login": "rhino1998",
"committed_at": "2026-01-29T02:10:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fbea4206789fdefb5f9dbde0afa8cb1e303db6a5",
"body": null,
"is_bot": false,
"headline": "Fix parsing failure when having multiple ttl expressions (#234)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-01-26T10:14:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b13080fd6ad5bba8f711da80fae212738c019941",
"body": "Co-authored-by: Claude Sonnet 4.5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Add support for SETTINGS clause in ALTER TABLE ADD COLUMN (#232)",
"author_name": "Lance",
"author_login": "Lance726",
"committed_at": "2026-01-23T08:59:41Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "2154d0b75f973039de1be7dfe87cb29ef4f88546",
"body": null,
"is_bot": false,
"headline": "Fix CASE statement WHEN spacing (#231)",
"author_name": "James Riley Wilburn",
"author_login": "rhino1998",
"committed_at": "2026-01-23T01:57:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c35e37e247556eabda6e9c7ce945b7ef79bbe18f",
"body": null,
"is_bot": false,
"headline": "Allow ARRAY JOIN to be interleaved with other JOIN statements (#230)",
"author_name": "Herman Schaaf",
"author_login": "hermanschaaf",
"committed_at": "2026-01-22T13:06:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "264c31243b0e9c19f3550ff8c134b262e03e78da",
"body": null,
"is_bot": false,
"headline": "Fix support for multiple array join statements (#229)",
"author_name": "Herman Schaaf",
"author_login": "hermanschaaf",
"committed_at": "2026-01-21T01:50:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "47921fec43ac891be7f0bca5d2bc590cbc3dc25b",
"body": null,
"is_bot": false,
"headline": "Add support for concat operator (#228)",
"author_name": "James Riley Wilburn",
"author_login": "rhino1998",
"committed_at": "2026-01-16T12:32:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "39f4fac7b9e2848c6e45a80859ed81f69ed8473c",
"body": "Co-authored-by: Copilot Autofix powered by AI <62310815+github-advanced-security[bot]@users.noreply.github.com>",
"is_bot": false,
"headline": "Fix workflow does not contain permissions (#227)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-01-13T13:24:14Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "7d8113246f59b6e5502abda633ea7955d37316eb",
"body": null,
"is_bot": false,
"headline": "Add support for OFFSET clause without LIMIT (#226)",
"author_name": "James Riley Wilburn",
"author_login": "rhino1998",
"committed_at": "2026-01-13T02:26:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b233fe1ba6f3d37dd52465fd142d744f40edcad5",
"body": null,
"is_bot": false,
"headline": "Add support of parsing Tuple type in DDL (#225)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-12-25T04:00:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8e07af72ca754e780b85e440f7667c2ce4177ce1",
"body": null,
"is_bot": false,
"headline": "Support empty parentheses in index type definitions (#224)",
"author_name": "Lance",
"author_login": "Lance726",
"committed_at": "2025-12-09T10:23:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "827df05967469ee90905688e084e57e5ac723611",
"body": null,
"is_bot": false,
"headline": "Delete .github/workflows/claude.yaml",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-12-08T13:22:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5fc8fac1180a342b28c263a92873a52792c51c0b",
"body": null,
"is_bot": false,
"headline": "Fix regex expression wasn't allowed in EXTRACT (#223)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-12-06T16:05:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ff82e4c7015b870e669ca737e9f7375efeb77b4c",
"body": null,
"is_bot": false,
"headline": "Update VERSION constant to 0.4.17",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-12-05T08:45:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fd7b5d02ddec261c8576ae3f3f5f3c5d3d4e4f17",
"body": "Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Fix: Send error messages to stderr instead of stdout (#221)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-12-01T09:36:39Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "699e78fbe72209e69fc8b79efa334a999c1c81d7",
"body": "* Removing unwanted code\n\nSigned-off-by: Sharad Gaur <sharadgaur@gmail.com>\n\n* Adding to walk.go\n\nSigned-off-by: Sharad Gaur <sharadgaur@gmail.com>\n\n---------\n\nSigned-off-by: Sharad Gaur <sharadgaur@gmail.com>",
"is_bot": false,
"headline": "Fix refreshable View with named parameters (#217)",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2025-11-21T02:45:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3f5e89de1f9b8416ca97814b67c5e30fc29475f6",
"body": "ALTER TABLE foo MODIFY QUERY <an invalid query> crashed the parser with a sigsegv due to a missing error check; this commit adds the missing check and a regression test.",
"is_bot": false,
"headline": "bug: fix a crash with an invalid query following MODIFY QUERY (#215)",
"author_name": "Sean Gillespie",
"author_login": "swgillespie",
"committed_at": "2025-11-20T01:52:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4466b5c995e43b1d6969da59dd3d565db3ab9e6e",
"body": "This commit adds support for using table functions like remoteSecure()\nand remote() in CREATE TABLE AS statements when column definitions are\npresent, and fixes support for AS SELECT without parentheses.\n\nThe parser now supports table creations such as:\n- CREATE TABLE (...) AS remoteSecure('host', 'db', 'table', 'user', 'pass')\n- CREATE TABLE (...) AS remote('host', 'db', 'table')\n- CREATE TABLE AS SELECT ... (without parentheses)\n- CREATE TABLE (...) AS SELECT ... (without parentheses)",
"is_bot": false,
"headline": "Add support for table functions in CREATE TABLE AS statements (#214)",
"author_name": "Sean Gillespie",
"author_login": "swgillespie",
"committed_at": "2025-11-19T04:11:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8ca8a97ad9b1d43e0faf0ede75977692e9199795",
"body": null,
"is_bot": false,
"headline": "Add support of parsing SETTING boolean values (#213)",
"author_name": "Mark deVilliers",
"author_login": "mdevilliers",
"committed_at": "2025-11-18T02:02:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "42fd0bb737216c665970901ba10215bc7f817e7c",
"body": null,
"is_bot": false,
"headline": "Fix nil pointer for replicated database engine (#212)",
"author_name": "Sebastian Rabenhorst",
"author_login": "rabenhorst",
"committed_at": "2025-11-17T12:57:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c9e8bb49915ee6fcdee7589ba78447b09a46c40e",
"body": "Compression codecs such as `DoubleDelta` do not require any additional positional parameters and infer defaults, such as `CODEC(DoubleDelta)`. This commit doesn't continue parsing a codec if there's no comma indicating additional parameters to the codec.",
"is_bot": false,
"headline": "Parse compression codecs with no parameters (#197)",
"author_name": "Sean Gillespie",
"author_login": "swgillespie",
"committed_at": "2025-11-14T02:07:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "06f1e259f9f56adc99daa7487c8645d07de5ccab",
"body": null,
"is_bot": false,
"headline": "Add WITH FILL Support in ORDER BY (#211)",
"author_name": "Flo",
"author_login": "Flo4604",
"committed_at": "2025-11-07T13:22:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e1db7786cb3ebbb68c5fadcf051d4fdaea49f96b",
"body": "Signed-off-by: Sharad Gaur <sharadgaur@gmail.com>",
"is_bot": false,
"headline": "Adding support for parsing COMMENT for dictionary (#210)",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2025-11-07T01:44:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "405710174ae922d12df730901af1b8e8045a5514",
"body": null,
"is_bot": false,
"headline": "Fix string escape sequences in lexer (#209)",
"author_name": "Su Yong Chang",
"author_login": "waterdrag0n",
"committed_at": "2025-11-03T09:54:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "60759d4f18e287a89055e726fff97d00c5fca3bb",
"body": null,
"is_bot": false,
"headline": "Support multiple WINDOW definitions; expand window function tests (#208)",
"author_name": "A.J. Ruckman",
"author_login": "ajruckman",
"committed_at": "2025-10-30T02:45:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0b8b2e33d8fe85e4a78ca782aea35cc51941698e",
"body": null,
"is_bot": false,
"headline": "Support QBit data type via simplified identifier handling (#207)",
"author_name": "A.J. Ruckman",
"author_login": "ajruckman",
"committed_at": "2025-10-29T01:57:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5c0f9cced3e636c8e044293c3dd4e5b0a5671f42",
"body": "…206)",
"is_bot": false,
"headline": "Allow to use the optional `IN PARTITION` expression in ALTER TABLE (#…",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-10-28T11:48:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e31c88c056396d2a737f0931997aeb721aa3b54a",
"body": null,
"is_bot": false,
"headline": "Add support of ALTER TABLE DELETE/UPDATE mutations (#203)",
"author_name": "A.J. Ruckman",
"author_login": "ajruckman",
"committed_at": "2025-10-27T02:16:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "78ff34b55d7055500025955b677a7eed5e19597f",
"body": "…#202)",
"is_bot": false,
"headline": "Fix typed placeholder lookahead; parse WHERE in SELECT without FROM (…",
"author_name": "A.J. Ruckman",
"author_login": "ajruckman",
"committed_at": "2025-10-27T02:03:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "61525d54cccb3b901889a7ed4de75a03eb8049e5",
"body": "---------\n\nCo-authored-by: wanghao <wang_hao11@venusgroup.com.cn>\nCo-authored-by: git-hulk <hulk.website@gmail.com>",
"is_bot": false,
"headline": "Fix the printing order of the EngineExpr.String() method (#201)",
"author_name": "design",
"author_login": "whscout",
"committed_at": "2025-10-11T05:34:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ac0ab090ec1abc8eea46158a884325c3a5949a28",
"body": null,
"is_bot": false,
"headline": "Fix `SELECT` keyword inside functions (#200)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2025-10-08T08:16:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c884bd5998ae473b5c8daf76bf307afc03b62731",
"body": null,
"is_bot": false,
"headline": "Support single-quoted table names (#199)",
"author_name": "Mariano Gappa",
"author_login": "marianogappa",
"committed_at": "2025-10-02T14:57:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "341967c2fa4c03f3635b18f3aa7d708033b3e47f",
"body": null,
"is_bot": false,
"headline": "Add support of the type hint parsing in JSON column type (#196)",
"author_name": "Piyush Singariya",
"author_login": "piyushsingariya",
"committed_at": "2025-09-29T07:27:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ee69fcc25f12ed75aa9bb18a224019c23e3bee40",
"body": "Add support for walking DistinctOn AST nodes in the Walk function to ensure proper traversal of SELECT DISTINCT ON expressions.\n\n🤖 Generated with [Claude Code](https://claude.ai/code)\n\nCo-authored-by: Claude <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix Walk logic for DistinctOn clause (#195)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-09-22T06:38:57Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "b8659ca21d60b9cda4ce1575d1a8ce5501e5315f",
"body": null,
"is_bot": false,
"headline": "feat: add support for `SELECT DISTINCT ON(…)` (#194)",
"author_name": "Ben Blackmore",
"author_login": "bripkens",
"committed_at": "2025-09-21T10:25:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4350d2eb704a3f45b75c13aae52cd2a7bda956b3",
"body": null,
"is_bot": false,
"headline": "Fix allow using keywords as alias for columns (#193)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2025-09-19T02:09:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "752d6e78430b01565d7f5abcee78e8d624318ea5",
"body": null,
"is_bot": false,
"headline": "Fix parsing on multiple `union distinct` and `except` (#192)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2025-09-18T01:57:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7bdfc482fb1b7e4e1992a0d045540738a9dffa2b",
"body": null,
"is_bot": false,
"headline": "Fix `Walk` logic for `When` clause (#190)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2025-09-17T02:05:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "18938455f91c1989f90258f35879c24a033e4fbc",
"body": null,
"is_bot": false,
"headline": "Fix shouldn't stop on `nil` values when traversing the AST (#191)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2025-09-17T02:03:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "294aafbcb0009df3dad13ae5f6d4420feff6c456",
"body": null,
"is_bot": false,
"headline": "Allow using JSON path in select results (#189)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-09-11T05:32:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "171c3e84444ffbf23e1394260766f3b6caef0868",
"body": "---------\n\nSigned-off-by: Sharad Gaur <sharadgaur@gmail.com>",
"is_bot": false,
"headline": "Fix INDEX column spacing bug (#186)",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2025-09-01T04:16:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bf749932c1fe60e4c4fdff85dac1aab795d60b9b",
"body": null,
"is_bot": false,
"headline": "Add ALTER TABLE MODIFY/RESET SETTING syntax support (#185)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-08-27T05:39:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d81858052d5142f93bf6297a14cce29edff68bac",
"body": null,
"is_bot": false,
"headline": "Support `DESCRIBE TABLE` syntax (#183)",
"author_name": "Dejan Miletic",
"author_login": "dejanmltc",
"committed_at": "2025-08-22T10:29:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2590403d7c446d0f6a44032b9932c67bb83d0641",
"body": null,
"is_bot": false,
"headline": "Add CLAUDE.md and claude bot into workflows",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2025-08-15T11:10:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5b6fdc6d33962ef989b5a752af097968100210b8",
"body": "…LE, and FORMAT clauses (#182)\n\n---------\n\nCo-authored-by: Copilot <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Enhance SHOW DATABASES statement to support LIKE, ILIKE, LIMIT, OUTFI…",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-08-12T10:26:44Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "17e786410300307200857501a6ba82d963b053f9",
"body": "Co-authored-by: Copilot <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add support for SHOW and DESC/DESCRIBE statements (#180)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-08-12T03:18:58Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "4f49fc62596fc4ccf5ee66038cef0c9ff4c2ce5a",
"body": null,
"is_bot": false,
"headline": "Update README",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2025-08-11T09:05:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4e4cfbf618186f4c42c13b5f4b3355ebe4c4b7fc",
"body": null,
"is_bot": false,
"headline": "Add support of AST travering by the Walk function",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2025-08-11T09:01:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3cdc4c1e8e114c77c8b6d88298ebdc2a40b98069",
"body": null,
"is_bot": false,
"headline": "Add support of PROJECTION column in CREATE TABLE (#178)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-08-01T06:31:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b84b7e1c1b5d3425328bb26decaef773be8db5aa",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>\nCo-authored-by: git-hulk <hulk.website@gmail.com>",
"is_bot": false,
"headline": "Add support for CREATE DICTIONARY statement (#175)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-07-17T14:16:26Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "6aaddc066e96bf9909e557d0e5842e2dc92a3e68",
"body": null,
"is_bot": false,
"headline": "Remove an extra leading space when formatting the WINDOW FUNCTION (#174)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-07-11T03:10:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "91718f80fa2fcffb2dfd5b019c526cf42a78faf4",
"body": null,
"is_bot": false,
"headline": "Fix positions of Window Clause and string generation (#173)",
"author_name": "Andrei Kochemirovskii",
"author_login": "Blackmorse",
"committed_at": "2025-07-11T02:08:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "21fc5f072970bca68c2e293e42a454aa754658c4",
"body": "…umentation (#170)\n\nCo-authored-by: git-hulk <hulk.website@gmail.com>",
"is_bot": false,
"headline": "Add support for CREATE USER statement according to ClickHouse SQL doc…",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-07-03T09:07:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bce7652f34aceac291f6ead7c65f47788247bdde",
"body": null,
"is_bot": false,
"headline": "Export Enter and Leave methods in ASTVisitor interface (#172)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-07-03T07:47:35Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 24,
"commits_last_year": 95,
"latest_release_at": "2026-07-11T07:11:11Z",
"latest_release_tag": "v0.5.2",
"releases_from_tags": false,
"days_since_last_push": 16,
"active_weeks_last_year": 29,
"days_since_latest_release": 16,
"mean_days_between_releases": 35.3
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": false,
"health_percentage": 37,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": [
{
"name": "github.com/AfterShip/clickhouse-sql-parser",
"exists": true,
"license": null,
"keywords": [],
"ecosystem": "go",
"matches_repo": true,
"registry_url": "https://pkg.go.dev/github.com/AfterShip/clickhouse-sql-parser",
"is_deprecated": false,
"latest_version": "v0.5.2",
"repository_url": "https://github.com/AfterShip/clickhouse-sql-parser",
"versions_count": 33,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": null,
"first_published_at": null,
"latest_published_at": "2026-07-05T07:23:50Z",
"latest_version_yanked": null,
"days_since_latest_publish": 22
}
]
},
"popularity": {
"forks": 51,
"stars": 242,
"watchers": 5,
"fork_history": {
"days": [
{
"date": "2023-09-22",
"count": 2
},
{
"date": "2023-09-24",
"count": 1
},
{
"date": "2023-10-18",
"count": 1
},
{
"date": "2024-01-22",
"count": 1
},
{
"date": "2024-01-26",
"count": 1
},
{
"date": "2024-02-08",
"count": 1
},
{
"date": "2024-06-09",
"count": 1
},
{
"date": "2024-06-11",
"count": 1
},
{
"date": "2024-06-14",
"count": 1
},
{
"date": "2024-07-09",
"count": 1
},
{
"date": "2024-07-15",
"count": 1
},
{
"date": "2024-07-18",
"count": 1
},
{
"date": "2024-08-06",
"count": 1
},
{
"date": "2024-09-27",
"count": 1
},
{
"date": "2024-11-06",
"count": 1
},
{
"date": "2024-11-28",
"count": 1
},
{
"date": "2024-12-27",
"count": 1
},
{
"date": "2025-02-10",
"count": 1
},
{
"date": "2025-02-26",
"count": 1
},
{
"date": "2025-03-21",
"count": 1
},
{
"date": "2025-04-05",
"count": 1
},
{
"date": "2025-04-24",
"count": 1
},
{
"date": "2025-05-23",
"count": 1
},
{
"date": "2025-05-29",
"count": 1
},
{
"date": "2025-06-07",
"count": 1
},
{
"date": "2025-06-11",
"count": 1
},
{
"date": "2025-06-18",
"count": 1
},
{
"date": "2025-07-07",
"count": 1
},
{
"date": "2025-07-14",
"count": 1
},
{
"date": "2025-07-18",
"count": 1
},
{
"date": "2025-07-22",
"count": 1
},
{
"date": "2025-08-12",
"count": 1
},
{
"date": "2025-08-16",
"count": 1
},
{
"date": "2025-08-21",
"count": 1
},
{
"date": "2025-09-25",
"count": 1
},
{
"date": "2025-09-30",
"count": 1
},
{
"date": "2025-10-02",
"count": 1
},
{
"date": "2025-10-11",
"count": 1
},
{
"date": "2025-10-26",
"count": 1
},
{
"date": "2025-11-03",
"count": 1
},
{
"date": "2025-11-07",
"count": 1
},
{
"date": "2025-11-17",
"count": 2
},
{
"date": "2025-11-25",
"count": 1
},
{
"date": "2026-01-12",
"count": 1
},
{
"date": "2026-01-20",
"count": 1
},
{
"date": "2026-01-28",
"count": 1
},
{
"date": "2026-03-18",
"count": 1
},
{
"date": "2026-04-08",
"count": 1
},
{
"date": "2026-05-11",
"count": 1
}
],
"complete": true,
"collected": 51,
"total_forks": 51
},
"star_history": null,
"open_issues_and_prs": 0
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": false,
"has_mcp_signal": false,
"bootstrap_files": [
"Makefile"
],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [
"go.mod"
],
"largest_source_bytes": 123155,
"source_files_sampled": 32,
"oversized_source_files": 3,
"agent_instruction_files": [
"AGENTS.md"
],
"agent_instruction_max_bytes": 3523
},
"dependencies": {
"manifests": [
"go.mod"
],
"advisories": {
"error": null,
"scope": "repository_graph",
"source": "osv",
"findings": [],
"collected": true,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 6,
"malicious_count": 0,
"assessed_package": null,
"unassessed_count": 0,
"direct_affected_count": 0
},
"ecosystems": [
"go"
],
"dependencies": [
{
"name": "github.com/sebdah/goldie/v2",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v2.5.3"
},
{
"name": "github.com/stretchr/testify",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v1.8.4"
}
],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "github.com/sebdah/goldie/v2",
"direct": true,
"version": "v2.5.3",
"ecosystem": "go"
},
{
"name": "github.com/stretchr/testify",
"direct": true,
"version": "v1.8.4",
"ecosystem": "go"
},
{
"name": "github.com/davecgh/go-spew",
"direct": false,
"version": "v1.1.1",
"ecosystem": "go"
},
{
"name": "github.com/pmezard/go-difflib",
"direct": false,
"version": "v1.0.0",
"ecosystem": "go"
},
{
"name": "github.com/sergi/go-diff",
"direct": false,
"version": "v1.0.0",
"ecosystem": "go"
},
{
"name": "gopkg.in/yaml.v3",
"direct": false,
"version": "v3.0.1",
"ecosystem": "go"
}
],
"collected": true,
"truncated": false,
"total_count": 6,
"direct_count": 2,
"indirect_count": 4
}
},
"maintainership": {
"issues": {
"open_prs": 0,
"merged_prs": 182,
"open_issues": 0,
"closed_ratio": 1,
"closed_issues": 87,
"closed_unmerged_prs": 12
},
"bus_factor": 1,
"bot_contributors": 1,
"top_contributors": [
{
"type": "User",
"login": "git-hulk",
"commits": 133,
"avatar_url": "https://avatars.githubusercontent.com/u/4987594?v=4"
},
{
"type": "User",
"login": "sharadgaur",
"commits": 11,
"avatar_url": "https://avatars.githubusercontent.com/u/2407900?v=4"
},
{
"type": "User",
"login": "Lance726",
"commits": 9,
"avatar_url": "https://avatars.githubusercontent.com/u/107540329?v=4"
},
{
"type": "User",
"login": "erezrokah",
"commits": 8,
"avatar_url": "https://avatars.githubusercontent.com/u/26760571?v=4"
},
{
"type": "User",
"login": "laojianzi",
"commits": 7,
"avatar_url": "https://avatars.githubusercontent.com/u/42930263?v=4"
},
{
"type": "User",
"login": "ajruckman",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/40143425?v=4"
},
{
"type": "User",
"login": "rhino1998",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/9094640?v=4"
},
{
"type": "User",
"login": "swgillespie",
"commits": 3,
"avatar_url": "https://avatars.githubusercontent.com/u/1871912?v=4"
},
{
"type": "User",
"login": "hermanschaaf",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/1121616?v=4"
},
{
"type": "User",
"login": "orian",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/144554?v=4"
}
],
"contributors_sampled": 31,
"top_contributor_share": 0.639
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"ci.yaml"
],
"has_docs_dir": false,
"linter_configs": [
".golangci.yml"
],
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": false
},
"security_signals": {
"lockfiles": [
"go.sum"
],
"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": null,
"reason": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 10,
"reason": "23 out of 23 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": 5,
"reason": "Found 15/30 approved changesets -- score normalized to 5",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 10,
"reason": "project has 8 contributing companies or organizations",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": 10,
"reason": "no dangerous workflow patterns detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 0,
"reason": "no update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 10,
"reason": "17 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
},
{
"name": "Packaging",
"score": null,
"reason": "packaging workflow not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
},
{
"name": "Pinned-Dependencies",
"score": 0,
"reason": "dependency not pinned by hash detected -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
},
{
"name": "SAST",
"score": 5,
"reason": "SAST tool is not run on all commits -- score normalized to 5",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
},
{
"name": "Security-Policy",
"score": 0,
"reason": "security policy file not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
},
{
"name": "Signed-Releases",
"score": null,
"reason": "no releases found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
},
{
"name": "Token-Permissions",
"score": 10,
"reason": "GitHub workflow tokens follow principle of least privilege",
"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": "e4c6e11fcec9a7140ef53835fae0728b2f304a3c",
"ran_at": "2026-07-27T17:24:00Z",
"aggregate_score": 6.3,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": false,
"has_dependabot_config": false
},
"contribution_flow": {
"collected": true,
"ci_last_run_at": "2026-07-25T18:53:57Z",
"oldest_open_prs": [],
"last_merged_pr_at": "2026-07-05T07:23:50Z",
"ci_last_conclusion": "SUCCESS",
"oldest_open_issues": []
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/AfterShip/clickhouse-sql-parser",
"host": "github.com",
"name": "clickhouse-sql-parser",
"owner": "AfterShip"
},
"metrics": {
"overall": {
"key": "overall",
"band": "excellent",
"name": "Overall health",
"note": "The weighted overall 72 is calibrated to 86 on the published index scale (record calibration 2026-08-02).",
"notes": [
{
"code": "overall_calibration",
"params": {
"raw": 72,
"calibrated": 86,
"calibration": "2026-08-02"
}
}
],
"value": 86,
"inputs": {
"security": 70,
"vitality": 86,
"community": 53,
"governance": 72,
"calibration": "2026-08-02",
"engineering": 74,
"ai_readiness": 85,
"weighted_overall_raw": 72
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "excellent",
"name": "Vitality",
"value": 86,
"weight": 0.21,
"metrics": [
{
"key": "development_activity",
"band": "good",
"name": "Development activity",
"note": null,
"notes": [],
"value": 77,
"inputs": {
"commits_last_year": 95,
"human_commit_share": 1,
"days_since_last_push": 16,
"active_weeks_last_year": 29
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 16 days ago",
"points": 28.8,
"status": "partial",
"details": [
{
"code": "push_recency",
"params": {
"days": 16
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "29/52 weeks with commits",
"points": 20.1,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 29
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "95 commits in the last year",
"points": 17.8,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 95
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "17 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "exceptional",
"name": "Release discipline",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 100,
"inputs": {
"releases_count": 24,
"latest_release_tag": "v0.5.2",
"releases_from_tags": false,
"days_since_latest_release": 16,
"mean_days_between_releases": 35.3
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "24 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 24
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 16 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "release_recency",
"params": {
"days": 16
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~35.3 days",
"points": 27,
"status": "met",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 35.3
}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "abandonment",
"band": "exceptional",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"cap": null,
"state": "maintained",
"guards": [],
"signals": [],
"red_flag": false,
"multiplier_pct": 100,
"declared_reason": null,
"unverified_reason": null,
"unanswered_open_prs": null,
"unanswered_open_issues": null,
"days_since_last_merged_pr": null,
"days_since_last_human_commit": 28,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 28 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 28
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "moderate",
"name": "Community & Adoption",
"value": 53,
"weight": 0.17,
"metrics": [
{
"key": "popularity",
"band": "moderate",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 56,
"inputs": {
"forks": 51,
"stars": 242,
"watchers": 5,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "242 stars",
"points": 38.6,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 242
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "51 forks",
"points": 14.2,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 51
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "5 watchers",
"points": 3.3,
"status": "partial",
"details": [
{
"code": "watchers",
"params": {
"count": 5
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "moderate",
"name": "Community health",
"note": null,
"notes": [],
"value": 50,
"inputs": {
"has_readme": true,
"has_license": true,
"readme_badges": null,
"has_contributing": false,
"has_issue_template": false,
"has_code_of_conduct": false,
"readme_badge_services": [],
"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": 0,
"status": "missed",
"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
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "good",
"name": "Sustainability & Governance",
"value": 72,
"weight": 0.23,
"metrics": [
{
"key": "maintainer_resilience",
"band": "weak",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 41,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 31,
"top_contributor_share": 0.639
},
"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 64% of commits",
"points": 8.1,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 64
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "31 contributors",
"points": 13.5,
"status": "met",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 31
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 8 contributing companies or organizations",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "excellent",
"name": "Issue & PR responsiveness",
"note": "Excluded from scoring (no data or not applicable): Newcomer PR acceptance. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"newcomer_pr_acceptance"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 89,
"inputs": {
"merged_prs": 182,
"open_issues": 0,
"closed_issues": 87,
"prs_merged_7d": null,
"prs_decided_7d": null,
"prs_merged_30d": null,
"prs_decided_30d": null,
"issue_closed_ratio": 1,
"closed_unmerged_prs": 12,
"first_time_authors_30d": null,
"first_time_prs_merged_30d": null,
"first_time_prs_decided_30d": null
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "100% of issues closed",
"points": 42,
"status": "met",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 100
}
}
],
"max_points": 42
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "182/194 decided PRs merged",
"points": 28.1,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 182,
"decided": 194
}
}
],
"max_points": 30
},
{
"key": "newcomer_pr_acceptance",
"name": "Newcomer PR acceptance",
"detail": "no first-time contributor's PR decided in 30d",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_newcomer_prs",
"params": {
"days": 30
}
}
],
"max_points": 13
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 15/30 approved changesets -- score normalized to 5",
"points": 7.5,
"status": "partial",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "good",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 71,
"inputs": {
"followers": 169,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "AfterShip",
"public_repos": 81,
"account_age_days": 5306
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "organization-owned",
"points": 30,
"status": "met",
"details": [
{
"code": "owner_organization",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "169 followers of AfterShip",
"points": 16,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 169,
"login": "AfterShip"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "81 public repos, account ~14 yr old",
"points": 25,
"status": "met",
"details": [
{
"code": "public_repos",
"params": {
"count": 81
}
},
{
"code": "account_age_years",
"params": {
"years": 14
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "exceptional",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"github.com/AfterShip/clickhouse-sql-parser"
],
"ecosystems": "go",
"any_deprecated": false,
"min_days_since_publish": 22
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "1 package(s) on go",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 1,
"ecosystems": "go"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 22 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 22
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "33 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 33
}
}
],
"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": 74,
"weight": 0.19,
"metrics": [
{
"key": "engineering_practices",
"band": "excellent",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 84,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "1 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 1
}
}
],
"max_points": 24
},
{
"key": "tests_present",
"name": "Tests present",
"detail": null,
"points": 24,
"status": "met",
"details": [],
"max_points": 24
},
{
"key": "linter_config",
"name": "Linter config",
"detail": ".golangci.yml",
"points": 16,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": ".golangci.yml"
}
}
],
"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": "23 out of 23 merged PRs checked by a CI test -- score normalized to 10",
"points": 20,
"status": "met",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "moderate",
"name": "Documentation",
"note": null,
"notes": [],
"value": 60,
"inputs": {
"topics": [
"clickhouse",
"go",
"sql-parser"
],
"has_wiki": true,
"homepage": null,
"has_readme": true,
"has_docs_dir": false,
"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": 0,
"status": "missed",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": null,
"points": 0,
"status": "missed",
"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": "3 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 3
}
}
],
"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": "good",
"name": "Security",
"value": 70,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "moderate",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Branch-Protection, Packaging, Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"branch_protection",
"packaging",
"signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 63,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 15,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 3,
"scorecard_aggregate": 6.3
},
"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": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "23 out of 23 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 15/30 approved changesets -- score normalized to 5",
"points": 3.8,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 8 contributing companies or organizations",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no dangerous workflow patterns detected",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "dependency_update_tool",
"name": "Dependency-Update-Tool",
"detail": "no update tool detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "17 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow not detected",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "pinned_dependencies",
"name": "Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is not run on all commits -- score normalized to 5",
"points": 2.5,
"status": "partial",
"details": [],
"max_points": 5
},
{
"key": "security_policy",
"name": "Security-Policy",
"detail": "security policy file not detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "signed_releases",
"name": "Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "token_permissions",
"name": "Token-Permissions",
"detail": "GitHub workflow tokens follow principle of least privilege",
"points": 7.5,
"status": "met",
"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": "dependency_advisories",
"band": "exceptional",
"name": "Dependency advisories",
"note": "Excluded from scoring (no data or not applicable): Indirect dependencies free of known advisories, No advisories left outstanding. Remaining weights renormalized. Matched 6 resolved dependencies against OSV. This repository publishes no package the index resolves, so the repository dependency graph was assessed instead. That graph mixes development and test pins with shipped dependencies, so only the declared runtime dependencies are scored; transitive findings are reported as context and excluded from the score. Reachability is not analyzed.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"indirect_dependencies_free_of_known_advisories",
"no_advisories_left_outstanding"
]
}
},
{
"code": "weights_renormalized",
"params": {}
},
{
"code": "advisories_scope_repository",
"params": {
"assessed": 6
}
},
{
"code": "advisories_repo_graph_caveat",
"params": {}
},
{
"code": "advisories_reachability",
"params": {}
}
],
"value": 100,
"inputs": {
"source": "osv",
"advisories": 0,
"affected_packages": 0,
"assessed_packages": 6,
"unassessed_packages": 0,
"affected_by_severity": "none",
"direct_affected_packages": 0
},
"components": [
{
"key": "direct_dependencies_free_of_known_advisories",
"name": "Direct dependencies free of known advisories",
"detail": "no direct dependency carries a known advisory",
"points": 35,
"status": "met",
"details": [
{
"code": "no_direct_advisories",
"params": {}
}
],
"max_points": 35
},
{
"key": "indirect_dependencies_free_of_known_advisories",
"name": "Indirect dependencies free of known advisories",
"detail": "transitive set not separable from development and test dependencies in this scope",
"points": 0,
"status": "excluded",
"details": [
{
"code": "advisories_scope_not_separable",
"params": {}
}
],
"max_points": 25
},
{
"key": "no_advisories_left_outstanding",
"name": "No advisories left outstanding",
"detail": "no advisory carries a publication date",
"points": 0,
"status": "excluded",
"details": [
{
"code": "advisories_no_publication_date",
"params": {}
}
],
"max_points": 40
}
]
},
{
"key": "malicious_dependencies",
"band": "exceptional",
"name": "Malicious dependencies",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"source": "osv",
"meaning": "reported as a malicious package by the OpenSSF corpus; the remedy is removal or moving off the compromised name, never an upgrade of the same artifact. Versions the registry has since pulled are listed but not scored",
"packages": [],
"red_flag": false,
"assessed_packages": 6,
"malicious_packages": 0,
"direct_malicious_packages": 0,
"withdrawn_malicious_packages": 0,
"installable_malicious_packages": 0
},
"components": [
{
"key": "no_dependency_reported_as_a_malicious_package",
"name": "No dependency reported as a malicious package",
"detail": "no dependency is reported as a malicious package",
"points": 100,
"status": "met",
"details": [
{
"code": "no_malicious_dependencies",
"params": {}
}
],
"max_points": 100
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "exceptional",
"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"
],
"commit_weight_rule": {
"min_commits": 50,
"min_commit_share": 0.1
},
"review_only_matches": 0,
"below_threshold_exposures": [],
"assessed_self_published_locations": 13
},
"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": "excellent",
"name": "AI Readiness",
"value": 85,
"weight": 0.04,
"metrics": [
{
"key": "ai_agent_context",
"band": "excellent",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 85,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.78,
"agent_instruction_files": [
"AGENTS.md"
],
"agent_instruction_max_bytes": 3523
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "AGENTS.md",
"points": 45,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "AGENTS.md"
}
}
],
"max_points": 45
},
{
"key": "machine_readable_docs_llms_txt",
"name": "Machine-readable docs (llms.txt)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "legible_commit_history",
"name": "Legible commit history",
"detail": "78 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 40,
"status": "met",
"details": [
{
"code": "legible_history",
"params": {
"legible": 78,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "excellent",
"name": "Verify loop (build / test / typecheck)",
"note": null,
"notes": [],
"value": 82,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [
"go.sum"
],
"has_dockerfile": false,
"typed_language": true,
"bootstrap_files": [
"Makefile"
],
"has_devcontainer": false,
"has_linter_config": true,
"typecheck_configs": [],
"agent_commit_share": 0.25,
"toolchain_manifests": [
"go.mod"
],
"dependency_bot_commit_share": 0
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": "Makefile",
"points": 18,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Makefile"
}
}
],
"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": ".golangci.yml",
"points": 11,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": ".golangci.yml"
}
}
],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": "Go (statically typed)",
"points": 11,
"status": "met",
"details": [
{
"code": "statically_typed_language",
"params": {
"language": "Go"
}
}
],
"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": "25 of the last 100 commits agent-authored or agent-credited",
"points": 10,
"status": "met",
"details": [
{
"code": "agent_authored_commits",
"params": {
"count": 25,
"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": "exceptional",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 95,
"inputs": {
"primary_language": "Go",
"largest_source_bytes": 123155,
"source_files_sampled": 32,
"oversized_source_files": 3
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "Go (statically typed)",
"points": 45,
"status": "met",
"details": [
{
"code": "statically_typed_language",
"params": {
"language": "Go"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "3/32 source files over 60KB",
"points": 49.8,
"status": "partial",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 32,
"oversized": 3
}
}
],
"max_points": 55
}
]
}
],
"description": "How well is the repo equipped to be developed and maintained with AI coding agents? Carries a deliberately small weight: agent tooling is a real maintenance signal, but its absence must never gate the top of the scale (calibration saturates at raw 91, so 100/100 remains reachable with AI Readiness at zero)."
}
],
"classification": {
"labels": [
"library"
],
"scores": {
"cli": 2,
"library": 8
},
"primary": "library",
"evidence": [
{
"tier": "distribution",
"label": "library",
"source": "registry:go",
"weight": 6
},
{
"tier": "description",
"label": "cli",
"source": "description:cli",
"weight": 2
},
{
"tier": "description",
"label": "library",
"source": "description:library",
"weight": 2
}
],
"artifacts": [],
"confidence": "medium",
"host_extension": false,
"runs_as_process": false,
"consumed_by_code": true
},
"metrics_version": "2.3.1"
},
"warnings": [
"Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token"
],
"report_type": "repository",
"generated_at": "2026-07-27T17:24:27.075016Z",
"schema_version": "0.27.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/a/AfterShip/clickhouse-sql-parser.svg",
"full_name": "AfterShip/clickhouse-sql-parser",
"license_state": "standard",
"license_spdx": "MIT"
}