公开记录中等
软件健康报告模式 0.27.0 · 指标 1.13.0 · 2026-07-24 21:15 UTC
pawurb / ruby-pg-extras
Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
pawurb/ruby-pg-extras 的健康指数为 100 分中的 61 分，处于「中等」区间。 其得分最高的类别是Vitality（69/100），最低的是AI Readiness（23/100）。 最近一次更新在今天。 近期的大部分工作由 1 位贡献者完成。
61
总分 / 100软件健康指数
指标归入加权类别，统一采用 1–100 量表。总体分先取类别加权平均；当公开证据触发高风险司法辖区政策时，评级会按政策调整，并设置 49（有风险）的上限。AI 就绪度不计入总体分。
61
优秀85-100堪称典范；基本满足所有检验标准
良好70-84健康；仅有轻微不足
中等50-69可接受，但存在明显不足；建议进行审查
存在风险30-49存在重大薄弱环节；采用时应保持审慎
危急1-29问题严重（项目被弃置、仅有单一维护者、缺乏基本工程规范）
评分画像
每条轴代表一个类别。形状比平均值更重要——健康的对象会填满整个图形，而“一峰一谷”式画像意味着某一维度的优势正掩盖另一维度的风险。
所有权
软件包生态系统
| 注册表 | 软件包 | 版本 | 月下载量 | 版本数 | 最近发布 |
|---|---|---|---|---|---|
| RubyGems | ruby-pg-extras | 5.8.0 | - | 98 | 0 天前 |
按类别列示的指标
活力
项目是否仍有生命——是否仍在编写代码，是否仍在发布版本？
69
开发活跃度
57中等
评分方式
| 36/36 | 推送新近度 — 最近一次推送于 0 天前 |
| 5.5/36 | 提交节奏 — 52 周中有 8 周有提交 |
| 11.3/18 | 提交量 — 最近一年 17 次提交 |
| 4/10 | OpenSSF Scorecard：Maintained — 5 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 4 |
所用输入
| commits_last_year | 17 |
| human_commit_share | 1 |
| days_since_last_push | 0 |
| active_weeks_last_year | 8 |
发布纪律
88优秀
评分方式
| 16.2/27 | 有发布版本 — 100 个版本标签（无 GitHub 发布版本） |
| 36/36 | 发布时效 — 最近一次发布版本于 0 天前 |
| 27/27 | 发布节奏 — 约每 41.8 天发布一次 |
| 0/10 | OpenSSF Scorecard：Signed-Releases — 无数据 |
所用输入
| releases_count | 100 |
| latest_release_tag | v5.8.0 |
| releases_from_tags | 是 |
| days_since_latest_release | 0 |
| mean_days_between_releases | 41.8 |
已排除计分（无数据或不适用）：OpenSSF Scorecard：Signed-Releases。 其余权重已重新归一化。
社区与采用
项目是否拥有用户、下载量与关注度，并具备欢迎贡献者参与的配置？
57
流行度与采用
46存在风险
评分方式
| 36.2/60 | 星标 — 171 个星标 |
| 10/25 | 复刻 — 17 个复刻 |
| 0/15 | 关注者 — 1 位关注者 |
所用输入
| forks | 17 |
| stars | 171 |
| watchers | 1 |
| 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 | 否 |
生态采用（下载量）
86优秀
评分方式
| 69.2/80 | 累计下载量 — rubygems 合计历史 4,524,288 次下载 |
| 0/20 | 注册表被依赖数 — 该生态系统不报告此项 |
所用输入
| packages | ruby-pg-extras |
| dependents | — |
| ecosystems | rubygems |
| total_downloads | 4,524,288 |
| monthly_downloads | — |
已排除计分（无数据或不适用）：注册表被依赖数。 其余权重已重新归一化。
可持续性与治理
项目能否在其成员之外延续——巴士系数、响应能力、由谁支持，以及软件包的维护状况？
68
维护者韧性（巴士系数）
28危急
评分方式
| 9/54 | 巴士系数 — 1 位贡献者贡献了半数提交 |
| 2.2/22.5 | 提交分布 — 头号贡献者编写了 90% 的提交 |
| 13.5/13.5 | 贡献者广度 — 12 位贡献者 |
| 3/10 | OpenSSF Scorecard：Contributors — project has 1 contributing companies or organizations -- score normalized to 3 |
所用输入
| bus_factor | 1 |
| contributors_sampled | 12 |
| top_contributor_share | 0.903 |
议题与 PR 响应能力
88优秀
评分方式
| 46.8/46.8 | 议题解决 — 100% 的议题已关闭 |
| 36.8/38.3 | PR 接受 — 已裁定的 PR 中 25/26 已合并 |
| 4.5/15 | OpenSSF Scorecard：Code-Review — Found 10/30 approved changesets -- score normalized to 3 |
所用输入
| merged_prs | 25 |
| open_issues | 0 |
| closed_issues | 13 |
| issue_closed_ratio | 1 |
| closed_unmerged_prs | 1 |
所有权与托管责任
69中等
评分方式
| 10/30 | 所有权背书 — 个人（用户）账户 |
| 0/20 | 已验证域名 — 不适用于个人账户 |
| 20/25 | 所有者影响力 — pawurb 有 606 位关注者 |
| 25/25 | 既往记录 — 107 个公开仓库，账户约 14 年 |
所用输入
| followers | 606 |
| owner_type | User |
| is_verified | — |
| owner_login | pawurb |
| public_repos | 107 |
| account_age_days | 5,394 |
已排除计分（无数据或不适用）：已验证域名。 其余权重已重新归一化。
软件包维护
100优秀
评分方式
| 25/25 | 已发布且可解析 — rubygems 上有 1 个软件包 |
| 35/35 | 发布时效 — 最近一次发布于 0 天前 |
| 20/20 | 版本历史 — 98 个已发布版本 |
| 20/20 | 未被弃用 — 活跃，未被弃用或撤回 |
所用输入
| packages | ruby-pg-extras |
| ecosystems | rubygems |
| any_deprecated | 否 |
| min_days_since_publish | 0 |
工程质量
基础的工程与文档实践是否到位？
64
工程实践
66中等
评分方式
| 24/24 | CI 工作流 — 1 个工作流 |
| 24/24 | 存在测试 |
| 0/16 | Linter 配置 |
| 0/9.6 | Pre-commit 钩子 |
| 0/6.4 | .editorconfig |
| 18/20 | OpenSSF Scorecard：CI-Tests — 9 out of 10 merged PRs checked by a CI test -- score normalized to 9 |
所用输入
| has_ci | 是 |
| has_tests | 是 |
| has_editorconfig | 否 |
| has_linter_config | 否 |
| has_precommit_config | 否 |
文档
60中等
评分方式
| 30/30 | README |
| 0/25 | 文档目录 |
| 0/15 | 文档 / 主页站点 |
| 10/10 | 仓库描述 |
| 10/10 | 主题标签 — 4 个主题标签 |
| 10/10 | Wiki |
所用输入
| topics | database, performance, postgresql, ruby |
| has_wiki | 是 |
| homepage | — |
| has_readme | 是 |
| has_docs_dir | 否 |
| has_description | 是 |
安全
可见的安全与供应链实践是否稳固，且不存在未解决的高风险司法辖区暴露？
39
安全态势
39存在风险
评分方式
| 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 |
| 2.2/2.5 | CI-Tests — 9 out of 10 merged PRs checked by a CI test -- score normalized to 9 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 2.2/7.5 | Code-Review — Found 10/30 approved changesets -- score normalized to 3 |
| 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 |
| 3/7.5 | Maintained — 5 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 4 |
| 0/5 | Packaging — 无数据 |
| 0/5 | Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
| 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 — detected GitHub workflow tokens with excessive permissions |
| 7.5/7.5 | Vulnerabilities — 0 existing vulnerabilities detected |
所用输入
| source | openssf_scorecard |
| checks_evaluated | 16 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 2 |
| scorecard_aggregate | 3.9 |
已排除计分（无数据或不适用）：packaging, signed_releases。 其余权重已重新归一化。
AI 就绪度
该仓库在多大程度上具备与 AI 编码代理协同开发与维护的条件？这是一枚独立的实验性徽章——权重为 0.0，因此单独呈现，不影响总体健康评分。
23
AI 代理上下文与指引
8危急
评分方式
| 0/45 | 代理指令 — 没有 CLAUDE.md / AGENTS.md / 编辑器规则 |
| 0/15 | 机器可读文档（llms.txt） |
| 8.5/40 | 可读的提交历史 — 100 次人类提交中有 16 次说明了意图（结构化标题或解释性正文） |
所用输入
| has_llms_txt | 否 |
| legible_history_share | 0.16 |
| agent_instruction_files | — |
| agent_instruction_max_bytes | — |
评分方式
| 0/18 | 一条命令的引导启动 |
| 22/22 | 自动化测试 |
| 0/11 | Lint / 格式化配置 |
| 0/11 | 静态类型检查 |
| 0/10 | 可复现环境 |
| 0/10 | 已体现的代理实践 — 最近 100 次提交中没有代理编写的提交 |
| 0/8 | 自动化维护 — 未观察到自动依赖更新 |
| 0/10 | OpenSSF Scorecard：Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
所用输入
| has_nix | 否 |
| has_tests | 是 |
| lockfiles | — |
| has_dockerfile | 否 |
| typed_language | 否 |
| bootstrap_files | — |
| has_devcontainer | 否 |
| has_linter_config | 否 |
| typecheck_configs | — |
| agent_commit_share | 0 |
| toolchain_manifests | — |
| dependency_bot_commit_share | 0 |
面向模型的代码可读性
55中等
评分方式
| 0/45 | 可类型检查的代码 — Ruby，未配置类型检查 |
| 55/55 | 可控的文件大小 — 采样的 24 个源文件中有 0 个超过 60KB |
所用输入
| primary_language | Ruby |
| largest_source_bytes | 13,835 |
| source_files_sampled | 24 |
| oversized_source_files | 0 |
关键数据
171GitHub 星标
12贡献者
17最近 12 个月提交数
0距最近推送天数
100发布版本数
1巴士系数（bus factor）
0开放议题
RubyGems软件包生态系统数
数据采集警告
- 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 ★ / 17 ⇿
0Star
17Fork
99发布
每颗 star 和每个 fork 的添加时间，来自 GitHub 并按天汇总。累计增长位于其构成来源——每日新增——的正上方，二者可相互对照：稳定的自然增长与短暂的突增形态截然不同。当这一差别可被衡量时，它会作为增长真实性予以报告。
主版本 4次版本 30修订 65
每个点涵盖 6 天。
OpenSSF Scorecard 3.9 / 10
3.9综合
来自开源项目 OpenSSF Scorecard 的独立、工具无关的安全评估。每项检查奖励的是安全实践本身，而非特定供应商的工具。Scorecard 无法判定的检查项标记为 不适用，并从安全评分中剔除（绝不按零分计）。
| 10 | Binary-Artifacts | no binaries found in the repo |
| 0 | Branch-Protection | branch protection not enabled on development/release branches |
| 9 | CI-Tests | 9 out of 10 merged PRs checked by a CI test -- score normalized to 9 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 3 | Code-Review | Found 10/30 approved changesets -- score normalized to 3 |
| 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 |
| 4 | Maintained | 5 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 4 |
| 不适用 | Packaging | packaging workflow not detected |
| 0 | Pinned-Dependencies | dependency not pinned by hash detected -- score normalized to 0 |
| 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 |
| 0 | Token-Permissions | detected GitHub workflow tokens with excessive permissions |
| 10 | Vulnerabilities | 0 existing vulnerabilities detected |
全部依赖 6
来自 GitHub 依赖图的完整解析依赖集合：0 个直接依赖与 6 个间接（传递）软件包。仓库提交锁文件时，传递闭包才是完整的。
| 注册表 | 软件包 | 版本 | 关系 |
|---|---|---|---|
| RubyGems | dbg-rb | — | 间接 |
| RubyGems | pg | — | 间接 |
| RubyGems | rake | — | 间接 |
| RubyGems | rspec | — | 间接 |
| RubyGems | rufo | — | 间接 |
| RubyGems | terminal-table | — | 间接 |
依赖安全公告 未评估
本报告未能完成公告比对：No resolved dependencies carried a version and a supported ecosystem
原始 JSON 报告 机器可读
{
"data": {
"repo": {
"topics": [
"database",
"performance",
"postgresql",
"ruby"
],
"is_fork": false,
"size_kb": 319,
"has_wiki": true,
"homepage": null,
"languages": {
"Ruby": 92508
},
"pushed_at": "2026-07-24T21:06:00Z",
"created_at": "2020-01-08T16:03:38Z",
"owner_type": "User",
"updated_at": "2026-07-24T21:05:48Z",
"description": "Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "main",
"license_spdx_raw": "MIT",
"primary_language": "Ruby",
"significant_languages": [
"Ruby"
]
},
"owner": {
"blog": "https://pawelurbanek.com",
"name": "Paweł Urbanek",
"type": "User",
"login": "pawurb",
"company": "@namiai",
"location": "Poland",
"followers": 606,
"avatar_url": "https://avatars.githubusercontent.com/u/1131944?v=4",
"created_at": "2011-10-16T21:35:44Z",
"is_verified": null,
"public_repos": 107,
"account_age_days": 5394
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v5.8.0",
"kind": "minor",
"published_at": "2026-07-24T21:05:36Z"
},
{
"tag": "v5.7.0",
"kind": "minor",
"published_at": "2026-06-16T22:28:32Z"
},
{
"tag": "v5.6.18",
"kind": "patch",
"published_at": "2026-05-11T22:09:00Z"
},
{
"tag": "v5.6.17",
"kind": "patch",
"published_at": "2026-01-20T22:13:14Z"
},
{
"tag": "v5.6.16",
"kind": "patch",
"published_at": "2026-01-06T20:37:41Z"
},
{
"tag": "v5.6.15",
"kind": "patch",
"published_at": "2025-12-16T21:45:10Z"
},
{
"tag": "v5.6.14",
"kind": "patch",
"published_at": "2025-11-26T21:03:11Z"
},
{
"tag": "v5.6.13",
"kind": "patch",
"published_at": "2025-09-07T20:02:47Z"
},
{
"tag": "v5.6.12",
"kind": "patch",
"published_at": "2025-07-13T22:16:31Z"
},
{
"tag": "v5.6.11",
"kind": "patch",
"published_at": "2025-07-13T22:05:44Z"
},
{
"tag": "v5.6.10",
"kind": "patch",
"published_at": "2025-05-07T20:17:41Z"
},
{
"tag": "v5.6.9",
"kind": "patch",
"published_at": "2025-05-02T18:59:23Z"
},
{
"tag": "v5.6.8",
"kind": "patch",
"published_at": "2025-04-16T15:31:27Z"
},
{
"tag": "v5.6.7",
"kind": "patch",
"published_at": "2025-02-25T11:41:23Z"
},
{
"tag": "v5.6.6",
"kind": "patch",
"published_at": "2025-02-14T11:38:23Z"
},
{
"tag": "v5.6.5",
"kind": "patch",
"published_at": "2025-02-14T09:57:10Z"
},
{
"tag": "v5.6.4",
"kind": "patch",
"published_at": "2025-02-14T09:51:40Z"
},
{
"tag": "v5.6.3",
"kind": "patch",
"published_at": "2025-02-14T00:59:10Z"
},
{
"tag": "v5.6.2",
"kind": "patch",
"published_at": "2025-02-03T14:52:40Z"
},
{
"tag": "v5.6.1",
"kind": "patch",
"published_at": "2025-02-02T21:58:19Z"
},
{
"tag": "v5.6.0",
"kind": "minor",
"published_at": "2025-02-01T22:03:15Z"
},
{
"tag": "v5.5.1",
"kind": "patch",
"published_at": "2025-01-04T16:23:55Z"
},
{
"tag": "v5.5.0",
"kind": "minor",
"published_at": "2025-01-04T16:09:42Z"
},
{
"tag": "v5.4.5",
"kind": "patch",
"published_at": "2024-11-21T18:36:02Z"
},
{
"tag": "v5.4.4",
"kind": "patch",
"published_at": "2024-11-21T12:26:40Z"
},
{
"tag": "v5.4.3",
"kind": "patch",
"published_at": "2024-11-21T11:03:28Z"
},
{
"tag": "v5.4.2",
"kind": "patch",
"published_at": "2024-11-21T10:56:27Z"
},
{
"tag": "v5.4.1",
"kind": "patch",
"published_at": "2024-10-08T09:04:03Z"
},
{
"tag": "v5.4.0",
"kind": "minor",
"published_at": "2024-09-19T20:07:05Z"
},
{
"tag": "v5.3.1",
"kind": "patch",
"published_at": "2023-12-14T08:37:15Z"
},
{
"tag": "v5.3.0",
"kind": "minor",
"published_at": "2023-08-25T10:12:04Z"
},
{
"tag": "v5.2.5",
"kind": "patch",
"published_at": "2023-06-08T11:49:35Z"
},
{
"tag": "v5.2.4",
"kind": "patch",
"published_at": "2023-06-06T21:16:29Z"
},
{
"tag": "v5.2.3",
"kind": "patch",
"published_at": "2023-06-05T14:14:17Z"
},
{
"tag": "v5.2.2",
"kind": "patch",
"published_at": "2023-04-09T22:48:20Z"
},
{
"tag": "v5.2.1",
"kind": "patch",
"published_at": "2023-03-01T12:59:09Z"
},
{
"tag": "v5.2.0",
"kind": "minor",
"published_at": "2023-02-27T22:31:34Z"
},
{
"tag": "v5.1.0",
"kind": "minor",
"published_at": "2023-02-26T22:48:31Z"
},
{
"tag": "v5.0.0",
"kind": "major",
"published_at": "2023-02-25T14:32:26Z"
},
{
"tag": "v4.13.0",
"kind": "minor",
"published_at": "2023-01-31T22:57:12Z"
},
{
"tag": "v4.12.2",
"kind": "patch",
"published_at": "2023-01-03T23:20:17Z"
},
{
"tag": "v4.12.1",
"kind": "patch",
"published_at": "2022-12-16T11:55:26Z"
},
{
"tag": "v4.12.0",
"kind": "minor",
"published_at": "2022-11-30T09:48:52Z"
},
{
"tag": "v4.11.0",
"kind": "minor",
"published_at": "2022-11-30T09:45:26Z"
},
{
"tag": "v4.10.0",
"kind": "minor",
"published_at": "2022-11-23T22:42:17Z"
},
{
"tag": "v4.9.0",
"kind": "minor",
"published_at": "2022-08-18T23:02:32Z"
},
{
"tag": "v4.8.1",
"kind": "patch",
"published_at": "2022-07-19T23:18:09Z"
},
{
"tag": "v4.8.0",
"kind": "minor",
"published_at": "2022-07-19T22:57:10Z"
},
{
"tag": "v4.7.2",
"kind": "patch",
"published_at": "2022-07-08T12:09:01Z"
},
{
"tag": "v4.7.1",
"kind": "patch",
"published_at": "2022-07-08T10:47:39Z"
},
{
"tag": "v4.7.0",
"kind": "minor",
"published_at": "2022-06-12T03:19:11Z"
},
{
"tag": "v4.6.0",
"kind": "minor",
"published_at": "2022-06-12T02:18:40Z"
},
{
"tag": "v4.5.1",
"kind": "patch",
"published_at": "2022-05-13T20:39:22Z"
},
{
"tag": "v4.5.0",
"kind": "minor",
"published_at": "2022-04-08T23:35:22Z"
},
{
"tag": "v4.4.4",
"kind": "patch",
"published_at": "2022-03-24T22:20:13Z"
},
{
"tag": "v4.4.3",
"kind": "patch",
"published_at": "2022-03-23T23:13:47Z"
},
{
"tag": "v4.4.2",
"kind": "patch",
"published_at": "2022-03-22T22:01:26Z"
},
{
"tag": "v4.4.1",
"kind": "patch",
"published_at": "2022-03-16T23:10:51Z"
},
{
"tag": "v4.4.0",
"kind": "minor",
"published_at": "2022-03-12T23:52:46Z"
},
{
"tag": "v4.3.3",
"kind": "patch",
"published_at": "2022-03-12T23:49:35Z"
},
{
"tag": "v4.3.2",
"kind": "patch",
"published_at": "2022-03-12T23:37:11Z"
},
{
"tag": "v4.3.1",
"kind": "patch",
"published_at": "2022-03-12T23:28:21Z"
},
{
"tag": "v4.3.0",
"kind": "minor",
"published_at": "2022-03-12T23:25:49Z"
},
{
"tag": "v4.2.0",
"kind": "minor",
"published_at": "2022-03-12T21:49:59Z"
},
{
"tag": "v4.1.0",
"kind": "minor",
"published_at": "2022-03-12T00:29:39Z"
},
{
"tag": "v4.0.1",
"kind": "patch",
"published_at": "2022-03-10T22:10:45Z"
},
{
"tag": "v4.0.0",
"kind": "major",
"published_at": "2022-03-09T00:32:09Z"
},
{
"tag": "v3.3.0",
"kind": "minor",
"published_at": "2022-02-22T22:21:09Z"
},
{
"tag": "v3.2.7",
"kind": "patch",
"published_at": "2022-02-21T14:31:53Z"
},
{
"tag": "v3.2.6",
"kind": "patch",
"published_at": "2022-01-20T23:35:17Z"
},
{
"tag": "v3.2.5",
"kind": "patch",
"published_at": "2021-12-21T02:21:23Z"
},
{
"tag": "v3.2.4",
"kind": "patch",
"published_at": "2021-12-21T02:18:03Z"
},
{
"tag": "v3.2.3",
"kind": "patch",
"published_at": "2021-12-18T01:34:44Z"
},
{
"tag": "v3.2.2",
"kind": "patch",
"published_at": "2021-12-17T02:03:49Z"
},
{
"tag": "v3.2.1",
"kind": "patch",
"published_at": "2021-12-15T02:39:29Z"
},
{
"tag": "v3.2.0",
"kind": "minor",
"published_at": "2021-12-15T01:44:15Z"
},
{
"tag": "v3.1.0",
"kind": "minor",
"published_at": "2021-10-29T22:18:58Z"
},
{
"tag": "v3.0.6",
"kind": "patch",
"published_at": "2021-10-28T20:43:20Z"
},
{
"tag": "v3.0.5",
"kind": "patch",
"published_at": "2021-10-28T20:32:00Z"
},
{
"tag": "v3.0.4",
"kind": "patch",
"published_at": "2021-10-28T13:20:09Z"
},
{
"tag": "v3.0.3",
"kind": "patch",
"published_at": "2021-10-28T13:07:19Z"
},
{
"tag": "v3.0.2",
"kind": "patch",
"published_at": "2021-10-28T13:02:15Z"
},
{
"tag": "v3.0.1",
"kind": "patch",
"published_at": "2021-10-28T12:44:52Z"
},
{
"tag": "v3.0.0",
"kind": "major",
"published_at": "2021-10-28T12:27:47Z"
},
{
"tag": "v2.3.0",
"kind": "minor",
"published_at": "2021-10-27T15:05:28Z"
},
{
"tag": "v2.2.0",
"kind": "minor",
"published_at": "2021-10-26T11:34:07Z"
},
{
"tag": "v2.1.0",
"kind": "minor",
"published_at": "2021-10-15T22:53:30Z"
},
{
"tag": "v2.0.0",
"kind": "major",
"published_at": "2021-07-08T21:13:18Z"
},
{
"tag": "v1.6.0",
"kind": "minor",
"published_at": "2021-03-29T09:10:47Z"
},
{
"tag": "v1.5.3",
"kind": "patch",
"published_at": "2021-02-16T14:21:37Z"
},
{
"tag": "v1.5.2",
"kind": "patch",
"published_at": "2021-02-13T11:00:58Z"
},
{
"tag": "v1.5.1",
"kind": "patch",
"published_at": "2021-02-13T10:17:28Z"
},
{
"tag": "v1.5.0",
"kind": "minor",
"published_at": "2021-02-13T09:43:17Z"
},
{
"tag": "v1.4.0",
"kind": "minor",
"published_at": "2021-01-26T14:06:23Z"
},
{
"tag": "v1.3.1",
"kind": "patch",
"published_at": "2021-01-22T16:19:17Z"
},
{
"tag": "v1.3.0",
"kind": "minor",
"published_at": "2021-01-22T13:01:11Z"
},
{
"tag": "v1.2.4",
"kind": "patch",
"published_at": "2020-10-13T10:48:31Z"
},
{
"tag": "v1.2.3",
"kind": "patch",
"published_at": "2020-10-08T10:11:48Z"
},
{
"tag": "v1.2.2",
"kind": "patch",
"published_at": "2020-10-08T10:04:34Z"
},
{
"tag": "v1.2.1",
"kind": "patch",
"published_at": "2020-05-13T16:25:48Z"
}
],
"recent_commits": [
{
"oid": "5ffe2862d704c7257df9043f65827cecdd343ba5",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2026-07-24T21:05:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ae8632babe8af89c3e8a0272b3554ea3988fdfd3",
"body": "* feat: add update_stats for HOT and new-page update breakdown\n\n## Summary\nAdd `update_stats` to report per-table HOT, same-page non-HOT, and new-page update metrics from `pg_stat_user_tables`, including fillfactor and percentages.\n\n## Why\nUpdate-heavy workloads benefit from HOT updates, but diagnos\n[…]\nt fillfactor.\n\n## Why\nThis feature enhances the ability to diagnose performance issues related to update-heavy workloads, providing insights into how table configurations may impact update efficiency.",
"is_bot": false,
"headline": "Add `update_stats` query for HOT and same-page update analysis (#39)",
"author_name": "Chedli Bourguiba",
"author_login": "chaadow",
"committed_at": "2026-07-24T20:54:52Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "846f42e741fb5bfcbe01426d7b645f1de7e0ac1b",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2026-06-16T22:28:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c1e9e4ea8c7f1360c910f45d1109facd1694a2e8",
"body": "…(#38)\n\n* refactor: read index columns from PostgreSQL catalogs\n\n## Summary\nReplace string parsing of `pg_indexes.indexdef` with catalog-based index metadata from `pg_index`, `pg_class`, `pg_attribute`, `pg_opclass`, and `pg_collation`.\n\n## Why\nParsing `CREATE INDEX` text is fragile for expression i\n[…]\nions.\n\n* fix: enhance foreign key index detection for partial indexes\n\nUpdate the logic in `missing_fk_indexes` to correctly identify foreign keys covered by partial indexes with a not-null predicate.",
"is_bot": false,
"headline": "Fix missing FK index detection with richer PostgreSQL index metadata …",
"author_name": "Chedli Bourguiba",
"author_login": "chaadow",
"committed_at": "2026-06-16T22:23:41Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "7e9898cdd7cde4904eca1ea13bc1c1df2e883d7d",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2026-05-11T22:09:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4ce0eaca54e23dbf6eb2448b82a21776490ecf8b",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2026-01-20T22:13:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0c69a29c8f9bd0684ec61c8cfc76ba8061356d3d",
"body": "Allows ruby-pg-extras to work with applications using multiple\ndatabases (e.g. Rails sharding) by closing and clearing the\nexisting connection when database_url= is called.",
"is_bot": false,
"headline": "Reset connection when database_url changes",
"author_name": "Fabrizio Monti",
"author_login": "delphaber",
"committed_at": "2026-01-20T22:12:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dc4a74012eeb2cee97511437509383b0a717e139",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2026-01-06T20:37:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "faca2a4446602f5083cef67364953657c007df2a",
"body": null,
"is_bot": false,
"headline": "Enhance missing_fk_indexes to support ignore_list",
"author_name": "Chedli Bourguiba",
"author_login": "chaadow",
"committed_at": "2026-01-06T20:36:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "977e40555e9fa0c67d66e207c330cbab9faf313d",
"body": null,
"is_bot": false,
"headline": "Update README for ignore_list as well as missing fk indexes (#35)",
"author_name": "Chedli Bourguiba",
"author_login": "chaadow",
"committed_at": "2025-12-17T22:22:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a74821aa57e5095511e1ec932175437abb965ed8",
"body": null,
"is_bot": false,
"headline": "Add pg18 to CI",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-12-16T21:59:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "133f39c8f712969f08c7078ce2b4c8d6cb6d18cd",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-12-16T21:45:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d1c6f6bdd8fcfa2e24f49c3e9bd06fdd4a546084",
"body": "…ints heuristics and update tests (#34)\n\n* Refactor missing foreign key index detection and update tests\n\n* Simplify the logic for detecting missing foreign key indexes by directly using foreign key information.\n* Update tests to reflect changes in foreign key and index detection, including new expe\n[…]\nhe `pluralize` method to normalize table names before applying pluralization rules.\n* Add new test cases to validate detection for various scenarios, including uncountable nouns and irregular plurals.",
"is_bot": false,
"headline": "Refactor/Fix missing foreign key index detection + missing FK constra…",
"author_name": "Chedli Bourguiba",
"author_login": "chaadow",
"committed_at": "2025-12-16T21:42:54Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "c8879c0641f10c5d8f03b4ca6e6b22ebfc240619",
"body": "…t` and `autovacuum_count` (#33)\n\n* Add 3 new queries\n\n- ANALYZE progress\nUseful to check to know if PG is acquiring sample rows on a certain\ntable\n\n- VACUUM progress\nUseful to know when vacuum workers are working or if you suspect the\nsystem beingn slow for some reason. This could also help check i\n[…]\nity-by-autovacuum-and-manual-vacuums\n\n* Add missing useful columns in vacuum_stats.sql\n\n* Update README with analyze_progress / vacuum_progress / vacuum_io_stats queries + updated vacuum_stats command",
"is_bot": false,
"headline": "Add 3 new queries + update vacuum_stats view with `manual_vacuum_coun…",
"author_name": "Chedli Bourguiba",
"author_login": "chaadow",
"committed_at": "2025-12-01T21:37:18Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "1bfff516335234c657b1153a0f069ef33a45c4a9",
"body": null,
"is_bot": false,
"headline": "Remove PG 12 tests",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-11-29T21:18:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5e16c51aa79707521de72ece6b65981c84f7cda2",
"body": "* Add new parameters to vacuum stats\n\n* Remove support for PG 12",
"is_bot": false,
"headline": "Add parameters to vacuum stats, and remove PG 12 support",
"author_name": "Chedli Bourguiba",
"author_login": "chaadow",
"committed_at": "2025-11-29T21:13:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ea44687696f5990ee87f21924e00b1fcc5dd4697",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-11-26T21:03:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f0c27365b7f0793805bcd94cbbbc4c62df53dfe9",
"body": "…query (#31)",
"is_bot": false,
"headline": "Performance: fetch schemas and foreign keys for all tables in single …",
"author_name": "Reid Lynch",
"author_login": "reid-rigo",
"committed_at": "2025-11-26T21:02:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8349c46fa3685f3966b2e8ab0c38394a6d336cf3",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-09-07T20:02:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8ef4d81af9f342d546896a5fe86fcd2f1098c35d",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-07-13T22:16:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4d93ef67485a6f1599e98760e315d1efebbee8bf",
"body": null,
"is_bot": false,
"headline": "Add avg_exec_ms to calls and outliers",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-07-13T22:05:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "48bcd8a91a8772db8ccb6e15da274f71fc7f4f9d",
"body": null,
"is_bot": false,
"headline": "Revert version",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-06-12T22:07:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bd09b4032f5c17fd87192784a41ec0c558746227",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-06-11T21:26:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "95026b1e09c4b0aa7c577fb91395654016279014",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-06-11T20:52:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "eb3aea86aa80f61fcf4d407f80345210bc701ee2",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-05-07T20:17:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "362f456683cea3f6fa03f685dac570eff6479541",
"body": null,
"is_bot": false,
"headline": "Test Ruby 3.4",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-05-02T19:00:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4c8395851d18e81f4dcba4be53f8b5842215e9f4",
"body": null,
"is_bot": false,
"headline": "Use schema for table_size query",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-05-02T18:59:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d3ff263c156ff8394be2ca1bc0c1c2f50760bb7b",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-04-16T15:31:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ad5a6dde2c55eb04de93f69c20759e8d53e6bb5b",
"body": "Fix detection of columns of partial indexes.",
"is_bot": false,
"headline": "Update indexes.sql (#29)",
"author_name": "Daniel Rikowski",
"author_login": "daniel-rikowski",
"committed_at": "2025-04-16T15:30:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6c236bfd615f9319fc79bc1183bd531df7ffd591",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-02-25T11:41:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d37dcf41e6053cb84d2fe06ee7aade32e806df87",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-02-14T11:38:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3eb9d3e0a21302bd11a2988cc90c21873c8bad2d",
"body": null,
"is_bot": false,
"headline": "Change wording",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-02-14T09:57:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "96ea2289be9b9d5ce8ffce54c1ea11e389781a6d",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-02-14T09:51:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5954d82533169711ac872c3933f47c4d3416f21b",
"body": null,
"is_bot": false,
"headline": "Add db_settings checks",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-02-14T00:59:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "af46019702b83e528be6877cb891a3b3e7262bb6",
"body": null,
"is_bot": false,
"headline": "Less queries for missing fk indexes",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-02-03T14:52:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fbc82b851af5e48aadcbcdb2b83a56b94ad300cf",
"body": null,
"is_bot": false,
"headline": "Update readme",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-02-03T12:41:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fe9574a0517460dd444f1684d355b670ff0dc70b",
"body": null,
"is_bot": false,
"headline": "Add missing fk indexes and constraints to diagnose",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-02-02T21:58:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cad2f830421ee4da73b71e01bd848cea0e75d485",
"body": null,
"is_bot": false,
"headline": "Cleanup and refactor",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-02-02T17:01:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "600bdc4c9dd82bc31543e69a0d8fdc1347b1648b",
"body": null,
"is_bot": false,
"headline": "Missing indexes and foreign keys helpers",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-02-01T22:03:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e33b559c867a61b721f8e81365e0dd4e66f82e6a",
"body": null,
"is_bot": false,
"headline": "Ports mapping",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-01-31T21:39:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e8707aae09422a6679416ad7b29edc54845c0bd5",
"body": null,
"is_bot": false,
"headline": "Drop ruby 2.6 CI",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-01-22T20:24:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bc89777856ac5636e9a9373f4b43e293c53672bb",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-01-04T16:23:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6b882d6b8ed32559eb113130ce4878b6e9271e43",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2025-01-04T16:09:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9b34c3b1cff7b94eb0b60c21e64689058abbf325",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2024-11-21T18:36:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "67cc5c3daa8940e19eb0597c3a2c37d79409a67e",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2024-11-21T12:26:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6ad36566ea90b19a29891d56fb11da915ae96328",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2024-11-21T11:03:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ba1907c962e596373f57158439c30622d76c83bb",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2024-11-21T10:56:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5c9072b24ee55f68633c709bf796daef0d6ed9f0",
"body": null,
"is_bot": false,
"headline": "Sleep less",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2024-10-12T13:22:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f23cd308fb4f3fac78f16ab561d4680f80fb5527",
"body": null,
"is_bot": false,
"headline": "Cleanup CI",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2024-10-09T10:02:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "99812590d27db877743a874fb899777dfa400d5a",
"body": null,
"is_bot": false,
"headline": "[#25] pg 17 compatibility",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2024-10-08T09:04:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "02e20853cf931333a2b85e3bf8d25ce04c3c5345",
"body": "* Run CI with latest Ruby and Postgres versions, remove duplicated job\r\n\r\n* Bump to actions/checkout@v4",
"is_bot": false,
"headline": "Run CI with latest Ruby and Postgres versions (#26)",
"author_name": "Nicolas Rodriguez",
"author_login": "n-rodriguez",
"committed_at": "2024-10-08T08:23:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "069cf7bb38c7b323ae7a331b6205b7d57be2d8a4",
"body": null,
"is_bot": false,
"headline": "Add database and locktype to locks",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2024-09-19T20:07:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9c58f7464221bd7fafb1fcc8413dacd8f364086d",
"body": null,
"is_bot": false,
"headline": "Readme fix",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2024-08-22T10:23:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7e51c75d77858626762d46fdf8b0aa1e019d080c",
"body": null,
"is_bot": false,
"headline": "Use rufo formatting",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2024-02-22T15:53:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d9290eac01cea85ebdbb84667f18a99a123d5e61",
"body": null,
"is_bot": false,
"headline": "Fix CI",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-12-31T12:59:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a3c6140d6aecd61a6f8f0bfca69ad2834e1246f2",
"body": null,
"is_bot": false,
"headline": "Add rust-pg-extras",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-12-31T12:54:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a3c6dd7ae1dbe3040c1c09595f75219dae33c7f9",
"body": null,
"is_bot": false,
"headline": "Update readme",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-12-14T08:48:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "43f2d2b2fa5d76e10b113ecc9c41b603ecd81a9b",
"body": null,
"is_bot": false,
"headline": "Customizable default schema",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-12-14T08:37:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bf7e4c3ef7912b800a672249de16d7a529a8c2f0",
"body": null,
"is_bot": false,
"headline": "Add table name to null_indexes",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-09-01T07:08:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8057906904e4d28226e70efbbcd6db4c1f12f9ce",
"body": null,
"is_bot": false,
"headline": "Add schema info to helper queries",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-08-25T10:12:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d0447d747b56440303c606cea529044ec020075a",
"body": null,
"is_bot": false,
"headline": "Use GH Actions for CI (#23)",
"author_name": "Paweł Urbanek",
"author_login": "pawurb",
"committed_at": "2023-08-19T11:24:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7f84af231b5e941c770b8311c2e7d52089f19141",
"body": null,
"is_bot": false,
"headline": "Fix sorting for blocking SQL",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-06-08T11:49:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3ab2633179cddc256970ece0b8bd036477935b40",
"body": null,
"is_bot": false,
"headline": "Display both blocking and blocked process name",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-06-06T21:16:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b083afb1e35ccfdc28cf61a34d39fb90c3503c18",
"body": null,
"is_bot": false,
"headline": "Add application_name to blocking method",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-06-05T14:14:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "27a8e8ec372ca21b0c0d619f96fb93b04593047c",
"body": null,
"is_bot": false,
"headline": "Rename default branch",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-05-16T21:40:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1b0fb56017038a6e8658249cc9af608f9f48560c",
"body": null,
"is_bot": false,
"headline": "Add limit for blocking method",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-04-09T22:48:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1970309fa4055ce5d1d73306620aef7bece235bc",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-03-01T12:59:09Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "083286d214bf4dd444f61ba15975746942160767",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-02-27T22:31:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3e0f14cedc895b59158eb4ce66aec1db068d24e2",
"body": null,
"is_bot": false,
"headline": "Version dump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-02-26T22:48:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3694bc99082efd37c66595763c3409595808dae2",
"body": null,
"is_bot": false,
"headline": "Major version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-02-25T14:32:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3506cec2a8865259990f5c3b501c1ad5ca9c9082",
"body": null,
"is_bot": false,
"headline": "Support custom database URL env",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-01-31T22:57:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5aa3093b935a8d34a371aaa85e89f471ec169028",
"body": null,
"is_bot": false,
"headline": "Add limit to locks query",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2023-01-03T23:20:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bb878d51ea8482cc95c9c74f21b48012a7cadf5e",
"body": "* fix: support server without sslinfo\r\n\r\n* bump version\r\n\r\nCo-authored-by: Chris Young <chris.young@jdcp.forces.gc.ca>",
"is_bot": false,
"headline": "Support scenario where sslinfo is not installed on the server (#20)",
"author_name": "Christopher Young",
"author_login": "krsyoung",
"committed_at": "2022-12-16T11:55:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "df11ea8b8a2fc9e86d3c1b08729481e7fdb2aaff",
"body": null,
"is_bot": false,
"headline": "Update readme",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-11-30T10:38:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1eb024267abbc00941cc281d281f5430c0bc4906",
"body": null,
"is_bot": false,
"headline": "Rename to kill_pid",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-11-30T09:48:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f430c2e2f5033cf02a5d2989f0a0e51592b5cfe2",
"body": null,
"is_bot": false,
"headline": "Add kill_by_pid method",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-11-30T09:45:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e68302dc4d8dbca40a1a61fff8f8eb5c9c34ed80",
"body": null,
"is_bot": false,
"headline": "Update readme",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-11-23T22:44:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2d4fd0d535a13aa5b5720301d2b74fa206c76c99",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-11-23T22:42:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "76756eccf3a250268a9b255a5e02fb38546ba5cd",
"body": "This adds the ability to get all active connections to the database.",
"is_bot": false,
"headline": "Add ability to gets all active connections to the database. (#18)",
"author_name": "Johnny5",
"author_login": "djgoku",
"committed_at": "2022-11-23T22:36:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7734a5dc4a3eebcf2074321270dd64929aff0771",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-08-18T23:02:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4b77dd9fdd72f38f10f2285f6e829a87e394e7ac",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-07-19T23:18:09Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a610f90067edf7597adbb3fc23e87a0b80ae3011",
"body": null,
"is_bot": false,
"headline": "Version dump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-07-08T12:09:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aef7789292b50d114fcb3ade2145b490a0225351",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-07-08T10:47:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0656f0a30d09f5dc3167513fb61aa5438d9d3b24",
"body": null,
"is_bot": false,
"headline": "Display application name for locks",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-06-12T03:19:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "466db087be1ea9e6b3d99224df4d80f6667a0f57",
"body": null,
"is_bot": false,
"headline": "Fix CI",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-06-12T02:45:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b9d29447b966335fe9cb11ccb67e2b6a1586b9c5",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-06-12T02:19:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "83eb7ae2d9147b4d49b58f68512c40260996efa0",
"body": "* Adds Postgres 14 to the development and testing environment\r\n\r\nPostgres 14 has been out for a while (14.3 was released in May 2022). This PR adds Postgres 14 to the set of Docker images that are created and used for local testing, and to Circle CI.\r\n\r\n* Fix typo",
"is_bot": false,
"headline": "Adds Postgres 14 to the development and testing environment (#15)",
"author_name": "Peter Goldstein",
"author_login": "petergoldstein",
"committed_at": "2022-06-12T02:12:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f0a3b5c4da02a3fabd942c96095da70d86dfbac4",
"body": "This commit eliminates the dependency on the now unsupported filesize gem. The parsing functionality from that gem is now handled with a dedicated SizeParser class.",
"is_bot": false,
"headline": "Fix #12 - Eliminate filesize dependency (#14)",
"author_name": "Peter Goldstein",
"author_login": "petergoldstein",
"committed_at": "2022-06-12T02:11:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6fb971461948d407658c4db668bc02156cd0f346",
"body": "Circle CI is no longer supporting the Docker images with a `circleci` prefix. The newer, supported images have a `cimg` prefix.\r\n\r\nThis PR changes the prefix. It also migrates to the latest patch version for each Ruby and Postgres image.",
"is_bot": false,
"headline": "Switch to cimg images (#13)",
"author_name": "Peter Goldstein",
"author_login": "petergoldstein",
"committed_at": "2022-06-12T02:08:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "677cd9dcf5e4d783be20b2dbc8951896716967b5",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-05-13T20:39:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1ce8edc723b4e2c5301de0dd8340cc72181b65da",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-04-08T23:35:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a7557e5c87b1927108749364e577ab625bde0def",
"body": "Llimit queries to specific schema where appropriate, defaulting to the public schema",
"is_bot": false,
"headline": "Merge pull request #11 from weknowtraining/weknowtraining",
"author_name": "Paweł Urbanek",
"author_login": "pawurb",
"committed_at": "2022-04-08T23:34:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5ed3f43f0bb9b41a56ea73d39b55b04133f76911",
"body": "… normal public schema",
"is_bot": false,
"headline": "limit queries to specific schema where appropriate, defaulting to the…",
"author_name": "Daniel Huckstep",
"author_login": "darkhelmet",
"committed_at": "2022-04-08T18:58:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "70fd04900f3bc2bdeed96d522f2f35f9061b6b55",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-03-24T22:20:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5b624ea4485fea8d115c5bca0ebd5fc38d408bcd",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-03-23T23:13:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c6ce6e8cd5c0c5313eae809e604265c61fbfc18e",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-03-22T22:01:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aa4ec6a8d7d0f544502a78242afb18959cf27c70",
"body": null,
"is_bot": false,
"headline": "Update CI config",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-03-16T23:35:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "721820e764c2b4fb65eda171eacbac0a18da28dc",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-03-16T23:10:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9a384a887fce941d43f955f4f47c8603e8e5b95f",
"body": null,
"is_bot": false,
"headline": "Custom require not needed",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-03-12T23:52:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c37c92ed3a29050815015990b8d7cd76d79bf612",
"body": null,
"is_bot": false,
"headline": "Version bump",
"author_name": "pawurb",
"author_login": "pawurb",
"committed_at": "2022-03-12T23:49:35Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 100,
"commits_last_year": 17,
"latest_release_at": "2026-07-24T21:05:36Z",
"latest_release_tag": "v5.8.0",
"releases_from_tags": true,
"days_since_last_push": 0,
"active_weeks_last_year": 8,
"days_since_latest_release": 0,
"mean_days_between_releases": 41.8
},
"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": "ruby-pg-extras",
"exists": true,
"license": "MIT",
"keywords": [],
"ecosystem": "rubygems",
"matches_repo": true,
"registry_url": "https://rubygems.org/gems/ruby-pg-extras",
"is_deprecated": false,
"latest_version": "5.8.0",
"repository_url": "http://github.com/pawurb/ruby-pg-extras",
"versions_count": 98,
"total_downloads": 4524288,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": null,
"first_published_at": "2020-01-08T16:04:29.970000Z",
"latest_published_at": "2026-07-24T21:07:02.793000Z",
"latest_version_yanked": null,
"days_since_latest_publish": 0
}
]
},
"popularity": {
"forks": 17,
"stars": 171,
"watchers": 1,
"fork_history": {
"days": [
{
"date": "2020-01-09",
"count": 1
},
{
"date": "2020-03-31",
"count": 1
},
{
"date": "2020-10-20",
"count": 1
},
{
"date": "2021-03-20",
"count": 1
},
{
"date": "2021-04-06",
"count": 1
},
{
"date": "2022-04-06",
"count": 1
},
{
"date": "2022-06-11",
"count": 1
},
{
"date": "2022-07-25",
"count": 1
},
{
"date": "2022-08-11",
"count": 1
},
{
"date": "2022-11-10",
"count": 1
},
{
"date": "2022-12-16",
"count": 1
},
{
"date": "2025-03-17",
"count": 1
},
{
"date": "2025-04-16",
"count": 1
},
{
"date": "2025-09-26",
"count": 1
},
{
"date": "2025-11-29",
"count": 1
},
{
"date": "2026-01-19",
"count": 1
},
{
"date": "2026-06-30",
"count": 1
}
],
"complete": true,
"collected": 17,
"total_forks": 17
},
"star_history": null,
"open_issues_and_prs": 0
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": false,
"has_mcp_signal": false,
"bootstrap_files": [],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [],
"largest_source_bytes": 13835,
"source_files_sampled": 24,
"oversized_source_files": 0,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"dependencies": {
"manifests": [
"Gemfile"
],
"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": 6,
"direct_affected_count": 0
},
"ecosystems": [
"rubygems"
],
"dependencies": [],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "dbg-rb",
"direct": false,
"version": null,
"ecosystem": "rubygems"
},
{
"name": "pg",
"direct": false,
"version": null,
"ecosystem": "rubygems"
},
{
"name": "rake",
"direct": false,
"version": null,
"ecosystem": "rubygems"
},
{
"name": "rspec",
"direct": false,
"version": null,
"ecosystem": "rubygems"
},
{
"name": "rufo",
"direct": false,
"version": null,
"ecosystem": "rubygems"
},
{
"name": "terminal-table",
"direct": false,
"version": null,
"ecosystem": "rubygems"
}
],
"collected": true,
"truncated": false,
"total_count": 6,
"direct_count": 0,
"indirect_count": 6
}
},
"maintainership": {
"issues": {
"open_prs": 0,
"merged_prs": 25,
"open_issues": 0,
"closed_ratio": 1,
"closed_issues": 13,
"closed_unmerged_prs": 1
},
"bus_factor": 1,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "pawurb",
"commits": 177,
"avatar_url": "https://avatars.githubusercontent.com/u/1131944?v=4"
},
{
"type": "User",
"login": "chaadow",
"commits": 7,
"avatar_url": "https://avatars.githubusercontent.com/u/1371733?v=4"
},
{
"type": "User",
"login": "petergoldstein",
"commits": 3,
"avatar_url": "https://avatars.githubusercontent.com/u/421488?v=4"
},
{
"type": "User",
"login": "krsyoung",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/5449541?v=4"
},
{
"type": "User",
"login": "darkhelmet",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/36123?v=4"
},
{
"type": "User",
"login": "daniel-rikowski",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/1169363?v=4"
},
{
"type": "User",
"login": "delphaber",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/139284?v=4"
},
{
"type": "User",
"login": "djgoku",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/105506?v=4"
},
{
"type": "User",
"login": "n-rodriguez",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/3433835?v=4"
},
{
"type": "User",
"login": "rainerborene",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/101501?v=4"
}
],
"contributors_sampled": 12,
"top_contributor_share": 0.903
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"ci.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": 9,
"reason": "9 out of 10 merged PRs checked by a CI test -- score normalized to 9",
"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 10/30 approved changesets -- score normalized to 3",
"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": 4,
"reason": "5 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 4",
"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": "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": 0,
"reason": "detected GitHub workflow tokens with excessive permissions",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
},
{
"name": "Vulnerabilities",
"score": 10,
"reason": "0 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "5ffe2862d704c7257df9043f65827cecdd343ba5",
"ran_at": "2026-07-24T21:15:00Z",
"aggregate_score": 3.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-24T21:08:48Z",
"oldest_open_prs": [],
"last_merged_pr_at": "2026-07-24T20:54:52Z",
"ci_last_conclusion": "SUCCESS",
"oldest_open_issues": []
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/pawurb/ruby-pg-extras",
"host": "github.com",
"name": "ruby-pg-extras",
"owner": "pawurb"
},
"metrics": {
"overall": {
"key": "overall",
"band": "moderate",
"name": "Overall health",
"note": null,
"notes": [],
"value": 61,
"inputs": {
"security": 39,
"vitality": 69,
"community": 57,
"governance": 68,
"engineering": 64
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "moderate",
"name": "Vitality",
"value": 69,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "moderate",
"name": "Development activity",
"note": null,
"notes": [],
"value": 57,
"inputs": {
"commits_last_year": 17,
"human_commit_share": 1,
"days_since_last_push": 0,
"active_weeks_last_year": 8
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 0 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "push_recency",
"params": {
"days": 0
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "8/52 weeks with commits",
"points": 5.5,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 8
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "17 commits in the last year",
"points": 11.3,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 17
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "5 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 4",
"points": 4,
"status": "partial",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "excellent",
"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": 88,
"inputs": {
"releases_count": 100,
"latest_release_tag": "v5.8.0",
"releases_from_tags": true,
"days_since_latest_release": 0,
"mean_days_between_releases": 41.8
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "100 version tags (no GitHub releases)",
"points": 16.2,
"status": "partial",
"details": [
{
"code": "version_tags_no_releases",
"params": {
"count": 100
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 0 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "release_recency",
"params": {
"days": 0
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~41.8 days",
"points": 27,
"status": "met",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 41.8
}
}
],
"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": 0,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 0 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 0
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "moderate",
"name": "Community & Adoption",
"value": 57,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "at_risk",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 46,
"inputs": {
"forks": 17,
"stars": 171,
"watchers": 1,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "171 stars",
"points": 36.2,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 171
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "17 forks",
"points": 10,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 17
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "1 watchers",
"points": 0,
"status": "missed",
"details": [
{
"code": "watchers",
"params": {
"count": 1
}
}
],
"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": "Excluded from scoring (no data or not applicable): Registry dependents. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"registry_dependents"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 86,
"inputs": {
"packages": [
"ruby-pg-extras"
],
"dependents": null,
"ecosystems": "rubygems",
"total_downloads": 4524288,
"monthly_downloads": null
},
"components": [
{
"key": "total_downloads",
"name": "Total downloads",
"detail": "4,524,288 downloads all-time across rubygems",
"points": 69.2,
"status": "partial",
"details": [
{
"code": "downloads_total",
"params": {
"count": 4524288,
"ecosystems": "rubygems"
}
}
],
"max_points": 80
},
{
"key": "registry_dependents",
"name": "Registry dependents",
"detail": "not reported by this ecosystem",
"points": 0,
"status": "excluded",
"details": [
{
"code": "not_reported_by_this_ecosystem",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "moderate",
"name": "Sustainability & Governance",
"value": 68,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "critical",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 28,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 12,
"top_contributor_share": 0.903
},
"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 90% of commits",
"points": 2.2,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 90
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "12 contributors",
"points": 13.5,
"status": "met",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 12
}
}
],
"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": "excellent",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 88,
"inputs": {
"merged_prs": 25,
"open_issues": 0,
"closed_issues": 13,
"issue_closed_ratio": 1,
"closed_unmerged_prs": 1
},
"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": "25/26 decided PRs merged",
"points": 36.8,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 25,
"decided": 26
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 10/30 approved changesets -- score normalized to 3",
"points": 4.5,
"status": "partial",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "moderate",
"name": "Ownership & stewardship",
"note": "Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"verified_domain"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 69,
"inputs": {
"followers": 606,
"owner_type": "User",
"is_verified": null,
"owner_login": "pawurb",
"public_repos": 107,
"account_age_days": 5394
},
"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": "606 followers of pawurb",
"points": 20,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 606,
"login": "pawurb"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "107 public repos, account ~14 yr old",
"points": 25,
"status": "met",
"details": [
{
"code": "public_repos",
"params": {
"count": 107
}
},
{
"code": "account_age_years",
"params": {
"years": 14
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "excellent",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"ruby-pg-extras"
],
"ecosystems": "rubygems",
"any_deprecated": false,
"min_days_since_publish": 0
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "1 package(s) on rubygems",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 1,
"ecosystems": "rubygems"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 0 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 0
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "98 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 98
}
}
],
"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": 64,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "moderate",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 66,
"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": "9 out of 10 merged PRs checked by a CI test -- score normalized to 9",
"points": 18,
"status": "partial",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "moderate",
"name": "Documentation",
"note": null,
"notes": [],
"value": 60,
"inputs": {
"topics": [
"database",
"performance",
"postgresql",
"ruby"
],
"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": "4 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 4
}
}
],
"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": 39,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "at_risk",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Packaging, Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"packaging",
"signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 39,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 16,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 2,
"scorecard_aggregate": 3.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": "9 out of 10 merged PRs checked by a CI test -- score normalized to 9",
"points": 2.2,
"status": "partial",
"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 10/30 approved changesets -- score normalized to 3",
"points": 2.2,
"status": "partial",
"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": "5 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 4",
"points": 3,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow not detected",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "pinned_dependencies",
"name": "Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is not run on all commits -- score normalized to 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": "detected GitHub workflow tokens with excessive permissions",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "0 existing vulnerabilities detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "excellent",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"review_only_matches": 0,
"assessed_self_published_locations": 12
},
"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": "critical",
"name": "AI Readiness",
"value": 23,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "critical",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 8,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.16,
"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": "16 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 8.5,
"status": "partial",
"details": [
{
"code": "legible_history",
"params": {
"legible": 16,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "critical",
"name": "Verify loop (build / test / typecheck)",
"note": null,
"notes": [],
"value": 22,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": false,
"typed_language": false,
"bootstrap_files": [],
"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": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 18
},
{
"key": "automated_tests",
"name": "Automated tests",
"detail": null,
"points": 22,
"status": "met",
"details": [],
"max_points": 22
},
{
"key": "lint_format_config",
"name": "Lint / format config",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": 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": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "moderate",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 55,
"inputs": {
"primary_language": "Ruby",
"largest_source_bytes": 13835,
"source_files_sampled": 24,
"oversized_source_files": 0
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "Ruby without a type-check config",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_typecheck_config_language",
"params": {
"language": "Ruby"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "0/24 source files over 60KB",
"points": 55,
"status": "met",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 24,
"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-24T21:15:13.602458Z",
"schema_version": "0.27.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/p/pawurb/ruby-pg-extras.svg",
"full_name": "pawurb/ruby-pg-extras",
"license_state": "standard",
"license_spdx": "MIT"
}