公开记录中等
软件健康报告模式 0.26.0 · 指标 1.13.0 · 2026-07-22 17:44 UTC
iamcal / SQLParser
Parse MySQL schemas in PHP, fast
iamcal/SQLParser 的健康指数为 100 分中的 50 分，处于「中等」区间。 其得分最高的类别是Sustainability & Governance（68/100），最低的是Security（30/100）。 最近一次更新在 174 天前。 近期的大部分工作由 1 位贡献者完成。
50
总分 / 100软件健康指数
指标归入加权类别，统一采用 1–100 量表。总体分先取类别加权平均；当公开证据触发高风险司法辖区政策时，评级会按政策调整，并设置 49（有风险）的上限。AI 就绪度不计入总体分。
50
优秀85-100堪称典范；基本满足所有检验标准
良好70-84健康；仅有轻微不足
中等50-69可接受，但存在明显不足；建议进行审查
存在风险30-49存在重大薄弱环节；采用时应保持审慎
危急1-29问题严重（项目被弃置、仅有单一维护者、缺乏基本工程规范）
评分画像
每条轴代表一个类别。形状比平均值更重要——健康的对象会填满整个图形，而“一峰一谷”式画像意味着某一维度的优势正掩盖另一维度的风险。
所有权
软件包生态系统
| 注册表 | 软件包 | 版本 | 月下载量 | 版本数 | 最近发布 |
|---|---|---|---|---|---|
| Packagist | iamcal/sql-parser | v0.7 | 4,742,890 | 7 | 174 天前 |
按类别列示的指标
活力
项目是否仍有生命——是否仍在编写代码，是否仍在发布版本？
37
开发活跃度
18危急
评分方式
| 9.9/36 | 推送新近度 — 最近一次推送于 174 天前 |
| 0.7/36 | 提交节奏 — 52 周中有 1 周有提交 |
| 7.6/18 | 提交量 — 最近一年 6 次提交 |
| 0/10 | OpenSSF Scorecard：Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0 |
所用输入
| commits_last_year | 6 |
| human_commit_share | 1 |
| days_since_last_push | 174 |
| active_weeks_last_year | 1 |
发布纪律
66中等
评分方式
| 27/27 | 有发布版本 — 已发布 2 个发布版本 |
| 27/36 | 发布时效 — 最近一次发布版本于 174 天前 |
| 5.4/27 | 发布节奏 — 约每 3,062.7 天发布一次 |
| 0/10 | OpenSSF Scorecard：Signed-Releases — 无数据 |
所用输入
| releases_count | 2 |
| latest_release_tag | v0.7 |
| releases_from_tags | 否 |
| days_since_latest_release | 174 |
| mean_days_between_releases | 3,062.7 |
已排除计分（无数据或不适用）：OpenSSF Scorecard：Signed-Releases。 其余权重已重新归一化。
社区与采用
项目是否拥有用户、下载量与关注度，并具备欢迎贡献者参与的配置？
56
流行度与采用
43存在风险
评分方式
| 30.5/60 | 星标 — 77 个星标 |
| 10.7/25 | 复刻 — 20 个复刻 |
| 1.7/15 | 关注者 — 3 位关注者 |
所用输入
| forks | 20 |
| stars | 77 |
| watchers | 3 |
| 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 | 是 |
| has_contributing | 否 |
| has_issue_template | 否 |
| has_code_of_conduct | 否 |
| has_pull_request_template | 否 |
生态采用（下载量）
87优秀
评分方式
| 80/80 | 月度下载量 — packagist 合计每月 4,742,890 次下载 |
| 6.9/20 | 注册表被依赖数 — 10 个软件包依赖它 |
所用输入
| packages | iamcal/sql-parser |
| dependents | 10 |
| ecosystems | packagist |
| total_downloads | 38,486,535 |
| monthly_downloads | 4,742,890 |
可持续性与治理
项目能否在其成员之外延续——巴士系数、响应能力、由谁支持，以及软件包的维护状况？
68
维护者韧性（巴士系数）
29危急
评分方式
| 9/54 | 巴士系数 — 1 位贡献者贡献了半数提交 |
| 2.9/22.5 | 提交分布 — 头号贡献者编写了 87% 的提交 |
| 10.8/13.5 | 贡献者广度 — 8 位贡献者 |
| 6/10 | OpenSSF Scorecard：Contributors — project has 2 contributing companies or organizations -- score normalized to 6 |
所用输入
| bus_factor | 1 |
| contributors_sampled | 8 |
| top_contributor_share | 0.872 |
议题与 PR 响应能力
86优秀
评分方式
| 46.8/46.8 | 议题解决 — 100% 的议题已关闭 |
| 34.9/38.3 | PR 接受 — 已裁定的 PR 中 21/23 已合并 |
| 4.5/15 | OpenSSF Scorecard：Code-Review — Found 8/22 approved changesets -- score normalized to 3 |
所用输入
| merged_prs | 21 |
| open_issues | 0 |
| closed_issues | 8 |
| issue_closed_ratio | 1 |
| closed_unmerged_prs | 2 |
所有权与托管责任
71良好
评分方式
| 10/30 | 所有权背书 — 个人（用户）账户 |
| 0/20 | 已验证域名 — 不适用于个人账户 |
| 21.6/25 | 所有者影响力 — iamcal 有 1,025 位关注者 |
| 25/25 | 既往记录 — 193 个公开仓库，账户约 16 年 |
所用输入
| followers | 1,025 |
| owner_type | User |
| is_verified | — |
| owner_login | iamcal |
| public_repos | 193 |
| account_age_days | 6,048 |
已排除计分（无数据或不适用）：已验证域名。 其余权重已重新归一化。
软件包维护
100优秀
评分方式
| 25/25 | 已发布且可解析 — packagist 上有 1 个软件包 |
| 35/35 | 发布时效 — 最近一次发布于 174 天前 |
| 20/20 | 版本历史 — 7 个已发布版本 |
| 20/20 | 未被弃用 — 活跃，未被弃用或撤回 |
所用输入
| packages | iamcal/sql-parser |
| ecosystems | packagist |
| any_deprecated | 否 |
| min_days_since_publish | 174 |
工程质量
基础的工程与文档实践是否到位？
53
工程实践
48存在风险
评分方式
| 24/24 | CI 工作流 — 1 个工作流 |
| 24/24 | 存在测试 |
| 0/16 | Linter 配置 |
| 0/9.6 | Pre-commit 钩子 |
| 0/6.4 | .editorconfig |
| 0/20 | OpenSSF Scorecard：CI-Tests — 1 out of 16 merged PRs checked by a CI test -- score normalized to 0 |
所用输入
| has_ci | 是 |
| has_tests | 是 |
| has_editorconfig | 否 |
| has_linter_config | 否 |
| has_precommit_config | 否 |
文档
60中等
评分方式
| 30/30 | README |
| 0/25 | 文档目录 |
| 0/15 | 文档 / 主页站点 |
| 10/10 | 仓库描述 |
| 10/10 | 主题标签 — 6 个主题标签 |
| 10/10 | Wiki |
所用输入
| topics | php, sql-parser, lex, composer, database, autoloader |
| has_wiki | 是 |
| homepage | — |
| has_readme | 是 |
| has_docs_dir | 否 |
| has_description | 是 |
安全
可见的安全与供应链实践是否稳固，且不存在未解决的高风险司法辖区暴露？
30
安全态势
30存在风险
评分方式
| 7.5/7.5 | Binary-Artifacts — no binaries found in the repo |
| 0/7.5 | Branch-Protection — branch protection not enabled on development/release branches |
| 0/2.5 | CI-Tests — 1 out of 16 merged PRs checked by a CI test -- score normalized to 0 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 2.2/7.5 | Code-Review — Found 8/22 approved changesets -- score normalized to 3 |
| 1.5/2.5 | Contributors — project has 2 contributing companies or organizations -- score normalized to 6 |
| 0/10 | Dangerous-Workflow — 无数据 |
| 0/7.5 | Dependency-Update-Tool — no update tool detected |
| 0/5 | Fuzzing — project is not fuzzed |
| 2.5/2.5 | 许可证 — license file detected |
| 0/7.5 | Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0 |
| 0/5 | Packaging — 无数据 |
| 0/5 | Pinned-Dependencies — 无数据 |
| 0/5 | SAST — SAST tool is not run on all commits -- score normalized to 0 |
| 0/5 | Security-Policy — security policy file not detected |
| 0/7.5 | Signed-Releases — 无数据 |
| 0/7.5 | Token-Permissions — 无数据 |
| 7.5/7.5 | Vulnerabilities — 0 existing vulnerabilities detected |
所用输入
| source | openssf_scorecard |
| checks_evaluated | 13 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 5 |
| scorecard_aggregate | 3 |
已排除计分（无数据或不适用）：dangerous_workflow, packaging, pinned_dependencies, signed_releases, token_permissions。 其余权重已重新归一化。
AI 就绪度
该仓库在多大程度上具备与 AI 编码代理协同开发与维护的条件？这是一枚独立的实验性徽章——权重为 0.0，因此单独呈现，不影响总体健康评分。
33
AI 代理上下文与指引
6危急
评分方式
| 0/45 | 代理指令 — 没有 CLAUDE.md / AGENTS.md / 编辑器规则 |
| 0/15 | 机器可读文档（llms.txt） |
| 6.4/40 | 可读的提交历史 — 100 次人类提交中有 12 次说明了意图（结构化标题或解释性正文） |
所用输入
| has_llms_txt | 否 |
| legible_history_share | 0.12 |
| agent_instruction_files | — |
| agent_instruction_max_bytes | — |
验证循环（构建 / 测试 / 类型检查）
44存在风险
评分方式
| 18/18 | 一条命令的引导启动 — Makefile |
| 22/22 | 自动化测试 |
| 0/11 | Lint / 格式化配置 |
| 0/11 | 静态类型检查 |
| 0/10 | 可复现环境 |
| 0/10 | 已体现的代理实践 — 最近 100 次提交中没有代理编写的提交 |
| 0/8 | 自动化维护 — 未观察到自动依赖更新 |
| 0/10 | OpenSSF Scorecard：Pinned-Dependencies — 无数据 |
所用输入
| has_nix | 否 |
| has_tests | 是 |
| lockfiles | — |
| has_dockerfile | 否 |
| typed_language | 否 |
| bootstrap_files | Makefile |
| has_devcontainer | 否 |
| has_linter_config | 否 |
| typecheck_configs | — |
| agent_commit_share | 0 |
| toolchain_manifests | — |
| dependency_bot_commit_share | 0 |
已排除计分（无数据或不适用）：OpenSSF Scorecard：Pinned-Dependencies。 其余权重已重新归一化。
面向模型的代码可读性
55中等
评分方式
| 0/45 | 可类型检查的代码 — PHP，未配置类型检查 |
| 55/55 | 可控的文件大小 — 采样的 12 个源文件中有 0 个超过 60KB |
所用输入
| primary_language | PHP |
| largest_source_bytes | 27,313 |
| source_files_sampled | 12 |
| oversized_source_files | 0 |
关键数据
77GitHub 星标
8贡献者
6最近 12 个月提交数
174距最近推送天数
2发布版本数
1巴士系数（bus factor）
0开放议题
Packagist软件包生态系统数
数据采集警告
- Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
- No resolved dependencies carried a version and a supported ecosystem
更多细节
Star 与 Fork 历史 0 ★ / 20 ⇿
0Star
20Fork
1发布
每颗 star 和每个 fork 的添加时间，来自 GitHub 并按天汇总。累计增长位于其构成来源——每日新增——的正上方，二者可相互对照：稳定的自然增长与短暂的突增形态截然不同。当这一差别可被衡量时，它会作为增长真实性予以报告。
主版本 0次版本 0修订 0
每个点涵盖 9 天。
OpenSSF Scorecard 3.0 / 10
3.0综合
来自开源项目 OpenSSF Scorecard 的独立、工具无关的安全评估。每项检查奖励的是安全实践本身，而非特定供应商的工具。Scorecard 无法判定的检查项标记为 不适用，并从安全评分中剔除（绝不按零分计）。
| 10 | Binary-Artifacts | no binaries found in the repo |
| 0 | Branch-Protection | branch protection not enabled on development/release branches |
| 0 | CI-Tests | 1 out of 16 merged PRs checked by a CI test -- score normalized to 0 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 3 | Code-Review | Found 8/22 approved changesets -- score normalized to 3 |
| 6 | Contributors | project has 2 contributing companies or organizations -- score normalized to 6 |
| 不适用 | Dangerous-Workflow | no workflows found |
| 0 | Dependency-Update-Tool | no update tool detected |
| 0 | Fuzzing | project is not fuzzed |
| 10 | License | license file detected |
| 0 | Maintained | 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0 |
| 不适用 | Packaging | packaging workflow not detected |
| 不适用 | Pinned-Dependencies | no dependencies found |
| 0 | SAST | SAST tool is not run on all commits -- score normalized to 0 |
| 0 | Security-Policy | security policy file not detected |
| 不适用 | Signed-Releases | no releases found |
| 不适用 | Token-Permissions | No tokens found |
| 10 | Vulnerabilities | 0 existing vulnerabilities detected |
全部依赖 2
来自 GitHub 依赖图的完整解析依赖集合：0 个直接依赖与 2 个间接（传递）软件包。仓库提交锁文件时，传递闭包才是完整的。
| 注册表 | 软件包 | 版本 | 关系 |
|---|---|---|---|
| Packagist | php-coveralls/php-coveralls | — | 间接 |
| Packagist | phpunit/phpunit | — | 间接 |
依赖安全公告 未评估
本报告未能完成公告比对：No resolved dependencies carried a version and a supported ecosystem
原始 JSON 报告 机器可读
{
"data": {
"repo": {
"topics": [
"php",
"sql-parser",
"lex",
"composer",
"database",
"autoloader"
],
"is_fork": false,
"size_kb": 183,
"has_wiki": true,
"homepage": null,
"languages": {
"PHP": 66319,
"Makefile": 73
},
"pushed_at": "2026-01-28T22:23:25Z",
"created_at": "2013-01-04T23:49:17Z",
"owner_type": "User",
"updated_at": "2026-05-28T19:50:24Z",
"description": "Parse MySQL schemas in PHP, fast",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "master",
"license_spdx_raw": "MIT",
"primary_language": "PHP",
"significant_languages": [
"PHP"
]
},
"owner": {
"blog": "http://www.iamcal.com/",
"name": "Cal Henderson",
"type": "User",
"login": "iamcal",
"company": "Slack",
"location": "San Francisco, CA",
"followers": 1025,
"avatar_url": "https://avatars.githubusercontent.com/u/173750?v=4",
"created_at": "2009-12-29T17:57:48Z",
"is_verified": null,
"public_repos": 193,
"account_age_days": 6048
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v0.7",
"kind": "other",
"published_at": "2026-01-28T22:23:25Z"
},
{
"tag": "0.1",
"kind": "other",
"published_at": "2017-09-10T05:04:30Z"
}
],
"recent_commits": [
{
"oid": "610392f38de49a44dab08dc1659960a29874c4b8",
"body": null,
"is_bot": false,
"headline": "Fix quote doubling decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "47edc41c929b33266e3affc151281f0361667c99",
"body": null,
"is_bot": false,
"headline": "Add tests for quote doubling decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "02f623f2f3f425d5c9bbef342a3d17db2dc1aebf",
"body": null,
"is_bot": false,
"headline": "Fix quote doubling lexing",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ec94c056723d37bfeb14316b0f29b8b67373e0a5",
"body": null,
"is_bot": false,
"headline": "Add tests for quote doubling lexing",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a8106d8925cb33792819e1ebbdfb2dbfcc4fbcee",
"body": null,
"is_bot": false,
"headline": "Fix escaped quote decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a831815c183aa572f0a9743a50e723fe869aa8cf",
"body": null,
"is_bot": false,
"headline": "Add tests for escaped quote decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "947083e2dca211a6f12fb1beb67a01e387de9b62",
"body": null,
"is_bot": false,
"headline": "feat: add `.gitattributes`",
"author_name": "Owen Voke",
"author_login": "owenvoke",
"committed_at": "2025-03-17T16:59:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0262cfb8bc1d04e91b8f927e7105037c440e4ccc",
"body": null,
"is_bot": false,
"headline": "throw exception instead of die",
"author_name": "DirtyRacer1337",
"author_login": "DirtyRacer1337",
"committed_at": "2025-03-16T16:28:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "52f3c952969148d6d25073911e6c369dbdf51cc0",
"body": null,
"is_bot": false,
"headline": "Merge branch 'zzycad-master'",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-12-13T18:47:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a670a900cae83cd9f019711aa7e8d296235fcb5a",
"body": null,
"is_bot": false,
"headline": "added tests for field comments",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-12-13T18:46:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7308b62557ffd8662f36904f8e059238d38ef1f3",
"body": "…ers too)",
"is_bot": false,
"headline": "added test for negative default values (generally tests negative numb…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-12-13T18:44:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "37f43534dbffd77281f8f876aef6e69a784c3f54",
"body": "…le field comments.",
"is_bot": false,
"headline": "Fix the bug with default negative values, and add the ability to hand…",
"author_name": "zzy",
"author_login": null,
"committed_at": "2024-12-13T09:32:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "644fd994de3b54e5d833aecf406150aa3b66ca88",
"body": "Start testing there...",
"is_bot": false,
"headline": "PHP 8.3 support",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-03-22T22:46:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a9f3f74d1d390665868b64404cbe7faaed558f8c",
"body": null,
"is_bot": false,
"headline": "supports [5.6,...,8.2]",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1fe57fa39d6de91fc7a2988a7d0c205becbcf341",
"body": null,
"is_bot": false,
"headline": "removed dynamic property",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3356bcd528aa98b8a8c3e655c17baadcdf1c9dcf",
"body": null,
"is_bot": false,
"headline": "add code blocks",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9b56b6b42006e167a8f37c2cc84cbbb08515dae7",
"body": null,
"is_bot": false,
"headline": "ignore cache, vendor, build",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2c5eb8b229d4937a16a1bd17c5e2b137ce3b4597",
"body": "* detect when we've reached the end of input when lexing an unterminated string\r\n* added a mode where we throw exceptions for invalid syntax\r\n* added tests for invalid syntax, in both default and exception mode\r\n* documented `$parser->throw_on_bad_syntax`\r\n* get tests running again on php 8.1 (broken by https://github.com/sebastianbergmann/phpunit/issues/4740)",
"is_bot": false,
"headline": "Throw on bad syntax (#23)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2022-03-05T00:19:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4080544b2df11132eecdb57fbe91c07dbbe5bc41",
"body": null,
"is_bot": false,
"headline": "added an alernatives section to the readme",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2022-03-04T23:44:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5ae12b79b0192d84b8ebc29541c55703104064e6",
"body": null,
"is_bot": false,
"headline": "how to publish changes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2022-03-04T23:40:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3ceec1bdb7c0cfe0c10afdd1493889a0f2a484d9",
"body": "* name the build sensibly\r\n* updated the badge images",
"is_bot": false,
"headline": "Show a build bade for Github Actions (#21)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:39:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4f897e91f98cf0be4602822b2fd08197e47ffa40",
"body": "* JSON is a type with no params\r\n* spatial types are all param-less too\r\n* added some missing field type aliases\r\n* added boolean type (plus alias)\r\n* updated the list of \"unsupported\", to cover all the 5.7 field types i've found\r\n* normalize whitespace",
"is_bot": false,
"headline": "Full support for 5.7 field types (#16)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:34:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "de2497155b098a23ae58a56aba2fe0867885b40a",
"body": null,
"is_bot": false,
"headline": "Upgrade to Ubuntu 20 for all CI (#20)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:31:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aebd40a35c51bd08a2e4e09a5b8bf3cdcfb68e91",
"body": null,
"is_bot": false,
"headline": "add php 8.1 to build matrix (#19)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:25:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0da94942aecc15fbda275dffd6e420726ac00f8c",
"body": "* added PHP 5.3 to the build matrix\r\n* php 5.3 compat in code and tests: `[] -> array()`",
"is_bot": false,
"headline": "Support for PHP 5.3",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:19:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0f853a6f0ff736bf5836589cafabe9636e87ad6f",
"body": "Switch from Travis to Github Actions as our test runner",
"is_bot": false,
"headline": "Using github actions (#17)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T18:33:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9bf1bfdf69655c69bc5e5368a2bc034dcc632fe8",
"body": null,
"is_bot": false,
"headline": "JSON case",
"author_name": "William Peter Falci",
"author_login": "WilliamFalci",
"committed_at": "2020-12-29T00:00:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e2d6e9e186c347cc3f00733bf6c7799ec4b3c624",
"body": null,
"is_bot": false,
"headline": "Fix undefined offset exception",
"author_name": "richardudovich",
"author_login": "richardudovich",
"committed_at": "2019-03-01T17:16:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a3a40469722f28506c0c000e8b42c6854d0e11bd",
"body": null,
"is_bot": false,
"headline": "support database",
"author_name": "Alexey Solodkiy",
"author_login": null,
"committed_at": "2019-03-01T01:31:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f3fa038fd07ca30c0b3be4726f7693ecafe45c8b",
"body": null,
"is_bot": false,
"headline": "the commits will continue until morale improves",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T01:26:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "02351ce150b86007c3bc6268bd1aeae9687906fd",
"body": null,
"is_bot": false,
"headline": "try this?",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T01:20:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ce4625d0cf9036f28c37a69648decc9536b7499a",
"body": "peg to 7.4 which was the last one that worked",
"is_bot": false,
"headline": "nightly is now 8.0, which wont work (dependencies broken)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T00:45:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8bfd265f24d29b898353f75c218be24d5436bb29",
"body": "no longer test nightly - composer is not supported",
"is_bot": false,
"headline": "pin version of hhvm we're testing",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T00:33:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a0aed3b89fe0c3a4e4edca6b6489db4f4619b869",
"body": null,
"is_bot": false,
"headline": "this version worked, i swear",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-01-25T21:37:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8fbb5e6fbfa1ca98fdf1f202ac084eddfc9c2d5e",
"body": null,
"is_bot": false,
"headline": "phpunit 6.5 is the last one to work with hhvm",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-01-25T21:27:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dcb614bae8151ed9db79f56cb2cf369b9749f21b",
"body": null,
"is_bot": false,
"headline": "Set `null` to `true` for fields that default to `NULL`",
"author_name": "Michael Hahn",
"author_login": null,
"committed_at": "2018-01-09T21:19:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c5412e7563bd41783e10d31584eef7e653117f4d",
"body": "when lexing, set the source SQL as a prop",
"is_bot": false,
"headline": "document the public API.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:30:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "404c1ecdd3e8b8cbacb54f16a7591ba8acf3c223",
"body": null,
"is_bot": false,
"headline": "split general table tests into their own file",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:08:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a0b565e7ff20847dab18d5e665471eeffd9006e5",
"body": null,
"is_bot": false,
"headline": "some more TODOs",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:04:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f7ae33a0df581771a70db5a5e00bd8df10aa8ba1",
"body": "better field test helper\nimplemented binary flag parser\nadded binary support for CHAR/VARCHAR (new in MySQL 5.7)\ndecode charset and collation entities",
"is_bot": false,
"headline": "tests for BIT, CHAR/VARCHAR/etc fields",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:02:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d5cfb1dfe8e9f4b95f4a115fc0de68919df8a44e",
"body": null,
"is_bot": false,
"headline": "supprot and tests for fractional seconds precision on time types",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T04:48:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e8db894cbff6c7c7d0cc5f5aafbc3dff05c0e906",
"body": null,
"is_bot": false,
"headline": "added tests for float and numeric types",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T04:45:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c86b77ef50d78da3a18cb0d0562282a2dca0cffb",
"body": null,
"is_bot": false,
"headline": "test foreign key with a name",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T04:35:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3e087f05c6afb234fcda2ad6eb3e9507936e6136",
"body": null,
"is_bot": false,
"headline": "better explain what the library is for. history moved down lower",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-15T21:05:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "926d452469606624305f8e0a7bdd16162dd92519",
"body": "avoid some out of band reads",
"is_bot": false,
"headline": "full support for CHECK and FORIEGN KEY index conditions.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-15T20:56:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "482601cde261f6957b8e8bb1cb5da40a20e96a4b",
"body": null,
"is_bot": false,
"headline": "added a test for find_single_table mode",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:54:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "adf87288c6d6ea0d21bae8bb4f6fadfb52fc2dad",
"body": null,
"is_bot": false,
"headline": "started to write tests for field types",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:51:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b510bc3b2fa7ef68dfea0f41c0ed9e0d31b79d05",
"body": "added tests for constraints",
"is_bot": false,
"headline": "actually include constraint information in the index (duh).",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:31:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "103ef2b6856087587c3bf5f5141f1a868a9f5c71",
"body": null,
"is_bot": false,
"headline": "support for multiple index options, with tests",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:21:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "df86dc72b9e99cb33e454a8e081589c3be2e2ea2",
"body": "…of index.\n\nadded support for index comments (mysql 5.7)\nadded tests for all idnex options",
"is_bot": false,
"headline": "fixed index mode parser to not overflow for btree mode as last token …",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:17:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "30501a9d5ca0941f9197b53934c924b4f287921c",
"body": "change index.col.direction to upper case to match everything else",
"is_bot": false,
"headline": "added tests for index columns.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:10:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8cde164fa0813ddfb670e1a6a053b774cabd19da",
"body": null,
"is_bot": false,
"headline": "tests for indexes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T19:57:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2d64c0840481f2c3eef33fe1364f9dd44382f8f5",
"body": "… bar`",
"is_bot": false,
"headline": "tests for `CREATE TABLE IF NOT EXISTS foo` and `CREATE TABLE foo LIKE…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T19:57:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "713011e67b634f442f972451b497a2b7d8a4a0d1",
"body": "return mode in upper case, to match .type",
"is_bot": false,
"headline": "since the returned prop is called mode, call the function that too.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T19:57:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dc2997b9a23c13cb7d72961faec3196f89c88dcc",
"body": null,
"is_bot": false,
"headline": "don't mess with any globals",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:38:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7b23d247fae3e4d8eafd0bd8601fa54b7dbbd249",
"body": null,
"is_bot": false,
"headline": "test some simple table props end-to-end",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:31:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9dde6404b5efebd76bb3c617e821aeea8beb2912",
"body": "renamed temporary table prop to `temporary`",
"is_bot": false,
"headline": "fixed two bounds error cases.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:30:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "924e51c850a5c40836b9baf4fa2a8c6cc40c7b4c",
"body": null,
"is_bot": false,
"headline": "added lexer tests for multiline comments that don't end",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:11:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fa00ac7d0aa71734f0b180a70fa579ff580b2954",
"body": "added composer installation instructions",
"is_bot": false,
"headline": "added travis and coveralls badges",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:09:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "11343214b7fb95d70f0d789db8ff3be1c4477564",
"body": null,
"is_bot": false,
"headline": "more lexer tests",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:54:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2595b267396abff0a842db0da36b38a1842ce106",
"body": null,
"is_bot": false,
"headline": "towards coverage logs",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:34:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "03cabc08dd07a394562d4e6152927b138ca2558e",
"body": null,
"is_bot": false,
"headline": "get travis running the phpunit tests",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:20:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f7f2e2fdc151fdec7bc91d6ee10d3bd31aae1aa3",
"body": null,
"is_bot": false,
"headline": "moved the example files over to the new layout/naming",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:01:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2fc077ef4613a1fe5f90926c7bbe87b8bb0e4c07",
"body": null,
"is_bot": false,
"headline": "moving to phpunit",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:59:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b37968357e8bb6dde09b3c1c670a04a3e3b756e4",
"body": null,
"is_bot": false,
"headline": "what an adventure",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:36:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5510c4e2fe4b31e7bdc7728c612c478d66cfba65",
"body": null,
"is_bot": false,
"headline": "composer documentation and tooling is *really* bad",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:35:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "341410239e24f75b4d045b08f237134cfad8223d",
"body": null,
"is_bot": false,
"headline": "packagist package names have to be lowercase",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:34:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "872e481fc0b1f842b70639eb4758558af6970adb",
"body": null,
"is_bot": false,
"headline": "updated tests for path and namespace changes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:33:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a924287adefd4862370f9488b6327e2cca8938ea",
"body": "moved src into a subdir in the composer style",
"is_bot": false,
"headline": "added composer json",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:33:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "be254456c8faa5f5f7fadac2fe922fc16c187686",
"body": "still needs some more work",
"is_bot": false,
"headline": "replace some/most of the array shifting with a cursor instead.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-09T20:49:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "841e09a6c4694a6666a46d8e19abc8bf148b5224",
"body": "fixed a typo in function call name",
"is_bot": false,
"headline": "added some more checks to avoid php warnings.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-09T20:49:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c2a258a8d2657e69977124d5810de2a66b7e4b79",
"body": null,
"is_bot": false,
"headline": "silence all php warnings/notices",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-09T20:49:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9084e471a12478ff9c637beb3bf3cb9b24f2a141",
"body": null,
"is_bot": false,
"headline": "Create LICENSE",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-06-09T20:48:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0902af528efe28245c9278a120fac2f9d99d0f32",
"body": "In order to have the original CREATE TABLE text from the schema\navailable when using the parsed structure, rework the lexer so that\ninstead of extracting the substring tokens, it extracts tuples of\n[position, length] and maintains these associations when collapsing\nthe token sequences.\n\nThis means we can include the original source text in a `sql` field\nof the resulting parsed structure.",
"is_bot": false,
"headline": "rework the lexer to keep track of source locations for each token",
"author_name": "Michael Demmer",
"author_login": "demmer",
"committed_at": "2017-02-16T22:01:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b944a2a63f86e2f3ee26f0b929454885e4dc5247",
"body": null,
"is_bot": false,
"headline": "support LONGBLOB types",
"author_name": "Michael Demmer",
"author_login": "demmer",
"committed_at": "2017-02-14T04:45:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ad246f58ad2a4f3be5e9defdcbee85c0fa25a2ef",
"body": null,
"is_bot": false,
"headline": "simple test file while i add capabilities",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T18:14:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f61aa253adf37b9743b4856abcf4708dfadcebd2",
"body": null,
"is_bot": false,
"headline": "support for value lists in enum & set field defs",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:29:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "76a23accffa4c334759603411f1112e4cd48c543",
"body": null,
"is_bot": false,
"headline": "auto_increment support",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:23:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7a9f01a2d52df18120275c00be609730087cb26b",
"body": null,
"is_bot": false,
"headline": "decode identifiers for column names in indexes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:21:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "795e5c421ae06da799517a0c49478f7cbd4207ea",
"body": "decode them too",
"is_bot": false,
"headline": "actually return index names instead of discarding them.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:20:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "04117a09d5db179e23e723b07609d520bf1e8926",
"body": "added decoding for values.\nrefactored decoding for identifiers.",
"is_bot": false,
"headline": "added support for default field values.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:17:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a93a2203fa9cdcce00c9a7bc168759f11440c81b",
"body": null,
"is_bot": false,
"headline": "handle single and double quoted strings",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:06:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d2cee4caddfd01122f61d26622990254510fac1f",
"body": null,
"is_bot": false,
"headline": "correctly parse index columns, taking into account length and asc/desc",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T05:03:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2cf04353680e1f5d6a3b3b3840d3e6e269f3c6c9",
"body": null,
"is_bot": false,
"headline": "support for index options",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:53:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f4c91622bdb4556b52d8abe3bb74d6e7c601cd8c",
"body": null,
"is_bot": false,
"headline": "when an index is USING HASH, it means the index type is ... hash. duh",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:51:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "13c51b9a300bd998a75e7111d3c4db653fe57100",
"body": null,
"is_bot": false,
"headline": "only add the 'more' array is there are extra, unparsed tokens",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:39:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ca6cf8a4fda37f8e762eb37a57571c0fa95c7f9e",
"body": null,
"is_bot": false,
"headline": "parse character set and collations",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:36:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1da164c1c056ce3ec8c9ac06f7b6fd505fc8a412",
"body": "support for unsigned and zerofill field props.\nsupport for null/not-null field props.",
"is_bot": false,
"headline": "support for fields lengths.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-13T02:45:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e67dee42779d46e3c5359aaea0c2aa308288a90c",
"body": null,
"is_bot": false,
"headline": "recognize the <unsigned numeric literal> token when lexing",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-13T02:45:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f5dbb8fbea72821ca9e14d683671876e07f7d4af",
"body": null,
"is_bot": false,
"headline": "renamed test files to .php to avoid confusion",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:47:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b32f1387cf88adcad2bef45b6bf772f3ecf65bec",
"body": null,
"is_bot": false,
"headline": "updated the readme to reflect what the library's purpose is now",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:45:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dc27f3a9eecc4a822a7bea52760ac7f019aa6dab",
"body": null,
"is_bot": false,
"headline": "the old glitch schema, for testing",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:39:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d58439c8699a00fe88d007eb1601d49acff8ad99",
"body": null,
"is_bot": false,
"headline": "point the tests to the new file & classname",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:38:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bf7aede91ed4757caa2207bcf963ccd37b423a95",
"body": null,
"is_bot": false,
"headline": "renamed main file and the class inside it",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:36:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e4bd20b03349a3dd38f2a32b19891e9ca056d71f",
"body": "…rser now",
"is_bot": false,
"headline": "removed the old compare script - this repo is just going to be the pa…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:05:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a32a7af0068c2de0392c33329865ff7be0890369",
"body": "stubbed out all of the supported fields types (non complete yet)",
"is_bot": false,
"headline": "changed field parsing to use a switch.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-14T18:08:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8efc1bb7c883081a833c1d8819b11a52412610b0",
"body": null,
"is_bot": false,
"headline": "the first end-to-end test",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-14T17:50:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6132eec6b8e0d46b6cce895db496ab453ecc588e",
"body": "…() method caqn be fully tested.",
"is_bot": false,
"headline": "added a global option for debugging a single table, so that the parse…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-14T17:49:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "efc92572519fca4cf0cef846e78ab2ba26091bab",
"body": "avoids having to use StrToUpper in the field parser.",
"is_bot": false,
"headline": "some more single-token keywords that need uppercasing.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-12T20:35:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fb1460b076b9296ea91251071846f9e55e49d23c",
"body": "added support for FULLTEXT and SPATIAL indexes.",
"is_bot": false,
"headline": "switch the index parser to use a switch().",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-12T20:33:40Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 2,
"commits_last_year": 6,
"latest_release_at": "2026-01-28T22:23:25Z",
"latest_release_tag": "v0.7",
"releases_from_tags": false,
"days_since_last_push": 174,
"active_weeks_last_year": 1,
"days_since_latest_release": 174,
"mean_days_between_releases": 3062.7
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": false,
"health_percentage": 42,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": [
{
"name": "iamcal/sql-parser",
"exists": true,
"license": "MIT",
"keywords": [],
"ecosystem": "packagist",
"matches_repo": true,
"registry_url": "https://packagist.org/packages/iamcal/sql-parser",
"is_deprecated": false,
"latest_version": "v0.7",
"repository_url": "https://github.com/iamcal/SQLParser",
"versions_count": 7,
"total_downloads": 38486535,
"dependents_count": 10,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": 4742890,
"first_published_at": null,
"latest_published_at": "2026-01-28T22:20:33Z",
"latest_version_yanked": null,
"days_since_latest_publish": 174
}
]
},
"popularity": {
"forks": 20,
"stars": 77,
"watchers": 3,
"fork_history": {
"days": [
{
"date": "2017-02-14",
"count": 1
},
{
"date": "2018-01-08",
"count": 1
},
{
"date": "2018-08-29",
"count": 1
},
{
"date": "2018-11-29",
"count": 1
},
{
"date": "2019-02-06",
"count": 1
},
{
"date": "2019-06-10",
"count": 1
},
{
"date": "2019-06-20",
"count": 1
},
{
"date": "2019-08-13",
"count": 1
},
{
"date": "2019-08-16",
"count": 1
},
{
"date": "2019-09-22",
"count": 1
},
{
"date": "2020-04-30",
"count": 1
},
{
"date": "2020-12-16",
"count": 1
},
{
"date": "2021-09-21",
"count": 1
},
{
"date": "2021-10-14",
"count": 1
},
{
"date": "2022-03-03",
"count": 1
},
{
"date": "2022-04-24",
"count": 1
},
{
"date": "2022-05-25",
"count": 1
},
{
"date": "2024-01-12",
"count": 1
},
{
"date": "2024-12-13",
"count": 1
},
{
"date": "2026-01-24",
"count": 1
}
],
"complete": true,
"collected": 20,
"total_forks": 20
},
"star_history": null,
"open_issues_and_prs": 1
},
"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": [],
"largest_source_bytes": 27313,
"source_files_sampled": 12,
"oversized_source_files": 0,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"dependencies": {
"manifests": [
"composer.json"
],
"advisories": {
"error": "No resolved dependencies carried a version and a supported ecosystem",
"scope": "repository_graph",
"source": null,
"findings": [],
"collected": false,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 0,
"malicious_count": 0,
"assessed_package": null,
"unassessed_count": 2,
"direct_affected_count": 0
},
"ecosystems": [
"packagist"
],
"dependencies": [],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "php-coveralls/php-coveralls",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "phpunit/phpunit",
"direct": false,
"version": null,
"ecosystem": "packagist"
}
],
"collected": true,
"truncated": false,
"total_count": 2,
"direct_count": 0,
"indirect_count": 2
}
},
"maintainership": {
"issues": {
"open_prs": 1,
"merged_prs": 21,
"open_issues": 0,
"closed_ratio": 1,
"closed_issues": 8,
"closed_unmerged_prs": 2
},
"bus_factor": 1,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "iamcal",
"commits": 109,
"avatar_url": "https://avatars.githubusercontent.com/u/173750?v=4"
},
{
"type": "User",
"login": "ngmy",
"commits": 6,
"avatar_url": "https://avatars.githubusercontent.com/u/864041?v=4"
},
{
"type": "User",
"login": "rodber",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/20590102?v=4"
},
{
"type": "User",
"login": "demmer",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/3308504?v=4"
},
{
"type": "User",
"login": "DirtyRacer1337",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/17379553?v=4"
},
{
"type": "User",
"login": "owenvoke",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/1899334?v=4"
},
{
"type": "User",
"login": "WilliamFalci",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/36926081?v=4"
},
{
"type": "User",
"login": "richardudovich",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/828730?v=4"
}
],
"contributors_sampled": 8,
"top_contributor_share": 0.872
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"php.yml"
],
"has_docs_dir": false,
"linter_configs": [],
"has_editorconfig": false,
"has_linter_config": false,
"has_precommit_config": false
},
"security_signals": {
"lockfiles": [],
"scorecard": {
"checks": [
{
"name": "Binary-Artifacts",
"score": 10,
"reason": "no binaries found in the repo",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
},
{
"name": "Branch-Protection",
"score": 0,
"reason": "branch protection not enabled on development/release branches",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 0,
"reason": "1 out of 16 merged PRs checked by a CI test -- score normalized to 0",
"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": 3,
"reason": "Found 8/22 approved changesets -- score normalized to 3",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 6,
"reason": "project has 2 contributing companies or organizations -- score normalized to 6",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": null,
"reason": "no workflows found",
"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": 0,
"reason": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
"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": null,
"reason": "no dependencies found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
},
{
"name": "SAST",
"score": 0,
"reason": "SAST tool is not run on all commits -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
},
{
"name": "Security-Policy",
"score": 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": null,
"reason": "No tokens found",
"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": "610392f38de49a44dab08dc1659960a29874c4b8",
"ran_at": "2026-07-22T17:43:47Z",
"aggregate_score": 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-04-19T06:21:28Z",
"oldest_open_prs": [
{
"number": 5,
"created_at": "2017-09-10T05:34:31Z",
"last_comment_at": "2017-09-10T05:39:04Z",
"last_comment_author": "coveralls"
}
],
"last_merged_pr_at": "2026-01-28T22:20:33Z",
"ci_last_conclusion": "FAILURE",
"oldest_open_issues": []
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/iamcal/SQLParser",
"host": "github.com",
"name": "SQLParser",
"owner": "iamcal"
},
"metrics": {
"overall": {
"key": "overall",
"band": "moderate",
"name": "Overall health",
"note": null,
"notes": [],
"value": 50,
"inputs": {
"security": 30,
"vitality": 37,
"community": 56,
"governance": 68,
"engineering": 53
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "at_risk",
"name": "Vitality",
"value": 37,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "critical",
"name": "Development activity",
"note": null,
"notes": [],
"value": 18,
"inputs": {
"commits_last_year": 6,
"human_commit_share": 1,
"days_since_last_push": 174,
"active_weeks_last_year": 1
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 174 days ago",
"points": 9.9,
"status": "partial",
"details": [
{
"code": "push_recency",
"params": {
"days": 174
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "1/52 weeks with commits",
"points": 0.7,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 1
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "6 commits in the last year",
"points": 7.6,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 6
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "moderate",
"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": 66,
"inputs": {
"releases_count": 2,
"latest_release_tag": "v0.7",
"releases_from_tags": false,
"days_since_latest_release": 174,
"mean_days_between_releases": 3062.7
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "2 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 2
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 174 days ago",
"points": 27,
"status": "partial",
"details": [
{
"code": "release_recency",
"params": {
"days": 174
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~3062.7 days",
"points": 5.4,
"status": "partial",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 3062.7
}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "abandonment",
"band": "excellent",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"cap": null,
"state": "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": 174,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 174 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 174
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "moderate",
"name": "Community & Adoption",
"value": 56,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "at_risk",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 43,
"inputs": {
"forks": 20,
"stars": 77,
"watchers": 3,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "77 stars",
"points": 30.5,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 77
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "20 forks",
"points": 10.7,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 20
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "3 watchers",
"points": 1.7,
"status": "partial",
"details": [
{
"code": "watchers",
"params": {
"count": 3
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "moderate",
"name": "Community health",
"note": null,
"notes": [],
"value": 50,
"inputs": {
"has_readme": true,
"has_license": true,
"has_contributing": false,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 22.5,
"status": "met",
"details": [],
"max_points": 22.5
},
{
"key": "license",
"name": "License",
"detail": "recognized license (MIT)",
"points": 22.5,
"status": "met",
"details": [
{
"code": "license_standard",
"params": {}
},
{
"code": "license_spdx",
"params": {
"spdx": "MIT"
}
}
],
"max_points": 22.5
},
{
"key": "contributing_guide",
"name": "CONTRIBUTING guide",
"detail": null,
"points": 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
}
]
},
{
"key": "ecosystem_adoption",
"band": "excellent",
"name": "Ecosystem adoption (downloads)",
"note": null,
"notes": [],
"value": 87,
"inputs": {
"packages": [
"iamcal/sql-parser"
],
"dependents": 10,
"ecosystems": "packagist",
"total_downloads": 38486535,
"monthly_downloads": 4742890
},
"components": [
{
"key": "monthly_downloads",
"name": "Monthly downloads",
"detail": "4,742,890 downloads/month across packagist",
"points": 80,
"status": "met",
"details": [
{
"code": "downloads_monthly",
"params": {
"count": 4742890,
"ecosystems": "packagist"
}
}
],
"max_points": 80
},
{
"key": "registry_dependents",
"name": "Registry dependents",
"detail": "10 packages depend on it",
"points": 6.9,
"status": "partial",
"details": [
{
"code": "registry_dependents",
"params": {
"count": 10
}
}
],
"max_points": 20
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "moderate",
"name": "Sustainability & Governance",
"value": 68,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "critical",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 29,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 8,
"top_contributor_share": 0.872
},
"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 87% of commits",
"points": 2.9,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 87
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "8 contributors",
"points": 10.8,
"status": "partial",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 8
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 2 contributing companies or organizations -- score normalized to 6",
"points": 6,
"status": "partial",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "excellent",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 86,
"inputs": {
"merged_prs": 21,
"open_issues": 0,
"closed_issues": 8,
"issue_closed_ratio": 1,
"closed_unmerged_prs": 2
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "100% of issues closed",
"points": 46.8,
"status": "met",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 100
}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "21/23 decided PRs merged",
"points": 34.9,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 21,
"decided": 23
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 8/22 approved changesets -- score normalized to 3",
"points": 4.5,
"status": "partial",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "good",
"name": "Ownership & stewardship",
"note": "Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"verified_domain"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 71,
"inputs": {
"followers": 1025,
"owner_type": "User",
"is_verified": null,
"owner_login": "iamcal",
"public_repos": 193,
"account_age_days": 6048
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "personal (user) account",
"points": 10,
"status": "partial",
"details": [
{
"code": "owner_personal",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": "not applicable to user accounts",
"points": 0,
"status": "excluded",
"details": [
{
"code": "not_applicable_to_user_accounts",
"params": {}
}
],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "1,025 followers of iamcal",
"points": 21.6,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 1025,
"login": "iamcal"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "193 public repos, account ~16 yr old",
"points": 25,
"status": "met",
"details": [
{
"code": "public_repos",
"params": {
"count": 193
}
},
{
"code": "account_age_years",
"params": {
"years": 16
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "excellent",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"iamcal/sql-parser"
],
"ecosystems": "packagist",
"any_deprecated": false,
"min_days_since_publish": 174
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "1 package(s) on packagist",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 1,
"ecosystems": "packagist"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 174 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 174
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "7 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 7
}
}
],
"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": "moderate",
"name": "Engineering Quality",
"value": 53,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "at_risk",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 48,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": false,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "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": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 9.6
},
{
"key": "editorconfig",
"name": ".editorconfig",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "1 out of 16 merged PRs checked by a CI test -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "moderate",
"name": "Documentation",
"note": null,
"notes": [],
"value": 60,
"inputs": {
"topics": [
"php",
"sql-parser",
"lex",
"composer",
"database",
"autoloader"
],
"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": "6 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 6
}
}
],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "at_risk",
"name": "Security",
"value": 30,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "at_risk",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Dangerous-Workflow, Packaging, Pinned-Dependencies, Signed-Releases, Token-Permissions. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"dangerous_workflow",
"packaging",
"pinned_dependencies",
"signed_releases",
"token_permissions"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 30,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 13,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 5,
"scorecard_aggregate": 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": "branch protection not enabled on development/release branches",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "1 out of 16 merged PRs checked by a CI test -- score normalized to 0",
"points": 0,
"status": "missed",
"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 8/22 approved changesets -- score normalized to 3",
"points": 2.2,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 2 contributing companies or organizations -- score normalized to 6",
"points": 1.5,
"status": "partial",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no workflows found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"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": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
"points": 0,
"status": "missed",
"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": "no dependencies found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is not run on all commits -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "security_policy",
"name": "Security-Policy",
"detail": "security policy file 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": "No tokens found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "0 existing vulnerabilities detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "excellent",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"review_only_matches": 0,
"assessed_self_published_locations": 9
},
"components": [
{
"key": "policy_exposure_multiplier",
"name": "Policy exposure multiplier",
"detail": "no confirmed policy-scope location match",
"points": 100,
"status": "met",
"details": [
{
"code": "jurisdiction_no_match",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "at_risk",
"name": "AI Readiness",
"value": 33,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "critical",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 6,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.12,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "no CLAUDE.md / AGENTS.md / editor rules",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_instructions",
"params": {}
}
],
"max_points": 45
},
{
"key": "machine_readable_docs_llms_txt",
"name": "Machine-readable docs (llms.txt)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "legible_commit_history",
"name": "Legible commit history",
"detail": "12 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 6.4,
"status": "partial",
"details": [
{
"code": "legible_history",
"params": {
"legible": 12,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "at_risk",
"name": "Verify loop (build / test / typecheck)",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Pinned-Dependencies. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_pinned_dependencies"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 44,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": false,
"typed_language": false,
"bootstrap_files": [
"Makefile"
],
"has_devcontainer": false,
"has_linter_config": false,
"typecheck_configs": [],
"agent_commit_share": 0,
"toolchain_manifests": [],
"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": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "no agent-authored commits among the last 100",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_authored_commits",
"params": {
"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": "no dependencies found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "moderate",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 55,
"inputs": {
"primary_language": "PHP",
"largest_source_bytes": 27313,
"source_files_sampled": 12,
"oversized_source_files": 0
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "PHP without a type-check config",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_typecheck_config_language",
"params": {
"language": "PHP"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "0/12 source files over 60KB",
"points": 55,
"status": "met",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 12,
"oversized": 0
}
}
],
"max_points": 55
}
]
}
],
"description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
}
],
"metrics_version": "1.13.0"
},
"warnings": [
"Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
"No resolved dependencies carried a version and a supported ecosystem"
],
"report_type": "repository",
"generated_at": "2026-07-22T17:44:03.883045Z",
"schema_version": "0.26.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/i/iamcal/SQLParser.svg",
"full_name": "iamcal/SQLParser",
"license_state": "standard",
"license_spdx": "MIT"
}