Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-09-15 16:31 UTC

alexandrainst / node-red-contrib-postgresql

Node-RED node for PostgreSQL, supporting parameters, split, back-pressure

HTML · JavaScriptApache-2.0★ 38 stars⑂ 12 forkssince Jul 2021View on GitHub ↗

alexandrainst/node-red-contrib-postgresql holds a health index of 81 out of 100, placing it in the Excellent band. It scores highest on Engineering Quality (83/100) and lowest on Community & Adoption (49/100). It was last updated 14 days ago. A single contributor accounts for most of its recent work.

81
overall / 100
Excellent

Software health index

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

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

Score profile

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

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

Ownership

Alexandra InstituteOrganization · verified domain
73 followers102 public repossince Jan 2014

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publishTags
npmnode-red-contrib-postgresql0.16.211,5012438 days agobackpressurenode-red-contribnode-rednoderedpostgrespostgresqltimescale

Metrics by category

Vitality

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

73Good · 21% of overall
How it's scored
28.8/36Push recency — last push 14 days ago
12.5/36Commit cadence — 18/52 weeks with commits
14.4/18Commit volume — 39 commits in the last year
10/10OpenSSF Scorecard: Maintained — 17 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year39
human_commit_share0.47
days_since_last_push14
active_weeks_last_year18
How it's scored
27/27Ships releases — 27 releases published
36/36Release recency — latest release 38 days ago
12.6/27Release cadence — a release every ~129.4 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count27
latest_release_tagv0.16.2
releases_from_tagsno
days_since_latest_release38
mean_days_between_releases129.4
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?

49Weak · 17% of overall
How it's scored
25.4/60Stars — 38 stars
8.7/25Forks — 12 forks
3.3/15Watchers — 5 watchers
Inputs used
forks12
stars38
watchers5
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (Apache-2.0)
0/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges0
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_services—
has_pull_request_templateno
How it's scored
54.1/80Monthly downloads — 11,501 downloads/month across npm
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagesnode-red-contrib-postgresql
dependents—
ecosystemsnpm
total_downloads—
monthly_downloads11,501
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?

70Good · 23% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
7.2/22.5Commit distribution — top contributor authored 68% of commits
12.2/13.5Contributor breadth — 9 contributors
10/10OpenSSF Scorecard: Contributors — project has 3 contributing companies or organizations -- score normalized to 10
Inputs used
bus_factor1
contributors_sampled9
top_contributor_share0.68
How it's scored
31.5/42Issue resolution — 75% of issues closed
25.2/30PR acceptance — 83/99 decided PRs merged
0/13Newcomer PR acceptance — no first-time contributor's PR decided in 30d
0/15OpenSSF Scorecard: Code-Review — Found 1/11 approved changesets -- score normalized to 0
Inputs used
merged_prs83
open_issues10
closed_issues30
prs_merged_7d0
prs_decided_7d0
prs_merged_30d0
prs_decided_30d0
issue_closed_ratio0.75
closed_unmerged_prs16
first_time_authors_30d0
first_time_prs_merged_30d0
first_time_prs_decided_30d0
Excluded from scoring (no data or not applicable): Newcomer PR acceptance. Remaining weights renormalized.
How it's scored
30/30Ownership backing — organization-owned
20/20Verified domain
13.4/25Owner reach — 73 followers of alexandrainst
25/25Track record — 102 public repos, account ~12 yr old
Inputs used
followers73
owner_typeOrganization
is_verifiedyes
owner_loginalexandrainst
public_repos102
account_age_days4,618

Package maintenance

100Exceptional
How it's scored
25/25Published & resolvable — 1 package(s) on npm
35/35Publish recency — latest publish 38 days ago
20/20Version history — 24 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagesnode-red-contrib-postgresql
ecosystemsnpm
any_deprecatedno
min_days_since_publish38

Engineering Quality

Are baseline engineering and documentation practices in place?

