Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-11-17 15:13 UTC

marinazzio / pg_objects

Simple manager for PostgreSQL objects like triggers and functions

RubyMIT★ 1 star⑂ 0 forkssince Oct 2018View on GitHub ↗
KindLibraryCommand-line toolPluginhow this is determined

marinazzio/pg_objects holds a health index of 71 out of 100, placing it in the Good band. It scores highest on Vitality (81/100) and lowest on Community & Adoption (33/100). It was last updated 8 days ago. A single contributor accounts for most of its recent work.

71
overall / 100
Good

Software health index

Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean, calibrated against the distribution of the public record so bands carry percentile meaning; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At Risk ceiling of 34.

71
Exceptional93-100The record's top tier (≈ top 5%); essentially all checked criteria met
Excellent80-92Strong across the board; minor gaps
Good65-79Healthy; gaps are limited and manageable
Moderate50-64Acceptable with notable gaps; review recommended
Weak35-49Material weaknesses across several areas
At Risk20-34Significant weaknesses; adoption warrants caution
Critical1-19Severe problems (abandoned, single-maintainer, no hygiene)
VitalityCommunity &AdoptionSustainability &GovernanceEngineeringQualitySecurityAI Readiness

Score profile

Each axis is a category. The shape matters more than the average — a healthy subject fills the whole shape, while a spike-and-crater profile means strength in one dimension is masking risk in another.

The weighted overall 63 is calibrated to 71 on the published index scale (record calibration 2026-08-02).

Ownership

Denis KiselevPersonal account
5 followers29 public repossince Mar 2015

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
RubyGemspg_objects1.5.0-37111 days ago

Metrics by category

Vitality

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

81Excellent · 21% of overall
How it's scored
28.8/36Push recency — last push 8 days ago
25.6/36Commit cadence — 37/52 weeks with commits
18/18Commit volume — 117 commits in the last year
9/10OpenSSF Scorecard: Maintained — 10 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 9
Inputs used
commits_last_year117
human_commit_share0.59
days_since_last_push8
active_weeks_last_year37
How it's scored
27/27Ships releases — 17 releases published
27/36Release recency — latest release 111 days ago
19.8/27Release cadence — a release every ~69.9 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count17
latest_release_tagv1.5.0
releases_from_tagsno
days_since_latest_release111
mean_days_between_releases69.9
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?

33At Risk · 17% of overall
How it's scored
0/60Stars — 1 stars
0/25Forks — 0 forks
0/15Watchers — 2 watchers
Inputs used
forks0
stars1
watchers2
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
0/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges1
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_servicesbadge.fury.io
has_pull_request_templateno
How it's scored
48.8/80Total downloads — 49,688 downloads all-time across rubygems
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagespg_objects
dependents—
ecosystemsrubygems
total_downloads49,688
monthly_downloads—
unverified_packages_excluded—
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?

54Moderate · 23% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
0/22.5Commit distribution — top contributor authored 100% of commits
1.4/13.5Contributor breadth — 1 contributors
0/10OpenSSF Scorecard: Contributors — project has 0 contributing companies or organizations -- score normalized to 0
Inputs used
bus_factor1
contributors_sampled1
top_contributor_share1
How it's scored
41.5/42Issue resolution — 99% of issues closed
25.6/30PR acceptance — 296/347 decided PRs merged
0/13Newcomer PR acceptance — no first-time contributor's PR decided in 30d
0/15OpenSSF Scorecard: Code-Review — Found 0/17 approved changesets -- score normalized to 0
Inputs used
merged_prs296
open_issues1
closed_issues83
prs_merged_7d0
prs_decided_7d0
prs_merged_30d1
prs_decided_30d1
issue_closed_ratio0.988
closed_unmerged_prs51
first_time_authors_30d0
first_time_prs_merged_30d0
first_time_prs_decided_30d0
Excluded from scoring (no data or not applicable): Newcomer PR acceptance. Remaining weights renormalized.
How it's scored
10/30Ownership backing — personal (user) account
0/20Verified domain — not applicable to user accounts
5.6/25Owner reach — 5 followers of marinazzio
22.8/25Track record — 29 public repos, account ~11 yr old
Inputs used
followers5
owner_typeUser
is_verified—
owner_loginmarinazzio
public_repos29
account_age_days4,264
Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.

Package maintenance

100Exceptional
How it's scored
25/25Published & resolvable — 1 package(s) on rubygems
35/35Publish recency — latest publish 111 days ago
20/20Version history — 37 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagespg_objects
ecosystemsrubygems
any_deprecatedno
min_days_since_publish111

Engineering Quality

Are baseline engineering and documentation practices in place?

