Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-09-19 18:29 UTC

hirosassa / bqvalid

SQL linter tool for BigQuery GoogleSQL (formerly known as StandardSQL).

RustMIT★ 17 stars⑂ 2 forkssince Jun 2022View on GitHub ↗
KindCommand-line toolhow this is determined

hirosassa/bqvalid holds a health index of 62 out of 100, placing it in the Moderate band. It scores highest on Vitality (75/100) and lowest on Community & Adoption (34/100). It was last updated 6 days ago. A single contributor accounts for most of its recent work.

62
overall / 100
Moderate

Software 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.

62
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)
VitalityCommunity &AdoptionSustainability &GovernanceEngineeringQualitySecurityAI Readiness

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 58 is calibrated to 62 on the published index scale (record calibration 2026-08-02).

Ownership

hirosassaPersonal account
41 followers120 public repossince Oct 2010@m3dev

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?

75Good · 21% of overall
How it's scored
36/36Push recencylast push 6 days ago
12.5/36Commit cadence18/52 weeks with commits
16.2/18Commit volume63 commits in the last year
10/10OpenSSF Scorecard: Maintained30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year63
human_commit_share0.82
days_since_last_push6
active_weeks_last_year18
How it's scored
27/27Ships releases15 releases published
36/36Release recencylatest release 33 days ago
12.6/27Release cadencea release every ~167.9 days
0/10OpenSSF Scorecard: Signed-ReleasesProject has not signed or included provenance with any releases.
Inputs used
releases_count15
latest_release_tagv2.0.0
releases_from_tagsno
days_since_latest_release33
mean_days_between_releases167.9

Community & Adoption

Does the project have users, downloads, attention, and a welcoming setup for contributors?

34At Risk · 17% of overall
How it's scored
19.5/60Stars17 stars
0/25Forks2 forks
0/15Watchers1 watchers
Inputs used
forks2
stars17
watchers1
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
How it's scored
22.5/22.5README
22.5/22.5Licenserecognized license (MIT)
0/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges3
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_servicescodecov.io, github.com, shields.io
has_pull_request_templateno

Sustainability & Governance

Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?

50Moderate · 23% of overall
How it's scored
9/54Bus factor1 contributor(s) cover half of all commits
1.8/22.5Commit distributiontop contributor authored 92% of commits
4.1/13.5Contributor breadth3 contributors
3/10OpenSSF Scorecard: Contributorsproject has 1 contributing companies or organizations -- score normalized to 3
Inputs used
bus_factor1
contributors_sampled3
top_contributor_share0.921
How it's scored
42/42Issue resolution100% of issues closed
29.3/30PR acceptance82/84 decided PRs merged
0/13Newcomer PR acceptanceno first-time contributor's PR decided in 30d
0/15OpenSSF Scorecard: Code-ReviewFound 0/22 approved changesets -- score normalized to 0
Inputs used
merged_prs82
open_issues0
closed_issues7
prs_merged_7d0
prs_decided_7d0
prs_merged_30d0
prs_decided_30d0
issue_closed_ratio1
closed_unmerged_prs2
first_time_authors_30d0
first_time_prs_merged_30d0
first_time_prs_decided_30d0
Excluded from scoring (no data or not applicable): Newcomer PR acceptance. Remaining weights renormalized.
How it's scored
10/30Ownership backingpersonal (user) account
0/20Verified domainnot applicable to user accounts
11.7/25Owner reach41 followers of hirosassa
25/25Track record120 public repos, account ~15 yr old
Inputs used
followers41
owner_typeUser
is_verified
owner_loginhirosassa
public_repos120
account_age_days5,832
Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.

Engineering Quality

Are baseline engineering and documentation practices in place?

66Good · 19% of overall
How it's scored
24/24CI workflows2 workflow(s)
0/24Tests present
16/16Linter configCargo.toml ([lints])
0/9.6Pre-commit hooks
0/6.4.editorconfig
14/20OpenSSF Scorecard: CI-Tests22 out of 30 merged PRs checked by a CI test -- score normalized to 7
Inputs used
has_ciyes
has_testsno
has_editorconfigno
has_linter_configyes
has_precommit_configno

Documentation

85Excellent
How it's scored
30/30README
25/25Documentation directory
0/15Documentation / homepage site
10/10Repository description
10/10Topics4 topics
10/10Wiki
Inputs used
topicsbigquery, linter, sql, google
has_wikiyes
homepage
docs_site
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

Are visible security and supply-chain practices strong, without unresolved high-risk jurisdiction exposure?

