Public record
Software health reportschema 0.15.0 · metrics 1.13.0 · 2026-07-19 17:53 UTC

djezzzl / database_consistency

The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.

RubyMIT★ 1,193 stars⑂ 63 forkssince Oct 2018View on GitHub ↗

djezzzl/database_consistency holds a health index of 32 out of 100, placing it in the At risk band. It scores highest on Vitality (78/100) and lowest on Security (24/100). It was last updated today. A single contributor accounts for most of its recent work.

32
overall / 100
At risk

Software health index

Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At risk ceiling of 49. AI Readiness sits outside the overall score.

32
Excellent85-100Exemplary; meets essentially all checked criteria
Good70-84Healthy; minor gaps
Moderate50-69Acceptable with notable gaps; review recommended
At risk30-49Significant weaknesses; adoption warrants caution
Critical1-29Severe 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.

High-Risk Jurisdiction Policy applies a 50% multiplier to weighted overall health and gives it an At risk ceiling of 49.

Ownership

Evgeniy DeminPersonal account
70 followers9 public repossince Oct 2014

This repository is owned by a personal account. A single-owner project carries more continuity risk than an organization-backed one.

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publish
RubyGemsdatabase_consistency3.0.6-1270 days ago

Metrics by category

Vitality

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

78Good · 22% of overall
How it's scored
36/36Push recency — last push 0 days ago
10.4/36Commit cadence — 15/52 weeks with commits
15.4/18Commit volume — 51 commits in the last year
10/10OpenSSF Scorecard: Maintained — 11 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year51
human_commit_share
days_since_last_push0
active_weeks_last_year15
How it's scored
16.2/27Ships releases — 100 version tags (no GitHub releases)
36/36Release recency — latest release 0 days ago
27/27Release cadence — a release every ~24.6 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count100
latest_release_tagv3.0.6
releases_from_tagsyes
days_since_latest_release0
mean_days_between_releases24.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?

72Good · 18% of overall
How it's scored
49.9/60Stars — 1,193 stars
14.9/25Forks — 63 forks
3.9/15Watchers — 6 watchers
Inputs used
forks63
stars1,193
watchers6
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (MIT)
0/18CONTRIBUTING guide
13.5/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
has_contributingno
has_issue_templateno
has_code_of_conductyes
has_pull_request_templateno
How it's scored
68.3/80Total downloads — 3,748,634 downloads all-time across rubygems
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagesdatabase_consistency
dependents
ecosystemsrubygems
total_downloads3,748,634
monthly_downloads
Excluded from scoring (no data or not applicable): Registry dependents. Remaining weights renormalized.

Sustainability & Governance

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

64Moderate · 24% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
4.4/22.5Commit distribution — top contributor authored 80% of commits
13.5/13.5Contributor breadth — 36 contributors
3/10OpenSSF Scorecard: Contributors — project has 1 contributing companies or organizations -- score normalized to 3
Inputs used
bus_factor1
contributors_sampled36
top_contributor_share0.805
How it's scored
45.9/46.8Issue resolution — 98% of issues closed
35.9/38.3PR acceptance — 183/195 decided PRs merged
4.5/15OpenSSF Scorecard: Code-Review — Found 6/18 approved changesets -- score normalized to 3
Inputs used
merged_prs183
open_issues2
closed_issues108
issue_closed_ratio0.982
closed_unmerged_prs12
How it's scored
10/30Ownership backing — personal (user) account
0/20Verified domain — not applicable to user accounts
13.3/25Owner reach — 70 followers of djezzzl
19.3/25Track record — 9 public repos, account ~11 yr old
Inputs used
followers70
owner_typeUser
is_verified
owner_logindjezzzl
public_repos9
account_age_days4,283
Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.
How it's scored
25/25Published & resolvable — 1 package(s) on rubygems
35/35Publish recency — latest publish 0 days ago
20/20Version history — 127 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagesdatabase_consistency
ecosystemsrubygems
any_deprecatedno
min_days_since_publish0

Engineering Quality

Are baseline engineering and documentation practices in place?

78Good · 20% of overall
How it's scored
24/24CI workflows — 5 workflow(s)
24/24Tests present
16/16Linter config — .rubocop.yml
0/9.6Pre-commit hooks
0/6.4.editorconfig
16/20OpenSSF Scorecard: CI-Tests — 16 out of 18 merged PRs checked by a CI test -- score normalized to 8
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configyes
has_precommit_configno
How it's scored
30/30README
25/25Documentation directory
0/15Documentation / homepage site
10/10Repository description
10/10Topics — 9 topics
0/10Wiki
Inputs used
topicsruby-on-rails, activerecord, tool, database, consistency, optimization, performance, rails, ruby
has_wikino
homepage
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

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

24Critical · 16% of overall
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — no data
2/2.5CI-Tests — 16 out of 18 merged PRs checked by a CI test -- score normalized to 8
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
2.2/7.5Code-Review — Found 6/18 approved changesets -- score normalized to 3
0.8/2.5Contributors — project has 1 contributing companies or organizations -- score normalized to 3
10/10Dangerous-Workflow — no dangerous workflow patterns detected
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
7.5/7.5Maintained — 11 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
0/5Packaging — no data
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
0/5SAST — SAST tool is not run on all commits -- score normalized to 0
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — no data
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
7.5/7.5Vulnerabilities — 0 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated15
scorecard_versionv5.5.0
checks_inconclusive3
scorecard_aggregate4.7
high_risk_jurisdiction_cap49
high_risk_jurisdiction_multiplier50
security_posture_after_multiplier24
security_posture_before_jurisdiction47
Excluded from scoring (no data or not applicable): branch_protection, packaging, signed_releases. Remaining weights renormalized. High-Risk Jurisdiction Policy applies a 50% multiplier and gives Security posture an At risk ceiling of 49.

