Public record
Software health reportschema 0.12.0 · metrics 2.10.0 · 2026-07-17 20:18 UTC

snowflake-labs / snowcli

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

PythonApache-2.0★ 263 stars⑂ 112 forkssince Aug 2022View on GitHub ↗
KindCommand-line toolhow this is determined
#cli#data-ops#devops-tools#snowflake#sql

snowflake-labs/snowcli holds a health index of 94 out of 100, placing it in the Exceptional band. It scores highest on Vitality (99/100) and lowest on AI Readiness (45/100). It was last updated today. 6 contributors account for most of its recent work.

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

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

Ownership

SnowflakeOrganization
1,614 followers63 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-clipoints to another repo — not scored3.23.0996,166381 day 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 0 days ago
34.6/36Commit cadence — 50/52 weeks with commits
18/18Commit volume — 393 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_year393
human_commit_share—
days_since_last_push0
active_weeks_last_year50

Release discipline

98Exceptional
How it's scored
27/27Ships releases — 100 releases published
36/36Release recency — latest release 1 days ago
27/27Release cadence — a release every ~7.6 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.23.0
releases_from_tagsno
days_since_latest_release1
mean_days_between_releases7.6

Community & Adoption

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

69Good · 17% of overall

Popularity & adoption

62Moderate
How it's scored
39.2/60Stars — 263 stars
17/25Forks — 112 forks
6.2/15Watchers — 14 watchers
Inputs used
forks112
stars263
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_badges—
has_contributingyes
has_issue_templateno
has_code_of_conductno
readme_badge_services—
has_pull_request_templateyes

Sustainability & Governance

Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?

87Excellent · 23% of overall

Maintainer resilience (bus factor)

92Excellent
How it's scored
48.6/54Bus factor — 6 contributor(s) cover half of all commits
19.7/22.5Commit distribution — top contributor authored 12% of commits
13.5/13.5Contributor breadth — 72 contributors
10/10OpenSSF Scorecard: Contributors — project has 3 contributing companies or organizations -- score normalized to 10
Inputs used
bus_factor6
contributors_sampled72
top_contributor_share0.123

Issue & PR responsiveness

69Good
How it's scored
35/42Issue resolution — 83% of issues closed
24.9/30PR acceptance — 2,175/2,621 decided PRs merged
0/13Newcomer PR acceptance — no first-time contributor's PR decided in 30d
0/15OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0
Inputs used
merged_prs2,175
open_issues68
closed_issues340
prs_merged_7d—
prs_decided_7d—
prs_merged_30d—
prs_decided_30d—
issue_closed_ratio0.833
closed_unmerged_prs446
first_time_authors_30d—
first_time_prs_merged_30d—
first_time_prs_decided_30d—
Excluded from scoring (no data or not applicable): Newcomer PR acceptance. Remaining weights renormalized.

Ownership & stewardship

98Exceptional
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain — verified-domain status not read for this organization
23.1/25Owner reach — 1,614 followers of snowflakedb
25/25Track record — 63 public repos, account ~12 yr old
Inputs used
followers1,614
owner_typeOrganization
is_verified—
owner_loginsnowflakedb
public_repos63
account_age_days4,561
Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.

Engineering Quality

Are baseline engineering and documentation practices in place?

91Excellent · 19% of overall

Engineering practices

92Excellent
How it's scored
24/24CI workflows — 23 workflow(s)
24/24Tests present
16/16Linter config
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?

52Moderate · 16% of overall

Security posture

52Moderate
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
2.2/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
2.5/2.5Contributors — project has 3 contributing companies or organizations -- score normalized to 10
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 — 19 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.

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.

45Weak · 4% of overall

Agent context & guidance

1Critical
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
0/40Legible commit history — no data
Inputs used
has_llms_txtno
llms_txt_url—
legible_history_share—
agent_instruction_files—
agent_instruction_max_bytes—
Excluded from scoring (no data or not applicable): Legible commit history. Remaining weights renormalized.

Verify loop (build / test / typecheck)

53Moderate
How it's scored
0/18One-command bootstrap
22/22Automated tests
11/11Lint / format config
0/11Static type checking
10/10Reproducible environment — Dockerfile
0/10Demonstrated agent practice — no data
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_share—
toolchain_manifests—
dependency_bot_commit_share0
Excluded from scoring (no data or not applicable): Demonstrated agent practice. Remaining weights renormalized.

