{"id":5933014,"name":"@beequeue/knex","ecosystem":"npm","description":"A batteries-included SQL query \u0026 schema builder for PostgresSQL, MySQL, CockroachDB, MSSQL and SQLite3","homepage":"https://knex.github.io/documentation/","licenses":"MIT","normalized_licenses":["MIT"],"repository_url":"https://github.com/knex/knex","keywords_array":["sql","query","postgresql","postgres","mysql","cockroachdb","sqlite3","oracle","mssql","builder","querybuilder","build","db","database"],"namespace":"beequeue","versions_count":1,"first_release_published_at":"2023-01-22T23:01:48.871Z","latest_release_published_at":"2023-01-22T23:01:48.871Z","latest_release_number":"2.4.3","last_synced_at":"2026-05-24T04:22:14.639Z","created_at":"2023-01-24T00:33:36.846Z","updated_at":"2026-05-24T04:22:14.639Z","registry_url":"https://www.npmjs.com/package/@beequeue/knex","install_command":"npm install @beequeue/knex","documentation_url":null,"metadata":{"funding":null,"dist-tags":{"latest":"2.4.3"}},"repo_metadata":{"id":6134752,"uuid":"7363211","full_name":"knex/knex","owner":"knex","description":"A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.","archived":false,"fork":false,"pushed_at":"2026-05-04T17:36:05.000Z","size":18973,"stargazers_count":20276,"open_issues_count":711,"forks_count":2201,"subscribers_count":197,"default_branch":"master","last_synced_at":"2026-05-21T15:54:20.517Z","etag":null,"topics":["javascript","knex","mysql","postgresql","sql","sqlite3"],"latest_commit_sha":null,"homepage":"https://knexjs.org/","language":"JavaScript","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"mit","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/knex.png","metadata":{"files":{"readme":"README.md","changelog":"CHANGELOG.md","contributing":"CONTRIBUTING.md","funding":null,"license":"LICENSE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null,"zenodo":null,"notice":null,"maintainers":null,"copyright":null,"agents":null,"dco":null,"cla":null}},"created_at":"2012-12-29T05:18:25.000Z","updated_at":"2026-05-21T15:11:36.000Z","dependencies_parsed_at":"2025-12-11T12:03:20.600Z","dependency_job_id":null,"html_url":"https://github.com/knex/knex","commit_stats":{"total_commits":2667,"total_committers":585,"mean_commits":4.558974358974359,"dds":0.7326584176977877,"last_synced_commit":"176151d8048b2a7feeb89a3d649a5580786d4f4e"},"previous_names":["tgriesser/knex"],"tags_count":191,"template":false,"template_full_name":null,"purl":"pkg:github/knex/knex","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/knex%2Fknex","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/knex%2Fknex/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/knex%2Fknex/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/knex%2Fknex/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/knex","download_url":"https://codeload.github.com/knex/knex/tar.gz/refs/heads/master","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/knex%2Fknex/sbom","scorecard":{"id":564453,"data":{"date":"2025-08-11","repo":{"name":"github.com/knex/knex","commit":"9bd12999907436c2ef51f786df09a9a7e8931cca"},"scorecard":{"version":"v5.2.1-40-gf6ed084d","commit":"f6ed084d17c9236477efd66e5b258b9d4cc7b389"},"score":4,"checks":[{"name":"Code-Review","score":7,"reason":"Found 20/27 approved changesets -- score normalized to 7","details":null,"documentation":{"short":"Determines if the project requires human code review before pull requests (aka merge requests) are merged.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#code-review"}},{"name":"Packaging","score":-1,"reason":"packaging workflow not detected","details":["Warn: no GitHub/GitLab publishing workflow detected."],"documentation":{"short":"Determines if the project is published as a package that others can easily download, install, easily update, and uninstall.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#packaging"}},{"name":"Dangerous-Workflow","score":10,"reason":"no dangerous workflow patterns detected","details":null,"documentation":{"short":"Determines if the project's GitHub Action workflows avoid dangerous patterns.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#dangerous-workflow"}},{"name":"Maintained","score":0,"reason":"0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0","details":null,"documentation":{"short":"Determines if the project is \"actively maintained\".","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#maintained"}},{"name":"Token-Permissions","score":0,"reason":"detected GitHub workflow tokens with excessive permissions","details":["Info: jobLevel 'actions' permission set to 'read': .github/workflows/codeql-analysis.yml:17","Info: jobLevel 'contents' permission set to 'read': .github/workflows/codeql-analysis.yml:18","Info: jobLevel 'contents' permission set to 'read': .github/workflows/coverage.yml:13","Warn: jobLevel 'checks' permission set to 'write': .github/workflows/coverage.yml:12","Info: topLevel 'contents' permission set to 'read': .github/workflows/codeql-analysis.yml:12","Info: topLevel 'contents' permission set to 'read': .github/workflows/coverage.yml:7","Warn: no topLevel permission defined: .github/workflows/docs-deploy.yml:1","Info: topLevel 'contents' permission set to 'read': .github/workflows/integration-tests.yml:13","Info: topLevel 'contents' permission set to 'read': .github/workflows/linting.yml:13","Info: topLevel 'contents' permission set to 'read': .github/workflows/unit-tests.yml:13"],"documentation":{"short":"Determines if the project's workflows follow the principle of least privilege.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#token-permissions"}},{"name":"Pinned-Dependencies","score":0,"reason":"dependency not pinned by hash detected -- score normalized to 0","details":["Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:30: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/codeql-analysis.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:33: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/codeql-analysis.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:38: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/codeql-analysis.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/coverage.yml:25: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/coverage.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/coverage.yml:30: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/coverage.yml/master?enable=pin","Warn: third-party GitHubAction not pinned by hash: .github/workflows/coverage.yml:60: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/coverage.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/docs-deploy.yml:23: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/docs-deploy.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/docs-deploy.yml:24: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/docs-deploy.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/docs-deploy.yml:30: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/docs-deploy.yml/master?enable=pin","Warn: third-party GitHubAction not pinned by hash: .github/workflows/docs-deploy.yml:48: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/docs-deploy.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/integration-tests.yml:116: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/integration-tests.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/integration-tests.yml:120: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/integration-tests.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/integration-tests.yml:38: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/integration-tests.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/integration-tests.yml:43: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/integration-tests.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/linting.yml:26: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/linting.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/linting.yml:31: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/linting.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/unit-tests.yml:26: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/unit-tests.yml/master?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/unit-tests.yml:31: update your workflow using https://app.stepsecurity.io/secureworkflow/knex/knex/unit-tests.yml/master?enable=pin","Warn: npmCommand not pinned by hash: .github/workflows/coverage.yml:40","Warn: npmCommand not pinned by hash: .github/workflows/coverage.yml:43","Warn: npmCommand not pinned by hash: .github/workflows/integration-tests.yml:60","Warn: npmCommand not pinned by hash: .github/workflows/integration-tests.yml:71","Warn: npmCommand not pinned by hash: .github/workflows/integration-tests.yml:131","Warn: npmCommand not pinned by hash: .github/workflows/linting.yml:38","Warn: npmCommand not pinned by hash: .github/workflows/unit-tests.yml:38","Warn: npmCommand not pinned by hash: .github/workflows/unit-tests.yml:41","Info:   0 out of  16 GitHub-owned GitHubAction dependencies pinned","Info:   0 out of   2 third-party GitHubAction dependencies pinned","Info:   1 out of   9 npmCommand dependencies pinned"],"documentation":{"short":"Determines if the project has declared and pinned the dependencies of its build process.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#pinned-dependencies"}},{"name":"Binary-Artifacts","score":10,"reason":"no binaries found in the repo","details":null,"documentation":{"short":"Determines if the project has generated executable (binary) artifacts in the source repository.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#binary-artifacts"}},{"name":"CII-Best-Practices","score":0,"reason":"no effort to earn an OpenSSF best practices badge detected","details":null,"documentation":{"short":"Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#cii-best-practices"}},{"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":{"short":"Determines if the project has published a security policy.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#security-policy"}},{"name":"Signed-Releases","score":-1,"reason":"no releases found","details":null,"documentation":{"short":"Determines if the project cryptographically signs release artifacts.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#signed-releases"}},{"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":{"short":"Determines if the project has defined a license.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#license"}},{"name":"Branch-Protection","score":-1,"reason":"internal error: error during branchesHandler.setup: internal error: githubv4.Query: Resource not accessible by integration","details":null,"documentation":{"short":"Determines if the default and release branches are protected with GitHub's branch protection settings.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#branch-protection"}},{"name":"Fuzzing","score":0,"reason":"project is not fuzzed","details":["Warn: no fuzzer integrations found"],"documentation":{"short":"Determines if the project uses fuzzing.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#fuzzing"}},{"name":"Vulnerabilities","score":0,"reason":"13 existing vulnerabilities detected","details":["Warn: Project is vulnerable to: GHSA-67mh-4wv8-2f99","Warn: Project is vulnerable to: GHSA-mwcw-c2x4-8c55","Warn: Project is vulnerable to: GHSA-x7hr-w5r2-h6wg","Warn: Project is vulnerable to: GHSA-gcx4-mw62-g8wm","Warn: Project is vulnerable to: GHSA-8jhw-289h-jh2g","Warn: Project is vulnerable to: GHSA-64vr-g452-qvp3","Warn: Project is vulnerable to: GHSA-9cwx-2883-4wfx","Warn: Project is vulnerable to: GHSA-vg6x-rcgg-rjx6","Warn: Project is vulnerable to: GHSA-x574-m823-4x7w","Warn: Project is vulnerable to: GHSA-4r4m-qw57-chr8","Warn: Project is vulnerable to: GHSA-xcj6-pq6g-qj4x","Warn: Project is vulnerable to: GHSA-356w-63v5-8wf4","Warn: Project is vulnerable to: GHSA-859w-5945-r5v3"],"documentation":{"short":"Determines if the project has open, known unfixed vulnerabilities.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#vulnerabilities"}},{"name":"SAST","score":7,"reason":"SAST tool detected but not run on all commits","details":["Info: SAST configuration detected: CodeQL","Warn: 3 commits out of 26 are checked with a SAST tool"],"documentation":{"short":"Determines if the project uses static code analysis.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#sast"}}]},"last_synced_at":"2025-08-20T14:35:52.986Z","repository_id":6134752,"created_at":"2025-08-20T14:35:52.986Z","updated_at":"2025-08-20T14:35:52.986Z"},"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":286080680,"owners_count":33420914,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-05-23T22:14:44.296Z","status":"online","status_checked_at":"2026-05-24T02:00:06.296Z","response_time":57,"last_error":null,"robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":true,"can_crawl_api":true,"host_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories","repository_names_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repository_names","owners_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners"},"tags":[]},"repo_metadata_updated_at":"2026-05-24T04:22:08.319Z","dependent_packages_count":0,"downloads":23,"downloads_period":"last-month","dependent_repos_count":0,"rankings":{"downloads":40.02300089521233,"dependent_repos_count":25.30552159382132,"dependent_packages_count":32.889739249478886,"stargazers_count":0.9360203937726748,"forks_count":1.131074976857722,"average":20.05707142182859},"purl":"pkg:npm/%40beequeue/knex","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/npm/@beequeue/knex","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/npm/@beequeue/knex","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/npm/@beequeue/knex/dependencies","status":"deprecated","funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2025-10-24T05:01:54.980Z","issues_count":821,"pull_requests_count":318,"avg_time_to_close_issue":86872496.29820052,"avg_time_to_close_pull_request":15669613.48366013,"issues_closed_count":389,"pull_requests_closed_count":153,"pull_request_authors_count":141,"issue_authors_count":644,"avg_comments_per_issue":4.023142509135201,"avg_comments_per_pull_request":2.2767295597484276,"merged_pull_requests_count":69,"bot_issues_count":0,"bot_pull_requests_count":74,"past_year_issues_count":89,"past_year_pull_requests_count":52,"past_year_avg_time_to_close_issue":9114397.76923077,"past_year_avg_time_to_close_pull_request":995844.4285714285,"past_year_issues_closed_count":13,"past_year_pull_requests_closed_count":14,"past_year_pull_request_authors_count":30,"past_year_issue_authors_count":56,"past_year_avg_comments_per_issue":0.5730337078651685,"past_year_avg_comments_per_pull_request":0.17307692307692307,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":11,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/knex%2Fknex/issues","maintainers":[{"login":"elhigu","count":39,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/elhigu"},{"login":"mercmobily","count":27,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mercmobily"},{"login":"kibertoad","count":18,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/kibertoad"},{"login":"rluvaton","count":12,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/rluvaton"},{"login":"wubzz","count":9,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/wubzz"},{"login":"code-ape","count":8,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/code-ape"},{"login":"OlivierCavadenti","count":6,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/OlivierCavadenti"},{"login":"rijkvanzanten","count":3,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/rijkvanzanten"},{"login":"tgriesser","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/tgriesser"},{"login":"ricardograca","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/ricardograca"},{"login":"maximelkin","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/maximelkin"},{"login":"rhys-vdw","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/rhys-vdw"},{"login":"koskimas","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/koskimas"},{"login":"rubengmurray","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/rubengmurray"}],"active_maintainers":[{"login":"mercmobily","count":27,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mercmobily"},{"login":"kibertoad","count":6,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/kibertoad"},{"login":"code-ape","count":3,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/code-ape"},{"login":"OlivierCavadenti","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/OlivierCavadenti"},{"login":"rubengmurray","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/rubengmurray"}]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@beequeue%2Fknex/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@beequeue%2Fknex/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@beequeue%2Fknex/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@beequeue%2Fknex/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@beequeue%2Fknex/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@beequeue%2Fknex/codemeta","maintainers":[{"uuid":"beequeue","login":"beequeue","name":null,"email":"ahaglund@paypal.com","url":null,"packages_count":30,"html_url":"https://www.npmjs.com/~beequeue","role":null,"created_at":"2023-01-24T00:45:01.658Z","updated_at":"2023-01-24T00:45:01.658Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/beequeue/packages"}]}