Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-09-14 04:47 UTC

SAP / sqlalchemy-hana

SQLAlchemy Dialect for SAP HANA

PythonApache-2.0★ 151 stars⑂ 61 forkssince Mar 2015View on GitHub ↗

#python #hana #sqlalchemy #orm #sap-hana

SAP/sqlalchemy-hana holds a health index of 94 out of 100, placing it in the Exceptional band. It scores highest on Vitality (93/100) and lowest on AI Readiness (44/100). It was last updated today. A single contributor accounts for most of its recent work.

overall / 100

Exceptional

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.

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)

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

Ownership

SAPOrganization · verified domain

4,518 followers276 public repossince Oct 2012

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

Package ecosystems

Registry	Package	Version	Downloads / mo	Versions	Last publish	Tags
PyPI	sqlalchemy-hana	4.6.1	651,466	36	58 days ago	sqlalchemy sap hana

Metrics by category

Vitality

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

93Exceptional · 21% of overall

Development activity

99Exceptional

How it's scored

36/36	Push recency — last push 0 days ago
35.3/36	Commit cadence — 51/52 weeks with commits
18/18	Commit volume — 283 commits in the last year
10/10	OpenSSF Scorecard: Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10

Inputs used

commits_last_year	283
human_commit_share	0.12
days_since_last_push	0
active_weeks_last_year	51

Release discipline

83Excellent

How it's scored

27/27	Ships releases — 32 releases published
36/36	Release recency — latest release 58 days ago
19.8/27	Release cadence — a release every ~52.3 days
0/10	OpenSSF Scorecard: Signed-Releases — Project has not signed or included provenance with any releases.

Inputs used

releases_count	32
latest_release_tag	v4.6.1
releases_from_tags	no
days_since_latest_release	58
mean_days_between_releases	52.3

Community & Adoption

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

76Good · 17% of overall

Popularity & adoption

56Moderate

How it's scored

35.3/60	Stars — 151 stars
14.8/25	Forks — 61 forks
6/15	Watchers — 13 watchers

Inputs used

forks	61
stars	151
watchers	13
growth_state	unverified
growth_factor_pct	100
growth_unverified_reason	no_history

Community health

85Excellent

How it's scored

22.5/22.5	README
22.5/22.5	License — recognized license (Apache-2.0)
18/18	CONTRIBUTING guide
13.5/13.5	Code of conduct
0/7.2	Issue template
0/6.3	PR template

Inputs used

has_readme	yes
has_license	yes
readme_badges	2
has_contributing	yes
has_issue_template	no
has_code_of_conduct	yes
readme_badge_services	coveralls.io, shields.io
has_pull_request_template	no

Ecosystem adoption (downloads)

97Exceptional

How it's scored

77.5/80	Monthly downloads — 651,466 downloads/month across pypi
0/20	Registry dependents — not reported by this ecosystem

Inputs used

packages	sqlalchemy-hana
dependents	—
ecosystems	pypi
total_downloads	—
monthly_downloads	651,466
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?

82Excellent · 23% of overall

Maintainer resilience (bus factor)

41Weak

How it's scored

9/54	Bus factor — 1 contributor(s) cover half of all commits
8.3/22.5	Commit distribution — top contributor authored 63% of commits
13.5/13.5	Contributor breadth — 18 contributors
10/10	OpenSSF Scorecard: Contributors — project has 3 contributing companies or organizations -- score normalized to 10

Inputs used

bus_factor	1
contributors_sampled	18
top_contributor_share	0.633

Issue & PR responsiveness

97Exceptional

How it's scored

42/42	Issue resolution — 100% of issues closed
27.3/30	PR acceptance — 598/657 decided PRs merged
0/13	Newcomer PR acceptance — no first-time contributor's PR decided in 30d
15/15	OpenSSF Scorecard: Code-Review — all changesets reviewed

Inputs used

