{"date":"2026-08-24","repo":{"name":"github.com/sqlc-dev/sqlc","commit":"19038bb9c1b93b240447938ed8fbbf02e2861508"},"scorecard":{"version":"v5.5.1-0.20260815060127-d1fab88f5463","commit":"d1fab88f54636ff366076edfc5c239f97b3c8e66"},"score":4.5,"checks":[{"name":"Maintained","score":10,"reason":"30 commit(s) and 13 issue activity found in the last 90 days -- score normalized to 10","details":null,"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#maintained","short":"Determines if the project is \"actively maintained\"."}},{"name":"Packaging","score":-1,"reason":"packaging workflow not detected","details":["Warn: no GitHub/GitLab publishing workflow detected."],"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#packaging","short":"Determines if the project is published as a package that others can easily download, install, easily update, and uninstall."}},{"name":"Code-Review","score":0,"reason":"Found 1/21 approved changesets -- score normalized to 0","details":null,"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#code-review","short":"Determines if the project requires human code review before pull requests (aka merge requests) are merged."}},{"name":"Token-Permissions","score":0,"reason":"detected GitHub workflow tokens with excessive permissions","details":["Warn: no topLevel permission defined: .github/workflows/buf.yml:1","Warn: no topLevel permission defined: .github/workflows/build.yml:1","Warn: no topLevel permission defined: .github/workflows/ci-kotlin.yml:1","Warn: no topLevel permission defined: .github/workflows/ci-python.yml:1","Warn: no topLevel permission defined: .github/workflows/ci-typescript.yml:1","Warn: no topLevel permission defined: .github/workflows/ci.yml:1","Warn: no topLevel permission defined: .github/workflows/gen.yml:1","Info: no jobLevel write permissions found"],"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#token-permissions","short":"Determines if the project's workflows follow the principle of least privilege."}},{"name":"Dangerous-Workflow","score":10,"reason":"no dangerous workflow patterns detected","details":null,"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#dangerous-workflow","short":"Determines if the project's GitHub Action workflows avoid dangerous patterns."}},{"name":"Binary-Artifacts","score":10,"reason":"no binaries found in the repo","details":null,"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#binary-artifacts","short":"Determines if the project has generated executable (binary) artifacts in the source repository."}},{"name":"CII-Best-Practices","score":0,"reason":"no effort to earn an OpenSSF best practices badge detected","details":null,"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#cii-best-practices","short":"Determines if the project has an OpenSSF (formerly CII) Best Practices Badge."}},{"name":"Fuzzing","score":10,"reason":"project is fuzzed","details":["Info: GoBuiltInFuzzer integration found: internal/codegen/golang/opts/override_test.go:103","Info: GoBuiltInFuzzer integration found: internal/config/config_test.go:72"],"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#fuzzing","short":"Determines if the project uses fuzzing."}},{"name":"License","score":10,"reason":"license file detected","details":["Info: project has a license file: LICENSE:0","Info: FSF or OSI recognized license: MIT License: LICENSE:0"],"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#license","short":"Determines if the project has defined a license."}},{"name":"Pinned-Dependencies","score":3,"reason":"dependency not pinned by hash detected -- score normalized to 3","details":["Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/buf.yml:10: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/buf.yml/main?enable=pin","Warn: third-party GitHubAction not pinned by hash: .github/workflows/buf.yml:11: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/buf.yml/main?enable=pin","Warn: third-party GitHubAction not pinned by hash: .github/workflows/buf.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/buf.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/build.yml:12: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/build.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/build.yml:13: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/build.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-kotlin.yml:17: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci-kotlin.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-kotlin.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci-kotlin.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-kotlin.yml:23: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci-kotlin.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-python.yml:17: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci-python.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-python.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci-python.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-python.yml:23: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci-python.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-typescript.yml:17: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci-typescript.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-typescript.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci-typescript.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-typescript.yml:23: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci-typescript.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:16: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:17: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:28: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:29: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci.yml/main?enable=pin","Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:74: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/ci.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/gen.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/gen.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/gen.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/gen.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/gen.yml:35: update your workflow using https://app.stepsecurity.io/secureworkflow/sqlc-dev/sqlc/gen.yml/main?enable=pin","Warn: containerImage not pinned by hash: Dockerfile:2: pin your Docker image by updating golang:1.27.0 to golang:1.27.0@sha256:0ecdc2a9f6156af6451080bfe3d8382a662fcc4e209608c6f919e643453514c1","Warn: containerImage not pinned by hash: Dockerfile:16: pin your Docker image by updating gcr.io/distroless/base-debian12 to gcr.io/distroless/base-debian12@sha256:fabbf1c0c357a3d42550111351daed089b20a2c954df13ee2fcff60602515e84","Warn: goCommand not pinned by hash: .github/workflows/ci.yml:35","Info:   0 out of  19 GitHub-owned GitHubAction dependencies pinned","Info:   0 out of   3 third-party GitHubAction dependencies pinned","Info:   0 out of   2 containerImage dependencies pinned","Info:   6 out of   7 goCommand dependencies pinned"],"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#pinned-dependencies","short":"Determines if the project has declared and pinned the dependencies of its build process."}},{"name":"Security-Policy","score":0,"reason":"security policy file not detected","details":["Warn: no security policy file detected","Warn: no security file to analyze","Warn: no security file to analyze","Warn: no security file to analyze"],"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#security-policy","short":"Determines if the project has published a security policy."}},{"name":"Branch-Protection","score":3,"reason":"branch protection is not maximal on development and all release branches","details":["Info: 'allow deletion' disabled on branch 'main'","Info: 'force pushes' disabled on branch 'main'","Info: 'branch protection settings apply to administrators' is required to merge on branch 'main'","Warn: 'stale review dismissal' is disabled on branch 'main'","Warn: branch 'main' does not require approvers","Warn: codeowners review is not required on branch 'main'","Warn: 'last push approval' is disabled on branch 'main'","Warn: 'up-to-date branches' is disabled on branch 'main'","Info: status check found to merge onto on branch 'main'","Info: PRs are required in order to make changes on branch 'main'"],"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#branch-protection","short":"Determines if the default and release branches are protected with GitHub's branch protection settings."}},{"name":"Signed-Releases","score":0,"reason":"Project has not signed or included provenance with any releases.","details":["Warn: release artifact v1.31.1 not signed: https://api.github.com/repos/sqlc-dev/sqlc/releases/312281549","Warn: release artifact v1.31.0 not signed: https://api.github.com/repos/sqlc-dev/sqlc/releases/310993943","Warn: release artifact v1.30.0 not signed: https://api.github.com/repos/sqlc-dev/sqlc/releases/243972169","Warn: release artifact v1.29.0 not signed: https://api.github.com/repos/sqlc-dev/sqlc/releases/213007211","Warn: release artifact v1.28.0 not signed: https://api.github.com/repos/sqlc-dev/sqlc/releases/195704518","Warn: release artifact v1.31.1 does not have provenance: https://api.github.com/repos/sqlc-dev/sqlc/releases/312281549","Warn: release artifact v1.31.0 does not have provenance: https://api.github.com/repos/sqlc-dev/sqlc/releases/310993943","Warn: release artifact v1.30.0 does not have provenance: https://api.github.com/repos/sqlc-dev/sqlc/releases/243972169","Warn: release artifact v1.29.0 does not have provenance: https://api.github.com/repos/sqlc-dev/sqlc/releases/213007211","Warn: release artifact v1.28.0 does not have provenance: https://api.github.com/repos/sqlc-dev/sqlc/releases/195704518"],"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#signed-releases","short":"Determines if the project cryptographically signs release artifacts."}},{"name":"SAST","score":0,"reason":"SAST tool is not run on all commits -- score normalized to 0","details":["Warn: 0 commits out of 30 are checked with a SAST tool"],"documentation":{"url":"https://github.com/ossf/scorecard/blob/d1fab88f54636ff366076edfc5c239f97b3c8e66/docs/checks.md#sast","short":"Determines if the project uses static code analysis."}}]}