Public record
Software health reportschema 0.27.0 · metrics 1.13.0 · 2026-07-24 02:57 UTC

ash-project / ash_sqlite

The SQLite data layer for Ash Framework.

ElixirCustom license★ 30 stars⑂ 30 forkssince Sep 2023View on GitHub ↗

ash-project/ash_sqlite holds a health index of 68 out of 100, placing it in the Moderate band. It scores highest on Engineering Quality (71/100) and lowest on AI Readiness (49/100). It was last updated 22 days ago. A single contributor accounts for most of its recent work.

68
overall / 100
Moderate

Software health index

Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At risk ceiling of 49. AI Readiness sits outside the overall score.

68
Excellent85-100Exemplary; meets essentially all checked criteria
Good70-84Healthy; minor gaps
Moderate50-69Acceptable with notable gaps; review recommended
At risk30-49Significant weaknesses; adoption warrants caution
Critical1-29Severe problems (abandoned, single-maintainer, no hygiene)
VitalityCommunity &AdoptionSustainability &GovernanceEngineeringQualitySecurityAI Readiness

Score profile

Each axis is a category. The shape matters more than the average — a healthy subject fills the whole shape, while a spike-and-crater profile means strength in one dimension is masking risk in another.

Ownership

Ash FrameworkOrganization
385 followers61 public repossince Dec 2019

This repository is backed by an organization — shared, accountable stewardship that can outlive any single maintainer.

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publish
Hexash_sqlite0.2.172,1282492 days ago

Metrics by category

Vitality

Is the project alive — is code being written and are releases shipping?

70Good · 22% of overall
How it's scored
28.8/36Push recency — last push 22 days ago
15.9/36Commit cadence — 23/52 weeks with commits
15.8/18Commit volume — 57 commits in the last year
8/10OpenSSF Scorecard: Maintained — 10 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 8
Inputs used
commits_last_year57
human_commit_share0.78
days_since_last_push22
active_weeks_last_year23
How it's scored
27/27Ships releases — 3 releases published
27/36Release recency — latest release 92 days ago
12.6/27Release cadence — a release every ~137.1 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count3
latest_release_tagv0.2.17
releases_from_tagsno
days_since_latest_release92
mean_days_between_releases137.1
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.

Community & Adoption

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

60Moderate · 18% of overall
How it's scored
23.7/60Stars — 30 stars
12.2/25Forks — 30 forks
2.7/15Watchers — 4 watchers
Inputs used
forks30
stars30
watchers4
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

86Excellent
How it's scored
22.5/22.5README
16.9/22.5License — license file present, not a recognized license
18/18CONTRIBUTING guide
13.5/13.5Code of conduct
0/7.2Issue template
6.3/6.3PR template
Inputs used
has_readmeyes
has_licenseno
has_contributingyes
has_issue_templateno
has_code_of_conductyes
has_pull_request_templateyes
How it's scored
44.4/80Monthly downloads — 2,128 downloads/month across hex
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagesash_sqlite
dependents
ecosystemshex
total_downloads31,399
monthly_downloads2,128
Excluded from scoring (no data or not applicable): Registry dependents. Remaining weights renormalized.

Sustainability & Governance

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

70Good · 24% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
4.3/22.5Commit distribution — top contributor authored 81% of commits
13.5/13.5Contributor breadth — 22 contributors
10/10OpenSSF Scorecard: Contributors — project has 4 contributing companies or organizations
Inputs used
bus_factor1
contributors_sampled22
top_contributor_share0.807
How it's scored
46.8/46.8Issue resolution — 100% of issues closed
31.7/38.3PR acceptance — 149/180 decided PRs merged
3/15OpenSSF Scorecard: Code-Review — Found 6/28 approved changesets -- score normalized to 2
Inputs used
merged_prs149
open_issues0
closed_issues34
issue_closed_ratio1
closed_unmerged_prs31
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
18.6/25Owner reach — 385 followers of ash-project
25/25Track record — 61 public repos, account ~6 yr old
Inputs used
followers385
owner_typeOrganization
is_verified
owner_loginash-project
public_repos61
account_age_days2,423
How it's scored
25/25Published & resolvable — 1 package(s) on hex
35/35Publish recency — latest publish 92 days ago
20/20Version history — 24 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagesash_sqlite
ecosystemshex
any_deprecatedno
min_days_since_publish92

Engineering Quality

Are baseline engineering and documentation practices in place?

71Good · 20% of overall
How it's scored
24/24CI workflows — 1 workflow(s)
24/24Tests present
0/16Linter config
0/9.6Pre-commit hooks
0/6.4.editorconfig
4/20OpenSSF Scorecard: CI-Tests — 2 out of 8 merged PRs checked by a CI test -- score normalized to 2
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configno
has_precommit_configno

Documentation

100Excellent
How it's scored
30/30README
25/25Documentation directory
15/15Documentation / homepage site — https://hexdocs.pm/ash_sqlite
10/10Repository description
10/10Topics — 4 topics
10/10Wiki
Inputs used
topicsash, data-layer, elixir, sqlite
has_wikiyes
homepagehttps://hexdocs.pm/ash_sqlite
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

Are visible security and supply-chain practices strong, without unresolved high-risk jurisdiction exposure?

66Moderate · 16% of overall
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
3.8/7.5Branch-Protection — branch protection is not maximal on development and all release branches
0.5/2.5CI-Tests — 2 out of 8 merged PRs checked by a CI test -- score normalized to 2
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
1.5/7.5Code-Review — Found 6/28 approved changesets -- score normalized to 2
2.5/2.5Contributors — project has 4 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
6/7.5Maintained — 10 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 8
0/5Packaging — no data
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
2.5/5SAST — SAST tool is not run on all commits -- score normalized to 5
5/5Security-Policy — security policy file detected
0/7.5Signed-Releases — no data
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
3.8/7.5Vulnerabilities — 5 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated16
scorecard_versionv5.5.0
checks_inconclusive2
scorecard_aggregate5.7
Excluded from scoring (no data or not applicable): packaging, signed_releases. Remaining weights renormalized.
How it's scored
35/35Direct dependencies free of known advisories — no direct dependency carries a known advisory
0/25Indirect dependencies free of known advisories — transitive set not separable from development and test dependencies in this scope
0/40No advisories left outstanding — no advisory carries a publication date
Inputs used
sourceosv
advisories5
affected_packages2
assessed_packages57
unassessed_packages0
affected_by_severityhigh 2
direct_affected_packages0
Excluded from scoring (no data or not applicable): Indirect dependencies free of known advisories, No advisories left outstanding. Remaining weights renormalized. Matched 57 resolved dependencies against OSV. 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.

AI Readiness

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.

49At risk · 0% of overall
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
40/40Legible commit history — 77 of 78 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
legible_history_share0.987
agent_instruction_files
agent_instruction_max_bytes
How it's scored
12.6/18One-command bootstrap — mix.exs (toolchain convention, no task runner)
22/22Automated tests
0/11Lint / format config
0/11Static type checking
10/10Reproducible environment — lockfile
0/10Demonstrated agent practice — no agent-authored commits among the last 100
8/8Automated maintenance — 22 of the last 100 commits are automated dependency updates
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfilesmix.lock
has_dockerfileno
typed_languageno
bootstrap_files
has_devcontainerno
has_linter_configno
typecheck_configs
agent_commit_share0
toolchain_manifestsmix.exs
dependency_bot_commit_share0.22
How it's scored
0/45Type-checkable code — Elixir without a type-check config
53.7/55Manageable file sizes — 2/87 source files over 60KB
Inputs used
primary_languageElixir
largest_source_bytes77,094
source_files_sampled87
oversized_source_files2

Key facts

30GitHub stars
22contributors
57commits, last 12 months
22days since last push
3releases
1bus factor
0open issues
Hexpackage ecosystems

Data collection warnings

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token

More detail

Star and fork history 0 ★ / 30 ⇿
0Stars
30Forks
3Releases

When each star and fork was added, collected from GitHub and bucketed by day. Cumulative growth sits directly above the daily additions it is made of, so the two read against each other: steady organic accretion looks nothing like an abrupt, short-lived burst. Where that difference is measurable, it is reported as growth authenticity.

0510152025303012023-102025-022026-06
Major 0Minor 0Patch 3

Each point covers 3 days.

OpenSSF Scorecard 5.7 / 10
5.7aggregate

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

10Binary-Artifactsno binaries found in the repo
5Branch-Protectionbranch protection is not maximal on development and all release branches
2CI-Tests2 out of 8 merged PRs checked by a CI test -- score normalized to 2
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
2Code-ReviewFound 6/28 approved changesets -- score normalized to 2
10Contributorsproject has 4 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
8Maintained10 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 8
n/aPackagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
5SASTSAST tool is not run on all commits -- score normalized to 5
10Security-Policysecurity policy file detected
n/aSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
5Vulnerabilities5 existing vulnerabilities detected
Direct dependencies 8
RegistryPackageVersion constraintManifest
Hexecto_sql~> 3.13mix.exs
Hexecto_sqlite3~> 0.12mix.exs
Hexecto_libsql~> 0.9mix.exs
Hexecto~> 3.13mix.exs
Hexjason~> 1.0mix.exs
Hexash~> 3.19mix.exs
Hexash_sql~> 0.2 and >= 0.2.20mix.exs
Hexigniter~> 0.6 and >= 0.6.14mix.exs
All dependencies 57

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