merged_prs	598
open_issues	0
closed_issues	65
prs_merged_7d	0
prs_decided_7d	0
prs_merged_30d	1
prs_decided_30d	1
issue_closed_ratio	1
closed_unmerged_prs	59
first_time_authors_30d	0
first_time_prs_merged_30d	0
first_time_prs_decided_30d	0

Excluded from scoring (no data or not applicable): Newcomer PR acceptance. Remaining weights renormalized.

Ownership & stewardship

100Exceptional

How it's scored

30/30	Ownership backing — organization-owned
20/20	Verified domain
25/25	Owner reach — 4,518 followers of SAP
25/25	Track record — 276 public repos, account ~13 yr old

Inputs used

followers	4,518
owner_type	Organization
is_verified	yes
owner_login	SAP
public_repos	276
account_age_days	5,086

Package maintenance

100Exceptional

How it's scored

25/25	Published & resolvable — 1 package(s) on pypi
35/35	Publish recency — latest publish 58 days ago
20/20	Version history — 36 published versions
20/20	Not deprecated — active, not deprecated or yanked

Inputs used

packages	sqlalchemy-hana
ecosystems	pypi
any_deprecated	no
min_days_since_publish	58

Engineering Quality

Are baseline engineering and documentation practices in place?

76Good · 19% of overall

Engineering practices

94Exceptional

How it's scored

24/24	CI workflows — 2 workflow(s)
24/24	Tests present
16/16	Linter config — .flake8, pyproject.toml ([tool.pylint], [tool.isort])
9.6/9.6	Pre-commit hooks
0/6.4	.editorconfig
20/20	OpenSSF Scorecard: CI-Tests — 30 out of 30 merged PRs checked by a CI test -- score normalized to 10

Inputs used

has_ci	yes
has_tests	yes
has_editorconfig	no
has_linter_config	yes
has_precommit_config	yes

Documentation

50Moderate

How it's scored

30/30	README
0/25	Documentation directory
0/15	Documentation / homepage site
10/10	Repository description
10/10	Topics — 5 topics
0/10	Wiki

Inputs used

topics	python, hana, sqlalchemy, orm, sap-hana
has_wiki	no
homepage	—
docs_site	—
has_readme	yes
has_docs_dir	no
has_description	yes

Security

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

75Good · 16% of overall

Security posture

69Good

How it's scored

7.5/7.5	Binary-Artifacts — no binaries found in the repo
6/7.5	Branch-Protection — branch protection is not maximal on development and all release branches
2.5/2.5	CI-Tests — 30 out of 30 merged PRs checked by a CI test -- score normalized to 10
0/2.5	CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
7.5/7.5	Code-Review — all changesets reviewed
2.5/2.5	Contributors — project has 3 contributing companies or organizations -- score normalized to 10
0/10	Dangerous-Workflow — dangerous workflow patterns detected
7.5/7.5	Dependency-Update-Tool — update tool detected
0/5	Fuzzing — project is not fuzzed
2.5/2.5	License — license file detected
7.5/7.5	Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
5/5	Packaging — packaging workflow detected
0/5	Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
5/5	SAST — SAST tool is run on all commits
5/5	Security-Policy — security policy file detected
0/7.5	Signed-Releases — Project has not signed or included provenance with any releases.
6.8/7.5	Token-Permissions — detected GitHub workflow tokens with excessive permissions
7.5/7.5	Vulnerabilities — 0 existing vulnerabilities detected

Inputs used

source	openssf_scorecard
checks_evaluated	18
scorecard_version	v5.5.0
checks_inconclusive	0
scorecard_aggregate	6.9

Dependency advisories

100Exceptional

How it's scored

35/35	Direct dependencies free of known advisories — no direct dependency carries a known advisory
25/25	Indirect dependencies free of known advisories — no indirect dependency carries a known advisory
0/40	No advisories left outstanding — no advisory carries a publication date

Inputs used

source	osv
advisories	0
affected_packages	0
assessed_packages	4
unassessed_packages	0
affected_by_severity	none
direct_affected_packages	0