83Excellent · 19% of overall
How it's scored
24/24CI workflows — 2 workflow(s)
24/24Tests present
16/16Linter config — eslint.config.mjs
0/9.6Pre-commit hooks
6.4/6.4.editorconfig
18/20OpenSSF Scorecard: CI-Tests — 25 out of 26 merged PRs checked by a CI test -- score normalized to 9
Inputs used
has_ciyes
has_testsyes
has_editorconfigyes
has_linter_configyes
has_precommit_configno
How it's scored
30/30README
0/25Documentation directory
15/15Documentation / homepage site — https://flows.nodered.org/node/node-red-contrib-postgresql
10/10Repository description
10/10Topics — 5 topics
10/10Wiki
Inputs used
topicsnode-red-contrib, node-red, postgresql, alx-ailab, alx-production
has_wikiyes
homepagehttps://flows.nodered.org/node/node-red-contrib-postgresql
docs_sitehttps://flows.nodered.org/node/node-red-contrib-postgresql
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.2/2.5CI-Tests — 25 out of 26 merged PRs checked by a CI test -- score normalized to 9
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 1/11 approved changesets -- score normalized to 0
2.5/2.5Contributors — project has 3 contributing companies or organizations -- score normalized to 10
0/10Dangerous-Workflow — no data
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — no data
2.5/2.5License — license file detected
7.5/7.5Maintained — 17 commit(s) and 0 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
4.5/5SAST — SAST tool is not run on all commits -- score normalized to 9
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — no data
0/7.5Token-Permissions — no data
6.8/7.5Vulnerabilities — 1 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated12
scorecard_versionv5.5.0
checks_inconclusive6
scorecard_aggregate6.6
Excluded from scoring (no data or not applicable): Branch-Protection, Dangerous-Workflow, Fuzzing, Packaging, Signed-Releases, Token-Permissions. Remaining weights renormalized.

Dependency advisories

100Exceptional
How it's scored
35/35Direct dependencies free of known advisories — no direct dependency carries a known advisory
25/25Indirect dependencies free of known advisories — no indirect dependency carries a known advisory
0/40No advisories left outstanding — no advisory carries a publication date
Inputs used
sourceosv
advisories0
affected_packages0
assessed_packages16
unassessed_packages0
affected_by_severitynone
direct_affected_packages0
Excluded from scoring (no data or not applicable): No advisories left outstanding. Remaining weights renormalized. Matched the npm:node-red-contrib-postgresql@0.16.2 runtime dependency closure — what installing the published package pulls in — 16 packages. Reachability is not analyzed.

AI Readiness

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

52Moderate · 4% of overall
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
15.9/40Legible commit history — 14 of 47 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
llms_txt_url—
legible_history_share0.298
agent_instruction_files—
agent_instruction_max_bytes—
How it's scored
0/18One-command bootstrap
22/22Automated tests
11/11Lint / format config — eslint.config.mjs
0/11Static type checking
10/10Reproducible environment — Dockerfile, lockfile
8/10Demonstrated agent practice — 4 of the last 100 commits agent-authored or agent-credited
8/8Automated maintenance — 53 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
lockfilespackage-lock.json
has_dockerfileyes
typed_languageno
bootstrap_files—
has_devcontainerno
has_linter_configyes
typecheck_configs—
agent_commit_share0.04
toolchain_manifests—
dependency_bot_commit_share0.53
How it's scored
0/45Type-checkable code — HTML without a type-check config
55/55Manageable file sizes — 0/5 source files over 60KB
Inputs used
primary_languageHTML
largest_source_bytes11,849
source_files_sampled5
oversized_source_files0
How it's scored
0/40API schema (OpenAPI/GraphQL/proto) — not applicable to this kind of software
0/20MCP server — not applicable to this kind of software
40/40Runnable examples — examples
Inputs used
example_dirsexamples
has_mcp_signalno
api_schema_files—
interfaces_expected_of—
Excluded from scoring (no data or not applicable): API schema (OpenAPI/GraphQL/proto), MCP server. Remaining weights renormalized.

