Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-09-11 05:24 UTC

pyathena-dev / PyAthena

PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.

PythonMIT★ 492 stars⑂ 109 forkssince May 2017View on GitHub ↗
KindPluginLibraryhow this is determined
#python#dbapi#aws#athena#sqlalchemy

pyathena-dev/PyAthena holds a health index of 87 out of 100, placing it in the Excellent band. It scores highest on AI Readiness (96/100) and lowest on Sustainability & Governance (59/100). It was last updated 8 days ago. A single contributor accounts for most of its recent work.

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

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

Ownership

pyathena-devOrganization
0 followers3 public repossince Feb 2026

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publish
PyPIPyAthena3.36.018,422,8491838 days ago

Metrics by category

Vitality

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

82Excellent · 21% of overall

Development activity

76Good
How it's scored
28.8/36Push recency — last push 8 days ago
18.7/36Commit cadence — 27/52 weeks with commits
18/18Commit volume — 359 commits in the last year
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 18 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year359
human_commit_share0.97
days_since_last_push8
active_weeks_last_year27

Release discipline

90Excellent
How it's scored
27/27Ships releases — 100 releases published
36/36Release recency — latest release 8 days ago
27/27Release cadence — a release every ~9.8 days
0/10OpenSSF Scorecard: Signed-Releases — Project has not signed or included provenance with any releases.
Inputs used
releases_count100
latest_release_tagv3.36.0
releases_from_tagsno
days_since_latest_release8
mean_days_between_releases9.8

Community & Adoption

Does the project have users, downloads, attention, and a welcoming setup for contributors?

71Good · 17% of overall

Popularity & adoption

64Moderate
How it's scored
43.7/60Stars — 492 stars
16.9/25Forks — 109 forks
3.3/15Watchers — 5 watchers
Inputs used
forks109
stars492
watchers5
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

57Moderate
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
6.3/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges6
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_servicesbadge.fury.io, github.com, shields.io
has_pull_request_templateyes

Ecosystem adoption (downloads)

100Exceptional
How it's scored
80/80Monthly downloads — 18,422,849 downloads/month across pypi
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagesPyAthena
dependents—
ecosystemspypi
total_downloads—
monthly_downloads18,422,849
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?

59Moderate · 23% of overall

Maintainer resilience (bus factor)

33At Risk
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
0.9/22.5Commit distribution — top contributor authored 96% of commits
13.5/13.5Contributor breadth — 33 contributors
10/10OpenSSF Scorecard: Contributors — project has 6 contributing companies or organizations
Inputs used
bus_factor1
contributors_sampled33
top_contributor_share0.96

Issue & PR responsiveness

80Excellent
How it's scored
40.1/42Issue resolution — 96% of issues closed
27/30PR acceptance — 412/457 decided PRs merged
13/13Newcomer PR acceptance — 1/1 first-time contributors' PRs merged in 30d
0/15OpenSSF Scorecard: Code-Review — Found 1/12 approved changesets -- score normalized to 0
Inputs used
merged_prs412
open_issues14
closed_issues294
prs_merged_7d0
prs_decided_7d0
prs_merged_30d3
prs_decided_30d3
issue_closed_ratio0.955
closed_unmerged_prs45
first_time_authors_30d1
first_time_prs_merged_30d1
first_time_prs_decided_30d1

Ownership & stewardship

36Weak
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
0/25Owner reach — 0 followers of pyathena-dev
5.5/25Track record — 3 public repos, account ~0 yr old
Inputs used
followers0
owner_typeOrganization
is_verifiedno
owner_loginpyathena-dev
public_repos3
account_age_days207

Package maintenance

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

Engineering Quality

Are baseline engineering and documentation practices in place?

85Excellent · 19% of overall

Engineering practices

82Excellent
How it's scored
24/24CI workflows — 7 workflow(s)
24/24Tests present
16/16Linter config — pyproject.toml ([tool.ruff])
0/9.6Pre-commit hooks
0/6.4.editorconfig
18/20OpenSSF Scorecard: CI-Tests — 11 out of 12 merged PRs checked by a CI test -- score normalized to 9
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://pyathena.dev/
10/10Repository description
10/10Topics — 5 topics
0/10Wiki
Inputs used
topicspython, dbapi, aws, athena, sqlalchemy
has_wikino
homepagehttps://pyathena.dev/
docs_sitehttps://pyathena.dev/
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

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

65Good · 16% of overall

Security posture

