Public recordGood
Software health reportschema 0.27.0 · metrics 2.5.0 · 2026-07-30 03:45 UTC
hafenkran / duckdb-bigquery
Integrates DuckDB with Google BigQuery, allowing direct querying and management of BigQuery datasets
hafenkran/duckdb-bigquery holds a health index of 73 out of 100, placing it in the Good band. It scores highest on Vitality (94/100) and lowest on Security (47/100). It was last updated 4 days ago. A single contributor accounts for most of its recent work.
73
overall / 100Software health index
Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean, calibrated against the distribution of the public record so bands carry percentile meaning; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At Risk ceiling of 34.
73
Exceptional93-100The record's top tier (≈ top 5%); essentially all checked criteria met
Excellent80-92Strong across the board; minor gaps
Good65-79Healthy; gaps are limited and manageable
Moderate50-64Acceptable with notable gaps; review recommended
Weak35-49Material weaknesses across several areas
At Risk20-34Significant weaknesses; adoption warrants caution
Critical1-19Severe problems (abandoned, single-maintainer, no hygiene)
Score profile
Each axis is a category. The shape matters more than the average — a healthy subject fills the whole shape, while a spike-and-crater profile means strength in one dimension is masking risk in another.
The weighted overall 64 is calibrated to 73 on the published index scale (record calibration 2026-08-02).
Ownership
adwPersonal account
25 followers13 public repossince Apr 2013Planet Labs
This repository is owned by a personal account. A single-owner project carries more continuity risk than an organization-backed one.
Metrics by category
Vitality
Is the project alive — is code being written and are releases shipping?
94
Development activity
90Excellent
How it's scored
| 36/36 | Push recency — last push 4 days ago |
| 26.3/36 | Commit cadence — 38/52 weeks with commits |
| 18/18 | Commit volume — 358 commits in the last year |
| 10/10 | OpenSSF Scorecard: Maintained — 30 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 10 |
Inputs used
| commits_last_year | 358 |
| human_commit_share | 1 |
| days_since_last_push | 4 |
| active_weeks_last_year | 38 |
Release discipline
100Exceptional
How it's scored
| 27/27 | Ships releases — 29 releases published |
| 36/36 | Release recency — latest release 7 days ago |
| 27/27 | Release cadence — a release every ~14.6 days |
| 0/10 | OpenSSF Scorecard: Signed-Releases — no data |
Inputs used
| releases_count | 29 |
| latest_release_tag | v0.12.0 |
| releases_from_tags | no |
| days_since_latest_release | 7 |
| mean_days_between_releases | 14.6 |
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.
Community & Adoption
Does the project have users, downloads, attention, and a welcoming setup for contributors?
48
Popularity & adoption
47Weak
How it's scored
| 36/60 | Stars — 167 stars |
| 8/25 | Forks — 10 forks |
| 2.7/15 | Watchers — 4 watchers |
Inputs used
| forks | 10 |
| stars | 167 |
| watchers | 4 |
| growth_state | unverified |
| growth_factor_pct | 100 |
| growth_unverified_reason | no_history |
Community health
50Moderate
How it's scored
| 22.5/22.5 | README |
| 22.5/22.5 | License — recognized license (MIT) |
| 0/18 | CONTRIBUTING guide |
| 0/13.5 | Code of conduct |
| 0/7.2 | Issue template |
| 0/6.3 | PR template |
Inputs used
| has_readme | yes |
| has_license | yes |
| readme_badges | — |
| has_contributing | no |
| has_issue_template | no |
| has_code_of_conduct | no |
| readme_badge_services | — |
| has_pull_request_template | no |
Sustainability & Governance
Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?
50
Maintainer resilience (bus factor)
25At Risk
How it's scored
| 9/54 | Bus factor — 1 contributor(s) cover half of all commits |
| 0.8/22.5 | Commit distribution — top contributor authored 96% of commits |
| 5.4/13.5 | Contributor breadth — 4 contributors |
| 10/10 | OpenSSF Scorecard: Contributors — project has 3 contributing companies or organizations -- score normalized to 10 |
Inputs used
| bus_factor | 1 |
| contributors_sampled | 4 |
| top_contributor_share | 0.964 |
How it's scored
| 39.4/42 | Issue resolution — 94% of issues closed |
| 28.7/30 | PR acceptance — 155/162 decided PRs merged |
| 0/13 | Newcomer PR acceptance — no first-time contributor's PR decided in 30d |
| 0/15 | OpenSSF Scorecard: Code-Review — Found 0/5 approved changesets -- score normalized to 0 |
Inputs used
| merged_prs | 155 |
| open_issues | 3 |
| closed_issues | 45 |
| prs_merged_7d | — |
| prs_decided_7d | — |
| prs_merged_30d | — |
| prs_decided_30d | — |
| issue_closed_ratio | 0.938 |
| closed_unmerged_prs | 7 |
| first_time_authors_30d | — |
| first_time_prs_merged_30d | — |
| first_time_prs_decided_30d | — |
Excluded from scoring (no data or not applicable): newcomer_pr_acceptance. Remaining weights renormalized.
Ownership & stewardship
51Moderate
How it's scored
| 10/30 | Ownership backing — personal (user) account |
| 0/20 | Verified domain — not applicable to user accounts |
| 10.2/25 | Owner reach — 25 followers of hafenkran |
| 20.3/25 | Track record — 13 public repos, account ~13 yr old |
Inputs used
| followers | 25 |
| owner_type | User |
| is_verified | — |
| owner_login | hafenkran |
| public_repos | 13 |
| account_age_days | 4,847 |
Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.
Engineering Quality
Are baseline engineering and documentation practices in place?
80
Engineering practices
100Exceptional
How it's scored
| 24/24 | CI workflows — 4 workflow(s) |
| 24/24 | Tests present |
| 16/16 | Linter config |
| 9.6/9.6 | Pre-commit hooks |
| 6.4/6.4 | .editorconfig |
| 20/20 | OpenSSF Scorecard: CI-Tests — 3 out of 3 merged PRs checked by a CI test -- score normalized to 10 |
Inputs used
| has_ci | yes |
| has_tests | yes |
| has_editorconfig | yes |
| has_linter_config | yes |
| has_precommit_config | yes |
Documentation
50Moderate
How it's scored
| 30/30 | README |
| 0/25 | Documentation directory |
| 0/15 | Documentation / homepage site |
| 10/10 | Repository description |
| 10/10 | Topics — 3 topics |
| 0/10 | Wiki |
Inputs used
| topics | bigquery, duckdb, duckdb-extension |
| has_wiki | no |
| homepage | — |
| has_readme | yes |
| has_docs_dir | no |
| has_description | yes |
Security
Are visible security and supply-chain practices strong, without unresolved high-risk jurisdiction exposure?
47
Security posture
47Weak
How it's scored
| 7.5/7.5 | Binary-Artifacts — no binaries found in the repo |
| 0/7.5 | Branch-Protection — no data |
| 2.5/2.5 | CI-Tests — 3 out of 3 merged PRs checked by a CI test -- score normalized to 10 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 0/7.5 | Code-Review — Found 0/5 approved changesets -- score normalized to 0 |
| 2.5/2.5 | Contributors — project has 3 contributing companies or organizations -- score normalized to 10 |
| 10/10 | Dangerous-Workflow — no dangerous workflow patterns detected |
| 0/7.5 | Dependency-Update-Tool — no update tool detected |
| 0/5 | Fuzzing — project is not fuzzed |
| 2.5/2.5 | License — license file detected |
| 7.5/7.5 | Maintained — 30 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 10 |
| 0/5 | Packaging — no data |
| 0/5 | Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
| 0/5 | SAST — SAST tool is not run on all commits -- score normalized to 0 |
| 0/5 | Security-Policy — security policy file not detected |
| 0/7.5 | Signed-Releases — no data |
| 0/7.5 | Token-Permissions — detected GitHub workflow tokens with excessive permissions |
| 7.5/7.5 | Vulnerabilities — 0 existing vulnerabilities detected |
Inputs used
| source | openssf_scorecard |
| checks_evaluated | 15 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 3 |
| scorecard_aggregate | 4.7 |
Excluded from scoring (no data or not applicable): branch_protection, packaging, signed_releases. Remaining weights renormalized.
AI Readiness
How well is the repo equipped to be developed and maintained with AI coding agents? Carries a deliberately small weight (4%): agent tooling is a real maintenance signal, but a repository with none can still reach 100/100.
52
Agent context & guidance
16Critical
How it's scored
| 0/45 | Agent instructions — no CLAUDE.md / AGENTS.md / editor rules |
| 0/15 | Machine-readable docs (llms.txt) |
| 16/40 | Legible commit history — 30 of 100 human commits state their intent (structured subject or explanatory body) |
Inputs used
| has_llms_txt | no |
| legible_history_share | 0.3 |
| agent_instruction_files | — |
| agent_instruction_max_bytes | — |
Verify loop (build / test / typecheck)
62Moderate
How it's scored
| 18/18 | One-command bootstrap — Makefile |
| 22/22 | Automated tests |
| 11/11 | Lint / format config |
| 11/11 | Static type checking — C++ (statically typed) |
| 0/10 | Reproducible environment |
| 0/10 | Demonstrated agent practice — no agent-authored commits among the last 100 |
| 0/8 | Automated maintenance — no automated dependency updates observed |
| 0/10 | OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
Inputs used
| has_nix | no |
| has_tests | yes |
| lockfiles | — |
| has_dockerfile | no |
| typed_language | yes |
| bootstrap_files | Makefile |
| has_devcontainer | no |
| has_linter_config | yes |
| typecheck_configs | — |
| agent_commit_share | 0 |
| toolchain_manifests | — |
| dependency_bot_commit_share | 0 |
Code legibility for models
98Exceptional
How it's scored
| 45/45 | Type-checkable code — C++ (statically typed) |
| 53.3/55 | Manageable file sizes — 2/65 source files over 60KB |
Inputs used
| primary_language | C++ |
| largest_source_bytes | 94,199 |
| source_files_sampled | 65 |
| oversized_source_files | 2 |
Key facts
167GitHub stars
4contributors
358commits, last 12 months
4days since last push
29releases
1bus factor
3open issues
—package ecosystems
Data collection warnings
- Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
More detail
Star and fork history 0 ★ / 10 ⇿
0Stars
10Forks
28Releases
When each star and fork was added, collected from GitHub and bucketed by day. Cumulative growth sits directly above the daily additions it is made of, so the two read against each other: steady organic accretion looks nothing like an abrupt, short-lived burst. Where that difference is measurable, it is reported as growth authenticity.
Major 0Minor 11Patch 16
Each point covers 2 days.
OpenSSF Scorecard 4.7 / 10
4.7aggregate
Independent, tool-agnostic security assessment from the open-source OpenSSF Scorecard. Each check rewards a security practice, not a specific vendor's tool. Checks Scorecard could not determine are marked n/a and excluded from the security score (never counted as zero).
| 10 | Binary-Artifacts | no binaries found in the repo |
| n/a | Branch-Protection | internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md |
| 10 | CI-Tests | 3 out of 3 merged PRs checked by a CI test -- score normalized to 10 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 0 | Code-Review | Found 0/5 approved changesets -- score normalized to 0 |
| 10 | Contributors | project has 3 contributing companies or organizations -- score normalized to 10 |
| 10 | Dangerous-Workflow | no dangerous workflow patterns detected |
| 0 | Dependency-Update-Tool | no update tool detected |
| 0 | Fuzzing | project is not fuzzed |
| 10 | License | license file detected |
| 10 | Maintained | 30 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 10 |
| n/a | Packaging | packaging workflow not detected |
| 0 | Pinned-Dependencies | dependency not pinned by hash detected -- score normalized to 0 |
| 0 | SAST | SAST tool is not run on all commits -- score normalized to 0 |
| 0 | Security-Policy | security policy file not detected |
| n/a | Signed-Releases | no releases found |
| 0 | Token-Permissions | detected GitHub workflow tokens with excessive permissions |
| 10 | Vulnerabilities | 0 existing vulnerabilities detected |
All dependencies 0
Full resolved dependency set from the GitHub dependency graph: 0 direct and 0 indirect (transitive) packages. The transitive closure is complete when the repository commits a lockfile.
| Registry | Package | Version | Relation |
|---|
Dependency advisories not assessed
Advisory matching could not run for this report: No resolved dependencies to assess
Raw JSON report machine-readable
{
"data": {
"repo": {
"topics": [
"bigquery",
"duckdb",
"duckdb-extension"
],
"is_fork": false,
"size_kb": 105695,
"has_wiki": false,
"homepage": null,
"languages": {
"C++": 663380,
"CMake": 12513,
"Shell": 6209,
"Python": 27767,
"Makefile": 1757
},
"pushed_at": "2026-07-25T10:20:03Z",
"created_at": "2024-06-07T19:58:45Z",
"owner_type": "User",
"updated_at": "2026-07-22T20:45:25Z",
"description": "Integrates DuckDB with Google BigQuery, allowing direct querying and management of BigQuery datasets",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "main",
"license_spdx_raw": "MIT",
"primary_language": "C++",
"significant_languages": [
"C++"
]
},
"owner": {
"blog": null,
"name": "adw",
"type": "User",
"login": "hafenkran",
"company": "Planet Labs",
"location": "Berlin, Germany",
"followers": 25,
"avatar_url": "https://avatars.githubusercontent.com/u/4216598?v=4",
"created_at": "2013-04-21T13:57:31Z",
"is_verified": null,
"public_repos": 13,
"account_age_days": 4847
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v0.12.0",
"kind": "minor",
"published_at": "2026-07-22T19:04:18Z"
},
{
"tag": "v0.11.0",
"kind": "minor",
"published_at": "2026-06-04T06:03:22Z"
},
{
"tag": "v0.10.0",
"kind": "minor",
"published_at": "2026-05-19T17:07:49Z"
},
{
"tag": "v0.9.0",
"kind": "minor",
"published_at": "2026-05-06T18:35:13Z"
},
{
"tag": "v0.8.1",
"kind": "patch",
"published_at": "2026-04-22T18:52:06Z"
},
{
"tag": "v0.8.0",
"kind": "minor",
"published_at": "2026-04-16T16:42:26Z"
},
{
"tag": "v0.7.4",
"kind": "patch",
"published_at": "2026-03-30T20:32:17Z"
},
{
"tag": "v0.7.3",
"kind": "patch",
"published_at": "2026-03-28T10:16:00Z"
},
{
"tag": "v0.7.2",
"kind": "patch",
"published_at": "2026-03-13T09:54:03Z"
},
{
"tag": "v0.7.2_andium",
"kind": "other",
"published_at": "2026-03-13T09:38:53Z"
},
{
"tag": "v0.7.1",
"kind": "patch",
"published_at": "2026-02-21T14:21:21Z"
},
{
"tag": "v0.7.0",
"kind": "minor",
"published_at": "2026-02-08T10:04:03Z"
},
{
"tag": "v0.6.3",
"kind": "patch",
"published_at": "2025-12-11T16:51:39Z"
},
{
"tag": "v0.6.2",
"kind": "patch",
"published_at": "2025-11-16T17:26:49Z"
},
{
"tag": "v0.6.1",
"kind": "patch",
"published_at": "2025-11-02T19:52:16Z"
},
{
"tag": "v0.6.0",
"kind": "minor",
"published_at": "2025-10-18T09:59:28Z"
},
{
"tag": "v0.5.1",
"kind": "patch",
"published_at": "2025-10-10T20:12:49Z"
},
{
"tag": "v0.5.0",
"kind": "minor",
"published_at": "2025-09-17T18:40:15Z"
},
{
"tag": "v0.4.2",
"kind": "patch",
"published_at": "2025-08-24T13:35:53Z"
},
{
"tag": "v0.4.1",
"kind": "patch",
"published_at": "2025-07-10T21:07:10Z"
},
{
"tag": "v0.4.0",
"kind": "minor",
"published_at": "2025-06-20T09:02:32Z"
},
{
"tag": "v0.3.1",
"kind": "patch",
"published_at": "2025-05-25T12:56:32Z"
},
{
"tag": "v0.3.0",
"kind": "minor",
"published_at": "2025-04-29T07:06:20Z"
},
{
"tag": "v0.2.2",
"kind": "patch",
"published_at": "2025-04-09T20:40:19Z"
},
{
"tag": "v0.2.1",
"kind": "patch",
"published_at": "2025-03-12T20:06:01Z"
},
{
"tag": "v0.2.0",
"kind": "minor",
"published_at": "2025-02-06T18:57:00Z"
},
{
"tag": "v0.1.2",
"kind": "patch",
"published_at": "2025-01-02T22:12:29Z"
},
{
"tag": "v0.1.1",
"kind": "patch",
"published_at": "2024-12-31T14:31:42Z"
},
{
"tag": "v0.1.0",
"kind": "minor",
"published_at": "2024-11-03T17:15:57Z"
}
],
"recent_commits": [
{
"oid": "0c55a9b81646002edc0c73f36b703c8c39cea2ab",
"body": "Fix billing project handling for bigquery_query dry runs",
"is_bot": false,
"headline": "Merge pull request #211 from hafenkran/fix/dry-run-billing-project",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-07-19T10:30:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cdae41b9d0dcc4ac43adc83b280b2305dfa3ec11",
"body": null,
"is_bot": false,
"headline": "updated readme",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-07-19T10:29:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5d9ab1db3584dafb4e7e5915655f93276324a3aa",
"body": null,
"is_bot": false,
"headline": "Document unsupported musl build",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-07-18T21:02:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8ebea2dc4cfe83e60f3adc70033742f6db65eba4",
"body": null,
"is_bot": false,
"headline": "Fix billing project for query dry runs",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-07-18T14:21:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d750a93df65abf09b848b751ca644ff301d0b4b6",
"body": "…ssion-pushdown\n\nExpand experimental BigQuery aggregate pushdown",
"is_bot": false,
"headline": "Merge pull request #210 from hafenkran/feature/aggregate-filter-expre…",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-07-17T14:03:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "988bf9be6a99bde801e8526c32faa091423912d9",
"body": null,
"is_bot": false,
"headline": "Mark aggregate pushdown experimental",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-07-17T08:16:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "790c18d141d8a53f244982452bdd8006e722d4ed",
"body": null,
"is_bot": false,
"headline": "Push down distinct aggregate variants",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-07-12T20:07:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7e46ae3b093e246e47c1a05514a635ac3617d58e",
"body": null,
"is_bot": false,
"headline": "Push down sin and group string float expressions",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-07-01T21:14:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b92a5e71fe7ad5ce75b6b5b91ed48d8124fbe880",
"body": null,
"is_bot": false,
"headline": "Push down count distinct expressions",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-07-01T21:02:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "679603cfb0b9675bd60f0b77f76d5c8e0c537fa4",
"body": null,
"is_bot": false,
"headline": "Push down varchar-casts, float-modulo, constructor strings",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-07-01T20:51:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "54dfc0d68418c5120486145b98714a6b020dc817",
"body": null,
"is_bot": false,
"headline": "Push down float modulo filters",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-07-01T19:58:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6159d13e6fbcaf941e8d0a52d79fb9fa8fda7c7e",
"body": null,
"is_bot": false,
"headline": "Push down additional aggregate group keys",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-30T21:11:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b3952217f6b0200ef35645f193fffdc5ced44483",
"body": null,
"is_bot": false,
"headline": "Push down aggregate group by expressions",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-30T20:50:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "367aae2f6913e7c12a31381217171f65bcfe37e1",
"body": null,
"is_bot": false,
"headline": "Push down dynamic modulo and nested string casts",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-30T20:12:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "183893d5e0000ae7228efecc45485aec108ec7f9",
"body": null,
"is_bot": false,
"headline": "Push down list casts and float modulo filters",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-29T19:57:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cefcc4744269d08ed70cdb6a1034c2da0cc4d28c",
"body": null,
"is_bot": false,
"headline": "Push down more aggregate argument functions",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-29T19:25:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "32c34cf639d10b9405ccd4419eb726847d436676",
"body": null,
"is_bot": false,
"headline": "Push down TRY_CAST aggregate arguments",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-29T18:59:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "97cc4e70a2c4a8fd742a37631258306a5f1018db",
"body": null,
"is_bot": false,
"headline": "Push down selected group by expressions",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-29T18:15:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "10c212ca039b75433657e85807083e338828f94c",
"body": null,
"is_bot": false,
"headline": "Push down temporal casts and group-by ABS aggregates",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-27T15:19:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bf1198120d6bf84ed723f017fcf673b1a75e2932",
"body": null,
"is_bot": false,
"headline": "Push down abs aggregate filters",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-27T09:45:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "451c9ba05bb8c6efe22f99f653fbe939cdcf3808",
"body": null,
"is_bot": false,
"headline": "Push down try_cast aggregate filters",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-27T09:45:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8f629320a6ab2db7184068b8d1bcc76bb3d541e8",
"body": null,
"is_bot": false,
"headline": "Fix numeric filter pushdown tests",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-27T09:45:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7deecb963dd9c3b23b5cb45b400a2f968ebaa05d",
"body": null,
"is_bot": false,
"headline": "Handle integer float modulo literals",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-27T09:45:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c24446ec5951e757a3d8a258b29016968fcb0ec1",
"body": null,
"is_bot": false,
"headline": "Document aggregate filter expression pushdown",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-27T09:45:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c1abb7cae01e45a3d4a6df6a7673dd8a44b55bf4",
"body": null,
"is_bot": false,
"headline": "Test aggregate filter expression pushdown",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-27T09:45:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "915be090af2cafb45f699c295a37504f956df9fd",
"body": null,
"is_bot": false,
"headline": "Push down scalar aggregate filters",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-27T09:45:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b9b903bcd73f8c1bd5cad28fd50487cc0833ee41",
"body": "Separate extension tests from build artifacts and skip fork PR GCP tests",
"is_bot": false,
"headline": "Merge pull request #163 from hafenkran/skip_tests_on_fork_pr",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-27T08:10:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dac99d0d3f8eebd70c47aa7602c57c9c4d618a03",
"body": null,
"is_bot": false,
"headline": "Restore full matrix with credential-gated tests",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-26T19:45:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "87b48e9dfc2bb84b683b7abf6b1ce0c59e358265",
"body": null,
"is_bot": false,
"headline": "Limit PR test matrix to Linux",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-26T17:45:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9dfb94f4c796a77918d629a04ed0f066def01e29",
"body": null,
"is_bot": false,
"headline": "Fix split test workflow artifacts",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-26T17:40:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3aeccd20694ba5e4d47520db2073133611463f89",
"body": null,
"is_bot": false,
"headline": "Split extension tests from distribution workflow",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-26T17:38:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ac34cd256686ce761d24437c13ab61c08295c843",
"body": null,
"is_bot": false,
"headline": "skip tests on fork prs",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-26T17:38:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2aac966e781dca3b9c9d2f5c42fa1e4d94277025",
"body": "…ate-pushdown\n\nAdd division and modulo aggregate pushdown",
"is_bot": false,
"headline": "Merge pull request #209 from hafenkran/feature/division-modulo-aggreg…",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-23T19:22:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7dd22f0f09689bb3d9b1bf365acb293a96225f76",
"body": null,
"is_bot": false,
"headline": "Add local formatting and editor configuration",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-22T21:43:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4cc4f2526506c7a0c57d0ec39b161fae373f90da",
"body": null,
"is_bot": false,
"headline": "Push down division and modulo aggregate expressions",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-22T21:43:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "025f40ca89a361910e9a421dc6840c63c60aa958",
"body": "…ushdown\n\nPush Down Arithmetic Expressions in Aggregate Arguments",
"is_bot": false,
"headline": "Merge pull request #208 from hafenkran/feature/aggregate-expression-p…",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-22T17:08:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d3bf78179cf574e962d63260b8a5e39ad1fdc1c1",
"body": null,
"is_bot": false,
"headline": "Propagate aggregate expressions through projections",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-21T14:56:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fb53c4519d67739ef7c2e7062b84b43ac99ee261",
"body": null,
"is_bot": false,
"headline": "Test aggregate expression pushdown",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-21T14:22:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0632973a5b1c3fec72c9262bb5bf6e6cfe0fcf6f",
"body": null,
"is_bot": false,
"headline": "Add aggregate expression pushdown",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-21T14:22:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aa4b1a3cc95fa90d104b8b512fc61f95ddbd1f76",
"body": "Push Down COUNT(DISTINCT Column)",
"is_bot": false,
"headline": "Merge pull request #207 from hafenkran/feature/count-distinct-pushdown",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-21T14:21:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "878d9b8a47ec3d9fad534bf817bde4a58d2966f7",
"body": null,
"is_bot": false,
"headline": "Test COUNT DISTINCT aggregate pushdown",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-21T12:29:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5a6cb4e2db3d7d7e7d4acd4bdc5f93ae3c02dbcf",
"body": null,
"is_bot": false,
"headline": "Add COUNT DISTINCT aggregate pushdown",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-21T12:29:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "14843c83a2d01e7d955578c2953f50c7fc3169b3",
"body": "…down\n\nPush Down Grouped Aggregates",
"is_bot": false,
"headline": "Merge pull request #206 from hafenkran/feature/grouped-aggregate-push…",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-21T09:19:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "81f3fa40c22adc154f06d1bad4e45d5290af6c3f",
"body": null,
"is_bot": false,
"headline": "Expand aggregate pushdown coverage",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-20T10:21:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c1f5515ff9f64d060c79a5a6a2066fca40bd5acb",
"body": null,
"is_bot": false,
"headline": "Add grouped BigQuery aggregate pushdown",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-20T10:21:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3f634647233d35d2559783457d61758957bc259a",
"body": "…hdown\n\nFeature/bigquery aggregate pushdown",
"is_bot": false,
"headline": "Merge pull request #204 from hafenkran/feature/bigquery-aggregate-pus…",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-20T06:51:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c191bc466f1d92162e96f716bdab83ee2eea84bc",
"body": null,
"is_bot": false,
"headline": "Refine aggregate pushdown helper structure",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-19T19:32:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "47f506f8b32a9ed8a6511cec8d2e099927489a04",
"body": null,
"is_bot": false,
"headline": "Fix aggregate pushdown null filter test",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-19T19:32:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d1df90d66c4f1c14f23bad1f10d07d3ee25937cc",
"body": null,
"is_bot": false,
"headline": "Add BigQuery aggregate pushdown tests",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-19T19:32:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "08d4ec0fe7ebaa8c584a216779f9c6d3527a4a13",
"body": null,
"is_bot": false,
"headline": "Add BigQuery aggregate pushdown optimizer",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-19T19:32:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ccff4035645a1d530d061cd48870d60e88f08279",
"body": null,
"is_bot": false,
"headline": "Refactor BigQuery SQL filter helpers",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-19T19:31:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "de7cee9a1b2c733630e1335a264a15590f2840af",
"body": "Add additional bigquery_load format support",
"is_bot": false,
"headline": "Merge pull request #202 from hafenkran/feature/bigquery-load-2.0",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-19T19:10:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6dca25c9390f6cf814429507236eb39853653377",
"body": null,
"is_bot": false,
"headline": "docs(load): document load 2.0 API",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-19T14:44:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4ce9a32e594b8921406384bf204693e0aa7928c8",
"body": null,
"is_bot": false,
"headline": "test(load): cover load 2.0 options",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-19T14:44:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "eb093beedc96be0071a2563f79a3f611fed0974d",
"body": null,
"is_bot": false,
"headline": "feat(load): expose load 2.0 SQL options",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-19T14:44:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "562d84373ef0f6bfbd6a735026176cffba9dfd5f",
"body": null,
"is_bot": false,
"headline": "feat(load): add generic load job options",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-19T14:44:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1eb940c8063bb439f32de03beddc8ff95937b3a6",
"body": "update duckdb to v1.5.4",
"is_bot": false,
"headline": "Merge pull request #205 from hafenkran/duckdb_v1.5.4",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-19T06:50:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0998623be8c52d59fbb383f471cc4f452d4a7d29",
"body": null,
"is_bot": false,
"headline": "Add PyYAML to format check environment",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-18T21:29:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "786119418284ad7f625299d49b45c3cda9cec242",
"body": null,
"is_bot": false,
"headline": "Make format check setup more robust",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-18T21:24:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cbb2fb1a5a94d41bfe597d649b7727c9ae0aba72",
"body": null,
"is_bot": false,
"headline": "Update extension distribution workflow",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-18T16:53:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4369271b2bded1e0ab7f8a7ec1143d1533843f2b",
"body": null,
"is_bot": false,
"headline": "Force MSVC compiler for Windows distribution builds",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-18T16:45:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "82ad0f8e57bb55ac74c75dc0a815954835e655d6",
"body": null,
"is_bot": false,
"headline": "Fix Arrow Snappy target compatibility",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-18T07:43:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f894c99f35b4fbb370506e3088559fdd475afd0c",
"body": null,
"is_bot": false,
"headline": "updated duckdb to v1.5.4",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-17T20:00:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6bbc20e5fedcb7f878e46582e73e18dfbd1540b9",
"body": "Use attached BigQuery dataset as the default schema",
"is_bot": false,
"headline": "Merge pull request #201 from hafenkran/fix/default-schema-dataset",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-10T07:35:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "577fbf220a794d277509b91240fe61fb1dbc3ea2",
"body": null,
"is_bot": false,
"headline": "Fix BigQuery default schema for dataset attaches",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-09T19:31:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a470c89364b68ea6711cabab6f295ddbc2cb21ad",
"body": "Add BQ table extract jobs via bigquery_extract",
"is_bot": false,
"headline": "Merge pull request #199 from hafenkran/feature/bigquery-extract-job",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-09T17:49:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "22da25742f22cb5e3675bcbbf08b80d8b094b2ee",
"body": "Avoid redundant ReadRows call at stream EOF",
"is_bot": false,
"headline": "Merge pull request #200 from hafenkran/remove-extra-eof-readrows",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-06-08T06:44:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c17b4b255c1ad87091033e3d8215e3170f20a78c",
"body": null,
"is_bot": false,
"headline": "Avoid EOF ReadRows resume",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-07T18:29:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "43df005ad8933cb9be52a7ea8e9d8060c6340865",
"body": null,
"is_bot": false,
"headline": "Refine bigquery_extract parameters",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-07T15:33:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5f6d197af49411e24cfeb02f9c279334e5462a22",
"body": null,
"is_bot": false,
"headline": "Rename export function to bigquery_extract",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-07T13:16:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3db8e3c9816f00f7ac3cbe078310faccfa701220",
"body": null,
"is_bot": false,
"headline": "Document and test bigquery_export extract jobs",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-06T19:13:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "880eebf149749b298f760494236b6d1d9528712a",
"body": null,
"is_bot": false,
"headline": "Register bigquery_export table function",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-06T19:13:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "296e4e1663e9771aaf6ac5f5c4c7826f9b18fa7e",
"body": null,
"is_bot": false,
"headline": "Add BigQuery extract job client support",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-06T19:13:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ec1aeafd784dfff0c384847c79bca98423d41dd3",
"body": null,
"is_bot": false,
"headline": "format",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-06-01T19:57:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a65ade17db3da55e12befc81a3bb6d14de80ae07",
"body": "feat(bigquery_execute): add destination_table for query-to-table jobs",
"is_bot": false,
"headline": "Merge pull request #196 from jatorre/feat/query-destination-table",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-05-31T21:23:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "292ff3c5e1dd9d4ddb2d5d01b639c09f025a55d1",
"body": "The result column was declared VARCHAR but always fed a BIGINT value (cast\nimplicitly on output), inconsistent with the integer total_rows/total_bytes\ncolumns beside it. Declare it BIGINT to match the value and the README example.",
"is_bot": false,
"headline": "refactor(bigquery_execute): type num_dml_affected_rows as BIGINT",
"author_name": "Javier de la Torre",
"author_login": "jatorre",
"committed_at": "2026-05-31T17:35:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f3b0941593138543630764ba42a7f222fe2a3735",
"body": "- Respect bq_query_timeout_ms on the destination path: fall back to the\n session timeout when no per-call timeout_ms is given instead of waiting\n forever (mirrors ExecuteQuery).\n- Report real job metadata (total_rows from the query results,\n total_bytes_processed and num_dml_affected_rows from jo\n[…]\nn_table write, invalid disposition, and\n destination_table + dry_run rejection.\n- Document destination_table / write_disposition / create_disposition in the\n README bigquery_execute parameter table.",
"is_bot": false,
"headline": "fix(bigquery_execute): address destination_table review feedback",
"author_name": "Javier de la Torre",
"author_login": "jatorre",
"committed_at": "2026-05-31T17:21:12Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "6e99c9d3f431639fb4e72f0b9f6adce7ce89d79c",
"body": "…read\n\nAdjust parallel BQ Storage Read scans",
"is_bot": false,
"headline": "Merge pull request #197 from hafenkran/fix/bigquery-storage-parallel-…",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-05-31T09:07:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5e677a4e3f1233484efc8811bbb99c0b6079fb4a",
"body": null,
"is_bot": false,
"headline": "Document BigQuery read stream limits",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-30T09:03:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0e58dd5c8e5e02949ce1077b45cc56cd3e4eb1a3",
"body": null,
"is_bot": false,
"headline": "Parallelize BigQuery Storage API scans",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-30T09:03:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "49fa35fd7f235a41fc288d0d88d9641ef94ba9a2",
"body": "bigquery_execute runs queries via the jobs.query REST endpoint, which cannot\nwrite results to a destination table. There is no way to run a SELECT and land\nits result in `dataset.table`.\n\nAdd optional destination_table / write_disposition / create_disposition named\nparameters. When destination_table\n[…]\nEXT(wkt) AS geom FROM staging',\n destination_table := 'dataset.table',\n write_disposition := 'WRITE_TRUNCATE');\n\nRebased onto main after #195 (query job polling); reuses its timeout_ms plumbing.",
"is_bot": false,
"headline": "feat(bigquery_execute): add destination_table for query-to-table jobs",
"author_name": "Javier de la Torre",
"author_login": "jatorre",
"committed_at": "2026-05-28T22:54:51Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "d7235af9393abcdbb09b82b3d5d88c45af7d9a4a",
"body": "Poll long-running BQ query jobs to completion and introduce new timeout_ms param",
"is_bot": false,
"headline": "Merge pull request #195 from hafenkran/fix/bigquery-query-polling",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-05-28T22:07:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "15ea9bae549d583ba0112591441baa6a99af1ef5",
"body": null,
"is_bot": false,
"headline": "Make BigQuery zero timeouts wait indefinitely",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-28T17:29:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4e46b2ae320e915650fcb108633de416d8da97a6",
"body": null,
"is_bot": false,
"headline": "Add per-call timeouts for BigQuery functions",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-27T19:46:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "671a7d5211863da90cac32a1b4cb57b7c9ff7694",
"body": null,
"is_bot": false,
"headline": "Make BigQuery query timeout cover polling",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-27T19:32:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8a8daab07f6181a1c732fda871cc63ced5701941",
"body": null,
"is_bot": false,
"headline": "Poll long-running BigQuery query jobs to completion",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-27T19:12:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "af6d66cd259ab36fd851b99126a59574699c907e",
"body": "…light\n\nValidate bq credentials during attach",
"is_bot": false,
"headline": "Merge pull request #193 from hafenkran/feat/bigquery-attach-auth-pref…",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-05-27T06:48:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "53b49b1ba78aefb1bdf2ba3d98105a5cae5c16c6",
"body": null,
"is_bot": false,
"headline": "Validate BigQuery credentials during attach",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-26T18:45:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2eb8a02d31c0386a294e50879b476a691e9903a7",
"body": "Update DuckDB to v1.5.3",
"is_bot": false,
"headline": "Merge pull request #192 from hafenkran/update-duckdb-v1.5.3",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-05-24T06:46:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5f24a9e16162f89b5a8bfe1bff7698b800d7f1f7",
"body": null,
"is_bot": false,
"headline": "Update DuckDB to v1.5.3",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-23T19:49:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8091e0d1e4c3d4e4c33135a95bd45222eb210cf1",
"body": "Unify BQ filter rendering",
"is_bot": false,
"headline": "Merge pull request #191 from hafenkran/fix/bigquery-filter-rendering",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-05-22T19:47:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e5e596f26655ddd13fddbf31d38bc0e6509af028",
"body": null,
"is_bot": false,
"headline": "Unify BigQuery filter rendering",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-22T14:52:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b1d0e5e500cbc40c27756bcb1b1c182c643cd6d0",
"body": "Rebind BigQuery catalog on stale columns",
"is_bot": false,
"headline": "Merge pull request #190 from hafenkran/fix/bigquery-stale-cache-rebind",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-05-22T11:41:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5664dcda5397d9e6f5b9c23b923ef37b374ee53c",
"body": null,
"is_bot": false,
"headline": "Rebind BigQuery catalog on stale columns",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-22T07:31:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "190009058cefb0faf7653fd58aa5b5444f859de9",
"body": "Avoid BQ scans for remote DML",
"is_bot": false,
"headline": "Merge pull request #189 from hafenkran/optimize/bigquery-dml-no-scan",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-05-20T16:37:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0a570f47fb029da52129ebe8293353b433bc747e",
"body": null,
"is_bot": false,
"headline": "dml no scan plan test",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-19T21:18:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "71654b6ba144d5c9ffb73731a91d5a89d3cea281",
"body": "# Conflicts:\n#\tsrc/storage/bigquery_delete.cpp\n#\tsrc/storage/bigquery_update.cpp",
"is_bot": false,
"headline": "Avoid BigQuery scans for remote DML",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-19T21:17:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0715cd878e37e340c3bcd7372fee4fb0daec60d4",
"body": "…count\n\nReturn DML affected row counts",
"is_bot": false,
"headline": "Merge pull request #188 from hafenkran/fix/bigquery-dml-affected-row-…",
"author_name": "adw",
"author_login": "hafenkran",
"committed_at": "2026-05-18T17:53:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "93fc31987059d4707fdc677c320bc8c784a4dd52",
"body": null,
"is_bot": false,
"headline": "Fix Windows DML enum names",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-17T21:48:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "842aba1b6662cf3dfcfe19b8ad4c42ec926ba269",
"body": null,
"is_bot": false,
"headline": "format",
"author_name": "hafenkran",
"author_login": "hafenkran",
"committed_at": "2026-05-17T17:41:58Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 29,
"commits_last_year": 358,
"latest_release_at": "2026-07-22T19:04:18Z",
"latest_release_tag": "v0.12.0",
"releases_from_tags": false,
"days_since_last_push": 4,
"active_weeks_last_year": 38,
"days_since_latest_release": 7,
"mean_days_between_releases": 14.6
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": false,
"health_percentage": 42,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": []
},
"popularity": {
"forks": 10,
"stars": 167,
"watchers": 4,
"fork_history": {
"days": [
{
"date": "2024-08-13",
"count": 1
},
{
"date": "2024-09-13",
"count": 1
},
{
"date": "2024-10-12",
"count": 1
},
{
"date": "2024-12-12",
"count": 1
},
{
"date": "2025-04-02",
"count": 1
},
{
"date": "2025-09-20",
"count": 1
},
{
"date": "2025-10-07",
"count": 1
},
{
"date": "2026-02-08",
"count": 1
},
{
"date": "2026-05-27",
"count": 1
},
{
"date": "2026-07-09",
"count": 1
}
],
"complete": true,
"collected": 10,
"total_forks": 10
},
"star_history": null,
"open_issues_and_prs": 5
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": false,
"has_mcp_signal": false,
"bootstrap_files": [
"Makefile"
],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [],
"largest_source_bytes": 94199,
"source_files_sampled": 65,
"oversized_source_files": 2,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"dependencies": {
"manifests": [],
"advisories": {
"error": "No resolved dependencies to assess",
"scope": "repository_graph",
"source": null,
"findings": [],
"collected": false,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 0,
"malicious_count": 0,
"assessed_package": null,
"unassessed_count": 0,
"direct_affected_count": 0
},
"ecosystems": [],
"dependencies": [],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [],
"collected": true,
"truncated": false,
"total_count": 0,
"direct_count": 0,
"indirect_count": 0
}
},
"maintainership": {
"issues": {
"open_prs": 2,
"merged_prs": 155,
"open_issues": 3,
"closed_ratio": 0.938,
"closed_issues": 45,
"closed_unmerged_prs": 7
},
"bus_factor": 1,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "hafenkran",
"commits": 792,
"avatar_url": "https://avatars.githubusercontent.com/u/4216598?v=4"
},
{
"type": "User",
"login": "jatorre",
"commits": 19,
"avatar_url": "https://avatars.githubusercontent.com/u/127803?v=4"
},
{
"type": "User",
"login": "jankramer",
"commits": 8,
"avatar_url": "https://avatars.githubusercontent.com/u/1487934?v=4"
},
{
"type": "User",
"login": "jrosskopf",
"commits": 3,
"avatar_url": "https://avatars.githubusercontent.com/u/851749?v=4"
}
],
"contributors_sampled": 4,
"top_contributor_share": 0.964
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"MainDistributionPipeline.yml",
"_extension_deploy.yml",
"_extension_distribution.yml",
"_extension_tests.yml"
],
"has_docs_dir": false,
"linter_configs": [],
"has_editorconfig": true,
"has_linter_config": true,
"has_precommit_config": true
},
"security_signals": {
"lockfiles": [],
"scorecard": {
"checks": [
{
"name": "Binary-Artifacts",
"score": 10,
"reason": "no binaries found in the repo",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
},
{
"name": "Branch-Protection",
"score": null,
"reason": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 10,
"reason": "3 out of 3 merged PRs checked by a CI test -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
},
{
"name": "CII-Best-Practices",
"score": 0,
"reason": "no effort to earn an OpenSSF best practices badge detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
},
{
"name": "Code-Review",
"score": 0,
"reason": "Found 0/5 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 3 contributing companies or organizations -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": 10,
"reason": "no dangerous workflow patterns detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 0,
"reason": "no update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 10,
"reason": "30 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
},
{
"name": "Packaging",
"score": null,
"reason": "packaging workflow not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
},
{
"name": "Pinned-Dependencies",
"score": 0,
"reason": "dependency not pinned by hash detected -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
},
{
"name": "SAST",
"score": 0,
"reason": "SAST tool is not run on all commits -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
},
{
"name": "Security-Policy",
"score": 0,
"reason": "security policy file not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
},
{
"name": "Signed-Releases",
"score": null,
"reason": "no releases found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
},
{
"name": "Token-Permissions",
"score": 0,
"reason": "detected GitHub workflow tokens with excessive permissions",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
},
{
"name": "Vulnerabilities",
"score": 10,
"reason": "0 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "0c55a9b81646002edc0c73f36b703c8c39cea2ab",
"ran_at": "2026-07-30T03:45:03Z",
"aggregate_score": 4.7,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": false,
"has_dependabot_config": false
},
"contribution_flow": {
"collected": true,
"ci_last_run_at": "2026-07-20T21:43:06Z",
"oldest_open_prs": [
{
"number": 139,
"created_at": "2026-01-26T20:20:26Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 198,
"created_at": "2026-06-05T19:13:31Z",
"last_comment_at": null,
"last_comment_author": null
}
],
"last_merged_pr_at": "2026-07-19T10:30:15Z",
"ci_last_conclusion": "SUCCESS",
"oldest_open_issues": [
{
"number": 101,
"created_at": "2025-07-10T15:10:33Z",
"last_comment_at": "2025-10-07T20:09:08Z",
"last_comment_author": "hafenkran"
},
{
"number": 116,
"created_at": "2025-09-26T16:05:58Z",
"last_comment_at": "2025-10-13T09:23:29Z",
"last_comment_author": "guillesd"
},
{
"number": 117,
"created_at": "2025-10-03T17:53:06Z",
"last_comment_at": "2026-01-20T12:00:25Z",
"last_comment_author": "kstanaszek"
}
]
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/hafenkran/duckdb-bigquery",
"host": "github.com",
"name": "duckdb-bigquery",
"owner": "hafenkran"
},
"metrics": {
"overall": {
"key": "overall",
"band": "good",
"name": "Overall health",
"note": "The weighted overall 64 is calibrated to 73 on the published index scale (record calibration 2026-08-02).",
"notes": [
{
"code": "overall_calibration",
"params": {
"raw": 64,
"calibrated": 73,
"calibration": "2026-08-02"
}
}
],
"value": 73,
"inputs": {
"security": 47,
"vitality": 94,
"community": 48,
"governance": 50,
"calibration": "2026-08-02",
"engineering": 80,
"ai_readiness": 52,
"weighted_overall_raw": 64
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "exceptional",
"name": "Vitality",
"value": 94,
"weight": 0.21,
"metrics": [
{
"key": "development_activity",
"band": "excellent",
"name": "Development activity",
"note": null,
"notes": [],
"value": 90,
"inputs": {
"commits_last_year": 358,
"human_commit_share": 1,
"days_since_last_push": 4,
"active_weeks_last_year": 38
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 4 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "push_recency",
"params": {
"days": 4
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "38/52 weeks with commits",
"points": 26.3,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 38
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "358 commits in the last year",
"points": 18,
"status": "met",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 358
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "30 commit(s) and 4 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": 29,
"latest_release_tag": "v0.12.0",
"releases_from_tags": false,
"days_since_latest_release": 7,
"mean_days_between_releases": 14.6
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "29 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 29
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 7 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "release_recency",
"params": {
"days": 7
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~14.6 days",
"points": 27,
"status": "met",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 14.6
}
}
],
"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": 16,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 16 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 16
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "weak",
"name": "Community & Adoption",
"value": 48,
"weight": 0.17,
"metrics": [
{
"key": "popularity",
"band": "weak",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 47,
"inputs": {
"forks": 10,
"stars": 167,
"watchers": 4,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "167 stars",
"points": 36,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 167
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "10 forks",
"points": 8,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 10
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "4 watchers",
"points": 2.7,
"status": "partial",
"details": [
{
"code": "watchers",
"params": {
"count": 4
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "moderate",
"name": "Community health",
"note": null,
"notes": [],
"value": 50,
"inputs": {
"has_readme": true,
"has_license": true,
"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": 22.5,
"status": "met",
"details": [],
"max_points": 22.5
},
{
"key": "license",
"name": "License",
"detail": "recognized license (MIT)",
"points": 22.5,
"status": "met",
"details": [
{
"code": "license_standard",
"params": {}
},
{
"code": "license_spdx",
"params": {
"spdx": "MIT"
}
}
],
"max_points": 22.5
},
{
"key": "contributing_guide",
"name": "CONTRIBUTING guide",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 18
},
{
"key": "code_of_conduct",
"name": "Code of conduct",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 13.5
},
{
"key": "issue_template",
"name": "Issue template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.2
},
{
"key": "pr_template",
"name": "PR template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.3
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "moderate",
"name": "Sustainability & Governance",
"value": 50,
"weight": 0.23,
"metrics": [
{
"key": "maintainer_resilience",
"band": "at_risk",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 25,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 4,
"top_contributor_share": 0.964
},
"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 96% of commits",
"points": 0.8,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 96
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "4 contributors",
"points": 5.4,
"status": "partial",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 4
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 3 contributing companies or organizations -- score normalized to 10",
"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": 78,
"inputs": {
"merged_prs": 155,
"open_issues": 3,
"closed_issues": 45,
"prs_merged_7d": null,
"prs_decided_7d": null,
"prs_merged_30d": null,
"prs_decided_30d": null,
"issue_closed_ratio": 0.938,
"closed_unmerged_prs": 7,
"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": "94% of issues closed",
"points": 39.4,
"status": "partial",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 94
}
}
],
"max_points": 42
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "155/162 decided PRs merged",
"points": 28.7,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 155,
"decided": 162
}
}
],
"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/5 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": 51,
"inputs": {
"followers": 25,
"owner_type": "User",
"is_verified": null,
"owner_login": "hafenkran",
"public_repos": 13,
"account_age_days": 4847
},
"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": "25 followers of hafenkran",
"points": 10.2,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 25,
"login": "hafenkran"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "13 public repos, account ~13 yr old",
"points": 20.3,
"status": "partial",
"details": [
{
"code": "public_repos",
"params": {
"count": 13
}
},
{
"code": "account_age_years",
"params": {
"years": 13
}
}
],
"max_points": 25
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "excellent",
"name": "Engineering Quality",
"value": 80,
"weight": 0.19,
"metrics": [
{
"key": "engineering_practices",
"band": "exceptional",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": true,
"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": 6.4,
"status": "met",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "3 out of 3 merged PRs checked by a CI test -- score normalized to 10",
"points": 20,
"status": "met",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "moderate",
"name": "Documentation",
"note": null,
"notes": [],
"value": 50,
"inputs": {
"topics": [
"bigquery",
"duckdb",
"duckdb-extension"
],
"has_wiki": false,
"homepage": null,
"has_readme": true,
"has_docs_dir": false,
"has_description": true
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 30,
"status": "met",
"details": [],
"max_points": 30
},
{
"key": "documentation_directory",
"name": "Documentation directory",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "repository_description",
"name": "Repository description",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "topics",
"name": "Topics",
"detail": "3 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 3
}
}
],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "weak",
"name": "Security",
"value": 47,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "weak",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Branch-Protection, Packaging, Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"branch_protection",
"packaging",
"signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 47,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 15,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 3,
"scorecard_aggregate": 4.7
},
"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": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "3 out of 3 merged PRs checked by a CI test -- score normalized to 10",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "cii_best_practices",
"name": "CII-Best-Practices",
"detail": "no effort to earn an OpenSSF best practices badge detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "code_review",
"name": "Code-Review",
"detail": "Found 0/5 approved changesets -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 3 contributing companies or organizations -- score normalized to 10",
"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": "no update tool detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "30 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 10",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow not detected",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "pinned_dependencies",
"name": "Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is not run on all commits -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "security_policy",
"name": "Security-Policy",
"detail": "security policy file not detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "signed_releases",
"name": "Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "token_permissions",
"name": "Token-Permissions",
"detail": "detected GitHub workflow tokens with excessive permissions",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "0 existing vulnerabilities detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "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": 7
},
"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": "moderate",
"name": "AI Readiness",
"value": 52,
"weight": 0.04,
"metrics": [
{
"key": "ai_agent_context",
"band": "critical",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 16,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.3,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "no CLAUDE.md / AGENTS.md / editor rules",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_instructions",
"params": {}
}
],
"max_points": 45
},
{
"key": "machine_readable_docs_llms_txt",
"name": "Machine-readable docs (llms.txt)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "legible_commit_history",
"name": "Legible commit history",
"detail": "30 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 16,
"status": "partial",
"details": [
{
"code": "legible_history",
"params": {
"legible": 30,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "moderate",
"name": "Verify loop (build / test / typecheck)",
"note": null,
"notes": [],
"value": 62,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": false,
"typed_language": true,
"bootstrap_files": [
"Makefile"
],
"has_devcontainer": false,
"has_linter_config": true,
"typecheck_configs": [],
"agent_commit_share": 0,
"toolchain_manifests": [],
"dependency_bot_commit_share": 0
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": "Makefile",
"points": 18,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Makefile"
}
}
],
"max_points": 18
},
{
"key": "automated_tests",
"name": "Automated tests",
"detail": null,
"points": 22,
"status": "met",
"details": [],
"max_points": 22
},
{
"key": "lint_format_config",
"name": "Lint / format config",
"detail": null,
"points": 11,
"status": "met",
"details": [],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": "C++ (statically typed)",
"points": 11,
"status": "met",
"details": [
{
"code": "statically_typed_language",
"params": {
"language": "C++"
}
}
],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "no agent-authored commits among the last 100",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_authored_commits",
"params": {
"sampled": 100
}
}
],
"max_points": 10
},
{
"key": "automated_maintenance",
"name": "Automated maintenance",
"detail": "no automated dependency updates observed",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_dependency_automation",
"params": {}
}
],
"max_points": 8
},
{
"key": "openssf_scorecard_pinned_dependencies",
"name": "OpenSSF Scorecard: Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "exceptional",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 98,
"inputs": {
"primary_language": "C++",
"largest_source_bytes": 94199,
"source_files_sampled": 65,
"oversized_source_files": 2
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "C++ (statically typed)",
"points": 45,
"status": "met",
"details": [
{
"code": "statically_typed_language",
"params": {
"language": "C++"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "2/65 source files over 60KB",
"points": 53.3,
"status": "partial",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 65,
"oversized": 2
}
}
],
"max_points": 55
}
]
}
],
"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": {
"top": [],
"labels": [],
"scores": {},
"primary": null,
"evidence": [],
"artifacts": [],
"confidence": "none",
"host_extension": false,
"runs_as_process": false,
"consumed_by_code": false
},
"metrics_version": "2.5.0"
},
"warnings": [
"Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token"
],
"report_type": "repository",
"generated_at": "2026-07-30T03:45:23.027468Z",
"schema_version": "0.27.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/h/hafenkran/duckdb-bigquery.svg",
"full_name": "hafenkran/duckdb-bigquery",
"license_state": "standard",
"license_spdx": "MIT"
}Scores are signals, not warranties. They reflect publicly visible practices on GitHub — not a code audit, and not a security guarantee.
Missing data is excluded and weights renormalized, never scored as zero. Methodology is versioned and open: metrics v2.5.0, schema v0.27.0 — full methodology · metrics wiki.
How one result sits in the wider record: aggregate statistics.