Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-09-11 17:46 UTC

JAAQL / JAAQL-middleware-python

The JAAQL (Javascript as a query language) middleware. A out the box wrapper for databases providing user management, logging and a neat docker container which allows you to deploy a performant application with minimal configuration or know-how

Python · PLpgSQLCustom license★ 2 stars⑂ 0 forkssince Oct 2021View on GitHub ↗
KindLibraryhow this is determined
#postgres#gunicorn#python#nginx#docker#lightweight#server

JAAQL/JAAQL-middleware-python holds a health index of 39 out of 100, placing it in the Weak band. It scores highest on Vitality (63/100) and lowest on Engineering Quality (25/100). It was last updated 2 days ago. A single contributor accounts for most of its recent work.

39
overall / 100
Weak

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.

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

Ownership

JAAQLOrganization
1 follower5 public repossince Aug 2020

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publish
PyPIjaaql-middleware-python5.3.151,95641249 days ago

Metrics by category

Vitality

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

63Moderate · 21% of overall

Development activity

76Good
How it's scored
36/36Push recency — last push 2 days ago
14.5/36Commit cadence — 21/52 weeks with commits
15.9/18Commit volume — 58 commits in the last year
10/10OpenSSF Scorecard: Maintained — 23 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year58
human_commit_share1
days_since_last_push2
active_weeks_last_year21

Release discipline

44Weak
How it's scored
27/27Ships releases — 1 releases published
0/36Release recency — latest release 1,640 days ago
12.6/27Release cadence — cadence unknown (single release)
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count1
latest_release_tag2.1.5
releases_from_tagsno
days_since_latest_release1,640
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?

37Weak · 17% of overall

Popularity & adoption

1Critical
How it's scored
0/60Stars — 2 stars
0/25Forks — 0 forks
0/15Watchers — 1 watchers
Inputs used
forks0
stars2
watchers1
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

64Moderate
How it's scored
22.5/22.5README
16.9/22.5License — license file present, not a recognized license
18/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges0
has_contributingyes
has_issue_templateno
has_code_of_conductno
readme_badge_services—
has_pull_request_templateno

Ecosystem adoption (downloads)

55Moderate
How it's scored
43.9/80Monthly downloads — 1,956 downloads/month across pypi
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagesjaaql-middleware-python
dependents—
ecosystemspypi
total_downloads—
monthly_downloads1,956
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?

52Moderate · 23% of overall

Maintainer resilience (bus factor)

10Critical
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

Issue & PR responsiveness

67Good
How it's scored
0/42Issue resolution — no issues or no data
30/30PR acceptance — 23/23 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_prs23
open_issues0
closed_issues0
prs_merged_7d0
prs_decided_7d0
prs_merged_30d0
prs_decided_30d0
issue_closed_ratio—
closed_unmerged_prs0
first_time_authors_30d0
first_time_prs_merged_30d0
first_time_prs_decided_30d0
Excluded from scoring (no data or not applicable): Issue resolution, Newcomer PR acceptance. Remaining weights renormalized.

Ownership & stewardship

50Moderate
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
2.2/25Owner reach — 1 followers of JAAQL
17.7/25Track record — 5 public repos, account ~6 yr old
Inputs used
followers1
owner_typeOrganization
is_verifiedno
owner_loginJAAQL
public_repos5
account_age_days2,204

Package maintenance

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

Engineering Quality

Are baseline engineering and documentation practices in place?

25At Risk · 19% of overall

Engineering practices

1Critical
How it's scored
0/24CI workflows
0/24Tests present
0/16Linter config
0/9.6Pre-commit hooks
0/6.4.editorconfig
0/20OpenSSF Scorecard: CI-Tests — no data
Inputs used
has_cino
has_testsno
has_editorconfigno
has_linter_configno
has_precommit_configno
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: CI-Tests. Remaining weights renormalized.

Documentation

60Moderate
How it's scored
30/30README
0/25Documentation directory
0/15Documentation / homepage site
10/10Repository description
10/10Topics — 7 topics
10/10Wiki
Inputs used
topicspostgres, gunicorn, python, nginx, docker, lightweight, server
has_wikiyes
homepage—
docs_site—
has_readmeyes
has_docs_dirno
has_descriptionyes

Security

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

28At Risk · 16% of overall

Security posture

22At Risk
How it's scored
6/7.5Binary-Artifacts — binaries present in source code
0/7.5Branch-Protection — branch protection not enabled on development/release branches
0/2.5CI-Tests — no data
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/2.5Contributors — project has 0 contributing companies or organizations -- score normalized to 0
0/10Dangerous-Workflow — no data
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.2/2.5License — license file detected
7.5/7.5Maintained — 23 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
0/5SAST — no SAST tool detected
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — no data
0/7.5Token-Permissions — no data
0/7.5Vulnerabilities — 46 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated13
scorecard_versionv5.5.0
checks_inconclusive5
scorecard_aggregate2.2
Excluded from scoring (no data or not applicable): CI-Tests, Dangerous-Workflow, Packaging, Signed-Releases, Token-Permissions. Remaining weights renormalized.

Dependency advisories