AI Readiness

How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score.

45At risk · 0% of overall
How it's scored
18/45Agent instructions — .github/copilot-instructions.md (stub)
0/15Machine-readable docs (llms.txt)
0/40Legible commit history — no data
Inputs used
has_llms_txtno
legible_history_share
agent_instruction_files.github/copilot-instructions.md
agent_instruction_max_bytes106
Excluded from scoring (no data or not applicable): Legible commit history. Remaining weights renormalized.
How it's scored
0/18One-command bootstrap
22/22Automated tests
11/11Lint / format config — .rubocop.yml
0/11Static type checking
10/10Reproducible environment — Dockerfile
0/10Demonstrated agent practice — no data
0/8Automated maintenance — no data
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfiles
has_dockerfileyes
typed_languageno
bootstrap_files
has_devcontainerno
has_linter_configyes
typecheck_configs
agent_commit_share
toolchain_manifests
dependency_bot_commit_share
Excluded from scoring (no data or not applicable): Demonstrated agent practice, Automated maintenance. Remaining weights renormalized.
How it's scored
0/45Type-checkable code — Ruby without a type-check config
55/55Manageable file sizes — 0/329 source files over 60KB
Inputs used
primary_languageRuby
largest_source_bytes24,403
source_files_sampled329
oversized_source_files0

Key facts

1,193GitHub stars
36contributors
51commits, last 12 months
0days since last push
100releases
1bus factor
2open issues
npm, RubyGemspackage ecosystems

More detail

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).Scorecard v5.5.0 · 2026-07-19 17:53 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
8CI-Tests16 out of 18 merged PRs checked by a CI test -- score normalized to 8
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
3Code-ReviewFound 6/18 approved changesets -- score normalized to 3
3Contributorsproject has 1 contributing companies or organizations -- score normalized to 3
10Dangerous-Workflowno dangerous workflow patterns detected
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
10Maintained11 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
n/aPackagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
0SASTSAST tool is not run on all commits -- score normalized to 0
0Security-Policysecurity policy file not detected
n/aSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
10Vulnerabilities0 existing vulnerabilities detected
Direct dependencies 58
RegistryPackageVersion constraintManifest
RubyGemsappraisalGemfile
RubyGemsactiverecordGemfile
RubyGemsmysql2Gemfile
RubyGemspgGemfile
RubyGemssqlite3Gemfile
RubyGemsrails~> 5.2.1rails-example/Gemfile
RubyGemssqlite3rails-example/Gemfile
RubyGemspuma~> 3.11rails-example/Gemfile
RubyGemssass-rails~> 5.0rails-example/Gemfile
RubyGemsuglifier>= 1.3.0rails-example/Gemfile
RubyGemscoffee-rails~> 4.2rails-example/Gemfile
RubyGemsturbolinks~> 5rails-example/Gemfile
RubyGemsjbuilder~> 2.5rails-example/Gemfile
RubyGemsbootsnap>= 1.1.0rails-example/Gemfile
RubyGemstzinfo-datarails-example/Gemfile
RubyGemsconcurrent-ruby1.3.4rails6-example/Gemfile
RubyGemsrails~> 6.0.0rails6-example/Gemfile
RubyGemssqlite3~> 1.4rails6-example/Gemfile
RubyGemspuma~> 3.11rails6-example/Gemfile
RubyGemssass-rails~> 5rails6-example/Gemfile
RubyGemswebpacker~> 4.0rails6-example/Gemfile
RubyGemsturbolinks~> 5rails6-example/Gemfile
RubyGemsjbuilder~> 2.7rails6-example/Gemfile
RubyGemsbootsnap>= 1.4.2rails6-example/Gemfile
RubyGemstzinfo-datarails6-example/Gemfile
npm@rails/actioncable^6.0.0-alpharails6-example/package.json
npm@rails/activestorage^6.0.0-alpharails6-example/package.json
npm@rails/ujs^6.0.0-alpharails6-example/package.json
npm@rails/webpacker^4.0.7rails6-example/package.json
npmturbolinks^5.2.0rails6-example/package.json
RubyGemspgrails7-example/Gemfile
RubyGemsloggerrails7-example/Gemfile
RubyGemsconcurrent-ruby1.3.4rails7-example/Gemfile
RubyGemsrails~> 7.0.6rails7-example/Gemfile
RubyGemssprockets-railsrails7-example/Gemfile
RubyGemssqlite3~> 1.4rails7-example/Gemfile
RubyGemspuma~> 5.0rails7-example/Gemfile
RubyGemsimportmap-railsrails7-example/Gemfile
RubyGemsturbo-railsrails7-example/Gemfile
RubyGemsstimulus-railsrails7-example/Gemfile
RubyGemsjbuilderrails7-example/Gemfile
RubyGemstzinfo-datarails7-example/Gemfile
RubyGemsbootsnaprails7-example/Gemfile
RubyGemsrails~> 8.0.1rails8-example/Gemfile
RubyGemspropshaftrails8-example/Gemfile
RubyGemssqlite3>= 2.1rails8-example/Gemfile
RubyGemspuma>= 5.0rails8-example/Gemfile
RubyGemsimportmap-railsrails8-example/Gemfile
RubyGemsturbo-railsrails8-example/Gemfile
RubyGemsstimulus-railsrails8-example/Gemfile
RubyGemsjbuilderrails8-example/Gemfile
RubyGemstzinfo-datarails8-example/Gemfile
RubyGemssolid_cacherails8-example/Gemfile
RubyGemssolid_queuerails8-example/Gemfile
RubyGemssolid_cablerails8-example/Gemfile
RubyGemsbootsnaprails8-example/Gemfile
RubyGemskamalrails8-example/Gemfile
RubyGemsthrusterrails8-example/Gemfile
All dependencies 74

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

