公开记录
软件健康报告模式 0.27.0 · 指标 2.3.1 · 2026-07-31 09:06 UTC

leonardovida / duckdb-sqlalchemy

Production-ready SQLAlchemy dialect for DuckDB and MotherDuck with operational defaults and migration support from duckdb_engine.

PythonMIT★ 16 星标⑂ 0 复刻始于 2025年12月复刻在 GitHub 上查看 ↗
类型如何判定

leonardovida/duckdb-sqlalchemy 的健康指数为 100 分中的 71 分,处于「良好」区间。 其得分最高的类别是Vitality(90/100),最低的是Community & Adoption(22/100)。 最近一次更新在今天。 近期的大部分工作由 1 位贡献者完成。

71
总分 / 100
良好

软件健康指数

指标归入加权类别,统一采用 1–100 量表。总体分先取类别加权平均,再依据公开记录的分布进行校准,使各等级具有百分位含义;当公开证据触发高风险司法辖区政策时,评级会按政策调整,并设置 34(存在风险)的上限。

71
卓越93-100公开记录中的最高层级(约前 5%);基本满足所有检验标准
优秀80-92各方面均表现强劲;仅有少量不足
良好65-79健康;不足之处有限且可控
中等50-64可接受,但存在明显不足;建议进行审查
薄弱35-49多个领域存在实质性薄弱环节
存在风险20-34存在重大薄弱环节;采用时应保持审慎
危急1-19问题严重(项目被弃置、仅有单一维护者、缺乏基本工程规范)
活力社区与采用可持续性与治理工程质量安全AI 就绪度

评分画像

每条轴代表一个类别。形状比平均值更重要——健康的对象会填满整个图形,而“一峰一谷”式画像意味着某一维度的优势正掩盖另一维度的风险。

加权总体分 63 经校准后在公布的指数量表上为 71(记录校准 2026-08-02)。

所有权

Leonardo Vida个人账户
39 关注者40 个公开仓库始于 2012年10月@motherduckdb

该仓库由个人账户拥有。相较于组织支持的项目,单一所有者项目的延续性风险更高。

软件包生态系统

注册表软件包版本月下载量版本数最近发布标签
PyPIduckdb-sqlalchemy1.5.4.7-270 天前analyticsdatabasedialectduckdbmotherduckolapsqlalchemy

按类别列示的指标

活力

项目是否仍有生命——是否仍在编写代码,是否仍在发布版本?

90优秀 · 占总体的 21%
评分方式
36/36推送新近度 — 最近一次推送于 0 天前
20.1/36提交节奏 — 52 周中有 29 周有提交
18/18提交量 — 最近一年 218 次提交
10/10OpenSSF Scorecard:Maintained — 30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
所用输入
commits_last_year218
human_commit_share1
days_since_last_push0
active_weeks_last_year29

发布纪律

100卓越
评分方式
27/27有发布版本 — 已发布 27 个发布版本
36/36发布时效 — 最近一次发布版本于 0 天前
27/27发布节奏 — 约每 9 天发布一次
0/10OpenSSF Scorecard:Signed-Releases — 无数据
所用输入
releases_count27
latest_release_tagv1.5.4.7
releases_from_tags
days_since_latest_release0
mean_days_between_releases9
已排除计分(无数据或不适用):OpenSSF Scorecard:Signed-Releases。 其余权重已重新归一化。

社区与采用

项目是否拥有用户、下载量与关注度,并具备欢迎贡献者参与的配置?

22存在风险 · 占总体的 17%
评分方式
19.1/60星标 — 16 个星标
0/25复刻 — 0 个复刻
0/15关注者 — 0 位关注者
所用输入
forks0
stars16
watchers0
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

社区健康

25存在风险
评分方式
0/22.5README
22.5/22.5许可证 — 可识别的许可证(MIT)
0/18CONTRIBUTING 指南
0/13.5行为准则
0/7.2议题模板
0/6.3PR 模板
所用输入
has_readme
has_license
readme_badges
has_contributing
has_issue_template
has_code_of_conduct
readme_badge_services
has_pull_request_template

可持续性与治理

项目能否在其成员之外延续——巴士系数、响应能力、由谁支持,以及软件包的维护状况?

63中等 · 占总体的 23%
评分方式
9/54巴士系数 — 1 位贡献者贡献了半数提交
3.2/22.5提交分布 — 头号贡献者编写了 86% 的提交
13.5/13.5贡献者广度 — 25 位贡献者
10/10OpenSSF Scorecard:Contributors — project has 10 contributing companies or organizations
所用输入
bus_factor1
contributors_sampled25
top_contributor_share0.856
评分方式
33.6/42议题解决 — 80% 的议题已关闭
29.1/30PR 接受 — 已裁定的 PR 中 137/141 已合并
0/13Newcomer PR acceptance — 30 天内没有首次贡献者的 PR 得到裁决
0/15OpenSSF Scorecard:Code-Review — Found 0/30 approved changesets -- score normalized to 0
所用输入
merged_prs137
open_issues1
closed_issues4
prs_merged_7d
prs_decided_7d
prs_merged_30d
prs_decided_30d
issue_closed_ratio0.8
closed_unmerged_prs4
first_time_authors_30d
first_time_prs_merged_30d
first_time_prs_decided_30d
已排除计分(无数据或不适用):newcomer_pr_acceptance。 其余权重已重新归一化。
评分方式
10/30所有权背书 — 个人(用户)账户
0/20已验证域名 — 不适用于个人账户
11.5/25所有者影响力 — leonardovida 有 39 位关注者
23.7/25既往记录 — 40 个公开仓库,账户约 13 年
所用输入
followers39
owner_typeUser
is_verified
owner_loginleonardovida
public_repos40
account_age_days5,033
已排除计分(无数据或不适用):已验证域名。 其余权重已重新归一化。
评分方式
25/25已发布且可解析 — pypi 上有 1 个软件包
35/35发布时效 — 最近一次发布于 0 天前
20/20版本历史 — 27 个已发布版本
20/20未被弃用 — 活跃,未被弃用或撤回
所用输入
packagesduckdb-sqlalchemy
ecosystemspypi
any_deprecated
min_days_since_publish0

工程质量

基础的工程与文档实践是否到位?

79良好 · 占总体的 19%

工程实践

92优秀
评分方式
24/24CI 工作流 — 4 个工作流
24/24存在测试
16/16Linter 配置
9.6/9.6Pre-commit 钩子
0/6.4.editorconfig
18/20OpenSSF Scorecard:CI-Tests — 29 out of 30 merged PRs checked by a CI test -- score normalized to 9
所用输入
has_ci
has_tests
has_editorconfig
has_linter_config
has_precommit_config

文档

60中等
评分方式
0/30README
25/25文档目录
15/15文档 / 主页站点 — https://leonardovida.github.io/duckdb-sqlalchemy/
0/10仓库描述
10/10主题标签 — 11 个主题标签
10/10Wiki
所用输入
topicsanalytics, database, dialect, duckdb, motherduck, olap, python, sqlalchemy, alembic, data-engineering, duckdb-engine-migration
has_wiki
homepagehttps://leonardovida.github.io/duckdb-sqlalchemy/
has_readme
has_docs_dir
has_description

安全

可见的安全与供应链实践是否稳固,且不存在未解决的高风险司法辖区暴露?

51中等 · 占总体的 16%

安全态势

