Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-09-15 06:59 UTC

cockroachdb / sqlalchemy-cockroachdb

SQLAlchemy adapter for CockroachDB

PythonApache-2.0★ 156 stars⑂ 65 forkssince Mar 2015View on GitHub ↗
KindLibraryhow this is determined

cockroachdb/sqlalchemy-cockroachdb holds a health index of 77 out of 100, placing it in the Good band. It scores highest on Sustainability & Governance (84/100) and lowest on AI Readiness (43/100). It was last updated 40 days ago. 2 contributors account 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

CockroachDBOrganization · verified domain
969 followers225 public repossince Feb 2014

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publishTags
PyPIsqlalchemy-cockroachdb2.0.4486,93718144 days agosqlalchemycockroachdb

Metrics by category

Vitality

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

48Weak · 21% of overall

Development activity

39Weak
How it's scored
18/36Push recency — last push 40 days ago
9/36Commit cadence — 13/52 weeks with commits
12.1/18Commit volume — 21 commits in the last year
0/10OpenSSF Scorecard: Maintained — 0 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 0
Inputs used
commits_last_year21
human_commit_share0.69
days_since_last_push40
active_weeks_last_year13

Release discipline

62Moderate
How it's scored
16.2/27Ships releases — 17 version tags (no GitHub releases)
27/36Release recency — latest release 144 days ago
12.6/27Release cadence — a release every ~182.8 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count17
latest_release_tagv2.0.4
releases_from_tagsyes
days_since_latest_release144
mean_days_between_releases182.8
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?

65Good · 17% of overall

Popularity & adoption

60Moderate
How it's scored
35.5/60Stars — 156 stars
15.1/25Forks — 65 forks
9.1/15Watchers — 45 watchers
Inputs used
forks65
stars156
watchers45
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

50Moderate
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (Apache-2.0)
0/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges0
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_services—
has_pull_request_templateno

Ecosystem adoption (downloads)

95Exceptional
How it's scored
75.8/80Monthly downloads — 486,937 downloads/month across pypi
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagessqlalchemy-cockroachdb
dependents—
ecosystemspypi
total_downloads—
monthly_downloads486,937
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?

84Excellent · 23% of overall

Maintainer resilience (bus factor)

63Moderate
How it's scored
25.2/54Bus factor — 2 contributor(s) cover half of all commits
14.4/22.5Commit distribution — top contributor authored 36% of commits
13.5/13.5Contributor breadth — 27 contributors
10/10OpenSSF Scorecard: Contributors — project has 9 contributing companies or organizations
Inputs used
bus_factor2
contributors_sampled27
top_contributor_share0.359

Issue & PR responsiveness

85Excellent
How it's scored
37.9/42Issue resolution — 90% of issues closed
24.2/30PR acceptance — 178/221 decided PRs merged
0/13Newcomer PR acceptance — no first-time contributor's PR decided in 30d
12/15OpenSSF Scorecard: Code-Review — Found 9/11 approved changesets -- score normalized to 8
Inputs used
merged_prs178
open_issues8
closed_issues74
prs_merged_7d0
prs_decided_7d0
prs_merged_30d0
prs_decided_30d0
issue_closed_ratio0.902
closed_unmerged_prs43
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

96Exceptional
How it's scored
30/30Ownership backing — organization-owned
20/20Verified domain
21.5/25Owner reach — 969 followers of cockroachdb
25/25Track record — 225 public repos, account ~12 yr old
Inputs used
followers969
owner_typeOrganization
is_verifiedyes
owner_logincockroachdb
public_repos225
account_age_days4,588

Package maintenance

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

Engineering Quality

Are baseline engineering and documentation practices in place?

74Good · 19% of overall

Engineering practices

80Excellent
How it's scored
24/24CI workflows — 1 workflow(s)
24/24Tests present
16/16Linter config — pyproject.toml ([tool.black]), setup.cfg ([flake8]), tox.ini
0/9.6Pre-commit hooks
0/6.4.editorconfig
16/20OpenSSF Scorecard: CI-Tests — 22 out of 25 merged PRs checked by a CI test -- score normalized to 8
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configyes
has_precommit_configno

Documentation

65Good
How it's scored
30/30README
0/25Documentation directory
15/15Documentation / homepage site — https://github.com/cockroachdb/sqlalchemy-cockroachdb/wiki
10/10Repository description
0/10Topics
10/10Wiki
Inputs used
topics—
has_wikiyes
homepage—
docs_sitehttps://github.com/cockroachdb/sqlalchemy-cockroachdb/wiki
has_readmeyes
has_docs_dirno
has_descriptionyes

Security

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

60Moderate · 16% of overall

Security posture

50Moderate
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 — 22 out of 25 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
6/7.5Code-Review — Found 9/11 approved changesets -- score normalized to 8
2.5/2.5Contributors — project has 9 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
0/7.5Maintained — 0 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 0
0/5Packaging — no data
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
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — no data
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
4.5/7.5Vulnerabilities — 4 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated15
scorecard_versionv5.5.0
checks_inconclusive3
scorecard_aggregate5
Excluded from scoring (no data or not applicable): Branch-Protection, Packaging, 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_packages3
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:sqlalchemy-cockroachdb@2.0.4 runtime dependency closure — what installing the published package pulls in — 3 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.

