Public record
Software health reportschema 0.27.0 · metrics 2.5.0 · 2026-07-29 04:32 UTC

constructive-io / libpg-query-node

🐘 libpg_query PG port for node.js

TypeScript · JavaScriptMIT★ 77 stars⑂ 32 forkssince Jul 2020View on GitHub ↗

constructive-io/libpg-query-node holds a health index of 60 out of 100, placing it in the Moderate band. It scores highest on Engineering Quality (61/100) and lowest on Community & Adoption (51/100). It was last updated 7 days ago. A single contributor accounts for most of its recent work.

60
overall / 100
Moderate

Software health index

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

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

Ownership

ConstructiveOrganization
10 followers71 public repossince Nov 2025

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publishTags
npm@pgsql/parser1.5.08,0921768 days agopostgresqlparsersqlastmulti-version

Metrics by category

Vitality

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

57Moderate · 21% of overall
How it's scored
36/36Push recency — last push 7 days ago
4.8/36Commit cadence — 7/52 weeks with commits
17.6/18Commit volume — 91 commits in the last year
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year91
human_commit_share1
days_since_last_push7
active_weeks_last_year7
How it's scored
16.2/27Ships releases — 1 version tags (no GitHub releases)
7.2/36Release recency — latest release 399 days ago
12.6/27Release cadence — cadence unknown (single release)
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count1
latest_release_tagv0.0.1
releases_from_tagsyes
days_since_latest_release399
mean_days_between_releases
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?

51Moderate · 17% of overall
How it's scored
30.5/60Stars — 77 stars
12.4/25Forks — 32 forks
0/15Watchers — 2 watchers
Inputs used
forks32
stars77
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_badges
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_services
has_pull_request_templateno
How it's scored
52.1/80Monthly downloads — 8,092 downloads/month across npm
0/20Registry dependents — not reported by this ecosystem
Inputs used
packages@pgsql/parser
dependents
ecosystemsnpm
total_downloads
monthly_downloads8,092
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?

59Moderate · 23% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
3.1/22.5Commit distribution — top contributor authored 86% of commits
13.5/13.5Contributor breadth — 14 contributors
10/10OpenSSF Scorecard: Contributors — project has 7 contributing companies or organizations
Inputs used
bus_factor1
contributors_sampled14
top_contributor_share0.861
How it's scored
34.8/42Issue resolution — 83% of issues closed
17.3/30PR acceptance — 67/116 decided PRs merged
0/13Newcomer PR acceptance — no first-time contributor's PR decided in 30d
0/15OpenSSF Scorecard: Code-Review — Found 0/15 approved changesets -- score normalized to 0
Inputs used
merged_prs67
open_issues7
closed_issues34
prs_merged_7d
prs_decided_7d
prs_merged_30d
prs_decided_30d
issue_closed_ratio0.829
closed_unmerged_prs49
first_time_authors_30d
first_time_prs_merged_30d
first_time_prs_decided_30d
Excluded from scoring (no data or not applicable): newcomer_pr_acceptance. Remaining weights renormalized.
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
7.5/25Owner reach — 10 followers of constructive-io
14.4/25Track record — 71 public repos, account ~0 yr old
Inputs used
followers10
owner_typeOrganization
is_verified
owner_loginconstructive-io
public_repos71
account_age_days251

Package maintenance

100Exceptional
How it's scored
25/25Published & resolvable — 1 package(s) on npm
35/35Publish recency — latest publish 68 days ago
20/20Version history — 17 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packages@pgsql/parser
ecosystemsnpm
any_deprecatedno
min_days_since_publish68

Engineering Quality

Are baseline engineering and documentation practices in place?

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

Documentation

50Moderate
How it's scored
30/30README
0/25Documentation directory
0/15Documentation / homepage site
10/10Repository description
0/10Topics
10/10Wiki
Inputs used
topics
has_wikiyes
homepage
has_readmeyes
has_docs_dirno
has_descriptionyes

Security

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