51中等
评分方式
7.5/7.5Binary-Artifacts — no binaries found in the repo
2.2/7.5Branch-Protection — branch protection is not maximal on development and all release branches
2.2/2.5CI-Tests — 29 out of 30 merged PRs checked by a CI test -- score normalized to 9
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 0/30 approved changesets -- score normalized to 0
2.5/2.5Contributors — project has 10 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5许可证 — license file detected
7.5/7.5Maintained — 30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
5/5Packaging — packaging workflow detected
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
0/5SAST — SAST tool is not run on all commits -- score normalized to 0
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — 无数据
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
3/7.5Vulnerabilities — 6 existing vulnerabilities detected
所用输入
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate5.1
已排除计分(无数据或不适用):signed_releases。 其余权重已重新归一化。

AI 就绪度

该仓库在多大程度上具备与 AI 编码代理协同开发与维护的条件?权重刻意设小(4%):代理工具链是一项真实的维护信号,但完全不具备的仓库仍可达到 100/100。

79良好 · 占总体的 4%
评分方式
45/45代理指令 — AGENTS.md, CLAUDE.md
15/15机器可读文档(llms.txt) — 存在 llms.txt
40/40可读的提交历史 — 100 次人类提交中有 84 次说明了意图(结构化标题或解释性正文)
所用输入
has_llms_txt
legible_history_share0.84
agent_instruction_filesAGENTS.md, CLAUDE.md
agent_instruction_max_bytes2,595
评分方式
18/18一条命令的引导启动 — noxfile.py
22/22自动化测试
11/11Lint / 格式化配置
11/11静态类型检查 — duckdb_sqlalchemy/py.typed
10/10可复现环境 — lockfile
0/10已体现的代理实践 — 最近 100 次提交中没有代理编写的提交
5/8自动化维护 — 已配置依赖自动化,但在抽样提交中未观察到
0/10OpenSSF Scorecard:Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
所用输入
has_nix
has_tests
lockfilesuv.lock
has_dockerfile
typed_language
bootstrap_filesnoxfile.py
has_devcontainer
has_linter_config
typecheck_configsduckdb_sqlalchemy/py.typed
agent_commit_share0
toolchain_manifests
dependency_bot_commit_share0
评分方式
27/45可类型检查的代码 — Python,已配置类型检查(duckdb_sqlalchemy/py.typed)
52.1/55可控的文件大小 — 采样的 38 个源文件中有 2 个超过 60KB
所用输入
primary_languagePython
largest_source_bytes75,234
source_files_sampled38
oversized_source_files2
评分方式
0/40API 模式(OpenAPI/GraphQL/proto)
0/20MCP 服务器
40/40可运行示例 — examples
所用输入
example_dirsexamples
has_mcp_signal
api_schema_files

关键数据

16GitHub 星标
25贡献者
218最近 12 个月提交数
0距最近推送天数
27发布版本数
1巴士系数(bus factor)
1开放议题
PyPI软件包生态系统数

数据采集警告

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
  • Community profile unavailable
  • GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository
  • deps.dev does not index pypi:duckdb-sqlalchemy@1.5.4.7; advisories assessed against the repository dependency graph instead

更多细节

OpenSSF Scorecard 5.1 / 10
5.1综合

来自开源项目 OpenSSF Scorecard 的独立、工具无关的安全评估。每项检查奖励的是安全实践本身,而非特定供应商的工具。Scorecard 无法判定的检查项标记为 不适用,并从安全评分中剔除(绝不按零分计)。Scorecard v5.5.0 · 2026-07-31 09:06 UTC

10Binary-Artifactsno binaries found in the repo
3Branch-Protectionbranch protection is not maximal on development and all release branches
9CI-Tests29 out of 30 merged PRs checked by a CI test -- score normalized to 9
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/30 approved changesets -- score normalized to 0
10Contributorsproject has 10 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
10Maintained30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
10Packagingpackaging workflow detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
0SASTSAST tool is not run on all commits -- score normalized to 0
0Security-Policysecurity policy file not detected
不适用Signed-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
4Vulnerabilities6 existing vulnerabilities detected
直接依赖 4
注册表软件包版本约束清单文件
PyPIduckdb>=0.5.0pyproject.toml
PyPIsqlalchemy>=2.0.0pyproject.toml
PyPIsqlalchemy>=2.0.45pyproject.toml
PyPIpackaging>=21pyproject.toml
全部依赖 未采集

本报告未能采集到解析后的依赖集合:GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