64Moderate · 16% of overall
How it's scored
7.5/7.5Binary-Artifactsno binaries found in the repo
0/7.5Branch-Protectionno data
1.8/2.5CI-Tests22 out of 30 merged PRs checked by a CI test -- score normalized to 7
0/2.5CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0/7.5Code-ReviewFound 0/22 approved changesets -- score normalized to 0
0.8/2.5Contributorsproject has 1 contributing companies or organizations -- score normalized to 3
10/10Dangerous-Workflowno dangerous workflow patterns detected
7.5/7.5Dependency-Update-Toolupdate tool detected
0/5Fuzzingproject is not fuzzed
2.5/2.5Licenselicense file detected
7.5/7.5Maintained30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
5/5Packagingpackaging workflow detected
4/5Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 8
0/5SASTSAST tool is not run on all commits -- score normalized to 0
0/5Security-Policysecurity policy file not detected
0/7.5Signed-ReleasesProject has not signed or included provenance with any releases.
0/7.5Token-Permissionsdetected GitHub workflow tokens with excessive permissions
6.8/7.5Vulnerabilities1 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate5.5
Excluded from scoring (no data or not applicable): Branch-Protection. Remaining weights renormalized.

Dependency advisories

100Exceptional
How it's scored
35/35Direct dependencies free of known advisoriesno direct dependency carries a known advisory
0/25Indirect dependencies free of known advisoriestransitive set not separable from development and test dependencies in this scope
0/40No advisories left outstandingno advisory carries a publication date
Inputs used
sourceosv
advisories1
affected_packages1
assessed_packages174
unassessed_packages0
affected_by_severityunknown 1
direct_affected_packages0
Excluded from scoring (no data or not applicable): Indirect dependencies free of known advisories, No advisories left outstanding. Remaining weights renormalized. Matched 174 resolved dependencies against OSV. This repository publishes no package the index resolves, so the repository dependency graph was assessed instead. That graph mixes development and test pins with shipped dependencies, so only the declared runtime dependencies are scored; transitive findings are reported as context and excluded from the score. Reachability is not analyzed.

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.

64Moderate · 4% of overall
How it's scored
0/45Agent instructionsno CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
38.4/40Legible commit history59 of 82 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
llms_txt_url
legible_history_share0.72
agent_instruction_files
agent_instruction_max_bytes
How it's scored
12.6/18One-command bootstrapCargo.toml (toolchain convention, no task runner)
0/22Automated tests
11/11Lint / format configCargo.toml ([lints])
11/11Static type checkingRust (statically typed)
10/10Reproducible environmentlockfile
10/10Demonstrated agent practice9 of the last 100 commits agent-authored or agent-credited
8/8Automated maintenance18 of the last 100 commits are automated dependency updates
8/10OpenSSF Scorecard: Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 8
Inputs used
has_nixno
has_testsno
lockfilesCargo.lock
has_dockerfileno
typed_languageyes
bootstrap_files
has_devcontainerno
has_linter_configyes
typecheck_configs
agent_commit_share0.09
toolchain_manifestsCargo.toml
dependency_bot_commit_share0.18
How it's scored
45/45Type-checkable codeRust (statically typed)
55/55Manageable file sizes0/30 source files over 60KB
Inputs used
primary_languageRust
largest_source_bytes21,941
source_files_sampled30
oversized_source_files0

Key facts

17GitHub stars
3contributors
63commits, last 12 months
6days since last push
15releases
1bus factor
0open issues
crates.iopackage ecosystems

Data collection warnings

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
  • Could not fetch crates package 'bqvalid' from its registry

More detail

Star and fork history 0 ★ / 2 ⇿
0Stars
2Forks
5Releases

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.

111222212022-062023-052024-05
Major 0Minor 0Patch 5

Each point covers 2 days.

OpenSSF Scorecard 5.5 / 10
5.5aggregate

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).Scorecard v5.5.0 · 2026-09-19 18:29 UTC

10Binary-Artifactsno binaries found in the repo
n/aBranch-Protectioninternal 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
7CI-Tests22 out of 30 merged PRs checked by a CI test -- score normalized to 7
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/22 approved changesets -- score normalized to 0
3Contributorsproject has 1 contributing companies or organizations -- score normalized to 3
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
8Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 8
0SASTSAST tool is not run on all commits -- score normalized to 0
0Security-Policysecurity policy file not detected
0Signed-ReleasesProject has not signed or included provenance with any releases.
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
9Vulnerabilities1 existing vulnerabilities detected
Direct dependencies 10
RegistryPackageVersion constraintManifest
crates.ioclap4.6.1Cargo.toml
crates.iowalkdir2.5.0Cargo.toml
crates.iolog0.4.32Cargo.toml
crates.ioenv_logger0.11.10Cargo.toml
crates.ioclap-verbosity-flag3.0.4Cargo.toml
crates.iorayon1.12.0Cargo.toml
crates.iogooglesql0.4.0Cargo.toml
crates.ioserde1.0Cargo.toml
crates.ioserde_json1.0Cargo.toml
crates.iotoml1.0Cargo.toml
All dependencies 174

