Öffentliches RegisterGut
Software-GesundheitsberichtSchema 0.17.0 · Metriken 1.13.0 · 2026-07-21 03:38 UTC
snowflakedb / snowflake-sqlalchemy
Snowflake SQLAlchemy
snowflakedb/snowflake-sqlalchemy erreicht einen Gesundheitsindex von 78 von 100 und liegt damit im Bereich Gut. Am stärksten schneidet es bei Vitality (90/100) ab, am schwächsten bei AI Readiness (46/100). Zuletzt vor 4 Tagen aktualisiert. 3 Mitwirkende tragen den Großteil der jüngsten Arbeit.
78
gesamt / 100Software-Gesundheitsindex
Metriken werden auf einer Skala von 1–100 in gewichtete Kategorien gruppiert. Der Gesamtwert beginnt als ihr Mittel; sobald öffentliche Evidenz die Richtlinie für Hochrisikojurisdiktionen auslöst, wird die Bewertung angepasst und erhält die Obergrenze 49 (Gefährdet). AI Readiness liegt außerhalb.
78
Exzellent85-100Vorbildlich; erfüllt im Wesentlichen alle geprüften Kriterien
Gut70-84Gesund; geringfügige Lücken
Mittel50-69Akzeptabel mit deutlichen Lücken; Überprüfung empfohlen
Gefährdet30-49Erhebliche Schwächen; eine Übernahme erfordert Vorsicht
Kritisch1-29Schwerwiegende Probleme (aufgegeben, nur ein Maintainer, keine Hygiene)
Bewertungsprofil
Jede Achse ist eine Kategorie. Die Form zählt mehr als der Durchschnitt — ein gesundes Projekt füllt die gesamte Fläche, während ein Profil aus Spitzen und Kratern bedeutet, dass Stärke in einer Dimension Risiken in einer anderen verdeckt.
Eigentümerschaft
SnowflakeOrganisation
1.616 Follower63 öffentliche Reposseit Jan. 2014
Dieses Repository wird von einer Organisation getragen — geteilte, rechenschaftspflichtige Trägerschaft, die jeden einzelnen Maintainer überdauern kann.
Paket-Ökosysteme
| Registry | Paket | Version | Downloads / Monat | Versionen | Zuletzt veröffentlicht | Tags |
|---|---|---|---|---|---|---|
| PyPI | snowflake-sqlalchemy | 1.11.0 | 78.552.830 | 59 | vor 12 Tagen | snowflakeanalyticsclouddatabasedbwarehouse |
Metriken nach Kategorie
Vitalität
Lebt das Projekt — wird Code geschrieben und werden Releases ausgeliefert?
90
Entwicklungsaktivität
85Exzellent
Wie die Bewertung erfolgt
| 36/36 | Push-Aktualität — letzter Push vor 4 Tagen |
| 21.5/36 | Commit-Rhythmus — 31/52 Wochen mit Commits |
| 17.2/18 | Commit-Volumen — 82 Commits im letzten Jahr |
| 10/10 | OpenSSF Scorecard: Maintained — 30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10 |
Verwendete Eingangsdaten
| commits_last_year | 82 |
| human_commit_share | — |
| days_since_last_push | 4 |
| active_weeks_last_year | 31 |
Release-Disziplin
98Exzellent
Wie die Bewertung erfolgt
| 27/27 | Liefert Releases aus — 51 Releases veröffentlicht |
| 36/36 | Release-Aktualität — letztes Release vor 4 Tagen |
| 27/27 | Release-Rhythmus — ein Release etwa alle 41,3 Tage |
| 8/10 | OpenSSF Scorecard: Signed-Releases — 5 out of the last 5 releases have a total of 5 signed artifacts. |
Verwendete Eingangsdaten
| releases_count | 51 |
| latest_release_tag | v2.0.0a0 |
| releases_from_tags | nein |
| days_since_latest_release | 4 |
| mean_days_between_releases | 41,3 |
Community & Verbreitung
Hat das Projekt Nutzer, Downloads, Aufmerksamkeit und ein einladendes Umfeld für Beitragende?
71
Popularität & Verbreitung
65Mittel
Wie die Bewertung erfolgt
| 39.4/60 | Stars — 268 Stars |
| 18.5/25 | Forks — 169 Forks |
| 7.1/15 | Watcher — 20 Watcher |
Verwendete Eingangsdaten
| forks | 169 |
| stars | 268 |
| watchers | 20 |
| growth_state | organic |
| growth_factor_pct | 100 |
Community-Gesundheit
57Mittel
Wie die Bewertung erfolgt
| 22.5/22.5 | README |
| 22.5/22.5 | Lizenz — anerkannte Lizenz (Apache-2.0) |
| 0/18 | CONTRIBUTING-Leitfaden |
| 0/13.5 | Verhaltenskodex |
| 0/7.2 | Issue-Vorlage |
| 6.3/6.3 | PR-Vorlage |
Verwendete Eingangsdaten
| has_readme | ja |
| has_license | ja |
| has_contributing | nein |
| has_issue_template | nein |
| has_code_of_conduct | nein |
| has_pull_request_template | ja |
Ökosystem-Verbreitung (Downloads)
100Exzellent
Wie die Bewertung erfolgt
| 80/80 | Downloads pro Monat — 78.552.830 Downloads/Monat über pypi |
| 0/20 | Abhängige in der Registry — von diesem Ökosystem nicht ausgewiesen |
Verwendete Eingangsdaten
| packages | snowflake-sqlalchemy |
| dependents | — |
| ecosystems | pypi |
| total_downloads | — |
| monthly_downloads | 78.552.830 |
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): Abhängige in der Registry. Die verbleibenden Gewichte wurden renormalisiert.
Nachhaltigkeit & Governance
Überdauert das Projekt die Menschen, die es tragen — Bus-Faktor, Reaktionsfähigkeit, Trägerschaft und Paketpflege?
82
Wie die Bewertung erfolgt
| 36/54 | Bus-Faktor — 3 Beitragende decken die Hälfte aller Commits ab |
| 16.1/22.5 | Commit-Verteilung — wichtigste beitragende Person verfasste 29 % der Commits |
| 13.5/13.5 | Breite der Beitragenden — 54 Beitragende |
| 6/10 | OpenSSF Scorecard: Contributors — project has 2 contributing companies or organizations -- score normalized to 6 |
Verwendete Eingangsdaten
| bus_factor | 3 |
| contributors_sampled | 54 |
| top_contributor_share | 0,286 |
Wie die Bewertung erfolgt
| 39.6/46.8 | Issue-Lösungsquote — 85 % der Issues geschlossen |
| 29.3/38.3 | PR-Annahme — 319/417 entschiedene PRs gemergt |
| 15/15 | OpenSSF Scorecard: Code-Review — all changesets reviewed |
Verwendete Eingangsdaten
| merged_prs | 319 |
| open_issues | 41 |
| closed_issues | 229 |
| issue_closed_ratio | 0,848 |
| closed_unmerged_prs | 98 |
Wie die Bewertung erfolgt
| 30/30 | Organisatorische Trägerschaft — im Besitz einer Organisation |
| 0/20 | Verifizierte Domain |
| 23.1/25 | Reichweite des Inhabers — 1.616 Follower von snowflakedb |
| 25/25 | Kontohistorie — 63 öffentliche Repos, Kontoalter ca. 12 Jahre |
Verwendete Eingangsdaten
| followers | 1.616 |
| owner_type | Organization |
| is_verified | — |
| owner_login | snowflakedb |
| public_repos | 63 |
| account_age_days | 4.564 |
Paketpflege
100Exzellent
Wie die Bewertung erfolgt
| 25/25 | Veröffentlicht & auflösbar — 1 Paket(e) auf pypi |
| 35/35 | Veröffentlichungsaktualität — letzte Veröffentlichung vor 12 Tagen |
| 20/20 | Versionshistorie — 59 veröffentlichte Versionen |
| 20/20 | Nicht veraltet — aktiv, nicht veraltet oder zurückgezogen |
Verwendete Eingangsdaten
| packages | snowflake-sqlalchemy |
| ecosystems | pypi |
| any_deprecated | nein |
| min_days_since_publish | 12 |
Engineering-Qualität
Sind grundlegende Engineering- und Dokumentationspraktiken vorhanden?
70
Wie die Bewertung erfolgt
| 24/24 | CI-Workflows — 7 Workflow(s) |
| 24/24 | Tests vorhanden |
| 16/16 | Linter-Konfiguration — tox.ini |
| 9.6/9.6 | Pre-Commit-Hooks |
| 0/6.4 | .editorconfig |
| 0/20 | OpenSSF Scorecard: CI-Tests — 1 out of 27 merged PRs checked by a CI test -- score normalized to 0 |
Verwendete Eingangsdaten
| has_ci | ja |
| has_tests | ja |
| has_editorconfig | nein |
| has_linter_config | ja |
| has_precommit_config | ja |
Dokumentation
65Mittel
Wie die Bewertung erfolgt
| 30/30 | README |
| 0/25 | Dokumentationsverzeichnis |
| 15/15 | Dokumentations-/Homepage-Site — https://pypi.python.org/pypi/snowflake-sqlalchemy/ |
| 10/10 | Repository-Beschreibung |
| 10/10 | Topics — 3 Topics |
| 0/10 | Wiki |
Verwendete Eingangsdaten
| topics | python, database, sql |
| has_wiki | nein |
| homepage | https://pypi.python.org/pypi/snowflake-sqlalchemy/ |
| has_readme | ja |
| has_docs_dir | nein |
| has_description | ja |
Sicherheit
Sind die sichtbaren Sicherheits- und Lieferkettenpraktiken belastbar, ohne ungeklärte Exposition gegenüber Hochrisikojurisdiktionen?
71
Sicherheitslage
64Mittel
Wie die Bewertung erfolgt
| 7.5/7.5 | Binary-Artifacts — no binaries found in the repo |
| 4.5/7.5 | Branch-Protection — branch protection is not maximal on development and all release branches |
| 0/2.5 | CI-Tests — 1 out of 27 merged PRs checked by a CI test -- score normalized to 0 |
| 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 |
| 1.5/2.5 | Contributors — project has 2 contributing companies or organizations -- score normalized to 6 |
| 10/10 | Dangerous-Workflow — no 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 | Lizenz — license file detected |
| 7.5/7.5 | Maintained — 30 commit(s) and 2 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 |
| 0/5 | SAST — SAST tool is not run on all commits -- score normalized to 0 |
| 0/5 | Security-Policy — security policy file not detected |
| 6/7.5 | Signed-Releases — 5 out of the last 5 releases have a total of 5 signed artifacts. |
| 0/7.5 | Token-Permissions — detected GitHub workflow tokens with excessive permissions |
| 7.5/7.5 | Vulnerabilities — 0 existing vulnerabilities detected |
Verwendete Eingangsdaten
| source | openssf_scorecard |
| checks_evaluated | 18 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 0 |
| scorecard_aggregate | 6,4 |
Abhängigkeits-Advisories
100Exzellent
Wie die Bewertung erfolgt
| 35/35 | Direkte Abhängigkeiten ohne bekannte Advisories — keine direkte Abhängigkeit trägt ein bekanntes Advisory |
| 25/25 | Indirekte Abhängigkeiten ohne bekannte Advisories — keine indirekte Abhängigkeit trägt ein bekanntes Advisory |
| 0/40 | Keine offenen Advisories — kein Advisory trägt ein Veröffentlichungsdatum |
Verwendete Eingangsdaten
| source | osv |
| advisories | 0 |
| affected_packages | 0 |
| assessed_packages | 10 |
| unassessed_packages | 0 |
| affected_by_severity | none |
| direct_affected_packages | 0 |
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): Keine offenen Advisories. Die verbleibenden Gewichte wurden renormalisiert. Abgeglichen wurde die Laufzeit-Abhängigkeitshülle von pypi:snowflake-sqlalchemy@1.11.0 — das, was die Installation des veröffentlichten Pakets nach sich zieht — mit 10 Paketen. Erreichbarkeit wird nicht analysiert.
AI Readiness
Wie gut ist das Repository dafür ausgestattet, mit KI-Coding-Agenten entwickelt und gepflegt zu werden? Ein unabhängiges, experimentelles Badge — Gewicht 0,0, es wird eigenständig ausgewiesen und verändert den Gesamt-Gesundheitswert nicht.
46
AI-Agentenkontext & Leitlinien
1Kritisch
Wie die Bewertung erfolgt
| 0/45 | Agentenanweisungen — keine CLAUDE.md / AGENTS.md / Editor-Regeln |
| 0/15 | Maschinenlesbare Doku (llms.txt) |
| 0/40 | Lesbare Commit-Historie — keine Daten |
Verwendete Eingangsdaten
| has_llms_txt | nein |
| legible_history_share | — |
| agent_instruction_files | — |
| agent_instruction_max_bytes | — |
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): Lesbare Commit-Historie. Die verbleibenden Gewichte wurden renormalisiert.
Wie die Bewertung erfolgt
| 0/18 | Bootstrap mit einem Befehl |
| 22/22 | Automatisierte Tests |
| 11/11 | Lint-/Format-Konfiguration — tox.ini |
| 11/11 | Statische Typprüfung — src/snowflake/sqlalchemy/py.typed |
| 10/10 | Reproduzierbare Umgebung — Dockerfile |
| 0/10 | Belegte Agentenpraxis — keine Daten |
| 5/8 | Automatisierte Wartung — Abhängigkeits-Automatisierung konfiguriert, in den erfassten Commits nicht beobachtet |
| 0/10 | OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
Verwendete Eingangsdaten
| has_nix | nein |
| has_tests | ja |
| lockfiles | — |
| has_dockerfile | ja |
| typed_language | nein |
| bootstrap_files | — |
| has_devcontainer | nein |
| has_linter_config | ja |
| typecheck_configs | src/snowflake/sqlalchemy/py.typed |
| agent_commit_share | — |
| toolchain_manifests | — |
| dependency_bot_commit_share | 0 |
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): Belegte Agentenpraxis. Die verbleibenden Gewichte wurden renormalisiert.
Wie die Bewertung erfolgt
| 27/45 | Typprüfbarer Code — Python mit Typprüfungs-Konfiguration (src/snowflake/sqlalchemy/py.typed) |
| 53.4/55 | Handhabbare Dateigrößen — 3/104 Quelldateien über 60 KB |
Verwendete Eingangsdaten
| primary_language | Python |
| largest_source_bytes | 86.986 |
| source_files_sampled | 104 |
| oversized_source_files | 3 |
Eckdaten
268GitHub-Sterne
54Mitwirkende
82Commits, letzte 12 Monate
4Tage seit letztem Push
51Releases
3Bus-Faktor
41offene Issues
PyPIPaket-Ökosysteme
Weitere Details
Stern- und Fork-Verlauf 268 ★ / 0 ⇿
268Sterne
Wann jeder Stern und Fork hinzugefügt wurde, von GitHub erfasst und nach Tagen gruppiert. Das kumulierte Wachstum steht direkt über den täglichen Zugängen, aus denen es besteht, sodass beide gegeneinander lesbar sind: stetiger organischer Zuwachs sieht ganz anders aus als ein abrupter, kurzlebiger Ausschlag. Wo dieser Unterschied messbar ist, wird er als Wachstumsauthentizität ausgewiesen.
Es wird nur die jüngste Historie angezeigt — dieses Repository überschreitet das Erfassungsfenster, sodass die früheste Historie nicht erfasst wird.
Jeder Punkt umfasst 9 Tage.
OpenSSF Scorecard 6.4 / 10
6.4Gesamtwert
Unabhängige, werkzeugneutrale Sicherheitsbewertung durch das quelloffene OpenSSF Scorecard. Jede Prüfung honoriert eine Sicherheits-Praxis, nicht das Werkzeug eines bestimmten Anbieters. Prüfungen, die Scorecard nicht ermitteln konnte, sind mit k. A. markiert und vom Sicherheitswert ausgeschlossen (nie als null gezählt).
| 10 | Binary-Artifacts | no binaries found in the repo |
| 6 | Branch-Protection | branch protection is not maximal on development and all release branches |
| 0 | CI-Tests | 1 out of 27 merged PRs checked by a CI test -- score normalized to 0 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 10 | Code-Review | all changesets reviewed |
| 6 | Contributors | project has 2 contributing companies or organizations -- score normalized to 6 |
| 10 | Dangerous-Workflow | no 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 2 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 |
| 0 | SAST | SAST tool is not run on all commits -- score normalized to 0 |
| 0 | Security-Policy | security policy file not detected |
| 8 | Signed-Releases | 5 out of the last 5 releases have a total of 5 signed artifacts. |
| 0 | Token-Permissions | detected GitHub workflow tokens with excessive permissions |
| 10 | Vulnerabilities | 0 existing vulnerabilities detected |
Direkte Abhängigkeiten 2
| Registry | Paket | Versionsvorgabe | Manifest |
|---|---|---|---|
| PyPI | SQLAlchemy | >=2.0.0 | pyproject.toml |
| PyPI | snowflake-connector-python | <5.0.0 | pyproject.toml |
Alle Abhängigkeiten 3
Vollständig aufgelöster Abhängigkeitssatz aus dem GitHub-Abhängigkeitsgraphen: 2 direkte und 1 indirekte (transitive) Pakete. Die transitive Hülle ist vollständig, wenn das Repository eine Lockfile eincheckt.
| Registry | Paket | Version | Beziehung |
|---|---|---|---|
| PyPI | snowflake-connector-python | — | direkt |
| PyPI | sqlalchemy | — | direkt |
| PyPI | mypy | — | indirekt |
Abhängigkeits-Advisories 0
Die Installation von pypi:snowflake-sqlalchemy@1.11.0 zieht 10 Pakete nach sich, direkt und transitiv: 0 tragen bekannte Advisories, davon 0 direkte Abhängigkeiten.
Keine bekannten Advisories betreffen die bewerteten Abhängigkeiten.
Ein Advisory bedeutet, dass die im Abhängigkeitsgraphen erfasste Version in den betroffenen Bereich eines Advisories fällt. Erreichbarkeit wird nicht analysiert, und der Graph enthält Entwicklungs- und Test-Pins — ein Fund kann das Werkzeug betreffen und nicht die ausgelieferte Software.
JSON-Rohbericht maschinenlesbar
{
"data": {
"repo": {
"topics": [
"python",
"database",
"sql"
],
"is_fork": false,
"size_kb": 1938,
"has_wiki": false,
"homepage": "https://pypi.python.org/pypi/snowflake-sqlalchemy/",
"languages": {
"Shell": 6663,
"Python": 864821,
"Dockerfile": 1029
},
"pushed_at": "2026-07-16T12:32:03Z",
"created_at": "2016-06-18T23:52:24Z",
"owner_type": "Organization",
"updated_at": "2026-07-15T14:54:31Z",
"description": "Snowflake SQLAlchemy",
"is_archived": false,
"is_disabled": false,
"license_spdx": "Apache-2.0",
"default_branch": "main",
"license_spdx_raw": "Apache-2.0",
"primary_language": "Python",
"significant_languages": [
"Python"
]
},
"owner": {
"blog": "https://snowflake.com",
"name": "Snowflake",
"type": "Organization",
"login": "snowflakedb",
"company": null,
"location": "In the ☁",
"followers": 1616,
"avatar_url": "https://avatars.githubusercontent.com/u/6453780?v=4",
"created_at": "2014-01-20T19:36:18Z",
"is_verified": null,
"public_repos": 63,
"account_age_days": 4564
},
"license": {
"state": "standard",
"spdx_id": "Apache-2.0",
"raw_spdx": "Apache-2.0",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases_count": 51,
"commits_last_year": 82,
"latest_release_at": "2026-07-16T12:32:03Z",
"latest_release_tag": "v2.0.0a0",
"releases_from_tags": false,
"days_since_last_push": 4,
"active_weeks_last_year": 31,
"days_since_latest_release": 4,
"mean_days_between_releases": 41.3
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": false,
"health_percentage": 50,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": true
},
"ecosystem": {
"packages": [
{
"name": "snowflake-sqlalchemy",
"exists": true,
"license": "Apache-2.0",
"keywords": [
"Snowflake",
"analytics",
"cloud",
"database",
"db",
"warehouse",
"Development Status :: 5 - Production/Stable",
"Environment :: Console",
"Environment :: Other Environment",
"Intended Audience :: Developers",
"Intended Audience :: Education",
"Intended Audience :: Information Technology",
"Intended Audience :: System Administrators",
"License :: OSI Approved :: Apache Software License",
"Operating System :: OS Independent",
"Programming Language :: Python :: 3",
"Programming Language :: Python :: 3 :: Only",
"Programming Language :: Python :: 3.10",
"Programming Language :: Python :: 3.11",
"Programming Language :: Python :: 3.12",
"Programming Language :: Python :: 3.13",
"Programming Language :: Python :: 3.8",
"Programming Language :: Python :: 3.9",
"Programming Language :: SQL",
"Topic :: Database",
"Topic :: Scientific/Engineering :: Information Analysis",
"Topic :: Software Development",
"Topic :: Software Development :: Libraries",
"Topic :: Software Development :: Libraries :: Application Frameworks",
"Topic :: Software Development :: Libraries :: Python Modules"
],
"ecosystem": "pypi",
"matches_repo": true,
"registry_url": "https://pypi.org/project/snowflake-sqlalchemy/",
"is_deprecated": false,
"latest_version": "1.11.0",
"repository_url": "https://github.com/snowflakedb/snowflake-sqlalchemy",
"versions_count": 59,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": 78552830,
"first_published_at": "2017-05-18T18:08:43.342064Z",
"latest_published_at": "2026-07-08T08:53:39.248945Z",
"latest_version_yanked": null,
"days_since_latest_publish": 12
}
]
},
"popularity": {
"forks": 169,
"stars": 268,
"watchers": 20,
"star_history": {
"days": [
{
"date": "2016-12-05",
"count": 1
},
{
"date": "2017-09-06",
"count": 1
},
{
"date": "2017-10-17",
"count": 1
},
{
"date": "2017-12-20",
"count": 1
},
{
"date": "2018-01-07",
"count": 1
},
{
"date": "2018-03-13",
"count": 1
},
{
"date": "2018-03-16",
"count": 1
},
{
"date": "2018-03-27",
"count": 1
},
{
"date": "2018-05-07",
"count": 1
},
{
"date": "2018-07-02",
"count": 1
},
{
"date": "2018-11-21",
"count": 1
},
{
"date": "2018-11-23",
"count": 1
},
{
"date": "2018-12-10",
"count": 1
},
{
"date": "2018-12-14",
"count": 1
},
{
"date": "2019-01-15",
"count": 1
},
{
"date": "2019-02-13",
"count": 1
},
{
"date": "2019-03-04",
"count": 1
},
{
"date": "2019-03-06",
"count": 1
},
{
"date": "2019-03-18",
"count": 1
},
{
"date": "2019-04-08",
"count": 1
},
{
"date": "2019-04-24",
"count": 1
},
{
"date": "2019-05-06",
"count": 1
},
{
"date": "2019-05-08",
"count": 2
},
{
"date": "2019-05-17",
"count": 1
},
{
"date": "2019-06-10",
"count": 1
},
{
"date": "2019-07-03",
"count": 1
},
{
"date": "2019-08-01",
"count": 1
},
{
"date": "2019-08-12",
"count": 1
},
{
"date": "2019-09-27",
"count": 1
},
{
"date": "2019-10-08",
"count": 1
},
{
"date": "2019-10-30",
"count": 1
},
{
"date": "2019-11-12",
"count": 1
},
{
"date": "2019-11-25",
"count": 1
},
{
"date": "2019-12-11",
"count": 1
},
{
"date": "2020-01-15",
"count": 1
},
{
"date": "2020-01-16",
"count": 1
},
{
"date": "2020-01-24",
"count": 1
},
{
"date": "2020-02-06",
"count": 1
},
{
"date": "2020-02-14",
"count": 1
},
{
"date": "2020-02-19",
"count": 1
},
{
"date": "2020-03-17",
"count": 2
},
{
"date": "2020-04-09",
"count": 1
},
{
"date": "2020-04-13",
"count": 2
},
{
"date": "2020-04-16",
"count": 1
},
{
"date": "2020-04-18",
"count": 1
},
{
"date": "2020-04-20",
"count": 1
},
{
"date": "2020-05-03",
"count": 1
},
{
"date": "2020-05-06",
"count": 1
},
{
"date": "2020-07-22",
"count": 1
},
{
"date": "2020-09-01",
"count": 1
},
{
"date": "2020-09-11",
"count": 1
},
{
"date": "2020-09-27",
"count": 1
},
{
"date": "2020-10-01",
"count": 1
},
{
"date": "2020-10-14",
"count": 1
},
{
"date": "2020-10-15",
"count": 2
},
{
"date": "2020-10-21",
"count": 1
},
{
"date": "2020-11-01",
"count": 1
},
{
"date": "2020-11-12",
"count": 1
},
{
"date": "2020-11-20",
"count": 1
},
{
"date": "2020-11-24",
"count": 1
},
{
"date": "2020-12-01",
"count": 1
},
{
"date": "2020-12-15",
"count": 1
},
{
"date": "2021-01-12",
"count": 1
},
{
"date": "2021-01-19",
"count": 1
},
{
"date": "2021-02-02",
"count": 1
},
{
"date": "2021-02-03",
"count": 1
},
{
"date": "2021-02-05",
"count": 1
},
{
"date": "2021-02-09",
"count": 1
},
{
"date": "2021-02-18",
"count": 1
},
{
"date": "2021-03-05",
"count": 1
},
{
"date": "2021-03-10",
"count": 1
},
{
"date": "2021-03-14",
"count": 1
},
{
"date": "2021-04-09",
"count": 2
},
{
"date": "2021-04-15",
"count": 1
},
{
"date": "2021-04-27",
"count": 1
},
{
"date": "2021-05-17",
"count": 1
},
{
"date": "2021-05-21",
"count": 1
},
{
"date": "2021-06-24",
"count": 1
},
{
"date": "2021-07-12",
"count": 1
},
{
"date": "2021-07-23",
"count": 1
},
{
"date": "2021-08-09",
"count": 1
},
{
"date": "2021-08-19",
"count": 2
},
{
"date": "2021-09-13",
"count": 1
},
{
"date": "2021-09-15",
"count": 1
},
{
"date": "2021-09-16",
"count": 1
},
{
"date": "2021-09-29",
"count": 1
},
{
"date": "2021-10-13",
"count": 1
},
{
"date": "2021-10-19",
"count": 1
},
{
"date": "2021-11-09",
"count": 1
},
{
"date": "2021-11-11",
"count": 1
},
{
"date": "2021-12-03",
"count": 1
},
{
"date": "2021-12-05",
"count": 1
},
{
"date": "2021-12-30",
"count": 1
},
{
"date": "2022-01-05",
"count": 1
},
{
"date": "2022-01-25",
"count": 2
},
{
"date": "2022-02-02",
"count": 1
},
{
"date": "2022-02-03",
"count": 1
},
{
"date": "2022-02-21",
"count": 1
},
{
"date": "2022-02-28",
"count": 1
},
{
"date": "2022-03-01",
"count": 1
},
{
"date": "2022-03-28",
"count": 1
},
{
"date": "2022-03-31",
"count": 1
},
{
"date": "2022-05-06",
"count": 1
},
{
"date": "2022-05-07",
"count": 1
},
{
"date": "2022-05-09",
"count": 1
},
{
"date": "2022-05-18",
"count": 1
},
{
"date": "2022-05-25",
"count": 1
},
{
"date": "2022-05-30",
"count": 1
},
{
"date": "2022-06-10",
"count": 1
},
{
"date": "2022-06-12",
"count": 1
},
{
"date": "2022-06-16",
"count": 1
},
{
"date": "2022-06-19",
"count": 1
},
{
"date": "2022-07-04",
"count": 1
},
{
"date": "2022-07-06",
"count": 1
},
{
"date": "2022-07-10",
"count": 1
},
{
"date": "2022-07-18",
"count": 2
},
{
"date": "2022-07-22",
"count": 1
},
{
"date": "2022-07-28",
"count": 1
},
{
"date": "2022-08-18",
"count": 1
},
{
"date": "2022-08-26",
"count": 1
},
{
"date": "2022-09-11",
"count": 1
},
{
"date": "2022-09-18",
"count": 1
},
{
"date": "2022-09-19",
"count": 1
},
{
"date": "2022-09-21",
"count": 1
},
{
"date": "2022-09-25",
"count": 1
},
{
"date": "2022-10-05",
"count": 1
},
{
"date": "2022-10-17",
"count": 1
},
{
"date": "2022-10-18",
"count": 1
},
{
"date": "2022-10-26",
"count": 1
},
{
"date": "2022-11-10",
"count": 1
},
{
"date": "2022-11-28",
"count": 2
},
{
"date": "2022-12-22",
"count": 2
},
{
"date": "2022-12-26",
"count": 1
},
{
"date": "2023-01-04",
"count": 1
},
{
"date": "2023-01-09",
"count": 1
},
{
"date": "2023-01-11",
"count": 1
},
{
"date": "2023-01-21",
"count": 1
},
{
"date": "2023-01-30",
"count": 1
},
{
"date": "2023-02-01",
"count": 1
},
{
"date": "2023-02-03",
"count": 2
},
{
"date": "2023-02-16",
"count": 1
},
{
"date": "2023-03-02",
"count": 1
},
{
"date": "2023-03-06",
"count": 1
},
{
"date": "2023-03-23",
"count": 1
},
{
"date": "2023-03-27",
"count": 2
},
{
"date": "2023-03-30",
"count": 1
},
{
"date": "2023-04-13",
"count": 1
},
{
"date": "2023-04-18",
"count": 1
},
{
"date": "2023-04-20",
"count": 2
},
{
"date": "2023-04-21",
"count": 1
},
{
"date": "2023-04-24",
"count": 2
},
{
"date": "2023-04-28",
"count": 1
},
{
"date": "2023-05-15",
"count": 1
},
{
"date": "2023-05-25",
"count": 1
},
{
"date": "2023-05-27",
"count": 1
},
{
"date": "2023-06-01",
"count": 1
},
{
"date": "2023-06-08",
"count": 1
},
{
"date": "2023-06-12",
"count": 1
},
{
"date": "2023-06-27",
"count": 1
},
{
"date": "2023-07-10",
"count": 2
},
{
"date": "2023-07-13",
"count": 1
},
{
"date": "2023-07-16",
"count": 1
},
{
"date": "2023-07-19",
"count": 2
},
{
"date": "2023-07-21",
"count": 1
},
{
"date": "2023-07-28",
"count": 2
},
{
"date": "2023-08-10",
"count": 1
},
{
"date": "2023-08-16",
"count": 1
},
{
"date": "2023-08-18",
"count": 1
},
{
"date": "2023-08-29",
"count": 1
},
{
"date": "2023-09-01",
"count": 1
},
{
"date": "2023-09-07",
"count": 1
},
{
"date": "2023-09-11",
"count": 1
},
{
"date": "2023-09-14",
"count": 1
},
{
"date": "2023-09-20",
"count": 1
},
{
"date": "2023-09-21",
"count": 1
},
{
"date": "2023-12-14",
"count": 1
},
{
"date": "2024-01-07",
"count": 1
},
{
"date": "2024-01-08",
"count": 1
},
{
"date": "2024-01-09",
"count": 1
},
{
"date": "2024-01-18",
"count": 1
},
{
"date": "2024-01-24",
"count": 1
},
{
"date": "2024-01-29",
"count": 1
},
{
"date": "2024-02-14",
"count": 1
},
{
"date": "2024-02-28",
"count": 1
},
{
"date": "2024-03-01",
"count": 1
},
{
"date": "2024-03-12",
"count": 1
},
{
"date": "2024-03-14",
"count": 1
},
{
"date": "2024-03-15",
"count": 1
},
{
"date": "2024-03-16",
"count": 1
},
{
"date": "2024-03-17",
"count": 1
},
{
"date": "2024-04-08",
"count": 1
},
{
"date": "2024-04-11",
"count": 1
},
{
"date": "2024-04-16",
"count": 1
},
{
"date": "2024-04-25",
"count": 1
},
{
"date": "2024-05-16",
"count": 1
},
{
"date": "2024-05-23",
"count": 3
},
{
"date": "2024-05-28",
"count": 1
},
{
"date": "2024-06-10",
"count": 1
},
{
"date": "2024-06-11",
"count": 1
},
{
"date": "2024-06-17",
"count": 1
},
{
"date": "2024-06-21",
"count": 1
},
{
"date": "2024-07-01",
"count": 1
},
{
"date": "2024-07-11",
"count": 1
},
{
"date": "2024-07-13",
"count": 1
},
{
"date": "2024-07-26",
"count": 1
},
{
"date": "2024-07-27",
"count": 1
},
{
"date": "2024-08-08",
"count": 1
},
{
"date": "2024-08-14",
"count": 1
},
{
"date": "2024-10-05",
"count": 1
},
{
"date": "2024-11-02",
"count": 1
},
{
"date": "2024-11-22",
"count": 1
},
{
"date": "2024-11-26",
"count": 1
},
{
"date": "2024-12-02",
"count": 1
},
{
"date": "2024-12-03",
"count": 1
},
{
"date": "2024-12-05",
"count": 1
},
{
"date": "2024-12-23",
"count": 1
},
{
"date": "2024-12-24",
"count": 1
},
{
"date": "2025-01-11",
"count": 1
},
{
"date": "2025-01-22",
"count": 1
},
{
"date": "2025-02-03",
"count": 1
},
{
"date": "2025-02-10",
"count": 1
},
{
"date": "2025-02-13",
"count": 1
},
{
"date": "2025-03-17",
"count": 1
},
{
"date": "2025-04-17",
"count": 1
},
{
"date": "2025-04-30",
"count": 1
},
{
"date": "2025-05-29",
"count": 1
},
{
"date": "2025-07-20",
"count": 1
},
{
"date": "2025-07-23",
"count": 1
},
{
"date": "2025-07-29",
"count": 1
},
{
"date": "2025-08-15",
"count": 1
},
{
"date": "2025-08-16",
"count": 1
},
{
"date": "2025-08-17",
"count": 1
},
{
"date": "2025-08-21",
"count": 1
},
{
"date": "2025-08-29",
"count": 1
},
{
"date": "2025-09-04",
"count": 1
},
{
"date": "2025-09-21",
"count": 1
},
{
"date": "2025-09-29",
"count": 1
},
{
"date": "2025-10-10",
"count": 1
},
{
"date": "2025-11-20",
"count": 1
},
{
"date": "2025-12-03",
"count": 1
},
{
"date": "2025-12-09",
"count": 1
},
{
"date": "2026-02-04",
"count": 1
},
{
"date": "2026-02-18",
"count": 1
},
{
"date": "2026-04-09",
"count": 1
},
{
"date": "2026-04-24",
"count": 1
},
{
"date": "2026-04-27",
"count": 1
},
{
"date": "2026-05-10",
"count": 1
},
{
"date": "2026-05-15",
"count": 1
}
],
"complete": false,
"collected": 267,
"total_stars": 268
},
"open_issues_and_prs": 73
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": true,
"has_mcp_signal": false,
"bootstrap_files": [],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [
"src/snowflake/sqlalchemy/py.typed"
],
"largest_source_bytes": 86986,
"source_files_sampled": 104,
"oversized_source_files": 3,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"dependencies": {
"manifests": [
"pyproject.toml",
"setup.cfg",
"snyk/requirements.txt"
],
"advisories": {
"error": null,
"scope": "published_package",
"source": "osv",
"findings": [],
"collected": true,
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 10,
"assessed_package": "pypi:snowflake-sqlalchemy@1.11.0",
"unassessed_count": 0,
"direct_affected_count": 0
},
"ecosystems": [
"pypi"
],
"dependencies": [
{
"name": "SQLAlchemy",
"manifest": "pyproject.toml",
"ecosystem": "pypi",
"version_constraint": ">=2.0.0"
},
{
"name": "snowflake-connector-python",
"manifest": "pyproject.toml",
"ecosystem": "pypi",
"version_constraint": "<5.0.0"
}
],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "snowflake-connector-python",
"direct": true,
"version": null,
"ecosystem": "pypi"
},
{
"name": "sqlalchemy",
"direct": true,
"version": null,
"ecosystem": "pypi"
},
{
"name": "mypy",
"direct": false,
"version": null,
"ecosystem": "pypi"
}
],
"collected": true,
"truncated": false,
"total_count": 3,
"direct_count": 2,
"indirect_count": 1
}
},
"maintainership": {
"issues": {
"open_prs": 32,
"merged_prs": 319,
"open_issues": 41,
"closed_ratio": 0.848,
"closed_issues": 229,
"closed_unmerged_prs": 98
},
"bus_factor": 3,
"top_contributors": [
{
"type": "User",
"login": "smtakeda",
"commits": 128,
"avatar_url": "https://avatars.githubusercontent.com/u/169573?v=4"
},
{
"type": "User",
"login": "sfc-gh-mraba",
"commits": 69,
"avatar_url": "https://avatars.githubusercontent.com/u/152898938?v=4"
},
{
"type": "User",
"login": "sfc-gh-stakeda",
"commits": 50,
"avatar_url": "https://avatars.githubusercontent.com/u/20942173?v=4"
},
{
"type": "User",
"login": "sfc-gh-aling",
"commits": 38,
"avatar_url": "https://avatars.githubusercontent.com/u/104799010?v=4"
},
{
"type": "User",
"login": "sfc-gh-mkeller",
"commits": 31,
"avatar_url": "https://avatars.githubusercontent.com/u/63477823?v=4"
},
{
"type": "User",
"login": "sfc-gh-jvasquezrojas",
"commits": 30,
"avatar_url": "https://avatars.githubusercontent.com/u/127370564?v=4"
},
{
"type": "User",
"login": "sfc-gh-jcieslak",
"commits": 22,
"avatar_url": "https://avatars.githubusercontent.com/u/138496486?v=4"
},
{
"type": "User",
"login": "sfc-gh-ogarciabarquero",
"commits": 7,
"avatar_url": "https://avatars.githubusercontent.com/u/127251112?v=4"
},
{
"type": "User",
"login": "sfc-gh-kdama",
"commits": 5,
"avatar_url": "https://avatars.githubusercontent.com/u/69480841?v=4"
},
{
"type": "User",
"login": "sfc-gh-abhatnagar",
"commits": 5,
"avatar_url": "https://avatars.githubusercontent.com/u/47045764?v=4"
}
],
"contributors_sampled": 54,
"top_contributor_share": 0.286
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"build_test.yml",
"changelog.yml",
"cla_bot.yml",
"create_req_files.yml",
"jira-issue.yml",
"python-publish.yml",
"semgrep.yml"
],
"has_docs_dir": false,
"linter_configs": [
"tox.ini"
],
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": true
},
"security_signals": {
"lockfiles": [],
"scorecard": {
"checks": [
{
"name": "Binary-Artifacts",
"score": 10,
"reason": "no binaries found in the repo",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
},
{
"name": "Branch-Protection",
"score": 6,
"reason": "branch protection is not maximal on development and all release branches",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 0,
"reason": "1 out of 27 merged PRs checked by a CI test -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
},
{
"name": "CII-Best-Practices",
"score": 0,
"reason": "no effort to earn an OpenSSF best practices badge detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
},
{
"name": "Code-Review",
"score": 10,
"reason": "all changesets reviewed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 6,
"reason": "project has 2 contributing companies or organizations -- score normalized to 6",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": 10,
"reason": "no dangerous workflow patterns detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 10,
"reason": "update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 10,
"reason": "30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
},
{
"name": "Packaging",
"score": 10,
"reason": "packaging workflow detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
},
{
"name": "Pinned-Dependencies",
"score": 0,
"reason": "dependency not pinned by hash detected -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
},
{
"name": "SAST",
"score": 0,
"reason": "SAST tool is not run on all commits -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
},
{
"name": "Security-Policy",
"score": 0,
"reason": "security policy file not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
},
{
"name": "Signed-Releases",
"score": 8,
"reason": "5 out of the last 5 releases have a total of 5 signed artifacts.",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
},
{
"name": "Token-Permissions",
"score": 0,
"reason": "detected GitHub workflow tokens with excessive permissions",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
},
{
"name": "Vulnerabilities",
"score": 10,
"reason": "0 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "054fa7fe6e9fa311d95e54cf3920760202b5ce2e",
"ran_at": "2026-07-21T03:38:06Z",
"aggregate_score": 6.4,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": false,
"has_dependabot_config": true
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/snowflakedb/snowflake-sqlalchemy",
"host": "github.com",
"name": "snowflake-sqlalchemy",
"owner": "snowflakedb"
},
"metrics": {
"overall": {
"key": "overall",
"band": "good",
"name": "Overall health",
"note": null,
"notes": [],
"value": 78,
"inputs": {
"security": 71,
"vitality": 90,
"community": 71,
"governance": 82,
"engineering": 70
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "excellent",
"name": "Vitality",
"value": 90,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "excellent",
"name": "Development activity",
"note": null,
"notes": [],
"value": 85,
"inputs": {
"commits_last_year": 82,
"human_commit_share": null,
"days_since_last_push": 4,
"active_weeks_last_year": 31
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 4 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "push_recency",
"params": {
"days": 4
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "31/52 weeks with commits",
"points": 21.5,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 31
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "82 commits in the last year",
"points": 17.2,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 82
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "excellent",
"name": "Release discipline",
"note": null,
"notes": [],
"value": 98,
"inputs": {
"releases_count": 51,
"latest_release_tag": "v2.0.0a0",
"releases_from_tags": false,
"days_since_latest_release": 4,
"mean_days_between_releases": 41.3
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "51 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 51
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 4 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "release_recency",
"params": {
"days": 4
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~41.3 days",
"points": 27,
"status": "met",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 41.3
}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "5 out of the last 5 releases have a total of 5 signed artifacts.",
"points": 8,
"status": "partial",
"details": [],
"max_points": 10
}
]
},
{
"key": "abandonment",
"band": "excellent",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"cap": null,
"state": "unverified",
"guards": [],
"signals": [],
"red_flag": false,
"multiplier_pct": 100,
"declared_reason": null,
"unverified_reason": "no_commit_sample",
"unanswered_open_prs": null,
"unanswered_open_issues": null,
"days_since_last_merged_pr": null,
"days_since_last_human_commit": null,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "maintenance record not established from the collected data",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_unverified",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "good",
"name": "Community & Adoption",
"value": 71,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "moderate",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 65,
"inputs": {
"forks": 169,
"stars": 268,
"watchers": 20,
"growth_state": "organic",
"growth_factor_pct": 100
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "268 stars",
"points": 39.4,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 268
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "169 forks",
"points": 18.5,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 169
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "20 watchers",
"points": 7.1,
"status": "partial",
"details": [
{
"code": "watchers",
"params": {
"count": 20
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "moderate",
"name": "Community health",
"note": null,
"notes": [],
"value": 57,
"inputs": {
"has_readme": true,
"has_license": true,
"has_contributing": false,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": true
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 22.5,
"status": "met",
"details": [],
"max_points": 22.5
},
{
"key": "license",
"name": "License",
"detail": "recognized license (Apache-2.0)",
"points": 22.5,
"status": "met",
"details": [
{
"code": "license_standard",
"params": {}
},
{
"code": "license_spdx",
"params": {
"spdx": "Apache-2.0"
}
}
],
"max_points": 22.5
},
{
"key": "contributing_guide",
"name": "CONTRIBUTING guide",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 18
},
{
"key": "code_of_conduct",
"name": "Code of conduct",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 13.5
},
{
"key": "issue_template",
"name": "Issue template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.2
},
{
"key": "pr_template",
"name": "PR template",
"detail": null,
"points": 6.3,
"status": "met",
"details": [],
"max_points": 6.3
}
]
},
{
"key": "ecosystem_adoption",
"band": "excellent",
"name": "Ecosystem adoption (downloads)",
"note": "Excluded from scoring (no data or not applicable): Registry dependents. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"registry_dependents"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 100,
"inputs": {
"packages": [
"snowflake-sqlalchemy"
],
"dependents": null,
"ecosystems": "pypi",
"total_downloads": null,
"monthly_downloads": 78552830
},
"components": [
{
"key": "monthly_downloads",
"name": "Monthly downloads",
"detail": "78,552,830 downloads/month across pypi",
"points": 80,
"status": "met",
"details": [
{
"code": "downloads_monthly",
"params": {
"count": 78552830,
"ecosystems": "pypi"
}
}
],
"max_points": 80
},
{
"key": "registry_dependents",
"name": "Registry dependents",
"detail": "not reported by this ecosystem",
"points": 0,
"status": "excluded",
"details": [
{
"code": "not_reported_by_this_ecosystem",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "good",
"name": "Sustainability & Governance",
"value": 82,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "good",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 72,
"inputs": {
"bus_factor": 3,
"contributors_sampled": 54,
"top_contributor_share": 0.286
},
"components": [
{
"key": "bus_factor",
"name": "Bus factor",
"detail": "3 contributor(s) cover half of all commits",
"points": 36,
"status": "partial",
"details": [
{
"code": "bus_factor",
"params": {
"count": 3
}
}
],
"max_points": 54
},
{
"key": "commit_distribution",
"name": "Commit distribution",
"detail": "top contributor authored 29% of commits",
"points": 16.1,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 29
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "54 contributors",
"points": 13.5,
"status": "met",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 54
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 2 contributing companies or organizations -- score normalized to 6",
"points": 6,
"status": "partial",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "good",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 84,
"inputs": {
"merged_prs": 319,
"open_issues": 41,
"closed_issues": 229,
"issue_closed_ratio": 0.848,
"closed_unmerged_prs": 98
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "85% of issues closed",
"points": 39.6,
"status": "partial",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 85
}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "319/417 decided PRs merged",
"points": 29.3,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 319,
"decided": 417
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "all changesets reviewed",
"points": 15,
"status": "met",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "good",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 78,
"inputs": {
"followers": 1616,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "snowflakedb",
"public_repos": 63,
"account_age_days": 4564
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "organization-owned",
"points": 30,
"status": "met",
"details": [
{
"code": "owner_organization",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "1,616 followers of snowflakedb",
"points": 23.1,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 1616,
"login": "snowflakedb"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "63 public repos, account ~12 yr old",
"points": 25,
"status": "met",
"details": [
{
"code": "public_repos",
"params": {
"count": 63
}
},
{
"code": "account_age_years",
"params": {
"years": 12
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "excellent",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"snowflake-sqlalchemy"
],
"ecosystems": "pypi",
"any_deprecated": false,
"min_days_since_publish": 12
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "1 package(s) on pypi",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 1,
"ecosystems": "pypi"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 12 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 12
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "59 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 59
}
}
],
"max_points": 20
},
{
"key": "not_deprecated",
"name": "Not deprecated",
"detail": "active, not deprecated or yanked",
"points": 20,
"status": "met",
"details": [
{
"code": "package_not_deprecated",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "good",
"name": "Engineering Quality",
"value": 70,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "good",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 74,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": true
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "7 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 7
}
}
],
"max_points": 24
},
{
"key": "tests_present",
"name": "Tests present",
"detail": null,
"points": 24,
"status": "met",
"details": [],
"max_points": 24
},
{
"key": "linter_config",
"name": "Linter config",
"detail": "tox.ini",
"points": 16,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "tox.ini"
}
}
],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 9.6,
"status": "met",
"details": [],
"max_points": 9.6
},
{
"key": "editorconfig",
"name": ".editorconfig",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "1 out of 27 merged PRs checked by a CI test -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "moderate",
"name": "Documentation",
"note": null,
"notes": [],
"value": 65,
"inputs": {
"topics": [
"python",
"database",
"sql"
],
"has_wiki": false,
"homepage": "https://pypi.python.org/pypi/snowflake-sqlalchemy/",
"has_readme": true,
"has_docs_dir": false,
"has_description": true
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 30,
"status": "met",
"details": [],
"max_points": 30
},
{
"key": "documentation_directory",
"name": "Documentation directory",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": "https://pypi.python.org/pypi/snowflake-sqlalchemy/",
"points": 15,
"status": "met",
"details": [],
"max_points": 15
},
{
"key": "repository_description",
"name": "Repository description",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "topics",
"name": "Topics",
"detail": "3 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 3
}
}
],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "good",
"name": "Security",
"value": 71,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "moderate",
"name": "Security posture",
"note": null,
"notes": [],
"value": 64,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 18,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 0,
"scorecard_aggregate": 6.4
},
"components": [
{
"key": "binary_artifacts",
"name": "Binary-Artifacts",
"detail": "no binaries found in the repo",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "branch_protection",
"name": "Branch-Protection",
"detail": "branch protection is not maximal on development and all release branches",
"points": 4.5,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "1 out of 27 merged PRs checked by a CI test -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "cii_best_practices",
"name": "CII-Best-Practices",
"detail": "no effort to earn an OpenSSF best practices badge detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "code_review",
"name": "Code-Review",
"detail": "all changesets reviewed",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 2 contributing companies or organizations -- score normalized to 6",
"points": 1.5,
"status": "partial",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no dangerous workflow patterns detected",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "dependency_update_tool",
"name": "Dependency-Update-Tool",
"detail": "update tool detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow detected",
"points": 5,
"status": "met",
"details": [],
"max_points": 5
},
{
"key": "pinned_dependencies",
"name": "Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is not run on all commits -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "security_policy",
"name": "Security-Policy",
"detail": "security policy file not detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "signed_releases",
"name": "Signed-Releases",
"detail": "5 out of the last 5 releases have a total of 5 signed artifacts.",
"points": 6,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "token_permissions",
"name": "Token-Permissions",
"detail": "detected GitHub workflow tokens with excessive permissions",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "0 existing vulnerabilities detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "dependency_advisories",
"band": "excellent",
"name": "Dependency advisories",
"note": "Excluded from scoring (no data or not applicable): No advisories left outstanding. Remaining weights renormalized. Matched the pypi:snowflake-sqlalchemy@1.11.0 runtime dependency closure — what installing the published package pulls in — 10 packages. Reachability is not analyzed.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"no_advisories_left_outstanding"
]
}
},
{
"code": "weights_renormalized",
"params": {}
},
{
"code": "advisories_scope_published",
"params": {
"package": "pypi:snowflake-sqlalchemy@1.11.0",
"assessed": 10
}
},
{
"code": "advisories_reachability",
"params": {}
}
],
"value": 100,
"inputs": {
"source": "osv",
"advisories": 0,
"affected_packages": 0,
"assessed_packages": 10,
"unassessed_packages": 0,
"affected_by_severity": "none",
"direct_affected_packages": 0
},
"components": [
{
"key": "direct_dependencies_free_of_known_advisories",
"name": "Direct dependencies free of known advisories",
"detail": "no direct dependency carries a known advisory",
"points": 35,
"status": "met",
"details": [
{
"code": "no_direct_advisories",
"params": {}
}
],
"max_points": 35
},
{
"key": "indirect_dependencies_free_of_known_advisories",
"name": "Indirect dependencies free of known advisories",
"detail": "no indirect dependency carries a known advisory",
"points": 25,
"status": "met",
"details": [
{
"code": "no_indirect_advisories",
"params": {}
}
],
"max_points": 25
},
{
"key": "no_advisories_left_outstanding",
"name": "No advisories left outstanding",
"detail": "no advisory carries a publication date",
"points": 0,
"status": "excluded",
"details": [
{
"code": "advisories_no_publication_date",
"params": {}
}
],
"max_points": 40
}
]
},
{
"key": "malicious_dependencies",
"band": "excellent",
"name": "Malicious dependencies",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"source": "osv",
"meaning": "reported as a malicious package by the OpenSSF corpus; the remedy is removal or moving off the compromised name, never an upgrade of the same artifact. Versions the registry has since pulled are listed but not scored",
"packages": [],
"red_flag": false,
"assessed_packages": 10,
"malicious_packages": 0,
"direct_malicious_packages": 0,
"withdrawn_malicious_packages": 0,
"installable_malicious_packages": 0
},
"components": [
{
"key": "no_dependency_reported_as_a_malicious_package",
"name": "No dependency reported as a malicious package",
"detail": "no dependency is reported as a malicious package",
"points": 100,
"status": "met",
"details": [
{
"code": "no_malicious_dependencies",
"params": {}
}
],
"max_points": 100
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "excellent",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"review_only_matches": 0,
"assessed_self_published_locations": 7
},
"components": [
{
"key": "policy_exposure_multiplier",
"name": "Policy exposure multiplier",
"detail": "no confirmed policy-scope location match",
"points": 100,
"status": "met",
"details": [
{
"code": "jurisdiction_no_match",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "at_risk",
"name": "AI Readiness",
"value": 46,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "critical",
"name": "Agent context & guidance",
"note": "Excluded from scoring (no data or not applicable): Legible commit history. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"legible_commit_history"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 1,
"inputs": {
"has_llms_txt": false,
"legible_history_share": null,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "no CLAUDE.md / AGENTS.md / editor rules",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_instructions",
"params": {}
}
],
"max_points": 45
},
{
"key": "machine_readable_docs_llms_txt",
"name": "Machine-readable docs (llms.txt)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "legible_commit_history",
"name": "Legible commit history",
"detail": "no data",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "moderate",
"name": "Verify loop (build / test / typecheck)",
"note": "Excluded from scoring (no data or not applicable): Demonstrated agent practice. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"demonstrated_agent_practice"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 66,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": true,
"typed_language": false,
"bootstrap_files": [],
"has_devcontainer": false,
"has_linter_config": true,
"typecheck_configs": [
"src/snowflake/sqlalchemy/py.typed"
],
"agent_commit_share": null,
"toolchain_manifests": [],
"dependency_bot_commit_share": 0
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 18
},
{
"key": "automated_tests",
"name": "Automated tests",
"detail": null,
"points": 22,
"status": "met",
"details": [],
"max_points": 22
},
{
"key": "lint_format_config",
"name": "Lint / format config",
"detail": "tox.ini",
"points": 11,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "tox.ini"
}
}
],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": "src/snowflake/sqlalchemy/py.typed",
"points": 11,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "src/snowflake/sqlalchemy/py.typed"
}
}
],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": "Dockerfile",
"points": 10,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Dockerfile"
}
}
],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "no data",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
},
{
"key": "automated_maintenance",
"name": "Automated maintenance",
"detail": "dependency automation configured, none observed in the sampled commits",
"points": 5,
"status": "partial",
"details": [
{
"code": "dependency_bot_config_only",
"params": {}
}
],
"max_points": 8
},
{
"key": "openssf_scorecard_pinned_dependencies",
"name": "OpenSSF Scorecard: Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "good",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 80,
"inputs": {
"primary_language": "Python",
"largest_source_bytes": 86986,
"source_files_sampled": 104,
"oversized_source_files": 3
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "Python with type-check config (src/snowflake/sqlalchemy/py.typed)",
"points": 27,
"status": "partial",
"details": [
{
"code": "typecheck_config_language",
"params": {
"files": "src/snowflake/sqlalchemy/py.typed",
"language": "Python"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "3/104 source files over 60KB",
"points": 53.4,
"status": "partial",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 104,
"oversized": 3
}
}
],
"max_points": 55
}
]
}
],
"description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
}
],
"metrics_version": "1.13.0"
},
"warnings": [],
"report_type": "repository",
"generated_at": "2026-07-21T03:38:35.484670Z",
"schema_version": "0.17.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/s/snowflakedb/snowflake-sqlalchemy.svg",
"full_name": "snowflakedb/snowflake-sqlalchemy",
"license_state": "standard",
"license_spdx": "Apache-2.0"
}Bewertungen sind Signale, keine Garantien. Sie spiegeln öffentlich sichtbare Praxis auf GitHub wider — kein Code-Audit und keine Sicherheitsgarantie.
Fehlende Daten werden ausgeschlossen und die Gewichte neu normiert, nie als null bewertet. Die Methodik ist versioniert und offen: Metriken v1.13.0, Schema v0.17.0 — vollständige Methodik · Metriken-Wiki.
Wie ein einzelnes Ergebnis im Gesamtregister steht: aggregierte Statistiken — PyPI.