76Good · 19% of overall
How it's scored
24/24CI workflows — 3 workflow(s)
24/24Tests present
16/16Linter config — .rubocop.yml
0/9.6Pre-commit hooks
0/6.4.editorconfig
20/20OpenSSF Scorecard: CI-Tests — 30 out of 30 merged PRs checked by a CI test -- score normalized to 10
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configyes
has_precommit_configno
How it's scored
30/30README
0/25Documentation directory
15/15Documentation / homepage site — https://github.com/marinazzio/pg_objects/blob/master/README.md
10/10Repository description
0/10Topics
10/10Wiki
Inputs used
topics—
has_wikiyes
homepage—
docs_sitehttps://github.com/marinazzio/pg_objects/blob/master/README.md
has_readmeyes
has_docs_dirno
has_descriptionyes

Security

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

73Good · 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.5/2.5CI-Tests — 30 out of 30 merged PRs checked by a CI test -- score normalized to 10
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 0/17 approved changesets -- score normalized to 0
0/2.5Contributors — project has 0 contributing companies or organizations -- score normalized to 0
10/10Dangerous-Workflow — no dangerous workflow patterns detected
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
6.8/7.5Maintained — 10 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 9
0/5Packaging — no data
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
5/5SAST — SAST tool is run on all commits
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — no data
6.8/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_aggregate6.6
Excluded from scoring (no data or not applicable): Branch-Protection, Packaging, Signed-Releases. Remaining weights renormalized.

Dependency advisories

100Exceptional
How it's scored
35/35Direct dependencies free of known advisories — no direct dependency carries a known advisory
0/25Indirect dependencies free of known advisories — transitive set not separable from development and test dependencies in this scope
0/40No advisories left outstanding — no advisory carries a publication date
Inputs used
sourceosv
advisories0
affected_packages0
assessed_packages91
unassessed_packages8
affected_by_severitynone
direct_affected_packages0
Excluded from scoring (no data or not applicable): Indirect dependencies free of known advisories, No advisories left outstanding. Remaining weights renormalized. Matched 91 resolved dependencies against OSV. 8 could not be assessed — no resolved version, an unsupported ecosystem, or beyond the reported package list. This repository publishes no package the index resolves, so the repository dependency graph was assessed instead. That graph mixes development and test pins with shipped dependencies, so only the declared runtime dependencies are scored; transitive findings are reported as context and excluded from the score. Reachability is not analyzed.

AI Readiness

How well is the repo equipped to be developed and maintained with AI coding agents? Carries a deliberately small weight (4%): agent tooling is a real maintenance signal, but a repository with none can still reach 100/100.

44Weak · 4% of overall
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
21.7/40Legible commit history — 24 of 59 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
llms_txt_url—
legible_history_share0.407
agent_instruction_files—
agent_instruction_max_bytes—
How it's scored
0/18One-command bootstrap
22/22Automated tests
11/11Lint / format config — .rubocop.yml
0/11Static type checking
10/10Reproducible environment — lockfile
6/10Demonstrated agent practice — 3 of the last 100 commits agent-authored or agent-credited
8/8Automated maintenance — 41 of the last 100 commits are automated dependency updates
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfilesGemfile.lock
has_dockerfileno
typed_languageno
bootstrap_files—
has_devcontainerno
has_linter_configyes
typecheck_configs—
agent_commit_share0.03
toolchain_manifests—
dependency_bot_commit_share0.41
How it's scored
0/45Type-checkable code — Ruby without a type-check config
55/55Manageable file sizes — 0/80 source files over 60KB
Inputs used
primary_languageRuby
largest_source_bytes13,066
source_files_sampled80
oversized_source_files0

Key facts

1GitHub stars
1contributors
117commits, last 12 months
8days since last push
17releases
1bus factor
1open issues
RubyGemspackage ecosystems

Data collection warnings

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token

More detail

OpenSSF Scorecard 6.6 / 10
6.6aggregate

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-11-17 15:13 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
10CI-Tests30 out of 30 merged PRs checked by a CI test -- score normalized to 10
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/17 approved changesets -- score normalized to 0
0Contributorsproject has 0 contributing companies or organizations -- score normalized to 0
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
9Maintained10 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 9
n/aPackagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
10SASTSAST tool is run on all commits
0Security-Policysecurity policy file not detected
n/aSigned-Releasesno releases found
9Token-Permissionsdetected GitHub workflow tokens with excessive permissions
10Vulnerabilities0 existing vulnerabilities detected
All dependencies 99

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

