公开记录中等
软件健康报告模式 0.27.0 · 指标 1.13.0 · 2026-07-25 13:53 UTC
catgoose / chuck
Multi-dialect SQL DDL schema builder for Go
catgoose/chuck 的健康指数为 100 分中的 57 分，处于「中等」区间。 其得分最高的类别是Vitality（85/100），最低的是Community & Adoption（24/100）。 最近一次更新在 6 天前。 近期的大部分工作由 1 位贡献者完成。
57
总分 / 100软件健康指数
指标归入加权类别，统一采用 1–100 量表。总体分先取类别加权平均；当公开证据触发高风险司法辖区政策时，评级会按政策调整，并设置 49（有风险）的上限。AI 就绪度不计入总体分。
57
优秀85-100堪称典范；基本满足所有检验标准
良好70-84健康；仅有轻微不足
中等50-69可接受，但存在明显不足；建议进行审查
存在风险30-49存在重大薄弱环节；采用时应保持审慎
危急1-29问题严重（项目被弃置、仅有单一维护者、缺乏基本工程规范）
评分画像
每条轴代表一个类别。形状比平均值更重要——健康的对象会填满整个图形，而“一峰一谷”式画像意味着某一维度的优势正掩盖另一维度的风险。
所有权
软件包生态系统
| 注册表 | 软件包 | 版本 | 月下载量 | 版本数 | 最近发布 |
|---|---|---|---|---|---|
| Go | github.com/catgoose/chuck | v0.1.51 | - | 52 | 6 天前 |
按类别列示的指标
活力
项目是否仍有生命——是否仍在编写代码，是否仍在发布版本？
85
开发活跃度
75良好
评分方式
| 36/36 | 推送新近度 — 最近一次推送于 6 天前 |
| 11.1/36 | 提交节奏 — 52 周中有 16 周有提交 |
| 18/18 | 提交量 — 最近一年 113 次提交 |
| 10/10 | OpenSSF Scorecard：Maintained — 30 commit(s) and 16 issue activity found in the last 90 days -- score normalized to 10 |
所用输入
| commits_last_year | 113 |
| human_commit_share | 1 |
| days_since_last_push | 6 |
| active_weeks_last_year | 16 |
发布纪律
100优秀
评分方式
| 27/27 | 有发布版本 — 已发布 51 个发布版本 |
| 36/36 | 发布时效 — 最近一次发布版本于 6 天前 |
| 27/27 | 发布节奏 — 约每 5.4 天发布一次 |
| 0/10 | OpenSSF Scorecard：Signed-Releases — 无数据 |
所用输入
| releases_count | 51 |
| latest_release_tag | v0.1.51 |
| releases_from_tags | 否 |
| days_since_latest_release | 6 |
| mean_days_between_releases | 5.4 |
已排除计分（无数据或不适用）：OpenSSF Scorecard：Signed-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 | 否 |
可持续性与治理
项目能否在其成员之外延续——巴士系数、响应能力、由谁支持，以及软件包的维护状况？
58
维护者韧性（巴士系数）
10危急
评分方式
| 9/54 | 巴士系数 — 1 位贡献者贡献了半数提交 |
| 0/22.5 | 提交分布 — 头号贡献者编写了 100% 的提交 |
| 1.4/13.5 | 贡献者广度 — 1 位贡献者 |
| 0/10 | OpenSSF Scorecard：Contributors — project has 0 contributing companies or organizations -- score normalized to 0 |
所用输入
| bus_factor | 1 |
| contributors_sampled | 1 |
| top_contributor_share | 1 |
议题与 PR 响应能力
85优秀
评分方式
| 46.8/46.8 | 议题解决 — 100% 的议题已关闭 |
| 38.2/38.3 | PR 接受 — 已裁定的 PR 中 58/58 已合并 |
| 0/15 | OpenSSF Scorecard：Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
所用输入
| merged_prs | 58 |
| open_issues | 0 |
| closed_issues | 54 |
| issue_closed_ratio | 1 |
| closed_unmerged_prs | 0 |
所有权与托管责任
57中等
评分方式
| 10/30 | 所有权背书 — 个人（用户）账户 |
| 0/20 | 已验证域名 — 不适用于个人账户 |
| 10.9/25 | 所有者影响力 — catgoose 有 32 位关注者 |
| 25/25 | 既往记录 — 82 个公开仓库，账户约 9 年 |
所用输入
| followers | 32 |
| owner_type | User |
| is_verified | — |
| owner_login | catgoose |
| public_repos | 82 |
| account_age_days | 3,632 |
已排除计分（无数据或不适用）：已验证域名。 其余权重已重新归一化。
软件包维护
100优秀
评分方式
| 25/25 | 已发布且可解析 — go 上有 1 个软件包 |
| 35/35 | 发布时效 — 最近一次发布于 6 天前 |
| 20/20 | 版本历史 — 52 个已发布版本 |
| 20/20 | 未被弃用 — 活跃，未被弃用或撤回 |
所用输入
| packages | github.com/catgoose/chuck |
| ecosystems | go |
| any_deprecated | 否 |
| min_days_since_publish | 6 |
工程质量
基础的工程与文档实践是否到位？
66
工程实践
84良好
评分方式
| 24/24 | CI 工作流 — 3 个工作流 |
| 24/24 | 存在测试 |
| 16/16 | Linter 配置 — .golangci.yml |
| 0/9.6 | Pre-commit 钩子 |
| 0/6.4 | .editorconfig |
| 20/20 | OpenSSF Scorecard：CI-Tests — 19 out of 19 merged PRs checked by a CI test -- score normalized to 10 |
所用输入
| has_ci | 是 |
| has_tests | 是 |
| has_editorconfig | 否 |
| has_linter_config | 是 |
| has_precommit_config | 否 |
文档
40存在风险
评分方式
| 30/30 | README |
| 0/25 | 文档目录 |
| 0/15 | 文档 / 主页站点 |
| 10/10 | 仓库描述 |
| 0/10 | 主题标签 |
| 0/10 | Wiki |
所用输入
| topics | — |
| has_wiki | 否 |
| homepage | — |
| has_readme | 是 |
| has_docs_dir | 否 |
| has_description | 是 |
安全
可见的安全与供应链实践是否稳固，且不存在未解决的高风险司法辖区暴露？
40
安全态势
40存在风险
评分方式
| 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.5/2.5 | CI-Tests — 19 out of 19 merged PRs checked by a CI test -- score normalized to 10 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 0/7.5 | Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
| 0/2.5 | Contributors — project has 0 contributing companies or organizations -- score normalized to 0 |
| 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 16 issue activity found in the last 90 days -- score normalized to 10 |
| 0/5 | Packaging — 无数据 |
| 0.5/5 | Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 1 |
| 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 |
| 6.8/7.5 | Vulnerabilities — 1 existing vulnerabilities detected |
所用输入
| source | openssf_scorecard |
| checks_evaluated | 16 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 2 |
| scorecard_aggregate | 4 |
已排除计分（无数据或不适用）：packaging, signed_releases。 其余权重已重新归一化。
AI 就绪度
该仓库在多大程度上具备与 AI 编码代理协同开发与维护的条件？这是一枚独立的实验性徽章——权重为 0.0，因此单独呈现，不影响总体健康评分。
66
AI 代理上下文与指引
40存在风险
评分方式
| 0/45 | 代理指令 — 没有 CLAUDE.md / AGENTS.md / 编辑器规则 |
| 0/15 | 机器可读文档（llms.txt） |
| 40/40 | 可读的提交历史 — 100 次人类提交中有 98 次说明了意图（结构化标题或解释性正文） |
所用输入
| has_llms_txt | 否 |
| legible_history_share | 0.98 |
| agent_instruction_files | — |
| agent_instruction_max_bytes | — |
评分方式
| 18/18 | 一条命令的引导启动 — Makefile |
| 22/22 | 自动化测试 |
| 11/11 | Lint / 格式化配置 — .golangci.yml |
| 11/11 | 静态类型检查 — Go（静态类型） |
| 10/10 | 可复现环境 — lockfile |
| 0/10 | 已体现的代理实践 — 最近 100 次提交中没有代理编写的提交 |
| 0/8 | 自动化维护 — 未观察到自动依赖更新 |
| 1/10 | OpenSSF Scorecard：Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 1 |
所用输入
| 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 |
面向模型的代码可读性
100优秀
评分方式
| 45/45 | 可类型检查的代码 — Go（静态类型） |
| 55/55 | 可控的文件大小 — 采样的 78 个源文件中有 0 个超过 60KB |
所用输入
| primary_language | Go |
| largest_source_bytes | 43,648 |
| source_files_sampled | 78 |
| oversized_source_files | 0 |
关键数据
1GitHub 星标
1贡献者
113最近 12 个月提交数
6距最近推送天数
51发布版本数
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 4.0 / 10
4.0综合
来自开源项目 OpenSSF Scorecard 的独立、工具无关的安全评估。每项检查奖励的是安全实践本身，而非特定供应商的工具。Scorecard 无法判定的检查项标记为 不适用，并从安全评分中剔除（绝不按零分计）。
| 10 | Binary-Artifacts | no binaries found in the repo |
| 0 | Branch-Protection | branch protection not enabled on development/release branches |
| 10 | CI-Tests | 19 out of 19 merged PRs checked by a CI test -- score normalized to 10 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 0 | Code-Review | Found 0/30 approved changesets -- score normalized to 0 |
| 0 | Contributors | project has 0 contributing companies or organizations -- score normalized to 0 |
| 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 16 issue activity found in the last 90 days -- score normalized to 10 |
| 不适用 | Packaging | packaging workflow not detected |
| 1 | Pinned-Dependencies | dependency not pinned by hash detected -- score normalized to 1 |
| 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 |
| 9 | Vulnerabilities | 1 existing vulnerabilities detected |
直接依赖 5
| 注册表 | 软件包 | 版本约束 | 清单文件 |
|---|---|---|---|
| Go | github.com/denisenkom/go-mssqldb | v0.12.3 | go.mod |
| Go | github.com/lib/pq | v1.12.3 | go.mod |
| Go | github.com/mattn/go-sqlite3 | v1.14.48 | go.mod |
| Go | github.com/ncruces/go-sqlite3 | v0.35.2 | go.mod |
| Go | github.com/stretchr/testify | v1.11.1 | go.mod |
全部依赖 未采集
本报告未能采集到解析后的依赖集合：GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository
原始 JSON 报告 机器可读
{
"data": {
"repo": {
"topics": [],
"is_fork": false,
"size_kb": 398,
"has_wiki": false,
"homepage": null,
"languages": {
"Go": 632152,
"Makefile": 98
},
"pushed_at": "2026-07-19T01:25:27Z",
"created_at": "2026-04-02T16:40:01Z",
"owner_type": "User",
"updated_at": "2026-07-19T01:22:26Z",
"description": "Multi-dialect SQL DDL schema builder for Go",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "main",
"license_spdx_raw": "MIT",
"primary_language": "Go",
"significant_languages": [
"Go"
]
},
"owner": {
"blog": null,
"name": "Meow Honk",
"type": "User",
"login": "catgoose",
"company": null,
"location": null,
"followers": 32,
"avatar_url": "https://avatars.githubusercontent.com/u/21010072?v=4",
"created_at": "2016-08-13T15:22:05Z",
"is_verified": null,
"public_repos": 82,
"account_age_days": 3632
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v0.1.51",
"kind": "patch",
"published_at": "2026-07-19T01:25:32Z"
},
{
"tag": "v0.1.50",
"kind": "patch",
"published_at": "2026-07-12T01:27:39Z"
},
{
"tag": "v0.1.49",
"kind": "patch",
"published_at": "2026-07-05T01:51:09Z"
},
{
"tag": "v0.1.48",
"kind": "patch",
"published_at": "2026-06-28T02:12:16Z"
},
{
"tag": "v0.1.47",
"kind": "patch",
"published_at": "2026-06-21T02:32:19Z"
},
{
"tag": "v0.1.46",
"kind": "patch",
"published_at": "2026-06-14T02:31:09Z"
},
{
"tag": "v0.1.45",
"kind": "patch",
"published_at": "2026-06-07T20:55:46Z"
},
{
"tag": "v0.1.44",
"kind": "patch",
"published_at": "2026-06-07T02:13:40Z"
},
{
"tag": "v0.1.43",
"kind": "patch",
"published_at": "2026-06-05T16:24:51Z"
},
{
"tag": "v0.1.42",
"kind": "patch",
"published_at": "2026-05-31T02:10:12Z"
},
{
"tag": "v0.1.41",
"kind": "patch",
"published_at": "2026-05-24T02:00:53Z"
},
{
"tag": "v0.1.40",
"kind": "patch",
"published_at": "2026-05-23T13:29:48Z"
},
{
"tag": "v0.1.39",
"kind": "patch",
"published_at": "2026-05-22T01:18:09Z"
},
{
"tag": "v0.1.38",
"kind": "patch",
"published_at": "2026-05-22T00:06:25Z"
},
{
"tag": "v0.1.37",
"kind": "patch",
"published_at": "2026-05-21T13:02:17Z"
},
{
"tag": "v0.1.36",
"kind": "patch",
"published_at": "2026-05-21T12:09:42Z"
},
{
"tag": "v0.1.35",
"kind": "patch",
"published_at": "2026-05-21T11:14:55Z"
},
{
"tag": "v0.1.34",
"kind": "patch",
"published_at": "2026-05-20T14:13:50Z"
},
{
"tag": "v0.1.33",
"kind": "patch",
"published_at": "2026-05-19T16:14:37Z"
},
{
"tag": "v0.1.32",
"kind": "patch",
"published_at": "2026-05-19T15:02:07Z"
},
{
"tag": "v0.1.31",
"kind": "patch",
"published_at": "2026-05-19T14:59:55Z"
},
{
"tag": "v0.1.30",
"kind": "patch",
"published_at": "2026-05-19T14:46:30Z"
},
{
"tag": "v0.1.29",
"kind": "patch",
"published_at": "2026-05-19T14:32:31Z"
},
{
"tag": "v0.1.28",
"kind": "patch",
"published_at": "2026-05-19T14:11:39Z"
},
{
"tag": "v0.1.27",
"kind": "patch",
"published_at": "2026-05-19T13:55:25Z"
},
{
"tag": "v0.1.26",
"kind": "patch",
"published_at": "2026-05-19T13:10:39Z"
},
{
"tag": "v0.1.25",
"kind": "patch",
"published_at": "2026-05-19T12:23:45Z"
},
{
"tag": "v0.1.24",
"kind": "patch",
"published_at": "2026-05-19T00:33:27Z"
},
{
"tag": "v0.1.23",
"kind": "patch",
"published_at": "2026-05-19T00:15:45Z"
},
{
"tag": "v0.1.22",
"kind": "patch",
"published_at": "2026-05-18T23:50:36Z"
},
{
"tag": "v0.1.21",
"kind": "patch",
"published_at": "2026-05-17T01:54:34Z"
},
{
"tag": "v0.1.20",
"kind": "patch",
"published_at": "2026-05-15T14:13:15Z"
},
{
"tag": "v0.1.19",
"kind": "patch",
"published_at": "2026-05-15T14:09:41Z"
},
{
"tag": "v0.1.18",
"kind": "patch",
"published_at": "2026-05-11T18:05:02Z"
},
{
"tag": "v0.1.17",
"kind": "patch",
"published_at": "2026-05-11T15:27:29Z"
},
{
"tag": "v0.1.16",
"kind": "patch",
"published_at": "2026-05-10T01:50:17Z"
},
{
"tag": "v0.1.15",
"kind": "patch",
"published_at": "2026-05-03T01:46:28Z"
},
{
"tag": "v0.1.14",
"kind": "patch",
"published_at": "2026-04-26T01:28:52Z"
},
{
"tag": "v0.1.13",
"kind": "patch",
"published_at": "2026-04-19T01:25:59Z"
},
{
"tag": "v0.1.12",
"kind": "patch",
"published_at": "2026-04-12T01:23:17Z"
},
{
"tag": "v0.1.11",
"kind": "patch",
"published_at": "2026-04-10T00:39:40Z"
},
{
"tag": "v0.1.10",
"kind": "patch",
"published_at": "2026-04-04T01:31:45Z"
},
{
"tag": "v0.1.9",
"kind": "patch",
"published_at": "2026-04-04T01:29:56Z"
},
{
"tag": "v0.1.8",
"kind": "patch",
"published_at": "2026-04-04T01:22:24Z"
},
{
"tag": "v0.1.7",
"kind": "patch",
"published_at": "2026-04-04T01:20:16Z"
},
{
"tag": "v0.1.6",
"kind": "patch",
"published_at": "2026-04-04T01:16:59Z"
},
{
"tag": "v0.1.5",
"kind": "patch",
"published_at": "2026-04-04T01:15:21Z"
},
{
"tag": "v0.1.4",
"kind": "patch",
"published_at": "2026-04-03T19:33:00Z"
},
{
"tag": "v0.1.3",
"kind": "patch",
"published_at": "2026-04-03T19:14:52Z"
},
{
"tag": "v0.1.2",
"kind": "patch",
"published_at": "2026-04-02T16:48:12Z"
},
{
"tag": "v0.1.1",
"kind": "patch",
"published_at": "2026-04-02T16:43:22Z"
}
],
"recent_commits": [
{
"oid": "711f850fdfc1bd41c5a6ab1ff22fa3cb695b916b",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-07-19T01:22:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "41461d1b4f573c67170cd4031ef90fd0dd3884fb",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-07-12T01:24:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b2580f725f8993f798b4a0a5080ce41c8d87d3fc",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-06-28T02:09:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "657a80056e3028988a86a4e0c17c5e77d622eb73",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-06-21T02:29:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a11d39a15da3c44045c5c11e5fe23eb9deb9f98f",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-06-14T02:28:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5487e531df3125f37d6d632a91755fb17466e635",
"body": "The Schema-Qualified Tables section exists at line 255 between\nForeign Key References and CHECK Constraints, but the TOC was not\nupdated when the section was added. Restore the missing entry so the\nTOC matches the body.",
"is_bot": false,
"headline": "docs(readme): add Schema-Qualified Tables to TOC (#113)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-06-07T20:54:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "103d45e0bc915fd51a6d30e43cf5696db99e8339",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-06-05T16:21:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5f0c301fa2e0be2cbe45dc7ddfed0d6c2cf918f7",
"body": "…) (#112)\n\nSchema manifests evolve, and removing a table from the current TableDef\nslice can leave an orphaned live table with inbound foreign keys to a\nstill-managed table. On MSSQL that orphaned FK blocks the destructive\nrebuild of the current parent (the dbo.GroupMembershipSources -> dbo.Groups\nc\n[…]\n EXISTS no-op on\nabsent tables, and error context on closed connection. MSSQL integration\ntest reproduces the issue's FK-blocking case and asserts the parent\nbecomes droppable after DropRetiredTables.",
"is_bot": false,
"headline": "feat(schema): retired-table tombstones for destructive rebuilds (#111…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-06-05T16:21:22Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "abefb1fb785861f05d4d6ee4e9c07b2fb0843ab8",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-05-31T02:07:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6d64220d11b3c5f4baaf35c11cfb3e0440c1b4cf",
"body": "…108) (#109)\n\n* feat(schema): add FromStruct tag helper for simple TableDef generation (#108)\n\nFromStruct[T](name) derives a *TableDef from a Go struct with `chuck` field\ntags. Intentionally bounded: column name override, nullability, varchar\nsize, primary key, auto-increment, unique, and literal de\n[…]\natches the implementation. New regression tests cover the\ntypoed flag cases, the malformed skip combinations, and the positive\n`name=` rename path.\n\n* fix(schema): satisfy FromStruct lint check (#108)",
"is_bot": false,
"headline": "feat(schema): FromStruct tag helper for simple TableDef generation (#…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-23T13:28:06Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "7d85e28f7367c0209c831e5e25b929b5349699f7",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-05-22T01:15:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aaf6fe0430cd6ad070aabebe4acdc9c21c7d98a7",
"body": "…elete actor (#106) (#107)\n\nReshape the audit-trail API so the four concerns are independent traits\ninstead of one bundled spec, and tables only pay for what they use:\n\n- WithTimestamps() -> CreatedAt, UpdatedAt\n- WithAuditActors(spec) -> CreatedBy, UpdatedBy\n- WithSoftDelete() \n[…]\n, table tests, and README updated to reflect the split. The\nconvenience bundle is shown alongside the explicit composition so callers\ncan pick whichever matches their table's audit shape.\n\nCloses #106",
"is_bot": false,
"headline": "feat(schema,dbrepo): split audit trail into timestamps, actors, and d…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-22T01:14:48Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "dfd1baff38e44cfd288117d9505bc08f1370be30",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-05-22T00:03:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c1458b8c46152f37a0711b3f7086e91e115e31a8",
"body": "* feat(schema,dbrepo): typed audit actor columns via AuditTrailSpec (#104)\n\nReplace the no-arg WithAuditTrail() trait with a spec-driven API so audit\nactor identity can be typed however the caller stores it (free-form string,\ninteger FK to a Users table, UUID, etc.) instead of being hardcoded to\nVAR\n[…]\nt64 actor types.\n\nREADME/examples updated to show both the string preset and a typed\n(int64-FK) actor configuration end-to-end.\n\nCloses #104\n\n* docs(readme): clarify WithAuditTrail trait table wording",
"is_bot": false,
"headline": "feat(schema,dbrepo): typed audit actor columns via AuditTrailSpec (#105)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-22T00:02:55Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "3c798743712e0d20c21bf96e0afa8115ee956fdb",
"body": "…alCase core (#103)\n\nReduce the opt-in metadata ledger to a single ChuckObjectMetadata table with\nfixed PascalCase column names (Owner, ObjectType, ObjectSchema, ObjectName,\nFirstAppliedAtUtc, LastAppliedAtUtc, LastChangedAtUtc, DefinitionHash). Drop\nthe chuck_database_metadata table and the SourceR\n[…]\nifier for the ledger table so the PascalCase\nidentifier renders verbatim on Postgres (which would otherwise camelToSnake\nthe table name). Ownership-notice pointer text and tests/docs updated to\nmatch.",
"is_bot": false,
"headline": "refactor(schema): shrink snapshot metadata ledger to object-only Pasc…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-21T13:00:21Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "b420043f09862407793ed48cb5a8291532f43a3d",
"body": "… enabled (#101)\n\nWhen CodeObjectOptions.OwnershipNotice renders and CodeObjectOptions.Metadata\nis non-nil, the rendered chuck-owned block comment now carries a single-line\n\"Provenance recorded in <table>.\" pointer at the bottom of the notice text.\nThe pointer names the dialect-quoted, schema-qualif\n[…]\n coverage plus per-dialect unit tests\n(metadataNoticePointer for SQLite/Postgres/MSSQL with and without an\nexplicit ledger schema; effectiveOptionsForRender for all four\nnotice/metadata permutations).",
"is_bot": false,
"headline": "feat(schema): owned code-object notice points at metadata ledger when…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-21T12:07:44Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "463c25e822d8b52e201012f4359609b311ca6bac",
"body": "…ode objects (#100)\n\n* feat(schema): opt-in snapshot operational metadata tables for owned code objects\n\nAdd an opt-in snapshot ledger that records provenance for owned views and\nprocedures: first/last applied timestamps, last changed timestamp, current\ndefinition hash, and optional source repo/rev/\n[…]\nller-supplied schema preserved unchanged on all engines.\n\nAdds focused unit coverage for the keying across all three dialects plus\na SQLite end-to-end probe confirming the stored object_schema column.",
"is_bot": false,
"headline": "feat(schema): opt-in snapshot operational metadata tables for owned c…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-21T11:12:56Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "98ad03ed85be2504d3351d93bae2da7c48c12ef4",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-05-20T14:10:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "22e304a933f78313751b055ac42684c76ba4e969",
"body": "…irst (#99)\n\n* refactor(schema): owned code-object comments render OwnershipNotice first\n\nReorder the rendered leading-comment stack on owned ViewDef and ProcedureDef\noutput so the chuck-owned OwnershipNotice block renders first (most prominent\nto DB-side readers), DocPreamble second, and the per-ob\n[…]\nre unchanged: comment-only front matter is still ignored, and\napply-owned tolerance still lets validate pass without markers present live.\n\n* docs(schema): drop plan artifact and stale comment wording",
"is_bot": false,
"headline": "refactor(schema): owned code-object comments render OwnershipNotice f…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-20T14:09:59Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "a25b5e8a18c976ebed52e58440ba26f7112563f9",
"body": "…t (#98)",
"is_bot": false,
"headline": "fix(schema): format code object comments and ignore comment-only drif…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T16:12:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "56b8826b966d76a411877e3e0ed49a8d53770d85",
"body": "…s (#94) (#97)\n\n* feat(schema): explicit rename/tombstone support for owned views and procedures (#94)\n\nAdd WithReplaces(names ...chuck.ObjectName) on ViewDef and ProcedureDef so\ncallers can retire renamed or replaced code objects explicitly without\nunsafe schema-wide pruning.\n\nApply semantics:\n- on\n[…]\nunwrap tests\n(integration is MSSQL-only and follows the same code path).\n\nREADME documents the new lane and the apply / validate semantics.\n\n* docs(readme): caveat stale replacement unwrap on Postgres",
"is_bot": false,
"headline": "feat(schema): explicit rename/tombstone support for owned code object…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T14:58:06Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "3d61489a62365275f37e56ad131fbf93a761d367",
"body": "* chore(audit): plan-015 repo audit artifact\n\nRead-heavy diagnosis pass across root package, schema/, and dbrepo/.\nProduces one prioritized artifact with file refs and severity ratings;\nno code changes. Verified the highest-impact claims by hand (corrected\ntwo agent false positives along the way).\n\n\n[…]\nd the lib/pq + sqlx.Rebind caveats. F8 claim\n\"still claims dialect-agnostic\" is not supported by file text;\nremove the finding and sync executive summary, remaining-findings\nlist, and Lane C grouping.",
"is_bot": false,
"headline": "chore(audit): plan-015 repo audit artifact (#90)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T14:58:02Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "5513eb1ad5d4fe77d99b8ce386e20a991eaa708c",
"body": "Add WithDocAnnotation(text) on ViewDef and ProcedureDef. Unlike\nCodeObjectOptions.DocPreamble (apply-owned, shared, tolerated by\nValidate*WithOptions), the per-object annotation is declaration-owned: it\nrenders into the live SQL between DocPreamble and OwnershipNotice and\nparticipates in body-drift \n[…]\niddle slot, mismatched annotation drift signal, and a SQLite\n integration test exercising the apply/validate/drift round-trip.\n- README documents the third lane and the declaration-owned drift table.",
"is_bot": false,
"headline": "feat(schema): declaration-owned per-object doc annotations (#93) (#96)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T14:44:25Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "641e0abf3313dd16099223478483f551be2b2282",
"body": "…dentifier (#87) (#95)\n\nSQLiteDialect.QuoteIdentifier and PostgresDialect.QuoteIdentifier wrapped\nthe input in double quotes without escaping any embedded \". An\nidentifier like a\"b rendered as \"a\"b\" — a quoted empty identifier\nfollowed by stray tokens, which the parser rejects.\n\nDouble any embedded \" so the rendered identifier conforms to SQL\nquoted-identifier rules (mirrors MSSQL bracket escaping of ] -> ]]).\n\nAdd focused unit assertions to both dialect tests.",
"is_bot": false,
"headline": "fix(dialect): escape embedded double quotes in SQLite/Postgres QuoteI…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T14:30:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "76e3c1b6fcf3bc37c3a2cec9d0296484d4f9d458",
"body": "…t (#89) (#92)\n\nThe helper normalizes both view bodies and procedure definitions for\ndrift comparison. Rename it to a neutral name that matches actual use,\nand update godoc to describe statement normalization rather than view\nbodies only. Behavior unchanged: same trim / trailing-semicolon strip /\ninternal-whitespace collapse.\n\nUpdates the single test function and one explanatory comment that still\nnamed the old helper.",
"is_bot": false,
"headline": "refactor(schema): rename canonicalizeViewBody to canonicalizeStatemen…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T14:09:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "780d134b67fcdf056f52ffabdf8e9b4547dcf74f",
"body": "…als (#91)\n\n* fix(mssql): escape single quotes in CreateTable/DropTable guard literals\n\nCreateTableIfNotExists and DropTableIfExists interpolated the\nbracket-quoted name directly into an OBJECT_ID(N'...') literal.\nA table name containing a single quote terminated the literal\nmid-string and produced \n[…]\nsh remaining cleanup from plan-017 / issue #88:\n- delete tracked root plan.md\n- add plan.md to .gitignore so future scratch files stay local\n\nNo code or test changes; MSSQL fix from 78b85ac unchanged.",
"is_bot": false,
"headline": "fix(mssql): escape single quotes in CreateTable/DropTable guard liter…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T13:53:38Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "741b7380fc01beccfc33198d3972f0201eea2892",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-05-19T13:07:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b74219d6e63cf442863d310cbe0a124adfe6ee30",
"body": "… (#86)\n\nReworks the CodeObjectOptions contract so the ownership notice and an\noptional caller-controlled doc preamble are apply-owned decoration rather\nthan declaration-owned content. Validate*WithOptions strips the exact\nconfigured prefix from live text before canonical comparison and\ntolerates it\n[…]\n- README \"Opt-in ownership notice\" subsection rewritten to describe the\n apply-owned contract, document the render order, and replace the\n same-options-required wording with the new tolerance table.",
"is_bot": false,
"headline": "feat(schema): gate ownership notice to apply-owned code objects (#84)…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T13:06:51Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "d68be3c743dfbc71453d64bbc3772f343033e44b",
"body": "…(#84) (#85)\n\n* feat(schema): opt-in ownership notice for owned views and procedures (#84)\n\nOwned views and procedures can now carry an embedded ownership notice\nso DB-side readers can tell the object is code-owned without forcing\nevery call site to thread a per-definition banner. The notice is\nopt-\n[…]\nt.go: SQLite + MSSQL e2e assertions updated\n- README.md: prose description quotes the new URL form\n\nNo API or behavior change; the const value is the only user-visible\nshift and remains a soft notice.",
"is_bot": false,
"headline": "feat(schema): opt-in ownership notice for owned views and procedures …",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T12:21:16Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "cdd05ce6f74612f0046b77021cc860e921b967eb",
"body": "…#83)\n\nUpdateBuilder previously emitted `SET col = @col` placeholders\nunconditionally via SetClause / SetClauseQ, with no caller-visible way\nto swap in positional placeholders. The @Name token survives\n`database/sql` drivers that translate sql.NamedArg natively\n(go-sqlite3, go-mssqldb, pgx) but it d\n[…]\nchema-qualified table quoting, the\nzero-cols/zero-values edge, the count-mismatch panic, and a regression\nguard that the default @Name path is unchanged. Adds\nExampleUpdateBuilder_SetValues for godoc.",
"is_bot": false,
"headline": "feat(dbrepo): UpdateBuilder.SetValues positional-bind opt-out (#71) (…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T00:30:55Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "82a36c9a4e896fdbd50f144ae96e9df59112b2ae",
"body": "…(#82)\n\n* feat(schema): explicit validate/apply for owned views and procedures\n\nAdds dedicated validate-or-apply helpers for owned views and owned\nprocedures, kept deliberately separate from the table Ensure() / DiffSchema()\ncovenant. Tables remain strict — drift is always an error and nothing is\nau\n[…]\nrives the full path: missing →\nErrViewMissing, applied → ErrViewBodyComparisonUnsupported with\nBodyComparisonSkipped flag set. README comparison table, prose, and\ndrift-error example updated to match.",
"is_bot": false,
"headline": "feat(schema): explicit validate/apply for owned views and procedures …",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-19T00:13:03Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "e7826387b562cd67a661669f0cbcff42b33cfba8",
"body": "…res (#80) (#81)\n\n* feat(schema): first-class ProcedureDef for owned MSSQL stored procedures (#80)\n\nAdds ProcedureDef alongside ViewDef so MSSQL refresh / migration\nentrypoints stop being raw checked-in .sql outside chuck ownership.\n\n- NewProcedure / NewQualifiedProcedure / WithSchema / Schema / Bod\n[…]\n schema/integration_test.go comments. The\n intent (parameters belong between the name and AS) survives without\n the PR-history reference, which would only rot post-merge.\n\nNo behavior or API change.",
"is_bot": false,
"headline": "feat(schema): first-class ProcedureDef for owned MSSQL stored procedu…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-18T23:48:07Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "ab41566879e1159aa37a2e46e31ef871e9851ced",
"body": "Tables, indexes, foreign keys, and seed data are already declarative in\nchuck/schema, but views were a permanent raw-SQL exception: apps had to\nkeep adjacent CREATE VIEW string constants and wire separate drop/create\ninto bootstrap, splitting ownership across files. Adding a new owned\nview silently \n[…]\ndempotent\n drop end-to-end against in-memory SQLite to catch surface-level\n rendering breakage that pure string tests would miss\n- README adds an Owned Views section under the schema ownership group",
"is_bot": false,
"headline": "feat(schema): first-class ViewDef for owned-view lifecycle (#76) (#79)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-15T14:10:37Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "3e671e09c600d9e6214d33940fa9c859dfc58c41",
"body": "Inline FKs declared via chuck/schema emit auto-generated constraint names\non MSSQL (e.g. FK__Goals__AgentID__1234ABCD). DropOrder solves table\nordering, but DROP TABLE still fails while an inbound FK pins the table.\nApps that use chuck/schema as canonical ownership had to maintain a\nhandwritten FK-d\n[…]\nh an inline FK, asserts a naive DROP TABLE on the parent fails\n while the FK is in place, then exercises DropInboundForeignKeys +\n DropOrder to prove the destructive rebuild path succeeds end-to-end",
"is_bot": false,
"headline": "feat(schema): MSSQL inbound foreign-key teardown helper (#77) (#78)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-15T14:07:04Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "20d832ae40a7ffe7caa67584d18874b52affb120",
"body": "* feat(dbrepo): first-class schema-qualified table references (#73)\n\nAdds qualified-table rendering to the dbrepo query builders. Builders now\naccept schema-qualified strings (\"sg.SalesAgents\") and render each part\nthrough the dialect's quoting, including alias forms. SQLite drops the\nschema compone\n[…]\nM through quoteJoinTarget instead so the same parser that already\nhandles JOIN aliases is reused. Passthrough for derived tables and raw\nsubqueries is preserved by the existing ambiguous-shape branch.",
"is_bot": false,
"headline": "feat(dbrepo): first-class schema-qualified table references (#73) (#75)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-11T18:02:55Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "68cb1e7e9c799fb6873896a2004dfa54c474aa9d",
"body": "* feat(schema): first-class schema-qualified table support (#72)\n\nAdds structured ObjectName identity for tables and foreign-key targets so\nschema-qualified declarations like sg.SalesAgents render and inspect\ncorrectly across MSSQL, Postgres, and SQLite without dotted-string parsing.\n\n- chuck.Object\n[…]\nity\n fails fast with ErrSQLiteSchemaCollision when bare names collide\n- README documents WithSchema, ReferencesQualified, SQLite fallback\n\n* fix(ci): remove lint leftovers and ignore local tmux state",
"is_bot": false,
"headline": "feat(schema): first-class schema-qualified table support (#72) (#74)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-05-11T15:25:33Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "86515a1f62cb9aaf6cbdcbf7252b72a5a3efb90d",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-05-10T01:47:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b6fa0168949236af42546d376961c89e436c1e52",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-05-03T01:43:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2bf500bcbfefc0fe395167eed361fa0f000f55db",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-04-26T01:25:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f274eb1f7b7cafcf3c1d385e82b522596956cd46",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-04-19T01:23:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "27e68429607e012124856743b526f3ac81e7ca8a",
"body": "…(#70)\n\nRecognize nextval(...) as a sequence-backed default and canonicalize\nit to the empty string so a declared column with no explicit default\nmatches a live column whose default is the implicit sequence created\nby SERIAL, BIGSERIAL, or INTEGER PRIMARY KEY.\n\nPattern matching is engine-agnostic in implementation but Postgres-\nspecific in practice; SQLite and MSSQL live snapshots never produce\nnextval(...) defaults.\n\nFixes #65.",
"is_bot": false,
"headline": "fix: normalize Postgres sequence-backed defaults in drift comparator …",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-10T00:36:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f92322da778acc38657a5d4274bc76239303a1de",
"body": "Run both declared and live index column lists through the active\ndialect's NormalizeIdentifier before comparing. Postgres lowercases\nunquoted PascalCase identifiers to snake_case, so a declared index on\n\"Name\" matches a live index on \"name\" without engine-specific logic.\nSQLite and MSSQL NormalizeIdentifier are identity, so case-preserving\nengines see no behavior change.\n\nError messages still show the user's original declared and live\nstrings on real drift.\n\nPart of #65.",
"is_bot": false,
"headline": "fix: normalize index column identifiers in drift comparator (#69)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-10T00:27:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b4e153996f9059d63e580fdd589adf4ba8166ace",
"body": "…(#68)\n\nMatch live single-column unique indexes against declared column-level\nUNIQUE constraints (ColumnDef.Unique and single-column\nTableDef.UniqueColumns). When a live unique index covers exactly one\ndeclared unique column, skip it instead of reporting as unexpected\ndrift. Uses column-set matching, not name-pattern matching, so\nPostgres `<table>_<col>_key` and MSSQL `UQ__<prefix>__<hash>` both\nwork without engine-specific logic.\n\nPart of #65.",
"is_bot": false,
"headline": "fix: ignore implicit unique-constraint-backed indexes in drift check …",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-10T00:16:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5823c7832e15aacdefb164b3792972455c1062c3",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-04-10T00:01:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0a867bcc9ab60575ec7ffc8b7dcb4fc6fb09229b",
"body": "Extend the MSSQL INFORMATION_SCHEMA.COLUMNS query to read\nCHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, and NUMERIC_SCALE\nalongside DATA_TYPE, and rebuild the live type string so\nVARCHAR(n), NVARCHAR(n), NVARCHAR(MAX), DECIMAL(p,s), etc. match\nthe declared types from Snapshot(). This removes the primary\nsource of false-positive drift in TestSchemaDriftMSSQL.\n\nPart of #65.",
"is_bot": false,
"headline": "fix: reconstruct parameterized MSSQL column types in live snapshot (#67)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-10T00:01:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e52a7e5e819f30f78ef7b3e822045786433ee94b",
"body": "- colName now rejects override identifiers that fail validIdentifier\n (the same rule used by Search) and falls back to the default\n column. Helpers NotDeleted, HasStatus, HasParent, etc. inherit\n this behavior without signature changes.\n- OpenSQLite and openSQLiteFromURL now share a single setup helper\n so URL-based SQLite opens apply WAL mode, busy_timeout=30000,\n the conservative connection pool, and directory creation.\n\nFixes #59\nFixes #61",
"is_bot": false,
"headline": "fix: validate WhereBuilder override columns and share SQLite setup (#64)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-09T22:02:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7e64b7bed211c3684c17769a0cf0320cb8c6fa9e",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-04-09T21:13:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3a69f7ef537777b12cf728bd6ab17588d63b3445",
"body": "* fix: support aliased JOIN targets and tolerant column spacing\n\n- Parse JOIN targets into base table and optional alias (bare and AS\n forms) so dialect quoting only applies to the table identifier.\n- Split column lists on comma then trim whitespace per token, removing\n the dependency on a single \n[…]\nitTypeParams for gocritic unnamedResult.\n- Add explanations to two nolint:errcheck directives in writeDiffs.\n\nPre-existing lint violations surfaced by golangci-lint v2.11.4 blocking\nCI on this branch.",
"is_bot": false,
"headline": "fix: aliased JOIN quoting and tolerant column spacing (#63)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-09T21:13:07Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "2f692f7ae4818d3a804bc1572987d8da0e5acd26",
"body": null,
"is_bot": false,
"headline": "docs: add screenshot above TOC in README (#58)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T19:22:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9321a8501b63c79b6b856e355b86affdf8185323",
"body": null,
"is_bot": false,
"headline": "docs: updates readme",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-07T17:45:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9ab4679dbb7c95e64193bde54747bbc064d3136e",
"body": "…utput (#57)\n\nSnapshotString unconditionally appended PRIMARY KEY and AUTO INCREMENT\ntext even when those keywords already appeared in the column type string\n(e.g. SERIAL PRIMARY KEY, INTEGER PRIMARY KEY AUTOINCREMENT). This\nproduced duplicated output like \"SERIAL PRIMARY KEY PRIMARY KEY AUTO\nINCREM\n[…]\nhecks whether the type string already contains the relevant\nkeywords before appending, including suppressing AUTO INCREMENT when the\ntype contains SERIAL (Postgres implicit auto-increment).\n\nFixes #56",
"is_bot": false,
"headline": "fix: avoid duplicate PRIMARY KEY / AUTO INCREMENT in SnapshotString o…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T16:41:44Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "ebc53d830aa46355e86c78f26a315e2d79cebb69",
"body": "…avior (#55)\n\n- Fix DiffSchema field docs: add ChangedIndexes, expand ChangedColumns description\n- Fix dbrepo Q function examples: show normalized Postgres output (snake_case)\n- Fix snapshot example: match actual SnapshotString output format\n- Fix LiveSnapshot description: mention index columns, uni\n[…]\nDeleteBuilder examples: WHERE clause uses raw names, not quoted\n- Fix SelectBuilder docs: mention normalization alongside quoting\n- Fix dbrepo doc comments: show normalized Postgres output\n\nCloses #52",
"is_bot": false,
"headline": "docs: fix stale README examples against current schema and dbrepo beh…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T15:42:12Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "b909ebfbc3c39f5ea9f2514c606f60e309ae0aed",
"body": "…hema (#54)\n\nAdd doc comments to DiffSchema and ValidateSchema listing the dimensions\nthey compare (columns, indexes) and what they do not yet cover (unique\nconstraints, primary keys, foreign keys, CHECK constraints). Add a\ncorresponding \"Drift Detection Coverage\" section to the README.\n\nCloses #51",
"is_bot": false,
"headline": "docs: document drift detection coverage for DiffSchema and ValidateSc…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T15:38:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bf1340195ece18606c9e34b50c22ae1c7002f618",
"body": "PrimaryKey() set the pk metadata field but ddl() never checked it,\nso Col(\"id\", TypeInt()).PrimaryKey() produced DDL without PRIMARY KEY.\nAdd a pk check in ddl() after the type string, skipping if the type\nalready contains PRIMARY KEY (as with AutoIncrCol and UUIDPKCol).\n\nFixes #47",
"is_bot": false,
"headline": "fix: emit PRIMARY KEY in DDL when ColumnDef.PrimaryKey() is used (#49)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T15:08:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e531e142e58a5fd07574d00f8e6d319568b29987",
"body": "Add a second pass in ValidateSchema that detects indexes present in the\nlive database but not declared in the schema, mirroring the existing\nbehavior in DiffSchema. Also narrow the SQLite live index query to only\ninclude user-created indexes (origin = 'c'), excluding auto-generated\nindexes from UNIQUE constraints that would cause false positives.\n\nCloses #42",
"is_bot": false,
"headline": "fix: report extra live indexes in ValidateSchema (#46)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:56:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "196715f0a6889bd579086b736fce0065dae991fd",
"body": "…espace (#45)\n\nAdd pg_namespace join to both the column query and index query in\nlive_snapshot.go so that pg_class lookups are constrained to the public\nschema. Without this, tables with the same name in different schemas\ncould produce incorrect results.\n\nCloses #41",
"is_bot": false,
"headline": "fix: scope Postgres introspection queries to public schema via pg_nam…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:55:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a2935bafe229420a17fbf16240300e26aae77b53",
"body": "The EnsureError.Error() method listed all drift categories except\nChangedIndexes, so index property changes (columns, uniqueness, WHERE\nclause) were silently omitted from error messages. Add the missing\nblock and corresponding tests.\n\nCloses #43",
"is_bot": false,
"headline": "fix: include ChangedIndexes in EnsureError.Error() summary (#44)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:55:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2e96f1a418564be4bbbd2bc97ee947cce1419add",
"body": "…#40)\n\nReplace UPPER(data_type) from information_schema.columns with\nUPPER(format_type(atttypid, atttypmod)) from pg_attribute in the\nPostgres live snapshot query. format_type preserves length, precision,\nand scale (e.g., CHARACTER VARYING(255) instead of CHARACTER VARYING).\n\nAdd normalizePostgresAl\n[…]\n(n) <-> CHARACTER VARYING(n)\n- TIMESTAMPTZ <-> TIMESTAMP WITH TIME ZONE\n- NUMERIC(p,s) <-> DECIMAL(p,s)\n- SERIAL <-> INTEGER, BIGSERIAL <-> BIGINT\n- BOOL <-> BOOLEAN, INT <-> INTEGER, etc.\n\nCloses #35",
"is_bot": false,
"headline": "fix: resolve false Postgres drift mismatches for type introspection (…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:36:50Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "20f17eda862ea33e72ee4c1af4c359b8524bfed5",
"body": "…query (#39)\n\nThe MSSQL index subquery in queryIndexesMSSQL was missing two critical\nclauses: it did not exclude included (non-key) columns and did not\norder by key_ordinal. This caused index drift comparisons to include\nspurious columns and produce non-deterministic column ordering.\n\nAdd ic.is_included_column = 0 filter and ORDER BY ic.key_ordinal to\nthe subquery. Extract the query as a package-level variable for\ntestability and add unit tests verifying both clauses are present.\n\nFixes #37",
"is_bot": false,
"headline": "fix: filter included columns and order by key_ordinal in MSSQL index …",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:36:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "043182f7775e65e7d6066442e55e768c339cf9ac",
"body": "… (#38)\n\nnormalizeDefault was lowercasing the entire expression including string\nliteral contents, causing 'Admin' and 'admin' to compare as equal.\nNow only non-quoted segments are lowercased, preserving case inside\nsingle-quoted string literals while still normalizing SQL keywords.\n\nFixes #36",
"is_bot": false,
"headline": "fix: preserve case-sensitive default literals during drift comparison…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:36:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7950feba671857d0f536e0887121534a27864e95",
"body": "SelectBuilder, UpdateBuilder, DeleteBuilder, and fragment helpers\n(ColumnsQ, SetClauseQ, InsertIntoQ, BulkInsertInto, UpsertIntoQ) all\ncalled QuoteIdentifier without first calling NormalizeIdentifier. This\ncaused PascalCase names like \"Users\" to be quoted as-is on Postgres\ninstead of being lowercased to \"users\", creating a mismatch with the\nschema package which normalizes correctly.\n\nFixes #29",
"is_bot": false,
"headline": "fix: normalize identifiers before quoting in dbrepo builders (#34)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:22:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "759a8fee1e8172a66f181acc40ee1071c1f573d7",
"body": "LiveIndexSnapshot now captures parsed columns ([]string), uniqueness\n(bool), and WHERE clause (string) matching the declared IndexSnapshot\nfields. Per-dialect queryIndexes implementations:\n\n- SQLite: uses pragma_index_info for columns, pragma_index_list for\n unique flag, and sqlite_master SQL parsi\n[…]\n, sys.index_columns for columns,\n and filter_definition for filtered indexes\n\nDiffSchema and ValidateSchema now compare index columns, uniqueness,\nand WHERE clauses — not just index names.\n\nFixes #28",
"is_bot": false,
"headline": "feat: enrich live index snapshots for reliable drift detection (#33)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:22:37Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "7982f19b41cd70fa2c8d09f45ab268c17574c3f9",
"body": "…ismatches (#32)\n\nDiffSchema and ValidateSchema previously only compared column presence,\nnullability, and index names. This extends both to detect type mismatches\nand default value mismatches between declared and live schemas.\n\n- Add Mismatches, DeclaredDefault, and LiveDefault fields to ColumnDiff\n[…]\nues\n- Add type and default mismatch validation errors to ValidateSchema\n- Add tests for type mismatch, default mismatch, multiple mismatches,\n and auto-increment false positive prevention\n\nCloses #27",
"is_bot": false,
"headline": "feat: expand drift detection to cover type, default, and constraint m…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:22:21Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "d5b5e5a28479240760f38c5b989edfc2ea5993dd",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:20:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b81f9127b0310b53de0b0434e977990b272709fd",
"body": "The sqlite:///:memory: URL form was broken because TrimPrefix left a\nleading slash, producing /:memory: which SQLite treated as a filesystem\npath. Strip the URI path separator for the :memory: special name while\npreserving leading slashes for absolute file paths.\n\nCloses #30",
"is_bot": false,
"headline": "fix: handle sqlite:// three-slash URI form for :memory: (#31)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-07T14:20:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a9ac5e5dfa9f9773da5686ad56ab219560e5f7b6",
"body": null,
"is_bot": false,
"headline": "docs: add collapsible Mermaid architecture diagram to README (#26)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T02:45:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6b87539c6634ac89376de2ec8d3a3ad8e347cb95",
"body": "Documents all features added in PRs #16-25: CHECK constraints, typed\nSeedValues, table dependency ordering, unique/partial indexes,\nUPDATE/DELETE builders, JOIN composition, bulk INSERT, UPSERT, expression\nhelpers (IsNull, Concat), DiffSchema, and Ensure with Strict/Dev/DryRun\nmodes. Restores full Grug quotes and manifesto voice throughout.",
"is_bot": false,
"headline": "docs: rewrite README with full feature coverage and manifesto flavor",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-04T02:30:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6a477bd973c92fa437e9cfb324320f11459d66fd",
"body": "Adds DiffSchema/DiffAll for structured, JSON-serializable schema drift\ndetection, and Ensure with three modes: ModeStrict (validate only),\nModeDev (auto-create missing tables + seed), and ModeDryRun (report\nwithout changes). Supports diff output to io.Writer or file path.\n\nCloses #2",
"is_bot": false,
"headline": "feat: add structured schema diff and mode-based Ensure function (#25)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T02:17:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5bf01d18887a93182e24308710ff2918fded503b",
"body": "Add two new methods to the QueryWriter interface where SQL syntax\ngenuinely diverges across engines:\n\n- IsNull(col, fallback): COALESCE (Postgres), IFNULL (SQLite), ISNULL (MSSQL)\n- Concat(parts...): || operator (Postgres/SQLite), + operator (MSSQL)\n\nString literals (single-quoted) pass through without identifier quoting.\nCurrentTimestamp is skipped as Now() already covers that mapping.\n\nCloses #15",
"is_bot": false,
"headline": "feat: add IsNull and Concat dialect-aware expression helpers (#24)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T01:28:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7d098ca84a8bd1b33c384a56ccd2253ace9e627c",
"body": "Extend IndexDef to support unique indexes, partial (filtered) indexes,\nand combined unique+partial indexes across all three dialects (Postgres,\nSQLite, MSSQL).\n\nNew constructors: UniqueIndex, PartialIndex, UniquePartialIndex, plus a\nWhere() method for attaching filter conditions. Snapshot and\nSnapshotString output now includes uniqueness and WHERE metadata.\n\nCloses #7",
"is_bot": false,
"headline": "feat: add unique and partial index support (#23)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T01:28:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1403523d906556ae9c08ff592084f51cd0d6f73c",
"body": "Add Join() and LeftJoin() methods to SelectBuilder for composing\nmulti-table queries. JOIN clauses appear between FROM and WHERE in\ngenerated SQL. Table names in JOIN clauses are dialect-quoted; ON\nconditions pass through as raw SQL. Dot-qualified column names\n(Table.Column) are quoted per-part when a dialect is set.\n\nCountQuery() also includes JOIN clauses for accurate counts.\n\nCloses #4",
"is_bot": false,
"headline": "feat: add JOIN composition on SelectBuilder (#22)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T01:28:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a081f0a7a6fc6dd356d2316e9226cb0f02b05c97",
"body": "Add dialect-aware Upsert method to DDLWriter interface and implement\nacross all three dialects:\n- Postgres/SQLite: INSERT INTO ... ON CONFLICT (key) DO UPDATE SET ...\n- MSSQL: MERGE ... USING ... ON ... WHEN MATCHED/NOT MATCHED ...\n\nAdd UpsertInto and UpsertIntoQ helpers in dbrepo that automatically\nbuild the conflict/update clauses from column lists, using EXCLUDED\nreferences for Postgres/SQLite and Source references for MSSQL.\n\nCloses #9",
"is_bot": false,
"headline": "feat: add UPSERT builder (INSERT ... ON CONFLICT DO UPDATE) (#21)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T01:20:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4d138ce678b86d2722d2a092ea9ec3e27de393b5",
"body": "…rs (#20)\n\nAdds BulkInsertInto(dialect, table, cols, rowCount) to the dbrepo\npackage. It generates multi-row INSERT statements using the dialect's\npositional placeholder style ($1/$2 for Postgres, ? for SQLite,\n@p1/@p2 for MSSQL) and quoted identifiers.\n\nParameter limit enforcement is left to the caller, with limits\ndocumented in the function comment.\n\nCloses #5",
"is_bot": false,
"headline": "feat: add BulkInsertInto for multi-row INSERT with dialect placeholde…",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T01:18:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "13c5f420f16af843ff1c1cef1bdab43087ceb09b",
"body": "Add SeedValues type that accepts Go values (string, int, float64, bool,\nnil) and converts them to dialect-appropriate SQL literals automatically.\nIncludes SQLExpr escape hatch for raw SQL expressions. SeedValues works\nalongside the existing SeedRow API for backward compatibility.\n\nCloses #11",
"is_bot": false,
"headline": "feat: add typed SeedValues API for Go-value seed data (#19)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T01:14:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "099f469b408c829e18feb1a1b77ef13f04dd7004",
"body": "Add a .Check(expr string) method on ColumnDef that adds inline CHECK\nconstraints to column definitions. The CHECK expression is raw SQL,\nrendered in DDL output for all three dialects (Postgres, SQLite, MSSQL).\nCHECK constraints also appear in snapshots (struct, JSON, and string).\n\nCloses #6",
"is_bot": false,
"headline": "feat: add CHECK constraint support to column builder (#18)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T01:14:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a99c841196c21a254a83376fdd45d29597374799",
"body": "Adds composable query builders for UPDATE and DELETE statements,\nmatching the existing SelectBuilder patterns. Both support WhereBuilder\nintegration, dialect-aware identifier quoting, and RETURNING clauses\nfor Postgres/SQLite.\n\nCloses #3",
"is_bot": false,
"headline": "feat: add UpdateBuilder and DeleteBuilder to dbrepo package (#17)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T01:13:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ae35757eb7833ba9b21de4e8c19be850f211d505",
"body": "Implements CreationOrder and DropOrder functions that topologically sort\ntables by foreign key references so parents are created before children\n(and dropped in reverse). Includes cycle detection and graceful handling\nof self-referential tables.\n\nCloses #10",
"is_bot": false,
"headline": "feat: add table dependency ordering via topological sort (#16)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-04T01:13:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ffe4b9d99067531c754eaf0a59df565d6fc2d79e",
"body": null,
"is_bot": false,
"headline": "docs: adds TOC to readme",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-03T19:31:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1da75e6a96db6d2308d201238ecd251ae4eb2cf8",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-04-03T19:11:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7c9c5b259201c4a533386af27c5bd2a333cf2dd3",
"body": "Split driver/sqlite into build-tagged files so that CGO_ENABLED=1\nuses mattn/go-sqlite3 (C-backed) and CGO_ENABLED=0 uses\nncruces/go-sqlite3 (pure Go). Same import path, zero consumer changes.",
"is_bot": false,
"headline": "feat: add pure-Go SQLite driver for CGO_ENABLED=0 builds (#1)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-03T19:11:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6e734d76228a2ef3741cdb79774c17e25d087c38",
"body": null,
"is_bot": false,
"headline": "fix screenshot extension in README",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-02T16:45:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "063f31d0d2ab277157547d57d3d6110e3407d4b5",
"body": null,
"is_bot": false,
"headline": "rename fraggle to chuck",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-02T16:40:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6ac1a19e146e9ce29dcb50fcec749209dadaa82b",
"body": null,
"is_bot": false,
"headline": "chore: remove Fraggle Rock references from README",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-02T14:28:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "59fbfd703f8dc55d8ef74595d998e5cc90be8765",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-04-02T13:43:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9a87cdfc7bd5cdb9bc66c482cd8ccd832cb5a951",
"body": null,
"is_bot": false,
"headline": "ci: auto-close CI issues on pipeline success",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-02T13:43:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9fdfbe17bf473c75d8d4a4e515256b502577fb69",
"body": null,
"is_bot": false,
"headline": "chore: add LICENSE and .gitignore",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-02T01:47:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8a2273dda889bfaa1fc461de5bfe95ac45a33992",
"body": null,
"is_bot": false,
"headline": "fix: reword test comments to satisfy gocritic linter",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-02T00:52:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "553f5e9084960778451075697dd922f5a7bc7527",
"body": null,
"is_bot": false,
"headline": "chore: lowercase README title",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-02T00:39:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "20e6a6785f26acab4833cf6731c510a4c204fc34",
"body": null,
"is_bot": false,
"headline": "test: improve test coverage",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-02T00:11:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e330e4a648566323df51a519525a7c731e0ed49a",
"body": null,
"is_bot": false,
"headline": "chore: replace ecosystem diagram with library architecture",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-01T22:01:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d3e6906ddcefd6e57a8627402ecde0016bc94680",
"body": null,
"is_bot": false,
"headline": "chore: add architecture diagram with ecosystem context",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-01T21:13:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b83cbd0eb5ec1534ad44df9de7b6ad2d22886644",
"body": null,
"is_bot": false,
"headline": "chore: add more manifesto flavor to README",
"author_name": "Joshua Tye",
"author_login": "catgoose",
"committed_at": "2026-04-01T21:01:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fc266c7ef442a225dd3a3dce25868e6d69cb795f",
"body": "Split the monolithic 30-method Dialect interface into five focused\nsub-interfaces (TypeMapper, DDLWriter, QueryWriter, Identifier,\nInspector) composed back into Dialect for backwards compatibility.\n\nNarrow function signatures where possible: QuoteColumns accepts\nIdentifier, dbrepo ColumnsQ/SetClauseQ/InsertIntoQ accept Identifier.\n\nAdd compile-time interface checks for all three dialect implementations.",
"is_bot": false,
"headline": "refactor: split Dialect interface into composable sub-interfaces (#28)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-01T20:45:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "957bed414c1d71d82a9a15ef4a51bb9df52a20f3",
"body": null,
"is_bot": false,
"headline": "fix: remove Dothog Manifesto attribution suffix from README quotes (#27)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-01T20:20:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a744584e4e739ff26783c0ee3c5012e4093a2118",
"body": "Sprinkle relevant Manifesto quotes into the Why section,\nDialect Interface, and Schema as Code sections.",
"is_bot": false,
"headline": "Add Dothog Manifesto flavor to README (#26)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-01T20:16:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7c6dfea65ba7191f5efcd8c08aa7e26aa718d32e",
"body": null,
"is_bot": false,
"headline": "docs: add Why section with before/after comparison to README (#25)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-01T20:11:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f831bb2328f5233829204e7a7be33913af45d90b",
"body": null,
"is_bot": false,
"headline": "docs: replace old HTML screenshot with standard markdown image (#24)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-04-01T00:21:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "42fab02801463661d446f1eab775373d16b3e8d5",
"body": null,
"is_bot": false,
"headline": "docs: add Go Reference and License badges to README (#23)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-03-31T23:57:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "18fa7105954f1ff84a45117d02d1343e92c07fff",
"body": null,
"is_bot": false,
"headline": "chore: update Go dependencies and Go version [skip ci]",
"author_name": "catgoose",
"author_login": "catgoose",
"committed_at": "2026-03-31T23:43:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bb76ba1c0a5a71d13e05e638b704fdd0d3e48c08",
"body": "Add example_test.go files across all three packages (fraggle, schema,\ndbrepo) with runnable examples covering dialects, table definitions,\ntraits, table factories, query builders, where filters, audit helpers,\nsnapshots, and seed data. Document ReturningClause, QuoteColumns, and\nOr/OrIf in the README.",
"is_bot": false,
"headline": "feat: add runnable Go examples and document missing API surface (#22)",
"author_name": "Meow Honk",
"author_login": "catgoose",
"committed_at": "2026-03-31T23:43:25Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 51,
"commits_last_year": 113,
"latest_release_at": "2026-07-19T01:25:32Z",
"latest_release_tag": "v0.1.51",
"releases_from_tags": false,
"days_since_last_push": 6,
"active_weeks_last_year": 16,
"days_since_latest_release": 6,
"mean_days_between_releases": 5.4
},
"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": "github.com/catgoose/chuck",
"exists": true,
"license": null,
"keywords": [],
"ecosystem": "go",
"matches_repo": true,
"registry_url": "https://pkg.go.dev/github.com/catgoose/chuck",
"is_deprecated": false,
"latest_version": "v0.1.51",
"repository_url": "https://github.com/catgoose/chuck",
"versions_count": 52,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": null,
"first_published_at": null,
"latest_published_at": "2026-07-19T01:22:21Z",
"latest_version_yanked": null,
"days_since_latest_publish": 6
}
]
},
"popularity": {
"forks": 0,
"stars": 1,
"watchers": 0,
"fork_history": {
"days": [],
"complete": true,
"collected": 0,
"total_forks": 0
},
"star_history": null,
"open_issues_and_prs": 1
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": false,
"has_mcp_signal": false,
"bootstrap_files": [
"Makefile"
],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [
"go.mod"
],
"largest_source_bytes": 43648,
"source_files_sampled": 78,
"oversized_source_files": 0,
"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/denisenkom/go-mssqldb",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v0.12.3"
},
{
"name": "github.com/lib/pq",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v1.12.3"
},
{
"name": "github.com/mattn/go-sqlite3",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v1.14.48"
},
{
"name": "github.com/ncruces/go-sqlite3",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v0.35.2"
},
{
"name": "github.com/stretchr/testify",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v1.11.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": 1,
"merged_prs": 58,
"open_issues": 0,
"closed_ratio": 1,
"closed_issues": 54,
"closed_unmerged_prs": 0
},
"bus_factor": 1,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "catgoose",
"commits": 113,
"avatar_url": "https://avatars.githubusercontent.com/u/21010072?v=4"
}
],
"contributors_sampled": 1,
"top_contributor_share": 1
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"main.yml",
"pages.yml",
"pr.yml"
],
"has_docs_dir": false,
"linter_configs": [
".golangci.yml"
],
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": false
},
"security_signals": {
"lockfiles": [
"go.sum"
],
"scorecard": {
"checks": [
{
"name": "Binary-Artifacts",
"score": 10,
"reason": "no binaries found in the repo",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
},
{
"name": "Branch-Protection",
"score": 0,
"reason": "branch protection not enabled on development/release branches",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 10,
"reason": "19 out of 19 merged PRs checked by a CI test -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
},
{
"name": "CII-Best-Practices",
"score": 0,
"reason": "no effort to earn an OpenSSF best practices badge detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
},
{
"name": "Code-Review",
"score": 0,
"reason": "Found 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": 0,
"reason": "project has 0 contributing companies or organizations -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": 10,
"reason": "no dangerous workflow patterns detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 0,
"reason": "no update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 10,
"reason": "30 commit(s) and 16 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": 1,
"reason": "dependency not pinned by hash detected -- score normalized to 1",
"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": 9,
"reason": "1 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "711f850fdfc1bd41c5a6ab1ff22fa3cb695b916b",
"ran_at": "2026-07-25T13:53:02Z",
"aggregate_score": 4,
"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-19T01:22:23Z",
"oldest_open_prs": [
{
"number": 110,
"created_at": "2026-05-23T14:39:08Z",
"last_comment_at": null,
"last_comment_author": null
}
],
"last_merged_pr_at": "2026-06-07T20:54:13Z",
"ci_last_conclusion": null,
"oldest_open_issues": []
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/catgoose/chuck",
"host": "github.com",
"name": "chuck",
"owner": "catgoose"
},
"metrics": {
"overall": {
"key": "overall",
"band": "moderate",
"name": "Overall health",
"note": null,
"notes": [],
"value": 57,
"inputs": {
"security": 40,
"vitality": 85,
"community": 24,
"governance": 58,
"engineering": 66
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "excellent",
"name": "Vitality",
"value": 85,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "good",
"name": "Development activity",
"note": null,
"notes": [],
"value": 75,
"inputs": {
"commits_last_year": 113,
"human_commit_share": 1,
"days_since_last_push": 6,
"active_weeks_last_year": 16
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 6 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "push_recency",
"params": {
"days": 6
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "16/52 weeks with commits",
"points": 11.1,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 16
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "113 commits in the last year",
"points": 18,
"status": "met",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 113
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "30 commit(s) and 16 issue activity found in the last 90 days -- score normalized to 10",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "excellent",
"name": "Release discipline",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 100,
"inputs": {
"releases_count": 51,
"latest_release_tag": "v0.1.51",
"releases_from_tags": false,
"days_since_latest_release": 6,
"mean_days_between_releases": 5.4
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "51 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 51
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 6 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "release_recency",
"params": {
"days": 6
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~5.4 days",
"points": 27,
"status": "met",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 5.4
}
}
],
"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": "unverified",
"guards": [],
"signals": [],
"red_flag": false,
"multiplier_pct": 100,
"declared_reason": null,
"unverified_reason": "repository_too_young",
"unanswered_open_prs": null,
"unanswered_open_issues": null,
"days_since_last_merged_pr": null,
"days_since_last_human_commit": null,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "maintenance record not established from the collected data",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_unverified",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "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": "moderate",
"name": "Sustainability & Governance",
"value": 58,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "critical",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 10,
"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 0 contributing companies or organizations -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "excellent",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 85,
"inputs": {
"merged_prs": 58,
"open_issues": 0,
"closed_issues": 54,
"issue_closed_ratio": 1,
"closed_unmerged_prs": 0
},
"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": "58/58 decided PRs merged",
"points": 38.2,
"status": "met",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 58,
"decided": 58
}
}
],
"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": "moderate",
"name": "Ownership & stewardship",
"note": "Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"verified_domain"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 57,
"inputs": {
"followers": 32,
"owner_type": "User",
"is_verified": null,
"owner_login": "catgoose",
"public_repos": 82,
"account_age_days": 3632
},
"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": "32 followers of catgoose",
"points": 10.9,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 32,
"login": "catgoose"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "82 public repos, account ~9 yr old",
"points": 25,
"status": "met",
"details": [
{
"code": "public_repos",
"params": {
"count": 82
}
},
{
"code": "account_age_years",
"params": {
"years": 9
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "excellent",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"github.com/catgoose/chuck"
],
"ecosystems": "go",
"any_deprecated": false,
"min_days_since_publish": 6
},
"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 6 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 6
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "52 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 52
}
}
],
"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": "good",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 84,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "3 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 3
}
}
],
"max_points": 24
},
{
"key": "tests_present",
"name": "Tests present",
"detail": null,
"points": 24,
"status": "met",
"details": [],
"max_points": 24
},
{
"key": "linter_config",
"name": "Linter config",
"detail": ".golangci.yml",
"points": 16,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": ".golangci.yml"
}
}
],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 9.6
},
{
"key": "editorconfig",
"name": ".editorconfig",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "19 out of 19 merged PRs checked by a CI test -- score normalized to 10",
"points": 20,
"status": "met",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "at_risk",
"name": "Documentation",
"note": null,
"notes": [],
"value": 40,
"inputs": {
"topics": [],
"has_wiki": false,
"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": null,
"points": 0,
"status": "missed",
"details": [],
"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": "at_risk",
"name": "Security",
"value": 40,
"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": 40,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 16,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 2,
"scorecard_aggregate": 4
},
"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": "19 out of 19 merged PRs checked by a CI test -- score normalized to 10",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "cii_best_practices",
"name": "CII-Best-Practices",
"detail": "no effort to earn an OpenSSF best practices badge detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "code_review",
"name": "Code-Review",
"detail": "Found 0/30 approved changesets -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 0 contributing companies or organizations -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no dangerous workflow patterns detected",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "dependency_update_tool",
"name": "Dependency-Update-Tool",
"detail": "no update tool detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "30 commit(s) and 16 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 1",
"points": 0.5,
"status": "partial",
"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": "1 existing vulnerabilities detected",
"points": 6.8,
"status": "partial",
"details": [],
"max_points": 7.5
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "moderate",
"name": "AI Readiness",
"value": 66,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "at_risk",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 40,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.98,
"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": "98 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 40,
"status": "met",
"details": [
{
"code": "legible_history",
"params": {
"legible": 98,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "good",
"name": "Verify loop (build / test / typecheck)",
"note": null,
"notes": [],
"value": 73,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [
"go.sum"
],
"has_dockerfile": false,
"typed_language": true,
"bootstrap_files": [
"Makefile"
],
"has_devcontainer": false,
"has_linter_config": true,
"typecheck_configs": [],
"agent_commit_share": 0,
"toolchain_manifests": [
"go.mod"
],
"dependency_bot_commit_share": 0
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": "Makefile",
"points": 18,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Makefile"
}
}
],
"max_points": 18
},
{
"key": "automated_tests",
"name": "Automated tests",
"detail": null,
"points": 22,
"status": "met",
"details": [],
"max_points": 22
},
{
"key": "lint_format_config",
"name": "Lint / format config",
"detail": ".golangci.yml",
"points": 11,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": ".golangci.yml"
}
}
],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": "Go (statically typed)",
"points": 11,
"status": "met",
"details": [
{
"code": "statically_typed_language",
"params": {
"language": "Go"
}
}
],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": "lockfile",
"points": 10,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "lockfile"
}
}
],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "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 1",
"points": 1,
"status": "partial",
"details": [],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "excellent",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"primary_language": "Go",
"largest_source_bytes": 43648,
"source_files_sampled": 78,
"oversized_source_files": 0
},
"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": "0/78 source files over 60KB",
"points": 55,
"status": "met",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 78,
"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",
"GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository"
],
"report_type": "repository",
"generated_at": "2026-07-25T13:53:14.123878Z",
"schema_version": "0.27.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/c/catgoose/chuck.svg",
"full_name": "catgoose/chuck",
"license_state": "standard",
"license_spdx": "MIT"
}