Key facts

38GitHub stars
9contributors
39commits, last 12 months
14days since last push
27releases
1bus factor
10open issues
npmpackage ecosystems

Data collection warnings

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

More detail

Star and fork history 0 ★ / 12 ⇿
0Stars
12Forks
20Releases

When each star and fork was added, collected from GitHub and bucketed by day. Cumulative growth sits directly above the daily additions it is made of, so the two read against each other: steady organic accretion looks nothing like an abrupt, short-lived burst. Where that difference is measurable, it is reported as growth authenticity.

0246810121212021-092024-012026-05
Major 0Minor 11Patch 9

Each point covers 5 days.

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-09-15 16:31 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
9CI-Tests25 out of 26 merged PRs checked by a CI test -- score normalized to 9
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 1/11 approved changesets -- score normalized to 0
10Contributorsproject has 3 contributing companies or organizations -- score normalized to 10
n/aDangerous-Workflowno workflows found
10Dependency-Update-Toolupdate tool detected
n/aFuzzinginternal error: internal error: Client.Search.Code: http.Get: Get "https://oss-fuzz-build-logs.storage.googleapis.com/status.json": dial tcp [2a00:1450:4001:c0f::cf]:443: connect: network is unreachable
10Licenselicense file detected
10Maintained17 commit(s) and 0 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
9SASTSAST tool is not run on all commits -- score normalized to 9
0Security-Policysecurity policy file not detected
n/aSigned-Releasesno releases found
n/aToken-PermissionsNo tokens found
9Vulnerabilities1 existing vulnerabilities detected
Direct dependencies 3
RegistryPackageVersion constraintManifest
npmmustache^4.2.0package.json
npmpg^8.22.0package.json
npmpg-cursor^2.21.0package.json
All dependencies 216

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