RegistryPackageVersionRelation
npm@rails/actioncable^6.0.0-alphadirect
npm@rails/activestorage^6.0.0-alphadirect
npm@rails/ujs^6.0.0-alphadirect
npm@rails/webpacker^4.0.7direct
npmturbolinks^5.2.0direct
RubyGemsactiverecorddirect
RubyGemsactiverecord5.2.1direct
RubyGemsbootsnapdirect
RubyGemscoffee-railsdirect
RubyGemsconcurrent-ruby1.0.5direct
RubyGemsconcurrent-ruby1.3.4direct
RubyGemsimportmap-railsdirect
RubyGemsjbuilderdirect
RubyGemskamaldirect
RubyGemsloggerdirect
RubyGemsmysql2direct
RubyGemspgdirect
RubyGemspropshaftdirect
RubyGemspumadirect
RubyGemsrailsdirect
RubyGemssass-railsdirect
RubyGemssolid_cabledirect
RubyGemssolid_cachedirect
RubyGemssolid_queuedirect
RubyGemssprockets-railsdirect
RubyGemssqlite3direct
RubyGemssqlite31.3.13direct
RubyGemsstimulus-railsdirect
RubyGemsthrusterdirect
RubyGemsturbo-railsdirect
RubyGemsturbolinksdirect
RubyGemstzinfo-datadirect
RubyGemsuglifierdirect
RubyGemswebpackerdirect
npmwebpack-dev-server^3.8.2indirect
RubyGemsactivemodel5.2.1indirect
RubyGemsactivesupport5.2.1indirect
RubyGemsarel9.0.0indirect
RubyGemsast2.4.0indirect
RubyGemsbrakemanindirect
RubyGemsbundlerindirect
RubyGemsbyebugindirect
RubyGemscapybaraindirect
RubyGemschromedriver-helperindirect
RubyGemsdatabase_consistencyindirect
RubyGemsdiff-lcs1.3indirect
RubyGemsi18n1.1.1indirect
RubyGemslistenindirect
RubyGemsminitest5.11.3indirect
RubyGemsparallel1.12.1indirect
RubyGemsparser2.5.1.2indirect
RubyGemspowerpack0.1.1indirect
RubyGemsrainbow3.0.0indirect
RubyGemsrakeindirect
RubyGemsrake10.5.0indirect
RubyGemsrspecindirect
RubyGemsrspec3.8.0indirect
RubyGemsrspec-core3.8.0indirect
RubyGemsrspec-expectations3.8.1indirect
RubyGemsrspec-mocks3.8.0indirect
RubyGemsrspec-support3.8.0indirect
RubyGemsrspec_junit_formatterindirect
RubyGemsrubocopindirect
RubyGemsrubocop0.55.0indirect
RubyGemsrubocop-rails-omakaseindirect
RubyGemsruby-progressbar1.9.0indirect
RubyGemsselenium-webdriverindirect
RubyGemsspringindirect
RubyGemsspring-watcher-listenindirect
RubyGemsthread_safe0.3.6indirect
RubyGemstzinfo1.2.5indirect
RubyGemsunicode-display_width1.4.0indirect
RubyGemsweb-consoleindirect
RubyGemswebdriversindirect
Raw JSON report machine-readable
{
  "data": {
    "repo": {
      "topics": [
        "ruby-on-rails",
        "activerecord",
        "tool",
        "database",
        "consistency",
        "optimization",
        "performance",
        "rails",
        "ruby"
      ],
      "is_fork": false,
      "size_kb": 985,
      "has_wiki": false,
      "homepage": null,
      "languages": {
        "CSS": 2630,
        "HTML": 53268,
        "Ruby": 487695,
        "Shell": 1972,
        "Dockerfile": 2374,
        "JavaScript": 8054
      },
      "pushed_at": "2026-07-19T17:51:53Z",
      "created_at": "2018-10-30T11:13:51Z",
      "owner_type": "User",
      "updated_at": "2026-07-19T17:46:20Z",
      "description": "The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "master",
      "license_spdx_raw": "MIT",
      "primary_language": "Ruby",
      "significant_languages": [
        "Ruby"
      ]
    },
    "owner": {
      "blog": null,
      "name": "Evgeniy Demin",
      "type": "User",
      "login": "djezzzl",
      "company": null,
      "location": null,
      "followers": 70,
      "avatar_url": "https://avatars.githubusercontent.com/u/9407725?v=4",
      "created_at": "2014-10-26T20:30:27Z",
      "is_verified": null,
      "public_repos": 9,
      "account_age_days": 4283
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": true
    },
    "activity": {
      "releases_count": 100,
      "commits_last_year": 51,
      "latest_release_at": "2026-07-19T17:46:15Z",
      "latest_release_tag": "v3.0.6",
      "releases_from_tags": true,
      "days_since_last_push": 0,
      "active_weeks_last_year": 15,
      "days_since_latest_release": 0,
      "mean_days_between_releases": 24.6
    },
    "community": {
      "has_readme": true,
      "has_license": true,
      "has_description": true,
      "has_contributing": false,
      "health_percentage": 57,
      "has_issue_template": false,
      "has_code_of_conduct": true,
      "has_pull_request_template": false
    },
    "ecosystem": {
      "packages": [
        {
          "name": "database_consistency",
          "exists": true,
          "license": "MIT",
          "keywords": [],
          "ecosystem": "rubygems",
          "matches_repo": true,
          "registry_url": "https://rubygems.org/gems/database_consistency",
          "is_deprecated": false,
          "latest_version": "3.0.6",
          "repository_url": "https://github.com/djezzzl/database_consistency",
          "versions_count": 127,
          "total_downloads": 3748634,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": null,
          "first_published_at": "2018-10-30T11:15:19.751000Z",
          "latest_published_at": "2026-07-19T17:46:19.217000Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 0
        }
      ]
    },
    "popularity": {
      "forks": 63,
      "stars": 1193,
      "watchers": 6,
      "open_issues_and_prs": 5
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [],
      "has_llms_txt": false,
      "has_dockerfile": true,
      "has_mcp_signal": false,
      "bootstrap_files": [],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [],
      "largest_source_bytes": 24403,
      "source_files_sampled": 329,
      "oversized_source_files": 0,
      "agent_instruction_files": [
        ".github/copilot-instructions.md"
      ],
      "agent_instruction_max_bytes": 106
    },
    "dependencies": {
      "manifests": [
        "Gemfile",
        "rails-example/Gemfile",
        "rails-example/package.json",
        "rails6-example/Gemfile",
        "rails6-example/package.json",
        "rails7-example/Gemfile",
        "rails8-example/Gemfile"
      ],
      "ecosystems": [
        "npm",
        "rubygems"
      ],
      "dependencies": [
        {
          "name": "appraisal",
          "manifest": "Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "activerecord",
          "manifest": "Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "mysql2",
          "manifest": "Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "pg",
          "manifest": "Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "sqlite3",
          "manifest": "Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "rails",
          "manifest": "rails-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 5.2.1"
        },
        {
          "name": "sqlite3",
          "manifest": "rails-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "puma",
          "manifest": "rails-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 3.11"
        },
        {
          "name": "sass-rails",
          "manifest": "rails-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 5.0"
        },
        {
          "name": "uglifier",
          "manifest": "rails-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": ">= 1.3.0"
        },
        {
          "name": "coffee-rails",
          "manifest": "rails-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 4.2"
        },
        {
          "name": "turbolinks",
          "manifest": "rails-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 5"
        },
        {
          "name": "jbuilder",
          "manifest": "rails-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 2.5"
        },
        {
          "name": "bootsnap",
          "manifest": "rails-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": ">= 1.1.0"
        },
        {
          "name": "tzinfo-data",
          "manifest": "rails-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "concurrent-ruby",
          "manifest": "rails6-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "1.3.4"
        },
        {
          "name": "rails",
          "manifest": "rails6-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 6.0.0"
        },
        {
          "name": "sqlite3",
          "manifest": "rails6-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 1.4"
        },
        {
          "name": "puma",
          "manifest": "rails6-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 3.11"
        },
        {
          "name": "sass-rails",
          "manifest": "rails6-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 5"
        },
        {
          "name": "webpacker",
          "manifest": "rails6-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 4.0"
        },
        {
          "name": "turbolinks",
          "manifest": "rails6-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 5"
        },
        {
          "name": "jbuilder",
          "manifest": "rails6-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 2.7"
        },
        {
          "name": "bootsnap",
          "manifest": "rails6-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": ">= 1.4.2"
        },
        {
          "name": "tzinfo-data",
          "manifest": "rails6-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "@rails/actioncable",
          "manifest": "rails6-example/package.json",
          "ecosystem": "npm",
          "version_constraint": "^6.0.0-alpha"
        },
        {
          "name": "@rails/activestorage",
          "manifest": "rails6-example/package.json",
          "ecosystem": "npm",
          "version_constraint": "^6.0.0-alpha"
        },
        {
          "name": "@rails/ujs",
          "manifest": "rails6-example/package.json",
          "ecosystem": "npm",
          "version_constraint": "^6.0.0-alpha"
        },
        {
          "name": "@rails/webpacker",
          "manifest": "rails6-example/package.json",
          "ecosystem": "npm",
          "version_constraint": "^4.0.7"
        },
        {
          "name": "turbolinks",
          "manifest": "rails6-example/package.json",
          "ecosystem": "npm",
          "version_constraint": "^5.2.0"
        },
        {
          "name": "pg",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "logger",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "concurrent-ruby",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "1.3.4"
        },
        {
          "name": "rails",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 7.0.6"
        },
        {
          "name": "sprockets-rails",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "sqlite3",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 1.4"
        },
        {
          "name": "puma",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 5.0"
        },
        {
          "name": "importmap-rails",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "turbo-rails",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "stimulus-rails",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "jbuilder",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "tzinfo-data",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "bootsnap",
          "manifest": "rails7-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "rails",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": "~> 8.0.1"
        },
        {
          "name": "propshaft",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "sqlite3",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": ">= 2.1"
        },
        {
          "name": "puma",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": ">= 5.0"
        },
        {
          "name": "importmap-rails",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "turbo-rails",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "stimulus-rails",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "jbuilder",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "tzinfo-data",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "solid_cache",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "solid_queue",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "solid_cable",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "bootsnap",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "kamal",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        },
        {
          "name": "thruster",
          "manifest": "rails8-example/Gemfile",
          "ecosystem": "rubygems",
          "version_constraint": null
        }
      ],
      "all_dependencies": {
        "error": null,
        "source": "github-sbom",
        "packages": [
          {
            "name": "@rails/actioncable",
            "direct": true,
            "version": "^6.0.0-alpha",
            "ecosystem": "npm"
          },
          {
            "name": "@rails/activestorage",
            "direct": true,
            "version": "^6.0.0-alpha",
            "ecosystem": "npm"
          },
          {
            "name": "@rails/ujs",
            "direct": true,
            "version": "^6.0.0-alpha",
            "ecosystem": "npm"
          },
          {
            "name": "@rails/webpacker",
            "direct": true,
            "version": "^4.0.7",
            "ecosystem": "npm"
          },
          {
            "name": "turbolinks",
            "direct": true,
            "version": "^5.2.0",
            "ecosystem": "npm"
          },
          {
            "name": "activerecord",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "activerecord",
            "direct": true,
            "version": "5.2.1",
            "ecosystem": "rubygems"
          },
          {
            "name": "bootsnap",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "coffee-rails",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "concurrent-ruby",
            "direct": true,
            "version": "1.0.5",
            "ecosystem": "rubygems"
          },
          {
            "name": "concurrent-ruby",
            "direct": true,
            "version": "1.3.4",
            "ecosystem": "rubygems"
          },
          {
            "name": "importmap-rails",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "jbuilder",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "kamal",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "logger",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "mysql2",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "pg",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "propshaft",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "puma",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "rails",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "sass-rails",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "solid_cable",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "solid_cache",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "solid_queue",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "sprockets-rails",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "sqlite3",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "sqlite3",
            "direct": true,
            "version": "1.3.13",
            "ecosystem": "rubygems"
          },
          {
            "name": "stimulus-rails",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "thruster",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "turbo-rails",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "turbolinks",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "tzinfo-data",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "uglifier",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "webpacker",
            "direct": true,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "webpack-dev-server",
            "direct": false,
            "version": "^3.8.2",
            "ecosystem": "npm"
          },
          {
            "name": "activemodel",
            "direct": false,
            "version": "5.2.1",
            "ecosystem": "rubygems"
          },
          {
            "name": "activesupport",
            "direct": false,
            "version": "5.2.1",
            "ecosystem": "rubygems"
          },
          {
            "name": "arel",
            "direct": false,
            "version": "9.0.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "ast",
            "direct": false,
            "version": "2.4.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "brakeman",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "bundler",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "byebug",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "capybara",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "chromedriver-helper",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "database_consistency",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "diff-lcs",
            "direct": false,
            "version": "1.3",
            "ecosystem": "rubygems"
          },
          {
            "name": "i18n",
            "direct": false,
            "version": "1.1.1",
            "ecosystem": "rubygems"
          },
          {
            "name": "listen",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "minitest",
            "direct": false,
            "version": "5.11.3",
            "ecosystem": "rubygems"
          },
          {
            "name": "parallel",
            "direct": false,
            "version": "1.12.1",
            "ecosystem": "rubygems"
          },
          {
            "name": "parser",
            "direct": false,
            "version": "2.5.1.2",
            "ecosystem": "rubygems"
          },
          {
            "name": "powerpack",
            "direct": false,
            "version": "0.1.1",
            "ecosystem": "rubygems"
          },
          {
            "name": "rainbow",
            "direct": false,
            "version": "3.0.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "rake",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "rake",
            "direct": false,
            "version": "10.5.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "rspec",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "rspec",
            "direct": false,
            "version": "3.8.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "rspec-core",
            "direct": false,
            "version": "3.8.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "rspec-expectations",
            "direct": false,
            "version": "3.8.1",
            "ecosystem": "rubygems"
          },
          {
            "name": "rspec-mocks",
            "direct": false,
            "version": "3.8.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "rspec-support",
            "direct": false,
            "version": "3.8.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "rspec_junit_formatter",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "rubocop",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "rubocop",
            "direct": false,
            "version": "0.55.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "rubocop-rails-omakase",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "ruby-progressbar",
            "direct": false,
            "version": "1.9.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "selenium-webdriver",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "spring",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "spring-watcher-listen",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "thread_safe",
            "direct": false,
            "version": "0.3.6",
            "ecosystem": "rubygems"
          },
          {
            "name": "tzinfo",
            "direct": false,
            "version": "1.2.5",
            "ecosystem": "rubygems"
          },
          {
            "name": "unicode-display_width",
            "direct": false,
            "version": "1.4.0",
            "ecosystem": "rubygems"
          },
          {
            "name": "web-console",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          },
          {
            "name": "webdrivers",
            "direct": false,
            "version": null,
            "ecosystem": "rubygems"
          }
        ],
        "collected": true,
        "truncated": false,
        "total_count": 74,
        "direct_count": 34,
        "indirect_count": 40
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 3,
        "merged_prs": 183,
        "open_issues": 2,
        "closed_ratio": 0.982,
        "closed_issues": 108,
        "closed_unmerged_prs": 12
      },
      "bus_factor": 1,
      "top_contributors": [
        {
          "type": "User",
          "login": "djezzzl",
          "commits": 334,
          "avatar_url": "https://avatars.githubusercontent.com/u/9407725?v=4"
        },
        {
          "type": "Bot",
          "login": "Copilot",
          "commits": 15,
          "avatar_url": "https://avatars.githubusercontent.com/in/1143301?v=4"
        },
        {
          "type": "User",
          "login": "toydestroyer",
          "commits": 7,
          "avatar_url": "https://avatars.githubusercontent.com/u/578554?v=4"
        },
        {
          "type": "User",
          "login": "soloveytani",
          "commits": 7,
          "avatar_url": "https://avatars.githubusercontent.com/u/43356073?v=4"
        },
        {
          "type": "User",
          "login": "goulvench",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/419086?v=4"
        },
        {
          "type": "User",
          "login": "palkan",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/1516722?v=4"
        },
        {
          "type": "User",
          "login": "ojab",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/153388?v=4"
        },
        {
          "type": "User",
          "login": "chaadow",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/1371733?v=4"
        },
        {
          "type": "User",
          "login": "tdeo",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/6230277?v=4"
        },
        {
          "type": "User",
          "login": "ql",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/16793?v=4"
        }
      ],
      "contributors_sampled": 36,
      "top_contributor_share": 0.805
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "copilot-setup-steps.yml",
        "integrations.yml",
        "release.yml",
        "rubocop.yml",
        "tests.yml"
      ],
      "has_docs_dir": true,
      "linter_configs": [
        ".rubocop.yml"
      ],
      "has_editorconfig": false,
      "has_linter_config": true,
      "has_precommit_config": false
    },
    "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": 8,
            "reason": "16 out of 18 merged PRs checked by a CI test -- score normalized to 8",
            "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": 3,
            "reason": "Found 6/18 approved changesets -- score normalized to 3",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 3,
            "reason": "project has 1 contributing companies or organizations -- score normalized to 3",
            "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": "11 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
          },
          {
            "name": "Packaging",
            "score": 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": "758320db8e02d3e407057b7866785abd9a5d170f",
        "ran_at": "2026-07-19T17:53:13Z",
        "aggregate_score": 4.7,
        "scorecard_version": "v5.5.0"
      },
      "has_codeql_workflow": false,
      "has_security_policy": false,
      "has_dependabot_config": false
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/djezzzl/database_consistency",
    "host": "github.com",
    "name": "database_consistency",
    "owner": "djezzzl"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "at_risk",
      "name": "Overall health",
      "note": "High-Risk Jurisdiction Policy applies a 50% multiplier to weighted overall health and gives it an At risk ceiling of 49.",
      "notes": [
        {
          "code": "jurisdiction_overall_adjustment",
          "params": {
            "cap": 49,
            "pct": 50
          }
        }
      ],
      "value": 32,
      "inputs": {
        "security": 24,
        "vitality": 78,
        "community": 72,
        "governance": 64,
        "engineering": 78,
        "high_risk_jurisdiction_cap": 49,
        "high_risk_jurisdiction_multiplier": 50,
        "weighted_overall_before_jurisdiction": 65,
        "overall_after_jurisdiction_multiplier": 32
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "good",
        "name": "Vitality",
        "value": 78,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "good",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 72,
            "inputs": {
              "commits_last_year": 51,
              "human_commit_share": null,
              "days_since_last_push": 0,
              "active_weeks_last_year": 15
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 0 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "15/52 weeks with commits",
                "points": 10.4,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 15
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "51 commits in the last year",
                "points": 15.4,
                "status": "partial",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 51
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "11 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "release_discipline",
            "band": "excellent",
            "name": "Release discipline",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 88,
            "inputs": {
              "releases_count": 100,
              "latest_release_tag": "v3.0.6",
              "releases_from_tags": true,
              "days_since_latest_release": 0,
              "mean_days_between_releases": 24.6
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "100 version tags (no GitHub releases)",
                "points": 16.2,
                "status": "partial",
                "details": [
                  {
                    "code": "version_tags_no_releases",
                    "params": {
                      "count": 100
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 0 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~24.6 days",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 24.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": "excellent",
            "name": "Abandonment",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "cap": null,
              "state": "unverified",
              "guards": [],
              "signals": [],
              "red_flag": false,
              "multiplier_pct": 100,
              "declared_reason": null,
              "unverified_reason": "no_commit_sample",
              "unanswered_open_prs": null,
              "unanswered_open_issues": null,
              "days_since_last_merged_pr": null,
              "days_since_last_human_commit": null,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "maintenance record not established from the collected data",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_unverified",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Is the project alive — is code being written and are releases shipping?"
      },
      {
        "key": "community",
        "band": "good",
        "name": "Community & Adoption",
        "value": 72,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "moderate",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 69,
            "inputs": {
              "forks": 63,
              "stars": 1193,
              "watchers": 6,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "1,193 stars",
                "points": 49.9,
                "status": "partial",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 1193
                    }
                  }
                ],
                "max_points": 60
              },
              {
                "key": "forks",
                "name": "Forks",
                "detail": "63 forks",
                "points": 14.9,
                "status": "partial",
                "details": [
                  {
                    "code": "forks",
                    "params": {
                      "count": 63
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "watchers",
                "name": "Watchers",
                "detail": "6 watchers",
                "points": 3.9,
                "status": "partial",
                "details": [
                  {
                    "code": "watchers",
                    "params": {
                      "count": 6
                    }
                  }
                ],
                "max_points": 15
              }
            ]
          },
          {
            "key": "community_health",
            "band": "moderate",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 65,
            "inputs": {
              "has_readme": true,
              "has_license": true,
              "has_contributing": false,
              "has_issue_template": false,
              "has_code_of_conduct": true,
              "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": 13.5,
                "status": "met",
                "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
              }
            ]
          },
          {
            "key": "ecosystem_adoption",
            "band": "excellent",
            "name": "Ecosystem adoption (downloads)",
            "note": "Excluded from scoring (no data or not applicable): Registry dependents. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "registry_dependents"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 85,
            "inputs": {
              "packages": [
                "database_consistency"
              ],
              "dependents": null,
              "ecosystems": "rubygems",
              "total_downloads": 3748634,
              "monthly_downloads": null
            },
            "components": [
              {
                "key": "total_downloads",
                "name": "Total downloads",
                "detail": "3,748,634 downloads all-time across rubygems",
                "points": 68.3,
                "status": "partial",
                "details": [
                  {
                    "code": "downloads_total",
                    "params": {
                      "count": 3748634,
                      "ecosystems": "rubygems"
                    }
                  }
                ],
                "max_points": 80
              },
              {
                "key": "registry_dependents",
                "name": "Registry dependents",
                "detail": "not reported by this ecosystem",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "not_reported_by_this_ecosystem",
                    "params": {}
                  }
                ],
                "max_points": 20
              }
            ]
          }
        ],
        "description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
      },
      {
        "key": "governance",
        "band": "moderate",
        "name": "Sustainability & Governance",
        "value": 64,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "at_risk",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 30,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 36,
              "top_contributor_share": 0.805
            },
            "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 80% of commits",
                "points": 4.4,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 80
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "36 contributors",
                "points": 13.5,
                "status": "met",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 36
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 1 contributing companies or organizations -- score normalized to 3",
                "points": 3,
                "status": "partial",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "excellent",
            "name": "Issue & PR responsiveness",
            "note": null,
            "notes": [],
            "value": 86,
            "inputs": {
              "merged_prs": 183,
              "open_issues": 2,
              "closed_issues": 108,
              "issue_closed_ratio": 0.982,
              "closed_unmerged_prs": 12
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "98% of issues closed",
                "points": 45.9,
                "status": "partial",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 98
                    }
                  }
                ],
                "max_points": 46.75
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "183/195 decided PRs merged",
                "points": 35.9,
                "status": "partial",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 183,
                      "decided": 195
                    }
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 6/18 approved changesets -- score normalized to 3",
                "points": 4.5,
                "status": "partial",
                "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": 53,
            "inputs": {
              "followers": 70,
              "owner_type": "User",
              "is_verified": null,
              "owner_login": "djezzzl",
              "public_repos": 9,
              "account_age_days": 4283
            },
            "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": "70 followers of djezzzl",
                "points": 13.3,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 70,
                      "login": "djezzzl"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "9 public repos, account ~11 yr old",
                "points": 19.3,
                "status": "partial",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 9
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 11
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "excellent",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "packages": [
                "database_consistency"
              ],
              "ecosystems": "rubygems",
              "any_deprecated": false,
              "min_days_since_publish": 0
            },
            "components": [
              {
                "key": "published_resolvable",
                "name": "Published & resolvable",
                "detail": "1 package(s) on rubygems",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "packages_published",
                    "params": {
                      "count": 1,
                      "ecosystems": "rubygems"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "publish_recency",
                "name": "Publish recency",
                "detail": "latest publish 0 days ago",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "127 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 127
                    }
                  }
                ],
                "max_points": 20
              },
              {
                "key": "not_deprecated",
                "name": "Not deprecated",
                "detail": "active, not deprecated or yanked",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "package_not_deprecated",
                    "params": {}
                  }
                ],
                "max_points": 20
              }
            ]
          }
        ],
        "description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
      },
      {
        "key": "engineering",
        "band": "good",
        "name": "Engineering Quality",
        "value": 78,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "good",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 80,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": true,
              "has_precommit_config": false
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "5 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 5
                    }
                  }
                ],
                "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": ".rubocop.yml",
                "points": 16,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".rubocop.yml"
                    }
                  }
                ],
                "max_points": 16
              },
              {
                "key": "pre_commit_hooks",
                "name": "Pre-commit hooks",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 9.6
              },
              {
                "key": "editorconfig",
                "name": ".editorconfig",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.4
              },
              {
                "key": "openssf_scorecard_ci_tests",
                "name": "OpenSSF Scorecard: CI-Tests",
                "detail": "16 out of 18 merged PRs checked by a CI test -- score normalized to 8",
                "points": 16,
                "status": "partial",
                "details": [],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "good",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 75,
            "inputs": {
              "topics": [
                "ruby-on-rails",
                "activerecord",
                "tool",
                "database",
                "consistency",
                "optimization",
                "performance",
                "rails",
                "ruby"
              ],
              "has_wiki": false,
              "homepage": null,
              "has_readme": true,
              "has_docs_dir": true,
              "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": 25,
                "status": "met",
                "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": "9 topics",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "topics_count",
                    "params": {
                      "count": 9
                    }
                  }
                ],
                "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": "critical",
        "name": "Security",
        "value": 24,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "critical",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): Branch-Protection, Packaging, Signed-Releases. Remaining weights renormalized. High-Risk Jurisdiction Policy applies a 50% multiplier to Security posture and gives it an At risk ceiling of 49.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "branch_protection",
                    "packaging",
                    "signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              },
              {
                "code": "jurisdiction_posture_adjustment",
                "params": {
                  "cap": 49,
                  "pct": 50
                }
              }
            ],
            "value": 24,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 15,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 3,
              "scorecard_aggregate": 4.7,
              "high_risk_jurisdiction_cap": 49,
              "high_risk_jurisdiction_multiplier": 50,
              "security_posture_after_multiplier": 24,
              "security_posture_before_jurisdiction": 47
            },
            "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": "16 out of 18 merged PRs checked by a CI test -- score normalized to 8",
                "points": 2,
                "status": "partial",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "cii_best_practices",
                "name": "CII-Best-Practices",
                "detail": "no effort to earn an OpenSSF best practices badge detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "code_review",
                "name": "Code-Review",
                "detail": "Found 6/18 approved changesets -- score normalized to 3",
                "points": 2.2,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 1 contributing companies or organizations -- score normalized to 3",
                "points": 0.8,
                "status": "partial",
                "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": "11 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10",
                "points": 7.5,
                "status": "met",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "packaging",
                "name": "Packaging",
                "detail": "packaging workflow 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": "moderate",
            "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": 50,
            "inputs": {
              "meaning": "self-published location evidence; not nationality or citizenship",
              "red_flag": true,
              "exposures": [
                {
                  "role": "top_contributor",
                  "count": 1,
                  "country": "Russia"
                }
              ],
              "policy_countries": [
                "Russia",
                "Iran",
                "North Korea"
              ],
              "review_only_matches": 0,
              "assessed_self_published_locations": 11
            },
            "components": [
              {
                "key": "policy_exposure_multiplier",
                "name": "Policy exposure multiplier",
                "detail": "Russia: top_contributor (1)",
                "points": 50,
                "status": "partial",
                "details": [
                  {
                    "code": "jurisdiction_exposure",
                    "params": {
                      "role": "top_contributor",
                      "count": 1,
                      "country": "Russia"
                    }
                  }
                ],
                "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": "at_risk",
        "name": "AI Readiness",
        "value": 45,
        "weight": 0,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "at_risk",
            "name": "Agent context & guidance",
            "note": "Excluded from scoring (no data or not applicable): Legible commit history. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "legible_commit_history"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 30,
            "inputs": {
              "has_llms_txt": false,
              "legible_history_share": null,
              "agent_instruction_files": [
                ".github/copilot-instructions.md"
              ],
              "agent_instruction_max_bytes": 106
            },
            "components": [
              {
                "key": "agent_instructions",
                "name": "Agent instructions",
                "detail": ".github/copilot-instructions.md (stub)",
                "points": 18,
                "status": "partial",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".github/copilot-instructions.md"
                    }
                  },
                  {
                    "code": "agent_instructions_stub",
                    "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": "no data",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "moderate",
            "name": "Verify loop (build / test / typecheck)",
            "note": "Excluded from scoring (no data or not applicable): Demonstrated agent practice, Automated maintenance. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "demonstrated_agent_practice",
                    "automated_maintenance"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 52,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [],
              "has_dockerfile": true,
              "typed_language": false,
              "bootstrap_files": [],
              "has_devcontainer": false,
              "has_linter_config": true,
              "typecheck_configs": [],
              "agent_commit_share": null,
              "toolchain_manifests": [],
              "dependency_bot_commit_share": null
            },
            "components": [
              {
                "key": "one_command_bootstrap",
                "name": "One-command bootstrap",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "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": ".rubocop.yml",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".rubocop.yml"
                    }
                  }
                ],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 11
              },
              {
                "key": "reproducible_environment",
                "name": "Reproducible environment",
                "detail": "Dockerfile",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "Dockerfile"
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "demonstrated_agent_practice",
                "name": "Demonstrated agent practice",
                "detail": "no data",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 10
              },
              {
                "key": "automated_maintenance",
                "name": "Automated maintenance",
                "detail": "no data",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "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": "moderate",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 55,
            "inputs": {
              "primary_language": "Ruby",
              "largest_source_bytes": 24403,
              "source_files_sampled": 329,
              "oversized_source_files": 0
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "Ruby without a type-check config",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_typecheck_config_language",
                    "params": {
                      "language": "Ruby"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "0/329 source files over 60KB",
                "points": 55,
                "status": "met",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 329,
                      "oversized": 0
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          }
        ],
        "description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
      }
    ],
    "metrics_version": "1.13.0"
  },
  "warnings": [],
  "report_type": "repository",
  "generated_at": "2026-07-19T17:53:36.512845Z",
  "schema_version": "0.15.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/d/djezzzl/database_consistency.svg",
  "full_name": "djezzzl/database_consistency",
  "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 v1.13.0, schema v0.15.0 — full methodology · metrics wiki.

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