Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-09-13 07:03 UTC

Query-farm / vgi-python

Python SDK for the VGI (Vector Gateway Interface) protocol — host DuckDB scalar, table, aggregate, and table-in-out functions in an external worker over Arrow IPC.

PythonCustom license★ 4 stars⑂ 0 forkssince Dec 2025View on GitHub ↗
KindCommand-line toolLibraryhow this is determined
#apache-arrow#arrow#data-engineering#database#duckdb#pyarrow#python#udf#user-defined-functions#vgi#aggregate-functions#arrow-ipc#query-engine#scalar-functions#sdk#table-functions

Query-farm/vgi-python holds a health index of 75 out of 100, placing it in the Good band. It scores highest on Vitality (93/100) and lowest on Community & Adoption (33/100). It was last updated 1 day ago. A single contributor accounts for most of its recent work.

75
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.

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

Ownership

Query.FarmOrganization
118 followers222 public repossince Sep 2024

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publishTags
PyPIvgi-python0.32.03,130481 day agoanalyticsapache-arrowarrowdata-engineeringdatabaseduckdbpyarrowrpcsqludfuser-defined-functionsvgi

Metrics by category

Vitality

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

93Exceptional · 21% of overall

Development activity

88Excellent
How it's scored
36/36Push recency — last push 1 days ago
23.5/36Commit cadence — 34/52 weeks with commits
18/18Commit volume — 907 commits in the last year
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year907
human_commit_share1
days_since_last_push1
active_weeks_last_year34

Release discipline

100Exceptional
How it's scored
27/27Ships releases — 48 releases published
36/36Release recency — latest release 1 days ago
27/27Release cadence — a release every ~1.7 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count48
latest_release_tagv0.32.0
releases_from_tagsno
days_since_latest_release1
mean_days_between_releases1.7
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

Popularity & adoption

8Critical
How it's scored
7.7/60Stars — 4 stars
0/25Forks — 0 forks
0/15Watchers — 0 watchers
Inputs used
forks0
stars4
watchers0
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

44Weak
How it's scored
22.5/22.5README
16.9/22.5License — license file present, not a recognized license
0/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges4
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_servicesgithub.com, shields.io
has_pull_request_templateno

Ecosystem adoption (downloads)

58Moderate
How it's scored
46.6/80Monthly downloads — 3,130 downloads/month across pypi
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagesvgi-python
dependents—
ecosystemspypi
total_downloads—
monthly_downloads3,130
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?

45Weak · 23% of overall

Maintainer resilience (bus factor)

13Critical
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
3/10OpenSSF Scorecard: Contributors — project has 1 contributing companies or organizations -- score normalized to 3
Inputs used
bus_factor1
contributors_sampled1
top_contributor_share1

Issue & PR responsiveness

21At Risk
How it's scored
0/42Issue resolution — 0% of issues closed
18.7/30PR acceptance — 43/69 decided PRs merged
0/13Newcomer PR acceptance — no first-time contributor's PR decided in 30d
0/15OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0
Inputs used
merged_prs43
open_issues4
closed_issues0
prs_merged_7d4
prs_decided_7d4
prs_merged_30d4
prs_decided_30d4
issue_closed_ratio0
closed_unmerged_prs26
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.

Ownership & stewardship

62Moderate
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
14.9/25Owner reach — 118 followers of Query-farm
16.9/25Track record — 222 public repos, account ~1 yr old
Inputs used
followers118
owner_typeOrganization
is_verifiedno
owner_loginQuery-farm
public_repos222
account_age_days712

Package maintenance

100Exceptional
How it's scored
25/25Published & resolvable — 1 package(s) on pypi
35/35Publish recency — latest publish 1 days ago
20/20Version history — 48 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagesvgi-python
ecosystemspypi
any_deprecatedno
min_days_since_publish1

Engineering Quality

Are baseline engineering and documentation practices in place?

80Excellent · 19% of overall

Engineering practices

74Good
How it's scored
24/24CI workflows — 5 workflow(s)
24/24Tests present
16/16Linter config — pyproject.toml ([tool.ruff])
0/9.6Pre-commit hooks
0/6.4.editorconfig
10/20OpenSSF Scorecard: CI-Tests — 2 out of 4 merged PRs checked by a CI test -- score normalized to 5
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configyes
has_precommit_configno

Documentation

90Excellent
How it's scored
30/30README
25/25Documentation directory
15/15Documentation / homepage site — https://query.farm
10/10Repository description
10/10Topics — 16 topics
0/10Wiki
Inputs used
topicsapache-arrow, arrow, data-engineering, database, duckdb, pyarrow, python, udf, user-defined-functions, vgi, aggregate-functions, arrow-ipc, query-engine, scalar-functions, sdk, table-functions
has_wikino
homepagehttps://query.farm
docs_sitehttps://query.farm
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

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

68Good · 16% of overall

Security posture