54Moderate · 16% of overall
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — branch protection not enabled on development/release branches
2.5/2.5CI-Tests — 7 out of 7 merged PRs checked by a CI test -- score normalized to 10
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 0/15 approved changesets -- score normalized to 0
2.5/2.5Contributors — project has 7 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
7.5/7.5Maintained — 30 commit(s) and 1 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
0/7.5Vulnerabilities — 10 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated16
scorecard_versionv5.5.0
checks_inconclusive2
scorecard_aggregate4.3
Excluded from scoring (no data or not applicable): 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
advisories20
affected_packages10
assessed_packages143
unassessed_packages9
affected_by_severityhigh 8, moderate 2
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 143 resolved dependencies against OSV. 9 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.

57Moderate · 4% of overall
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
39.5/40Legible commit history — 74 of 100 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
legible_history_share0.74
agent_instruction_files
agent_instruction_max_bytes
How it's scored
18/18One-command bootstrap — versions/13/Makefile, versions/14/Makefile, versions/15/Makefile, versions/16/Makefile, versions/17/Makefile, versions/18/Makefile
22/22Automated tests
0/11Lint / format config
11/11Static type checking — enums/13/tsconfig.json, enums/14/tsconfig.json, enums/15/tsconfig.json, enums/16/tsconfig.json, enums/17/tsconfig.json, enums/18/tsconfig.json, tsconfig.json, types/13/tsconfig.json, types/14/tsconfig.json, types/15/tsconfig.json, types/16/tsconfig.json, types/17/tsconfig.json, types/18/tsconfig.json, versions/13/tsconfig.json, versions/14/tsconfig.json, versions/15/tsconfig.json, versions/16/tsconfig.json, versions/17/tsconfig.json, versions/18/tsconfig.json
10/10Reproducible environment — lockfile
0/10Demonstrated agent practice — no agent-authored commits among the last 100
0/8Automated maintenance — no automated dependency updates observed
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfilespnpm-lock.yaml
has_dockerfileno
typed_languageyes
bootstrap_filesversions/13/Makefile, versions/14/Makefile, versions/15/Makefile, versions/16/Makefile, versions/17/Makefile, versions/18/Makefile
has_devcontainerno
has_linter_configno
typecheck_configsenums/13/tsconfig.json, enums/14/tsconfig.json, enums/15/tsconfig.json, enums/16/tsconfig.json, enums/17/tsconfig.json, enums/18/tsconfig.json, tsconfig.json, types/13/tsconfig.json, types/14/tsconfig.json, types/15/tsconfig.json, types/16/tsconfig.json, types/17/tsconfig.json, types/18/tsconfig.json, versions/13/tsconfig.json, versions/14/tsconfig.json, versions/15/tsconfig.json, versions/16/tsconfig.json, versions/17/tsconfig.json, versions/18/tsconfig.json
agent_commit_share0
toolchain_manifests
dependency_bot_commit_share0
How it's scored
45/45Type-checkable code — TypeScript (statically typed)
55/55Manageable file sizes — 0/110 source files over 60KB
Inputs used
primary_languageTypeScript
largest_source_bytes54,314
source_files_sampled110
oversized_source_files0
How it's scored
40/40API schema (OpenAPI/GraphQL/proto) — protos/13/pg_query.proto, protos/14/pg_query.proto, protos/15/pg_query.proto, protos/16/pg_query.proto, protos/17/pg_query.proto, protos/18/pg_query.proto
0/20MCP server
0/40Runnable examples
Inputs used
example_dirs
has_mcp_signalno
api_schema_filesprotos/13/pg_query.proto, protos/14/pg_query.proto, protos/15/pg_query.proto, protos/16/pg_query.proto, protos/17/pg_query.proto, protos/18/pg_query.proto

Key facts

77GitHub stars
14contributors
91commits, last 12 months
7days since last push
1releases
1bus factor
7open 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 ★ / 32 ⇿
0Stars
32Forks
1Releases

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.

0510152025302722020-072023-062026-06
Major 0Minor 0Patch 1