Excluded from scoring (no data or not applicable): No advisories left outstanding. Remaining weights renormalized. Matched the pypi:sqlalchemy-hana@4.6.1 runtime dependency closure — what installing the published package pulls in — 4 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.

44Weak · 4% of overall

Agent context & guidance

1Critical

How it's scored

0/45	Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15	Machine-readable docs (llms.txt)
0/40	Legible commit history — no data

Inputs used

has_llms_txt	no
llms_txt_url	—
legible_history_share	—
agent_instruction_files	—
agent_instruction_max_bytes	—

Excluded from scoring (no data or not applicable): Legible commit history. Remaining weights renormalized.

Verify loop (build / test / typecheck)

62Moderate

How it's scored

0/18	One-command bootstrap
22/22	Automated tests
11/11	Lint / format config — .flake8, pyproject.toml ([tool.pylint], [tool.isort])
11/11	Static type checking — sqlalchemy_hana/py.typed
10/10	Reproducible environment — lockfile
0/10	Demonstrated agent practice — no agent-authored commits among the last 100
8/8	Automated maintenance — 88 of the last 100 commits are automated dependency updates
0/10	OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0

Inputs used

has_nix	no
has_tests	yes
lockfiles	uv.lock
has_dockerfile	no
typed_language	no
bootstrap_files	—
has_devcontainer	no
has_linter_config	yes
typecheck_configs	sqlalchemy_hana/py.typed
agent_commit_share	0
toolchain_manifests	—
dependency_bot_commit_share	0.88

Code legibility for models

82Excellent

How it's scored

27/45	Type-checkable code — Python with type-check config (sqlalchemy_hana/py.typed)
55/55	Manageable file sizes — 0/23 source files over 60KB

Inputs used

primary_language	Python
largest_source_bytes	49,062
source_files_sampled	23
oversized_source_files	0

Key facts

151GitHub stars

18contributors

283commits, last 12 months

0days since last push

32releases

1bus factor

0open issues

PyPIpackage ecosystems

Data collection warnings

Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
pypi download statistics for 'sqlalchemy-hana' unavailable this scan (stats endpoint failed after retries); adoption may be under-evidenced
pypi download figures for sqlalchemy-hana carried forward from the previous scan (stats endpoint unavailable this scan)

More detail

Star and fork history 0 ★ / 61 ⇿

0Stars

61Forks

32Releases

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.

Major 4Minor 21Patch 7

Each point covers 11 days.

OpenSSF Scorecard 6.9 / 10

6.9aggregate

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-14 04:46 UTC

10	Binary-Artifacts	no binaries found in the repo
8	Branch-Protection	branch protection is not maximal on development and all release branches
10	CI-Tests	30 out of 30 merged PRs checked by a CI test -- score normalized to 10
0	CII-Best-Practices	no effort to earn an OpenSSF best practices badge detected
10	Code-Review	all changesets reviewed
10	Contributors	project has 3 contributing companies or organizations -- score normalized to 10
0	Dangerous-Workflow	dangerous workflow patterns detected
10	Dependency-Update-Tool	update tool detected
0	Fuzzing	project is not fuzzed
10	License	license file detected
10	Maintained	30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
10	Packaging	packaging workflow detected
0	Pinned-Dependencies	dependency not pinned by hash detected -- score normalized to 0
10	SAST	SAST tool is run on all commits
10	Security-Policy	security policy file detected
0	Signed-Releases	Project has not signed or included provenance with any releases.
9	Token-Permissions	detected GitHub workflow tokens with excessive permissions
10	Vulnerabilities	0 existing vulnerabilities detected

Direct dependencies 3

Registry	Package	Version constraint	Manifest
PyPI	sqlalchemy	`>=2,<3`	pyproject.toml
PyPI	hdbcli	`~=2.10`	pyproject.toml
PyPI	typing_extensions	`~=4.15`	pyproject.toml

All dependencies 66

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

