Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-09-13 22:59 UTC

snowflakedb / snowflake-cli

Snowflake CLI is an open-source command-line tool explicitly designed for developer-centric workloads in addition to SQL operations.

PythonApache-2.0★ 267 stars⑂ 117 forkssince Aug 2022View on GitHub ↗
KindCommand-line toolNetwork serviceLibraryhow this is determined
#cli#data-ops#devops-tools#snowflake#sql

snowflakedb/snowflake-cli holds a health index of 95 out of 100, placing it in the Exceptional band. It scores highest on Vitality (99/100) and lowest on Security (56/100). It was last updated 2 days ago. 6 contributors account for most of its recent work.

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

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

Ownership

SnowflakeOrganization · verified domain
1,641 followers65 public repossince Jan 2014

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publish
PyPIsnowflake-cli3.27.0820,867434 days ago

Metrics by category

Vitality

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

99Exceptional · 21% of overall

Development activity

99Exceptional
How it's scored
36/36Push recency — last push 2 days ago
34.6/36Commit cadence — 50/52 weeks with commits
18/18Commit volume — 450 commits in the last year
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year450
human_commit_share1
days_since_last_push2
active_weeks_last_year50

Release discipline

98Exceptional
How it's scored
27/27Ships releases — 100 releases published
36/36Release recency — latest release 4 days ago
27/27Release cadence — a release every ~10.3 days
8/10OpenSSF Scorecard: Signed-Releases — 5 out of the last 5 releases have a total of 5 signed artifacts.
Inputs used
releases_count100
latest_release_tagv3.27.0
releases_from_tagsno
days_since_latest_release4
mean_days_between_releases10.3

Community & Adoption

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

77Good · 17% of overall

Popularity & adoption

63Moderate
How it's scored
39.3/60Stars — 267 stars
17.2/25Forks — 117 forks
6.2/15Watchers — 14 watchers
Inputs used
forks117
stars267
watchers14
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

77Good
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (Apache-2.0)
18/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
6.3/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges3
has_contributingyes
has_issue_templateno
has_code_of_conductno
readme_badge_servicesgithub.com
has_pull_request_templateyes

Ecosystem adoption (downloads)

99Exceptional
How it's scored
78.9/80Monthly downloads — 820,867 downloads/month across pypi
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagessnowflake-cli
dependents—
ecosystemspypi
total_downloads—
monthly_downloads820,867
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?

86Excellent · 23% of overall

Maintainer resilience (bus factor)

88Excellent
How it's scored
48.6/54Bus factor — 6 contributor(s) cover half of all commits
19.6/22.5Commit distribution — top contributor authored 13% of commits
13.5/13.5Contributor breadth — 73 contributors
6/10OpenSSF Scorecard: Contributors — project has 2 contributing companies or organizations -- score normalized to 6
Inputs used
bus_factor6
contributors_sampled73
top_contributor_share0.131

Issue & PR responsiveness

60Moderate
How it's scored
35.4/42Issue resolution — 84% of issues closed
24.6/30PR acceptance — 2,175/2,654 decided PRs merged
0/13Newcomer PR acceptance — 0/3 first-time contributors' PRs merged in 30d
0/15OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0
Inputs used
merged_prs2,175
open_issues65
closed_issues349
prs_merged_7d0
prs_decided_7d26
prs_merged_30d0
prs_decided_30d28
issue_closed_ratio0.843
closed_unmerged_prs479
first_time_authors_30d3
first_time_prs_merged_30d0
first_time_prs_decided_30d3

Ownership & stewardship

98Exceptional
How it's scored
30/30Ownership backing — organization-owned
20/20Verified domain
23.1/25Owner reach — 1,641 followers of snowflakedb
25/25Track record — 65 public repos, account ~12 yr old
Inputs used
followers1,641
owner_typeOrganization
is_verifiedyes
owner_loginsnowflakedb
public_repos65
account_age_days4,619

Package maintenance

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

Engineering Quality

Are baseline engineering and documentation practices in place?

91Excellent · 19% of overall

Engineering practices