51Moderate
How it's scored
5.5/35Direct dependencies free of known advisories — 5 affected: pillow 11.3.0 (critical 9.1), cryptography 44.0.3 (high 8.2), pyjwt 2.10.1 (high 7.5), +2 more
25/25Indirect dependencies free of known advisories — no indirect dependency carries a known advisory
20.6/40No advisories left outstanding — 5 advisory-carrying package(s) unaddressed past 90 days; oldest published 449 days ago
Inputs used
sourceosv
advisories73
affected_packages5
assessed_packages70
unassessed_packages0
affected_by_severitycritical 1, high 3, moderate 1
direct_affected_packages5
Matched the pypi:jaaql-middleware-python@5.3.15 runtime dependency closure — what installing the published package pulls in — 70 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.

45Weak · 4% of overall

Agent context & guidance

49Weak
How it's scored
45/45Agent instructions — claude.md
0/15Machine-readable docs (llms.txt)
4.3/40Legible commit history — 8 of 100 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
llms_txt_url—
legible_history_share0.08
agent_instruction_filesclaude.md
agent_instruction_max_bytes1,418

Verify loop (build / test / typecheck)

38Weak
How it's scored
18/18One-command bootstrap — pgextension/Makefile
0/22Automated tests
0/11Lint / format config
0/11Static type checking
10/10Reproducible environment — Dockerfile
10/10Demonstrated agent practice — 7 of the last 100 commits agent-authored or agent-credited
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_testsno
lockfiles—
has_dockerfileyes
typed_languageno
bootstrap_filespgextension/Makefile
has_devcontainerno
has_linter_configno
typecheck_configs—
agent_commit_share0.07
toolchain_manifests—
dependency_bot_commit_share0

Code legibility for models

53Moderate
How it's scored
0/45Type-checkable code — Python without a type-check config
53.3/55Manageable file sizes — 2/66 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes137,271
source_files_sampled66
oversized_source_files2

Key facts

2GitHub stars
1contributors
58commits, last 12 months
2days since last push
1releases
1bus factor
0open issues
PyPIpackage ecosystems

Data collection warnings

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

More detail

OpenSSF Scorecard 2.2 / 10
2.2aggregate

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-11 17:46 UTC

8Binary-Artifactsbinaries present in source code
0Branch-Protectionbranch protection not enabled on development/release branches
n/aCI-Testsno pull request found
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/30 approved changesets -- score normalized to 0
0Contributorsproject has 0 contributing companies or organizations -- score normalized to 0
n/aDangerous-Workflowno workflows found
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
9Licenselicense file detected
10Maintained23 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
0SASTno SAST tool detected
0Security-Policysecurity policy file not detected
n/aSigned-Releasesno releases found
n/aToken-PermissionsNo tokens found
0Vulnerabilities46 existing vulnerabilities detected
All dependencies 26

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

RegistryPackageVersionRelation
PyPIargon2-cffi23.1.0indirect
PyPIcertifi2025.1.31indirect
PyPIcoverage7.15.2indirect
PyPIcryptography44.0.2indirect
PyPIflask3.1.0indirect
PyPIgevent25.9.1indirect
PyPIgunicorn23.0.0indirect
PyPIidna3.10indirect
PyPIjaaql-monitor1.6.3indirect
PyPIjinja23.1.6indirect
PyPIjwcrypto1.5.6indirect
PyPIorjson3.11.9indirect
PyPIparsys-requests-unixsocket0.3.2indirect
PyPIpillow11.3.0indirect
PyPIpsycopg3.2.13indirect
PyPIpsycopg-pool3.2.1indirect
PyPIpyjwt2.10.1indirect
PyPIpyotp2.9.0indirect
PyPIpyyaml6.0.3indirect
PyPIpyzbar0.1.9indirect
PyPIqrcode7.4.2indirect
PyPIrequests2.32.3indirect
PyPIselenium4.29.0indirect
PyPItwine5.0.0indirect
PyPIurllib32.3.0indirect
PyPIwerkzeug3.1.3indirect
Dependency advisories 5

Installing pypi:jaaql-middleware-python@5.3.15 pulls in 70 packages, direct and transitive: 5 carry known advisories, of which 5 are direct dependencies.

PackageVersionRelationSeverityAdvisoriesFixed in
pillow11.3.0directcritical3612.3.0
cryptography44.0.3directhigh1050.0.0
pyjwt2.10.1directhigh132.13.0
urllib32.3.0directhigh122.7.0
requests2.32.5directmoderate22.33.0

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 JAAQL/JAAQL-middleware-python. Read them side by side →

100aws/aws-sam-cliCLI tool to build, test, debug, and deploy Serverless applications using AWS SAMExceptional99IBM/mcp-context-forgeAn AI Gateway, registry, and proxy that sits in front of any MCP, A2A, or REST/gRPC APIs, exposing a unified endpoint with centralized discovery, guardrails and management. Optimizes Agent & Tool calling, and supports plugins.Exceptional98supabase/supabase-pyPython Client for Supabase. Query Postgres from Flask, Django, FastAPI. Python user authentication, security policies, edge functions, file storage, and realtime data streaming. Good first issue.Exceptional98makeplane/plane🔥🔥🔥 Open-source Jira, Linear, Monday, and ClickUp alternative. Plane is a modern project management platform to manage tasks, sprints, docs, and triage.Exceptional100open-telemetry/opentelemetry-pythonOpenTelemetry Python API and SDK Exceptional100matplotlib/matplotlibmatplotlib: plotting with PythonExceptional

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.