Registry	Package	Version	Relation
PyPI	hdbcli	`2.29.27`	direct
PyPI	sqlalchemy	`2.0.52`	direct
PyPI	typing-extensions	`4.16.0`	direct
PyPI	alembic	`1.19.2`	indirect
PyPI	ast-serialize	`0.9.0`	indirect
PyPI	astroid	`4.0.4`	indirect
PyPI	attrs	`26.1.0`	indirect
PyPI	black	`26.5.1`	indirect
PyPI	cfgv	`3.5.0`	indirect
PyPI	chardet	`7.6.0`	indirect
PyPI	click	`8.5.0`	indirect
PyPI	colorama	`0.4.6`	indirect
PyPI	coverage	`7.16.0`	indirect
PyPI	dependency-groups	`1.3.2`	indirect
PyPI	diff-cover	`10.5.1`	indirect
PyPI	dill	`0.4.1`	indirect
PyPI	distlib	`0.4.3`	indirect
PyPI	exceptiongroup	`1.3.1`	indirect
PyPI	filelock	`3.32.5`	indirect
PyPI	flake8	`7.3.0`	indirect
PyPI	flake8-bugbear	`26.9.9`	indirect
PyPI	flake8-builtins	`3.1.0`	indirect
PyPI	flake8-comprehensions	`3.17.0`	indirect
PyPI	flake8-plugin-utils	`1.3.3`	indirect
PyPI	flake8-pytest-style	`2.2.0`	indirect
PyPI	flake8-simplify	`0.30.0`	indirect
PyPI	flake8-tergeo	`26.9.10.0`	indirect
PyPI	flake8-typing-imports	`1.17.0`	indirect
PyPI	greenlet	`3.5.5`	indirect
PyPI	identify	`2.6.19`	indirect
PyPI	iniconfig	`2.3.0`	indirect
PyPI	isort	`9.0.1`	indirect
PyPI	jinja2	`3.1.6`	indirect
PyPI	librt	`0.15.0`	indirect
PyPI	mako	`1.4.1`	indirect
PyPI	markupsafe	`3.0.3`	indirect
PyPI	mccabe	`0.7.0`	indirect
PyPI	mypy	`2.3.1`	indirect
PyPI	mypy-extensions	`1.1.0`	indirect
PyPI	nodeenv	`1.10.0`	indirect
PyPI	packaging	`26.3`	indirect
PyPI	pathspec	`1.1.1`	indirect
PyPI	platformdirs	`4.11.7`	indirect
PyPI	pluggy	`1.6.0`	indirect
PyPI	pre-commit	`4.6.2`	indirect
PyPI	pycodestyle	`2.14.0`	indirect
PyPI	pyflakes	`3.4.0`	indirect
PyPI	pygments	`2.21.0`	indirect
PyPI	pylint	`4.0.8`	indirect
PyPI	pylint-per-file-ignores	`3.2.1`	indirect
PyPI	pytest	`9.1.1`	indirect
PyPI	pytest-cov	`7.1.0`	indirect
PyPI	pytest-randomly	`5.0.0`	indirect
PyPI	python-discovery	`1.6.0`	indirect
PyPI	pytokens	`0.4.1`	indirect
PyPI	pyupgrade	`3.21.2`	indirect
PyPI	pyyaml	`6.0.3`	indirect
PyPI	sqlalchemy-hana	`4.6.1`	indirect
PyPI	tokenize-rt	`6.2.0`	indirect
PyPI	toml-sort	`0.24.4`	indirect
PyPI	tomli	`2.4.1`	indirect
PyPI	tomlkit	`0.15.1`	indirect
PyPI	types-hdbcli	`2.29.0.20260716`	indirect
PyPI	uv	`0.12.12`	indirect
PyPI	virtualenv	`21.7.8`	indirect
PyPI	yesqa	`1.5.0`	indirect

Dependency advisories 0

Installing pypi:sqlalchemy-hana@4.6.1 pulls in 4 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.

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.

Software health index

Score profile

Ownership

Package ecosystems

Metrics by category

Key facts

Data collection warnings

More detail

Feedback

Related records