92Excellent
How it's scored
24/24CI workflows — 22 workflow(s)
24/24Tests present
16/16Linter config — pyproject.toml ([tool.ruff])
9.6/9.6Pre-commit hooks
0/6.4.editorconfig
0/20OpenSSF Scorecard: CI-Tests — no data
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configyes
has_precommit_configyes
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: CI-Tests. Remaining weights renormalized.

Documentation

90Excellent
How it's scored
30/30README
25/25Documentation directory
15/15Documentation / homepage site — https://docs.snowflake.com/developer-guide/snowflake-cli-v2/index
10/10Repository description
10/10Topics — 5 topics
0/10Wiki
Inputs used
topicscli, data-ops, devops-tools, snowflake, sql
has_wikino
homepagehttps://docs.snowflake.com/developer-guide/snowflake-cli-v2/index
docs_sitehttps://docs.snowflake.com/developer-guide/snowflake-cli-v2/index
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

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

56Moderate · 16% of overall

Security posture

52Moderate
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
3/7.5Branch-Protection — branch protection is not maximal on development and all release branches
0/2.5CI-Tests — no data
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 0/30 approved changesets -- score normalized to 0
1.5/2.5Contributors — project has 2 contributing companies or organizations -- score normalized to 6
10/10Dangerous-Workflow — no dangerous workflow patterns detected
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
7.5/7.5Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
0/5Packaging — no data
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
0/5SAST — no SAST tool detected
5/5Security-Policy — security policy file detected
6/7.5Signed-Releases — 5 out of the last 5 releases have a total of 5 signed artifacts.
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
0/7.5Vulnerabilities — 22 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated16
scorecard_versionv5.5.0
checks_inconclusive2
scorecard_aggregate5.2
Excluded from scoring (no data or not applicable): CI-Tests, Packaging. Remaining weights renormalized.

Dependency advisories

72Good
How it's scored
12.9/35Direct dependencies free of known advisories — 2 affected: click 8.1.8 (high 7.2), setuptools 80.8.0 (moderate 6.1)
25/25Indirect dependencies free of known advisories — no indirect dependency carries a known advisory
33.9/40No advisories left outstanding — 1 advisory-carrying package(s) unaddressed past 90 days; oldest published 136 days ago
Inputs used
sourceosv
advisories3
affected_packages2
assessed_packages64
unassessed_packages0
affected_by_severityhigh 1, moderate 1
direct_affected_packages2
Matched the pypi:snowflake-cli@3.27.0 runtime dependency closure — what installing the published package pulls in — 64 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.

60Moderate · 4% of overall

Agent context & guidance