原始 JSON 报告 机器可读
{
  "data": {
    "repo": {
      "topics": [
        "analytics",
        "database",
        "dialect",
        "duckdb",
        "motherduck",
        "olap",
        "python",
        "sqlalchemy",
        "alembic",
        "data-engineering",
        "duckdb-engine-migration"
      ],
      "is_fork": true,
      "size_kb": 3871,
      "has_wiki": true,
      "homepage": "https://leonardovida.github.io/duckdb-sqlalchemy/",
      "languages": {
        "Python": 270900
      },
      "pushed_at": "2026-07-31T09:04:17Z",
      "created_at": "2025-12-11T22:45:33Z",
      "owner_type": "User",
      "updated_at": "2026-07-31T09:05:50Z",
      "description": "Production-ready SQLAlchemy dialect for DuckDB and MotherDuck with operational defaults and migration support from duckdb_engine.",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "main",
      "license_spdx_raw": "MIT",
      "primary_language": "Python",
      "significant_languages": [
        "Python"
      ]
    },
    "owner": {
      "blog": null,
      "name": "Leonardo Vida",
      "type": "User",
      "login": "leonardovida",
      "company": "@motherduckdb",
      "location": "Amsterdam",
      "followers": 39,
      "avatar_url": "https://avatars.githubusercontent.com/u/2588282?v=4",
      "created_at": "2012-10-18T10:09:34Z",
      "is_verified": null,
      "public_repos": 40,
      "account_age_days": 5033
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": false
    },
    "activity": {
      "releases": [
        {
          "tag": "v1.5.4.7",
          "kind": "other",
          "published_at": "2026-07-31T09:04:18Z"
        },
        {
          "tag": "v1.5.4.6",
          "kind": "other",
          "published_at": "2026-07-30T15:54:27Z"
        },
        {
          "tag": "v1.5.4.5",
          "kind": "other",
          "published_at": "2026-07-24T10:08:14Z"
        },
        {
          "tag": "v1.5.4.4",
          "kind": "other",
          "published_at": "2026-07-17T08:22:09Z"
        },
        {
          "tag": "v1.5.4.3",
          "kind": "other",
          "published_at": "2026-07-10T08:15:10Z"
        },
        {
          "tag": "v1.5.4.2",
          "kind": "other",
          "published_at": "2026-07-03T08:43:45Z"
        },
        {
          "tag": "v1.5.4.1",
          "kind": "other",
          "published_at": "2026-07-01T21:02:13Z"
        },
        {
          "tag": "v1.5.4",
          "kind": "patch",
          "published_at": "2026-06-26T09:00:28Z"
        },
        {
          "tag": "v1.5.3",
          "kind": "patch",
          "published_at": "2026-06-02T08:25:10Z"
        },
        {
          "tag": "v1.5.2.2",
          "kind": "other",
          "published_at": "2026-05-11T12:19:52Z"
        },
        {
          "tag": "v1.5.2.1",
          "kind": "other",
          "published_at": "2026-04-25T08:12:03Z"
        },
        {
          "tag": "v1.5.2",
          "kind": "patch",
          "published_at": "2026-04-17T09:16:10Z"
        },
        {
          "tag": "v1.5.1.4",
          "kind": "other",
          "published_at": "2026-04-10T16:58:32Z"
        },
        {
          "tag": "v1.5.1",
          "kind": "patch",
          "published_at": "2026-03-26T09:45:36Z"
        },
        {
          "tag": "v1.4.4.8",
          "kind": "other",
          "published_at": "2026-03-24T15:44:44Z"
        },
        {
          "tag": "v1.4.4.7",
          "kind": "other",
          "published_at": "2026-03-22T17:20:05Z"
        },
        {
          "tag": "v1.4.4.6",
          "kind": "other",
          "published_at": "2026-03-22T16:56:09Z"
        },
        {
          "tag": "v1.4.4.5",
          "kind": "other",
          "published_at": "2026-03-22T16:26:10Z"
        },
        {
          "tag": "v1.4.4.3",
          "kind": "other",
          "published_at": "2026-02-21T10:10:02Z"
        },
        {
          "tag": "v1.4.4.2",
          "kind": "other",
          "published_at": "2026-02-05T21:53:47Z"
        },
        {
          "tag": "v1.4.4.1",
          "kind": "other",
          "published_at": "2026-02-05T13:03:47Z"
        },
        {
          "tag": "v1.4.4",
          "kind": "patch",
          "published_at": "2026-02-03T10:06:38Z"
        },
        {
          "tag": "v1.4.3",
          "kind": "patch",
          "published_at": "2026-01-15T11:19:40Z"
        },
        {
          "tag": "v0.19.3",
          "kind": "patch",
          "published_at": "2025-12-28T11:16:45Z"
        },
        {
          "tag": "v0.19.2",
          "kind": "patch",
          "published_at": "2025-12-28T10:44:09Z"
        },
        {
          "tag": "v0.19.1",
          "kind": "patch",
          "published_at": "2025-12-26T22:24:54Z"
        },
        {
          "tag": "v0.19.0",
          "kind": "minor",
          "published_at": "2025-12-24T17:01:11Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "66f42bedbcfab7977a1c13bc6c1d636f7faee9c1",
          "body": null,
          "is_bot": false,
          "headline": "fix: reflect dotted schema names (#146)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-31T09:03:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a9759ddc2524953bc670b0aef428a50df130bc70",
          "body": null,
          "is_bot": false,
          "headline": "fix concurrent reserved word loading (#145)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-30T15:52:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7e8442274104dfc55ff8d6b277d9064a30d7e62f",
          "body": null,
          "is_bot": false,
          "headline": "refactor(olap): reuse legacy job mappings (#144)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-27T12:17:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7cf3b7c92685123afe68354701a31b716a1b3bdb",
          "body": null,
          "is_bot": false,
          "headline": "fix: support SQLAlchemy 2.1 (#143)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-24T10:07:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "da31175f3c622837f6c2db2c5da49584d58b3b2c",
          "body": null,
          "is_bot": false,
          "headline": "refactor: centralize implicit sequence ddl (#141)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-19T08:57:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2466081ec2786b80d87cb3c735b37ef37cec8cec",
          "body": null,
          "is_bot": false,
          "headline": "fix pooled connection invalidation (#140)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-17T08:20:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b6f2edb634773155e77855e8cb75b84abde9abd0",
          "body": null,
          "is_bot": false,
          "headline": "chore: align dependency checkers (#139)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-14T15:21:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "80cd74b2580fadd0f6e0d0a2ae63732a28d6fd41",
          "body": null,
          "is_bot": false,
          "headline": "fix MotherDuck Flight helper names (#138)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-10T08:14:19Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b3fb8aced59042a3763636cd8cf9c4be146dc3ea",
          "body": null,
          "is_bot": false,
          "headline": "refresh compatibility tools (#137)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-07T08:52:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d31163ddfa63e325752e971da8333d455f428a0a",
          "body": null,
          "is_bot": false,
          "headline": "add Dive status helper",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-06T15:12:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c126dc2ee096eef1facb1117c5767134aafcf988",
          "body": "Fix copy_from_rows header-mode row loss and prepare 1.5.4.2.",
          "is_bot": false,
          "headline": "fix copy_from_rows header mode",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-03T08:33:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1ed498439be9c7853f1ba54637375cb83136e3e1",
          "body": null,
          "is_bot": false,
          "headline": "refactor: centralize reflection result defaults (#133)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-02T20:56:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b03cb9b0b400fb7408209a0670825ac709bc7f44",
          "body": null,
          "is_bot": false,
          "headline": "refresh dive status metadata (#132)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-02T17:18:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1e9b9a00ea0b2d6f257da044b1771b27e44288fa",
          "body": null,
          "is_bot": false,
          "headline": "release 1.5.4.1 (#131)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-01T21:01:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "598ea0574d7aea130d15408a8089e8b941619561",
          "body": "…28) (#130)",
          "is_bot": false,
          "headline": "render implicit sequences instead of SERIAL for autoincrement PKs (#1…",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-01T20:58:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9d54f6d2aef35cbb58428e75aa0e2eff64105b85",
          "body": null,
          "is_bot": false,
          "headline": "refactor bulk row shaping (#129)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-28T15:34:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ac8d816568a2c5cd3eff294d0cdffa2bba3cd954",
          "body": null,
          "is_bot": false,
          "headline": "release 1.5.4",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-26T08:59:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8b1f7077fa1133ec2ca679bd5b0a7b98207a71bc",
          "body": null,
          "is_bot": false,
          "headline": "update duckdb 1.5.4 compatibility (#126)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-26T08:24:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d5a809c867fccbd578ad6ed5c2ee4cde018a70f6",
          "body": "Centralize DuckDB STRUCT/UNION field rendering and cover direct compiler use.",
          "is_bot": false,
          "headline": "refactor type field rendering",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-21T08:24:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7d4c175a6f89ae3c9a52dff45110b4363a499125",
          "body": null,
          "is_bot": false,
          "headline": "validate Flight config maps (#124)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-19T13:38:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d1746d38de8a7da762130642078b88016f225771",
          "body": null,
          "is_bot": false,
          "headline": "simplify execute retry wrapper",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-19T13:20:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a83e8bf293354f2264dd446845b16bbf19ac8a37",
          "body": null,
          "is_bot": false,
          "headline": "extract connect config prep (#122)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-16T13:02:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fade278209e9b391a861a0d63b6d301e90bbe20b",
          "body": null,
          "is_bot": false,
          "headline": "validate flight config keys (#121)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-16T11:09:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5230d01679150a8e77807b4adc3b5814bde3200d",
          "body": null,
          "is_bot": false,
          "headline": "update MotherDuck metadata helpers (#120)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-11T02:34:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "928d1cc3f510616da687cfcaee78033ecd2639fe",
          "body": null,
          "is_bot": false,
          "headline": "extract arrow result wrapper (#119)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-10T23:15:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9d2521587a1a35a2c1a60feb96f3c768ef3bb3d1",
          "body": "* centralize MotherDuck path query handling\n\n* use pypi codecov cli in ci",
          "is_bot": false,
          "headline": "[codex] centralize MotherDuck path query handling (#118)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-07T11:39:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a32b301c64eac43ccb057eccaba385aa2c145567",
          "body": "Refresh ty/Ruff development checker pins and lockfile after validation.",
          "is_bot": false,
          "headline": "refresh dev checker pins",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-05T12:51:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1858af375ebac47365f52868f00cb11b988aa886",
          "body": null,
          "is_bot": false,
          "headline": "add MotherDuck flight helpers (#116)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-05T08:13:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2e9c3412830fc7d245974cefef1dab214db74627",
          "body": null,
          "is_bot": false,
          "headline": "handle application names and refresh ty (#115)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-02T18:57:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "201c62426ab702b6c3236543259dece61c04f9a1",
          "body": null,
          "is_bot": false,
          "headline": "align release ty pin",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-02T08:23:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1440c8c1d803ee3ca174de34bb9bff916bfe3841",
          "body": null,
          "is_bot": false,
          "headline": "release 1.5.3",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-02T08:21:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b0e809ec61f3487ed8eb0f09ad9d2be8291f8cc4",
          "body": null,
          "is_bot": false,
          "headline": "add storage info helper (#112)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-02T07:55:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "efa2b6e59d36b4f45c2a5400dc810306231cc81a",
          "body": "Refresh ty to 0.0.38 after local and CI validation.",
          "is_bot": false,
          "headline": "refresh ty to 0.0.38",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-22T13:27:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cd84a58cfa813203e0b8a02c16b0c1b43295df10",
          "body": null,
          "is_bot": false,
          "headline": "refresh duckdb matrix and dev lock (#110)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-22T08:10:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "47d6f67ed5c468f5c56a6311b491e7e4a5979b64",
          "body": null,
          "is_bot": false,
          "headline": "test quack query helper runtime",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-21T14:24:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7fbb8bad458306a19db77ca01f4ff42ab03138c4",
          "body": null,
          "is_bot": false,
          "headline": "add duckdb 1.5.3 support",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-21T14:18:19Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "00fad1b6434e4e3ebe14786f2a9f10d3e7e6e486",
          "body": null,
          "is_bot": false,
          "headline": "centralize bulk insert row shape (#107)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-19T08:53:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "69169eb9727dbe33180644b2beb2b631a0ae78b6",
          "body": "Add MotherDuck Dives-as-code table-function helpers and refresh the validated ty dev pin.",
          "is_bot": false,
          "headline": "add motherduck dive helpers",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-19T08:50:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ff85ed12e3a5bcb16f71c028ff03f094565339d7",
          "body": null,
          "is_bot": false,
          "headline": "extract statement classification helpers (#105)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-17T20:58:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "43c7180f5cad83ca76cb464b2a7265f0b98c46a0",
          "body": null,
          "is_bot": false,
          "headline": "add motherduck job helpers",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-15T14:23:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8583484bd46ccdf089a1327ddc628e7c4b0d23bd",
          "body": null,
          "is_bot": false,
          "headline": "refactor olap metadata helpers (#103)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-15T14:19:01Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b1aa01ce116e3a0bcec8870bb75db5eaf7d80b0d",
          "body": null,
          "is_bot": false,
          "headline": "add motherduck table function helpers (#102)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-12T18:43:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8da837b8d22e74fa6f8758558a75f06464fa01ac",
          "body": "Release 1.5.2.2.",
          "is_bot": false,
          "headline": "chore: release 1.5.2.2",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-11T12:17:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e2a8c276ff790fda4a2e193cad4fea4a4ff079df",
          "body": null,
          "is_bot": false,
          "headline": "deduplicate reflection fallback wrappers",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-10T20:02:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e624a0c5eafaebd675a07f2bd37b48f4edb803ab",
          "body": "Refresh ty to 0.0.34 and update the locked development dependency set after local and CI validation.",
          "is_bot": false,
          "headline": "refresh dev tooling",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-07T07:44:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "73ca8144a646a7ac04078343a15ca59b68f20eff",
          "body": null,
          "is_bot": false,
          "headline": "handle postgres session compatibility (#98)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-03T19:56:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ba9f9b6f99c28d8494229ec19bc395f7ef56fc7c",
          "body": null,
          "is_bot": false,
          "headline": "validate motherduck database names (#97)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-01T08:08:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d54cf40abdb39be801010a1553fcf39ee783f8e2",
          "body": "Rollback PR #95 behavior and dependency updates while keeping formatting-only conftest cleanup.",
          "is_bot": false,
          "headline": "Revert pgcompat config aliases (#96)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-30T15:05:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "21ca5987c0de84a4d025d2e27b7e41c5b1bbbfbd",
          "body": null,
          "is_bot": false,
          "headline": "add pgcompat config aliases (#95)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-30T08:16:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f0f8a20e128b9f6af02b91e01de1a1c9dc2b69cc",
          "body": "Refresh maintenance dependency pins and lockfile; CI passed.",
          "is_bot": false,
          "headline": "refresh maintenance dependencies",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-29T10:17:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "836133bff43f1756398ac58deba68a6fc96cc62d",
          "body": null,
          "is_bot": false,
          "headline": "fix motherduck token env precedence (#93)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-26T17:08:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "69df613b45e21bfe4f9b35f4450029cf730b5959",
          "body": null,
          "is_bot": false,
          "headline": "extract bulk insert builders (#92)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-26T10:42:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "60ec8ef992e87a2273ef1158efb1a10becd653b6",
          "body": null,
          "is_bot": false,
          "headline": "add motherduck user info helper",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-25T08:55:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9e2b1b38590760e121f2d0a2c414c55cb596a2bb",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.5.2.1 (#90)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-25T08:11:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4daaec569223a3de26727c520d1e40f4fda4e06a",
          "body": null,
          "is_bot": false,
          "headline": "restore motherduck legacy transport aliases (#89)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-24T09:14:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9a2389d6b986f5261a0e157f65164e09c44526fa",
          "body": "* refactor validation helpers\n\n* restore uv lockfile",
          "is_bot": false,
          "headline": "[codex] refactor validation helpers (#88)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-24T08:32:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "19668b8523721dc7bee2fecd6248d905891cfa34",
          "body": null,
          "is_bot": false,
          "headline": "maintenance review: fix motherduck routing (#87)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-24T08:16:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d570b8d8bffe861418ea89c222ce2f30a6364f9a",
          "body": null,
          "is_bot": false,
          "headline": "fix motherduck startup options (#86)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-21T11:06:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "515ff0e663810968b90f827ce553650772466789",
          "body": null,
          "is_bot": false,
          "headline": "refactor bulk row normalization (#85)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-19T10:17:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f2319a728ccd54976fa80ed0a76ef70fc25979f3",
          "body": null,
          "is_bot": false,
          "headline": "refactor reflection fallbacks (#84)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-18T11:50:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d524ac9d921061f90d8346bc7a3666f9611a32c2",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.5.2",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-17T09:15:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cca001e5b15574000186eb7d5061b1d7492225f4",
          "body": null,
          "is_bot": false,
          "headline": "refactor reflection fallback (#82)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-17T08:38:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b129a5f72e34b6c83106e057690a78d095617a71",
          "body": "Support DuckDB 1.5.2 GEOMETRY reflection, prefer MotherDuck session_name while preserving session_hint aliases, and refresh validated development tooling pins.",
          "is_bot": false,
          "headline": "support duckdb 1.5.2 compatibility",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-17T08:12:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8cbf8c13cd6a2b2dd8354095e80f342a099dcc4f",
          "body": null,
          "is_bot": false,
          "headline": "refactor duckdb reflection statements (#80)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-16T11:07:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "59baaa8bafc4010a0a68208181b4c8d8b6ac6c1a",
          "body": null,
          "is_bot": false,
          "headline": "support duckdb 1.5.2 motherduck session names (#79)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-16T08:29:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ec65504ef758ccca0e1b440edda29ee280eab5da",
          "body": null,
          "is_bot": false,
          "headline": "refactor duckdb reflection filters (#78)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-12T09:36:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1537c5a10d11c663ad210acd1a2cdbcfb8fc273f",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.5.1.4 (#77)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-10T16:57:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "90a84a95f1bbb69e6ec0e3502197bcc4de01b0b1",
          "body": null,
          "is_bot": false,
          "headline": "fix motherduck oauth token config (#75)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-10T08:15:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d42d487643a23d03ace6d303802d3339a9e80c78",
          "body": null,
          "is_bot": false,
          "headline": "fix motherduck alias routing (#74)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-08T16:06:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0326c92f2055f84f6c2a0e8da7c1c7b7719e111c",
          "body": null,
          "is_bot": false,
          "headline": "fix memory url query handling (#73)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-07T12:33:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "92e8827ec1f4dfaf7db449cfb9ee2017d78adb69",
          "body": null,
          "is_bot": false,
          "headline": "consolidate motherduck ttl alias normalization (#72)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-07T12:29:17Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e6732e2c2f876486259b7eac130f44202dca308a",
          "body": "* fix retry handling and refresh tooling\n\n* fix datatypes ty regression",
          "is_bot": false,
          "headline": "[codex] fix retry handling and refresh tooling",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-03T12:40:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1ff8b468f3b5b4f648c6753e3a1760c6c42e1106",
          "body": null,
          "is_bot": false,
          "headline": "share struct union field cache logic (#70)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-03T12:34:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "29dd7084499cdc99d640c9f33ed570a1adc1b0ad",
          "body": null,
          "is_bot": false,
          "headline": "maintenance review: fix nox devtools setup (#69)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-02T15:33:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "41bcb9dc282d761ada39d25cd7bc24d87566e0c7",
          "body": null,
          "is_bot": false,
          "headline": "refactor pool selection (#68)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-02T15:28:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6adfaac122f371186d70142e75585f1df9b4af8a",
          "body": null,
          "is_bot": false,
          "headline": "refresh dev lockfile and bump ty (#67)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-01T08:11:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1d7a435de1e70a07512984b91e5ee1106195ba8d",
          "body": null,
          "is_bot": false,
          "headline": "extract index reflection helpers (#66)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-01T08:09:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d1844f7c214735db0203f34579b6928bc6804f22",
          "body": null,
          "is_bot": false,
          "headline": "maintenance review and ty upgrade (#65)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-31T08:14:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b7d559d6b8dc1034fdc84be47b21c077ff963ec5",
          "body": null,
          "is_bot": false,
          "headline": "refactor connect arg copying (#64)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-31T08:06:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ccb16cd1869a55c8673870056208e42b5cad0bcd",
          "body": null,
          "is_bot": false,
          "headline": "maintenance review: deprecate insert alias and bump ty (#63)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-30T08:13:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7b2a801be822d4a2c1ce4a2c318aedf855b25bde",
          "body": null,
          "is_bot": false,
          "headline": "refactor MotherDuck TTL alias normalization (#62)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-30T08:09:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8ac0a5cd23873fe9afa0ee9ebf621eafe9261030",
          "body": "* widen dependency caps and cache reserved words\n\n* add pytz for pandas 3 environments",
          "is_bot": false,
          "headline": "[codex] widen dependency caps and cache reserved words (#61)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-29T20:05:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b67ca47cd916b3e5cd39892ac15c690aa807c25c",
          "body": null,
          "is_bot": false,
          "headline": "extract bulk helpers (#60)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-29T19:55:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3f28dd56339cd05537eaf9b66ba0b01fbc44477d",
          "body": null,
          "is_bot": false,
          "headline": "maintenance review: deprecate ttl alias and refresh dev tools (#59)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-27T10:46:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2b11235f75ac26d6d01fa1e78a8d8b43972ebd2f",
          "body": null,
          "is_bot": false,
          "headline": "avoid empty bulk copy chunks (#58)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-27T10:39:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "67dceb82afba1e28deb728f34b0d7c5a07d0d14f",
          "body": null,
          "is_bot": false,
          "headline": "fix: align sqlalchemy floor and local pool defaults (#57)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-26T22:05:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b61146d35b1263adc25de15cca2a7a8e049d1f56",
          "body": null,
          "is_bot": false,
          "headline": "feat: add DuckDB 1.5.1 support (#56)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-26T09:45:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "091a829e706fdc4da8509bc964af045c2aad29c8",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.4.4.8 (#55)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-24T15:44:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b2deffbbedc09d7670bdab0a9febda5985f54998",
          "body": null,
          "is_bot": false,
          "headline": "feat: add explicit checkpoint helper (#54)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-24T15:18:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "856edaf8bada7084c37b64595869826214470000",
          "body": null,
          "is_bot": false,
          "headline": "fix: stop probing isolation level on connect (#53)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-24T15:06:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "18027d1439b35ff05fda0a932f627d9eadcade54",
          "body": null,
          "is_bot": false,
          "headline": "fix: restore pool defaults for named memory urls (#52)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-24T15:04:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "dab204cf33d6674106453fa4e86a3ba2e0557b16",
          "body": null,
          "is_bot": false,
          "headline": "ci: update github actions (#50)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T18:32:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "eb2676b6f77e7325d397e78f1aac5c1c5cc5cd0b",
          "body": null,
          "is_bot": false,
          "headline": "fix: repair reflection metadata (#48)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T17:19:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "72e6cf50dcc303b4a4c470228d2527a350ef08b7",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.4.4.6 (#47)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T16:55:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6f30c67f196855da119bf9abc169a4b3258e7e0a",
          "body": null,
          "is_bot": false,
          "headline": "fix: reflect float8 as double (#46)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T16:51:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7b4ca3e4e9798ccc11dd6324f2992156359c6411",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.4.4.5 (#45)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T16:25:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b865a9b172ab048af6ad6ff9f48107f3b0c7c2be",
          "body": null,
          "is_bot": false,
          "headline": "extract bulk insert data helper (#44)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T14:42:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "82b7273e558a20396d25bb35f0caaf11293eaba6",
          "body": "* bulk-loader cleanup and deps\n\n* trigger pr ci",
          "is_bot": false,
          "headline": "[codex] bulk-loader cleanup and deps (#43)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T13:04:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "35baffc98934f7092b8396b0c343ef2b080a4b3a",
          "body": null,
          "is_bot": false,
          "headline": "refactor MotherDuck TTL normalization (#42)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-21T15:22:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c9260f7c384906b45905638e9aedcafbf414a145",
          "body": null,
          "is_bot": false,
          "headline": "maintenance: bulk cleanup and deps (#41)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-21T12:55:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 27,
      "commits_last_year": 218,
      "latest_release_at": "2026-07-31T09:04:18Z",
      "latest_release_tag": "v1.5.4.7",
      "releases_from_tags": false,
      "days_since_last_push": 0,
      "active_weeks_last_year": 29,
      "days_since_latest_release": 0,
      "mean_days_between_releases": 9
    },
    "community": {
      "has_readme": false,
      "has_license": false,
      "has_description": false,
      "has_contributing": false,
      "health_percentage": null,
      "has_issue_template": false,
      "has_code_of_conduct": false,
      "has_pull_request_template": false
    },
    "ecosystem": {
      "packages": [
        {
          "name": "duckdb-sqlalchemy",
          "exists": true,
          "license": "MIT",
          "keywords": [
            "analytics",
            "database",
            "dialect",
            "duckdb",
            "motherduck",
            "olap",
            "sqlalchemy",
            "Development Status :: 5 - Production/Stable",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3 :: Only",
            "Programming Language :: Python :: 3.10",
            "Programming Language :: Python :: 3.11",
            "Programming Language :: Python :: 3.12",
            "Programming Language :: Python :: 3.13",
            "Programming Language :: Python :: 3.14",
            "Programming Language :: Python :: 3.9",
            "Topic :: Database",
            "Topic :: Database :: Front-Ends"
          ],
          "ecosystem": "pypi",
          "matches_repo": true,
          "registry_url": "https://pypi.org/project/duckdb-sqlalchemy/",
          "is_deprecated": false,
          "latest_version": "1.5.4.7",
          "repository_url": "https://github.com/leonardovida/duckdb-sqlalchemy",
          "versions_count": 27,
          "total_downloads": null,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": null,
          "first_published_at": "2025-12-26T22:14:51.171896Z",
          "latest_published_at": "2026-07-31T09:05:06.600094Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 0
        }
      ]
    },
    "popularity": {
      "forks": 0,
      "stars": 16,
      "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": [
        "examples"
      ],
      "has_llms_txt": true,
      "has_dockerfile": false,
      "has_mcp_signal": false,
      "bootstrap_files": [
        "noxfile.py"
      ],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [
        "duckdb_sqlalchemy/py.typed"
      ],
      "toolchain_manifests": [],
      "largest_source_bytes": 75234,
      "source_files_sampled": 38,
      "oversized_source_files": 2,
      "agent_instruction_files": [
        "AGENTS.md",
        "CLAUDE.md"
      ],
      "agent_instruction_max_bytes": 2595
    },
    "dependencies": {
      "manifests": [
        "pyproject.toml"
      ],
      "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": [
        "pypi"
      ],
      "dependencies": [
        {
          "name": "duckdb",
          "manifest": "pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=0.5.0"
        },
        {
          "name": "sqlalchemy",
          "manifest": "pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=2.0.0"
        },
        {
          "name": "sqlalchemy",
          "manifest": "pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=2.0.45"
        },
        {
          "name": "packaging",
          "manifest": "pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=21"
        }
      ],
      "all_dependencies": {
        "error": "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository",
        "source": null,
        "packages": [],
        "collected": false,
        "truncated": false,
        "total_count": null,
        "direct_count": null,
        "indirect_count": null
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 0,
        "merged_prs": 137,
        "open_issues": 1,
        "closed_ratio": 0.8,
        "closed_issues": 4,
        "closed_unmerged_prs": 4
      },
      "bus_factor": 1,
      "bot_contributors": 6,
      "top_contributors": [
        {
          "type": "User",
          "login": "Mause",
          "commits": 1424,
          "avatar_url": "https://avatars.githubusercontent.com/u/1405026?v=4"
        },
        {
          "type": "User",
          "login": "leonardovida",
          "commits": 168,
          "avatar_url": "https://avatars.githubusercontent.com/u/2588282?v=4"
        },
        {
          "type": "User",
          "login": "renovate-bot",
          "commits": 16,
          "avatar_url": "https://avatars.githubusercontent.com/u/25180681?v=4"
        },
        {
          "type": "User",
          "login": "Aarya2004",
          "commits": 9,
          "avatar_url": "https://avatars.githubusercontent.com/u/54771759?v=4"
        },
        {
          "type": "User",
          "login": "matteomorlack",
          "commits": 7,
          "avatar_url": "https://avatars.githubusercontent.com/u/28672237?v=4"
        },
        {
          "type": "User",
          "login": "elefeint",
          "commits": 7,
          "avatar_url": "https://avatars.githubusercontent.com/u/41136058?v=4"
        },
        {
          "type": "User",
          "login": "NickCrews",
          "commits": 5,
          "avatar_url": "https://avatars.githubusercontent.com/u/10820686?v=4"
        },
        {
          "type": "User",
          "login": "gforsyth",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/3596999?v=4"
        },
        {
          "type": "User",
          "login": "jorisvandenbossche",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/1020496?v=4"
        },
        {
          "type": "User",
          "login": "Alex-Monahan",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/52226177?v=4"
        }
      ],
      "contributors_sampled": 25,
      "top_contributor_share": 0.856
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "lint.yml",
        "pages.yml",
        "publish.yaml",
        "pythonapp.yaml"
      ],
      "has_docs_dir": true,
      "linter_configs": [],
      "has_editorconfig": false,
      "has_linter_config": true,
      "has_precommit_config": true
    },
    "security_signals": {
      "lockfiles": [
        "uv.lock"
      ],
      "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": 3,
            "reason": "branch protection is not maximal on development and all release branches",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
          },
          {
            "name": "CI-Tests",
            "score": 9,
            "reason": "29 out of 30 merged PRs checked by a CI test -- score normalized to 9",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
          },
          {
            "name": "CII-Best-Practices",
            "score": 0,
            "reason": "no effort to earn an OpenSSF best practices badge detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
          },
          {
            "name": "Code-Review",
            "score": 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": 10,
            "reason": "project has 10 contributing companies or organizations",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
          },
          {
            "name": "Dangerous-Workflow",
            "score": 10,
            "reason": "no dangerous workflow patterns detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
          },
          {
            "name": "Dependency-Update-Tool",
            "score": 10,
            "reason": "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 2 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": 10,
            "reason": "packaging workflow detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
          },
          {
            "name": "Pinned-Dependencies",
            "score": 0,
            "reason": "dependency not pinned by hash detected -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
          },
          {
            "name": "SAST",
            "score": 0,
            "reason": "SAST tool is not run on all commits -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
          },
          {
            "name": "Security-Policy",
            "score": 0,
            "reason": "security policy file not detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
          },
          {
            "name": "Signed-Releases",
            "score": null,
            "reason": "no releases found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
          },
          {
            "name": "Token-Permissions",
            "score": 0,
            "reason": "detected GitHub workflow tokens with excessive permissions",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
          },
          {
            "name": "Vulnerabilities",
            "score": 4,
            "reason": "6 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "66f42bedbcfab7977a1c13bc6c1d636f7faee9c1",
        "ran_at": "2026-07-31T09:06:02Z",
        "aggregate_score": 5.1,
        "scorecard_version": "v5.5.0"
      },
      "has_codeql_workflow": false,
      "has_security_policy": false,
      "has_dependabot_config": true
    },
    "contribution_flow": {
      "collected": true,
      "ci_last_run_at": "2026-07-31T09:05:09Z",
      "oldest_open_prs": [],
      "last_merged_pr_at": "2026-07-31T09:03:30Z",
      "ci_last_conclusion": "SUCCESS",
      "oldest_open_issues": [
        {
          "number": 135,
          "created_at": "2026-07-06T11:37:20Z",
          "last_comment_at": "2026-07-09T17:52:32Z",
          "last_comment_author": "ml31415"
        }
      ]
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/leonardovida/duckdb-sqlalchemy",
    "host": "github.com",
    "name": "duckdb-sqlalchemy",
    "owner": "leonardovida"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "good",
      "name": "Overall health",
      "note": "The weighted overall 63 is calibrated to 71 on the published index scale (record calibration 2026-08-02).",
      "notes": [
        {
          "code": "overall_calibration",
          "params": {
            "raw": 63,
            "calibrated": 71,
            "calibration": "2026-08-02"
          }
        }
      ],
      "value": 71,
      "inputs": {
        "security": 51,
        "vitality": 90,
        "community": 22,
        "governance": 63,
        "calibration": "2026-08-02",
        "engineering": 79,
        "ai_readiness": 79,
        "weighted_overall_raw": 63
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "excellent",
        "name": "Vitality",
        "value": 90,
        "weight": 0.21,
        "metrics": [
          {
            "key": "development_activity",
            "band": "excellent",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 84,
            "inputs": {
              "commits_last_year": 218,
              "human_commit_share": 1,
              "days_since_last_push": 0,
              "active_weeks_last_year": 29
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 0 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "29/52 weeks with commits",
                "points": 20.1,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 29
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "218 commits in the last year",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 218
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "release_discipline",
            "band": "exceptional",
            "name": "Release discipline",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "releases_count": 27,
              "latest_release_tag": "v1.5.4.7",
              "releases_from_tags": false,
              "days_since_latest_release": 0,
              "mean_days_between_releases": 9
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "27 releases published",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "releases_published",
                    "params": {
                      "count": 27
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 0 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~9 days",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 9
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "openssf_scorecard_signed_releases",
                "name": "OpenSSF Scorecard: Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 10
              }
            ]
          },
          {
            "key": "abandonment",
            "band": "exceptional",
            "name": "Abandonment",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "cap": null,
              "state": "maintained",
              "guards": [],
              "signals": [],
              "red_flag": false,
              "multiplier_pct": 100,
              "declared_reason": null,
              "unverified_reason": null,
              "unanswered_open_prs": null,
              "unanswered_open_issues": null,
              "days_since_last_merged_pr": null,
              "days_since_last_human_commit": 2,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "last human commit 2 days ago",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_maintained",
                    "params": {
                      "days": 2
                    }
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Is the project alive — is code being written and are releases shipping?"
      },
      {
        "key": "community",
        "band": "at_risk",
        "name": "Community & Adoption",
        "value": 22,
        "weight": 0.17,
        "metrics": [
          {
            "key": "popularity",
            "band": "critical",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 19,
            "inputs": {
              "forks": 0,
              "stars": 16,
              "watchers": 0,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "16 stars",
                "points": 19.1,
                "status": "partial",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 16
                    }
                  }
                ],
                "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": "at_risk",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 25,
            "inputs": {
              "has_readme": false,
              "has_license": false,
              "readme_badges": null,
              "has_contributing": false,
              "has_issue_template": false,
              "has_code_of_conduct": false,
              "readme_badge_services": [],
              "has_pull_request_template": false
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 0,
                "status": "missed",
                "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": 63,
        "weight": 0.23,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "weak",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 36,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 25,
              "top_contributor_share": 0.856
            },
            "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 86% of commits",
                "points": 3.2,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 86
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "25 contributors",
                "points": 13.5,
                "status": "met",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 25
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 10 contributing companies or organizations",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "good",
            "name": "Issue & PR responsiveness",
            "note": "Excluded from scoring (no data or not applicable): Newcomer PR acceptance. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "newcomer_pr_acceptance"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 72,
            "inputs": {
              "merged_prs": 137,
              "open_issues": 1,
              "closed_issues": 4,
              "prs_merged_7d": null,
              "prs_decided_7d": null,
              "prs_merged_30d": null,
              "prs_decided_30d": null,
              "issue_closed_ratio": 0.8,
              "closed_unmerged_prs": 4,
              "first_time_authors_30d": null,
              "first_time_prs_merged_30d": null,
              "first_time_prs_decided_30d": null
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "80% of issues closed",
                "points": 33.6,
                "status": "partial",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 80
                    }
                  }
                ],
                "max_points": 42
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "137/141 decided PRs merged",
                "points": 29.1,
                "status": "partial",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 137,
                      "decided": 141
                    }
                  }
                ],
                "max_points": 30
              },
              {
                "key": "newcomer_pr_acceptance",
                "name": "Newcomer PR acceptance",
                "detail": "no first-time contributor's PR decided in 30d",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_newcomer_prs",
                    "params": {
                      "days": 30
                    }
                  }
                ],
                "max_points": 13
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 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": 56,
            "inputs": {
              "followers": 39,
              "owner_type": "User",
              "is_verified": null,
              "owner_login": "leonardovida",
              "public_repos": 40,
              "account_age_days": 5033
            },
            "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": "39 followers of leonardovida",
                "points": 11.5,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 39,
                      "login": "leonardovida"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "40 public repos, account ~13 yr old",
                "points": 23.7,
                "status": "partial",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 40
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 13
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "exceptional",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "packages": [
                "duckdb-sqlalchemy"
              ],
              "ecosystems": "pypi",
              "any_deprecated": false,
              "min_days_since_publish": 0
            },
            "components": [
              {
                "key": "published_resolvable",
                "name": "Published & resolvable",
                "detail": "1 package(s) on pypi",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "packages_published",
                    "params": {
                      "count": 1,
                      "ecosystems": "pypi"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "publish_recency",
                "name": "Publish recency",
                "detail": "latest publish 0 days ago",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "27 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 27
                    }
                  }
                ],
                "max_points": 20
              },
              {
                "key": "not_deprecated",
                "name": "Not deprecated",
                "detail": "active, not deprecated or yanked",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "package_not_deprecated",
                    "params": {}
                  }
                ],
                "max_points": 20
              }
            ]
          }
        ],
        "description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
      },
      {
        "key": "engineering",
        "band": "good",
        "name": "Engineering Quality",
        "value": 79,
        "weight": 0.19,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "excellent",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 92,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": true,
              "has_precommit_config": true
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "4 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 4
                    }
                  }
                ],
                "max_points": 24
              },
              {
                "key": "tests_present",
                "name": "Tests present",
                "detail": null,
                "points": 24,
                "status": "met",
                "details": [],
                "max_points": 24
              },
              {
                "key": "linter_config",
                "name": "Linter config",
                "detail": null,
                "points": 16,
                "status": "met",
                "details": [],
                "max_points": 16
              },
              {
                "key": "pre_commit_hooks",
                "name": "Pre-commit hooks",
                "detail": null,
                "points": 9.6,
                "status": "met",
                "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": "29 out of 30 merged PRs checked by a CI test -- score normalized to 9",
                "points": 18,
                "status": "partial",
                "details": [],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "moderate",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 60,
            "inputs": {
              "topics": [
                "analytics",
                "database",
                "dialect",
                "duckdb",
                "motherduck",
                "olap",
                "python",
                "sqlalchemy",
                "alembic",
                "data-engineering",
                "duckdb-engine-migration"
              ],
              "has_wiki": true,
              "homepage": "https://leonardovida.github.io/duckdb-sqlalchemy/",
              "has_readme": false,
              "has_docs_dir": true,
              "has_description": false
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 30
              },
              {
                "key": "documentation_directory",
                "name": "Documentation directory",
                "detail": null,
                "points": 25,
                "status": "met",
                "details": [],
                "max_points": 25
              },
              {
                "key": "documentation_homepage_site",
                "name": "Documentation / homepage site",
                "detail": "https://leonardovida.github.io/duckdb-sqlalchemy/",
                "points": 15,
                "status": "met",
                "details": [],
                "max_points": 15
              },
              {
                "key": "repository_description",
                "name": "Repository description",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              },
              {
                "key": "topics",
                "name": "Topics",
                "detail": "11 topics",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "topics_count",
                    "params": {
                      "count": 11
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "wiki",
                "name": "Wiki",
                "detail": null,
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          }
        ],
        "description": "Are baseline engineering and documentation practices in place?"
      },
      {
        "key": "security",
        "band": "moderate",
        "name": "Security",
        "value": 51,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "moderate",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 51,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 17,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 1,
              "scorecard_aggregate": 5.1
            },
            "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 is not maximal on development and all release branches",
                "points": 2.2,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "ci_tests",
                "name": "CI-Tests",
                "detail": "29 out of 30 merged PRs checked by a CI test -- score normalized to 9",
                "points": 2.2,
                "status": "partial",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "cii_best_practices",
                "name": "CII-Best-Practices",
                "detail": "no effort to earn an OpenSSF best practices badge detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "code_review",
                "name": "Code-Review",
                "detail": "Found 0/30 approved changesets -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 10 contributing companies or organizations",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "dangerous_workflow",
                "name": "Dangerous-Workflow",
                "detail": "no dangerous workflow patterns detected",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "dependency_update_tool",
                "name": "Dependency-Update-Tool",
                "detail": "update tool detected",
                "points": 7.5,
                "status": "met",
                "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 2 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 detected",
                "points": 5,
                "status": "met",
                "details": [],
                "max_points": 5
              },
              {
                "key": "pinned_dependencies",
                "name": "Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "sast",
                "name": "SAST",
                "detail": "SAST tool is not run on all commits -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "security_policy",
                "name": "Security-Policy",
                "detail": "security policy file not detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "signed_releases",
                "name": "Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 7.5
              },
              {
                "key": "token_permissions",
                "name": "Token-Permissions",
                "detail": "detected GitHub workflow tokens with excessive permissions",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "vulnerabilities",
                "name": "Vulnerabilities",
                "detail": "6 existing vulnerabilities detected",
                "points": 3,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              }
            ]
          },
          {
            "key": "high_risk_jurisdiction_exposure",
            "band": "exceptional",
            "name": "High-Risk Jurisdiction Exposure",
            "note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
            "notes": [
              {
                "code": "jurisdiction_evidence_limits",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "meaning": "self-published location evidence; not nationality or citizenship",
              "red_flag": false,
              "exposures": [],
              "policy_countries": [
                "Russia",
                "Iran",
                "North Korea"
              ],
              "commit_weight_rule": {
                "min_commits": 50,
                "min_commit_share": 0.1
              },
              "review_only_matches": 0,
              "below_threshold_exposures": [],
              "assessed_self_published_locations": 14
            },
            "components": [
              {
                "key": "policy_exposure_multiplier",
                "name": "Policy exposure multiplier",
                "detail": "no confirmed policy-scope location match",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "jurisdiction_no_match",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
      },
      {
        "key": "ai_readiness",
        "band": "good",
        "name": "AI Readiness",
        "value": 79,
        "weight": 0.04,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "exceptional",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "has_llms_txt": true,
              "legible_history_share": 0.84,
              "agent_instruction_files": [
                "AGENTS.md",
                "CLAUDE.md"
              ],
              "agent_instruction_max_bytes": 2595
            },
            "components": [
              {
                "key": "agent_instructions",
                "name": "Agent instructions",
                "detail": "AGENTS.md, CLAUDE.md",
                "points": 45,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "AGENTS.md, CLAUDE.md"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "machine_readable_docs_llms_txt",
                "name": "Machine-readable docs (llms.txt)",
                "detail": "llms.txt present",
                "points": 15,
                "status": "met",
                "details": [
                  {
                    "code": "llms_txt_present",
                    "params": {}
                  }
                ],
                "max_points": 15
              },
              {
                "key": "legible_commit_history",
                "name": "Legible commit history",
                "detail": "84 of 100 human commits state their intent (structured subject or explanatory body)",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 84,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "good",
            "name": "Verify loop (build / test / typecheck)",
            "note": null,
            "notes": [],
            "value": 77,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [
                "uv.lock"
              ],
              "has_dockerfile": false,
              "typed_language": false,
              "bootstrap_files": [
                "noxfile.py"
              ],
              "has_devcontainer": false,
              "has_linter_config": true,
              "typecheck_configs": [
                "duckdb_sqlalchemy/py.typed"
              ],
              "agent_commit_share": 0,
              "toolchain_manifests": [],
              "dependency_bot_commit_share": 0
            },
            "components": [
              {
                "key": "one_command_bootstrap",
                "name": "One-command bootstrap",
                "detail": "noxfile.py",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "noxfile.py"
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "automated_tests",
                "name": "Automated tests",
                "detail": null,
                "points": 22,
                "status": "met",
                "details": [],
                "max_points": 22
              },
              {
                "key": "lint_format_config",
                "name": "Lint / format config",
                "detail": null,
                "points": 11,
                "status": "met",
                "details": [],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": "duckdb_sqlalchemy/py.typed",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "duckdb_sqlalchemy/py.typed"
                    }
                  }
                ],
                "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": "dependency automation configured, none observed in the sampled commits",
                "points": 5,
                "status": "partial",
                "details": [
                  {
                    "code": "dependency_bot_config_only",
                    "params": {}
                  }
                ],
                "max_points": 8
              },
              {
                "key": "openssf_scorecard_pinned_dependencies",
                "name": "OpenSSF Scorecard: Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "ai_code_legibility",
            "band": "good",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 79,
            "inputs": {
              "primary_language": "Python",
              "largest_source_bytes": 75234,
              "source_files_sampled": 38,
              "oversized_source_files": 2
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "Python with type-check config (duckdb_sqlalchemy/py.typed)",
                "points": 27,
                "status": "partial",
                "details": [
                  {
                    "code": "typecheck_config_language",
                    "params": {
                      "files": "duckdb_sqlalchemy/py.typed",
                      "language": "Python"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "2/38 source files over 60KB",
                "points": 52.1,
                "status": "partial",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 38,
                      "oversized": 2
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          },
          {
            "key": "ai_interfaces",
            "band": "weak",
            "name": "Machine-readable interfaces",
            "note": null,
            "notes": [],
            "value": 40,
            "inputs": {
              "example_dirs": [
                "examples"
              ],
              "has_mcp_signal": false,
              "api_schema_files": []
            },
            "components": [
              {
                "key": "api_schema_openapi_graphql_proto",
                "name": "API schema (OpenAPI/GraphQL/proto)",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 40
              },
              {
                "key": "mcp_server",
                "name": "MCP server",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 20
              },
              {
                "key": "runnable_examples",
                "name": "Runnable examples",
                "detail": "examples",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "examples"
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          }
        ],
        "description": "How well is the repo equipped to be developed and maintained with AI coding agents? Carries a deliberately small weight: agent tooling is a real maintenance signal, but its absence must never gate the top of the scale (calibration saturates at raw 91, so 100/100 remains reachable with AI Readiness at zero)."
      }
    ],
    "classification": {
      "labels": [
        "library"
      ],
      "scores": {
        "library": 6
      },
      "primary": "library",
      "evidence": [
        {
          "tier": "distribution",
          "label": "library",
          "source": "registry:pypi",
          "weight": 6
        }
      ],
      "artifacts": [],
      "confidence": "medium",
      "host_extension": false,
      "runs_as_process": false,
      "consumed_by_code": true
    },
    "metrics_version": "2.3.1"
  },
  "warnings": [
    "Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
    "Community profile unavailable",
    "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository",
    "deps.dev does not index pypi:duckdb-sqlalchemy@1.5.4.7; advisories assessed against the repository dependency graph instead"
  ],
  "report_type": "repository",
  "generated_at": "2026-07-31T09:06:30.630424Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/l/leonardovida/duckdb-sqlalchemy.svg",
  "full_name": "leonardovida/duckdb-sqlalchemy",
  "license_state": "standard",
  "license_spdx": "MIT"
}

评分是信号,而非担保。 评分反映的是 GitHub 上公开可见的实践——不是代码审计,也不是安全保证。

缺失数据将被剔除并重新归一化权重,绝不按零分计。方法论已版本化并公开:指标 v2.3.1、模式 v0.27.0—— 完整方法论 · 指标知识库.

单项结果在整体记录中的位置: 汇总统计PyPI.