56Moderate
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 — 11 out of 12 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/12 approved changesets -- score normalized to 0
2.5/2.5Contributors — project has 6 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 18 issue activity found in the last 90 days -- score normalized to 10
5/5Packaging — packaging workflow detected
5/5Pinned-Dependencies — all dependencies are pinned
0/5SAST — SAST tool is not run on all commits -- score normalized to 0
5/5Security-Policy — security policy file detected
0/7.5Signed-Releases — Project has not signed or included provenance with any releases.
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
0/7.5Vulnerabilities — 11 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate5.6
Excluded from scoring (no data or not applicable): Branch-Protection. 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_packages9
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:PyAthena@3.36.0 runtime dependency closure — what installing the published package pulls in — 9 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.

96Exceptional · 4% of overall

Agent context & guidance

100Exceptional
How it's scored
45/45Agent instructions — AGENTS.md, CLAUDE.md
15/15Machine-readable docs (llms.txt) — llms.txt served by the project website (https://docs.aws.amazon.com/llms.txt)
40/40Legible commit history — 82 of 97 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtyes
llms_txt_urlhttps://docs.aws.amazon.com/llms.txt
legible_history_share0.845
agent_instruction_filesAGENTS.md, CLAUDE.md
agent_instruction_max_bytes4,596

Verify loop (build / test / typecheck)

100Exceptional
How it's scored
18/18One-command bootstrap — .mise.toml, justfile
22/22Automated tests
11/11Lint / format config — pyproject.toml ([tool.ruff])
11/11Static type checking — pyathena/py.typed
10/10Reproducible environment — lockfile
10/10Demonstrated agent practice — 49 of the last 100 commits agent-authored or agent-credited
8/8Automated maintenance — 3 of the last 100 commits are automated dependency updates
10/10OpenSSF Scorecard: Pinned-Dependencies — all dependencies are pinned
Inputs used
has_nixno
has_testsyes
lockfilesPipfile.lock, uv.lock
has_dockerfileno
typed_languageno
bootstrap_files.mise.toml, justfile
has_devcontainerno
has_linter_configyes
typecheck_configspyathena/py.typed
agent_commit_share0.49
toolchain_manifests—
dependency_bot_commit_share0.03

Code legibility for models

80Excellent
How it's scored
27/45Type-checkable code — Python with type-check config (pyathena/py.typed)
53.5/55Manageable file sizes — 4/147 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes102,228
source_files_sampled147
oversized_source_files4

Key facts

492GitHub stars
33contributors
359commits, last 12 months
8days since last push
100releases
1bus factor
14open issues
PyPIpackage ecosystems

Data collection warnings

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

More detail

Star and fork history 0 ★ / 109 ⇿
0Stars
109Forks
99Releases

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.

02040608010012010632017-072022-012026-08
Major 1Minor 42Patch 56

Each point covers 9 days.

OpenSSF Scorecard 5.6 / 10
5.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-11 05:24 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-Tests11 out of 12 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/12 approved changesets -- score normalized to 0
10Contributorsproject has 6 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 18 issue activity found in the last 90 days -- score normalized to 10
10Packagingpackaging workflow detected
10Pinned-Dependenciesall dependencies are pinned
0SASTSAST tool is not run on all commits -- score normalized to 0
10Security-Policysecurity policy file detected
0Signed-ReleasesProject has not signed or included provenance with any releases.
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
0Vulnerabilities11 existing vulnerabilities detected
Direct dependencies 5
RegistryPackageVersion constraintManifest
PyPIboto3>=1.41.2pyproject.toml
PyPIbotocore>=1.41.2pyproject.toml
PyPItenacity>=4.1.0pyproject.toml
PyPIfsspec—pyproject.toml
PyPIpython-dateutil—pyproject.toml
All dependencies 93

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

RegistryPackageVersionRelation
PyPIboto31.17.85direct
PyPIboto31.43.14direct
PyPIbotocore1.20.85direct
PyPIbotocore1.43.14direct
PyPIfsspec2024.12.0direct
PyPIpython-dateutil2.8.1direct
PyPIpython-dateutil2.9.0.post0direct
PyPItenacity7.0.0direct
PyPItenacity9.0.0direct
PyPIaccessible-pygments0.0.5indirect
PyPIalabaster0.7.16indirect
PyPIbabel2.16.0indirect
PyPIbackports-asyncio-runner1.2.0indirect
PyPIbeautifulsoup44.13.5indirect
PyPIcertifi2024.12.14indirect
PyPIcharset-normalizer3.4.1indirect
PyPIcolorama0.4.6indirect
PyPIcoverage7.6.10indirect
PyPIdocutils0.21.2indirect
PyPIexceptiongroup1.2.2indirect
PyPIexecnet2.1.1indirect
PyPIfuro2025.9.25indirect
PyPIfuture0.18.2indirect
PyPIgreenlet3.3.2indirect
PyPIidna3.15indirect
PyPIimagesize1.4.1indirect
PyPIiniconfig2.0.0indirect
PyPIjinja23.1.6indirect
PyPIjmespath0.10.0indirect
PyPIjmespath1.0.1indirect
PyPIjpype11.2.1indirect
PyPImarkdown-it-py3.0.0indirect
PyPImarkdown-it-py4.0.0indirect
PyPImarkupsafe3.0.2indirect
PyPImdit-py-plugins0.5.0indirect
PyPImdurl0.1.2indirect
PyPImypy1.14.0indirect
PyPImypy-extensions1.0.0indirect
PyPImyst-parser4.0.1indirect
PyPImyst-parser5.0.0indirect
PyPInumpy1.20.3indirect
PyPInumpy2.0.2indirect
PyPInumpy2.3.4indirect
PyPIpackaging24.2indirect
PyPIpandas1.2.4indirect
PyPIpandas2.2.3indirect
PyPIpandas2.3.3indirect
PyPIpluggy1.5.0indirect
PyPIpolars1.36.1indirect
PyPIpolars-runtime-321.36.1indirect
PyPIpyarrow23.0.1indirect
PyPIpyathena1.7.1indirect
PyPIpyathenajdbc2.0.5indirect
PyPIpygments2.20.0indirect
PyPIpytest9.0.3indirect
PyPIpytest-asyncio1.3.0indirect
PyPIpytest-cov6.0.0indirect
PyPIpytest-dependency0.6.0indirect
PyPIpytest-xdist3.6.1indirect
PyPIpytz2021.1indirect
PyPIpytz2024.2indirect
PyPIpyyaml6.0.3indirect
PyPIrequests2.33.0indirect
PyPIroman-numerals4.1.0indirect
PyPIroman-numerals-py4.1.0indirect
PyPIs3transfer0.17.0indirect
PyPIs3transfer0.4.2indirect
PyPIsetuptools83.0.0indirect
PyPIsix1.16.0indirect
PyPIsix1.17.0indirect
PyPIsnowballstemmer2.2.0indirect
PyPIsoupsieve2.8.4indirect
PyPIsphinx7.4.7indirect
PyPIsphinx8.2.3indirect
PyPIsphinx-basic-ng1.0.0b2indirect
PyPIsphinx-design0.6.1indirect
PyPIsphinx-design0.7.0indirect
PyPIsphinx-multiversion0.2.4indirect
PyPIsphinxcontrib-applehelp2.0.0indirect
PyPIsphinxcontrib-devhelp2.0.0indirect
PyPIsphinxcontrib-htmlhelp2.1.0indirect
PyPIsphinxcontrib-jsmath1.0.1indirect
PyPIsphinxcontrib-qthelp2.0.0indirect
PyPIsphinxcontrib-serializinghtml2.0.0indirect
PyPIsphinxext-opengraph0.13.0indirect
PyPIsqlalchemy2.0.46indirect
PyPItomli2.2.1indirect
PyPItypes-python-dateutil2.9.0.20241206indirect
PyPItyping-extensions3.10.0.0indirect
PyPItyping-extensions4.12.2indirect
PyPItzdata2024.2indirect
PyPIurllib31.26.5indirect
PyPIurllib32.7.0indirect
Dependency advisories 0

Installing pypi:PyAthena@3.36.0 pulls in 9 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 pyathena-dev/PyAthena. Read them side by side →

100aws/aws-sam-cliCLI tool to build, test, debug, and deploy Serverless applications using AWS SAMExceptional99prowler-cloud/prowlerProwler is the world’s most widely used open-source cloud security platform that automates security and compliance across any cloud environment.Exceptional99aws-powertools/powertools-lambda-pythonA developer toolkit to implement Serverless best practices and increase developer velocity.Exceptional98Netflix/metaflowBuild, Manage and Deploy AI/ML SystemsExceptional98pulumi/pulumiPulumi - Infrastructure as Code in any programming language 🚀Exceptional100streamlit/streamlitStreamlit — A faster way to build and share data apps.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.