Each point covers 6 days.

OpenSSF Scorecard 4.3 / 10
4.3aggregate

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-29 04:32 UTC

10Binary-Artifactsno binaries found in the repo
0Branch-Protectionbranch protection not enabled on development/release branches
10CI-Tests7 out of 7 merged PRs checked by a CI test -- score normalized to 10
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/15 approved changesets -- score normalized to 0
10Contributorsproject has 7 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
10Maintained30 commit(s) and 1 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
0Vulnerabilities10 existing vulnerabilities detected
All dependencies 152

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

RegistryPackageVersionRelation
npm@babel/code-frame7.27.1indirect
npm@babel/generator7.27.5indirect
npm@babel/helper-environment-visitor7.24.7indirect
npm@babel/helper-function-name7.24.7indirect
npm@babel/helper-hoist-variables7.24.7indirect
npm@babel/helper-split-export-declaration7.24.7indirect
npm@babel/helper-string-parser7.27.1indirect
npm@babel/helper-validator-identifier7.27.1indirect
npm@babel/parser7.27.5indirect
npm@babel/template7.27.2indirect
npm@babel/traverse7.24.1indirect
npm@babel/types7.24.0indirect
npm@babel/types7.27.6indirect
npm@cspotcode/source-map-support0.8.1indirect
npm@isaacs/balanced-match4.0.1indirect
npm@isaacs/brace-expansion5.0.0indirect
npm@isaacs/cliui8.0.2indirect
npm@jridgewell/gen-mapping0.3.8indirect
npm@jridgewell/resolve-uri3.1.2indirect
npm@jridgewell/set-array1.2.1indirect
npm@jridgewell/sourcemap-codec1.5.0indirect
npm@jridgewell/trace-mapping0.3.25indirect
npm@jridgewell/trace-mapping0.3.9indirect
npm@launchql/protobufjs7.2.6indirect
npm@pgsql/types13.11.2indirect
npm@pgsql/types14.1.2indirect
npm@pgsql/types15.1.2indirect
npm@pgsql/types16.1.2indirect
npm@pgsql/types17.6.2indirect
npm@pgsql/types18.0.0indirect
npm@pgsql/types^13.11.2indirect
npm@pgsql/types^14.1.2indirect
npm@pgsql/types^15.1.2indirect
npm@pgsql/types^16.1.2indirect
npm@pgsql/types^17.6.2indirect
npm@pgsql/types^18.0.0indirect
npm@pkgjs/parseargs0.11.0indirect
npm@protobufjs/aspromise1.1.2indirect
npm@protobufjs/base641.1.2indirect
npm@protobufjs/codegen2.0.4indirect
npm@protobufjs/eventemitter1.1.0indirect
npm@protobufjs/fetch1.1.0indirect
npm@protobufjs/float1.0.2indirect
npm@protobufjs/inquire1.1.0indirect
npm@protobufjs/path1.1.2indirect
npm@protobufjs/pool1.1.0indirect
npm@protobufjs/utf81.1.0indirect
npm@tsconfig/node101.0.11indirect
npm@tsconfig/node121.0.11indirect
npm@tsconfig/node141.0.3indirect
npm@tsconfig/node161.0.4indirect
npm@types/node20.19.1indirect
npmacorn8.15.0indirect
npmacorn-walk8.3.4indirect
npmansi-regex5.0.1indirect
npmansi-regex6.1.0indirect
npmansi-styles4.3.0indirect
npmansi-styles6.2.1indirect
npmarg4.1.3indirect
npmbalanced-match1.0.2indirect
npmbrace-expansion1.1.12indirect
npmbrace-expansion2.0.2indirect
npmcase1.6.3indirect
npmcliui7.0.4indirect
npmcolor-convert2.0.1indirect
npmcolor-name1.1.4indirect
npmconcat-map0.0.1indirect
npmcopyfiles2.4.1indirect
npmcore-util-is1.0.3indirect
npmcreate-require1.1.1indirect
npmcross-env7.0.3indirect
npmcross-env^7.0.3indirect
npmcross-spawn7.0.6indirect
npmdebug4.4.1indirect
npmdeepmerge4.3.1indirect
npmdiff4.0.2indirect
npmeastasianwidth0.2.0indirect
npmemoji-regex8.0.0indirect
npmemoji-regex9.2.2indirect
npmescalade3.2.0indirect
npmforeground-child3.3.1indirect
npmfs.realpath1.0.0indirect
npmget-caller-file2.0.5indirect
npmglob10.4.5indirect
npmglob11.0.3indirect
npmglob7.2.3indirect
npmglobals11.12.0indirect
npminflight1.0.6indirect
npminherits2.0.4indirect
npmis-fullwidth-code-point3.0.0indirect
npmisarray0.0.1indirect
npmisarray1.0.0indirect
npmisexe2.0.0indirect
npmjackspeak3.4.3indirect
npmjackspeak4.1.1indirect
npmjs-tokens4.0.0indirect
npmjsesc3.1.0indirect
npmlong5.3.2indirect
npmlru-cache10.4.3indirect
npmlru-cache11.1.0indirect
npmmake-error1.3.6indirect
npmminimatch10.0.3indirect
npmminimatch3.1.2indirect
npmminimatch9.0.5indirect
npmminipass7.1.2indirect
npmmkdirp1.0.4indirect
npmms2.1.3indirect
npmnested-obj0.0.1indirect
npmnoms0.0.0indirect
npmonce1.4.0indirect
npmpackage-json-from-dist1.0.1indirect
npmpath-is-absolute1.0.1indirect
npmpath-key3.1.1indirect
npmpath-scurry1.11.1indirect
npmpath-scurry2.0.0indirect
npmpg-proto-parser1.28.2indirect
npmpg-proto-parser^1.28.2indirect
npmpicocolors1.1.1indirect
npmprocess-nextick-args2.0.1indirect
npmreadable-stream1.0.34indirect
npmreadable-stream2.3.8indirect
npmrequire-directory2.1.1indirect
npmrimraf5.0.10indirect
npmrimraf^5.0.0indirect
npmsafe-buffer5.1.2indirect
npmshebang-command2.0.0indirect
npmshebang-regex3.0.0indirect
npmsignal-exit4.1.0indirect
npmstrfy-js3.0.1indirect
npmstring-width4.2.3indirect
npmstring-width5.1.2indirect
npmstring_decoder0.10.31indirect
npmstring_decoder1.1.1indirect
npmstrip-ansi6.0.1indirect
npmstrip-ansi7.1.0indirect
npmthrough22.0.5indirect
npmto-fast-properties2.0.0indirect
npmts-node10.9.2indirect
npmtypescript5.8.3indirect
npmundici-types6.21.0indirect
npmuntildify4.0.0indirect
npmutil-deprecate1.0.2indirect
npmv8-compile-cache-lib3.0.1indirect
npmwhich2.0.2indirect
npmwrap-ansi7.0.0indirect
npmwrap-ansi8.1.0indirect
npmwrappy1.0.2indirect
npmxtend4.0.2indirect
npmy18n5.0.8indirect
npmyargs16.2.0indirect
npmyargs-parser20.2.9indirect
npmyn3.1.1indirect
Dependency advisories 10

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

PackageVersionRelationSeverityAdvisoriesFixed in
@isaacs/brace-expansion5.0.0indirecthigh15.0.1
brace-expansion1.1.12indirecthigh35.0.8
brace-expansion2.0.2indirecthigh35.0.8
glob10.4.5indirecthigh111.1.0
glob11.0.3indirecthigh111.1.0
minimatch10.0.3indirecthigh310.2.3
minimatch3.1.2indirecthigh310.2.3
minimatch9.0.5indirecthigh310.2.3
@protobufjs/utf81.1.0indirectmoderate18.0.2
diff4.0.2indirectmoderate18.0.3

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

Raw JSON report machine-readable

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

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