RegistryPackageVersionRelation
Hexash3.29.3direct
Hexash_sql0.6.5direct
Hexecto3.14.0direct
Hexecto_libsql0.9.1direct
Hexecto_sql3.14.0direct
Hexecto_sqlite30.24.1direct
Hexigniter0.8.2direct
Hexjason1.4.5direct
Hexbunt1.0.0indirect
Hexcc_precompiler0.1.11indirect
Hexcredo1.7.19indirect
Hexcrux0.1.3indirect
Hexdb_connection2.10.1indirect
Hexdecimal3.1.1indirect
Hexdialyxir1.4.7indirect
Hexearmark_parser1.4.45indirect
Hexelixir_make0.10.0indirect
Hexerlex0.2.9indirect
Hexets0.9.0indirect
Hexex_ast0.12.5indirect
Hexex_check0.16.0indirect
Hexex_doc0.40.3indirect
Hexexqlite0.37.0indirect
Hexfile_system1.1.1indirect
Hexfinch0.23.0indirect
Hexgit_cli0.3.0indirect
Hexgit_ops2.10.0indirect
Hexglob_ex0.1.11indirect
Hexhpax1.0.3indirect
Hexiterex0.1.2indirect
Hexmakeup1.2.1indirect
Hexmakeup_elixir1.0.1indirect
Hexmakeup_erlang1.1.0indirect
Hexmime2.0.7indirect
Hexmint1.9.0indirect
Hexmix_audit2.1.5indirect
Hexmultigraph0.16.1-mg.4indirect
Hexnimble_options1.1.1indirect
Hexnimble_parsec1.4.2indirect
Hexnimble_pool1.1.0indirect
Hexowl0.13.1indirect
Hexreactor1.0.2indirect
Hexreq0.6.2indirect
Hexrewrite1.3.0indirect
Hexrustler_precompiled0.9.0indirect
Hexsimple_sat0.1.4indirect
Hexsobelow0.14.1indirect
Hexsourceror1.12.2indirect
Hexspark2.7.2indirect
Hexspitfire0.3.13indirect
Hexsplode0.3.1indirect
Hexstream_data1.3.0indirect
Hextelemetry1.4.2indirect
Hextext_diff0.1.0indirect
Hexyamerl0.10.0indirect
Hexyaml_elixir2.12.2indirect
Hexymlr5.1.5indirect
Dependency advisories 2

This repository publishes no package the index resolves, so its own dependency graph was assessed — 57 packages, which also include development and test pins that never ship: 2 carry known advisories, of which 0 are direct.

PackageVersionRelationSeverityAdvisoriesFixed in
hpax1.0.3indirecthigh11.0.4
mint1.9.0indirecthigh41.9.3

An advisory means the version recorded in the dependency graph falls inside an advisory’s affected range. Reachability is not analysed, and the graph includes development and test pins — a finding may concern tooling rather than shipped software.