43Weak · 4% of overall

Agent context & guidance

17Critical
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
17/40Legible commit history — 22 of 69 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
llms_txt_url—
legible_history_share0.319
agent_instruction_files—
agent_instruction_max_bytes—

Verify loop (build / test / typecheck)

59Moderate
How it's scored
18/18One-command bootstrap — Makefile
22/22Automated tests
11/11Lint / format config — pyproject.toml ([tool.black]), setup.cfg ([flake8]), tox.ini
0/11Static type checking
0/10Reproducible environment
0/10Demonstrated agent practice — no agent-authored commits among the last 100
8/8Automated maintenance — 31 of the last 100 commits are automated dependency updates
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfiles—
has_dockerfileno
typed_languageno
bootstrap_filesMakefile
has_devcontainerno
has_linter_configyes
typecheck_configs—
agent_commit_share0
toolchain_manifests—
dependency_bot_commit_share0.31

Code legibility for models

55Moderate
How it's scored
0/45Type-checkable code — Python without a type-check config
55/55Manageable file sizes — 0/25 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes20,498
source_files_sampled25
oversized_source_files0

Key facts

156GitHub stars
27contributors
21commits, last 12 months
40days since last push
17releases
2bus factor
8open 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 ★ / 65 ⇿
0Stars
65Forks
17Releases

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.

01325385063756442015-032020-122026-08
Major 1Minor 2Patch 14

Each point covers 11 days.

OpenSSF Scorecard 5.0 / 10
5.0aggregate

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-15 06:58 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-Tests22 out of 25 merged PRs checked by a CI test -- score normalized to 8
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
8Code-ReviewFound 9/11 approved changesets -- score normalized to 8
10Contributorsproject has 9 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
0Maintained0 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 0
n/aPackagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
0SASTSAST tool is not run on all commits -- score normalized to 0
0Security-Policysecurity policy file not detected
n/aSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
6Vulnerabilities4 existing vulnerabilities detected
All dependencies 58

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

RegistryPackageVersionRelation
PyPIalembic1.18.4indirect
PyPIasync-timeout5.0.1indirect
PyPIasyncpg0.31.0indirect
PyPIbackports-tarfile1.2.0indirect
PyPIcachetools7.1.1indirect
PyPIcertifi2026.4.22indirect
PyPIcffi2.0.0indirect
PyPIchardet7.4.3indirect
PyPIcharset-normalizer3.4.7indirect
PyPIcolorama0.4.6indirect
PyPIcryptography48.0.0indirect
PyPIdistlib0.4.0indirect
PyPIdocutils0.22.4indirect
PyPIexceptiongroup1.3.1indirect
PyPIfilelock3.29.0indirect
PyPIfutures3.0.5indirect
PyPIgreenlet3.5.0indirect
PyPIid1.6.1indirect
PyPIidna3.15indirect
PyPIimportlib-metadata9.0.0indirect
PyPIiniconfig2.3.0indirect
PyPIjaraco-classes3.4.0indirect
PyPIjaraco-context6.1.2indirect
PyPIjaraco-functools4.4.0indirect
PyPIjeepney0.9.0indirect
PyPIkeyring25.7.0indirect
PyPImako1.3.12indirect
PyPImarkdown-it-py4.2.0indirect
PyPImarkupsafe3.0.3indirect
PyPImdurl0.1.2indirect
PyPImock5.2.0indirect
PyPImore-itertools11.0.2indirect
PyPInh30.3.5indirect
PyPIpackaging26.2indirect
PyPIplatformdirs4.9.6indirect
PyPIpluggy1.6.0indirect
PyPIpsycopg3.3.4indirect
PyPIpsycopg22.9.12indirect
PyPIpycparser3.0indirect
PyPIpygments2.20.0indirect
PyPIpyproject-api1.10.0indirect
PyPIpytest9.0.3indirect
PyPIpython-discovery1.3.1indirect
PyPIreadme-renderer44.0indirect
PyPIrequests2.34.1indirect
PyPIrequests-toolbelt1.0.0indirect
PyPIrfc39862.0.0indirect
PyPIrich15.0.0indirect
PyPIsecretstorage3.5.0indirect
PyPIsqlalchemy—indirect
PyPIsqlalchemy2.0.49indirect
PyPItomli2.4.1indirect
PyPItox4.34.1indirect
PyPItwine6.2.0indirect
PyPItyping-extensions4.15.0indirect
PyPIurllib32.7.0indirect
PyPIvirtualenv21.3.3indirect
PyPIzipp3.23.1indirect
Dependency advisories 0

Installing pypi:sqlalchemy-cockroachdb@2.0.4 pulls in 3 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 cockroachdb/sqlalchemy-cockroachdb. Read them side by side →

98googleapis/mcp-toolboxMCP Toolbox for Databases is an open source MCP server for databases.Exceptional97fastapi/sqlmodelSQL databases in Python, designed for simplicity, compatibility, and robustness.Exceptional96beekeeper-studio/beekeeper-studioModern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.Exceptional94SAP/sqlalchemy-hanaSQLAlchemy Dialect for SAP HANAExceptional94sqlalchemy/alembicA database migrations tool for SQLAlchemy.Exceptional94ClickHouse/clickhouse-connectPython driver/sqlalchemy/superset connectorsExceptional

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.