RegistryPackageVersionRelation
npmmustache4.2.0direct
npmpg8.23.0direct
npmpg-cursor2.22.0direct
npm@eslint-community/eslint-utils4.10.1indirect
npm@eslint-community/regexpp4.12.2indirect
npm@eslint/config-array0.23.5indirect
npm@eslint/config-helpers0.7.0indirect
npm@eslint/core1.2.1indirect
npm@eslint/js10.0.1indirect
npm@eslint/object-schema3.0.5indirect
npm@eslint/plugin-kit0.7.2indirect
npm@humanfs/core0.19.2indirect
npm@humanfs/node0.16.8indirect
npm@humanfs/types0.15.0indirect
npm@humanwhocodes/gitignore-to-minimatch1.0.2indirect
npm@humanwhocodes/module-importer1.0.1indirect
npm@humanwhocodes/retry0.4.3indirect
npm@nodelib/fs.scandir2.1.5indirect
npm@nodelib/fs.stat2.0.5indirect
npm@nodelib/fs.walk1.2.8indirect
npm@sindresorhus/merge-streams4.0.0indirect
npm@stylistic/eslint-plugin5.10.0indirect
npm@types/debug4.1.13indirect
npm@types/esrecurse4.3.1indirect
npm@types/estree1.0.9indirect
npm@types/json-schema7.0.15indirect
npm@types/katex0.16.8indirect
npm@types/ms2.1.0indirect
npm@types/unist2.0.11indirect
npm@typescript-eslint/eslint-plugin8.66.0indirect
npm@typescript-eslint/parser8.66.0indirect
npm@typescript-eslint/project-service8.66.0indirect
npm@typescript-eslint/scope-manager8.66.0indirect
npm@typescript-eslint/tsconfig-utils8.66.0indirect
npm@typescript-eslint/type-utils8.66.0indirect
npm@typescript-eslint/types8.66.0indirect
npm@typescript-eslint/typescript-estree8.66.0indirect
npm@typescript-eslint/utils8.66.0indirect
npm@typescript-eslint/visitor-keys8.66.0indirect
npmacorn8.18.0indirect
npmacorn-jsx5.3.2indirect
npmajv6.15.0indirect
npmansi-regex6.2.2indirect
npmargparse2.0.1indirect
npmbalanced-match4.0.4indirect
npmbrace-expansion5.0.9indirect
npmbraces3.0.3indirect
npmcharacter-entities2.0.2indirect
npmcharacter-entities-legacy3.0.0indirect
npmcharacter-reference-invalid2.0.1indirect
npmcommander8.3.0indirect
npmcross-spawn7.0.6indirect
npmdebug4.4.3indirect
npmdecode-named-character-reference1.3.0indirect
npmdeep-is0.1.4indirect
npmdequal2.0.3indirect
npmdevlop1.1.0indirect
npmdom-serializer2.0.0indirect
npmdomelementtype2.3.0indirect
npmdomhandler5.0.3indirect
npmdomutils3.2.2indirect
npmenhanced-resolve5.24.5indirect
npmentities4.5.0indirect
npmentities7.0.1indirect
npmescape-string-regexp4.0.0indirect
npmeslint10.9.1indirect
npmeslint-compat-utils0.5.1indirect
npmeslint-plugin-es-x7.8.0indirect
npmeslint-plugin-html8.2.0indirect
npmeslint-plugin-n18.2.2indirect
npmeslint-plugin-promise7.3.0indirect
npmeslint-scope9.1.2indirect
npmeslint-visitor-keys3.4.3indirect
npmeslint-visitor-keys4.2.1indirect
npmeslint-visitor-keys5.0.1indirect
npmespree10.4.0indirect
npmespree11.2.0indirect
npmesquery1.7.0indirect
npmesrecurse4.3.0indirect
npmestraverse5.3.0indirect
npmesutils2.0.3indirect
npmfast-deep-equal3.1.3indirect
npmfast-glob3.3.3indirect
npmfast-json-stable-stringify2.1.0indirect
npmfast-levenshtein2.0.6indirect
npmfastq1.20.1indirect
npmfdir6.5.0indirect
npmfile-entry-cache8.0.0indirect
npmfill-range7.1.1indirect
npmfind-up5.0.0indirect
npmfind-up8.0.0indirect
npmflat-cache4.0.1indirect
npmflatted3.4.4indirect
npmget-east-asian-width1.6.0indirect
npmget-tsconfig4.14.1indirect
npmglob-parent5.1.2indirect
npmglob-parent6.0.2indirect
npmglobals15.15.0indirect
npmglobals17.11.0indirect
npmglobby16.2.2indirect
npmglobrex0.1.2indirect
npmgraceful-fs4.2.11indirect
npmhtmlparser210.1.0indirect
npmignore5.3.2indirect
npmignore7.0.6indirect
npmimurmurhash0.1.4indirect
npmis-alphabetical2.0.1indirect
npmis-alphanumerical2.0.1indirect
npmis-decimal2.0.1indirect
npmis-extglob2.1.1indirect
npmis-glob4.0.3indirect
npmis-hexadecimal2.0.1indirect
npmis-number7.0.0indirect
npmis-path-inside4.0.0indirect
npmisexe2.0.0indirect
npmjs-yaml5.2.2indirect
npmjson-buffer3.0.1indirect
npmjson-schema-traverse0.4.1indirect
npmjson-stable-stringify-without-jsonify1.0.1indirect
npmjsonc-parser3.3.1indirect
npmjsonpointer5.0.1indirect
npmkatex0.16.47indirect
npmkeyv4.5.4indirect
npmlevn0.4.1indirect
npmlinkify-it5.0.2indirect
npmlocate-path6.0.0indirect
npmlocate-path8.0.0indirect
npmmarkdown-it14.3.0indirect
npmmarkdownlint0.41.1indirect
npmmarkdownlint-cli20.23.2indirect
npmmarkdownlint-cli2-formatter-default0.0.6indirect
npmmdurl2.1.0indirect
npmmerge21.4.1indirect
npmmicromark4.0.2indirect
npmmicromark-core-commonmark2.0.3indirect
npmmicromark-extension-directive4.0.0indirect
npmmicromark-extension-gfm-autolink-literal2.1.0indirect
npmmicromark-extension-gfm-footnote2.1.0indirect
npmmicromark-extension-gfm-table2.1.1indirect
npmmicromark-extension-math3.1.0indirect
npmmicromark-factory-destination2.0.1indirect
npmmicromark-factory-label2.0.1indirect
npmmicromark-factory-space2.0.1indirect
npmmicromark-factory-title2.0.1indirect
npmmicromark-factory-whitespace2.0.1indirect
npmmicromark-util-character2.1.1indirect
npmmicromark-util-chunked2.0.1indirect
npmmicromark-util-classify-character2.0.1indirect
npmmicromark-util-combine-extensions2.0.1indirect
npmmicromark-util-decode-numeric-character-reference2.0.2indirect
npmmicromark-util-encode2.0.1indirect
npmmicromark-util-html-tag-name2.0.1indirect
npmmicromark-util-normalize-identifier2.0.1indirect
npmmicromark-util-resolve-all2.0.1indirect
npmmicromark-util-sanitize-uri2.0.1indirect
npmmicromark-util-subtokenize2.1.0indirect
npmmicromark-util-symbol2.0.1indirect
npmmicromark-util-types2.0.2indirect
npmmicromatch4.0.8indirect
npmminimatch10.2.6indirect
npmms2.1.3indirect
npmnatural-compare1.4.0indirect
npmneostandard0.14.0-next.1indirect
npmoptionator0.9.4indirect
npmp-limit3.1.0indirect
npmp-limit4.0.0indirect
npmp-locate5.0.0indirect
npmp-locate6.0.0indirect
npmparse-entities4.0.2indirect
npmpath-exists4.0.0indirect
npmpath-key3.1.1indirect
npmpeowly2.0.1indirect
npmpg-cloudflare1.4.0indirect
npmpg-connection-string2.14.0indirect
npmpg-int81.0.1indirect
npmpg-pool3.14.0indirect
npmpg-protocol1.16.0indirect
npmpg-types2.2.0indirect
npmpgpass1.0.5indirect
npmpicomatch2.3.2indirect
npmpicomatch4.0.5indirect
npmpostgres-array2.0.0indirect
npmpostgres-bytea1.0.1indirect
npmpostgres-date1.0.7indirect
npmpostgres-interval1.2.0indirect
npmprelude-ls1.2.1indirect
npmpunycode2.3.1indirect
npmpunycode.js2.3.1indirect
npmqueue-microtask1.2.3indirect
npmresolve-pkg-maps1.0.0indirect
npmreusify1.1.0indirect
npmrun-parallel1.2.0indirect
npmsemver7.8.5indirect
npmshebang-command2.0.0indirect
npmshebang-regex3.0.0indirect
npmslash5.1.0indirect
npmsmol-toml1.7.0indirect
npmsplit24.2.0indirect
npmstring-width8.2.1indirect
npmstrip-ansi7.2.0indirect
npmtapable2.3.3indirect
npmtinyglobby0.2.17indirect
npmto-regex-range5.0.1indirect
npmts-api-utils2.5.0indirect
npmtype-check0.4.0indirect
npmtypescript6.0.3indirect
npmtypescript-eslint8.66.0indirect
npmuc.micro2.1.0indirect
npmunicorn-magic0.3.0indirect
npmunicorn-magic0.4.0indirect
npmuri-js4.4.1indirect
npmwhich2.0.2indirect
npmword-wrap1.2.5indirect
npmxtend4.0.2indirect
npmyocto-queue0.1.0indirect
npmyocto-queue1.2.2indirect
Dependency advisories 0

Installing npm:node-red-contrib-postgresql@0.16.2 pulls in 16 packages, direct and transitive: 0 carry known advisories, of which 0 are direct dependencies.

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