Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-10-19 10:42 UTC

metio / yosql

zero dependency database access for java

Java0BSD★ 10 stars⑂ 1 forksince Feb 2017View on GitHub ↗
KindCommand-line toolLibraryhow this is determined

metio/yosql holds a health index of 81 out of 100, placing it in the Excellent band. It scores highest on AI Readiness (94/100) and lowest on Community & Adoption (48/100). It was last updated 2 days ago. A single contributor accounts for most of its recent work.

81
overall / 100
Excellent

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.

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

Ownership

metio.wtfOrganization
4 followers43 public repossince Oct 2015

This repository is backed by an organization — shared, accountable stewardship that can outlive any single maintainer.

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publish
Mavenwtf.metio.yosql.codegen:yosql-codegen2026.10.8-2310 days ago

Metrics by category

Vitality

Is the project alive — is code being written and are releases shipping?

79Good · 21% of overall
How it's scored
36/36Push recency — last push 2 days ago
13.8/36Commit cadence — 20/52 weeks with commits
18/18Commit volume — 199 commits in the last year
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year199
human_commit_share0.76
days_since_last_push2
active_weeks_last_year20
How it's scored
27/27Ships releases — 25 releases published
36/36Release recency — latest release 10 days ago
12.6/27Release cadence — a release every ~172 days
4/10OpenSSF Scorecard: Signed-Releases — 3 out of the last 5 releases have a total of 3 signed artifacts.
Inputs used
releases_count25
latest_release_tag2026.10.8
releases_from_tagsno
days_since_latest_release10
mean_days_between_releases172

Community & Adoption

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

48Weak · 17% of overall
How it's scored
15.5/60Stars — 10 stars
0/25Forks — 1 forks
0/15Watchers — 1 watchers
Inputs used
forks1
stars10
watchers1
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

85Excellent
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (0BSD)
18/18CONTRIBUTING guide
13.5/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges0
has_contributingyes
has_issue_templateno
has_code_of_conductyes
readme_badge_services—
has_pull_request_templateno

Sustainability & Governance

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

60Moderate · 23% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
2.9/22.5Commit distribution — top contributor authored 87% of commits
2.7/13.5Contributor breadth — 2 contributors
3/10OpenSSF Scorecard: Contributors — project has 1 contributing companies or organizations -- score normalized to 3
Inputs used
bus_factor1
contributors_sampled2
top_contributor_share0.872
How it's scored
41.7/42Issue resolution — 99% of issues closed
26/30PR acceptance — 187/216 decided PRs merged
0/13Newcomer PR acceptance — no first-time contributor's PR decided in 30d
0/15OpenSSF Scorecard: Code-Review — Found 0/15 approved changesets -- score normalized to 0
Inputs used
merged_prs187
open_issues1
closed_issues144
prs_merged_7d0
prs_decided_7d0
prs_merged_30d0
prs_decided_30d0
issue_closed_ratio0.993
closed_unmerged_prs29
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
30/30Ownership backing — organization-owned
0/20Verified domain
5/25Owner reach — 4 followers of metio
24/25Track record — 43 public repos, account ~10 yr old
Inputs used
followers4
owner_typeOrganization
is_verifiedno
owner_loginmetio
public_repos43
account_age_days4,007

Package maintenance

100Exceptional
How it's scored
25/25Published & resolvable — 1 package(s) on maven
35/35Publish recency — latest publish 10 days ago
20/20Version history — 23 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packageswtf.metio.yosql.codegen:yosql-codegen
ecosystemsmaven
any_deprecatedno
min_days_since_publish10

Engineering Quality

Are baseline engineering and documentation practices in place?

80Excellent · 19% of overall
How it's scored
24/24CI workflows — 4 workflow(s)
24/24Tests present
0/16Linter config
0/9.6Pre-commit hooks
6.4/6.4.editorconfig
20/20OpenSSF Scorecard: CI-Tests — 15 out of 15 merged PRs checked by a CI test -- score normalized to 10
Inputs used
has_ciyes
has_testsyes
has_editorconfigyes
has_linter_configno
has_precommit_configno

Documentation