Raw JSON report machine-readable
{
  "data": {
    "repo": {
      "topics": [
        "ash",
        "data-layer",
        "elixir",
        "sqlite"
      ],
      "is_fork": false,
      "size_kb": 645,
      "has_wiki": true,
      "homepage": "https://hexdocs.pm/ash_sqlite",
      "languages": {
        "Elixir": 423461
      },
      "pushed_at": "2026-07-01T14:41:08Z",
      "created_at": "2023-09-23T05:38:04Z",
      "owner_type": "Organization",
      "updated_at": "2026-07-06T10:15:47Z",
      "description": "The SQLite data layer for Ash Framework.",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": null,
      "default_branch": "main",
      "license_spdx_raw": null,
      "primary_language": "Elixir",
      "significant_languages": [
        "Elixir"
      ]
    },
    "owner": {
      "blog": "https://www.ash-hq.org/",
      "name": "Ash Framework",
      "type": "Organization",
      "login": "ash-project",
      "company": null,
      "location": null,
      "followers": 385,
      "avatar_url": "https://avatars.githubusercontent.com/u/58521182?v=4",
      "created_at": "2019-12-04T15:07:14Z",
      "is_verified": null,
      "public_repos": 61,
      "account_age_days": 2423
    },
    "license": {
      "state": "custom",
      "spdx_id": null,
      "raw_spdx": null,
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": false
    },
    "activity": {
      "releases": [
        {
          "tag": "v0.2.17",
          "kind": "patch",
          "published_at": "2026-04-22T21:04:12Z"
        },
        {
          "tag": "v0.2.16",
          "kind": "patch",
          "published_at": "2026-03-05T20:59:18Z"
        },
        {
          "tag": "v0.2.12",
          "kind": "patch",
          "published_at": "2025-07-22T15:23:21Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "95641ec8caaefb12874e4e5605646e51c8254c3b",
          "body": null,
          "is_bot": false,
          "headline": "chore: format",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-07-01T14:41:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b169740b04fc80f4f49cc285c153e915d03de73f",
          "body": "…215)\n\nBumps the production-dependencies group with 3 updates: [ash](https://github.com/ash-project/ash), [ash_sql](https://github.com/ash-project/ash_sql) and [igniter](https://github.com/ash-project/igniter).\n\n\nUpdates `ash` from 3.29.1 to 3.29.3\n- [Release notes](https://github.com/ash-project/as\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group with 3 updates (#…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2026-07-01T14:40:52Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "9a9e6002307ac4b3a9c988372b558ae228965566",
          "body": null,
          "is_bot": false,
          "headline": "chore: update deps",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-06-15T02:04:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6d041d45f1608e00b609aac47e1750e2f5e53838",
          "body": "…#212)\n\nlibSQL (github.com/tursodatabase/libsql) is an open-source fork of\nSQLite that adds ALTER COLUMN, native vector search (DiskANN), and\nembedded replicas while maintaining full backwards compatibility\nwith the SQLite file format and API.\n\nChanges:\n- verify_repo: accept Ecto.Adapters.LibSql alo\n[…]\nd against a production Ash application: 5877 tests, 5872\npassed, 5 failures unrelated to the adapter change (DBConnection\nownership race conditions).\n\nCo-authored-by: Zach Daniel <zach@zachdaniel.dev>",
          "is_bot": false,
          "headline": "improvement: Support ecto_libsql (libSQL) as an alternative adapter (…",
          "author_name": "Alan McCann",
          "author_login": "AlanMcCann",
          "committed_at": "2026-06-14T13:41:19Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "51b9ad20a3de30251b1e9a7f686864b33a6df040",
          "body": null,
          "is_bot": false,
          "headline": "chore: small cleanups",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-06-14T13:23:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3bac0277fc28a211e279fc020276154f80fa3d96",
          "body": "Generate scalar SQLite IN filters as compact IN clauses instead of left-deep OR trees, while keeping the existing OR fallback for complex RHS values.\n\nDump RHS values through the selected SQLite adapter so booleans, datetimes, decimals, UUIDs, and custom storage types keep the behavior the old equality path provided.",
          "is_bot": false,
          "headline": "improvement: Use SQLite IN for large scalar list filters (#214)",
          "author_name": "Will Townsend",
          "author_login": "wtsnz",
          "committed_at": "2026-06-14T13:03:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f018e3c5e22e2b63c4ce37ee69c97d2028c3988f",
          "body": null,
          "is_bot": false,
          "headline": "chore: fix ends_with tests",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-05-18T03:34:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b5573233bd3f243c81fbfd8941c79613a44728ac",
          "body": null,
          "is_bot": false,
          "headline": "chore: fix starts with tests",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-05-17T16:30:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ead6edb3578f2483aab60753705b407886463d58",
          "body": null,
          "is_bot": false,
          "headline": "chore: add tests for new string functions",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-05-03T21:45:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "68680b7255b353de22a0255785a6826c05af54e8",
          "body": null,
          "is_bot": false,
          "headline": "chore: add sqlite adapter to matrix",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-04-28T04:25:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "623aac9197f947a121cad0cb3e9f178970144332",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.17",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-04-22T20:54:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "11d683c6c10a4d0d5023993bbfd4a161bf8ff1ae",
          "body": "fixes #211",
          "is_bot": false,
          "headline": "fix: ensure atomic updates properly update all fields",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-04-22T20:53:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e19e084ed019d027cb8639488aa395b010ee5b01",
          "body": null,
          "is_bot": false,
          "headline": "docs: include transactions guide in generated docs (#210)",
          "author_name": "Nassim",
          "author_login": "a-nassim",
          "committed_at": "2026-04-09T14:32:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "606d1d3fcb97a780feaee7e7ca29c34ed4777e6e",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.16",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-03-05T20:54:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9f24fa0da37c3fb753e53d84d91c3f66cbdbf360",
          "body": "closes #209",
          "is_bot": false,
          "headline": "improvement: support positional name argument in `generate_migrations`",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-03-05T04:34:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a5f457e06c051d72eed3f9aa0c3cb3c6b4c57726",
          "body": "…geset context (#208)\n\nfix: bulk_create with upsert now updates update_timestamp fields\n\nPorts ash-project/ash_postgres#697 to ash_sqlite. update_timestamp\nattributes (e.g. updated_at) were never included in the ON CONFLICT\nDO UPDATE SET clause because they have writable?: false. Now fields\nwith update_defaults are always included when an upsert modifies\nfields. Can be disabled via context:\n%{data_layer: %{touch_update_defaults?: false}}",
          "is_bot": false,
          "headline": "improvement: read touch_update_defaults? from options instead of chan…",
          "author_name": "Michael Bärtschi",
          "author_login": "mbaertschi",
          "committed_at": "2026-03-02T21:47:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "21dd0b23c65655f52800d4f20928088615b55380",
          "body": "Ports ash-project/ash_postgres#697 to ash_sqlite. update_timestamp\nattributes (e.g. updated_at) were never included in the ON CONFLICT\nDO UPDATE SET clause because they have writable?: false. Now fields\nwith update_defaults are always included when an upsert modifies\nfields. Can be disabled via context:\n%{data_layer: %{touch_update_defaults?: false}}",
          "is_bot": false,
          "headline": "fix: bulk_create with upsert now updates update_timestamp fields (#207)",
          "author_name": "Michael Bärtschi",
          "author_login": "mbaertschi",
          "committed_at": "2026-02-25T13:46:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9d47357ab9b9e9cfac5fa647978d99d73b737f60",
          "body": "closes #84",
          "is_bot": false,
          "headline": "improvement: support `nils_distinct?` in identities",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-24T06:38:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "267cc405f40a70f6e0b969e02e3ac9adb9bc1c32",
          "body": " closes #85",
          "is_bot": false,
          "headline": "fix: Handle nil default values in migration generator",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-24T06:29:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cf33460fc07716dbad1dc67954b49155689dd8b1",
          "body": null,
          "is_bot": false,
          "headline": "chore: better functional repo support, add guide",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-24T06:27:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9052dc881fdfffd51e04dc240b5f1e457695c4cf",
          "body": null,
          "is_bot": false,
          "headline": "chore: allow repo to be a function that returns a module",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-24T06:21:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e9ec32e4f7a6ab8f4076c33c3f0e0bdf0c26b336",
          "body": "fixes #178",
          "is_bot": false,
          "headline": "fix: don't double count renaming & adding attributes",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-23T17:56:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "38b1b1494397705cd77863a12b7f91674639745b",
          "body": "Bumps the dev-dependencies group with 3 updates: [credo](https://github.com/rrrene/credo), [dialyxir](https://github.com/jeremyjh/dialyxir) and [ex_doc](https://github.com/elixir-lang/ex_doc).\n\n\nUpdates `credo` from 1.7.13 to 1.7.16\n- [Release notes](https://github.com/rrrene/credo/releases)\n- [Chan\n[…]\non-update:semver-minor\n  dependency-group: dev-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps-dev): bump the dev-dependencies group with 3 updates (#205)",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2026-02-23T17:34:54Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "e3cda19466c00bc49d6edf83d75f4328bfc390c6",
          "body": null,
          "is_bot": false,
          "headline": "chore: SPDX contributor links (#204)",
          "author_name": "Leon Qadirie",
          "author_login": "leonqadirie",
          "committed_at": "2026-02-12T05:37:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b7ac87f77062c077179105e361970583f8f4b6e3",
          "body": null,
          "is_bot": false,
          "headline": "chore: reuse",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-12T05:36:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "512663e13e83e4b7d288e721fda12b88840d8eb4",
          "body": null,
          "is_bot": false,
          "headline": "chore: remove unnecessary migration",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-12T05:26:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4c280c873c67672c189698e3befb71c959c4af7b",
          "body": null,
          "is_bot": false,
          "headline": "chore: make migraiton tests faster",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-12T05:20:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "428dd2209af90d21d313ffa79edda1ef9e1b5d42",
          "body": null,
          "is_bot": false,
          "headline": "chore: codegen & fix preferred_envs",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-12T05:04:34Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7145b58b9542c201733e5dcdd531b1ae116429c7",
          "body": null,
          "is_bot": false,
          "headline": "chore: format",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-12T04:49:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "10a6d2967c305caf7b5f69bd01c466c07e7f6605",
          "body": null,
          "is_bot": false,
          "headline": "chore: credo, update deps",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-02-12T04:49:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0b8751f86d3883f5e471b64aca73f54a22b7fc33",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.15",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-01-30T03:28:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fbcd9785f0665510470078d30d8b2a8cc4ae4c58",
          "body": "fixes #201",
          "is_bot": false,
          "headline": "fix: handle map comparisons via json encoding.",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-01-30T03:24:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "338cf24e9857acebfca76e94a61e83a0beb7cde8",
          "body": null,
          "is_bot": false,
          "headline": "chore: reproduce issue about timestamp updates w/ map comparisons",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-01-29T04:13:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7012bca163c26e3f5764dc8dc14227aa905737d7",
          "body": "fixes #202",
          "is_bot": false,
          "headline": "fix: use custom string_length implementation for SQLite",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2026-01-29T03:58:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ccf0a24f43c75e3827554f6755701d4e3b840307",
          "body": null,
          "is_bot": false,
          "headline": "fix: only migrate/rollback one repo at a time (#199)",
          "author_name": "ydo-kollins",
          "author_login": "ydo-kollins",
          "committed_at": "2026-01-15T01:58:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cf87e624b2ecaa708af7b8fefd8dd48a340981c1",
          "body": "Co-authored-by: spicychickensauce <spicychickensauce@nope.com>",
          "is_bot": false,
          "headline": "fix: missing case in to_ecto (#198)",
          "author_name": "spicychickensauce",
          "author_login": "spicychickensauce",
          "committed_at": "2026-01-04T10:42:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b4742319cb39e714ea0b0770c2de66c498db37ce",
          "body": "…y with 3 updates (#197)\n\nBumps the production-dependencies group with 2 updates in the / directory: [ash](https://github.com/ash-project/ash) and [ash_sql](https://github.com/ash-project/ash_sql).\n\n\nUpdates `ash` from 3.9.0 to 3.11.3\n- [Release notes](https://github.com/ash-project/ash/releases)\n- \n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group across 1 director…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2026-01-01T20:59:17Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "d2e25aa28652e294dfd49c2d8057a447da0950ab",
          "body": "fixes #195",
          "is_bot": false,
          "headline": "fix: ensure we always clean dev migrations",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-12-24T07:01:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ccdc18861a8e32b15bff9589dffcbf1867c6857a",
          "body": "…SQLite migrations\n\nfixes #196",
          "is_bot": false,
          "headline": "improvement: raise clearer error on unsupported foreign key drops in …",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-12-24T06:50:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "78bd8d1433737fd4bcc05da511a411b313128f92",
          "body": null,
          "is_bot": false,
          "headline": "improvement: update to use bulk refs from latest ash",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-11-09T18:04:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ee96c61d3a34e312735ffc140af4a14baee3a1a0",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.14",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-11-05T00:40:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "05aa3a056eed11838bbfc02d5df1a41f7860b40b",
          "body": "Bumps the dev-dependencies group with 2 updates: [credo](https://github.com/rrrene/credo) and [ex_doc](https://github.com/elixir-lang/ex_doc).\n\n\nUpdates `credo` from 1.7.12 to 1.7.13\n- [Release notes](https://github.com/rrrene/credo/releases)\n- [Changelog](https://github.com/rrrene/credo/blob/master\n[…]\non-update:semver-minor\n  dependency-group: dev-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps-dev): bump the dev-dependencies group with 2 updates (#190)",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-11-02T04:28:16Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "799ed09ddd4752a175102d0cab0b6ac28ba14130",
          "body": "…191)\n\nBumps the production-dependencies group with 3 updates: [ash](https://github.com/ash-project/ash), [ash_sql](https://github.com/ash-project/ash_sql) and [ecto](https://github.com/elixir-ecto/ecto).\n\n\nUpdates `ash` from 3.7.0 to 3.7.6\n- [Release notes](https://github.com/ash-project/ash/releas\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group with 3 updates (#…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-11-02T02:46:49Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "1ef76ac5647c14aa2235687f3976745c2488b1fe",
          "body": null,
          "is_bot": false,
          "headline": "fix: Get rid of deprecation warnings (#188)",
          "author_name": "Jonatan Männchen",
          "author_login": "maennchen",
          "committed_at": "2025-10-16T00:48:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6eb6fafd6f12e193d94a1d849db0a853bafd1483",
          "body": "Bumps the production-dependencies group with 1 update: [ash_sql](https://github.com/ash-project/ash_sql).\n\n\nUpdates `ash_sql` from 0.3.2 to 0.3.4\n- [Release notes](https://github.com/ash-project/ash_sql/releases)\n- [Changelog](https://github.com/ash-project/ash_sql/blob/main/CHANGELOG.md)\n- [Commits\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump ash_sql in the production-dependencies group (#187)",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-10-14T20:59:35Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "ae152b4b1f575726be302a7f92361b49a7b3f950",
          "body": "Bumps the dev-dependencies group with 1 update: [sobelow](https://github.com/sobelow/sobelow).\n\n\nUpdates `sobelow` from 0.14.0 to 0.14.1\n- [Release notes](https://github.com/sobelow/sobelow/releases)\n- [Changelog](https://github.com/sobelow/sobelow/blob/main/CHANGELOG.md)\n- [Commits](https://github.\n[…]\non-update:semver-patch\n  dependency-group: dev-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps-dev): bump sobelow in the dev-dependencies group (#186)",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-10-14T20:59:20Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "e792c8d4417388c51e0b3f0aa6c5bf7ce201824f",
          "body": null,
          "is_bot": false,
          "headline": "chore: Fix REUSE copyright attributions",
          "author_name": "James Harton",
          "author_login": "jimsynz",
          "committed_at": "2025-10-14T19:40:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "27feaa72d19e6a82748205fd6cc4cbf0cd6fd047",
          "body": "…185)\n\nBumps the production-dependencies group with 2 updates: [ash](https://github.com/ash-project/ash) and [ash_sql](https://github.com/ash-project/ash_sql).\n\n\nUpdates `ash` from 3.5.43 to 3.6.2\n- [Release notes](https://github.com/ash-project/ash/releases)\n- [Changelog](https://github.com/ash-pro\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group with 2 updates (#…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-10-13T02:19:36Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "493b9fac792b0f8e984f134023f7c0dcb14cbb9b",
          "body": "* chore: Fix Spark warnings\n\n* chore: REUSE compliance",
          "is_bot": false,
          "headline": "chore: REUSE compliance (#184)",
          "author_name": "James Harton",
          "author_login": "jimsynz",
          "committed_at": "2025-10-12T20:55:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8985a44c8a67f84c9c4edfce8654b715f3cc9954",
          "body": "Bumps the dev-dependencies group with 1 update: [ex_doc](https://github.com/elixir-lang/ex_doc).\n\n\nUpdates `ex_doc` from 0.38.3 to 0.38.4\n- [Release notes](https://github.com/elixir-lang/ex_doc/releases)\n- [Changelog](https://github.com/elixir-lang/ex_doc/blob/main/CHANGELOG.md)\n- [Commits](https://\n[…]\non-update:semver-patch\n  dependency-group: dev-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps-dev): bump ex_doc in the dev-dependencies group (#182)",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-10-02T03:33:51Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "c103ef6db355671d645cbb9e977287f1063f1c9f",
          "body": "…183)\n\nBumps the production-dependencies group with 5 updates:\n\n| Package | From | To |\n| --- | --- | --- |\n| [ash](https://github.com/ash-project/ash) | `3.5.37` | `3.5.43` |\n| [ash_sql](https://github.com/ash-project/ash_sql) | `0.2.92` | `0.3.0` |\n| [ecto](https://github.com/elixir-ecto/ecto) | `\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group with 5 updates (#…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-10-02T03:20:13Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "e9bc07cb27113224acb0ae4a3f72e23a57e91217",
          "body": "Co-authored-by: Abdessabour Moutik <abdessabour+git@moutik.me>",
          "is_bot": false,
          "headline": "fix: ignore unkown option in generate_migrations task #180 (#181)",
          "author_name": "Abdessabour Moutik",
          "author_login": "moutikabdessabour",
          "committed_at": "2025-09-19T17:46:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "00c62287998740d5a7657ea57c96b9198f3ea7ab",
          "body": "…y with 2 updates (#177)\n\nBumps the production-dependencies group with 2 updates in the / directory: [ash](https://github.com/ash-project/ash) and [ash_sql](https://github.com/ash-project/ash_sql).\n\n\nUpdates `ash` from 3.5.31 to 3.5.37\n- [Release notes](https://github.com/ash-project/ash/releases)\n-\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group across 1 director…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-09-02T01:37:13Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "e85f20abec078f517869639a02af6ff0c2a253a7",
          "body": "Bumps the dev-dependencies group with 3 updates: [dialyxir](https://github.com/jeremyjh/dialyxir), [ex_doc](https://github.com/elixir-lang/ex_doc) and [git_ops](https://github.com/zachdaniel/git_ops).\n\n\nUpdates `dialyxir` from 1.4.5 to 1.4.6\n- [Release notes](https://github.com/jeremyjh/dialyxir/rel\n[…]\non-update:semver-minor\n  dependency-group: dev-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps-dev): bump the dev-dependencies group with 3 updates (#176)",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-09-01T14:36:28Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "dcf69f5877fc15de3762ac1aaafebb17a28eb8f6",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.13",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-08-31T15:40:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f0efda6584fabcd8cc55dcd42f6911a0133560c2",
          "body": "This issue was due to `get_existing_snapshot` ignoring dev migrations\nbecause they don't comform to `{timestamp.json}`.\n\nI fixed by making it closer to its postgres counterpart: not trying to\nparse the timestamp and instead comparing the filenames, which\nworks the same until timestamps change their numbers of digits.\n\n\nI'll think about how to introduce some reuse, because postgres has the\nsame feature except its getting more love.",
          "is_bot": false,
          "headline": "fix: generate_migrations --dev duplicating migration files (#173)",
          "author_name": "Georges Dubus",
          "author_login": "madjar",
          "committed_at": "2025-08-28T14:46:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3f6044d1586cf82f4f94871c6516e8935fce56b8",
          "body": "fixes #172",
          "is_bot": false,
          "headline": "fix: override default implementation of string trim test",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-08-23T14:13:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f0d05a5a9e68e4259f926bc216378a94894fd92c",
          "body": "…170)\n\nBumps the production-dependencies group with 3 updates: [ash](https://github.com/ash-project/ash), [ash_sql](https://github.com/ash-project/ash_sql) and [igniter](https://github.com/ash-project/igniter).\n\n\nUpdates `ash` from 3.5.27 to 3.5.31\n- [Release notes](https://github.com/ash-project/as\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group with 3 updates (#…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-07-22T19:17:36Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "32760ec66f199e3a193fa45f8447720ea0c27488",
          "body": null,
          "is_bot": false,
          "headline": "Update dependabot schedule to monthly",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-07-22T19:09:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b6c7edc3c8fc654fee3b8019617834aa3d867c5b",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.12",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-07-22T15:05:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b13aa266d798789554df28afcb587d99fe62045f",
          "body": null,
          "is_bot": false,
          "headline": "chore: update deps",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-07-17T14:44:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0fb95dedab3851b8e7bd40b2c97542196a963a09",
          "body": null,
          "is_bot": false,
          "headline": "chore: fix rollback behavior",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-07-14T17:47:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "511d4750c1714fec223ae37cb33484b62be27cf5",
          "body": null,
          "is_bot": false,
          "headline": "chore: remove Logger.debug",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-07-14T02:32:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6b3c2c89fa8c1c9f81e51721a142383d84b3b05c",
          "body": null,
          "is_bot": false,
          "headline": "improvement: make rollback more reliable by using `--to` instead of `-n`",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-07-14T02:27:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0ea1b2cd2c341dc0a203c69f1d6213e6dcfbe642",
          "body": "…168)\n\nBumps the production-dependencies group with 2 updates: [ash](https://github.com/ash-project/ash) and [ash_sql](https://github.com/ash-project/ash_sql).\n\n\nUpdates `ash` from 3.5.25 to 3.5.26\n- [Release notes](https://github.com/ash-project/ash/releases)\n- [Changelog](https://github.com/ash-pr\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group with 2 updates (#…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-07-10T15:06:11Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "b5b08a59d1d9cba830cb5edf2f07728ddf71539b",
          "body": null,
          "is_bot": false,
          "headline": "chore: update igniter",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-07-09T21:45:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0965f111ef4fdda1671db8b4f736007bb6663aff",
          "body": null,
          "is_bot": false,
          "headline": "fix: Reverse migrations order when reverting dev migrations (#167)",
          "author_name": "Kenneth Kostrešević",
          "author_login": "ken-kost",
          "committed_at": "2025-07-09T21:36:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6af483df7acdfdd27a53d9120498937ad0751313",
          "body": "…166)\n\nBumps the production-dependencies group with 3 updates: [ash](https://github.com/ash-project/ash), [ash_sql](https://github.com/ash-project/ash_sql) and [igniter](https://github.com/ash-project/igniter).\n\n\nUpdates `ash` from 3.5.24 to 3.5.25\n- [Release notes](https://github.com/ash-project/as\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group with 3 updates (#…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-07-03T12:46:31Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "efd9ce3fb29c583e9cfb8318413007c1b5a9af20",
          "body": "…165)\n\nBumps the production-dependencies group with 6 updates:\n\n| Package | From | To |\n| --- | --- | --- |\n| [ash](https://github.com/ash-project/ash) | `3.5.22` | `3.5.24` |\n| [ash_sql](https://github.com/ash-project/ash_sql) | `0.2.82` | `0.2.83` |\n| [ecto](https://github.com/elixir-ecto/ecto) | \n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group with 6 updates (#…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-06-26T09:19:32Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "19177dda7c25470cceefeea289a97037a82ce953",
          "body": "Bumps the production-dependencies group with 1 update: [ash](https://github.com/ash-project/ash).\n\n\nUpdates `ash` from 3.5.21 to 3.5.22\n- [Changelog](https://github.com/ash-project/ash/blob/main/CHANGELOG.md)\n- [Commits](https://github.com/ash-project/ash/compare/v3.5.21...v3.5.22)\n\n---\nupdated-depe\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump ash in the production-dependencies group (#164)",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-06-19T12:10:52Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "c83479e5599b143320e424c71d00d0c0571b51ab",
          "body": null,
          "is_bot": false,
          "headline": "fix: update ecto & ecto_sql",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-06-19T00:16:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e1de10efcafae6618c405fdd46cca26e10128f7c",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.11",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-06-16T01:40:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0181b7879ac4fe5916cda73d7ea1550374147917",
          "body": null,
          "is_bot": false,
          "headline": "improvement: support update_query and destroy_query",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-06-16T01:40:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "467406b96e06d41bc056c609aa66e025894233de",
          "body": null,
          "is_bot": false,
          "headline": "chore: docs typo",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-06-15T22:12:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cb8b293d698eca5482a38e9b4aae5842e67ee530",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.10",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-06-15T22:11:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2a7c0266ddc1c37dba93f6db6e17208735cdbc0c",
          "body": null,
          "is_bot": false,
          "headline": "chore: dialyzer",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-06-15T22:11:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "203e4c25c405740cce888129b71ec9a479f22a17",
          "body": "this also adopts the bulk of the required work to support proper update\nquery & destroy query callbacks, but that will be introduced in a\nfollow-up minor release because it will break people's applications\n\nfixes #163",
          "is_bot": false,
          "headline": "fix: properly apply filters on destroy & update",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-06-15T22:08:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "81379cf0f907ed02e22957effdb5d007a1adfbbf",
          "body": "Bumps the dev-dependencies group with 2 updates: [git_ops](https://github.com/zachdaniel/git_ops) and [mix_audit](https://github.com/mirego/mix_audit).\n\n\nUpdates `git_ops` from 2.7.3 to 2.8.0\n- [Changelog](https://github.com/zachdaniel/git_ops/blob/master/CHANGELOG.md)\n- [Commits](https://github.com\n[…]\non-update:semver-patch\n  dependency-group: dev-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps-dev): bump the dev-dependencies group with 2 updates (#162)",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-06-12T12:25:43Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "0fe59665b4feedbfe1354be387b64fa2b33d2866",
          "body": "…161)\n\nBumps the production-dependencies group with 4 updates: [ash](https://github.com/ash-project/ash), [ash_sql](https://github.com/ash-project/ash_sql), [ecto](https://github.com/elixir-ecto/ecto) and [igniter](https://github.com/ash-project/igniter).\n\n\nUpdates `ash` from 3.5.15 to 3.5.18\n- [Cha\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group with 4 updates (#…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-06-12T12:25:17Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "2743a07d7c72007537983454abbb804db1a90f3e",
          "body": "…l files and fix the iex testing commands (#160)",
          "is_bot": false,
          "headline": "docs: Update ash_sqlite starting guide to clarify modifications in al…",
          "author_name": "Sebastian Weiß",
          "author_login": "bastiW",
          "committed_at": "2025-06-07T19:37:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "676c9155a88ca50d95e27e79c77347e45a452527",
          "body": null,
          "is_bot": false,
          "headline": "chore: cleanup community files",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-06-05T12:12:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2f7d04b4bcf6d1b2dff494a2966cee44fc616b50",
          "body": "…159)\n\nBumps the production-dependencies group with 3 updates: [ash](https://github.com/ash-project/ash), [ash_sql](https://github.com/ash-project/ash_sql) and [igniter](https://github.com/ash-project/igniter).\n\n\nUpdates `ash` from 3.5.13 to 3.5.15\n- [Changelog](https://github.com/ash-project/ash/bl\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump the production-dependencies group with 3 updates (#…",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-06-05T12:10:34Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "7cc0788c14eb1c3ae0f0cabc23166866fe762dbc",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.9",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-30T19:50:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4400623f9c5dac8f8a1eb410642c30a89979cb48",
          "body": null,
          "is_bot": false,
          "headline": "chore: update deps",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-30T19:50:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ee66386f8ed4c2af5b4560e16ab1bd71fed5aa98",
          "body": null,
          "is_bot": false,
          "headline": "chore: update formatter",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-30T16:45:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f256da6e0837569d12850b59bc9ded889083283c",
          "body": "Add option in the DSL to generate [strict table](https://www.sqlite.org/stricttables.html),\nwhich enforces types more strictly (default is false).\n\nEcto already supports custom options that will be appended after the generated create table statement\nhttps://hexdocs.pm/ecto_sql/Ecto.Migration.html#table/2-options",
          "is_bot": false,
          "headline": "improvement: strict table support (#157)",
          "author_name": "Nassim",
          "author_login": "a-nassim",
          "committed_at": "2025-05-30T16:44:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "39f507b17c8423c77bd02a18601a2a2c40361afe",
          "body": null,
          "is_bot": false,
          "headline": "chore: better dev migration error",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-30T05:34:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "627d7c56e2087fb54ba421e756f8ae2cb82ac1ef",
          "body": null,
          "is_bot": false,
          "headline": "improvement: support new PendingCodegen error",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-30T05:18:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d63453c4c12162438735fbe8be500f06c43b8499",
          "body": null,
          "is_bot": false,
          "headline": "chore: update elixir tool version",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-29T15:26:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "022645723f0ba86f17783d958923d0913c1b753f",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.8",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-29T15:22:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c8038235922d74191aed443b15ecccc116723187",
          "body": null,
          "is_bot": false,
          "headline": "fix: properly fetch options in installer",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-29T15:22:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e72ce6410ed307c463a974c4886a180253ace39c",
          "body": "Bumps the dev-dependencies group with 2 updates: [ex_doc](https://github.com/elixir-lang/ex_doc) and [git_ops](https://github.com/zachdaniel/git_ops).\n\n\nUpdates `ex_doc` from 0.38.1 to 0.38.2\n- [Release notes](https://github.com/elixir-lang/ex_doc/releases)\n- [Changelog](https://github.com/elixir-la\n[…]\non-update:semver-patch\n  dependency-group: dev-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps-dev): bump the dev-dependencies group with 2 updates (#156)",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-05-29T14:28:16Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "2096e8281947bab8062ced92f6f300792410c11d",
          "body": "Bumps the production-dependencies group with 1 update: [igniter](https://github.com/ash-project/igniter).\n\n\nUpdates `igniter` from 0.6.2 to 0.6.3\n- [Changelog](https://github.com/ash-project/igniter/blob/main/CHANGELOG.md)\n- [Commits](https://github.com/ash-project/igniter/compare/v0.6.2...v0.6.3)\n\n\n[…]\nte:semver-patch\n  dependency-group: production-dependencies\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(deps): bump igniter in the production-dependencies group (#155)",
          "author_name": "dependabot[bot]",
          "author_login": "dependabot[bot]",
          "committed_at": "2025-05-29T14:28:04Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "de033bb521cee4a128c10f432e071fd6c32a2ee1",
          "body": null,
          "is_bot": false,
          "headline": "chore: fixes for dev migrations feature",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-28T03:14:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a555bdc03a82a4f014206212fcd6539d09556c00",
          "body": null,
          "is_bot": false,
          "headline": "chore: add to gitignore",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-28T03:05:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "feca190adf0da97415bdc642ddeb026528787c0f",
          "body": null,
          "is_bot": false,
          "headline": "improvement: --dev codegen flag (#154)",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-27T02:14:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1ce17b864e9aaca82cf9397838dc07ac2dbb07fe",
          "body": null,
          "is_bot": false,
          "headline": "chore: release version v0.2.7",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-26T20:26:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e9a535b4e7e01aeb6a72b39bcf5b2d811c122545",
          "body": "fixes #153",
          "is_bot": false,
          "headline": "fix: various fixes around parameterized type data shape change",
          "author_name": "Zach Daniel",
          "author_login": "zachdaniel",
          "committed_at": "2025-05-26T02:24:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "918ce9bce7d4d3fc420b45fd174faa866846651e",
          "body": null,
          "is_bot": false,
          "headline": "improvement: Fix igniter deprecation warning. (#152)",
          "author_name": "James Harton",
          "author_login": "jimsynz",
          "committed_at": "2025-05-25T20:23:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "55c808b4840c5ebdac716f519f4776fbb725a2e3",
          "body": null,
          "is_bot": false,
          "headline": "fix: Remove unused `:inflex` dependency",
          "author_name": "Rebecca Le",
          "author_login": "sevenseacat",
          "committed_at": "2025-05-24T15:00:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 3,
      "commits_last_year": 57,
      "latest_release_at": "2026-04-22T21:04:12Z",
      "latest_release_tag": "v0.2.17",
      "releases_from_tags": false,
      "days_since_last_push": 22,
      "active_weeks_last_year": 23,
      "days_since_latest_release": 92,
      "mean_days_between_releases": 137.1
    },
    "community": {
      "has_readme": true,
      "has_license": false,
      "has_description": true,
      "has_contributing": true,
      "health_percentage": 87,
      "has_issue_template": false,
      "has_code_of_conduct": true,
      "has_pull_request_template": true
    },
    "ecosystem": {
      "packages": [
        {
          "name": "ash_sqlite",
          "exists": true,
          "license": "MIT",
          "keywords": [],
          "ecosystem": "hex",
          "matches_repo": true,
          "registry_url": "https://hex.pm/packages/ash_sqlite",
          "is_deprecated": false,
          "latest_version": "0.2.17",
          "repository_url": "https://github.com/ash-project/ash_sqlite/blob/main/CHANGELOG.md",
          "versions_count": 24,
          "total_downloads": 31399,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": 2128,
          "first_published_at": "2023-10-12T00:25:01.064693Z",
          "latest_published_at": "2026-04-22T21:04:33.266055Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 92
        }
      ]
    },
    "popularity": {
      "forks": 30,
      "stars": 30,
      "watchers": 4,
      "fork_history": {
        "days": [
          {
            "date": "2023-10-26",
            "count": 1
          },
          {
            "date": "2023-11-10",
            "count": 1
          },
          {
            "date": "2024-04-02",
            "count": 1
          },
          {
            "date": "2024-04-05",
            "count": 1
          },
          {
            "date": "2024-04-27",
            "count": 1
          },
          {
            "date": "2024-05-08",
            "count": 1
          },
          {
            "date": "2024-05-24",
            "count": 1
          },
          {
            "date": "2024-06-21",
            "count": 1
          },
          {
            "date": "2024-07-16",
            "count": 1
          },
          {
            "date": "2025-01-04",
            "count": 1
          },
          {
            "date": "2025-01-20",
            "count": 1
          },
          {
            "date": "2025-02-05",
            "count": 1
          },
          {
            "date": "2025-03-05",
            "count": 1
          },
          {
            "date": "2025-04-04",
            "count": 1
          },
          {
            "date": "2025-04-08",
            "count": 1
          },
          {
            "date": "2025-05-29",
            "count": 1
          },
          {
            "date": "2025-06-07",
            "count": 1
          },
          {
            "date": "2025-08-26",
            "count": 1
          },
          {
            "date": "2025-08-29",
            "count": 1
          },
          {
            "date": "2025-09-19",
            "count": 1
          },
          {
            "date": "2025-10-15",
            "count": 1
          },
          {
            "date": "2025-10-31",
            "count": 1
          },
          {
            "date": "2026-01-03",
            "count": 1
          },
          {
            "date": "2026-01-14",
            "count": 1
          },
          {
            "date": "2026-02-01",
            "count": 1
          },
          {
            "date": "2026-02-25",
            "count": 1
          },
          {
            "date": "2026-04-08",
            "count": 1
          },
          {
            "date": "2026-04-27",
            "count": 1
          },
          {
            "date": "2026-05-19",
            "count": 1
          },
          {
            "date": "2026-06-26",
            "count": 1
          }
        ],
        "complete": true,
        "collected": 30,
        "total_forks": 30
      },
      "star_history": null,
      "open_issues_and_prs": 0
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [],
      "has_llms_txt": false,
      "has_dockerfile": false,
      "has_mcp_signal": false,
      "bootstrap_files": [],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [],
      "toolchain_manifests": [
        "mix.exs"
      ],
      "largest_source_bytes": 77094,
      "source_files_sampled": 87,
      "oversized_source_files": 2,
      "agent_instruction_files": [],
      "agent_instruction_max_bytes": null
    },
    "dependencies": {
      "manifests": [
        "mix.exs"
      ],
      "advisories": {
        "error": null,
        "scope": "repository_graph",
        "source": "osv",
        "findings": [
          {
            "name": "hpax",
            "direct": false,
            "version": "1.0.3",
            "severity": "high",
            "ecosystem": "hex",
            "cvss_score": 7.5,
            "advisory_ids": [
              "EEF-CVE-2026-58226"
            ],
            "fixed_version": "1.0.4",
            "advisory_count": 1,
            "oldest_advisory_days": 17
          },
          {
            "name": "mint",
            "direct": false,
            "version": "1.9.0",
            "severity": "high",
            "ecosystem": "hex",
            "cvss_score": 7.5,
            "advisory_ids": [
              "EEF-CVE-2026-56810",
              "EEF-CVE-2026-58229",
              "EEF-CVE-2026-59246",
              "EEF-CVE-2026-59249"
            ],
            "fixed_version": "1.9.3",
            "advisory_count": 4,
            "oldest_advisory_days": 17
          }
        ],
        "collected": true,
        "malicious": [],
        "truncated": false,
        "by_severity": {
          "high": 2
        },
        "advisory_count": 5,
        "affected_count": 2,
        "assessed_count": 57,
        "malicious_count": 0,
        "assessed_package": null,
        "unassessed_count": 0,
        "direct_affected_count": 0
      },
      "ecosystems": [
        "hex"
      ],
      "dependencies": [
        {
          "name": "ecto_sql",
          "manifest": "mix.exs",
          "ecosystem": "hex",
          "version_constraint": "~> 3.13"
        },
        {
          "name": "ecto_sqlite3",
          "manifest": "mix.exs",
          "ecosystem": "hex",
          "version_constraint": "~> 0.12"
        },
        {
          "name": "ecto_libsql",
          "manifest": "mix.exs",
          "ecosystem": "hex",
          "version_constraint": "~> 0.9"
        },
        {
          "name": "ecto",
          "manifest": "mix.exs",
          "ecosystem": "hex",
          "version_constraint": "~> 3.13"
        },
        {
          "name": "jason",
          "manifest": "mix.exs",
          "ecosystem": "hex",
          "version_constraint": "~> 1.0"
        },
        {
          "name": "ash",
          "manifest": "mix.exs",
          "ecosystem": "hex",
          "version_constraint": "~> 3.19"
        },
        {
          "name": "ash_sql",
          "manifest": "mix.exs",
          "ecosystem": "hex",
          "version_constraint": "~> 0.2 and >= 0.2.20"
        },
        {
          "name": "igniter",
          "manifest": "mix.exs",
          "ecosystem": "hex",
          "version_constraint": "~> 0.6 and >= 0.6.14"
        }
      ],
      "all_dependencies": {
        "error": null,
        "source": "github-sbom",
        "packages": [
          {
            "name": "ash",
            "direct": true,
            "version": "3.29.3",
            "ecosystem": "hex"
          },
          {
            "name": "ash_sql",
            "direct": true,
            "version": "0.6.5",
            "ecosystem": "hex"
          },
          {
            "name": "ecto",
            "direct": true,
            "version": "3.14.0",
            "ecosystem": "hex"
          },
          {
            "name": "ecto_libsql",
            "direct": true,
            "version": "0.9.1",
            "ecosystem": "hex"
          },
          {
            "name": "ecto_sql",
            "direct": true,
            "version": "3.14.0",
            "ecosystem": "hex"
          },
          {
            "name": "ecto_sqlite3",
            "direct": true,
            "version": "0.24.1",
            "ecosystem": "hex"
          },
          {
            "name": "igniter",
            "direct": true,
            "version": "0.8.2",
            "ecosystem": "hex"
          },
          {
            "name": "jason",
            "direct": true,
            "version": "1.4.5",
            "ecosystem": "hex"
          },
          {
            "name": "bunt",
            "direct": false,
            "version": "1.0.0",
            "ecosystem": "hex"
          },
          {
            "name": "cc_precompiler",
            "direct": false,
            "version": "0.1.11",
            "ecosystem": "hex"
          },
          {
            "name": "credo",
            "direct": false,
            "version": "1.7.19",
            "ecosystem": "hex"
          },
          {
            "name": "crux",
            "direct": false,
            "version": "0.1.3",
            "ecosystem": "hex"
          },
          {
            "name": "db_connection",
            "direct": false,
            "version": "2.10.1",
            "ecosystem": "hex"
          },
          {
            "name": "decimal",
            "direct": false,
            "version": "3.1.1",
            "ecosystem": "hex"
          },
          {
            "name": "dialyxir",
            "direct": false,
            "version": "1.4.7",
            "ecosystem": "hex"
          },
          {
            "name": "earmark_parser",
            "direct": false,
            "version": "1.4.45",
            "ecosystem": "hex"
          },
          {
            "name": "elixir_make",
            "direct": false,
            "version": "0.10.0",
            "ecosystem": "hex"
          },
          {
            "name": "erlex",
            "direct": false,
            "version": "0.2.9",
            "ecosystem": "hex"
          },
          {
            "name": "ets",
            "direct": false,
            "version": "0.9.0",
            "ecosystem": "hex"
          },
          {
            "name": "ex_ast",
            "direct": false,
            "version": "0.12.5",
            "ecosystem": "hex"
          },
          {
            "name": "ex_check",
            "direct": false,
            "version": "0.16.0",
            "ecosystem": "hex"
          },
          {
            "name": "ex_doc",
            "direct": false,
            "version": "0.40.3",
            "ecosystem": "hex"
          },
          {
            "name": "exqlite",
            "direct": false,
            "version": "0.37.0",
            "ecosystem": "hex"
          },
          {
            "name": "file_system",
            "direct": false,
            "version": "1.1.1",
            "ecosystem": "hex"
          },
          {
            "name": "finch",
            "direct": false,
            "version": "0.23.0",
            "ecosystem": "hex"
          },
          {
            "name": "git_cli",
            "direct": false,
            "version": "0.3.0",
            "ecosystem": "hex"
          },
          {
            "name": "git_ops",
            "direct": false,
            "version": "2.10.0",
            "ecosystem": "hex"
          },
          {
            "name": "glob_ex",
            "direct": false,
            "version": "0.1.11",
            "ecosystem": "hex"
          },
          {
            "name": "hpax",
            "direct": false,
            "version": "1.0.3",
            "ecosystem": "hex"
          },
          {
            "name": "iterex",
            "direct": false,
            "version": "0.1.2",
            "ecosystem": "hex"
          },
          {
            "name": "makeup",
            "direct": false,
            "version": "1.2.1",
            "ecosystem": "hex"
          },
          {
            "name": "makeup_elixir",
            "direct": false,
            "version": "1.0.1",
            "ecosystem": "hex"
          },
          {
            "name": "makeup_erlang",
            "direct": false,
            "version": "1.1.0",
            "ecosystem": "hex"
          },
          {
            "name": "mime",
            "direct": false,
            "version": "2.0.7",
            "ecosystem": "hex"
          },
          {
            "name": "mint",
            "direct": false,
            "version": "1.9.0",
            "ecosystem": "hex"
          },
          {
            "name": "mix_audit",
            "direct": false,
            "version": "2.1.5",
            "ecosystem": "hex"
          },
          {
            "name": "multigraph",
            "direct": false,
            "version": "0.16.1-mg.4",
            "ecosystem": "hex"
          },
          {
            "name": "nimble_options",
            "direct": false,
            "version": "1.1.1",
            "ecosystem": "hex"
          },
          {
            "name": "nimble_parsec",
            "direct": false,
            "version": "1.4.2",
            "ecosystem": "hex"
          },
          {
            "name": "nimble_pool",
            "direct": false,
            "version": "1.1.0",
            "ecosystem": "hex"
          },
          {
            "name": "owl",
            "direct": false,
            "version": "0.13.1",
            "ecosystem": "hex"
          },
          {
            "name": "reactor",
            "direct": false,
            "version": "1.0.2",
            "ecosystem": "hex"
          },
          {
            "name": "req",
            "direct": false,
            "version": "0.6.2",
            "ecosystem": "hex"
          },
          {
            "name": "rewrite",
            "direct": false,
            "version": "1.3.0",
            "ecosystem": "hex"
          },
          {
            "name": "rustler_precompiled",
            "direct": false,
            "version": "0.9.0",
            "ecosystem": "hex"
          },
          {
            "name": "simple_sat",
            "direct": false,
            "version": "0.1.4",
            "ecosystem": "hex"
          },
          {
            "name": "sobelow",
            "direct": false,
            "version": "0.14.1",
            "ecosystem": "hex"
          },
          {
            "name": "sourceror",
            "direct": false,
            "version": "1.12.2",
            "ecosystem": "hex"
          },
          {
            "name": "spark",
            "direct": false,
            "version": "2.7.2",
            "ecosystem": "hex"
          },
          {
            "name": "spitfire",
            "direct": false,
            "version": "0.3.13",
            "ecosystem": "hex"
          },
          {
            "name": "splode",
            "direct": false,
            "version": "0.3.1",
            "ecosystem": "hex"
          },
          {
            "name": "stream_data",
            "direct": false,
            "version": "1.3.0",
            "ecosystem": "hex"
          },
          {
            "name": "telemetry",
            "direct": false,
            "version": "1.4.2",
            "ecosystem": "hex"
          },
          {
            "name": "text_diff",
            "direct": false,
            "version": "0.1.0",
            "ecosystem": "hex"
          },
          {
            "name": "yamerl",
            "direct": false,
            "version": "0.10.0",
            "ecosystem": "hex"
          },
          {
            "name": "yaml_elixir",
            "direct": false,
            "version": "2.12.2",
            "ecosystem": "hex"
          },
          {
            "name": "ymlr",
            "direct": false,
            "version": "5.1.5",
            "ecosystem": "hex"
          }
        ],
        "collected": true,
        "truncated": false,
        "total_count": 57,
        "direct_count": 8,
        "indirect_count": 49
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 0,
        "merged_prs": 149,
        "open_issues": 0,
        "closed_ratio": 1,
        "closed_issues": 34,
        "closed_unmerged_prs": 31
      },
      "bus_factor": 1,
      "bot_contributors": 1,
      "top_contributors": [
        {
          "type": "User",
          "login": "zachdaniel",
          "commits": 151,
          "avatar_url": "https://avatars.githubusercontent.com/u/5722339?v=4"
        },
        {
          "type": "User",
          "login": "jimsynz",
          "commits": 10,
          "avatar_url": "https://avatars.githubusercontent.com/u/59449?v=4"
        },
        {
          "type": "User",
          "login": "joelpaulkoch",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/64319336?v=4"
        },
        {
          "type": "User",
          "login": "djgoku",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/105506?v=4"
        },
        {
          "type": "User",
          "login": "ken-kost",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/34007453?v=4"
        },
        {
          "type": "User",
          "login": "mbaertschi",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/1071091?v=4"
        },
        {
          "type": "User",
          "login": "a-nassim",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/49019782?v=4"
        },
        {
          "type": "User",
          "login": "sevenseacat",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/543859?v=4"
        },
        {
          "type": "User",
          "login": "moutikabdessabour",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/11250014?v=4"
        },
        {
          "type": "User",
          "login": "AlanMcCann",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/124184?v=4"
        }
      ],
      "contributors_sampled": 22,
      "top_contributor_share": 0.807
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "elixir.yml"
      ],
      "has_docs_dir": true,
      "linter_configs": [],
      "has_editorconfig": false,
      "has_linter_config": false,
      "has_precommit_config": false
    },
    "security_signals": {
      "lockfiles": [
        "mix.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": 5,
            "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": 2,
            "reason": "2 out of 8 merged PRs checked by a CI test -- score normalized to 2",
            "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/28 approved changesets -- score normalized to 2",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 10,
            "reason": "project has 4 contributing companies or organizations",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
          },
          {
            "name": "Dangerous-Workflow",
            "score": 10,
            "reason": "no dangerous workflow patterns detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
          },
          {
            "name": "Dependency-Update-Tool",
            "score": 10,
            "reason": "update tool detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
          },
          {
            "name": "Fuzzing",
            "score": 0,
            "reason": "project is not fuzzed",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
          },
          {
            "name": "License",
            "score": 10,
            "reason": "license file detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
          },
          {
            "name": "Maintained",
            "score": 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": null,
            "reason": "packaging workflow not detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
          },
          {
            "name": "Pinned-Dependencies",
            "score": 0,
            "reason": "dependency not pinned by hash detected -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
          },
          {
            "name": "SAST",
            "score": 5,
            "reason": "SAST tool is not run on all commits -- score normalized to 5",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
          },
          {
            "name": "Security-Policy",
            "score": 10,
            "reason": "security policy file detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
          },
          {
            "name": "Signed-Releases",
            "score": null,
            "reason": "no releases found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
          },
          {
            "name": "Token-Permissions",
            "score": 0,
            "reason": "detected GitHub workflow tokens with excessive permissions",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
          },
          {
            "name": "Vulnerabilities",
            "score": 5,
            "reason": "5 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "95641ec8caaefb12874e4e5605646e51c8254c3b",
        "ran_at": "2026-07-24T02:57:37Z",
        "aggregate_score": 5.7,
        "scorecard_version": "v5.5.0"
      },
      "has_codeql_workflow": false,
      "has_security_policy": false,
      "has_dependabot_config": true
    },
    "contribution_flow": {
      "collected": true,
      "ci_last_run_at": "2026-07-01T15:19:41Z",
      "oldest_open_prs": [],
      "last_merged_pr_at": "2026-07-01T14:40:52Z",
      "ci_last_conclusion": "FAILURE",
      "oldest_open_issues": []
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/ash-project/ash_sqlite",
    "host": "github.com",
    "name": "ash_sqlite",
    "owner": "ash-project"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "moderate",
      "name": "Overall health",
      "note": null,
      "notes": [],
      "value": 68,
      "inputs": {
        "security": 66,
        "vitality": 70,
        "community": 60,
        "governance": 70,
        "engineering": 71
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "good",
        "name": "Vitality",
        "value": 70,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "moderate",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 68,
            "inputs": {
              "commits_last_year": 57,
              "human_commit_share": 0.78,
              "days_since_last_push": 22,
              "active_weeks_last_year": 23
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 22 days ago",
                "points": 28.8,
                "status": "partial",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 22
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "23/52 weeks with commits",
                "points": 15.9,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 23
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "57 commits in the last year",
                "points": 15.8,
                "status": "partial",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 57
                    }
                  }
                ],
                "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": "good",
            "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": 74,
            "inputs": {
              "releases_count": 3,
              "latest_release_tag": "v0.2.17",
              "releases_from_tags": false,
              "days_since_latest_release": 92,
              "mean_days_between_releases": 137.1
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "3 releases published",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "releases_published",
                    "params": {
                      "count": 3
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 92 days ago",
                "points": 27,
                "status": "partial",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 92
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~137.1 days",
                "points": 12.6,
                "status": "partial",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 137.1
                    }
                  }
                ],
                "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": 22,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "last human commit 22 days ago",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_maintained",
                    "params": {
                      "days": 22
                    }
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Is the project alive — is code being written and are releases shipping?"
      },
      {
        "key": "community",
        "band": "moderate",
        "name": "Community & Adoption",
        "value": 60,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "at_risk",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 39,
            "inputs": {
              "forks": 30,
              "stars": 30,
              "watchers": 4,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "30 stars",
                "points": 23.7,
                "status": "partial",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 30
                    }
                  }
                ],
                "max_points": 60
              },
              {
                "key": "forks",
                "name": "Forks",
                "detail": "30 forks",
                "points": 12.2,
                "status": "partial",
                "details": [
                  {
                    "code": "forks",
                    "params": {
                      "count": 30
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "watchers",
                "name": "Watchers",
                "detail": "4 watchers",
                "points": 2.7,
                "status": "partial",
                "details": [
                  {
                    "code": "watchers",
                    "params": {
                      "count": 4
                    }
                  }
                ],
                "max_points": 15
              }
            ]
          },
          {
            "key": "community_health",
            "band": "excellent",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 86,
            "inputs": {
              "has_readme": true,
              "has_license": false,
              "has_contributing": true,
              "has_issue_template": false,
              "has_code_of_conduct": true,
              "has_pull_request_template": true
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 22.5,
                "status": "met",
                "details": [],
                "max_points": 22.5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "license file present, not a recognized license",
                "points": 16.9,
                "status": "partial",
                "details": [
                  {
                    "code": "license_custom",
                    "params": {}
                  }
                ],
                "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": 13.5,
                "status": "met",
                "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": 6.3,
                "status": "met",
                "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": 56,
            "inputs": {
              "packages": [
                "ash_sqlite"
              ],
              "dependents": null,
              "ecosystems": "hex",
              "total_downloads": 31399,
              "monthly_downloads": 2128
            },
            "components": [
              {
                "key": "monthly_downloads",
                "name": "Monthly downloads",
                "detail": "2,128 downloads/month across hex",
                "points": 44.4,
                "status": "partial",
                "details": [
                  {
                    "code": "downloads_monthly",
                    "params": {
                      "count": 2128,
                      "ecosystems": "hex"
                    }
                  }
                ],
                "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": "good",
        "name": "Sustainability & Governance",
        "value": 70,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "at_risk",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 37,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 22,
              "top_contributor_share": 0.807
            },
            "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 81% of commits",
                "points": 4.3,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 81
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "22 contributors",
                "points": 13.5,
                "status": "met",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 22
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 4 contributing companies or organizations",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "good",
            "name": "Issue & PR responsiveness",
            "note": null,
            "notes": [],
            "value": 82,
            "inputs": {
              "merged_prs": 149,
              "open_issues": 0,
              "closed_issues": 34,
              "issue_closed_ratio": 1,
              "closed_unmerged_prs": 31
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "100% of issues closed",
                "points": 46.8,
                "status": "met",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 100
                    }
                  }
                ],
                "max_points": 46.75
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "149/180 decided PRs merged",
                "points": 31.7,
                "status": "partial",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 149,
                      "decided": 180
                    }
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 6/28 approved changesets -- score normalized to 2",
                "points": 3,
                "status": "partial",
                "details": [],
                "max_points": 15
              }
            ]
          },
          {
            "key": "stewardship",
            "band": "good",
            "name": "Ownership & stewardship",
            "note": null,
            "notes": [],
            "value": 74,
            "inputs": {
              "followers": 385,
              "owner_type": "Organization",
              "is_verified": null,
              "owner_login": "ash-project",
              "public_repos": 61,
              "account_age_days": 2423
            },
            "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": "385 followers of ash-project",
                "points": 18.6,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 385,
                      "login": "ash-project"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "61 public repos, account ~6 yr old",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 61
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 6
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "excellent",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "packages": [
                "ash_sqlite"
              ],
              "ecosystems": "hex",
              "any_deprecated": false,
              "min_days_since_publish": 92
            },
            "components": [
              {
                "key": "published_resolvable",
                "name": "Published & resolvable",
                "detail": "1 package(s) on hex",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "packages_published",
                    "params": {
                      "count": 1,
                      "ecosystems": "hex"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "publish_recency",
                "name": "Publish recency",
                "detail": "latest publish 92 days ago",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 92
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "24 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 24
                    }
                  }
                ],
                "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": 71,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "moderate",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 52,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": false,
              "has_precommit_config": false
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "1 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 1
                    }
                  }
                ],
                "max_points": 24
              },
              {
                "key": "tests_present",
                "name": "Tests present",
                "detail": null,
                "points": 24,
                "status": "met",
                "details": [],
                "max_points": 24
              },
              {
                "key": "linter_config",
                "name": "Linter config",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 16
              },
              {
                "key": "pre_commit_hooks",
                "name": "Pre-commit hooks",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 9.6
              },
              {
                "key": "editorconfig",
                "name": ".editorconfig",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.4
              },
              {
                "key": "openssf_scorecard_ci_tests",
                "name": "OpenSSF Scorecard: CI-Tests",
                "detail": "2 out of 8 merged PRs checked by a CI test -- score normalized to 2",
                "points": 4,
                "status": "partial",
                "details": [],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "excellent",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "topics": [
                "ash",
                "data-layer",
                "elixir",
                "sqlite"
              ],
              "has_wiki": true,
              "homepage": "https://hexdocs.pm/ash_sqlite",
              "has_readme": true,
              "has_docs_dir": true,
              "has_description": true
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 30,
                "status": "met",
                "details": [],
                "max_points": 30
              },
              {
                "key": "documentation_directory",
                "name": "Documentation directory",
                "detail": null,
                "points": 25,
                "status": "met",
                "details": [],
                "max_points": 25
              },
              {
                "key": "documentation_homepage_site",
                "name": "Documentation / homepage site",
                "detail": "https://hexdocs.pm/ash_sqlite",
                "points": 15,
                "status": "met",
                "details": [],
                "max_points": 15
              },
              {
                "key": "repository_description",
                "name": "Repository description",
                "detail": null,
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "topics",
                "name": "Topics",
                "detail": "4 topics",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "topics_count",
                    "params": {
                      "count": 4
                    }
                  }
                ],
                "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": 66,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "moderate",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): Packaging, Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "packaging",
                    "signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 57,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 16,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 2,
              "scorecard_aggregate": 5.7
            },
            "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": 3.8,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "ci_tests",
                "name": "CI-Tests",
                "detail": "2 out of 8 merged PRs checked by a CI test -- score normalized to 2",
                "points": 0.5,
                "status": "partial",
                "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/28 approved changesets -- score normalized to 2",
                "points": 1.5,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 4 contributing companies or organizations",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "dangerous_workflow",
                "name": "Dangerous-Workflow",
                "detail": "no dangerous workflow patterns detected",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "dependency_update_tool",
                "name": "Dependency-Update-Tool",
                "detail": "update tool detected",
                "points": 7.5,
                "status": "met",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "fuzzing",
                "name": "Fuzzing",
                "detail": "project is not fuzzed",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "license file detected",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "maintained",
                "name": "Maintained",
                "detail": "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 not detected",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 5
              },
              {
                "key": "pinned_dependencies",
                "name": "Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "sast",
                "name": "SAST",
                "detail": "SAST tool is not run on all commits -- score normalized to 5",
                "points": 2.5,
                "status": "partial",
                "details": [],
                "max_points": 5
              },
              {
                "key": "security_policy",
                "name": "Security-Policy",
                "detail": "security policy file detected",
                "points": 5,
                "status": "met",
                "details": [],
                "max_points": 5
              },
              {
                "key": "signed_releases",
                "name": "Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 7.5
              },
              {
                "key": "token_permissions",
                "name": "Token-Permissions",
                "detail": "detected GitHub workflow tokens with excessive permissions",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "vulnerabilities",
                "name": "Vulnerabilities",
                "detail": "5 existing vulnerabilities detected",
                "points": 3.8,
                "status": "partial",
                "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 57 resolved dependencies against OSV. 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": 57
                }
              },
              {
                "code": "advisories_repo_graph_caveat",
                "params": {}
              },
              {
                "code": "advisories_reachability",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "source": "osv",
              "advisories": 5,
              "affected_packages": 2,
              "assessed_packages": 57,
              "unassessed_packages": 0,
              "affected_by_severity": "high 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": 57,
              "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
              }
            ]
          },
          {
            "key": "high_risk_jurisdiction_exposure",
            "band": "excellent",
            "name": "High-Risk Jurisdiction Exposure",
            "note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
            "notes": [
              {
                "code": "jurisdiction_evidence_limits",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "meaning": "self-published location evidence; not nationality or citizenship",
              "red_flag": false,
              "exposures": [],
              "policy_countries": [
                "Russia",
                "Iran",
                "North Korea"
              ],
              "review_only_matches": 0,
              "assessed_self_published_locations": 10
            },
            "components": [
              {
                "key": "policy_exposure_multiplier",
                "name": "Policy exposure multiplier",
                "detail": "no confirmed policy-scope location match",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "jurisdiction_no_match",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
      },
      {
        "key": "ai_readiness",
        "band": "at_risk",
        "name": "AI Readiness",
        "value": 49,
        "weight": 0,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "at_risk",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 40,
            "inputs": {
              "has_llms_txt": false,
              "legible_history_share": 0.987,
              "agent_instruction_files": [],
              "agent_instruction_max_bytes": null
            },
            "components": [
              {
                "key": "agent_instructions",
                "name": "Agent instructions",
                "detail": "no CLAUDE.md / AGENTS.md / editor rules",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_agent_instructions",
                    "params": {}
                  }
                ],
                "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": "77 of 78 human commits state their intent (structured subject or explanatory body)",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 77,
                      "sampled": 78
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "moderate",
            "name": "Verify loop (build / test / typecheck)",
            "note": null,
            "notes": [],
            "value": 53,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [
                "mix.lock"
              ],
              "has_dockerfile": false,
              "typed_language": false,
              "bootstrap_files": [],
              "has_devcontainer": false,
              "has_linter_config": false,
              "typecheck_configs": [],
              "agent_commit_share": 0,
              "toolchain_manifests": [
                "mix.exs"
              ],
              "dependency_bot_commit_share": 0.22
            },
            "components": [
              {
                "key": "one_command_bootstrap",
                "name": "One-command bootstrap",
                "detail": "mix.exs (toolchain convention, no task runner)",
                "points": 12.6,
                "status": "partial",
                "details": [
                  {
                    "code": "toolchain_convention",
                    "params": {
                      "files": "mix.exs"
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "automated_tests",
                "name": "Automated tests",
                "detail": null,
                "points": 22,
                "status": "met",
                "details": [],
                "max_points": 22
              },
              {
                "key": "lint_format_config",
                "name": "Lint / format config",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 11
              },
              {
                "key": "reproducible_environment",
                "name": "Reproducible environment",
                "detail": "lockfile",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "lockfile"
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "demonstrated_agent_practice",
                "name": "Demonstrated agent practice",
                "detail": "no agent-authored commits among the last 100",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_agent_authored_commits",
                    "params": {
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "automated_maintenance",
                "name": "Automated maintenance",
                "detail": "22 of the last 100 commits are automated dependency updates",
                "points": 8,
                "status": "met",
                "details": [
                  {
                    "code": "dependency_bot_commits",
                    "params": {
                      "count": 22,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 8
              },
              {
                "key": "openssf_scorecard_pinned_dependencies",
                "name": "OpenSSF Scorecard: Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "ai_code_legibility",
            "band": "moderate",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 54,
            "inputs": {
              "primary_language": "Elixir",
              "largest_source_bytes": 77094,
              "source_files_sampled": 87,
              "oversized_source_files": 2
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "Elixir without a type-check config",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_typecheck_config_language",
                    "params": {
                      "language": "Elixir"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "2/87 source files over 60KB",
                "points": 53.7,
                "status": "partial",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 87,
                      "oversized": 2
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          }
        ],
        "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": [
    "Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token"
  ],
  "report_type": "repository",
  "generated_at": "2026-07-24T02:57:54.797369Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/a/ash-project/ash_sqlite.svg",
  "full_name": "ash-project/ash_sqlite",
  "license_state": "custom",
  "license_spdx": null
}

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

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

How one result sits in the wider record: aggregate statisticsHex.