RegistryPackageVersionRelation
RubyGemsactionpack8.1.4.1indirect
RubyGemsactionview8.1.4.1indirect
RubyGemsactivemodel8.1.4.1indirect
RubyGemsactiverecord—indirect
RubyGemsactiverecord8.1.4.1indirect
RubyGemsactivesupport8.1.4.1indirect
RubyGemsast2.4.3indirect
RubyGemsbase640.3.0indirect
RubyGemsbenchmark0.5.0indirect
RubyGemsbigdecimal4.1.3indirect
RubyGemsbinding_of_caller2.0.0indirect
RubyGemsbuilder3.3.0indirect
RubyGemsbundler-audit0.9.3indirect
RubyGemsbyebug13.0.0indirect
RubyGemscoderay1.1.3indirect
RubyGemsconcurrent-ruby1.3.8indirect
RubyGemsconnection_pool3.0.2indirect
RubyGemscrass1.0.8indirect
RubyGemsdebug_inspector1.2.0indirect
RubyGemsdiff-lcs1.6.2indirect
RubyGemsdrb2.2.3indirect
RubyGemsdry-auto_inject—indirect
RubyGemsdry-auto_inject1.2.1indirect
RubyGemsdry-configurable—indirect
RubyGemsdry-configurable1.4.0indirect
RubyGemsdry-container—indirect
RubyGemsdry-container0.11.0indirect
RubyGemsdry-core1.2.0indirect
RubyGemserb6.0.7indirect
RubyGemserubi1.13.1indirect
RubyGemsfaker3.8.0indirect
RubyGemsgoogle-protobuf4.36.2indirect
RubyGemsi18n1.15.2indirect
RubyGemsio-console0.9.5indirect
RubyGemsirb1.19.0indirect
RubyGemsjson3.1.0indirect
RubyGemslanguage_server-protocol3.17.0.6indirect
RubyGemslint_roller1.1.0indirect
RubyGemslogger1.7.0indirect
RubyGemsloofah2.25.3indirect
RubyGemsmemery—indirect
RubyGemsmemery1.8.0indirect
RubyGemsmethod_source1.1.0indirect
RubyGemsminitest6.1.0indirect
RubyGemsnokogiri1.19.7indirect
RubyGemsparallel2.3.0indirect
RubyGemsparser3.3.13.0indirect
RubyGemspg_query—indirect
RubyGemspg_query6.2.5indirect
RubyGemspp0.6.4indirect
RubyGemsprettyprint0.2.1indirect
RubyGemsprism1.9.0indirect
RubyGemsproc_to_ast0.2.0indirect
RubyGemspry0.16.1indirect
RubyGemspry-byebug3.12.0indirect
RubyGemsracc1.8.1indirect
RubyGemsrack3.2.8indirect
RubyGemsrack-session2.1.2indirect
RubyGemsrack-test2.3.0indirect
RubyGemsrackup2.3.1indirect
RubyGemsrails-dom-testing2.3.0indirect
RubyGemsrails-html-sanitizer1.7.2indirect
RubyGemsrailties—indirect
RubyGemsrailties8.1.4.1indirect
RubyGemsrainbow3.1.1indirect
RubyGemsrake13.4.2indirect
RubyGemsrake-hooks—indirect
RubyGemsrake-hooks1.2.3indirect
RubyGemsrbs4.2.0indirect
RubyGemsrdoc8.1.0indirect
RubyGemsregexp_parser2.13.1indirect
RubyGemsreline0.7.0indirect
RubyGemsrouge5.1.0indirect
RubyGemsrspec3.13.2indirect
RubyGemsrspec-core3.13.7indirect
RubyGemsrspec-expectations3.13.6indirect
RubyGemsrspec-mocks3.13.9indirect
RubyGemsrspec-parameterized2.0.1indirect
RubyGemsrspec-parameterized-core2.0.2indirect
RubyGemsrspec-parameterized-table_syntax2.1.1indirect
RubyGemsrspec-support3.13.8indirect
RubyGemsrubocop1.92.2indirect
RubyGemsrubocop-ast1.50.0indirect
RubyGemsrubocop-rails2.38.0indirect
RubyGemsrubocop-rake0.7.1indirect
RubyGemsrubocop-rspec3.10.2indirect
RubyGemsruby-progressbar1.13.0indirect
RubyGemssecurerandom0.4.1indirect
RubyGemsstrscan3.1.8indirect
RubyGemsthor1.5.0indirect
RubyGemstimeout0.6.1indirect
RubyGemstsort0.2.0indirect
RubyGemstzinfo2.0.6indirect
RubyGemsunicode-display_width3.3.0indirect
RubyGemsunicode-emoji4.3.0indirect
RubyGemsunparser0.9.0indirect
RubyGemsuri1.1.2indirect
RubyGemsuseragent0.16.11indirect
RubyGemszeitwerk2.8.3indirect
Dependency advisories 0

This repository publishes no package the index resolves, so its own dependency graph was assessed — 91 packages, which also include development and test pins that never ship: 0 carry known advisories, of which 0 are direct. 8 could not be assessed — no resolved version, an unsupported ecosystem, or beyond the reported package list.

No known advisories affect the assessed dependencies.

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

Raw JSON report machine-readable

Feedback

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

The message is kept through sign-in.

Scores are signals, not warranties. They reflect publicly visible practices on GitHub — not a code audit, and not a security guarantee.

Missing data is excluded and weights renormalized, never scored as zero. Methodology is versioned and open: metrics v2.10.0, schema v0.34.0 — full methodology · metrics wiki.

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