90Excellent
How it's scored
30/30README
25/25Documentation directory
15/15Documentation / homepage site — https://yosql.projects.metio.wtf/
10/10Repository description
10/10Topics — 14 topics
0/10Wiki
Inputs used
topicsjava, sql, javapoet, code-generator, persistence, dagger2, jmh, zero-dependency, jdbc, build-tool, gradle-plugin, maven-plugin, ant-task, cli
has_wikino
homepagehttps://yosql.projects.metio.wtf/
docs_sitehttps://yosql.projects.metio.wtf/
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

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

69Good · 16% of overall
How it's scored
6/7.5Binary-Artifacts — binaries present in source code
2.2/7.5Branch-Protection — branch protection is not maximal on development and all release branches
2.5/2.5CI-Tests — 15 out of 15 merged PRs checked by a CI test -- score normalized to 10
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 0/15 approved changesets -- score normalized to 0
0.8/2.5Contributors — project has 1 contributing companies or organizations -- score normalized to 3
10/10Dangerous-Workflow — no dangerous workflow patterns detected
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
7.5/7.5Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
0/5Packaging — no data
5/5Pinned-Dependencies — all dependencies are pinned
0/5SAST — SAST tool is not run on all commits -- score normalized to 0
5/5Security-Policy — security policy file detected
3/7.5Signed-Releases — 3 out of the last 5 releases have a total of 3 signed artifacts.
7.5/7.5Token-Permissions — GitHub workflow tokens follow principle of least privilege
7.5/7.5Vulnerabilities — 0 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate6.7
Excluded from scoring (no data or not applicable): Packaging. Remaining weights renormalized.
How it's scored
11.8/35Direct dependencies free of known advisories — 2 affected: com.fasterxml.jackson.core:jackson-core 2.22.2 (high 7.5), com.fasterxml.jackson.core:jackson-databind 2.22.2 (high 7.5)
25/25Indirect dependencies free of known advisories — no indirect dependency carries a known advisory
40/40No advisories left outstanding — no advisory has been public longer than 90 days
Inputs used
sourceosv
advisories4
affected_packages2
assessed_packages20
unassessed_packages0
affected_by_severityhigh 2
direct_affected_packages2
Matched the maven:wtf.metio.yosql.codegen:yosql-codegen@2026.10.8 runtime dependency closure — what installing the published package pulls in — 20 packages. 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.

