Public record
Software health reportschema 0.14.0 · metrics 2.10.0 · 2026-07-18 23:16 UTC

laughingman7743 / pyathena

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

PythonMIT★ 492 stars⑂ 108 forkssince May 2017View on GitHub ↗
#python#dbapi#aws#athena#sqlalchemy

laughingman7743/pyathena holds a health index of 77 out of 100, placing it in the Good band. It scores highest on Vitality (88/100) and lowest on Security (52/100). It was last updated 4 days ago. A single contributor accounts for most of its recent work.

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

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

Ownership

pyathena-devOrganization
1 follower3 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
PyPIPyAthenapoints to another repo — not scored3.35.2-1804 days ago

Metrics by category

Vitality

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

88Excellent · 21% of overall

Development activity

86Excellent
How it's scored
36/36Push recency — last push 4 days ago
21.5/36Commit cadence — 31/52 weeks with commits
18/18Commit volume — 444 commits in the last year
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 15 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year444
human_commit_share—
days_since_last_push4
active_weeks_last_year31

Release discipline

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

Community & Adoption

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

61Moderate · 17% of overall

Popularity & adoption

64Moderate
How it's scored
43.7/60Stars — 492 stars
16.9/25Forks — 108 forks
3.3/15Watchers — 5 watchers
Inputs used
forks108
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_badges—
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_services—
has_pull_request_templateyes

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)

34At Risk
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
1.3/22.5Commit distribution — top contributor authored 94% 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.942

Issue & PR responsiveness

80Excellent
How it's scored
41.2/42Issue resolution — 98% of issues closed
27/30PR acceptance — 398/443 decided PRs merged
0/13Newcomer PR acceptance — no first-time contributor's PR decided in 30d
1.5/15OpenSSF Scorecard: Code-Review — Found 1/6 approved changesets -- score normalized to 1
Inputs used
merged_prs398
open_issues6
closed_issues290
prs_merged_7d—
prs_decided_7d—
prs_merged_30d—
prs_decided_30d—
issue_closed_ratio0.98
closed_unmerged_prs45
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.

Ownership & stewardship

47Weak
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain — verified-domain status not read for this organization
2.2/25Owner reach — 1 followers of pyathena-dev
5.2/25Track record — 3 public repos, account ~0 yr old
Inputs used
followers1
owner_typeOrganization
is_verified—
owner_loginpyathena-dev
public_repos3
account_age_days153
Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.

Engineering Quality

Are baseline engineering and documentation practices in place?

74Good · 19% of overall

Engineering practices

64Moderate
How it's scored
24/24CI workflows — 7 workflow(s)
24/24Tests present
0/16Linter config
0/9.6Pre-commit hooks
0/6.4.editorconfig
16/20OpenSSF Scorecard: CI-Tests — 6 out of 7 merged PRs checked by a CI test -- score normalized to 8
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configno
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?

52Moderate · 16% of overall

Security posture

52Moderate
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — no data
2/2.5CI-Tests — 6 out of 7 merged PRs checked by a CI test -- score normalized to 8
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0.8/7.5Code-Review — Found 1/6 approved changesets -- score normalized to 1
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 15 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
0/5Security-Policy — security policy file not 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 — 12 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate5.2
Excluded from scoring (no data or not applicable): Branch-Protection. Remaining weights renormalized.

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.

82Excellent · 4% of overall

Agent context & guidance

75Good
How it's scored
45/45Agent instructions — CLAUDE.md
0/15Machine-readable docs (llms.txt)
0/40Legible commit history — no data
Inputs used
has_llms_txtno
llms_txt_url—
legible_history_share—
agent_instruction_filesCLAUDE.md
agent_instruction_max_bytes4,482
Excluded from scoring (no data or not applicable): Legible commit history. Remaining weights renormalized.

Verify loop (build / test / typecheck)

87Excellent
How it's scored
18/18One-command bootstrap — .mise.toml, justfile
22/22Automated tests
0/11Lint / format config
11/11Static type checking — pyathena/py.typed
10/10Reproducible environment — lockfile
0/10Demonstrated agent practice — no data
0/8Automated maintenance — no data
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_configno
typecheck_configspyathena/py.typed
agent_commit_share—
toolchain_manifests—
dependency_bot_commit_share—
Excluded from scoring (no data or not applicable): Demonstrated agent practice, Automated maintenance. Remaining weights renormalized.

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
444commits, last 12 months
4days since last push
100releases
1bus factor
6open issues
PyPIpackage ecosystems

Data collection warnings

  • pypi package 'PyAthena' points at a different repository (https://github.com/pyathena-dev/PyAthena/); excluded from ecosystem scoring

More detail

OpenSSF Scorecard 5.2 / 10
5.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-07-18 23:16 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
8CI-Tests6 out of 7 merged PRs checked by a CI test -- score normalized to 8
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
1Code-ReviewFound 1/6 approved changesets -- score normalized to 1
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 15 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
0Security-Policysecurity policy file not detected
0Signed-ReleasesProject has not signed or included provenance with any releases.
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
0Vulnerabilities12 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
PyPIsetuptools78.1.1indirect
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
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 laughingman7743/pyathena. Read them side by side →

99prowler-cloud/prowlerProwler is the world’s most widely used open-source cloud security platform that automates security and compliance across any cloud environment.Exceptional99aws/aws-sam-cliCLI tool to build, test, debug, and deploy Serverless applications using AWS SAMExceptional99aws-powertools/powertools-lambda-pythonA developer toolkit to implement Serverless best practices and increase developer velocity.Exceptional98Netflix/metaflowBuild, Manage and Deploy AI/ML SystemsExceptional98aws/sagemaker-python-sdkA library for training and deploying machine learning models on Amazon SageMakerExceptional98pulumi/pulumiPulumi - Infrastructure as Code in any programming language 🚀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.14.0 — full methodology · metrics wiki.

How one result sits in the wider record: aggregate statistics — PyPI.