公开记录存在风险
软件健康报告模式 0.26.0 · 指标 1.13.0 · 2026-07-22 10:32 UTC
suprbdev / pgy
Forward-only PostgreSQL migration tool. It reads YAML schema files, diffs against a live DB, writes SQL to a buffer, and commits/applies migrations. No rollbacks.
suprbdev/pgy 的健康指数为 100 分中的 45 分，处于「存在风险」区间。 其得分最高的类别是Vitality（71/100），最低的是Community & Adoption（24/100）。 最近一次更新在 4 天前。 近期的大部分工作由 1 位贡献者完成。
45
总分 / 100软件健康指数
指标归入加权类别，统一采用 1–100 量表。总体分先取类别加权平均；当公开证据触发高风险司法辖区政策时，评级会按政策调整，并设置 49（有风险）的上限。AI 就绪度不计入总体分。
45
优秀85-100堪称典范；基本满足所有检验标准
良好70-84健康；仅有轻微不足
中等50-69可接受，但存在明显不足；建议进行审查
存在风险30-49存在重大薄弱环节；采用时应保持审慎
危急1-29问题严重（项目被弃置、仅有单一维护者、缺乏基本工程规范）
评分画像
每条轴代表一个类别。形状比平均值更重要——健康的对象会填满整个图形，而“一峰一谷”式画像意味着某一维度的优势正掩盖另一维度的风险。
所有权
软件包生态系统
| 注册表 | 软件包 | 版本 | 月下载量 | 版本数 | 最近发布 |
|---|---|---|---|---|---|
| Go | github.com/suprbdev/pgy | v0.1.0 | - | 1 | 4 天前 |
按类别列示的指标
活力
项目是否仍有生命——是否仍在编写代码，是否仍在发布版本？
71
开发活跃度
67中等
评分方式
| 36/36 | 推送新近度 — 最近一次推送于 4 天前 |
| 5.5/36 | 提交节奏 — 52 周中有 8 周有提交 |
| 15.1/18 | 提交量 — 最近一年 47 次提交 |
| 10/10 | OpenSSF Scorecard：Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10 |
所用输入
| commits_last_year | 47 |
| human_commit_share | 1 |
| days_since_last_push | 4 |
| active_weeks_last_year | 8 |
发布纪律
76良好
评分方式
| 27/27 | 有发布版本 — 已发布 1 个发布版本 |
| 36/36 | 发布时效 — 最近一次发布版本于 4 天前 |
| 12.6/27 | 发布节奏 — 节奏未知（仅一次发布） |
| 0/10 | OpenSSF Scorecard：Signed-Releases — Project has not signed or included provenance with any releases. |
所用输入
| releases_count | 1 |
| latest_release_tag | v0.1.0 |
| releases_from_tags | 否 |
| days_since_latest_release | 4 |
| mean_days_between_releases | — |
社区与采用
项目是否拥有用户、下载量与关注度，并具备欢迎贡献者参与的配置？
24
流行度与采用
1危急
评分方式
| 0/60 | 星标 — 1 个星标 |
| 0/25 | 复刻 — 0 个复刻 |
| 0/15 | 关注者 — 0 位关注者 |
所用输入
| forks | 0 |
| stars | 1 |
| watchers | 0 |
| 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 | 否 |
可持续性与治理
项目能否在其成员之外延续——巴士系数、响应能力、由谁支持，以及软件包的维护状况？
31
维护者韧性（巴士系数）
13危急
评分方式
| 9/54 | 巴士系数 — 1 位贡献者贡献了半数提交 |
| 0/22.5 | 提交分布 — 头号贡献者编写了 100% 的提交 |
| 1.4/13.5 | 贡献者广度 — 1 位贡献者 |
| 3/10 | OpenSSF Scorecard：Contributors — project has 1 contributing companies or organizations -- score normalized to 3 |
所用输入
| bus_factor | 1 |
| contributors_sampled | 1 |
| top_contributor_share | 1 |
议题与 PR 响应能力
1危急
评分方式
| 0/46.8 | 议题解决 — 没有议题或无数据 |
| 0/38.3 | PR 接受 — 没有已裁定的拉取请求或无数据 |
| 0/15 | OpenSSF Scorecard：Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
所用输入
| merged_prs | 0 |
| open_issues | 0 |
| closed_issues | 0 |
| issue_closed_ratio | — |
| closed_unmerged_prs | 0 |
已排除计分（无数据或不适用）：议题解决, PR 接受。 其余权重已重新归一化。
所有权与托管责任
39存在风险
评分方式
| 30/30 | 所有权背书 — 组织持有 |
| 0/20 | 已验证域名 |
| 0/25 | 所有者影响力 — suprbdev 有 0 位关注者 |
| 9.3/25 | 既往记录 — 7 个公开仓库，账户约 1 年 |
所用输入
| followers | 0 |
| owner_type | Organization |
| is_verified | — |
| owner_login | suprbdev |
| public_repos | 7 |
| account_age_days | 505 |
软件包维护
84良好
评分方式
| 25/25 | 已发布且可解析 — go 上有 1 个软件包 |
| 35/35 | 发布时效 — 最近一次发布于 4 天前 |
| 4/20 | 版本历史 — 1 个已发布版本 |
| 20/20 | 未被弃用 — 活跃，未被弃用或撤回 |
所用输入
| packages | github.com/suprbdev/pgy |
| ecosystems | go |
| any_deprecated | 否 |
| min_days_since_publish | 4 |
工程质量
基础的工程与文档实践是否到位？
66
工程实践
60中等
评分方式
| 24/24 | CI 工作流 — 2 个工作流 |
| 24/24 | 存在测试 |
| 0/16 | Linter 配置 |
| 0/9.6 | Pre-commit 钩子 |
| 0/6.4 | .editorconfig |
| 0/20 | OpenSSF Scorecard：CI-Tests — 无数据 |
所用输入
| has_ci | 是 |
| has_tests | 是 |
| has_editorconfig | 否 |
| has_linter_config | 否 |
| has_precommit_config | 否 |
已排除计分（无数据或不适用）：OpenSSF Scorecard：CI-Tests。 其余权重已重新归一化。
文档
75良好
评分方式
| 30/30 | README |
| 25/25 | 文档目录 |
| 0/15 | 文档 / 主页站点 |
| 10/10 | 仓库描述 |
| 10/10 | 主题标签 — 6 个主题标签 |
| 0/10 | Wiki |
所用输入
| topics | cli, cli-app, database, db, diff, migrations |
| has_wiki | 否 |
| homepage | — |
| has_readme | 是 |
| has_docs_dir | 是 |
| has_description | 是 |
安全
可见的安全与供应链实践是否稳固，且不存在未解决的高风险司法辖区暴露？
29
安全态势
29危急
评分方式
| 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 — 无数据 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 0/7.5 | Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
| 0.8/2.5 | Contributors — project has 1 contributing companies or organizations -- score normalized to 3 |
| 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 — 30 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 |
| 0/5 | SAST — no SAST tool detected |
| 0/5 | Security-Policy — security policy file not detected |
| 0/7.5 | Signed-Releases — Project has not signed or included provenance with any releases. |
| 0/7.5 | Token-Permissions — detected GitHub workflow tokens with excessive permissions |
| 0/7.5 | Vulnerabilities — 23 existing vulnerabilities detected |
所用输入
| source | openssf_scorecard |
| checks_evaluated | 16 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 2 |
| scorecard_aggregate | 2.9 |
已排除计分（无数据或不适用）：ci_tests, packaging。 其余权重已重新归一化。
AI 就绪度
该仓库在多大程度上具备与 AI 编码代理协同开发与维护的条件？这是一枚独立的实验性徽章——权重为 0.0，因此单独呈现，不影响总体健康评分。
45
AI 代理上下文与指引
1危急
评分方式
| 0/45 | 代理指令 — 没有 CLAUDE.md / AGENTS.md / 编辑器规则 |
| 0/15 | 机器可读文档（llms.txt） |
| 0/40 | 可读的提交历史 — 47 次人类提交中有 0 次说明了意图（结构化标题或解释性正文） |
所用输入
| has_llms_txt | 否 |
| legible_history_share | 0 |
| agent_instruction_files | — |
| agent_instruction_max_bytes | — |
评分方式
| 18/18 | 一条命令的引导启动 — Makefile |
| 22/22 | 自动化测试 |
| 0/11 | Lint / 格式化配置 |
| 11/11 | 静态类型检查 — Go（静态类型） |
| 10/10 | 可复现环境 — Dockerfile, lockfile |
| 0/10 | 已体现的代理实践 — 最近 47 次提交中没有代理编写的提交 |
| 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 |
| toolchain_manifests | go.mod |
| dependency_bot_commit_share | 0 |
面向模型的代码可读性
95优秀
评分方式
| 45/45 | 可类型检查的代码 — Go（静态类型） |
| 49.8/55 | 可控的文件大小 — 采样的 21 个源文件中有 2 个超过 60KB |
所用输入
| primary_language | Go |
| largest_source_bytes | 113,851 |
| source_files_sampled | 21 |
| oversized_source_files | 2 |
机器可读接口
40存在风险
评分方式
| 0/40 | API 模式（OpenAPI/GraphQL/proto） |
| 0/20 | MCP 服务器 |
| 40/40 | 可运行示例 — examples |
所用输入
| example_dirs | examples |
| has_mcp_signal | 否 |
| api_schema_files | — |
关键数据
1GitHub 星标
1贡献者
47最近 12 个月提交数
4距最近推送天数
1发布版本数
1巴士系数（bus factor）
0开放议题
Go软件包生态系统数
数据采集警告
- Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
- GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository
更多细节
OpenSSF Scorecard 2.9 / 10
2.9综合
来自开源项目 OpenSSF Scorecard 的独立、工具无关的安全评估。每项检查奖励的是安全实践本身，而非特定供应商的工具。Scorecard 无法判定的检查项标记为 不适用，并从安全评分中剔除（绝不按零分计）。
| 10 | Binary-Artifacts | no binaries found in the repo |
| 0 | Branch-Protection | branch protection not enabled on development/release branches |
| 不适用 | CI-Tests | no pull request found |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 0 | Code-Review | Found 0/30 approved changesets -- score normalized to 0 |
| 3 | Contributors | project has 1 contributing companies or organizations -- score normalized to 3 |
| 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 | 30 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 |
| 0 | SAST | no SAST tool detected |
| 0 | Security-Policy | security policy file not detected |
| 0 | Signed-Releases | Project has not signed or included provenance with any releases. |
| 0 | Token-Permissions | detected GitHub workflow tokens with excessive permissions |
| 0 | Vulnerabilities | 23 existing vulnerabilities detected |
直接依赖 3
| 注册表 | 软件包 | 版本约束 | 清单文件 |
|---|---|---|---|
| Go | github.com/jackc/pgx/v5 | v5.5.5 | go.mod |
| Go | github.com/spf13/cobra | v1.8.1 | go.mod |
| Go | gopkg.in/yaml.v3 | v3.0.1 | go.mod |
全部依赖 未采集
本报告未能采集到解析后的依赖集合：GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository
原始 JSON 报告 机器可读
{
"data": {
"repo": {
"topics": [
"cli",
"cli-app",
"database",
"db",
"diff",
"migrations"
],
"is_fork": false,
"size_kb": 274,
"has_wiki": false,
"homepage": null,
"languages": {
"Go": 407137,
"Makefile": 2451
},
"pushed_at": "2026-07-17T19:01:07Z",
"created_at": "2025-10-30T22:19:48Z",
"owner_type": "Organization",
"updated_at": "2026-07-17T19:01:21Z",
"description": "Forward-only PostgreSQL migration tool. It reads YAML schema files, diffs against a live DB, writes SQL to a buffer, and commits/applies migrations. No rollbacks.",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "main",
"license_spdx_raw": "MIT",
"primary_language": "Go",
"significant_languages": [
"Go"
]
},
"owner": {
"blog": "suprb.dev",
"name": "suprb",
"type": "Organization",
"login": "suprbdev",
"company": null,
"location": "United Kingdom",
"followers": 0,
"avatar_url": "https://avatars.githubusercontent.com/u/201692576?v=4",
"created_at": "2025-03-04T04:48:45Z",
"is_verified": null,
"public_repos": 7,
"account_age_days": 505
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v0.1.0",
"kind": "minor",
"published_at": "2026-07-17T18:56:13Z"
}
],
"recent_commits": [
{
"oid": "b8e9e36a61d36f8feb2d590e267d2978400a55f4",
"body": null,
"is_bot": false,
"headline": "Adds badges and updates install instructions.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-17T19:01:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e3576f6ac07c870def0ff948cd356a2967f65c84",
"body": null,
"is_bot": false,
"headline": "Adds build, release and gh workflow.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-17T18:54:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e7284a2ef454c3185b9a2ff69e51db64b8af88fe",
"body": null,
"is_bot": false,
"headline": "Fixes nondeterministic buffer order and dep ordering failures.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T15:16:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "127efd6229d5041ef06701df8a41fd321a9234c4",
"body": null,
"is_bot": false,
"headline": "Adds create role guards.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T09:54:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9f0d6936272c1fd0d4c22693d8e16e54638e0ae5",
"body": null,
"is_bot": false,
"headline": "Triggers diff by definition.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T09:49:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b6ede26cff36588cf6b9f2a284cbe95156e92bd6",
"body": null,
"is_bot": false,
"headline": "Adds view grants.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T09:38:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "07b40da926542b2a2ebeb3d5f1b9cd1fb6e00955",
"body": null,
"is_bot": false,
"headline": "Fix trigger order/deps and adds when guard.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T09:20:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9771dd99b0fca31aa47da12a0a22d5b84d633d42",
"body": null,
"is_bot": false,
"headline": "Implements column-level grants.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T09:04:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "beba34f5979051ecd103e8852ff1ee93a4cf048f",
"body": null,
"is_bot": false,
"headline": "Adds gist + partial index support.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T08:59:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fb703a874d8a7ea90ef3786d90234f5ec7add116",
"body": null,
"is_bot": false,
"headline": "Typecast for postgis fix.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T08:51:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9bbc48e7a6dc8eac78972bd38480f9d6e1322d80",
"body": null,
"is_bot": false,
"headline": "Better conf merge and expansive examples.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T05:29:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d714a0c6e9eec6dd798ee3eb819307ba9319da52",
"body": null,
"is_bot": false,
"headline": "Implements constraint alterations.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T04:08:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f95a097ad5199ec1c68f92023b2f47f6c1530fd3",
"body": null,
"is_bot": false,
"headline": "Implements column alterations.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T04:01:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3edce88ec89110b40a1f0418f62089f8bdca064e",
"body": null,
"is_bot": false,
"headline": "Implements table partitions.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T03:46:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8b4f56ed13042553bb61c6650fe13db88a502f82",
"body": null,
"is_bot": false,
"headline": "Implements prodedures.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T03:36:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f347d02ab7037ea45933c30a294c42e6957480f0",
"body": null,
"is_bot": false,
"headline": "Implements domains.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T03:30:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6622593fc4973896b1484a233da413b2023c52b9",
"body": null,
"is_bot": false,
"headline": "Updates feature list with implementation suggestions.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T03:21:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e3e9cbba80c7a1ff58b801905284372773832c02",
"body": null,
"is_bot": false,
"headline": "Implements identity columns.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T03:08:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "62d5af67972cb5c8ded9cb71068968fdf1f7a010",
"body": null,
"is_bot": false,
"headline": "Implements sequence support.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T02:24:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5da45fae3cac499f8fc20ef6a2a1370d8e29c137",
"body": null,
"is_bot": false,
"headline": "Roles & users implemented.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-11T01:26:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c6da3877e5a51b085d636061959f3ebff0fc837a",
"body": null,
"is_bot": false,
"headline": "Update exit codes: 0 success, 1 error, 2 pending.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T01:56:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "97a5a326db4160476c4d491a64f6fe0a32c9d81a",
"body": null,
"is_bot": false,
"headline": "Preserve composite type attribute order.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T01:47:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "04651c24e24ae3eca0bb5f34a932ec77c265eced",
"body": null,
"is_bot": false,
"headline": "Fix comment splitting on semi-colon.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T01:40:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9910633c4a82d2e3beff4e1f23b30400ca723c1d",
"body": null,
"is_bot": false,
"headline": "Fix policy and rls ordering.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T01:09:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "84e84f3f4899cb168d8c9e6e6e8708c4ee182a1c",
"body": null,
"is_bot": false,
"headline": "Adds contstraint triggers.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T00:45:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cbcd1ac3c00a867dc818a9425f4535efd3b25cfd",
"body": null,
"is_bot": false,
"headline": "Adds replace-on-change functionality.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T00:42:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fef4361285430b16528c9609a7e013aebc75b90e",
"body": null,
"is_bot": false,
"headline": "Comments on all objects.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T00:36:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "487f88d6de2748f6c9cd7cb38a61d590f04a5f08",
"body": null,
"is_bot": false,
"headline": "RLS support.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T00:31:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6d584f0d7e2424082eb8dbf63e524a95235c5782",
"body": null,
"is_bot": false,
"headline": "Grants on tables, functions and schemas.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T00:27:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0fad770afd2d9b911a748dbcfee110fc5c6d013f",
"body": null,
"is_bot": false,
"headline": "YAML default values coercion.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T00:11:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f726384eb809dfdbfb2946528e99f232cc66b611",
"body": null,
"is_bot": false,
"headline": "All FK alters now deferred until after every table's PK/unique alters.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T00:08:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "687d8325b5a1b803745cd034377d2a162f61b411",
"body": null,
"is_bot": false,
"headline": "Triggers now idempotent like other objects.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-07-07T00:04:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0792d34ef8e7081f3ebae83dbb0afc486a36be4d",
"body": null,
"is_bot": false,
"headline": "Adds exit code descriptions in help command.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-23T16:46:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f804e78e258ad8ff2a6cdc5d9fe70fbbca949523",
"body": null,
"is_bot": false,
"headline": "Adds extensive tests and integration tests for all features.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-22T09:55:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a43baee25db8e40595f8c4af7bda25c1597977d9",
"body": "…aints. Idempotency for primary keys.",
"is_bot": false,
"headline": "Adds integration test. Fixes changes on existing tables. Fixes constr…",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-22T09:12:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8aa97f7aee263b6762b621f07ce8aee247a3130a",
"body": null,
"is_bot": false,
"headline": "Add MIT License to the project",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-14T05:06:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fd3a7f55a0f9272e4612dc986daa118970f4e17c",
"body": null,
"is_bot": false,
"headline": "Adds function immutable support.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-13T06:13:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ae22271f01b9269c162375570af64eb416d246a2",
"body": null,
"is_bot": false,
"headline": "Updated docs.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-13T06:08:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7ce948e3d4754834df89252ee690c058406f8e31",
"body": null,
"is_bot": false,
"headline": "Adds view and materialized views.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-13T06:00:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0e0c4d115141a0275c336044ba5076674c7a40b2",
"body": null,
"is_bot": false,
"headline": "Adds unit tests.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-13T05:01:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1d48f03649874c96c481352a943a3667efc8caf1",
"body": null,
"is_bot": false,
"headline": "Adds test rules.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-13T05:01:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b2626e4c7abdb6cf030e23f77a50ebe2d84b1648",
"body": null,
"is_bot": false,
"headline": "Adds feature support doc file.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-13T01:57:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8ea52e8f2980609a100815c74ee9cea4391b2f5a",
"body": null,
"is_bot": false,
"headline": "Adds constraint support.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2026-06-13T01:57:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "22b56095216a00dda73c0483884e132ad6dfcda5",
"body": null,
"is_bot": false,
"headline": "Adds basic schema documentation.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2025-12-08T07:31:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "46e84fe6bd60ca89f32a6333a0f1c38026fd4dcc",
"body": null,
"is_bot": false,
"headline": "Diff improvements and normalization.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2025-11-05T21:16:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f7af74a61a9185c847f10262a9fad7751725d4c7",
"body": null,
"is_bot": false,
"headline": "Diff updates.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2025-11-04T16:36:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4345856c03351804a49b5ca5a1e18c46a6063c89",
"body": null,
"is_bot": false,
"headline": "Initial commit.",
"author_name": "Matt Edmonston",
"author_login": "archlemon",
"committed_at": "2025-10-30T22:20:09Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 1,
"commits_last_year": 47,
"latest_release_at": "2026-07-17T18:56:13Z",
"latest_release_tag": "v0.1.0",
"releases_from_tags": false,
"days_since_last_push": 4,
"active_weeks_last_year": 8,
"days_since_latest_release": 4,
"mean_days_between_releases": null
},
"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/suprbdev/pgy",
"exists": true,
"license": null,
"keywords": [],
"ecosystem": "go",
"matches_repo": true,
"registry_url": "https://pkg.go.dev/github.com/suprbdev/pgy",
"is_deprecated": false,
"latest_version": "v0.1.0",
"repository_url": "https://github.com/suprbdev/pgy",
"versions_count": 1,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": null,
"first_published_at": null,
"latest_published_at": "2026-07-17T18:54:15Z",
"latest_version_yanked": null,
"days_since_latest_publish": 4
}
]
},
"popularity": {
"forks": 0,
"stars": 1,
"watchers": 0,
"fork_history": {
"days": [],
"complete": true,
"collected": 0,
"total_forks": 0
},
"star_history": null,
"open_issues_and_prs": 0
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [
"examples"
],
"has_llms_txt": false,
"has_dockerfile": true,
"has_mcp_signal": false,
"bootstrap_files": [
"Makefile"
],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [
"go.mod"
],
"largest_source_bytes": 113851,
"source_files_sampled": 21,
"oversized_source_files": 2,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"dependencies": {
"manifests": [
"go.mod"
],
"advisories": {
"error": null,
"scope": null,
"source": null,
"findings": [],
"collected": false,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 0,
"malicious_count": 0,
"assessed_package": null,
"unassessed_count": 0,
"direct_affected_count": 0
},
"ecosystems": [
"go"
],
"dependencies": [
{
"name": "github.com/jackc/pgx/v5",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v5.5.5"
},
{
"name": "github.com/spf13/cobra",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v1.8.1"
},
{
"name": "gopkg.in/yaml.v3",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v3.0.1"
}
],
"all_dependencies": {
"error": "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository",
"source": null,
"packages": [],
"collected": false,
"truncated": false,
"total_count": null,
"direct_count": null,
"indirect_count": null
}
},
"maintainership": {
"issues": {
"open_prs": 0,
"merged_prs": 0,
"open_issues": 0,
"closed_ratio": null,
"closed_issues": 0,
"closed_unmerged_prs": 0
},
"bus_factor": 1,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "archlemon",
"commits": 47,
"avatar_url": "https://avatars.githubusercontent.com/u/9592740?v=4"
}
],
"contributors_sampled": 1,
"top_contributor_share": 1
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"ci.yaml",
"release.yaml"
],
"has_docs_dir": true,
"linter_configs": [],
"has_editorconfig": false,
"has_linter_config": false,
"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": 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": null,
"reason": "no pull request found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
},
{
"name": "CII-Best-Practices",
"score": 0,
"reason": "no effort to earn an OpenSSF best practices badge detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
},
{
"name": "Code-Review",
"score": 0,
"reason": "Found 0/30 approved changesets -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 3,
"reason": "project has 1 contributing companies or organizations -- score normalized to 3",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": 10,
"reason": "no dangerous workflow patterns detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 0,
"reason": "no update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 10,
"reason": "30 commit(s) and 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": 0,
"reason": "no SAST tool detected",
"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": 0,
"reason": "Project has not signed or included provenance with any releases.",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
},
{
"name": "Token-Permissions",
"score": 0,
"reason": "detected GitHub workflow tokens with excessive permissions",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
},
{
"name": "Vulnerabilities",
"score": 0,
"reason": "23 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "b8e9e36a61d36f8feb2d590e267d2978400a55f4",
"ran_at": "2026-07-22T10:32:02Z",
"aggregate_score": 2.9,
"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-17T19:01:27Z",
"oldest_open_prs": [],
"last_merged_pr_at": null,
"ci_last_conclusion": "SUCCESS",
"oldest_open_issues": []
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/suprbdev/pgy",
"host": "github.com",
"name": "pgy",
"owner": "suprbdev"
},
"metrics": {
"overall": {
"key": "overall",
"band": "at_risk",
"name": "Overall health",
"note": null,
"notes": [],
"value": 45,
"inputs": {
"security": 29,
"vitality": 71,
"community": 24,
"governance": 31,
"engineering": 66
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "good",
"name": "Vitality",
"value": 71,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "moderate",
"name": "Development activity",
"note": null,
"notes": [],
"value": 67,
"inputs": {
"commits_last_year": 47,
"human_commit_share": 1,
"days_since_last_push": 4,
"active_weeks_last_year": 8
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 4 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "push_recency",
"params": {
"days": 4
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "8/52 weeks with commits",
"points": 5.5,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 8
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "47 commits in the last year",
"points": 15.1,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 47
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "30 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": "good",
"name": "Release discipline",
"note": null,
"notes": [],
"value": 76,
"inputs": {
"releases_count": 1,
"latest_release_tag": "v0.1.0",
"releases_from_tags": false,
"days_since_latest_release": 4,
"mean_days_between_releases": null
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "1 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 1
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 4 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "release_recency",
"params": {
"days": 4
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "cadence unknown (single release)",
"points": 12.6,
"status": "partial",
"details": [
{
"code": "release_cadence_unknown",
"params": {}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "Project has not signed or included provenance with any releases.",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "abandonment",
"band": "excellent",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"cap": null,
"state": "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": 4,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 4 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 4
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "critical",
"name": "Community & Adoption",
"value": 24,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "critical",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 1,
"inputs": {
"forks": 0,
"stars": 1,
"watchers": 0,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "1 stars",
"points": 0,
"status": "missed",
"details": [
{
"code": "stars",
"params": {
"count": 1
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "0 forks",
"points": 0,
"status": "missed",
"details": [
{
"code": "forks",
"params": {
"count": 0
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "0 watchers",
"points": 0,
"status": "missed",
"details": [
{
"code": "watchers",
"params": {
"count": 0
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "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
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "at_risk",
"name": "Sustainability & Governance",
"value": 31,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "critical",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 13,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 1,
"top_contributor_share": 1
},
"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 100% of commits",
"points": 0,
"status": "missed",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 100
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "1 contributors",
"points": 1.4,
"status": "partial",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 1
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 1 contributing companies or organizations -- score normalized to 3",
"points": 3,
"status": "partial",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "critical",
"name": "Issue & PR responsiveness",
"note": "Excluded from scoring (no data or not applicable): Issue resolution, PR acceptance. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"issue_resolution",
"pr_acceptance"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 1,
"inputs": {
"merged_prs": 0,
"open_issues": 0,
"closed_issues": 0,
"issue_closed_ratio": null,
"closed_unmerged_prs": 0
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "no issues or no data",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_issues_or_data",
"params": {}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "no decided pull requests or no data",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_decided_prs_or_data",
"params": {}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 0/30 approved changesets -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "at_risk",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 39,
"inputs": {
"followers": 0,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "suprbdev",
"public_repos": 7,
"account_age_days": 505
},
"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": "0 followers of suprbdev",
"points": 0,
"status": "missed",
"details": [
{
"code": "owner_followers",
"params": {
"count": 0,
"login": "suprbdev"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "7 public repos, account ~1 yr old",
"points": 9.3,
"status": "partial",
"details": [
{
"code": "public_repos",
"params": {
"count": 7
}
},
{
"code": "account_age_years",
"params": {
"years": 1
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "good",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 84,
"inputs": {
"packages": [
"github.com/suprbdev/pgy"
],
"ecosystems": "go",
"any_deprecated": false,
"min_days_since_publish": 4
},
"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 4 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 4
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "1 published versions",
"points": 4,
"status": "partial",
"details": [
{
"code": "published_versions",
"params": {
"count": 1
}
}
],
"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": 66,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "moderate",
"name": "Engineering practices",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: CI-Tests. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_ci_tests"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 60,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": false,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "2 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 2
}
}
],
"max_points": 24
},
{
"key": "tests_present",
"name": "Tests present",
"detail": null,
"points": 24,
"status": "met",
"details": [],
"max_points": 24
},
{
"key": "linter_config",
"name": "Linter config",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 9.6
},
{
"key": "editorconfig",
"name": ".editorconfig",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "no pull request found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "good",
"name": "Documentation",
"note": null,
"notes": [],
"value": 75,
"inputs": {
"topics": [
"cli",
"cli-app",
"database",
"db",
"diff",
"migrations"
],
"has_wiki": false,
"homepage": null,
"has_readme": true,
"has_docs_dir": true,
"has_description": true
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 30,
"status": "met",
"details": [],
"max_points": 30
},
{
"key": "documentation_directory",
"name": "Documentation directory",
"detail": null,
"points": 25,
"status": "met",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": 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": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "critical",
"name": "Security",
"value": 29,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "critical",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): CI-Tests, Packaging. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"ci_tests",
"packaging"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 29,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 16,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 2,
"scorecard_aggregate": 2.9
},
"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": "no pull request found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 2.5
},
{
"key": "cii_best_practices",
"name": "CII-Best-Practices",
"detail": "no effort to earn an OpenSSF best practices badge detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "code_review",
"name": "Code-Review",
"detail": "Found 0/30 approved changesets -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 1 contributing companies or organizations -- score normalized to 3",
"points": 0.8,
"status": "partial",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no dangerous workflow patterns detected",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "dependency_update_tool",
"name": "Dependency-Update-Tool",
"detail": "no update tool detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "30 commit(s) and 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": "no SAST tool detected",
"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": "Project has not signed or included provenance with any releases.",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "token_permissions",
"name": "Token-Permissions",
"detail": "detected GitHub workflow tokens with excessive permissions",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "23 existing vulnerabilities detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "excellent",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"review_only_matches": 0,
"assessed_self_published_locations": 3
},
"components": [
{
"key": "policy_exposure_multiplier",
"name": "Policy exposure multiplier",
"detail": "no confirmed policy-scope location match",
"points": 100,
"status": "met",
"details": [
{
"code": "jurisdiction_no_match",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "at_risk",
"name": "AI Readiness",
"value": 45,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "critical",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 1,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0,
"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": "0 of 47 human commits state their intent (structured subject or explanatory body)",
"points": 0,
"status": "missed",
"details": [
{
"code": "legible_history",
"params": {
"legible": 0,
"sampled": 47
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "moderate",
"name": "Verify loop (build / test / typecheck)",
"note": null,
"notes": [],
"value": 61,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [
"go.sum"
],
"has_dockerfile": true,
"typed_language": true,
"bootstrap_files": [
"Makefile"
],
"has_devcontainer": false,
"has_linter_config": false,
"typecheck_configs": [],
"agent_commit_share": 0,
"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": null,
"points": 0,
"status": "missed",
"details": [],
"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": "Dockerfile, lockfile",
"points": 10,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Dockerfile, lockfile"
}
}
],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "no agent-authored commits among the last 47",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_authored_commits",
"params": {
"sampled": 47
}
}
],
"max_points": 10
},
{
"key": "automated_maintenance",
"name": "Automated maintenance",
"detail": "no automated dependency updates observed",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_dependency_automation",
"params": {}
}
],
"max_points": 8
},
{
"key": "openssf_scorecard_pinned_dependencies",
"name": "OpenSSF Scorecard: Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "excellent",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 95,
"inputs": {
"primary_language": "Go",
"largest_source_bytes": 113851,
"source_files_sampled": 21,
"oversized_source_files": 2
},
"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": "2/21 source files over 60KB",
"points": 49.8,
"status": "partial",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 21,
"oversized": 2
}
}
],
"max_points": 55
}
]
},
{
"key": "ai_interfaces",
"band": "at_risk",
"name": "Machine-readable interfaces",
"note": null,
"notes": [],
"value": 40,
"inputs": {
"example_dirs": [
"examples"
],
"has_mcp_signal": false,
"api_schema_files": []
},
"components": [
{
"key": "api_schema_openapi_graphql_proto",
"name": "API schema (OpenAPI/GraphQL/proto)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 40
},
{
"key": "mcp_server",
"name": "MCP server",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "runnable_examples",
"name": "Runnable examples",
"detail": "examples",
"points": 40,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "examples"
}
}
],
"max_points": 40
}
]
}
],
"description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
}
],
"metrics_version": "1.13.0"
},
"warnings": [
"Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
"GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository"
],
"report_type": "repository",
"generated_at": "2026-07-22T10:32:06.737616Z",
"schema_version": "0.26.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/s/suprbdev/pgy.svg",
"full_name": "suprbdev/pgy",
"license_state": "standard",
"license_spdx": "MIT"
}