Code legibility for models

54Moderate
How it's scored
0/45Type-checkable code — Python without a type-check config
54.1/55Manageable file sizes — 14/827 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes337,306
source_files_sampled827
oversized_source_files14

Machine-readable interfaces

100Exceptional
How it's scored
40/40API schema (OpenAPI/GraphQL/proto) — src/snowflake/cli/_plugins/streamlit/proto/developer/v1/logs_service.proto
0/20MCP server — not applicable to this kind of software
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_of—
Excluded from scoring (no data or not applicable): MCP server. Remaining weights renormalized.

Key facts

263GitHub stars
72contributors
393commits, last 12 months
0days since last push
100releases
6bus factor
68open issues
PyPIpackage ecosystems

Data collection warnings

  • pypi package 'snowflake-cli' points at a different repository (https://github.com/snowflakedb/snowflake-cli); excluded from ecosystem scoring

More detail

OpenSSF Scorecard 5.2 / 10
5.2aggregate

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

10Binary-Artifactsno binaries found in the repo
3Branch-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
10Contributorsproject has 3 contributing companies or organizations -- score normalized to 10
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
0Vulnerabilities19 existing vulnerabilities detected
Direct dependencies 22
RegistryPackageVersion constraintManifest
PyPIclick==8.1.8pyproject.toml
PyPIGitPython==3.1.50pyproject.toml
PyPIPyYAML==6.0.2pyproject.toml
PyPIid==1.5.0pyproject.toml
PyPIjinja2==3.1.6pyproject.toml
PyPIpackaging==25.0pyproject.toml
PyPIpip==26.1.2pyproject.toml
PyPIpluggy==1.6.0pyproject.toml
PyPIprompt-toolkit==3.0.51pyproject.toml
PyPIprotobuf>=5.29.6,<6pyproject.toml
PyPIpydantic==2.12.5pyproject.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.1pyproject.toml
PyPIsnowflake-snowpark-python==1.53.0pyproject.toml
PyPIsnowflake.core==1.10.0pyproject.toml
PyPItomlkit==0.13.3pyproject.toml
PyPItyper==0.17.3pyproject.toml
PyPIurllib3>=2.6.3,<3pyproject.toml
PyPIwebsocket-client>=1.6.0,<2pyproject.toml
All dependencies 96

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

RegistryPackageVersionRelation
PyPIclick8.1.8direct
PyPIgitpython3.1.50direct
PyPIid1.5.0direct
PyPIjinja23.1.6direct
PyPIpackaging25.0direct
PyPIpip26.1.2direct
PyPIpluggy1.6.0direct
PyPIprompt-toolkit3.0.51direct
PyPIprotobuf—direct
PyPIprotobuf5.29.6direct
PyPIpydantic1.10.13direct
PyPIpydantic2.12.5direct
PyPIpyyaml6.0.2direct
PyPIrequests2.33.0direct
PyPIrequirements-parser0.13.0direct
PyPIrich14.0.0direct
PyPIsetuptools80.8.0direct
PyPIsnowflake-connector-python—direct
PyPIsnowflake-connector-python4.7.1direct
PyPIsnowflake-core1.10.0direct
PyPIsnowflake-snowpark-python—direct
PyPIsnowflake-snowpark-python1.53.0direct
PyPItomlkit0.13.3direct
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
PyPIpandas—indirect
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
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 snowflake-labs/snowcli. Read them side by side →

96snowflakedb/snowflake-cliSnowflake CLI is an open-source command-line tool explicitly designed for developer-centric workloads in addition to SQL operations.Exceptional98sqlfluff/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/snowflake-connector-pythonSnowflake Connector for PythonExceptional96snowflakedb/snowpark-pythonSnowflake Snowpark Python APIExceptional96Canner/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.Exceptional

Scores are signals, not warranties. They reflect publicly visible practices on GitHub — not a code audit, and not a security guarantee.

Missing data is excluded and weights renormalized, never scored as zero. Methodology is versioned and open: metrics v2.10.0, schema v0.12.0 — full methodology · metrics wiki.

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