statisfy-us / prismiq

Повний розв'язаний набір залежностей із графа залежностей GitHub: 12 прямих і 303 непрямих (транзитивних) пакетів. Транзитивне замикання є повним, коли в репозиторії закомічено lockfile.

Цей репозиторій не публікує пакета, який розпізнає індекс, тож оцінено його власний граф залежностей — 300 пакетів, серед яких є й піниї розробки та тестування, що ніколи не постачаються: 24 мають відомі сповіщення, з них 0 прямі. 15 не вдалося оцінити — немає резолвленої версії, непідтримувана екосистема або поза наведеним переліком пакетів.

Сповіщення означає, що версія, записана в графі залежностей, потрапляє в уражений діапазон. Досяжність не аналізується, а граф містить піниї розробки й тестування — знахідка може стосуватися інструментів, а не поставленого коду.

{
  "data": {
    "repo": {
      "topics": [],
      "is_fork": false,
      "size_kb": 1758,
      "has_wiki": true,
      "homepage": null,
      "languages": {
        "Shell": 2683,
        "Python": 1173614,
        "PLpgSQL": 3574,
        "Makefile": 7213,
        "Starlark": 71,
        "TypeScript": 1153416
      },
      "pushed_at": "2026-07-29T05:47:37Z",
      "created_at": "2026-01-07T05:57:25Z",
      "owner_type": "Organization",
      "updated_at": "2026-07-29T05:47:39Z",
      "description": null,
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "main",
      "license_spdx_raw": "MIT",
      "primary_language": "Python",
      "significant_languages": [
        "Python",
        "TypeScript"
      ]
    },
    "owner": {
      "blog": null,
      "name": null,
      "type": "Organization",
      "login": "statisfy-us",
      "company": null,
      "location": null,
      "followers": 1,
      "avatar_url": "https://avatars.githubusercontent.com/u/151481998?v=4",
      "created_at": "2023-11-20T01:32:37Z",
      "is_verified": null,
      "public_repos": 2,
      "account_age_days": 982
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": true
    },
    "activity": {
      "releases": [
        {
          "tag": "python-v0.2.11",
          "kind": "other",
          "published_at": "2026-07-29T05:47:37Z"
        },
        {
          "tag": "react-v0.2.12",
          "kind": "other",
          "published_at": "2026-07-29T05:47:36Z"
        },
        {
          "tag": "react-v0.2.11",
          "kind": "other",
          "published_at": "2026-07-29T03:57:44Z"
        },
        {
          "tag": "react-v0.2.10",
          "kind": "other",
          "published_at": "2026-07-07T15:05:18Z"
        },
        {
          "tag": "python-v0.2.10",
          "kind": "other",
          "published_at": "2026-05-11T02:36:16Z"
        },
        {
          "tag": "react-v0.2.9",
          "kind": "other",
          "published_at": "2026-05-01T05:26:24Z"
        },
        {
          "tag": "python-v0.2.9",
          "kind": "other",
          "published_at": "2026-05-01T05:26:00Z"
        },
        {
          "tag": "python-v0.2.8",
          "kind": "other",
          "published_at": "2026-04-09T08:05:49Z"
        },
        {
          "tag": "python-v0.2.7",
          "kind": "other",
          "published_at": "2026-04-09T04:07:16Z"
        },
        {
          "tag": "react-v0.2.7",
          "kind": "other",
          "published_at": "2026-04-09T04:06:31Z"
        },
        {
          "tag": "react-v0.2.6",
          "kind": "other",
          "published_at": "2026-04-06T03:45:37Z"
        },
        {
          "tag": "react-v0.2.5",
          "kind": "other",
          "published_at": "2026-03-15T11:03:29Z"
        },
        {
          "tag": "python-v0.2.5",
          "kind": "other",
          "published_at": "2026-03-15T11:03:00Z"
        },
        {
          "tag": "react-v0.2.4",
          "kind": "other",
          "published_at": "2026-02-25T06:04:40Z"
        },
        {
          "tag": "python-v0.2.4",
          "kind": "other",
          "published_at": "2026-02-25T06:02:00Z"
        },
        {
          "tag": "react-v0.2.3",
          "kind": "other",
          "published_at": "2026-02-21T07:00:57Z"
        },
        {
          "tag": "python-v0.2.3",
          "kind": "other",
          "published_at": "2026-02-21T07:00:43Z"
        },
        {
          "tag": "react-v0.2.2",
          "kind": "other",
          "published_at": "2026-02-21T01:44:48Z"
        },
        {
          "tag": "python-v0.2.2",
          "kind": "other",
          "published_at": "2026-02-21T01:44:30Z"
        },
        {
          "tag": "react-v0.2.1",
          "kind": "other",
          "published_at": "2026-02-20T23:51:47Z"
        },
        {
          "tag": "python-v0.2.1",
          "kind": "other",
          "published_at": "2026-02-20T23:50:55Z"
        },
        {
          "tag": "react-v0.2.0",
          "kind": "other",
          "published_at": "2026-02-20T21:02:39Z"
        },
        {
          "tag": "python-v0.2.0",
          "kind": "other",
          "published_at": "2026-02-20T21:01:44Z"
        },
        {
          "tag": "react-v0.1.1",
          "kind": "other",
          "published_at": "2026-02-20T02:27:00Z"
        },
        {
          "tag": "python-v0.1.1",
          "kind": "other",
          "published_at": "2026-02-20T01:47:02Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "4688e2e0d6f4540ddea1fa277a2b80e7286d70d2",
          "body": null,
          "is_bot": false,
          "headline": "Updated versions (#84)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-07-29T05:47:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7076956862e836c1df171c02fc57d9baad967ca7",
          "body": "* LLM hint for hyperlink convention\n\n* crm",
          "is_bot": false,
          "headline": "LLM hint for hyperlink convention (#82)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-07-29T05:40:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bba4becbeca894d88ccf48cbd07ba797a878dc57",
          "body": null,
          "is_bot": false,
          "headline": "Fixed hover issue (#83)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-07-29T05:37:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "572a1d4e209031acdbe0bab8c88c7939ad05f2eb",
          "body": null,
          "is_bot": false,
          "headline": "updated react package version (#81)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-07-29T03:56:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "51b8cba76855fda875d9e89b2e41e457217ca811",
          "body": "* Hyperlink support\n\n* Hyperlink support\n\n* Hyperlink support",
          "is_bot": false,
          "headline": "Hyperlink support (#80)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-07-29T03:53:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b6f66de32d96153a4668cdbe7f3bee49c8026599",
          "body": "* Updated react package version\n\n* Updated react package version",
          "is_bot": false,
          "headline": "Updated react package version (#79)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-07-07T15:03:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3ea465aa83015b24e15686f5c1dfbf292f477215",
          "body": null,
          "is_bot": false,
          "headline": "Right-align numeric column headers to match cells (#78)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-07-07T14:50:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1cffaeaee708d3d21c25350e8e7586bb8789fb1f",
          "body": "* Resolve dashboard filter through derived subqueries/CTEs\n\n* Resolve dashboard filter through derived subqueries/CTEs",
          "is_bot": false,
          "headline": "Resolve dashboard filter through derived subqueries/CTEs (#77)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-05-11T02:34:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "eb63945f3a43055e9dd81b3174ca6e2ddb50d770",
          "body": null,
          "is_bot": false,
          "headline": "Updated versions (#76)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-05-01T05:16:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "086432eaa5b7782645771162bf469ad4d64e6d8e",
          "body": "* Dashboard filter SQL bugs, FY persistence, add table wrap toggle\n\n* fix: address CodeRabbit review on PR #75\n\n- dashboards: enforce 1..12 range on fiscalYearStartMonth via Pydantic\n  Field constraints so invalid months are rejected at deserialisation\n  rather than silently stored\n- sql_filters: tr\n[…]\nld obscure intent).\n\nCo-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>\n\n* format\n\n* format\n\n* format\n\n---------\n\nCo-authored-by: Claude Opus 4.7 (1M context) <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "Dashboard filter SQL bugs, FY persistence, add table wrap toggle (#75)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-05-01T05:02:05Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "49bcab1f893276864ab8f72499fbc9d2faedf919",
          "body": null,
          "is_bot": false,
          "headline": "Updated pip version (#74)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-04-09T08:05:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5449f1a920d9ba3b9f6b7b4a53ef2dd87d8873c2",
          "body": "* Allow admins to edit/delete dashboards\n\n* Allow admins to edit/delete dashboards",
          "is_bot": false,
          "headline": "Allow admins to edit/delete dashboards (#73)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-04-09T08:02:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c99154fa7bea68ceb16bfba392f3a0a5e75ce8e0",
          "body": null,
          "is_bot": false,
          "headline": "Updated versions (#72)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-04-09T04:05:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0c052851d26f279fd9288674ad2553712cd715b6",
          "body": "…r chart (#71)\n\n* Apply dashboard filters to SQL-mode widgets\n\n* Apply dashboard filters to SQL-mode widgets\n\n* Apply dashboard filters to SQL-mode widgets\n\n* Added stacked support for bar charts\n\n* Added stacked support for bar charts",
          "is_bot": false,
          "headline": "Apply dashboard filter support in sql widgets / Stacked support in ba…",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-04-09T04:01:53Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ec1971577f7292c535a7c0609e7779dd732c03f9",
          "body": null,
          "is_bot": false,
          "headline": "Updated react package version (#70)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-04-06T03:40:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "12bab9ae082d75f4662dd928284c86829420f689",
          "body": "* Calculated field enhancements\n\n* Calculated field enhancements\n\n* Calculated field enhancements\n\n* Calculated field enhancements",
          "is_bot": false,
          "headline": "Calculated field enhancements (#69)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-04-06T03:31:17Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "421ed033022cdd96ca6f7ac000b8e250c9c553b0",
          "body": null,
          "is_bot": false,
          "headline": "Updated versions (#68)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-03-15T10:59:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "65c43fb2c1e0b4a555268e6d74b01d8005ad828a",
          "body": "* Enchacements\n\n* Review changes\n\n* Review changes\n\n* Review changes\n\n* Review changes",
          "is_bot": false,
          "headline": "Enchacements (#67)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-03-15T10:48:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f6a381280b644894239e41a59ff90d906f5860f5",
          "body": "* Project bug fixes\n\n* Null currency fix\n\n* Added confirmation modal on widget type change\n\n* Review changes\n\n* Review changes\n\n* Review changes",
          "is_bot": false,
          "headline": "Project bug fixes (#66)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-03-15T07:59:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3f10986e8cb3e14c97a00cdf99ed5e0fbc171503",
          "body": "* Dashboard filter support\n\n* Dashboard filter support\n\n* Review changes\n\n* Review changes",
          "is_bot": false,
          "headline": "Dashboard filter support (#64)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-03-15T07:36:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "dd4779ca074e4ec8f162b8f3f0926bbf2634f3d4",
          "body": null,
          "is_bot": false,
          "headline": "Updated versions (#65)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-25T05:59:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4e4dcedae6c161f2d8b009899237f44efab46fb3",
          "body": null,
          "is_bot": false,
          "headline": "Fixed missing columns (#63)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-25T05:31:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0c3f4daed67d02699d085855a4e1b44b94e245e3",
          "body": "* Use subquery filtering for table joins\n\n* Review changes\n\n* Review changes\n\n* Review changes",
          "is_bot": false,
          "headline": "Use subquery filtering for table joins (#62)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-25T05:31:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "11ecd3296f3cdaf54cc5b1b225cad33894d94a4f",
          "body": "Co-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "chore: bump versions to 0.2.3 (#61)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-21T06:58:06Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "d51198ebfd3a74af3069881ebaabb0a06abf55af",
          "body": "* feat: add multi-tenant schema isolation with integration tests\n\n- Add qualify_table_schemas() to rewrite raw SQL with schema-qualified\n  table references, preventing cross-tenant data leakage in the LLM SQL\n  assistant path (execute_raw_sql)\n- Disable asyncpg statement cache (statement_cache_size=\n[…]\necute_raw_sql\n- Narrow sql_validator catch to (ParseError, TokenError) only\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: multi-tenant schema isolation with integration tests (#60)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-21T06:45:30Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "ac84b947c0549459ba44aaa0a3d02a88db73a79f",
          "body": "* fix: use parameterized set_config for statement_timeout\n\nReplace f-string interpolation with parameterized set_config call\nfor consistency with search_path handling.\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n* chore: bump versions to 0.2.2\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "chore: bump versions to 0.2.2 (#59)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-21T01:41:43Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "5a737b21ad42a7375b9d8e86f7a356ab5210ffe8",
          "body": "* feat: make max_tool_iterations configurable via LLMConfig\n\n- Add max_tool_iterations field to LLMConfig (default: 10, up from 5)\n- Thread config value from PrismiqEngine through to agent loop\n- Rename MAX_TOOL_ITERATIONS to DEFAULT_MAX_TOOL_ITERATIONS\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anth\n[…]\nArgs docstring\n- Add Field(ge=1) validation to prevent 0 or negative values\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: LLM SQL assistant schema isolation and error handling (#58)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-21T01:31:16Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "ee8be7caa7eb8d9cb6ad3410d5f230e5a8a862bf",
          "body": "Co-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "chore: bump versions to 0.2.1 (#57)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T23:42:22Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "eb7246cdc9b3505234670da94852137718d15122",
          "body": "…atus streaming (#56)\n\n* feat: add widget context, execute/column tools, and status streaming to LLM assistant\n\n- Add WidgetContext model with widget-specific SQL column rules so the LLM\n  generates queries matching each widget type (pie=2 cols, metric=1 row, etc.)\n- Add execute_sql tool with widget\n[…]\next with a top-level\nimport to match the existing import style in the file.\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: widget-aware LLM SQL assistant with execution validation and st…",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T23:39:01Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "b9ead03ec8c8318c429d4fef42ce0e6f01211ec3",
          "body": "* docs: add SQL mode and LLM SQL assistant documentation\n\n- Create docs/sql-mode.md with comprehensive guide covering SQL mode\n  editor, AI assistant architecture, configuration, API endpoints,\n  security, and graceful degradation\n- Update README.md with SQL mode and AI assistant in features list\n- \n[…]\nify that identifier quoting is recommended, not enforced by\n  the validator\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "docs: add SQL mode and LLM SQL assistant documentation (#55)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T21:39:58Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "91cfa2d8fac193027750d8967b4c0ef5b0e4455a",
          "body": "Co-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "chore: bump versions to 0.2.0 (#54)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T21:00:55Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "e489cc6254cc9281df32820c35658d6beb989a5a",
          "body": "* fix: resolve peer dependency issues for react-grid-layout and xlsx\n\n- Require react-grid-layout ^2.0.0 (was ^1.4.0 || ^2.0.0) since the\n  /legacy subpath import only exists in v2\n- Use dynamic import() for xlsx so consumers don't need it installed\n  unless they call exportToExcel()\n- Make exportTo\n[…]\no honor explicit 0 values\n- Update exportExcel return type to Promise<void>\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: resolve peer dependency issues for react-grid-layout and xlsx (#53)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T20:54:13Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "4df067277cf32561c8522db297cf02ab5321f86e",
          "body": "…de (#52)\n\nRemove unused alternate SQL builder path (sqlalchemy_builder.py, 577 lines)\nand its sole dependency (calculated_field_processor.py, 232 lines).\nQueryBuilder in query.py is the production builder used everywhere.\n\n- Delete sqlalchemy_builder.py (zero callers, zero tests)\n- Delete calculate\n[…]\nct, preprocess_calculated_fields,\n  has_aggregation, resolve_calculated_fields)\n- Update stale comment in query.py referencing removed function\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: remove dead sqlalchemy_builder and calculated_field_processor co…",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T20:46:26Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "8816d96ba00115afcb001ea01faafe1fdd09ce27",
          "body": "… (#51)\n\nFilters targeting the nullable side of an outer join (e.g., the right\ntable in a LEFT JOIN) were placed in WHERE, which effectively converted\nthe outer join into an inner join by eliminating NULL rows. Now these\nfilters are correctly placed in the JOIN's ON clause.\n\n- Extract _resolve_filte\n[…]\nd FULL join types\n- Exceptions: sql_expression and calculated field filters stay in WHERE\n- 11 new tests covering all join types and edge cases\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: place outer join filters in ON clause to preserve join semantics…",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T18:40:33Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "fb5493ed39cd51e4da19461c08abdf3986ad1f21",
          "body": "…#50)\n\n* feat: add LLM subsystem with types, provider, Gemini impl, tools, agent loop\n\n- LLMConfig, ChatMessage, StreamChunk types with Pydantic models\n- LLMProvider ABC with stream_chat() and run_chat_loop() methods\n- GeminiProvider using google-genai SDK with thought_signature support\n- Tool defin\n[…]\nnt coercion\n- Add data-testid=\"chat-panel-root\" to ChatPanel root container\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: add LLM-powered SQL mode with schema browser to widget editor (…",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T08:12:34Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "6e01966cb887f617ceacd15543f13d5a4a56fa1e",
          "body": "npm provenance verification requires package.json repository.url to\nmatch the actual GitHub repo. Also updated pyproject.toml URLs.\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: update repository URLs to statisfy-us/prismiq (#49)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T02:25:24Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "59a2ac08dc6ba012eb05cde5b8953a98c796eebd",
          "body": "… (#48)\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: use Node 24 for npm trusted publishing (OIDC requires >=22.14.0)…",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T02:22:45Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "89d3c8fa2a254fb96c51b339f426d6b1d67fe2e8",
          "body": "* fix: restore registry-url and add NPM_TOKEN for npm publish\n\nnpm trusted publishing requires a token for auth (OIDC only handles\nprovenance attestation). Restore registry-url and use NPM_TOKEN secret.\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n* fix: use OIDC trusted publishing for \n[…]\nrite\npermission + registry-url + plain npm publish. No token secret needed.\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: restore registry-url and add NPM_TOKEN for npm publish (#47)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T02:17:42Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "ecf0a59d8ff668aff3aac351a0106a6627fa41a0",
          "body": "setup-node's registry-url injects a NODE_AUTH_TOKEN placeholder into\n.npmrc which overrides the OIDC token exchange for trusted publishing.\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: remove registry-url to let npm OIDC handle auth natively (#46)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T02:05:03Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "d869b0682111e943b632306cdf3a2d82a00e1332",
          "body": "* fix: use explicit package and out-dir for uv build in PyPI workflow\n\nuv build in a workspace outputs to the workspace root dist/, not the\nmember package directory. Pass --package and --out-dir explicitly.\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n* fix: add --provenance flag for np\n[…]\nOIDC)\n\nEnables OIDC token exchange instead of requiring a stored NPM_TOKEN.\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: add --provenance for npm trusted publishing (#45)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T02:01:18Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "833fabc8e15a7ea722a2ee4b9c7ff97206d51832",
          "body": "…#44)\n\nuv build in a workspace outputs to the workspace root dist/, not the\nmember package directory. Pass --package and --out-dir explicitly.\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: use explicit package and out-dir for uv build in PyPI workflow (…",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T01:43:20Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "9e3f17226531f9f87000cae0b207a84927c802a9",
          "body": "Co-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "chore: bump versions to 0.1.1 (#43)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T01:35:18Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "a8bf3e78d0475f46610d131b538e9fad7e51a0c1",
          "body": "* fix: migrate to integer IDs, improve widget editor and filter UX\n\n- Switch all persistence layers from UUID to SERIAL integer IDs (schema.sql, tables.py, saved_query_store.py)\n- Add _parse_int_id() helper for safe ID parsing with clear error messages\n- Add null guard on saved query create() fetchr\n[…]\nOpus 4.6 <noreply@anthropic.com>\n\n* chore: fix ruff formatting in engine.py\n\nCo-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "Fix: integer IDs, widget editor guards, tag-based filter input (#42)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-20T01:28:37Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "b8d0252b447e7f16baae965faba4b92b8b690dcf",
          "body": null,
          "is_bot": false,
          "headline": "Revert back to single page scroll (#41)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-05T12:18:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ceb0db094bc93ab7e6dc559c8e614cb8db697a5e",
          "body": null,
          "is_bot": false,
          "headline": "Fit widget selector text (#40)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-05T12:12:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1bbb9d614e00ba3aa6d06e86b08703f7d4424450",
          "body": "* fix: improve widget editor layout with single page scroll\n\nReplace nested scroll containers with a single page-level scroll to\nreduce visual clutter. Increase preview height from 300px to 440px\nand let the data source section flow at its natural height instead\nof being squeezed into a fixed area w\n[…]\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>\nCo-authored-by: naman-statisfy <151496983+naman-statisfy@users.noreply.github.com>\nCo-authored-by: naman-statisfy <naman@statisfy.us>",
          "is_bot": false,
          "headline": "fix: improve widget editor layout with single page scroll (#39)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-05T11:57:01Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "0a4ec277f095f060a2344bf7862fdcf6e589c65c",
          "body": null,
          "is_bot": false,
          "headline": "Added dual pool support (#38)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-05T07:48:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e65dc043a9362b7726c4624b6e7abda3317caa99",
          "body": null,
          "is_bot": false,
          "headline": "Query validation fix (#37)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-05T04:12:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7ff97fd7c2e18832efe17d9ae1b8f041e3b79884",
          "body": "* ci: add npm and PyPI publishing workflows\n\n- Add publish-npm.yml: publishes @prismiq/react on react-v* tags\n- Add publish-pypi.yml: publishes prismiq to PyPI on python-v* tags\n- Add prepublishOnly script to React package.json\n\nWorkflows trigger on GitHub releases with tag prefixes:\n- react-v* → np\n[…]\nettings → Trusted Publisher → GitHub Actions\n- Match org/repo/workflow name\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "ci: add npm and PyPI publishing workflows (#36)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-05T00:14:58Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "885723cae68b81e402e55e92dc2e1b69f38535e5",
          "body": null,
          "is_bot": false,
          "headline": "Query validation fix",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T19:05:53Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5bef6c573967812cb7bbcb8ced3662fe9d90eb0c",
          "body": null,
          "is_bot": false,
          "headline": "Query validation fix",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T18:46:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ec7a572ab941ba30b2f49c2bdf730d7d8468c73c",
          "body": "Fixes",
          "is_bot": false,
          "headline": "Merge pull request #35 from statisfy-us/new-fixes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T17:29:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d312c25a007fb26455ee71e58e1efcd438e897a8",
          "body": null,
          "is_bot": false,
          "headline": "Fixes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T17:14:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "138b850bb7ba7cc172366223537b61315a373ab6",
          "body": "Review changes",
          "is_bot": false,
          "headline": "Merge pull request #34 from statisfy-us/review-changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T10:07:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "77e8793011680e5bed8cdbe9d004945bc446765d",
          "body": null,
          "is_bot": false,
          "headline": "Review changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T10:01:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bff8440970f396c02004c5c2cbced5a314db18ac",
          "body": null,
          "is_bot": false,
          "headline": "Review changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T09:47:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "df9cf3f9de218981572be55d684f163e79d0f9c4",
          "body": null,
          "is_bot": false,
          "headline": "Merge branch 'main' into review-changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T09:03:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7b5d8bc759634017c92fbfd3959a8926f3979b1c",
          "body": null,
          "is_bot": false,
          "headline": "Review changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T09:02:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b3f14d2cd5fb428228e261c41d14cab883a31e03",
          "body": null,
          "is_bot": false,
          "headline": "Review changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T08:31:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5a9946647b448b543198c4c0a92bc9d32937f824",
          "body": null,
          "is_bot": false,
          "headline": "Review changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T07:15:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "54f28ee5261bf780543768bb5139e8ec554351e6",
          "body": null,
          "is_bot": false,
          "headline": "Review changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-04T06:41:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fa43cbe4b59e1d3861741265c47e09510dcf5899",
          "body": "The SavedQueryStore.list method shadowed the builtin list type,\ncausing Pyright to reject list[Any] in return annotations. Use\nbuiltins.list to explicitly reference the builtin type.\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: resolve Pyright error where list method shadows builtin list type",
          "author_name": "Navin Agarwal",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-04T06:12:48Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "8eacbd34b6f832dc6ef01f22488a9b7c9c54afe9",
          "body": "* fix: default date granularity to day and auto-format date axis labels\n\nTimestamp columns now default to 'day' granularity when selected as\ngroup-by in ChartConfig and PieConfig. Chart axis labels are auto-\nformatted based on the query's date_trunc granularity (year→yyyy,\nquarter→Q1 2024, month→yyy\n[…]\negations already\nhandle the wildcard implicitly via their dedicated branch.\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: default date granularity and auto-format date axis labels (#33)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-02-04T04:46:51Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "d55204569563d373aa9a07e210cb643ffa3cb1e8",
          "body": "* Edit/Create widget flow improvements\n\n* fix: harden SQL quoting, parameterize search_path, and fix UI issues\n\n- Quote table/column identifiers in widget INSERT (postgres_store)\n- Use parameterized set_config for search_path (saved_query_store)\n- Change Dropdown onClickCapture to onClick for correc\n[…]\nwhen a widget is deleted\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Navin Agarwal <navin@statisfy.com>\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "Edit/Create widget flow improvements (#32)",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-03T23:44:15Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "5ab1a539dfe41187a568806aad10408f536ae399",
          "body": "Fixed multiple api call issue and added viewtype functionality",
          "is_bot": false,
          "headline": "Merge pull request #31 from statisfy-us/api-calls-fix",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-03T04:29:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d71210c3d286cb68975ae6b5f90fe7a20fd70d0f",
          "body": null,
          "is_bot": false,
          "headline": "Review changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-03T04:24:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "be7226f4011b2db870f34c9b1d94e1aa74933ad3",
          "body": null,
          "is_bot": false,
          "headline": "Review changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-03T04:16:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bf06bb09a8c4b2d5bfd169f9b131fc23ef8ecaab",
          "body": null,
          "is_bot": false,
          "headline": "Scroll based lazy loading",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-03T03:29:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "29cbf2b342f7fe5d8dc46af7e2f2d6a24ca5ba07",
          "body": null,
          "is_bot": false,
          "headline": "Scroll based lazy loading",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-03T03:23:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c753c31af14ee54fcc421db4452aa4e45a85616b",
          "body": null,
          "is_bot": false,
          "headline": "Batching changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-02T16:00:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1cedf4183757752a2fe8e1954cc796c020fc9f47",
          "body": null,
          "is_bot": false,
          "headline": "Dashboard filter changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-02T13:23:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a23df042c3f074a1734f420ba5e298d3bada78cb",
          "body": null,
          "is_bot": false,
          "headline": "Dashboard filter changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-02T09:28:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "260aaf8670e0fff0d98b734e27d123fcba879f8a",
          "body": null,
          "is_bot": false,
          "headline": "Viewtype functionality",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-02T06:23:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "97a9fcfdd0c2fb7563559a9d278af19ce3d651fc",
          "body": null,
          "is_bot": false,
          "headline": "Viewtype functionality",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-02-01T07:27:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "96fac3e1e91124ba61ce7bc5cd38f45b1fb597ed",
          "body": null,
          "is_bot": false,
          "headline": "Viewtype functionality",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-31T12:24:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "db07b23327388f154de7330f53154b2047a3a651",
          "body": null,
          "is_bot": false,
          "headline": "Fixed multiple api call issue",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-30T10:52:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "34fa19f82a1a0335a89e5f231fc440a9275c3037",
          "body": "- Fix I001 import sorting in api.py, dashboard_store.py, postgres_store.py\n- Move logger initialization after imports in postgres_store.py (E402)\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: sort imports and move logger after imports",
          "author_name": "Navin Agarwal",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-30T09:21:44Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "f8f5ead98962bf8ccbe55d0a9cf1d58531510f44",
          "body": "- integration-guide.md: Complete setup guide covering backend, frontend,\n  queries, charts, dashboards, multi-tenancy, auth, theming, and caching\n- hooks-reference.md: All React hooks with usage examples\n- api-reference.md: Backend API endpoints documentation\n- types-reference.md: TypeScript type definitions\n- getting-started.md: Updated quick start guide with current API\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "docs: add comprehensive integration documentation",
          "author_name": "Navin Agarwal",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-30T09:16:00Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "bd6839634ce4d24e41f8b2196bde274a5241fec2",
          "body": "Package changes",
          "is_bot": false,
          "headline": "Merge pull request #30 from statisfy-us/dashboard-changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-30T08:24:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "41e9aef5c16181ab700e99d31128d2be838d2b00",
          "body": null,
          "is_bot": false,
          "headline": "Fixed multiple api calls and layout issues",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-30T08:15:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6796ef52c3a9310db440f5bccedb1647016467ca",
          "body": null,
          "is_bot": false,
          "headline": "Fixed multiple api calls and layout issues",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-30T08:12:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e05b207061fbc3d5af80b34bcc1e8452c4caafb7",
          "body": null,
          "is_bot": false,
          "headline": "Fixed multiple api calls and layout issues",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-30T06:13:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ad94ebd35bbfb3b5e2d026f8834bb0e7903eacca",
          "body": null,
          "is_bot": false,
          "headline": "Fixed multiple api calls and layout issues",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-29T15:02:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "dce923cf632b729be1a5c8772ffb13e9dda01cbd",
          "body": null,
          "is_bot": false,
          "headline": "Fixed multiple api calls and layout issues",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-29T12:15:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b70e21698e74c4dec8b5bcbefb6214f196b79b41",
          "body": null,
          "is_bot": false,
          "headline": "Fixed multiple api calls and layout issues",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-29T12:02:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f8923c87081f0c33038a08b598cb4d8a38e28d59",
          "body": null,
          "is_bot": false,
          "headline": "Package changes",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-29T07:46:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5a1a24fdb1855c90663289b89d36a406d619fddd",
          "body": "* feat: add date truncation support for date columns\n\n- Add DateTruncInterval type and date_trunc field to ColumnSelection\n- Add date truncation dropdown to SelectedColumn component\n- Add date granularity selector to ChartConfig for date group-by columns\n- Add date granularity selector to PieConfig \n[…]\nt. These\ngranular intervals are not needed for typical analytics use cases.\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: self-serve UI gaps - widget editor enhancements (#28)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-28T09:44:54Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "59e7868cdaf55aa9f071554889b59cc9dcc4bfa8",
          "body": "…I (#27)\n\n* feat: add date truncation support for date columns\n\n- Add DateTruncInterval type and date_trunc field to ColumnSelection\n- Add date truncation dropdown to SelectedColumn component\n- Add date granularity selector to ChartConfig for date group-by columns\n- Add date granularity selector to \n[…]\nis stored as\nundefined (matching Y-axis behavior) rather than empty string.\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: close gaps between backend capabilities and self-serve create U…",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-28T07:35:49Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "c8b924b3a39428e7779eb647123fc724bf3265f4",
          "body": "* feat: add dashboard pinning data layer (Phase 1)\n\n- Add PrismiqPinnedDashboard SQLAlchemy model\n- Add PinnedDashboard, PinRequest, UnpinRequest, ReorderPinsRequest Pydantic models\n- Extend DashboardStore protocol with pin operations\n- Implement pin operations in InMemoryDashboardStore\n- Implement \n[…]\nverview\n- Update main README.md with pinning in features list and docs link\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: add dashboard pinning feature (#26)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-28T03:46:06Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "b5267ab863958032d5f1ff20a7798e542ccfc94c",
          "body": null,
          "is_bot": false,
          "headline": "Fix ORDER BY to use date_trunc when column has date truncation applied",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-27T11:22:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f7123803c1e5e0257578c2becf94f5abef202677",
          "body": "Cache fix",
          "is_bot": false,
          "headline": "Merge pull request #25 from statisfy-us/cache-fix",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-27T11:21:19Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9fc1627bea3782717743eef8e1cac7f5e538737a",
          "body": null,
          "is_bot": false,
          "headline": "Cache fix",
          "author_name": "naman-statisfy",
          "author_login": "naman-statisfy",
          "committed_at": "2026-01-27T11:02:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e65827adde139dfe8424bae7be6b545e69bc75f7",
          "body": "- EQ with None value now generates IS NULL instead of = NULL\n- NEQ with None value now generates IS NOT NULL instead of <> NULL\n- IN with empty list now returns FALSE (no rows match empty set)\n- NOT_IN with empty list now returns TRUE (all rows not in empty set)\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: handle edge cases in query builder filters (#24)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-27T01:31:52Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "eb84270efef7749e608b9d5a78d5ee1331e178e5",
          "body": "* feat: add NOT_LIKE and NOT_ILIKE filter operators to query builder\n\nAdds support for negated pattern matching filters:\n- NOT_LIKE: case-sensitive pattern exclusion\n- NOT_ILIKE: case-insensitive pattern exclusion\n\nThis enables proper mapping of RevealBI's NotContains filter which\nwas previously map\n[…]\nution.\nNone values remain allowed as they're handled by the IS NULL clause.\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: add NOT_LIKE and NOT_ILIKE filter operators to query builder (#23)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-27T01:23:46Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "394ea509d00fa062726c1f0c41a0cc077af9f1ba",
          "body": "Port in_or_null operator from sqlalchemy_builder.py to query.py.\nGenerates SQL like: (\"column\" IN ($1, $2) OR \"column\" IS NULL)\n\n- Add IN_OR_NULL to FilterOperator enum in types.py\n- Add handler in QueryBuilder._build_condition()\n- Handle edge cases:\n  - Empty list falls back to just IS NULL\n  - None values filtered from lists (handled by IS NULL clause)\n  - Single None value returns just IS NULL\n- Add 6 test cases covering all branches\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: add IN_OR_NULL filter operator to query builder (#22)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-27T00:53:16Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "a7a6964dbc1092a5e0d529756b879f21c9902ac1",
          "body": "…#21)\n\n* fix: raise ValueError for invalid IN_SUBQUERY in sqlalchemy_builder\n\nApply same security fix from commit 4968a37 to sqlalchemy_builder.py\nfor consistency. The IN_SUBQUERY filter now raises ValueError when:\n- value is not a dict\n- value is missing 'sql' key\n- SQL string is empty\n\nPreviously,\n[…]\nubqueries cannot be parameterized.\" to explain the architectural\nrationale.\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: raise ValueError for invalid IN_SUBQUERY in sqlalchemy_builder (…",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-27T00:26:52Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "267972456f3a585518ac82498a24148a0ada5d41",
          "body": "…(#20)\n\n* feat: add SQLAlchemy declarative models for multi-tenant integration\n\nAdd PrismiqBase, PrismiqDashboard, PrismiqWidget, and PrismiqSavedQuery\ndeclarative models for use with Alembic migrations and SQLAlchemy-based\nmulti-tenant systems.\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.co\n[…]\n in docs\n- Fix async example to use tenant-scoped pool with server_settings\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: add SQLAlchemy declarative models for multi-tenant integration …",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-27T00:04:49Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "59ed69f04c7b975a7c779c83f11e9612eeb51054",
          "body": "* refactor: remove prismiq_schema_config database table\n\nSchema configuration should be set at engine initialization time via\nthe schema_config parameter, not stored in the database. This simplifies\nthe architecture by treating schema config as static deployment config.\n\nChanges:\n- Remove prismiq_sc\n[…]\ne handled statically rather than via database. Also removes\nunused imports.\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "refactor: remove prismiq_schema_config database table (#19)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-26T23:32:29Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "a925072d36ddbb193269522479d65547aa323a8c",
          "body": "* refactor: extract _quote_column_ref helper to reduce duplication\n\nConsolidates duplicated column quoting logic in FieldRef.to_sql() into\na single helper function that handles:\n- Qualified \"alias.column\" -> \"alias\".\"column\"\n- Unqualified with default_table_ref -> \"table\".\"column\"\n- Unqualified with\n[…]\n Opus 4.5 <noreply@anthropic.com>\n\n* style: fix ruff formatting in query.py\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "refactor: extract _quote_column_ref helper to reduce duplication (#17)",
          "author_name": "navin-statisfy",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-26T22:41:04Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "4968a371e29f120d3d471f697b559a3e43794701",
          "body": "…allback\n\nSECURITY FIX: The IN_SUBQUERY filter now raises ValueError when:\n- value is not a dict\n- value is missing 'sql' key\n- SQL string is empty\n\nPreviously, invalid IN_SUBQUERY filters would silently return \"1=1\" (always true),\nwhich could expose data that should be filtered by RLS rules.\n\nAlso \n[…]\n interpolated directly (by design, subqueries can't be parameterized)\n- Callers MUST ensure SQL is from trusted internal code, never user input\n\nCo-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: raise ValueError for invalid IN_SUBQUERY instead of silent 1=1 f…",
          "author_name": "Navin Agarwal",
          "author_login": "navin-statisfy",
          "committed_at": "2026-01-26T22:17:16Z",
          "body_truncated": true,
          "is_coding_agent": true
        }
      ],
      "releases_count": 25,
      "commits_last_year": 233,
      "latest_release_at": "2026-07-29T05:47:37Z",
      "latest_release_tag": "python-v0.2.11",
      "releases_from_tags": false,
      "days_since_last_push": 0,
      "active_weeks_last_year": 15,
      "days_since_latest_release": 0,
      "mean_days_between_releases": 12.3
    },
    "community": {
      "has_readme": true,
      "has_license": true,
      "has_description": false,
      "has_contributing": true,
      "health_percentage": 37,
      "has_issue_template": false,
      "has_code_of_conduct": false,
      "has_pull_request_template": false
    },
    "ecosystem": {
      "packages": [
        {
          "name": "@prismiq/react",
          "exists": true,
          "license": "MIT",
          "keywords": [
            "react",
            "analytics",
            "dashboard",
            "embedded",
            "postgresql",
            "visualization",
            "charts",
            "echarts",
            "query-builder"
          ],
          "ecosystem": "npm",
          "matches_repo": true,
          "registry_url": "https://www.npmjs.com/package/@prismiq/react",
          "is_deprecated": false,
          "latest_version": "0.2.12",
          "repository_url": "https://github.com/statisfy-us/prismiq",
          "versions_count": 14,
          "total_downloads": null,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": 1,
          "monthly_downloads": 534,
          "first_published_at": "2026-02-04T22:44:49.999000Z",
          "latest_published_at": "2026-07-29T05:48:24.291000Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 0
        },
        {
          "name": "prismiq",
          "exists": true,
          "license": "MIT",
          "keywords": [
            "Development Status :: 3 - Alpha",
            "Framework :: FastAPI",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.10",
            "Programming Language :: Python :: 3.11",
            "Programming Language :: Python :: 3.12",
            "Topic :: Database",
            "Typing :: Typed"
          ],
          "ecosystem": "pypi",
          "matches_repo": true,
          "registry_url": "https://pypi.org/project/prismiq/",
          "is_deprecated": false,
          "latest_version": "0.2.11",
          "repository_url": "https://github.com/statisfy-us/prismiq",
          "versions_count": 13,
          "total_downloads": null,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": 3269,
          "first_published_at": "2026-02-04T23:17:17.669636Z",
          "latest_published_at": "2026-07-29T05:48:21.661222Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 0
        }
      ]
    },
    "popularity": {
      "forks": 0,
      "stars": 0,
      "watchers": 0,
      "fork_history": {
        "days": [],
        "complete": true,
        "collected": 0,
        "total_forks": 0
      },
      "star_history": {
        "days": [],
        "complete": true,
        "collected": 0,
        "total_stars": 0,
        "collected_at": null
      },
      "open_issues_and_prs": 0
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [
        "examples"
      ],
      "has_llms_txt": false,
      "has_dockerfile": true,
      "has_mcp_signal": false,
      "bootstrap_files": [
        "Makefile"
      ],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [
        "examples/demo/frontend/tsconfig.json",
        "packages/python/prismiq/py.typed",
        "packages/react/tsconfig.json"
      ],
      "toolchain_manifests": [],
      "largest_source_bytes": 70198,
      "source_files_sampled": 287,
      "oversized_source_files": 3,
      "agent_instruction_files": [
        "CLAUDE.md"
      ],
      "agent_instruction_max_bytes": 18054
    },
    "dependencies": {
      "manifests": [
        "pyproject.toml"
      ],
      "advisories": {
        "error": null,
        "scope": "repository_graph",
        "source": "osv",
        "findings": [
          {
            "name": "aiohttp",
            "direct": false,
            "version": "3.13.3",
            "severity": "critical",
            "ecosystem": "pypi",
            "cvss_score": 9.1,
            "advisory_ids": [
              "GHSA-2fqr-mr3j-6wp8",
              "GHSA-2vrm-gr82-f7m5",
              "GHSA-3wq7-rqq7-wx6j",
              "GHSA-4fvr-rgm6-gqmc",
              "GHSA-4m7w-qmgq-4wj5",
              "GHSA-63hf-3vf5-4wqf",
              "GHSA-63hw-fmq6-xxg2",
              "GHSA-966j-vmvw-g2g9",
              "GHSA-9x8q-7h8h-wcw9",
              "GHSA-c427-h43c-vf67"
            ],
            "fixed_version": "3.14.1",
            "advisory_count": 42,
            "oldest_advisory_days": 118
          },
          {
            "name": "cryptography",
            "direct": false,
            "version": "46.0.5",
            "severity": "critical",
            "ecosystem": "pypi",
            "cvss_score": 9.8,
            "advisory_ids": [
              "GHSA-537c-gmf6-5ccf",
              "GHSA-m959-cc7f-wv43",
              "GHSA-p423-j2cm-9vmq",
              "PYSEC-2026-35",
              "PYSEC-2026-36"
            ],
            "fixed_version": "48.0.1",
            "advisory_count": 5,
            "oldest_advisory_days": 123
          },
          {
            "name": "rollup",
            "direct": false,
            "version": "4.54.0",
            "severity": "critical",
            "ecosystem": "npm",
            "cvss_score": 9.1,
            "advisory_ids": [
              "GHSA-mw96-cpmx-2vgc"
            ],
            "fixed_version": "4.59.0",
            "advisory_count": 1,
            "oldest_advisory_days": 153
          },
          {
            "name": "rollup",
            "direct": false,
            "version": "4.56.0",
            "severity": "critical",
            "ecosystem": "npm",
            "cvss_score": 9.1,
            "advisory_ids": [
              "GHSA-mw96-cpmx-2vgc"
            ],
            "fixed_version": "4.59.0",
            "advisory_count": 1,
            "oldest_advisory_days": 153
          },
          {
            "name": "@remix-run/router",
            "direct": false,
            "version": "1.23.1",
            "severity": "high",
            "ecosystem": "npm",
            "cvss_score": 8,
            "advisory_ids": [
              "GHSA-2w69-qvjg-hvjx"
            ],
            "fixed_version": "7.12.0",
            "advisory_count": 1,
            "oldest_advisory_days": 201
          },
          {
            "name": "click",
            "direct": false,
            "version": "8.3.1",
            "severity": "high",
            "ecosystem": "pypi",
            "cvss_score": 7.2,
            "advisory_ids": [
              "PYSEC-2026-2132"
            ],
            "fixed_version": "8.3.3",
            "advisory_count": 1,
            "oldest_advisory_days": 89
          },
          {
            "name": "picomatch",
            "direct": false,
            "version": "4.0.3",
            "severity": "high",
            "ecosystem": "npm",
            "cvss_score": 7.5,
            "advisory_ids": [
              "GHSA-3v7f-55p6-f55p",
              "GHSA-c2c7-rcm5-vvqj"
            ],
            "fixed_version": "4.0.4",
            "advisory_count": 2,
            "oldest_advisory_days": 125
          },
          {
            "name": "postcss",
            "direct": false,
            "version": "8.5.6",
            "severity": "high",
            "ecosystem": "npm",
            "cvss_score": 7.5,
            "advisory_ids": [
              "GHSA-6g55-p6wh-862q",
              "GHSA-qx2v-qp2m-jg93",
              "GHSA-r28c-9q8g-f849"
            ],
            "fixed_version": "8.5.18",
            "advisory_count": 3,
            "oldest_advisory_days": 95
          },
          {
            "name": "pyasn1",
            "direct": false,
            "version": "0.6.2",
            "severity": "high",
            "ecosystem": "pypi",
            "cvss_score": 7.5,
            "advisory_ids": [
              "GHSA-8ppf-4f7h-5ppj",
              "GHSA-hm4w-wwcw-mr6r",
              "GHSA-jr27-m4p2-rc6r",
              "PYSEC-2026-2263",
              "PYSEC-2026-3455",
              "PYSEC-2026-3456",
              "PYSEC-2026-3457"
            ],
            "fixed_version": "0.6.4",
            "advisory_count": 7,
            "oldest_advisory_days": 133
          },
          {
            "name": "react-router",
            "direct": false,
            "version": "6.30.2",
            "severity": "high",
            "ecosystem": "npm",
            "cvss_score": 7.5,
            "advisory_ids": [
              "GHSA-2j2x-hqr9-3h42",
              "GHSA-337j-9hxr-rhxg",
              "GHSA-wrjc-x8rr-h8h6"
            ],
            "fixed_version": "7.18.0",
            "advisory_count": 3,
            "oldest_advisory_days": 55
          },
          {
            "name": "starlette",
            "direct": false,
            "version": "0.50.0",
            "severity": "high",
            "ecosystem": "pypi",
            "cvss_score": 7.5,
            "advisory_ids": [
              "GHSA-82w8-qh3p-5jfq",
              "GHSA-86qp-5c8j-p5mr",
              "GHSA-jp82-jpqv-5vv3",
              "GHSA-wqp7-x3pw-xc5r",
              "GHSA-x746-7m8f-x49c",
              "PYSEC-2026-161",
              "PYSEC-2026-2280",
              "PYSEC-2026-2281",
              "PYSEC-2026-248",
              "PYSEC-2026-249"
            ],
            "fixed_version": "1.3.1",
            "advisory_count": 10,
            "oldest_advisory_days": 67
          },
          {
            "name": "urllib3",
            "direct": false,
            "version": "2.6.3",
            "severity": "high",
            "ecosystem": "pypi",
            "cvss_score": 7.5,
            "advisory_ids": [
              "GHSA-mf9v-mfxr-j63j",
              "GHSA-qccp-gfcp-xxvc",
              "PYSEC-2026-141",
              "PYSEC-2026-142"
            ],
            "fixed_version": "2.7.0",
            "advisory_count": 4,
            "oldest_advisory_days": 78
          },
          {
            "name": "vite",
            "direct": false,
            "version": "5.4.21",
            "severity": "high",
            "ecosystem": "npm",
            "cvss_score": 7.5,
            "advisory_ids": [
              "GHSA-4w7w-66w2-5vf9",
              "GHSA-fx2h-pf6j-xcff",
              "GHSA-v6wh-96g9-6wx3"
            ],
            "fixed_version": "8.0.16",
            "advisory_count": 3,
            "oldest_advisory_days": 113
          },
          {
            "name": "xlsx",
            "direct": false,
            "version": "0.18.5",
            "severity": "high",
            "ecosystem": "npm",
            "cvss_score": 7.8,
            "advisory_ids": [
              "GHSA-4r6h-8v6p-xvw6",
              "GHSA-5pgg-2g8v-p4x9"
            ],
            "fixed_version": null,
            "advisory_count": 2,
            "oldest_advisory_days": 1191
          },
          {
            "name": "echarts",
            "direct": false,
            "version": "6.0.0",
            "severity": "moderate",
            "ecosystem": "npm",
            "cvss_score": 6.1,
            "advisory_ids": [
              "GHSA-fgmj-fm8m-jvvx"
            ],
            "fixed_version": "6.1.0",
            "advisory_count": 1,
            "oldest_advisory_days": 63
          },
          {
            "name": "esbuild",
            "direct": false,
            "version": "0.21.5",
            "severity": "moderate",
            "ecosystem": "npm",
            "cvss_score": 5.3,
            "advisory_ids": [
              "GHSA-67mh-4wv8-2f99"
            ],
            "fixed_version": "0.25.0",
            "advisory_count": 1,
            "oldest_advisory_days": 533
          },
          {
            "name": "filelock",
            "direct": false,
            "version": "3.20.1",
            "severity": "moderate",
            "ecosystem": "pypi",
            "cvss_score": 5.3,
            "advisory_ids": [
              "GHSA-qmgc-5h2g-mvrw",
              "PYSEC-2026-1374"
            ],
            "fixed_version": "3.20.3",
            "advisory_count": 2,
            "oldest_advisory_days": 196
          },
          {
            "name": "idna",
            "direct": false,
            "version": "3.11",
            "severity": "moderate",
            "ecosystem": "pypi",
            "cvss_score": 5.3,
            "advisory_ids": [
              "GHSA-65pc-fj4g-8rjx",
              "PYSEC-2026-215"
            ],
            "fixed_version": "3.15",
            "advisory_count": 2,
            "oldest_advisory_days": 70
          },
          {
            "name": "pytest",
            "direct": false,
            "version": "9.0.2",
            "severity": "moderate",
            "ecosystem": "pypi",
            "cvss_score": 6.8,
            "advisory_ids": [
              "GHSA-6w46-j5rx-g56g",
              "PYSEC-2026-1845"
            ],
            "fixed_version": "9.0.3",
            "advisory_count": 2,
            "oldest_advisory_days": 187
          },
          {
            "name": "react-router-dom",
            "direct": false,
            "version": "6.30.2",
            "severity": "moderate",
            "ecosystem": "npm",
            "cvss_score": 6.9,
            "advisory_ids": [
              "GHSA-jjmj-jmhj-qwj2"
            ],
            "fixed_version": "7.13.0",
            "advisory_count": 1,
            "oldest_advisory_days": 5
          },
          {
            "name": "requests",
            "direct": false,
            "version": "2.32.5",
            "severity": "moderate",
            "ecosystem": "pypi",
            "cvss_score": 5.5,
            "advisory_ids": [
              "GHSA-gc5v-m9x4-r6x2",
              "PYSEC-2026-2275"
            ],
            "fixed_version": "2.33.0",
            "advisory_count": 2,
            "oldest_advisory_days": 125
          },
          {
            "name": "virtualenv",
            "direct": false,
            "version": "20.35.4",
            "severity": "moderate",
            "ecosystem": "pypi",
            "cvss_score": 4.5,
            "advisory_ids": [
              "GHSA-597g-3phw-6986",
              "PYSEC-2026-2009"
            ],
            "fixed_version": "20.36.1",
            "advisory_count": 2,
            "oldest_advisory_days": 196
          },
          {
            "name": "@babel/core",
            "direct": false,
            "version": "7.28.5",
            "severity": "low",
            "ecosystem": "npm",
            "cvss_score": 3.2,
            "advisory_ids": [
              "GHSA-4x5r-pxfx-6jf8"
            ],
            "fixed_version": "8.0.0-rc.6",
            "advisory_count": 1,
            "oldest_advisory_days": 43
          },
          {
            "name": "pygments",
            "direct": false,
            "version": "2.19.2",
            "severity": "low",
            "ecosystem": "pypi",
            "cvss_score": 3.3,
            "advisory_ids": [
              "GHSA-5239-wwwm-4pmq",
              "PYSEC-2026-2987"
            ],
            "fixed_version": "2.20.0",
            "advisory_count": 2,
            "oldest_advisory_days": 128
          }
        ],
        "collected": true,
        "malicious": [],
        "truncated": false,
        "by_severity": {
          "low": 2,
          "high": 10,
          "critical": 4,
          "moderate": 8
        },
        "advisory_count": 101,
        "affected_count": 24,
        "assessed_count": 300,
        "malicious_count": 0,
        "assessed_package": null,
        "unassessed_count": 15,
        "direct_affected_count": 0
      },
      "ecosystems": [
        "pypi"
      ],
      "dependencies": [
        {
          "name": "asyncpg",
          "manifest": "packages/python/pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=0.29.0"
        },
        {
          "name": "pydantic",
          "manifest": "packages/python/pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=2.0.0"
        },
        {
          "name": "fastapi",
          "manifest": "packages/python/pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=0.109.0"
        },
        {
          "name": "sqlalchemy",
          "manifest": "packages/python/pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=2.0.0"
        },
        {
          "name": "sqlglot",
          "manifest": "packages/python/pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=26.0.0"
        },
        {
          "name": "uvicorn",
          "manifest": "packages/python/pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=0.27.0"
        }
      ],
      "all_dependencies": {
        "error": null,
        "source": "github-sbom",
        "packages": [
          {
            "name": "asyncpg",
            "direct": true,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "asyncpg",
            "direct": true,
            "version": "0.31.0",
            "ecosystem": "pypi"
          },
          {
            "name": "fastapi",
            "direct": true,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "fastapi",
            "direct": true,
            "version": "0.127.1",
            "ecosystem": "pypi"
          },
          {
            "name": "pydantic",
            "direct": true,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pydantic",
            "direct": true,
            "version": "2.12.5",
            "ecosystem": "pypi"
          },
          {
            "name": "sqlalchemy",
            "direct": true,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "sqlalchemy",
            "direct": true,
            "version": "2.0.45",
            "ecosystem": "pypi"
          },
          {
            "name": "sqlglot",
            "direct": true,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "sqlglot",
            "direct": true,
            "version": "28.5.0",
            "ecosystem": "pypi"
          },
          {
            "name": "uvicorn",
            "direct": true,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "uvicorn",
            "direct": true,
            "version": "0.40.0",
            "ecosystem": "pypi"
          },
          {
            "name": "@babel/code-frame",
            "direct": false,
            "version": "7.27.1",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/compat-data",
            "direct": false,
            "version": "7.28.5",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/core",
            "direct": false,
            "version": "7.28.5",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/generator",
            "direct": false,
            "version": "7.28.5",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/helper-compilation-targets",
            "direct": false,
            "version": "7.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/helper-globals",
            "direct": false,
            "version": "7.28.0",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/helper-module-imports",
            "direct": false,
            "version": "7.27.1",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/helper-module-transforms",
            "direct": false,
            "version": "7.28.3",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/helper-plugin-utils",
            "direct": false,
            "version": "7.27.1",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/helper-string-parser",
            "direct": false,
            "version": "7.27.1",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/helper-validator-identifier",
            "direct": false,
            "version": "7.28.5",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/helper-validator-option",
            "direct": false,
            "version": "7.27.1",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/helpers",
            "direct": false,
            "version": "7.28.4",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/parser",
            "direct": false,
            "version": "7.28.5",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/plugin-transform-react-jsx-self",
            "direct": false,
            "version": "7.27.1",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/plugin-transform-react-jsx-source",
            "direct": false,
            "version": "7.27.1",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/template",
            "direct": false,
            "version": "7.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/traverse",
            "direct": false,
            "version": "7.28.5",
            "ecosystem": "npm"
          },
          {
            "name": "@babel/types",
            "direct": false,
            "version": "7.28.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/aix-ppc64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/aix-ppc64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/android-arm",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/android-arm",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/android-arm64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/android-arm64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/android-x64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/android-x64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/darwin-arm64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/darwin-arm64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/darwin-x64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/darwin-x64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/freebsd-arm64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/freebsd-arm64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/freebsd-x64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/freebsd-x64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-arm",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-arm",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-arm64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-arm64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-ia32",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-ia32",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-loong64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-loong64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-mips64el",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-mips64el",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-ppc64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-ppc64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-riscv64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-riscv64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-s390x",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-s390x",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-x64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/linux-x64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/netbsd-arm64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/netbsd-x64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/netbsd-x64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/openbsd-arm64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/openbsd-x64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/openbsd-x64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/openharmony-arm64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/sunos-x64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/sunos-x64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/win32-arm64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/win32-arm64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/win32-ia32",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/win32-ia32",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/win32-x64",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "@esbuild/win32-x64",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "@jridgewell/gen-mapping",
            "direct": false,
            "version": "0.3.13",
            "ecosystem": "npm"
          },
          {
            "name": "@jridgewell/remapping",
            "direct": false,
            "version": "2.3.5",
            "ecosystem": "npm"
          },
          {
            "name": "@jridgewell/resolve-uri",
            "direct": false,
            "version": "3.1.2",
            "ecosystem": "npm"
          },
          {
            "name": "@jridgewell/sourcemap-codec",
            "direct": false,
            "version": "1.5.5",
            "ecosystem": "npm"
          },
          {
            "name": "@jridgewell/trace-mapping",
            "direct": false,
            "version": "0.3.31",
            "ecosystem": "npm"
          },
          {
            "name": "@playwright/test",
            "direct": false,
            "version": "1.58.0",
            "ecosystem": "npm"
          },
          {
            "name": "@prismiq/react",
            "direct": false,
            "version": "0.1.0",
            "ecosystem": "npm"
          },
          {
            "name": "@remix-run/router",
            "direct": false,
            "version": "1.23.1",
            "ecosystem": "npm"
          },
          {
            "name": "@rolldown/pluginutils",
            "direct": false,
            "version": "1.0.0-beta.27",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-android-arm-eabi",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-android-arm-eabi",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-android-arm64",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-android-arm64",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-darwin-arm64",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-darwin-arm64",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-darwin-x64",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-darwin-x64",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-freebsd-arm64",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-freebsd-arm64",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-freebsd-x64",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-freebsd-x64",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-arm-gnueabihf",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-arm-gnueabihf",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-arm-musleabihf",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-arm-musleabihf",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-arm64-gnu",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-arm64-gnu",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-arm64-musl",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-arm64-musl",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-loong64-gnu",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-loong64-gnu",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-loong64-musl",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-ppc64-gnu",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-ppc64-gnu",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-ppc64-musl",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-riscv64-gnu",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-riscv64-gnu",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-riscv64-musl",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-riscv64-musl",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-s390x-gnu",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-s390x-gnu",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-x64-gnu",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-x64-gnu",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-x64-musl",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-linux-x64-musl",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-openbsd-x64",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-openharmony-arm64",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-openharmony-arm64",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-win32-arm64-msvc",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-win32-arm64-msvc",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-win32-ia32-msvc",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-win32-ia32-msvc",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-win32-x64-gnu",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-win32-x64-gnu",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-win32-x64-msvc",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "@rollup/rollup-win32-x64-msvc",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "@types/babel__core",
            "direct": false,
            "version": "7.20.5",
            "ecosystem": "npm"
          },
          {
            "name": "@types/babel__generator",
            "direct": false,
            "version": "7.27.0",
            "ecosystem": "npm"
          },
          {
            "name": "@types/babel__template",
            "direct": false,
            "version": "7.4.4",
            "ecosystem": "npm"
          },
          {
            "name": "@types/babel__traverse",
            "direct": false,
            "version": "7.28.0",
            "ecosystem": "npm"
          },
          {
            "name": "@types/estree",
            "direct": false,
            "version": "1.0.8",
            "ecosystem": "npm"
          },
          {
            "name": "@types/node",
            "direct": false,
            "version": "25.0.10",
            "ecosystem": "npm"
          },
          {
            "name": "@types/prop-types",
            "direct": false,
            "version": "15.7.15",
            "ecosystem": "npm"
          },
          {
            "name": "@types/react",
            "direct": false,
            "version": "18.3.27",
            "ecosystem": "npm"
          },
          {
            "name": "@types/react-dom",
            "direct": false,
            "version": "18.3.7",
            "ecosystem": "npm"
          },
          {
            "name": "@vitejs/plugin-react",
            "direct": false,
            "version": "4.7.0",
            "ecosystem": "npm"
          },
          {
            "name": "acorn",
            "direct": false,
            "version": "8.15.0",
            "ecosystem": "npm"
          },
          {
            "name": "adler-32",
            "direct": false,
            "version": "1.3.1",
            "ecosystem": "npm"
          },
          {
            "name": "any-promise",
            "direct": false,
            "version": "1.3.0",
            "ecosystem": "npm"
          },
          {
            "name": "baseline-browser-mapping",
            "direct": false,
            "version": "2.9.11",
            "ecosystem": "npm"
          },
          {
            "name": "browserslist",
            "direct": false,
            "version": "4.28.1",
            "ecosystem": "npm"
          },
          {
            "name": "bundle-require",
            "direct": false,
            "version": "5.1.0",
            "ecosystem": "npm"
          },
          {
            "name": "cac",
            "direct": false,
            "version": "6.7.14",
            "ecosystem": "npm"
          },
          {
            "name": "caniuse-lite",
            "direct": false,
            "version": "1.0.30001761",
            "ecosystem": "npm"
          },
          {
            "name": "cfb",
            "direct": false,
            "version": "1.2.2",
            "ecosystem": "npm"
          },
          {
            "name": "chokidar",
            "direct": false,
            "version": "4.0.3",
            "ecosystem": "npm"
          },
          {
            "name": "clsx",
            "direct": false,
            "version": "2.1.1",
            "ecosystem": "npm"
          },
          {
            "name": "codepage",
            "direct": false,
            "version": "1.15.0",
            "ecosystem": "npm"
          },
          {
            "name": "commander",
            "direct": false,
            "version": "4.1.1",
            "ecosystem": "npm"
          },
          {
            "name": "confbox",
            "direct": false,
            "version": "0.1.8",
            "ecosystem": "npm"
          },
          {
            "name": "consola",
            "direct": false,
            "version": "3.4.2",
            "ecosystem": "npm"
          },
          {
            "name": "convert-source-map",
            "direct": false,
            "version": "2.0.0",
            "ecosystem": "npm"
          },
          {
            "name": "crc-32",
            "direct": false,
            "version": "1.2.2",
            "ecosystem": "npm"
          },
          {
            "name": "csstype",
            "direct": false,
            "version": "3.2.3",
            "ecosystem": "npm"
          },
          {
            "name": "debug",
            "direct": false,
            "version": "4.4.3",
            "ecosystem": "npm"
          },
          {
            "name": "echarts",
            "direct": false,
            "version": "6.0.0",
            "ecosystem": "npm"
          },
          {
            "name": "echarts-for-react",
            "direct": false,
            "version": "3.0.6",
            "ecosystem": "npm"
          },
          {
            "name": "electron-to-chromium",
            "direct": false,
            "version": "1.5.267",
            "ecosystem": "npm"
          },
          {
            "name": "esbuild",
            "direct": false,
            "version": "0.21.5",
            "ecosystem": "npm"
          },
          {
            "name": "esbuild",
            "direct": false,
            "version": "0.27.2",
            "ecosystem": "npm"
          },
          {
            "name": "escalade",
            "direct": false,
            "version": "3.2.0",
            "ecosystem": "npm"
          },
          {
            "name": "fast-deep-equal",
            "direct": false,
            "version": "3.1.3",
            "ecosystem": "npm"
          },
          {
            "name": "fast-equals",
            "direct": false,
            "version": "4.0.3",
            "ecosystem": "npm"
          },
          {
            "name": "fdir",
            "direct": false,
            "version": "6.5.0",
            "ecosystem": "npm"
          },
          {
            "name": "fix-dts-default-cjs-exports",
            "direct": false,
            "version": "1.0.1",
            "ecosystem": "npm"
          },
          {
            "name": "frac",
            "direct": false,
            "version": "1.1.2",
            "ecosystem": "npm"
          },
          {
            "name": "fsevents",
            "direct": false,
            "version": "2.3.2",
            "ecosystem": "npm"
          },
          {
            "name": "fsevents",
            "direct": false,
            "version": "2.3.3",
            "ecosystem": "npm"
          },
          {
            "name": "gensync",
            "direct": false,
            "version": "1.0.0-beta.2",
            "ecosystem": "npm"
          },
          {
            "name": "joycon",
            "direct": false,
            "version": "3.1.1",
            "ecosystem": "npm"
          },
          {
            "name": "js-tokens",
            "direct": false,
            "version": "4.0.0",
            "ecosystem": "npm"
          },
          {
            "name": "jsesc",
            "direct": false,
            "version": "3.1.0",
            "ecosystem": "npm"
          },
          {
            "name": "json5",
            "direct": false,
            "version": "2.2.3",
            "ecosystem": "npm"
          },
          {
            "name": "lilconfig",
            "direct": false,
            "version": "3.1.3",
            "ecosystem": "npm"
          },
          {
            "name": "lines-and-columns",
            "direct": false,
            "version": "1.2.4",
            "ecosystem": "npm"
          },
          {
            "name": "load-tsconfig",
            "direct": false,
            "version": "0.2.5",
            "ecosystem": "npm"
          },
          {
            "name": "loose-envify",
            "direct": false,
            "version": "1.4.0",
            "ecosystem": "npm"
          },
          {
            "name": "lru-cache",
            "direct": false,
            "version": "5.1.1",
            "ecosystem": "npm"
          },
          {
            "name": "magic-string",
            "direct": false,
            "version": "0.30.21",
            "ecosystem": "npm"
          },
          {
            "name": "mlly",
            "direct": false,
            "version": "1.8.0",
            "ecosystem": "npm"
          },
          {
            "name": "ms",
            "direct": false,
            "version": "2.1.3",
            "ecosystem": "npm"
          },
          {
            "name": "mz",
            "direct": false,
            "version": "2.7.0",
            "ecosystem": "npm"
          },
          {
            "name": "nanoid",
            "direct": false,
            "version": "3.3.11",
            "ecosystem": "npm"
          },
          {
            "name": "node-releases",
            "direct": false,
            "version": "2.0.27",
            "ecosystem": "npm"
          },
          {
            "name": "object-assign",
            "direct": false,
            "version": "4.1.1",
            "ecosystem": "npm"
          },
          {
            "name": "pathe",
            "direct": false,
            "version": "2.0.3",
            "ecosystem": "npm"
          },
          {
            "name": "picocolors",
            "direct": false,
            "version": "1.1.1",
            "ecosystem": "npm"
          },
          {
            "name": "picomatch",
            "direct": false,
            "version": "4.0.3",
            "ecosystem": "npm"
          },
          {
            "name": "pirates",
            "direct": false,
            "version": "4.0.7",
            "ecosystem": "npm"
          },
          {
            "name": "pkg-types",
            "direct": false,
            "version": "1.3.1",
            "ecosystem": "npm"
          },
          {
            "name": "playwright",
            "direct": false,
            "version": "1.58.0",
            "ecosystem": "npm"
          },
          {
            "name": "playwright-core",
            "direct": false,
            "version": "1.58.0",
            "ecosystem": "npm"
          },
          {
            "name": "postcss",
            "direct": false,
            "version": "8.5.6",
            "ecosystem": "npm"
          },
          {
            "name": "postcss-load-config",
            "direct": false,
            "version": "6.0.1",
            "ecosystem": "npm"
          },
          {
            "name": "prop-types",
            "direct": false,
            "version": "15.8.1",
            "ecosystem": "npm"
          },
          {
            "name": "react",
            "direct": false,
            "version": "18.3.1",
            "ecosystem": "npm"
          },
          {
            "name": "react-dom",
            "direct": false,
            "version": "18.3.1",
            "ecosystem": "npm"
          },
          {
            "name": "react-draggable",
            "direct": false,
            "version": "4.5.0",
            "ecosystem": "npm"
          },
          {
            "name": "react-grid-layout",
            "direct": false,
            "version": "2.2.2",
            "ecosystem": "npm"
          },
          {
            "name": "react-is",
            "direct": false,
            "version": "16.13.1",
            "ecosystem": "npm"
          },
          {
            "name": "react-refresh",
            "direct": false,
            "version": "0.17.0",
            "ecosystem": "npm"
          },
          {
            "name": "react-resizable",
            "direct": false,
            "version": "3.1.3",
            "ecosystem": "npm"
          },
          {
            "name": "react-router",
            "direct": false,
            "version": "6.30.2",
            "ecosystem": "npm"
          },
          {
            "name": "react-router-dom",
            "direct": false,
            "version": "6.30.2",
            "ecosystem": "npm"
          },
          {
            "name": "readdirp",
            "direct": false,
            "version": "4.1.2",
            "ecosystem": "npm"
          },
          {
            "name": "resize-observer-polyfill",
            "direct": false,
            "version": "1.5.1",
            "ecosystem": "npm"
          },
          {
            "name": "resolve-from",
            "direct": false,
            "version": "5.0.0",
            "ecosystem": "npm"
          },
          {
            "name": "rollup",
            "direct": false,
            "version": "4.54.0",
            "ecosystem": "npm"
          },
          {
            "name": "rollup",
            "direct": false,
            "version": "4.56.0",
            "ecosystem": "npm"
          },
          {
            "name": "scheduler",
            "direct": false,
            "version": "0.23.2",
            "ecosystem": "npm"
          },
          {
            "name": "semver",
            "direct": false,
            "version": "6.3.1",
            "ecosystem": "npm"
          },
          {
            "name": "size-sensor",
            "direct": false,
            "version": "1.0.3",
            "ecosystem": "npm"
          },
          {
            "name": "source-map",
            "direct": false,
            "version": "0.7.6",
            "ecosystem": "npm"
          },
          {
            "name": "source-map-js",
            "direct": false,
            "version": "1.2.1",
            "ecosystem": "npm"
          },
          {
            "name": "ssf",
            "direct": false,
            "version": "0.11.2",
            "ecosystem": "npm"
          },
          {
            "name": "sucrase",
            "direct": false,
            "version": "3.35.1",
            "ecosystem": "npm"
          },
          {
            "name": "thenify",
            "direct": false,
            "version": "3.3.1",
            "ecosystem": "npm"
          },
          {
            "name": "thenify-all",
            "direct": false,
            "version": "1.6.0",
            "ecosystem": "npm"
          },
          {
            "name": "tinyexec",
            "direct": false,
            "version": "0.3.2",
            "ecosystem": "npm"
          },
          {
            "name": "tinyglobby",
            "direct": false,
            "version": "0.2.15",
            "ecosystem": "npm"
          },
          {
            "name": "tree-kill",
            "direct": false,
            "version": "1.2.2",
            "ecosystem": "npm"
          },
          {
            "name": "ts-interface-checker",
            "direct": false,
            "version": "0.1.13",
            "ecosystem": "npm"
          },
          {
            "name": "tslib",
            "direct": false,
            "version": "2.3.0",
            "ecosystem": "npm"
          },
          {
            "name": "tsup",
            "direct": false,
            "version": "8.5.1",
            "ecosystem": "npm"
          },
          {
            "name": "typescript",
            "direct": false,
            "version": "5.9.3",
            "ecosystem": "npm"
          },
          {
            "name": "ufo",
            "direct": false,
            "version": "1.6.3",
            "ecosystem": "npm"
          },
          {
            "name": "undici-types",
            "direct": false,
            "version": "7.16.0",
            "ecosystem": "npm"
          },
          {
            "name": "update-browserslist-db",
            "direct": false,
            "version": "1.2.3",
            "ecosystem": "npm"
          },
          {
            "name": "vite",
            "direct": false,
            "version": "5.4.21",
            "ecosystem": "npm"
          },
          {
            "name": "wmf",
            "direct": false,
            "version": "1.0.2",
            "ecosystem": "npm"
          },
          {
            "name": "word",
            "direct": false,
            "version": "0.3.0",
            "ecosystem": "npm"
          },
          {
            "name": "xlsx",
            "direct": false,
            "version": "0.18.5",
            "ecosystem": "npm"
          },
          {
            "name": "yallist",
            "direct": false,
            "version": "3.1.1",
            "ecosystem": "npm"
          },
          {
            "name": "zrender",
            "direct": false,
            "version": "6.0.0",
            "ecosystem": "npm"
          },
          {
            "name": "aiohappyeyeballs",
            "direct": false,
            "version": "2.6.1",
            "ecosystem": "pypi"
          },
          {
            "name": "aiohttp",
            "direct": false,
            "version": "3.13.3",
            "ecosystem": "pypi"
          },
          {
            "name": "aiosignal",
            "direct": false,
            "version": "1.4.0",
            "ecosystem": "pypi"
          },
          {
            "name": "annotated-doc",
            "direct": false,
            "version": "0.0.4",
            "ecosystem": "pypi"
          },
          {
            "name": "annotated-types",
            "direct": false,
            "version": "0.7.0",
            "ecosystem": "pypi"
          },
          {
            "name": "anyio",
            "direct": false,
            "version": "4.12.0",
            "ecosystem": "pypi"
          },
          {
            "name": "async-timeout",
            "direct": false,
            "version": "5.0.1",
            "ecosystem": "pypi"
          },
          {
            "name": "attrs",
            "direct": false,
            "version": "25.4.0",
            "ecosystem": "pypi"
          },
          {
            "name": "backports-asyncio-runner",
            "direct": false,
            "version": "1.2.0",
            "ecosystem": "pypi"
          },
          {
            "name": "certifi",
            "direct": false,
            "version": "2025.11.12",
            "ecosystem": "pypi"
          },
          {
            "name": "cffi",
            "direct": false,
            "version": "2.0.0",
            "ecosystem": "pypi"
          },
          {
            "name": "cfgv",
            "direct": false,
            "version": "3.5.0",
            "ecosystem": "pypi"
          },
          {
            "name": "charset-normalizer",
            "direct": false,
            "version": "3.4.4",
            "ecosystem": "pypi"
          },
          {
            "name": "click",
            "direct": false,
            "version": "8.3.1",
            "ecosystem": "pypi"
          },
          {
            "name": "colorama",
            "direct": false,
            "version": "0.4.6",
            "ecosystem": "pypi"
          },
          {
            "name": "coverage",
            "direct": false,
            "version": "7.13.0",
            "ecosystem": "pypi"
          },
          {
            "name": "cryptography",
            "direct": false,
            "version": "46.0.5",
            "ecosystem": "pypi"
          },
          {
            "name": "distlib",
            "direct": false,
            "version": "0.4.0",
            "ecosystem": "pypi"
          },
          {
            "name": "distro",
            "direct": false,
            "version": "1.9.0",
            "ecosystem": "pypi"
          },
          {
            "name": "exceptiongroup",
            "direct": false,
            "version": "1.3.1",
            "ecosystem": "pypi"
          },
          {
            "name": "filelock",
            "direct": false,
            "version": "3.20.1",
            "ecosystem": "pypi"
          },
          {
            "name": "frozenlist",
            "direct": false,
            "version": "1.8.0",
            "ecosystem": "pypi"
          },
          {
            "name": "google-auth",
            "direct": false,
            "version": "2.48.0",
            "ecosystem": "pypi"
          },
          {
            "name": "google-genai",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "google-genai",
            "direct": false,
            "version": "1.64.0",
            "ecosystem": "pypi"
          },
          {
            "name": "greenlet",
            "direct": false,
            "version": "3.3.0",
            "ecosystem": "pypi"
          },
          {
            "name": "h11",
            "direct": false,
            "version": "0.16.0",
            "ecosystem": "pypi"
          },
          {
            "name": "httpcore",
            "direct": false,
            "version": "1.0.9",
            "ecosystem": "pypi"
          },
          {
            "name": "httpx",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "httpx",
            "direct": false,
            "version": "0.28.1",
            "ecosystem": "pypi"
          },
          {
            "name": "identify",
            "direct": false,
            "version": "2.6.15",
            "ecosystem": "pypi"
          },
          {
            "name": "idna",
            "direct": false,
            "version": "3.11",
            "ecosystem": "pypi"
          },
          {
            "name": "iniconfig",
            "direct": false,
            "version": "2.3.0",
            "ecosystem": "pypi"
          },
          {
            "name": "multidict",
            "direct": false,
            "version": "6.7.1",
            "ecosystem": "pypi"
          },
          {
            "name": "nodeenv",
            "direct": false,
            "version": "1.10.0",
            "ecosystem": "pypi"
          },
          {
            "name": "packaging",
            "direct": false,
            "version": "25.0",
            "ecosystem": "pypi"
          },
          {
            "name": "platformdirs",
            "direct": false,
            "version": "4.5.1",
            "ecosystem": "pypi"
          },
          {
            "name": "pluggy",
            "direct": false,
            "version": "1.6.0",
            "ecosystem": "pypi"
          },
          {
            "name": "pre-commit",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pre-commit",
            "direct": false,
            "version": "4.5.1",
            "ecosystem": "pypi"
          },
          {
            "name": "propcache",
            "direct": false,
            "version": "0.4.1",
            "ecosystem": "pypi"
          },
          {
            "name": "pyasn1",
            "direct": false,
            "version": "0.6.2",
            "ecosystem": "pypi"
          },
          {
            "name": "pyasn1-modules",
            "direct": false,
            "version": "0.4.2",
            "ecosystem": "pypi"
          },
          {
            "name": "pycparser",
            "direct": false,
            "version": "3.0",
            "ecosystem": "pypi"
          },
          {
            "name": "pydantic-core",
            "direct": false,
            "version": "2.41.5",
            "ecosystem": "pypi"
          },
          {
            "name": "pygments",
            "direct": false,
            "version": "2.19.2",
            "ecosystem": "pypi"
          },
          {
            "name": "pyright",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pyright",
            "direct": false,
            "version": "1.1.407",
            "ecosystem": "pypi"
          },
          {
            "name": "pytest",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pytest",
            "direct": false,
            "version": "9.0.2",
            "ecosystem": "pypi"
          },
          {
            "name": "pytest-asyncio",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pytest-asyncio",
            "direct": false,
            "version": "1.3.0",
            "ecosystem": "pypi"
          },
          {
            "name": "pytest-cov",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pytest-cov",
            "direct": false,
            "version": "7.0.0",
            "ecosystem": "pypi"
          },
          {
            "name": "pyyaml",
            "direct": false,
            "version": "6.0.3",
            "ecosystem": "pypi"
          },
          {
            "name": "redis",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "redis",
            "direct": false,
            "version": "7.1.0",
            "ecosystem": "pypi"
          },
          {
            "name": "requests",
            "direct": false,
            "version": "2.32.5",
            "ecosystem": "pypi"
          },
          {
            "name": "rsa",
            "direct": false,
            "version": "4.9.1",
            "ecosystem": "pypi"
          },
          {
            "name": "ruff",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "ruff",
            "direct": false,
            "version": "0.14.10",
            "ecosystem": "pypi"
          },
          {
            "name": "sniffio",
            "direct": false,
            "version": "1.3.1",
            "ecosystem": "pypi"
          },
          {
            "name": "starlette",
            "direct": false,
            "version": "0.50.0",
            "ecosystem": "pypi"
          },
          {
            "name": "tenacity",
            "direct": false,
            "version": "9.1.4",
            "ecosystem": "pypi"
          },
          {
            "name": "tomli",
            "direct": false,
            "version": "2.3.0",
            "ecosystem": "pypi"
          },
          {
            "name": "typing-extensions",
            "direct": false,
            "version": "4.15.0",
            "ecosystem": "pypi"
          },
          {
            "name": "typing-inspection",
            "direct": false,
            "version": "0.4.2",
            "ecosystem": "pypi"
          },
          {
            "name": "urllib3",
            "direct": false,
            "version": "2.6.3",
            "ecosystem": "pypi"
          },
          {
            "name": "virtualenv",
            "direct": false,
            "version": "20.35.4",
            "ecosystem": "pypi"
          },
          {
            "name": "websockets",
            "direct": false,
            "version": "15.0.1",
            "ecosystem": "pypi"
          },
          {
            "name": "yarl",
            "direct": false,
            "version": "1.22.0",
            "ecosystem": "pypi"
          }
        ],
        "collected": true,
        "truncated": false,
        "total_count": 315,
        "direct_count": 12,
        "indirect_count": 303
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 0,
        "merged_prs": 82,
        "open_issues": 0,
        "closed_ratio": null,
        "closed_issues": 0,
        "closed_unmerged_prs": 2
      },
      "bus_factor": 1,
      "bot_contributors": 0,
      "top_contributors": [
        {
          "type": "User",
          "login": "navin-statisfy",
          "commits": 151,
          "avatar_url": "https://avatars.githubusercontent.com/u/151481745?v=4"
        },
        {
          "type": "User",
          "login": "naman-statisfy",
          "commits": 87,
          "avatar_url": "https://avatars.githubusercontent.com/u/151496983?v=4"
        }
      ],
      "contributors_sampled": 2,
      "top_contributor_share": 0.634
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "ci.yml",
        "publish-npm.yml",
        "publish-pypi.yml"
      ],
      "has_docs_dir": true,
      "linter_configs": [],
      "has_editorconfig": false,
      "has_linter_config": true,
      "has_precommit_config": true
    },
    "security_signals": {
      "lockfiles": [
        "package-lock.json",
        "uv.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": 10,
            "reason": "30 out of 30 merged PRs checked by a CI test -- score normalized to 10",
            "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": 2,
            "reason": "Found 6/30 approved changesets -- score normalized to 2",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 0,
            "reason": "project has 0 contributing companies or organizations -- score normalized to 0",
            "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": 0,
            "reason": "no 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": 8,
            "reason": "10 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 8",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
          },
          {
            "name": "Packaging",
            "score": 10,
            "reason": "packaging workflow detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
          },
          {
            "name": "Pinned-Dependencies",
            "score": 3,
            "reason": "dependency not pinned by hash detected -- score normalized to 3",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
          },
          {
            "name": "SAST",
            "score": 10,
            "reason": "SAST tool is run on all commits",
            "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": 9,
            "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": "61 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "4688e2e0d6f4540ddea1fa277a2b80e7286d70d2",
        "ran_at": "2026-07-29T05:57:26Z",
        "aggregate_score": 5.2,
        "scorecard_version": "v5.5.0"
      },
      "has_codeql_workflow": false,
      "has_security_policy": false,
      "has_dependabot_config": false
    },
    "contribution_flow": {
      "collected": true,
      "ci_last_run_at": "2026-07-29T05:48:26Z",
      "oldest_open_prs": [],
      "last_merged_pr_at": "2026-07-29T05:47:03Z",
      "ci_last_conclusion": "SUCCESS",
      "oldest_open_issues": []
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/statisfy-us/prismiq",
    "host": "github.com",
    "name": "prismiq",
    "owner": "statisfy-us"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "moderate",
      "name": "Overall health",
      "note": null,
      "notes": [],
      "value": 65,
      "inputs": {
        "security": 62,
        "vitality": 83,
        "community": 40,
        "governance": 55,
        "engineering": 82
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "good",
        "name": "Vitality",
        "value": 83,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "good",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 72,
            "inputs": {
              "commits_last_year": 233,
              "human_commit_share": 1,
              "days_since_last_push": 0,
              "active_weeks_last_year": 15
            },
            "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": "15/52 weeks with commits",
                "points": 10.4,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 15
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "233 commits in the last year",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 233
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "10 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 8",
                "points": 8,
                "status": "partial",
                "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": 25,
              "latest_release_tag": "python-v0.2.11",
              "releases_from_tags": false,
              "days_since_latest_release": 0,
              "mean_days_between_releases": 12.3
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "25 releases published",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "releases_published",
                    "params": {
                      "count": 25
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 0 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~12.3 days",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 12.3
                    }
                  }
                ],
                "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": "maintained",
              "guards": [],
              "signals": [],
              "red_flag": false,
              "multiplier_pct": 100,
              "declared_reason": null,
              "unverified_reason": null,
              "unanswered_open_prs": null,
              "unanswered_open_issues": null,
              "days_since_last_merged_pr": null,
              "days_since_last_human_commit": 0,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "last human commit 0 days ago",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_maintained",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "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": 40,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "critical",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 1,
            "inputs": {
              "forks": 0,
              "stars": 0,
              "watchers": 0,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "0 stars",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 0
                    }
                  }
                ],
                "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 (MIT)",
                "points": 22.5,
                "status": "met",
                "details": [
                  {
                    "code": "license_standard",
                    "params": {}
                  },
                  {
                    "code": "license_spdx",
                    "params": {
                      "spdx": "MIT"
                    }
                  }
                ],
                "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
              }
            ]
          },
          {
            "key": "ecosystem_adoption",
            "band": "moderate",
            "name": "Ecosystem adoption (downloads)",
            "note": "Excluded from scoring (no data or not applicable): Registry dependents. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "registry_dependents"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 60,
            "inputs": {
              "packages": [
                "@prismiq/react",
                "prismiq"
              ],
              "dependents": null,
              "ecosystems": "npm, pypi",
              "total_downloads": null,
              "monthly_downloads": 3803
            },
            "components": [
              {
                "key": "monthly_downloads",
                "name": "Monthly downloads",
                "detail": "3,803 downloads/month across npm, pypi",
                "points": 47.7,
                "status": "partial",
                "details": [
                  {
                    "code": "downloads_monthly",
                    "params": {
                      "count": 3803,
                      "ecosystems": "npm, pypi"
                    }
                  }
                ],
                "max_points": 80
              },
              {
                "key": "registry_dependents",
                "name": "Registry dependents",
                "detail": "not reported by this ecosystem",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "not_reported_by_this_ecosystem",
                    "params": {}
                  }
                ],
                "max_points": 20
              }
            ]
          }
        ],
        "description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
      },
      {
        "key": "governance",
        "band": "moderate",
        "name": "Sustainability & Governance",
        "value": 55,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "critical",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 20,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 2,
              "top_contributor_share": 0.634
            },
            "components": [
              {
                "key": "bus_factor",
                "name": "Bus factor",
                "detail": "1 contributor(s) cover half of all commits",
                "points": 9,
                "status": "partial",
                "details": [
                  {
                    "code": "bus_factor",
                    "params": {
                      "count": 1
                    }
                  }
                ],
                "max_points": 54
              },
              {
                "key": "commit_distribution",
                "name": "Commit distribution",
                "detail": "top contributor authored 63% of commits",
                "points": 8.2,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 63
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "2 contributors",
                "points": 2.7,
                "status": "partial",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 2
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 0 contributing companies or organizations -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "good",
            "name": "Issue & PR responsiveness",
            "note": "Excluded from scoring (no data or not applicable): Issue resolution. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "issue_resolution"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 76,
            "inputs": {
              "merged_prs": 82,
              "open_issues": 0,
              "closed_issues": 0,
              "issue_closed_ratio": null,
              "closed_unmerged_prs": 2
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "no issues or no data",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_issues_or_data",
                    "params": {}
                  }
                ],
                "max_points": 46.75
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "82/84 decided PRs merged",
                "points": 37.3,
                "status": "partial",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 82,
                      "decided": 84
                    }
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 6/30 approved changesets -- score normalized to 2",
                "points": 3,
                "status": "partial",
                "details": [],
                "max_points": 15
              }
            ]
          },
          {
            "key": "stewardship",
            "band": "at_risk",
            "name": "Ownership & stewardship",
            "note": null,
            "notes": [],
            "value": 41,
            "inputs": {
              "followers": 1,
              "owner_type": "Organization",
              "is_verified": null,
              "owner_login": "statisfy-us",
              "public_repos": 2,
              "account_age_days": 982
            },
            "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": "1 followers of statisfy-us",
                "points": 2.2,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 1,
                      "login": "statisfy-us"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "2 public repos, account ~2 yr old",
                "points": 8.9,
                "status": "partial",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 2
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 2
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "excellent",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "packages": [
                "@prismiq/react",
                "prismiq"
              ],
              "ecosystems": "npm, pypi",
              "any_deprecated": false,
              "min_days_since_publish": 0
            },
            "components": [
              {
                "key": "published_resolvable",
                "name": "Published & resolvable",
                "detail": "2 package(s) on npm, pypi",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "packages_published",
                    "params": {
                      "count": 2,
                      "ecosystems": "npm, pypi"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "publish_recency",
                "name": "Publish recency",
                "detail": "latest publish 0 days ago",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "14 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 14
                    }
                  }
                ],
                "max_points": 20
              },
              {
                "key": "not_deprecated",
                "name": "Not deprecated",
                "detail": "active, not deprecated or yanked",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "package_not_deprecated",
                    "params": {}
                  }
                ],
                "max_points": 20
              }
            ]
          }
        ],
        "description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
      },
      {
        "key": "engineering",
        "band": "good",
        "name": "Engineering Quality",
        "value": 82,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "excellent",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 94,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": true,
              "has_precommit_config": true
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "3 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 3
                    }
                  }
                ],
                "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": 16,
                "status": "met",
                "details": [],
                "max_points": 16
              },
              {
                "key": "pre_commit_hooks",
                "name": "Pre-commit hooks",
                "detail": null,
                "points": 9.6,
                "status": "met",
                "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": "30 out of 30 merged PRs checked by a CI test -- score normalized to 10",
                "points": 20,
                "status": "met",
                "details": [],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "moderate",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 65,
            "inputs": {
              "topics": [],
              "has_wiki": true,
              "homepage": null,
              "has_readme": true,
              "has_docs_dir": true,
              "has_description": false
            },
            "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": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              },
              {
                "key": "repository_description",
                "name": "Repository description",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              },
              {
                "key": "topics",
                "name": "Topics",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "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": "moderate",
        "name": "Security",
        "value": 62,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "moderate",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 52,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 17,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 1,
              "scorecard_aggregate": 5.2
            },
            "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": "30 out of 30 merged PRs checked by a CI test -- score normalized to 10",
                "points": 2.5,
                "status": "met",
                "details": [],
                "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 6/30 approved changesets -- score normalized to 2",
                "points": 1.5,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 0 contributing companies or organizations -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "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": "no update tool detected",
                "points": 0,
                "status": "missed",
                "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": "10 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 8",
                "points": 6,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "packaging",
                "name": "Packaging",
                "detail": "packaging workflow detected",
                "points": 5,
                "status": "met",
                "details": [],
                "max_points": 5
              },
              {
                "key": "pinned_dependencies",
                "name": "Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 3",
                "points": 1.5,
                "status": "partial",
                "details": [],
                "max_points": 5
              },
              {
                "key": "sast",
                "name": "SAST",
                "detail": "SAST tool is run on all commits",
                "points": 5,
                "status": "met",
                "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": 6.8,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "vulnerabilities",
                "name": "Vulnerabilities",
                "detail": "61 existing vulnerabilities detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              }
            ]
          },
          {
            "key": "dependency_advisories",
            "band": "excellent",
            "name": "Dependency advisories",
            "note": "Excluded from scoring (no data or not applicable): Indirect dependencies free of known advisories, No advisories left outstanding. Remaining weights renormalized. Matched 300 resolved dependencies against OSV; 15 could not be assessed (no resolved version, an unsupported ecosystem, or beyond the reported package list). This repository publishes no package the index resolves, so the repository dependency graph was assessed instead. That graph mixes development and test pins with shipped dependencies, so only the declared runtime dependencies are scored; transitive findings are reported as context and excluded from the score. Reachability is not analyzed.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "indirect_dependencies_free_of_known_advisories",
                    "no_advisories_left_outstanding"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              },
              {
                "code": "advisories_scope_repository",
                "params": {
                  "assessed": 300
                }
              },
              {
                "code": "advisories_unassessed",
                "params": {
                  "count": 15
                }
              },
              {
                "code": "advisories_repo_graph_caveat",
                "params": {}
              },
              {
                "code": "advisories_reachability",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "source": "osv",
              "advisories": 101,
              "affected_packages": 24,
              "assessed_packages": 300,
              "unassessed_packages": 15,
              "affected_by_severity": "critical 4, high 10, moderate 8, low 2",
              "direct_affected_packages": 0
            },
            "components": [
              {
                "key": "direct_dependencies_free_of_known_advisories",
                "name": "Direct dependencies free of known advisories",
                "detail": "no direct dependency carries a known advisory",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "no_direct_advisories",
                    "params": {}
                  }
                ],
                "max_points": 35
              },
              {
                "key": "indirect_dependencies_free_of_known_advisories",
                "name": "Indirect dependencies free of known advisories",
                "detail": "transitive set not separable from development and test dependencies in this scope",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "advisories_scope_not_separable",
                    "params": {}
                  }
                ],
                "max_points": 25
              },
              {
                "key": "no_advisories_left_outstanding",
                "name": "No advisories left outstanding",
                "detail": "no advisory carries a publication date",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "advisories_no_publication_date",
                    "params": {}
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "malicious_dependencies",
            "band": "excellent",
            "name": "Malicious dependencies",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "source": "osv",
              "meaning": "reported as a malicious package by the OpenSSF corpus; the remedy is removal or moving off the compromised name, never an upgrade of the same artifact. Versions the registry has since pulled are listed but not scored",
              "packages": [],
              "red_flag": false,
              "assessed_packages": 300,
              "malicious_packages": 0,
              "direct_malicious_packages": 0,
              "withdrawn_malicious_packages": 0,
              "installable_malicious_packages": 0
            },
            "components": [
              {
                "key": "no_dependency_reported_as_a_malicious_package",
                "name": "No dependency reported as a malicious package",
                "detail": "no dependency is reported as a malicious package",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "no_malicious_dependencies",
                    "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": 77,
        "weight": 0,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "good",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 82,
            "inputs": {
              "has_llms_txt": false,
              "legible_history_share": 0.7,
              "agent_instruction_files": [
                "CLAUDE.md"
              ],
              "agent_instruction_max_bytes": 18054
            },
            "components": [
              {
                "key": "agent_instructions",
                "name": "Agent instructions",
                "detail": "CLAUDE.md",
                "points": 45,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "CLAUDE.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": "70 of 100 human commits state their intent (structured subject or explanatory body)",
                "points": 37.3,
                "status": "partial",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 70,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "excellent",
            "name": "Verify loop (build / test / typecheck)",
            "note": null,
            "notes": [],
            "value": 85,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [
                "package-lock.json",
                "uv.lock"
              ],
              "has_dockerfile": true,
              "typed_language": false,
              "bootstrap_files": [
                "Makefile"
              ],
              "has_devcontainer": false,
              "has_linter_config": true,
              "typecheck_configs": [
                "examples/demo/frontend/tsconfig.json",
                "packages/python/prismiq/py.typed",
                "packages/react/tsconfig.json"
              ],
              "agent_commit_share": 0.39,
              "toolchain_manifests": [],
              "dependency_bot_commit_share": 0
            },
            "components": [
              {
                "key": "one_command_bootstrap",
                "name": "One-command bootstrap",
                "detail": "Makefile",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "Makefile"
                    }
                  }
                ],
                "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": 11,
                "status": "met",
                "details": [],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": "examples/demo/frontend/tsconfig.json, packages/python/prismiq/py.typed, packages/react/tsconfig.json",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "examples/demo/frontend/tsconfig.json, packages/python/prismiq/py.typed, packages/react/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": "39 of the last 100 commits agent-authored or agent-credited",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "agent_authored_commits",
                    "params": {
                      "count": 39,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "automated_maintenance",
                "name": "Automated maintenance",
                "detail": "no automated dependency updates observed",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_dependency_automation",
                    "params": {}
                  }
                ],
                "max_points": 8
              },
              {
                "key": "openssf_scorecard_pinned_dependencies",
                "name": "OpenSSF Scorecard: Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 3",
                "points": 3,
                "status": "partial",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "ai_code_legibility",
            "band": "good",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 81,
            "inputs": {
              "primary_language": "Python",
              "largest_source_bytes": 70198,
              "source_files_sampled": 287,
              "oversized_source_files": 3
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "Python with type-check config (examples/demo/frontend/tsconfig.json, packages/python/prismiq/py.typed, packages/react/tsconfig.json)",
                "points": 27,
                "status": "partial",
                "details": [
                  {
                    "code": "typecheck_config_language",
                    "params": {
                      "files": "examples/demo/frontend/tsconfig.json, packages/python/prismiq/py.typed, packages/react/tsconfig.json",
                      "language": "Python"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "3/287 source files over 60KB",
                "points": 54.4,
                "status": "partial",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 287,
                      "oversized": 3
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          },
          {
            "key": "ai_interfaces",
            "band": "at_risk",
            "name": "Machine-readable interfaces",
            "note": null,
            "notes": [],
            "value": 40,
            "inputs": {
              "example_dirs": [
                "examples"
              ],
              "has_mcp_signal": false,
              "api_schema_files": []
            },
            "components": [
              {
                "key": "api_schema_openapi_graphql_proto",
                "name": "API schema (OpenAPI/GraphQL/proto)",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "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",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "examples"
                    }
                  }
                ],
                "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": [
    "deps.dev does not index pypi:prismiq@0.2.11; advisories assessed against the repository dependency graph instead"
  ],
  "report_type": "repository",
  "generated_at": "2026-07-29T05:57:42.468818Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/s/statisfy-us/prismiq.svg",
  "full_name": "statisfy-us/prismiq",
  "license_state": "standard",
  "license_spdx": "MIT"
}