Публічний реєстрПомірний
Звіт про здоров'я програмного забезпеченнясхема 0.17.0 · метрики 1.13.0 · 2026-07-21 06:43 UTC
SQLAnvil / sqlanvil
Analytics engineering for Postgres & Supabase — Dataform-style SQL workflows (SQLX, refs, assertions, incremental tables, materialized views).
SQLAnvil/sqlanvil має індекс здоров’я 60 зі 100, що відповідає смузі «Помірний». Найвищий показник — Vitality (88/100), найнижчий — Community & Adoption (33/100). Останнє оновлення — сьогодні. Більшість нещодавньої роботи виконують 3 учасники.
60
загалом / 100Індекс здоров'я програмного забезпечення
Метрики згруповано у зважені категорії на шкалі 1–100. Загальна оцінка починається як їхнє середнє; коли публічні дані активують Політику юрисдикцій високого ризику, рейтинг коригується й отримує верхню межу 49 («Під ризиком»). Готовність до ШІ не входить до індексу.
60
Відмінний85-100Зразковий; відповідає практично всім перевіреним критеріям
Добрий70-84Здоровий; незначні прогалини
Помірний50-69Прийнятний, але з помітними прогалинами; рекомендовано перевірку
У зоні ризику30-49Суттєві слабкі місця; впровадження потребує обережності
Критичний1-29Серйозні проблеми (покинутий, єдиний мейнтейнер, без базової гігієни)
Профіль оцінок
Кожна вісь — окрема категорія. Форма важить більше, ніж середнє: здоровий об'єкт заповнює всю фігуру, тоді як профіль із піками та провалами означає, що сила в одному вимірі маскує ризик в іншому.
Власність
SQLAnvilОрганізація
0 підписників6 публічних репозиторіївз трав. 2026 р.
За цим репозиторієм стоїть організація — спільна, підзвітна опіка, здатна пережити будь-якого окремого мейнтейнера.
Метрики за категоріями
Життєздатність
Чи живий проєкт — чи пишеться код і чи виходять релізи?
88
Активність розробки
80Добрий
Як обчислюється оцінка
| 36/36 | Свіжість push — останній push 0 дн. тому |
| 26.3/36 | Ритм комітів — 38/52 тижнів із комітами |
| 18/18 | Обсяг комітів — 425 комітів за останній рік |
| 0/10 | OpenSSF Scorecard: Maintained — project was created within the last 90 days. Please review its contents carefully |
Використані вхідні дані
| commits_last_year | 425 |
| human_commit_share | — |
| days_since_last_push | 0 |
| active_weeks_last_year | 38 |
Дисципліна релізів
100Відмінний
Як обчислюється оцінка
| 27/27 | Випускає релізи — опубліковано 34 релізів |
| 36/36 | Свіжість релізів — останній реліз 4 дн. тому |
| 27/27 | Ритм релізів — реліз кожні ~1,5 дн. |
| 0/10 | OpenSSF Scorecard: Signed-Releases — немає даних |
Використані вхідні дані
| releases_count | 34 |
| latest_release_tag | v1.24.0 |
| releases_from_tags | ні |
| days_since_latest_release | 4 |
| mean_days_between_releases | 1,5 |
Виключено з оцінювання (немає даних або не застосовно): OpenSSF Scorecard: Signed-Releases. Залишкові ваги перенормовано.
Спільнота та впровадження
Чи має проєкт користувачів, завантаження, увагу та влаштовані умови для контриб’юторів?
33
Популярність і впровадження
1Критичний
Як обчислюється оцінка
| 0/60 | Зірки — 1 зірок |
| 0/25 | Форки — 0 форків |
| 0/15 | Спостерігачі — 0 спостерігачів |
Використані вхідні дані
| forks | 0 |
| stars | 1 |
| watchers | 0 |
| growth_state | unverified |
| growth_factor_pct | 100 |
| growth_unverified_reason | below_threshold |
Здоров'я спільноти
70Добрий
Як обчислюється оцінка
| 22.5/22.5 | README |
| 22.5/22.5 | Ліцензія — визнана ліцензія (Apache-2.0) |
| 18/18 | Настанови CONTRIBUTING |
| 0/13.5 | Кодекс поведінки |
| 0/7.2 | Шаблон issue |
| 0/6.3 | Шаблон PR |
Використані вхідні дані
| has_readme | так |
| has_license | так |
| has_contributing | так |
| has_issue_template | ні |
| has_code_of_conduct | ні |
| has_pull_request_template | ні |
Сталість та врядування
Чи переживе проєкт своїх людей — бас-фактор, реактивність, хто за ним стоїть і як супроводжуються пакети?
57
Як обчислюється оцінка
| 36/54 | Бас-фактор — на 3 контриб’ютор(ів) припадає половина всіх комітів |
| 15.5/22.5 | Розподіл комітів — головний контриб’ютор — автор 31% комітів |
| 13.5/13.5 | Широта контриб’юторів — 68 контриб’юторів |
| 10/10 | OpenSSF Scorecard: Contributors — project has 13 contributing companies or organizations |
Використані вхідні дані
| bus_factor | 3 |
| contributors_sampled | 68 |
| top_contributor_share | 0,309 |
Реактивність на issue та PR
56Помірний
Як обчислюється оцінка
| 39.3/46.8 | Вирішення issue — закрито 84% issue |
| 16.6/38.3 | Прийняття PR — злито 10/23 вирішених PR |
| 0/15 | OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
Використані вхідні дані
| merged_prs | 10 |
| open_issues | 4 |
| closed_issues | 21 |
| issue_closed_ratio | 0,84 |
| closed_unmerged_prs | 13 |
Власність та опіка
36У зоні ризику
Як обчислюється оцінка
| 30/30 | Підтримка власника — у власності організації |
| 0/20 | Верифікований домен |
| 0/25 | Охоплення власника — 0 підписників у SQLAnvil |
| 6.4/25 | Послужний список — 6 публічних репозиторіїв, вік облікового запису ~0 р. |
Використані вхідні дані
| followers | 0 |
| owner_type | Organization |
| is_verified | — |
| owner_login | SQLAnvil |
| public_repos | 6 |
| account_age_days | 52 |
Інженерна якість
Чи наявні базові інженерні практики та документація?
76
Інженерні практики
60Помірний
Як обчислюється оцінка
| 24/24 | Процеси CI — 1 процес(ів) CI |
| 24/24 | Наявні тести |
| 0/16 | Конфігурація лінтера |
| 0/9.6 | Pre-commit-хуки |
| 0/6.4 | .editorconfig |
| 0/20 | OpenSSF Scorecard: CI-Tests — немає даних |
Використані вхідні дані
| has_ci | так |
| has_tests | так |
| has_editorconfig | ні |
| has_linter_config | ні |
| has_precommit_config | ні |
Виключено з оцінювання (немає даних або не застосовно): OpenSSF Scorecard: CI-Tests. Залишкові ваги перенормовано.
Документація
100Відмінний
Як обчислюється оцінка
| 30/30 | README |
| 25/25 | Каталог документації |
| 15/15 | Сайт документації / домашня сторінка — https://sqlanvil.com/docs |
| 10/10 | Опис репозиторію |
| 10/10 | Теми — 10 тем |
| 10/10 | Wiki |
Використані вхідні дані
| topics | analytics-engineering, bigquery, cli, data-transformation, dataform, dbt-alternative, elt, postgres, sql, supabase |
| has_wiki | так |
| homepage | https://sqlanvil.com/docs |
| has_readme | так |
| has_docs_dir | так |
| has_description | так |
Безпека
Чи міцні видимі практики безпеки й ланцюга постачання, без непослабленої пов’язаності з юрисдикціями високого ризику?
36
Стан безпеки
36У зоні ризику
Як обчислюється оцінка
| 7.5/7.5 | Binary-Artifacts — no binaries found in the repo |
| 2.2/7.5 | Branch-Protection — branch protection is not maximal on development and all release branches |
| 0/2.5 | CI-Tests — немає даних |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 0/7.5 | Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
| 2.5/2.5 | Contributors — project has 13 contributing companies or organizations |
| 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 | Ліцензія — license file detected |
| 0/7.5 | Maintained — project was created within the last 90 days. Please review its contents carefully |
| 0/5 | Packaging — немає даних |
| 0/5 | Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
| 0/5 | SAST — no SAST tool detected |
| 0/5 | Security-Policy — security policy file not detected |
| 0/7.5 | Signed-Releases — немає даних |
| 0/7.5 | Token-Permissions — detected GitHub workflow tokens with excessive permissions |
| 0/7.5 | Vulnerabilities — 46 existing vulnerabilities detected |
Використані вхідні дані
| source | openssf_scorecard |
| checks_evaluated | 15 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 3 |
| scorecard_aggregate | 3,6 |
Виключено з оцінювання (немає даних або не застосовно): ci_tests, packaging, signed_releases. Залишкові ваги перенормовано.
Готовність до ШІ
Наскільки репозиторій оснащений для розробки та супроводу за участі ШІ-агентів? Незалежний, експериментальний бейдж — вага 0.0, тож він подається окремо і не впливає на загальний індекс здоров'я.
70
Контекст і настанови для агентів
75Добрий
Як обчислюється оцінка
| 45/45 | Інструкції для агентів — AGENTS.md, CLAUDE.md, GEMINI.md |
| 0/15 | Машиночитана документація (llms.txt) |
| 0/40 | Читабельна історія комітів — немає даних |
Використані вхідні дані
| has_llms_txt | ні |
| legible_history_share | — |
| agent_instruction_files | AGENTS.md, CLAUDE.md, GEMINI.md |
| agent_instruction_max_bytes | 24 699 |
Виключено з оцінювання (немає даних або не застосовно): Читабельна історія комітів. Залишкові ваги перенормовано.
Як обчислюється оцінка
| 0/18 | Розгортання однією командою |
| 22/22 | Автоматизовані тести |
| 0/11 | Конфігурація лінтера / форматера |
| 11/11 | Статична перевірка типів — tsconfig.json |
| 10/10 | Відтворюване середовище — Dockerfile, lockfile |
| 0/10 | Підтверджена практика роботи з агентами — немає даних |
| 0/8 | Автоматизоване супроводження — немає даних |
| 0/10 | OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
Використані вхідні дані
| has_nix | ні |
| has_tests | так |
| lockfiles | package-lock.json, yarn.lock |
| has_dockerfile | так |
| typed_language | так |
| bootstrap_files | — |
| has_devcontainer | ні |
| has_linter_config | ні |
| typecheck_configs | tsconfig.json |
| agent_commit_share | — |
| toolchain_manifests | — |
| dependency_bot_commit_share | — |
Виключено з оцінювання (немає даних або не застосовно): Підтверджена практика роботи з агентами, Автоматизоване супроводження. Залишкові ваги перенормовано.
Читабельність коду для моделей
100Відмінний
Як обчислюється оцінка
| 45/45 | Типізований код — TypeScript (статично типізована) |
| 54.5/55 | Керовані розміри файлів — 2/220 файлів вихідного коду понад 60 КБ |
Використані вхідні дані
| primary_language | TypeScript |
| largest_source_bytes | 98 174 |
| source_files_sampled | 220 |
| oversized_source_files | 2 |
Машиночитні інтерфейси
80Добрий
Як обчислюється оцінка
| 40/40 | Схема API (OpenAPI/GraphQL/proto) — protos/configs.proto, protos/core.proto, protos/db_adapter.proto, protos/evaluation.proto, protos/execution.proto, protos/extension.proto, protos/jit.proto, protos/profiles.proto |
| 0/20 | Сервер MCP |
| 40/40 | Придатні до запуску приклади — examples, notebooks |
Використані вхідні дані
| example_dirs | examples, notebooks |
| has_mcp_signal | ні |
| api_schema_files | protos/configs.proto, protos/core.proto, protos/db_adapter.proto, protos/evaluation.proto, protos/execution.proto, protos/extension.proto, protos/jit.proto, protos/profiles.proto |
Ключові факти
1зірок GitHub
68контриб'юторів
425комітів за останні 12 місяців
0днів від останнього пушу
34релізів
3бас-фактор
4відкритих issue
npmпакетних екосистем
Попередження щодо збору даних
- Could not fetch npm package 'sqlanvil' from its registry
- GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository
Докладніше
OpenSSF Scorecard 3.6 / 10
3.6сукупно
Незалежна, не прив'язана до інструментів оцінка безпеки від відкритого проєкту OpenSSF Scorecard. Кожна перевірка винагороджує практику безпеки, а не інструмент конкретного постачальника. Перевірки, які Scorecard не зміг визначити, позначено н/д і виключено з оцінки безпеки (вони ніколи не зараховуються як нуль).
| 10 | Binary-Artifacts | no binaries found in the repo |
| 3 | Branch-Protection | branch protection is not maximal on development and all release branches |
| н/д | CI-Tests | no pull request found |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 0 | Code-Review | Found 0/30 approved changesets -- score normalized to 0 |
| 10 | Contributors | project has 13 contributing companies or organizations |
| 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 |
| 0 | Maintained | project was created within the last 90 days. Please review its contents carefully |
| н/д | Packaging | packaging workflow not detected |
| 0 | Pinned-Dependencies | dependency not pinned by hash detected -- score normalized to 0 |
| 0 | SAST | no SAST tool detected |
| 0 | Security-Policy | security policy file not detected |
| н/д | Signed-Releases | no releases found |
| 0 | Token-Permissions | detected GitHub workflow tokens with excessive permissions |
| 0 | Vulnerabilities | 46 existing vulnerabilities detected |
Прямі залежності 94
| Реєстр | Пакет | Обмеження версії | Маніфест |
|---|---|---|---|
| npm | @bazel/hide-bazel-files | 1.0.0 | package.json |
| npm | @bazel/ibazel | ^0.9.1 | package.json |
| npm | @bazel/labs | ^0.42.3 | package.json |
| npm | @bazel/rollup | ^3.0.0 | package.json |
| npm | @bazel/typescript | ^3.0.0 | package.json |
| npm | @google-cloud/bigquery | ~8.3.0 | package.json |
| npm | @google-cloud/storage | ^7.19.0 | package.json |
| npm | google-auth-library | ^9.15.1 | package.json |
| npm | @rollup/plugin-node-resolve | ^7.1.3 | package.json |
| npm | @types/chai | ^4.1.7 | package.json |
| npm | @types/diff | ^4.0.2 | package.json |
| npm | @types/es6-shim | ^0.31.37 | package.json |
| npm | @types/fs-extra | ^8.1.0 | package.json |
| npm | @types/glob | ^8.1.0 | package.json |
| npm | @types/js-beautify | ^1.8.1 | package.json |
| npm | @types/js-yaml | ^4.0.5 | package.json |
| npm | @types/json-stable-stringify | ^1.0.32 | package.json |
| npm | @types/long | ^4.0.0 | package.json |
| npm | @types/moo | ^0.5.0 | package.json |
| npm | @types/node | ^16.16.0 | package.json |
| npm | @types/pg | ^8.11.0 | package.json |
| npm | @types/readline-sync | ^1.4.3 | package.json |
| npm | @types/request | ^2.48.3 | package.json |
| npm | @types/rimraf | ^2.0.2 | package.json |
| npm | @types/semver | ^7.3.13 | package.json |
| npm | @types/tmp | ^0.2.0 | package.json |
| npm | @types/uuid | ^9.0.0 | package.json |
| npm | @types/vscode | ^1.45.1 | package.json |
| npm | @types/yargs | ^15.0.5 | package.json |
| npm | chai | ^4.2.0 | package.json |
| npm | chalk | ^4.0.0 | package.json |
| npm | chokidar | ^3.5.3 | package.json |
| npm | deepmerge | ^4.2.2 | package.json |
| npm | diff | ^8.0.3 | package.json |
| npm | @duckdb/node-api | ^1.5.4-r.1 | package.json |
| npm | escodegen | ^1.13.0 | package.json |
| npm | espree | ^7.0.0 | package.json |
| npm | estraverse | ^5.1.0 | package.json |
| npm | fs-extra | ^9.0.0 | package.json |
| npm | glob | 13.0.6 | package.json |
| npm | google-sql-syntax-ts | ^1.0.3 | package.json |
| npm | js-beautify | ^1.10.2 | package.json |
| npm | js-yaml | ^4.2.0 | package.json |
| npm | jsdoc | ^3.6.11 | package.json |
| npm | json-stable-stringify | ^1.0.1 | package.json |
| npm | long | ^4.0.0 | package.json |
| npm | minimist | ^1.2.6 | package.json |
| npm | moo | ^0.5.0 | package.json |
| npm | mysql2 | ^3.11.0 | package.json |
| npm | object-sizeof | ^1.6.1 | package.json |
| npm | parse-duration | ^1.0.0 | package.json |
| npm | pg | ^8.11.3 | package.json |
| npm | pg-query-stream | ^4.5.3 | package.json |
| npm | prettier | ^1.14.2 | package.json |
| npm | promise-pool-executor | ^1.1.1 | package.json |
| npm | protobufjs | ^7.6.3 | package.json |
| npm | protobufjs-cli | ^1.3.3 | package.json |
| npm | readline-sync | ^1.4.9 | package.json |
| npm | request | ^2.88.0 | package.json |
| npm | rimraf | ^2.6.2 | package.json |
| npm | rollup | ^2.80.0 | package.json |
| npm | rollup-plugin-dts | ^1.4.0 | package.json |
| npm | semver | ^7.5.2 | package.json |
| npm | source-map-support | ^0.5.21 | package.json |
| npm | tarjan-graph | ^2.0.0 | package.json |
| npm | tmp | ^0.2.7 | package.json |
| npm | ts-loader | ^5.3.1 | package.json |
| npm | ts-mockito | ^2.6.1 | package.json |
| npm | tslint | ^5.14.0 | package.json |
| npm | tslint-config-prettier | ^1.18.0 | package.json |
| npm | tslint-config-security | ^1.16.0 | package.json |
| npm | typedoc | 0.17.8 | package.json |
| npm | typedoc-plugin-markdown | 2.2.17 | package.json |
| npm | typeid-js | 0.3.0 | package.json |
| npm | typescript | ^3.8.3 | package.json |
| npm | uglify-es | ^3.3.9 | package.json |
| npm | uglify-js | ^3.7.7 | package.json |
| npm | untildify | ^4.0.0 | package.json |
| npm | url | ^0.11.0 | package.json |
| npm | uuid | ^9.0.0 | package.json |
| npm | vm2 | 3.11.4 | package.json |
| npm | vsce | ^1.79.5 | package.json |
| npm | vscode-jsonrpc | ^5.0.1 | package.json |
| npm | vscode-languageclient | ^6.1.3 | package.json |
| npm | vscode-languageserver | ^6.1.1 | package.json |
| npm | vscode-languageserver-protocol | ^3.15.3 | package.json |
| npm | vscode-languageserver-textdocument | ^1.0.1 | package.json |
| npm | vscode-languageserver-types | 3.15.1 | package.json |
| npm | webpack | 5.104.1 | package.json |
| npm | webpack-cli | 4.10.0 | package.json |
| npm | yargs | ^16.2.0 | package.json |
| npm | vscode-languageclient | ^6.1.3 | vscode/package.json |
| npm | vscode-languageserver | ^6.1.1 | vscode/package.json |
| npm | vscode-languageserver-textdocument | ^1.0.1 | vscode/package.json |
Усі залежності не зібрано
Не вдалося зібрати розв'язаний набір залежностей для цього звіту: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository
Звіт у форматі JSON машиночитний
{
"data": {
"repo": {
"topics": [
"analytics-engineering",
"bigquery",
"cli",
"data-transformation",
"dataform",
"dbt-alternative",
"elt",
"postgres",
"sql",
"supabase"
],
"is_fork": false,
"size_kb": 18123,
"has_wiki": true,
"homepage": "https://sqlanvil.com/docs",
"languages": {
"Shell": 18854,
"Python": 3056,
"Starlark": 76062,
"Dockerfile": 967,
"JavaScript": 12575,
"TypeScript": 1765150,
"Go Template": 236
},
"pushed_at": "2026-07-21T03:50:55Z",
"created_at": "2026-05-25T18:04:38Z",
"owner_type": "Organization",
"updated_at": "2026-07-21T03:51:09Z",
"description": "Analytics engineering for Postgres & Supabase — Dataform-style SQL workflows (SQLX, refs, assertions, incremental tables, materialized views).",
"is_archived": false,
"is_disabled": false,
"license_spdx": "Apache-2.0",
"default_branch": "main",
"license_spdx_raw": "Apache-2.0",
"primary_language": "TypeScript",
"significant_languages": [
"TypeScript"
]
},
"owner": {
"blog": "https://sqlanvil.com",
"name": "SQLAnvil",
"type": "Organization",
"login": "SQLAnvil",
"company": null,
"location": "United States of America",
"followers": 0,
"avatar_url": "https://avatars.githubusercontent.com/u/289101749?v=4",
"created_at": "2026-05-30T02:20:09Z",
"is_verified": null,
"public_repos": 6,
"account_age_days": 52
},
"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": 34,
"commits_last_year": 425,
"latest_release_at": "2026-07-16T17:05:54Z",
"latest_release_tag": "v1.24.0",
"releases_from_tags": false,
"days_since_last_push": 0,
"active_weeks_last_year": 38,
"days_since_latest_release": 4,
"mean_days_between_releases": 1.5
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": true,
"health_percentage": 50,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": []
},
"popularity": {
"forks": 0,
"stars": 1,
"watchers": 0,
"star_history": {
"days": [
{
"date": "2026-06-19",
"count": 1
}
],
"complete": true,
"collected": 1,
"total_stars": 1
},
"open_issues_and_prs": 4
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [
"examples",
"notebooks"
],
"has_llms_txt": false,
"has_dockerfile": true,
"has_mcp_signal": false,
"bootstrap_files": [],
"api_schema_files": [
"protos/configs.proto",
"protos/core.proto",
"protos/db_adapter.proto",
"protos/evaluation.proto",
"protos/execution.proto",
"protos/extension.proto",
"protos/jit.proto",
"protos/profiles.proto"
],
"has_devcontainer": false,
"typecheck_configs": [
"tsconfig.json"
],
"largest_source_bytes": 98174,
"source_files_sampled": 220,
"oversized_source_files": 2,
"agent_instruction_files": [
"AGENTS.md",
"CLAUDE.md",
"GEMINI.md"
],
"agent_instruction_max_bytes": 24699
},
"dependencies": {
"manifests": [
"package.json",
"vscode/package.json"
],
"advisories": {
"error": null,
"scope": null,
"source": null,
"findings": [],
"collected": false,
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 0,
"assessed_package": null,
"unassessed_count": 0,
"direct_affected_count": 0
},
"ecosystems": [
"npm"
],
"dependencies": [
{
"name": "@bazel/hide-bazel-files",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "1.0.0"
},
{
"name": "@bazel/ibazel",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^0.9.1"
},
{
"name": "@bazel/labs",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^0.42.3"
},
{
"name": "@bazel/rollup",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^3.0.0"
},
{
"name": "@bazel/typescript",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^3.0.0"
},
{
"name": "@google-cloud/bigquery",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "~8.3.0"
},
{
"name": "@google-cloud/storage",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^7.19.0"
},
{
"name": "google-auth-library",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^9.15.1"
},
{
"name": "@rollup/plugin-node-resolve",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^7.1.3"
},
{
"name": "@types/chai",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.1.7"
},
{
"name": "@types/diff",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.0.2"
},
{
"name": "@types/es6-shim",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^0.31.37"
},
{
"name": "@types/fs-extra",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^8.1.0"
},
{
"name": "@types/glob",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^8.1.0"
},
{
"name": "@types/js-beautify",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.8.1"
},
{
"name": "@types/js-yaml",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.0.5"
},
{
"name": "@types/json-stable-stringify",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.0.32"
},
{
"name": "@types/long",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.0.0"
},
{
"name": "@types/moo",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^0.5.0"
},
{
"name": "@types/node",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^16.16.0"
},
{
"name": "@types/pg",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^8.11.0"
},
{
"name": "@types/readline-sync",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.4.3"
},
{
"name": "@types/request",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^2.48.3"
},
{
"name": "@types/rimraf",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^2.0.2"
},
{
"name": "@types/semver",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^7.3.13"
},
{
"name": "@types/tmp",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^0.2.0"
},
{
"name": "@types/uuid",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^9.0.0"
},
{
"name": "@types/vscode",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.45.1"
},
{
"name": "@types/yargs",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^15.0.5"
},
{
"name": "chai",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.2.0"
},
{
"name": "chalk",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.0.0"
},
{
"name": "chokidar",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^3.5.3"
},
{
"name": "deepmerge",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.2.2"
},
{
"name": "diff",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^8.0.3"
},
{
"name": "@duckdb/node-api",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.5.4-r.1"
},
{
"name": "escodegen",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.13.0"
},
{
"name": "espree",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^7.0.0"
},
{
"name": "estraverse",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^5.1.0"
},
{
"name": "fs-extra",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^9.0.0"
},
{
"name": "glob",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "13.0.6"
},
{
"name": "google-sql-syntax-ts",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.0.3"
},
{
"name": "js-beautify",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.10.2"
},
{
"name": "js-yaml",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.2.0"
},
{
"name": "jsdoc",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^3.6.11"
},
{
"name": "json-stable-stringify",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.0.1"
},
{
"name": "long",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.0.0"
},
{
"name": "minimist",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.2.6"
},
{
"name": "moo",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^0.5.0"
},
{
"name": "mysql2",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^3.11.0"
},
{
"name": "object-sizeof",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.6.1"
},
{
"name": "parse-duration",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.0.0"
},
{
"name": "pg",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^8.11.3"
},
{
"name": "pg-query-stream",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.5.3"
},
{
"name": "prettier",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.14.2"
},
{
"name": "promise-pool-executor",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.1.1"
},
{
"name": "protobufjs",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^7.6.3"
},
{
"name": "protobufjs-cli",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.3.3"
},
{
"name": "readline-sync",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.4.9"
},
{
"name": "request",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^2.88.0"
},
{
"name": "rimraf",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^2.6.2"
},
{
"name": "rollup",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^2.80.0"
},
{
"name": "rollup-plugin-dts",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.4.0"
},
{
"name": "semver",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^7.5.2"
},
{
"name": "source-map-support",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^0.5.21"
},
{
"name": "tarjan-graph",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^2.0.0"
},
{
"name": "tmp",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^0.2.7"
},
{
"name": "ts-loader",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^5.3.1"
},
{
"name": "ts-mockito",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^2.6.1"
},
{
"name": "tslint",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^5.14.0"
},
{
"name": "tslint-config-prettier",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.18.0"
},
{
"name": "tslint-config-security",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.16.0"
},
{
"name": "typedoc",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "0.17.8"
},
{
"name": "typedoc-plugin-markdown",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "2.2.17"
},
{
"name": "typeid-js",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "0.3.0"
},
{
"name": "typescript",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^3.8.3"
},
{
"name": "uglify-es",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^3.3.9"
},
{
"name": "uglify-js",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^3.7.7"
},
{
"name": "untildify",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^4.0.0"
},
{
"name": "url",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^0.11.0"
},
{
"name": "uuid",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^9.0.0"
},
{
"name": "vm2",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "3.11.4"
},
{
"name": "vsce",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.79.5"
},
{
"name": "vscode-jsonrpc",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^5.0.1"
},
{
"name": "vscode-languageclient",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^6.1.3"
},
{
"name": "vscode-languageserver",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^6.1.1"
},
{
"name": "vscode-languageserver-protocol",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^3.15.3"
},
{
"name": "vscode-languageserver-textdocument",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^1.0.1"
},
{
"name": "vscode-languageserver-types",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "3.15.1"
},
{
"name": "webpack",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "5.104.1"
},
{
"name": "webpack-cli",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "4.10.0"
},
{
"name": "yargs",
"manifest": "package.json",
"ecosystem": "npm",
"version_constraint": "^16.2.0"
},
{
"name": "vscode-languageclient",
"manifest": "vscode/package.json",
"ecosystem": "npm",
"version_constraint": "^6.1.3"
},
{
"name": "vscode-languageserver",
"manifest": "vscode/package.json",
"ecosystem": "npm",
"version_constraint": "^6.1.1"
},
{
"name": "vscode-languageserver-textdocument",
"manifest": "vscode/package.json",
"ecosystem": "npm",
"version_constraint": "^1.0.1"
}
],
"all_dependencies": {
"error": "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository",
"source": null,
"packages": [],
"collected": false,
"truncated": false,
"total_count": null,
"direct_count": null,
"indirect_count": null
}
},
"maintainership": {
"issues": {
"open_prs": 0,
"merged_prs": 10,
"open_issues": 4,
"closed_ratio": 0.84,
"closed_issues": 21,
"closed_unmerged_prs": 13
},
"bus_factor": 3,
"top_contributors": [
{
"type": "User",
"login": "BenBirt",
"commits": 467,
"avatar_url": "https://avatars.githubusercontent.com/u/1123120?v=4"
},
{
"type": "User",
"login": "ihistand",
"commits": 275,
"avatar_url": "https://avatars.githubusercontent.com/u/490193?v=4"
},
{
"type": "User",
"login": "lewish",
"commits": 248,
"avatar_url": "https://avatars.githubusercontent.com/u/912458?v=4"
},
{
"type": "Bot",
"login": "dependabot[bot]",
"commits": 92,
"avatar_url": "https://avatars.githubusercontent.com/in/29110?v=4"
},
{
"type": "User",
"login": "faiyaz26",
"commits": 50,
"avatar_url": "https://avatars.githubusercontent.com/u/1517953?v=4"
},
{
"type": "User",
"login": "G2H",
"commits": 41,
"avatar_url": "https://avatars.githubusercontent.com/u/2012230?v=4"
},
{
"type": "User",
"login": "ShevtsovY",
"commits": 36,
"avatar_url": "https://avatars.githubusercontent.com/u/45006853?v=4"
},
{
"type": "User",
"login": "fernst",
"commits": 25,
"avatar_url": "https://avatars.githubusercontent.com/u/7290959?v=4"
},
{
"type": "User",
"login": "rafal-hawrylak",
"commits": 22,
"avatar_url": "https://avatars.githubusercontent.com/u/33635872?v=4"
},
{
"type": "User",
"login": "ikholopov-omni",
"commits": 21,
"avatar_url": "https://avatars.githubusercontent.com/u/73560138?v=4"
}
],
"contributors_sampled": 68,
"top_contributor_share": 0.309
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"test.yaml"
],
"has_docs_dir": true,
"linter_configs": [],
"has_editorconfig": false,
"has_linter_config": false,
"has_precommit_config": false
},
"security_signals": {
"lockfiles": [
"package-lock.json",
"yarn.lock"
],
"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": 3,
"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": null,
"reason": "no pull request found",
"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": 0,
"reason": "Found 0/30 approved changesets -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 10,
"reason": "project has 13 contributing companies or organizations",
"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": 0,
"reason": "project was created within the last 90 days. Please review its contents carefully",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
},
{
"name": "Packaging",
"score": null,
"reason": "packaging workflow not 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": "no SAST tool detected",
"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": null,
"reason": "no releases found",
"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": 0,
"reason": "46 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "87532b1d90073014fe7d2c4ba678fbe917f0057f",
"ran_at": "2026-07-21T06:43:10Z",
"aggregate_score": 3.6,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": false,
"has_dependabot_config": false
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/SQLAnvil/sqlanvil",
"host": "github.com",
"name": "sqlanvil",
"owner": "SQLAnvil"
},
"metrics": {
"overall": {
"key": "overall",
"band": "moderate",
"name": "Overall health",
"note": null,
"notes": [],
"value": 60,
"inputs": {
"security": 36,
"vitality": 88,
"community": 33,
"governance": 57,
"engineering": 76
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "excellent",
"name": "Vitality",
"value": 88,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "good",
"name": "Development activity",
"note": null,
"notes": [],
"value": 80,
"inputs": {
"commits_last_year": 425,
"human_commit_share": null,
"days_since_last_push": 0,
"active_weeks_last_year": 38
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 0 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "push_recency",
"params": {
"days": 0
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "38/52 weeks with commits",
"points": 26.3,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 38
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "425 commits in the last year",
"points": 18,
"status": "met",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 425
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "project was created within the last 90 days. Please review its contents carefully",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "excellent",
"name": "Release discipline",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 100,
"inputs": {
"releases_count": 34,
"latest_release_tag": "v1.24.0",
"releases_from_tags": false,
"days_since_latest_release": 4,
"mean_days_between_releases": 1.5
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "34 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 34
}
}
],
"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 ~1.5 days",
"points": 27,
"status": "met",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 1.5
}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"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": "repository_too_young",
"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": "at_risk",
"name": "Community & Adoption",
"value": 33,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "critical",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 1,
"inputs": {
"forks": 0,
"stars": 1,
"watchers": 0,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "below_threshold"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "1 stars",
"points": 0,
"status": "missed",
"details": [
{
"code": "stars",
"params": {
"count": 1
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "0 forks",
"points": 0,
"status": "missed",
"details": [
{
"code": "forks",
"params": {
"count": 0
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "0 watchers",
"points": 0,
"status": "missed",
"details": [
{
"code": "watchers",
"params": {
"count": 0
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "good",
"name": "Community health",
"note": null,
"notes": [],
"value": 70,
"inputs": {
"has_readme": true,
"has_license": true,
"has_contributing": true,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"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": 18,
"status": "met",
"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": 0,
"status": "missed",
"details": [],
"max_points": 6.3
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "moderate",
"name": "Sustainability & Governance",
"value": 57,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "good",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 75,
"inputs": {
"bus_factor": 3,
"contributors_sampled": 68,
"top_contributor_share": 0.309
},
"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 31% of commits",
"points": 15.5,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 31
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "68 contributors",
"points": 13.5,
"status": "met",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 68
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 13 contributing companies or organizations",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "moderate",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 56,
"inputs": {
"merged_prs": 10,
"open_issues": 4,
"closed_issues": 21,
"issue_closed_ratio": 0.84,
"closed_unmerged_prs": 13
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "84% of issues closed",
"points": 39.3,
"status": "partial",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 84
}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "10/23 decided PRs merged",
"points": 16.6,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 10,
"decided": 23
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 0/30 approved changesets -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "at_risk",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 36,
"inputs": {
"followers": 0,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "SQLAnvil",
"public_repos": 6,
"account_age_days": 52
},
"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": "0 followers of SQLAnvil",
"points": 0,
"status": "missed",
"details": [
{
"code": "owner_followers",
"params": {
"count": 0,
"login": "SQLAnvil"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "6 public repos, account ~0 yr old",
"points": 6.4,
"status": "partial",
"details": [
{
"code": "public_repos",
"params": {
"count": 6
}
},
{
"code": "account_age_years",
"params": {
"years": 0
}
}
],
"max_points": 25
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "good",
"name": "Engineering Quality",
"value": 76,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "moderate",
"name": "Engineering practices",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: CI-Tests. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_ci_tests"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 60,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": false,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "1 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 1
}
}
],
"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": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 0,
"status": "missed",
"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": "no pull request found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "excellent",
"name": "Documentation",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"topics": [
"analytics-engineering",
"bigquery",
"cli",
"data-transformation",
"dataform",
"dbt-alternative",
"elt",
"postgres",
"sql",
"supabase"
],
"has_wiki": true,
"homepage": "https://sqlanvil.com/docs",
"has_readme": true,
"has_docs_dir": true,
"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": 25,
"status": "met",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": "https://sqlanvil.com/docs",
"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": "10 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 10
}
}
],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "at_risk",
"name": "Security",
"value": 36,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "at_risk",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): CI-Tests, Packaging, Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"ci_tests",
"packaging",
"signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 36,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 15,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 3,
"scorecard_aggregate": 3.6
},
"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": 2.2,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "no pull request found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"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": "Found 0/30 approved changesets -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 13 contributing companies or organizations",
"points": 2.5,
"status": "met",
"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": "project was created within the last 90 days. Please review its contents carefully",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow not detected",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"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": "no SAST tool detected",
"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": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"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": "46 existing vulnerabilities detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
}
]
},
{
"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": "good",
"name": "AI Readiness",
"value": 70,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "good",
"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": 75,
"inputs": {
"has_llms_txt": false,
"legible_history_share": null,
"agent_instruction_files": [
"AGENTS.md",
"CLAUDE.md",
"GEMINI.md"
],
"agent_instruction_max_bytes": 24699
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "AGENTS.md, CLAUDE.md, GEMINI.md",
"points": 45,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "AGENTS.md, CLAUDE.md, GEMINI.md"
}
}
],
"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, Automated maintenance. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"demonstrated_agent_practice",
"automated_maintenance"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 52,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [
"package-lock.json",
"yarn.lock"
],
"has_dockerfile": true,
"typed_language": true,
"bootstrap_files": [],
"has_devcontainer": false,
"has_linter_config": false,
"typecheck_configs": [
"tsconfig.json"
],
"agent_commit_share": null,
"toolchain_manifests": [],
"dependency_bot_commit_share": null
},
"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": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": "tsconfig.json",
"points": 11,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "tsconfig.json"
}
}
],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": "Dockerfile, lockfile",
"points": 10,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Dockerfile, lockfile"
}
}
],
"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": "no data",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"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": "excellent",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"primary_language": "TypeScript",
"largest_source_bytes": 98174,
"source_files_sampled": 220,
"oversized_source_files": 2
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "TypeScript (statically typed)",
"points": 45,
"status": "met",
"details": [
{
"code": "statically_typed_language",
"params": {
"language": "TypeScript"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "2/220 source files over 60KB",
"points": 54.5,
"status": "partial",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 220,
"oversized": 2
}
}
],
"max_points": 55
}
]
},
{
"key": "ai_interfaces",
"band": "good",
"name": "Machine-readable interfaces",
"note": null,
"notes": [],
"value": 80,
"inputs": {
"example_dirs": [
"examples",
"notebooks"
],
"has_mcp_signal": false,
"api_schema_files": [
"protos/configs.proto",
"protos/core.proto",
"protos/db_adapter.proto",
"protos/evaluation.proto",
"protos/execution.proto",
"protos/extension.proto",
"protos/jit.proto",
"protos/profiles.proto"
]
},
"components": [
{
"key": "api_schema_openapi_graphql_proto",
"name": "API schema (OpenAPI/GraphQL/proto)",
"detail": "protos/configs.proto, protos/core.proto, protos/db_adapter.proto, protos/evaluation.proto, protos/execution.proto, protos/extension.proto, protos/jit.proto, protos/profiles.proto",
"points": 40,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "protos/configs.proto, protos/core.proto, protos/db_adapter.proto, protos/evaluation.proto, protos/execution.proto, protos/extension.proto, protos/jit.proto, protos/profiles.proto"
}
}
],
"max_points": 40
},
{
"key": "mcp_server",
"name": "MCP server",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "runnable_examples",
"name": "Runnable examples",
"detail": "examples, notebooks",
"points": 40,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "examples, notebooks"
}
}
],
"max_points": 40
}
]
}
],
"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": [
"Could not fetch npm package 'sqlanvil' from its registry",
"GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository"
],
"report_type": "repository",
"generated_at": "2026-07-21T06:43:26.723371Z",
"schema_version": "0.17.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/s/SQLAnvil/sqlanvil.svg",
"full_name": "SQLAnvil/sqlanvil",
"license_state": "standard",
"license_spdx": "Apache-2.0"
}Оцінки — це сигнали, а не гарантії. Вони відображають публічно видимі практики на GitHub — це не аудит коду й не гарантія безпеки.
Відсутні дані виключаються, а ваги перенормовуються — нуль за відсутність ніколи не ставиться. Методологія версіонована й відкрита: метрики v1.13.0, схема v0.17.0 — повна методологія · вікі метрик.
Як окремий результат виглядає на тлі всього реєстру: сукупна статистика.