94Exceptional · 4% of overall
How it's scored
45/45Agent instructions — CLAUDE.md, docs/content/editors/claude.md
15/15Machine-readable docs (llms.txt) — llms.txt served by the project website (https://yosql.projects.metio.wtf/llms.txt)
40/40Legible commit history — 76 of 76 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtyes
llms_txt_urlhttps://yosql.projects.metio.wtf/llms.txt
legible_history_share1
agent_instruction_filesCLAUDE.md, docs/content/editors/claude.md
agent_instruction_max_bytes7,765
How it's scored
12.6/18One-command bootstrap — docs/pom.xml, pom.xml, yosql-benchmarks/pom.xml (toolchain convention, no task runner)
22/22Automated tests
0/11Lint / format config
11/11Static type checking — Java (statically typed)
10/10Reproducible environment — Nix
10/10Demonstrated agent practice — 76 of the last 100 commits agent-authored or agent-credited
8/8Automated maintenance — 24 of the last 100 commits are automated dependency updates
10/10OpenSSF Scorecard: Pinned-Dependencies — all dependencies are pinned
Inputs used
has_nixyes
has_testsyes
lockfiles—
has_dockerfileno
typed_languageyes
bootstrap_files—
has_devcontainerno
has_linter_configno
typecheck_configs—
agent_commit_share0.76
toolchain_manifestsdocs/pom.xml, pom.xml, yosql-benchmarks/pom.xml, yosql-benchmarks/yosql-benchmarks-codegen/pom.xml, yosql-benchmarks/yosql-benchmarks-dao/pom.xml, yosql-benchmarks/yosql-benchmarks-vs-jdbi/pom.xml, yosql-codegen/pom.xml, yosql-examples/pom.xml, yosql-examples/yosql-examples-ant/pom.xml, yosql-examples/yosql-examples-cli/pom.xml, yosql-examples/yosql-examples-common/pom.xml, yosql-examples/yosql-examples-gradle/build.gradle.kts, yosql-examples/yosql-examples-gradle/yosql-examples-gradle-config/build.gradle.kts, yosql-examples/yosql-examples-gradle/yosql-examples-gradle-jdbc/build.gradle.kts, yosql-examples/yosql-examples-maven/pom.xml, yosql-examples/yosql-examples-maven/yosql-examples-maven-jdbc/pom.xml, yosql-examples/yosql-examples-native/pom.xml, yosql-examples/yosql-examples-records/pom.xml, yosql-internals/pom.xml, yosql-internals/yosql-internals-javapoet-utils/pom.xml, yosql-internals/yosql-internals-jdk-utils/pom.xml, yosql-internals/yosql-internals-junit5-utils/pom.xml, yosql-internals/yosql-internals-testing-configs/pom.xml, yosql-models/pom.xml, yosql-models/yosql-models-configuration/pom.xml, yosql-models/yosql-models-generator/pom.xml, yosql-models/yosql-models-immutables/pom.xml, yosql-models/yosql-models-meta/pom.xml, yosql-tooling/pom.xml, yosql-tooling/yosql-tooling-ant/pom.xml, yosql-tooling/yosql-tooling-cli/pom.xml, yosql-tooling/yosql-tooling-dagger/pom.xml, yosql-tooling/yosql-tooling-gradle/build.gradle.kts, yosql-tooling/yosql-tooling-gradle/buildSrc/build.gradle.kts, yosql-tooling/yosql-tooling-maven/pom.xml
dependency_bot_commit_share0.24
How it's scored
45/45Type-checkable code — Java (statically typed)
55/55Manageable file sizes — 0/558 source files over 60KB
Inputs used
primary_languageJava
largest_source_bytes45,955
source_files_sampled558
oversized_source_files0
How it's scored
0/40API schema (OpenAPI/GraphQL/proto) — not applicable to this kind of software
0/20MCP server — not applicable to this kind of software
40/40Runnable examples — example
Inputs used
example_dirsexample
has_mcp_signalno
api_schema_files—
interfaces_expected_of—
Excluded from scoring (no data or not applicable): API schema (OpenAPI/GraphQL/proto), MCP server. Remaining weights renormalized.

Key facts

10GitHub stars
2contributors
199commits, last 12 months
2days since last push
25releases
1bus factor
1open issues
Mavenpackage ecosystems

Data collection warnings

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
  • GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

More detail

OpenSSF Scorecard 6.7 / 10
6.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).Scorecard v5.5.0 · 2026-10-19 10:42 UTC