55Moderate
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
15/15Machine-readable docs (llms.txt) — llms.txt served by the project website (https://docs.snowflake.com/llms.txt)
40/40Legible commit history — 96 of 100 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtyes
llms_txt_urlhttps://docs.snowflake.com/llms.txt
legible_history_share0.96
agent_instruction_files—
agent_instruction_max_bytes—

Verify loop (build / test / typecheck)

58Moderate
How it's scored
0/18One-command bootstrap
22/22Automated tests
11/11Lint / format config — pyproject.toml ([tool.ruff])
0/11Static type checking
10/10Reproducible environment — Dockerfile
10/10Demonstrated agent practice — 42 of the last 100 commits agent-authored or agent-credited
5/8Automated maintenance — dependency automation configured, none observed in the sampled commits
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfiles—
has_dockerfileyes
typed_languageno
bootstrap_files—
has_devcontainerno
has_linter_configyes
typecheck_configs—
agent_commit_share0.42
toolchain_manifests—
dependency_bot_commit_share0

Code legibility for models

54Moderate
How it's scored
0/45Type-checkable code — Python without a type-check config
53.7/55Manageable file sizes — 21/856 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes457,333
source_files_sampled856
oversized_source_files21

Machine-readable interfaces

80Excellent
How it's scored
40/40API schema (OpenAPI/GraphQL/proto) — src/snowflake/cli/_plugins/streamlit/proto/developer/v1/logs_service.proto
0/20MCP server
40/40Runnable examples — example, notebooks
Inputs used
example_dirsexample, notebooks
has_mcp_signalno
api_schema_filessrc/snowflake/cli/_plugins/streamlit/proto/developer/v1/logs_service.proto
interfaces_expected_ofnetwork-service

Key facts

267GitHub stars
73contributors
450commits, last 12 months
2days since last push
100releases
6bus factor
65open 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 ★ / 117 ⇿
0Stars
117Forks
99Releases

When each star and fork was added, collected from GitHub and bucketed by day. Cumulative growth sits directly above the daily additions it is made of, so the two read against each other: steady organic accretion looks nothing like an abrupt, short-lived burst. Where that difference is measurable, it is reported as growth authenticity.

02040608010012011642022-112024-102026-09
Major 1Minor 28Patch 19

Each point covers 4 days.

OpenSSF Scorecard 5.2 / 10
5.2aggregate

Independent, tool-agnostic security assessment from the open-source OpenSSF Scorecard. Each check rewards a security practice, not a specific vendor's tool. Checks Scorecard could not determine are marked n/a and excluded from the security score (never counted as zero).Scorecard v5.5.0 · 2026-09-13 22:58 UTC

10Binary-Artifactsno binaries found in the repo
4Branch-Protectionbranch protection is not maximal on development and all release branches
n/aCI-Testsno pull request found
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/30 approved changesets -- score normalized to 0
6Contributorsproject has 2 contributing companies or organizations -- score normalized to 6
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
10Maintained30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10
n/aPackagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
0SASTno SAST tool detected
10Security-Policysecurity policy file detected
8Signed-Releases5 out of the last 5 releases have a total of 5 signed artifacts.
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
0Vulnerabilities22 existing vulnerabilities detected
Direct dependencies 23
RegistryPackageVersion constraintManifest
PyPIclick==8.1.8pyproject.toml
PyPIGitPython==3.1.59pyproject.toml
PyPIPyYAML==6.0.2pyproject.toml
PyPIid==1.5.0pyproject.toml
PyPIjinja2==3.1.6pyproject.toml
PyPIpackaging==25.0pyproject.toml
PyPIpip==26.2.1pyproject.toml
PyPIpluggy==1.6.0pyproject.toml
PyPIprompt-toolkit==3.0.51pyproject.toml
PyPIprotobuf>=5.29.6,<6pyproject.toml
PyPIpydantic==2.12.5pyproject.toml
PyPIpython-dotenv==1.2.2pyproject.toml
PyPIrequests==2.33.0pyproject.toml
PyPIrequirements-parser==0.13.0pyproject.toml
PyPIrich==14.0.0pyproject.toml
PyPIsetuptools==80.8.0pyproject.toml
PyPIsnowflake-connector-python==4.7.3pyproject.toml
PyPIsnowflake-snowpark-python==1.53.0pyproject.toml
PyPIsnowflake.core==1.10.0pyproject.toml
PyPItomlkit==0.15.1pyproject.toml
PyPItyper==0.17.3pyproject.toml
PyPIurllib3>=2.6.3,<3pyproject.toml
PyPIwebsocket-client>=1.6.0,<2pyproject.toml
All dependencies 100

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

RegistryPackageVersionRelation
PyPIclick8.1.8direct
PyPIgitpython3.1.59direct
PyPIid1.5.0direct
PyPIjinja23.1.6direct
PyPIpackaging25.0direct
PyPIpip26.2.1direct
PyPIpluggy1.6.0direct
PyPIprompt-toolkit3.0.51direct
PyPIprotobuf—direct
PyPIprotobuf5.29.6direct
PyPIpydantic1.10.13direct
PyPIpydantic2.12.5direct
PyPIpython-dotenv1.2.2direct
PyPIpyyaml6.0.2direct
PyPIrequests—direct
PyPIrequests2.33.0direct
PyPIrequirements-parser0.13.0direct
PyPIrich14.0.0direct
PyPIsetuptools80.8.0direct
PyPIsnowflake-connector-python—direct
PyPIsnowflake-connector-python4.7.3direct
PyPIsnowflake-core1.10.0direct
PyPIsnowflake-snowpark-python—direct
PyPIsnowflake-snowpark-python1.53.0direct
PyPItomlkit0.15.1direct
PyPItyper0.17.3direct
PyPIurllib3—direct
PyPIurllib32.6.3direct
PyPIwebsocket-client—direct
PyPIwebsocket-client1.9.0direct
PyPIaiohttp—indirect
PyPIannotated-types0.7.0indirect
PyPIasn1crypto1.5.1indirect
PyPIboto31.39.14indirect
PyPIbotocore1.39.14indirect
PyPIcertifi2025.7.14indirect
PyPIcffi2.0.0indirect
PyPIcharset-normalizer3.4.2indirect
PyPIcloudpickle3.0.0indirect
PyPIcolorama0.4.6indirect
PyPIcoverage7.10.4indirect
PyPIcryptography46.0.6indirect
PyPIdummy-pkg-for-tests—indirect
PyPIdummy-pkg-for-tests-with-deps—indirect
PyPIfactory-boy3.3.3indirect
PyPIfaker37.4.0indirect
PyPIfilelock3.18.0indirect
PyPIgitdb4.0.12indirect
PyPIhttpx—indirect
PyPIhttpx-retries0.4.2indirect
PyPIidna3.10indirect
PyPIjaraco-classes3.4.0indirect
PyPIjaraco-context6.0.1indirect
PyPIjaraco-functools4.2.1indirect
PyPIjeepney0.9.0indirect
PyPIjmespath1.0.1indirect
PyPIkeyring25.6.0indirect
PyPImarkdown-it-py3.0.0indirect
PyPImarkupsafe3.0.2indirect
PyPImatplotlib—indirect
PyPImdurl0.1.2indirect
PyPImore-itertools10.7.0indirect
PyPImypy1.3.0indirect
PyPInumpy—indirect
PyPInumpy1.26.4indirect
PyPIpandas—indirect
PyPIpandas2.1.4indirect
PyPIplatformdirs4.3.8indirect
PyPIpre-commit—indirect
PyPIpycparser2.22indirect
PyPIpydantic-core2.41.5indirect
PyPIpygments2.19.2indirect
PyPIpyjwt2.10.1indirect
PyPIpyopenssl26.0.0indirect
PyPIpytest8.4.1indirect
PyPIpytest-cov6.0.0indirect
PyPIpytest-httpserver1.1.3indirect
PyPIpytest-randomly3.16.0indirect
PyPIpytest-xdist3.6.1indirect
PyPIpython-dateutil2.9.0.post0indirect
PyPIpytz2025.2indirect
PyPIpywin32-ctypes0.2.3indirect
PyPIs3transfer0.13.1indirect
PyPIscikit-learn—indirect
PyPIsecretstorage3.3.3indirect
PyPIshellingham1.5.4indirect
PyPIsix1.17.0indirect
PyPIsmmap5.0.2indirect
PyPIsnowflake-cli—indirect
PyPIsnowflake-cli3.0.1indirect
PyPIsortedcontainers2.4.0indirect
PyPIsyrupy—indirect
PyPIsyrupy4.9.1indirect
PyPItyping-extensions4.14.1indirect
PyPItyping-inspection0.4.2indirect
PyPItzdata2025.2indirect
PyPItzlocal5.3.1indirect
PyPIuv0.10.9indirect
PyPIwcwidth0.2.13indirect
PyPIwheel0.45.1indirect
Dependency advisories 2

Installing pypi:snowflake-cli@3.27.0 pulls in 64 packages, direct and transitive: 2 carry known advisories, of which 2 are direct dependencies.

PackageVersionRelationSeverityAdvisoriesFixed in
click8.1.8directhigh18.3.3
setuptools80.8.0directmoderate283.0.0

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 snowflakedb/snowflake-cli. Read them side by side →

96Canner/WrenAIGenBI (Generative BI) for AI agents, an open-source, governed text-to-SQL through an open context layer that turns natural-language questions into trusted dashboards, charts, and SQL across 20+ data sources, such as BigQuery, Snowflake, PostgreSQL, ClickHouse, Amazon Redshift, Databricks and more.Exceptional98apache/datafusion-ballistaApache DataFusion Ballista Distributed Query EngineExceptional98sqlfluff/sqlfluffA modular SQL linter and auto-formatter with support for multiple dialects and templated code.Exceptional96bruin-data/bruinBuild data pipelines with SQL and Python, ingest data from different sources, add quality checks, and build end-to-end flows.Exceptional96snowflakedb/snowpark-pythonSnowflake Snowpark Python APIExceptional95snowflakedb/snowflake-connector-pythonSnowflake Connector for PythonExceptional

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.