60Moderate
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
1.2/2.5CI-Tests — 2 out of 4 merged PRs checked by a CI test -- score normalized to 5
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 0/30 approved changesets -- score normalized to 0
0.8/2.5Contributors — project has 1 contributing companies or organizations -- score normalized to 3
10/10Dangerous-Workflow — no dangerous workflow patterns detected
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.2/2.5License — license file detected
7.5/7.5Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
5/5Packaging — packaging workflow detected
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
4.5/5Security-Policy — security policy file detected
0/7.5Signed-Releases — no data
7.5/7.5Token-Permissions — GitHub workflow tokens follow principle of least privilege
5.2/7.5Vulnerabilities — 3 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate6.1
Excluded from scoring (no data or not applicable): 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
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_packages19
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 pypi:vgi-python@0.32.0 runtime dependency closure — what installing the published package pulls in — 19 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.

85Excellent · 4% of overall

Agent context & guidance

100Exceptional
How it's scored
45/45Agent instructions — CLAUDE.md
15/15Machine-readable docs (llms.txt) — llms.txt served by the project website (https://query.farm/llms.txt)
40/40Legible commit history — 95 of 100 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtyes
llms_txt_urlhttps://query.farm/llms.txt
legible_history_share0.95
agent_instruction_filesCLAUDE.md
agent_instruction_max_bytes31,968

Verify loop (build / test / typecheck)

69Good
How it's scored
0/18One-command bootstrap
22/22Automated tests
11/11Lint / format config — pyproject.toml ([tool.ruff])
11/11Static type checking — vgi/py.typed
10/10Reproducible environment — Dockerfile, lockfile
10/10Demonstrated agent practice — 46 of the last 100 commits agent-authored or agent-credited
5/8Automated maintenance — dependency automation configured, none observed in the sampled commits
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfilesuv.lock
has_dockerfileyes
typed_languageno
bootstrap_files—
has_devcontainerno
has_linter_configyes
typecheck_configsvgi/py.typed
agent_commit_share0.46
toolchain_manifests—
dependency_bot_commit_share0

Code legibility for models

80Excellent
How it's scored
27/45Type-checkable code — Python with type-check config (vgi/py.typed)
52.7/55Manageable file sizes — 15/364 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes570,322
source_files_sampled364
oversized_source_files15

Machine-readable interfaces

100Exceptional
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

4GitHub stars
1contributors
907commits, last 12 months
1days since last push
48releases
1bus factor
4open issues
PyPIpackage ecosystems

Data collection warnings

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

More detail

OpenSSF Scorecard 6.1 / 10
6.1aggregate

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-13 07:03 UTC

10Binary-Artifactsno binaries found in the repo
0Branch-Protectionbranch protection not enabled on development/release branches
5CI-Tests2 out of 4 merged PRs checked by a CI test -- score normalized to 5
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/30 approved changesets -- score normalized to 0
3Contributorsproject has 1 contributing companies or organizations -- score normalized to 3
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
9Licenselicense file detected
10Maintained30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
10Packagingpackaging workflow detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
0SASTSAST tool is not run on all commits -- score normalized to 0
9Security-Policysecurity policy file detected
n/aSigned-Releasesno releases found
10Token-PermissionsGitHub workflow tokens follow principle of least privilege
7Vulnerabilities3 existing vulnerabilities detected
Direct dependencies 6
RegistryPackageVersion constraintManifest
PyPIclick—pyproject.toml
PyPIpyarrow—pyproject.toml
PyPItyper>=0.9pyproject.toml
PyPIplatformdirs—pyproject.toml
PyPIvgi-rpc>=0.45.1pyproject.toml
PyPIhttpx2>=2.9.1pyproject.toml
All dependencies 122

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

RegistryPackageVersionRelation
PyPIclick8.4.2direct
PyPIhttpx22.10.0direct
PyPIplatformdirs4.11.2direct
PyPIpyarrow25.0.1direct
PyPItyper0.27.1direct
PyPIvgi-rpc0.45.1direct
PyPIaiohappyeyeballs2.7.1indirect
PyPIaiohttp3.14.3indirect
PyPIaiosignal1.4.0indirect
PyPIannotated-doc0.0.5indirect
PyPIannotated-types0.8.0indirect
PyPIanyio4.14.2indirect
PyPIast-serialize0.8.0indirect
PyPIattrs26.1.0indirect
PyPIazure-core1.41.0indirect
PyPIazure-identity1.25.3indirect
PyPIbabel2.18.0indirect
PyPIbackrefs8.0indirect
PyPIblack26.5.1indirect
PyPIcertifi2026.7.22indirect
PyPIcffi2.1.1indirect
PyPIcharset-normalizer3.5.0indirect
PyPIcolorama0.4.6indirect
PyPIcoverage7.15.4indirect
PyPIcryptography50.0.0indirect
PyPIdocstring-parser0.18.0indirect
PyPIduckdb1.5.5indirect
PyPIexecnet2.1.2indirect
PyPIfalcon4.3.1indirect
PyPIfilelock3.32.4indirect
PyPIfrozenlist1.8.0indirect
PyPIghp-import2.1.0indirect
PyPIgranian2.8.1indirect
PyPIgriffelib2.1.0indirect
PyPIh110.16.0indirect
PyPIhatchling—indirect
PyPIhaybarn1.5.5rc1indirect
PyPIhttpcore22.10.0indirect
PyPIhttpx2-jsfetch1.0indirect
PyPIidna3.18indirect
PyPIiniconfig2.3.0indirect
PyPIiroh1.1.0indirect
PyPIjinja23.1.6indirect
PyPIjoserfc1.7.4indirect
PyPIjsonschema4.26.0indirect
PyPIjsonschema-specifications2025.9.1indirect
PyPIlibrt0.15.0indirect
PyPIlxml6.1.1indirect
PyPImarkdown3.10.3indirect
PyPImarkdown-it-py4.2.0indirect
PyPImarkupsafe3.0.3indirect
PyPImdurl0.1.2indirect
PyPImergedeep1.3.4indirect
PyPImkdocs1.6.1indirect
PyPImkdocs-autorefs1.4.4indirect
PyPImkdocs-d2-plugin1.7.0indirect
PyPImkdocs-get-deps0.2.2indirect
PyPImkdocs-material9.7.7indirect
PyPImkdocs-material-extensions1.3.1indirect
PyPImkdocs-section-index0.3.12indirect
PyPImkdocstrings1.0.6indirect
PyPImkdocstrings-python2.0.5indirect
PyPImsal1.37.0indirect
PyPImsal-extensions1.3.1indirect
PyPImsgpack1.2.1indirect
PyPImultidict6.7.1indirect
PyPImypy2.3.0indirect
PyPImypy-extensions1.1.0indirect
PyPInumpy2.5.2indirect
PyPIopentelemetry-api1.44.0indirect
PyPIopentelemetry-sdk1.44.0indirect
PyPIopentelemetry-semantic-conventions0.65b0indirect
PyPIpackaging26.3indirect
PyPIpaginate0.5.7indirect
PyPIpathspec1.1.1indirect
PyPIpluggy1.6.0indirect
PyPIpropcache0.5.2indirect
PyPIproperdocs1.6.7indirect
PyPIpsutil7.2.2indirect
PyPIpyarrow-stubs20.0.0.20260625indirect
PyPIpycparser3.0indirect
PyPIpycryptodome3.23.0indirect
PyPIpydantic2.13.4indirect
PyPIpydantic-core2.46.4indirect
PyPIpygments2.20.0indirect
PyPIpyjwt2.13.0indirect
PyPIpymdown-extensions11.0.1indirect
PyPIpymssql2.3.13indirect
PyPIpynacl1.6.2indirect
PyPIpytest9.1.1indirect
PyPIpytest-cov7.1.0indirect
PyPIpytest-examples0.0.18indirect
PyPIpytest-ruff0.5indirect
PyPIpytest-timeout2.4.0indirect
PyPIpytest-xdist3.8.0indirect
PyPIpython-dateutil2.9.0.post0indirect
PyPIpytokens0.4.1indirect
PyPIpywin32312indirect
PyPIpyyaml6.0.3indirect
PyPIpyyaml-env-tag1.1indirect
PyPIreferencing0.37.0indirect
PyPIrequests2.34.2indirect
PyPIrich15.0.0indirect
PyPIrpds-py2026.6.3indirect
PyPIruff0.16.2indirect
PyPIsentry-sdk2.67.1indirect
PyPIshellingham1.5.4indirect
PyPIsix1.17.0indirect
PyPIsqlglot30.16.0indirect
PyPItenacity9.1.4indirect
PyPItruststore0.10.4indirect
PyPItyping-extensions4.16.0indirect
PyPItyping-inspection0.4.4indirect
PyPItzdata2026.3indirect
PyPIurllib32.7.0indirect
PyPIvgi-fixtures0.8.2indirect
PyPIvgi-python—indirect
PyPIvgi-python0.32.0indirect
PyPIwaitress3.0.2indirect
PyPIwatchdog6.0.0indirect
PyPIyarl1.24.5indirect
PyPIzstandard0.25.0indirect
Dependency advisories 0

Installing pypi:vgi-python@0.32.0 pulls in 19 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.

Related records

Inspected repositories sharing catalogue tags or ecosystems with Query-farm/vgi-python. Read them side by side →

99apache/datafusionApache DataFusion SQL Query EngineExceptional99apache/supersetApache Superset is a Data Visualization and Data Exploration PlatformExceptional98trinodb/trinoOfficial repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)Exceptional98dagster-io/dagsterAn orchestration platform for the development, production, and observation of data assets.Exceptional98Eventual-Inc/DaftHigh-performance data engine for AI and multimodal workloads. Process images, audio, video, and structured data at any scaleExceptional100risingwavelabs/risingwaveEvent streaming platform for agentic AI. Continuously ingest, transform, and serve event streams in real time, at scale.Exceptional

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