8Binary-Artifactsbinaries present in source code
3Branch-Protectionbranch protection is not maximal on development and all release branches
10CI-Tests15 out of 15 merged PRs checked by a CI test -- score normalized to 10
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/15 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 0 issue activity found in the last 90 days -- score normalized to 10
n/aPackagingpackaging workflow not detected
10Pinned-Dependenciesall dependencies are pinned
0SASTSAST tool is not run on all commits -- score normalized to 0
10Security-Policysecurity policy file detected
4Signed-Releases3 out of the last 5 releases have a total of 3 signed artifacts.
10Token-PermissionsGitHub workflow tokens follow principle of least privilege
10Vulnerabilities0 existing vulnerabilities detected
Direct dependencies 54
RegistryPackageVersion constraintManifest
Mavencom.fasterxml.jackson:jackson-bom${version.jackson}pom.xml
Mavennet.jqwik:jqwik${version.jqwik}pom.xml
Mavenorg.junit:junit-bom${version.junit}pom.xml
Mavench.qos.cal10n:cal10n-api${version.cal10n}pom.xml
Mavench.qos.logback:logback-classic${version.logback}pom.xml
Mavencom.github.spullara.mustache.java:compiler${version.mustache}pom.xml
Mavencom.google.dagger:dagger${version.dagger}pom.xml
Mavencom.google.dagger:dagger-compiler${version.dagger}pom.xml
Mavencom.google.dagger:dagger-producers${version.dagger}pom.xml
Mavencom.google.dagger:dagger-spi${version.dagger}pom.xml
Mavencom.h2database:h2${version.h2}pom.xml
Mavencom.palantir.javapoet:javapoet${version.javapoet}pom.xml
Mavencom.zaxxer:HikariCP${version.hikaricp}pom.xml
Maveninfo.picocli:picocli${version.picocli}pom.xml
Maveninfo.picocli:picocli-codegen${version.picocli}pom.xml
Mavenjavax.inject:javax.inject${version.javax-inject}pom.xml
Mavenorg.apache.ant:ant${version.ant}pom.xml
Mavenorg.apache.logging.log4j:log4j-api${version.log4j}pom.xml
Mavenorg.apache.logging.log4j:log4j-core${version.log4j}pom.xml
Mavenorg.apache.maven:maven-core${version.maven}pom.xml
Mavenorg.apache.maven:maven-plugin-api${version.maven}pom.xml
Mavenorg.apache.maven.plugin-tools:maven-plugin-annotations${version.maven-plugin-tools}pom.xml
Mavenorg.codehaus.plexus:plexus-sec-dispatcher${version.plexus-sec-dispatcher}pom.xml
Mavenorg.eclipse.sisu:org.eclipse.sisu.inject${version.sisu}pom.xml
Mavenorg.eclipse.sisu:org.eclipse.sisu.plexus${version.sisu}pom.xml
Mavencom.github.javaparser:javaparser-core${version.javaparser}pom.xml
Mavenorg.immutables:value${version.immutables}pom.xml
Mavenorg.immutables:value-annotations${version.immutables}pom.xml
Mavenorg.jetbrains.kotlin:kotlin-stdlib${version.kotlin}pom.xml
Mavenorg.jspecify:jspecify${version.jspecify}pom.xml
Mavenorg.openjdk.jmh:jmh-core${version.jmh}pom.xml
Mavenorg.openjdk.jmh:jmh-generator-annprocess${version.jmh}pom.xml
Mavenorg.postgresql:postgresql${version.postgresql}pom.xml
Mavenorg.slf4j:slf4j-api${version.slf4j}pom.xml
Mavenorg.slf4j:slf4j-ext${version.slf4j}pom.xml
Mavenorg.slf4j:slf4j-simple${version.slf4j}pom.xml
Mavenorg.codehaus.plexus:plexus-build-api${version.plexus-build-api}pom.xml
Mavenorg.tinylog:tinylog-impl${version.tinylog}pom.xml
Mavenorg.jdbi:jdbi3-core${version.jdbi}pom.xml
Mavencom.github.jsqlparser:jsqlparser${version.jsqlparser}pom.xml
Mavencom.github.javaparser:javaparser-core—yosql-codegen/pom.xml
Mavenwtf.metio.yosql.internals:yosql-internals-jdk-utils${project.version}yosql-codegen/pom.xml
Mavenwtf.metio.yosql.internals:yosql-internals-javapoet-utils${project.version}yosql-codegen/pom.xml
Mavenwtf.metio.yosql.models:yosql-models-configuration${project.version}yosql-codegen/pom.xml
Mavenwtf.metio.yosql.models:yosql-models-immutables${project.version}yosql-codegen/pom.xml
Mavencom.github.jsqlparser:jsqlparser—yosql-codegen/pom.xml
Mavencom.palantir.javapoet:javapoet—yosql-codegen/pom.xml
Mavench.qos.cal10n:cal10n-api—yosql-codegen/pom.xml
Mavenorg.slf4j:slf4j-api—yosql-codegen/pom.xml
Mavenorg.slf4j:slf4j-ext—yosql-codegen/pom.xml
Mavencom.fasterxml.jackson.core:jackson-databind—yosql-codegen/pom.xml
Mavencom.fasterxml.jackson.core:jackson-core—yosql-codegen/pom.xml
Mavencom.fasterxml.jackson.datatype:jackson-datatype-jdk8—yosql-codegen/pom.xml
Mavenorg.jspecify:jspecify—yosql-codegen/pom.xml
All dependencies not collected

The resolved dependency set could not be collected for this report: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

Dependency advisories 2

Installing maven:wtf.metio.yosql.codegen:yosql-codegen@2026.10.8 pulls in 20 packages, direct and transitive: 2 carry known advisories, of which 2 are direct dependencies.

PackageVersionRelationSeverityAdvisoriesFixed in
com.fasterxml.jackson.core:jackson-core2.22.2directhigh23.2.3
com.fasterxml.jackson.core:jackson-databind2.22.2directhigh23.2.3

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 — Maven.