Full resolved dependency set from the GitHub dependency graph: 10 direct and 164 indirect (transitive) packages. The transitive closure is complete when the repository commits a lockfile.

RegistryPackageVersionRelation
crates.ioclap4.6.6direct
crates.ioclap-verbosity-flag3.0.4direct
crates.ioenv_logger0.11.11direct
crates.iogooglesql0.4.0direct
crates.iolog0.4.34direct
crates.iorayon1.12.0direct
crates.ioserde1.0.229direct
crates.ioserde_json1.0.151direct
crates.iotoml1.1.4+spec-1.1.0direct
crates.iowalkdir2.5.0direct
crates.ioaddr2line0.25.1indirect
crates.ioadler22.0.1indirect
crates.ioaho-corasick1.1.4indirect
crates.ioalloca0.4.0indirect
crates.ioanes0.1.6indirect
crates.ioanstream1.0.0indirect
crates.ioanstyle1.0.14indirect
crates.ioanstyle-parse1.0.0indirect
crates.ioanstyle-query1.1.5indirect
crates.ioanstyle-wincon3.0.11indirect
crates.ioanyhow1.0.104indirect
crates.ioautocfg1.5.0indirect
crates.iobacktrace0.3.76indirect
crates.iobitflags2.11.0indirect
crates.ioblock-buffer0.12.1indirect
crates.iobumpalo3.20.2indirect
crates.iocast0.3.0indirect
crates.iocc1.2.56indirect
crates.iocfg-if1.0.4indirect
crates.iociborium0.2.2indirect
crates.iociborium-io0.2.2indirect
crates.iociborium-ll0.2.2indirect
crates.ioclap_builder4.6.6indirect
crates.ioclap_derive4.6.4indirect
crates.ioclap_lex1.0.0indirect
crates.iocolorchoice1.0.4indirect
crates.ioconst-oid0.10.2indirect
crates.iocpufeatures0.3.0indirect
crates.iocriterion0.8.2indirect
crates.iocriterion-plot0.8.2indirect
crates.iocrossbeam-deque0.8.6indirect
crates.iocrossbeam-epoch0.9.18indirect
crates.iocrossbeam-utils0.8.21indirect
crates.iocrunchy0.2.4indirect
crates.iocrypto-common0.2.2indirect
crates.iodhat0.3.3indirect
crates.iodigest0.11.3indirect
crates.ioeither1.15.0indirect
crates.ioenv_filter2.0.0indirect
crates.ioequivalent1.0.2indirect
crates.ioerrno0.3.14indirect
crates.iofastrand2.3.0indirect
crates.iofind-msvc-tools0.1.9indirect
crates.iofoldhash0.1.5indirect
crates.iofutures-core0.3.32indirect
crates.iofutures-macro0.3.32indirect
crates.iofutures-task0.3.32indirect
crates.iofutures-timer3.0.3indirect
crates.iofutures-util0.3.32indirect
crates.iogetrandom0.4.1indirect
crates.iogimli0.32.3indirect
crates.ioglob0.3.3indirect
crates.iohalf2.7.1indirect
crates.iohashbrown0.15.5indirect
crates.iohashbrown0.17.1indirect
crates.ioheck0.5.0indirect
crates.iohybrid-array0.4.14indirect
crates.ioid-arena2.3.0indirect
crates.ioindexmap2.14.0indirect
crates.iois_terminal_polyfill1.70.2indirect
crates.ioitertools0.13.0indirect
crates.ioitoa1.0.17indirect
crates.iojiff0.2.22indirect
crates.iojiff-static0.2.22indirect
crates.iojobserver0.1.35indirect
crates.iojs-sys0.3.91indirect
crates.iolazy_static1.5.0indirect
crates.ioleb128fmt0.1.0indirect
crates.iolibc0.2.189indirect
crates.iolinux-raw-sys0.12.1indirect
crates.iolock_api0.4.14indirect
crates.iomemchr2.8.0indirect
crates.iominiz_oxide0.8.9indirect
crates.iomintex0.1.4indirect
crates.ionum-traits0.2.19indirect
crates.ioobject0.37.3indirect
crates.ioonce_cell1.21.3indirect
crates.ioonce_cell_polyfill1.70.2indirect
crates.iooorandom11.1.5indirect
crates.iopage_size0.6.0indirect
crates.ioparking_lot0.12.5indirect
crates.ioparking_lot_core0.9.12indirect
crates.iopin-project-lite0.2.17indirect
crates.iopkg-config0.3.33indirect
crates.ioplotters0.3.7indirect
crates.ioplotters-backend0.3.7indirect
crates.ioplotters-svg0.3.7indirect
crates.ioportable-atomic1.13.1indirect
crates.ioportable-atomic-util0.2.5indirect
crates.ioprettyplease0.2.37indirect
crates.ioproc-macro-crate3.4.0indirect
crates.ioproc-macro21.0.106indirect
crates.ioquote1.0.45indirect
crates.ior-efi5.3.0indirect
crates.iorayon-core1.13.0indirect
crates.ioredox_syscall0.5.18indirect
crates.ioregex1.12.3indirect
crates.ioregex-automata0.4.14indirect
crates.ioregex-syntax0.8.10indirect
crates.iorelative-path1.9.3indirect
crates.iorstest0.26.1indirect
crates.iorstest_macros0.26.1indirect
crates.iorustc-demangle0.1.27indirect
crates.iorustc-hash1.1.0indirect
crates.iorustc_version0.4.1indirect
crates.iorustix1.1.4indirect
crates.iorustversion1.0.22indirect
crates.iosame-file1.0.6indirect
crates.ioscopeguard1.2.0indirect
crates.iosemver1.0.27indirect
crates.ioserde_core1.0.229indirect
crates.ioserde_derive1.0.229indirect
crates.ioserde_spanned1.1.1indirect
crates.iosha20.11.0indirect
crates.ioshlex1.3.0indirect
crates.ioslab0.4.12indirect
crates.iosmallvec1.15.1indirect
crates.iostrsim0.11.1indirect
crates.iosyn2.0.117indirect
crates.iosyn3.0.3indirect
crates.iotempfile3.27.0indirect
crates.iothiserror2.0.19indirect
crates.iothiserror-impl2.0.19indirect
crates.iothousands0.2.0indirect
crates.iotinytemplate1.2.1indirect
crates.iotoml_datetime0.7.5+spec-1.1.0indirect
crates.iotoml_datetime1.1.1+spec-1.1.0indirect
crates.iotoml_edit0.23.10+spec-1.0.0indirect
crates.iotoml_parser1.1.3+spec-1.1.0indirect
crates.iotoml_writer1.1.2+spec-1.1.0indirect
crates.iotypenum1.20.1indirect
crates.iounicode-ident1.0.24indirect
crates.iounicode-xid0.2.6indirect
crates.ioutf8parse0.2.2indirect
crates.iowasip21.0.2+wasi-0.2.9indirect
crates.iowasip30.4.0+wasi-0.3.0-rc-2026-01-06indirect
crates.iowasm-bindgen0.2.114indirect
crates.iowasm-bindgen-macro0.2.114indirect
crates.iowasm-bindgen-macro-support0.2.114indirect
crates.iowasm-bindgen-shared0.2.114indirect
crates.iowasm-encoder0.244.0indirect
crates.iowasm-metadata0.244.0indirect
crates.iowasmparser0.244.0indirect
crates.ioweb-sys0.3.91indirect
crates.iowinapi0.3.9indirect
crates.iowinapi-i686-pc-windows-gnu0.4.0indirect
crates.iowinapi-util0.1.11indirect
crates.iowinapi-x86_64-pc-windows-gnu0.4.0indirect
crates.iowindows-link0.2.1indirect
crates.iowindows-sys0.61.2indirect
crates.iowinnow0.7.14indirect
crates.iowinnow1.0.4indirect
crates.iowit-bindgen0.51.0indirect
crates.iowit-bindgen-core0.51.0indirect
crates.iowit-bindgen-rust0.51.0indirect
crates.iowit-bindgen-rust-macro0.51.0indirect
crates.iowit-component0.244.0indirect
crates.iowit-parser0.244.0indirect
crates.iozerocopy0.8.40indirect
crates.iozerocopy-derive0.8.40indirect
crates.iozmij1.0.21indirect
crates.iozstd0.13.3indirect
crates.iozstd-safe7.2.4indirect
crates.iozstd-sys2.0.16+zstd.1.5.7indirect
Dependency advisories 1

This repository publishes no package the index resolves, so its own dependency graph was assessed — 174 packages, which also include development and test pins that never ship: 1 carry known advisories, of which 0 are direct.

PackageVersionRelationSeverityAdvisoriesFixed in
crossbeam-epoch0.9.18indirectunknown10.9.20

An advisory means the version recorded in the dependency graph falls inside an advisory’s affected range. Reachability is not analysed, and the graph includes development and test pins — a finding may concern tooling rather than shipped software.

Raw JSON report machine-readable

Feedback

Spotted something off in this report, or have thoughts to share? Wrong measurements, missed tooling, ideas, questions — anything is welcome. Every message is read and gets a response.

The message is kept through sign-in.

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.10.0, schema v0.34.0 — full methodology · metrics wiki.

How one result sits in the wider record: aggregate statistics.