Öffentliches Register
Software-GesundheitsberichtSchema 0.27.0 · Metriken 1.13.0 · 2026-07-29 08:48 UTC

meoyawn / pggen

Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.

GoMIT★ 1 Stern⑂ 0 Forksseit Mai 2026ForkAuf GitHub ansehen ↗

meoyawn/pggen erreicht einen Gesundheitsindex von 46 von 100 und liegt damit im Bereich Gefährdet. Am stärksten schneidet es bei Sustainability & Governance (64/100) ab, am schwächsten bei Community & Adoption (12/100). Zuletzt vor 8 Tagen aktualisiert. Ein einzelner Mitwirkender trägt den Großteil der jüngsten Arbeit.

46
gesamt / 100
Gefährdet

Software-Gesundheitsindex

Metriken werden auf einer Skala von 1–100 in gewichtete Kategorien gruppiert. Der Gesamtwert beginnt als ihr Mittel; sobald öffentliche Evidenz die Richtlinie für Hochrisikojurisdiktionen auslöst, wird die Bewertung angepasst und erhält die Obergrenze 49 (Gefährdet). AI Readiness liegt außerhalb.

46
Exzellent85-100Vorbildlich; erfüllt im Wesentlichen alle geprüften Kriterien
Gut70-84Gesund; geringfügige Lücken
Mittel50-69Akzeptabel mit deutlichen Lücken; Überprüfung empfohlen
Gefährdet30-49Erhebliche Schwächen; eine Übernahme erfordert Vorsicht
Kritisch1-29Schwerwiegende Probleme (aufgegeben, nur ein Maintainer, keine Hygiene)
VitalitätCommunity &VerbreitungNachhaltigkeit &GovernanceEngineering-QualitätSicherheitAI Readiness

Bewertungsprofil

Jede Achse ist eine Kategorie. Die Form zählt mehr als der Durchschnitt — ein gesundes Projekt füllt die gesamte Fläche, während ein Profil aus Spitzen und Kratern bedeutet, dass Stärke in einer Dimension Risiken in einer anderen verdeckt.

Eigentümerschaft

Adel NizamutdinovPersönliches Konto
138 Follower57 öffentliche Reposseit März 2012

Dieses Repository gehört einem persönlichen Konto. Ein Projekt mit nur einem Eigentümer trägt ein höheres Kontinuitätsrisiko als ein organisationsgetragenes.

Paket-Ökosysteme

RegistryPaketVersionDownloads / MonatVersionenZuletzt veröffentlicht
Gogithub.com/meoyawn/pggenv0.2.0-6vor 8 Tagen

Metriken nach Kategorie

Vitalität

Lebt das Projekt — wird Code geschrieben und werden Releases ausgeliefert?

62Mittel · 22 % des Gesamtindex
Wie die Bewertung erfolgt
28.8/36Push-Aktualität — letzter Push vor 8 Tagen
2.8/36Commit-Rhythmus — 4/52 Wochen mit Commits
12.1/18Commit-Volumen — 21 Commits im letzten Jahr
0/10OpenSSF Scorecard: Maintained — project was created within the last 90 days. Please review its contents carefully
Verwendete Eingangsdaten
commits_last_year21
human_commit_share1
days_since_last_push8
active_weeks_last_year4
Wie die Bewertung erfolgt
16.2/27Liefert Releases aus — 6 Versions-Tags (keine GitHub-Releases)
36/36Release-Aktualität — letztes Release vor 8 Tagen
27/27Release-Rhythmus — ein Release etwa alle 14,8 Tage
0/10OpenSSF Scorecard: Signed-Releases — keine Daten
Verwendete Eingangsdaten
releases_count6
latest_release_tagv0.2.0
releases_from_tagsja
days_since_latest_release8
mean_days_between_releases14,8
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): OpenSSF Scorecard: Signed-Releases. Die verbleibenden Gewichte wurden renormalisiert.

Community & Verbreitung

Hat das Projekt Nutzer, Downloads, Aufmerksamkeit und ein einladendes Umfeld für Beitragende?

12Kritisch · 18 % des Gesamtindex
Wie die Bewertung erfolgt
0/60Stars — 1 Stars
0/25Forks — 0 Forks
0/15Watcher — 0 Watcher
Verwendete Eingangsdaten
forks0
stars1
watchers0
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
Wie die Bewertung erfolgt
0/22.5README
22.5/22.5Lizenz — anerkannte Lizenz (MIT)
0/18CONTRIBUTING-Leitfaden
0/13.5Verhaltenskodex
0/7.2Issue-Vorlage
0/6.3PR-Vorlage
Verwendete Eingangsdaten
has_readmenein
has_licensenein
has_contributingnein
has_issue_templatenein
has_code_of_conductnein
has_pull_request_templatenein

Nachhaltigkeit & Governance

Überdauert das Projekt die Menschen, die es tragen — Bus-Faktor, Reaktionsfähigkeit, Trägerschaft und Paketpflege?

64Mittel · 24 % des Gesamtindex
Wie die Bewertung erfolgt
9/54Bus-Faktor — 1 Beitragende decken die Hälfte aller Commits ab
1.3/22.5Commit-Verteilung — wichtigste beitragende Person verfasste 94 % der Commits
13.5/13.5Breite der Beitragenden — 10 Beitragende
6/10OpenSSF Scorecard: Contributors — project has 2 contributing companies or organizations -- score normalized to 6
Verwendete Eingangsdaten
bus_factor1
contributors_sampled10
top_contributor_share0,943
Wie die Bewertung erfolgt
46.8/46.8Issue-Lösungsquote — 100 % der Issues geschlossen
0/38.3PR-Annahme — keine entschiedenen Pull Requests oder keine Daten
0/15OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0
Verwendete Eingangsdaten
merged_prs0
open_issues0
closed_issues4
issue_closed_ratio1
closed_unmerged_prs0
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): PR-Annahme. Die verbleibenden Gewichte wurden renormalisiert.
Wie die Bewertung erfolgt
10/30Organisatorische Trägerschaft — persönliches (Nutzer-)Konto
0/20Verifizierte Domain — für Nutzerkonten nicht anwendbar
15.4/25Reichweite des Inhabers — 138 Follower von meoyawn
24.8/25Kontohistorie — 57 öffentliche Repos, Kontoalter ca. 14 Jahre
Verwendete Eingangsdaten
followers138
owner_typeUser
is_verified
owner_loginmeoyawn
public_repos57
account_age_days5.232
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): Verifizierte Domain. Die verbleibenden Gewichte wurden renormalisiert.

Paketpflege

100Exzellent
Wie die Bewertung erfolgt
25/25Veröffentlicht & auflösbar — 1 Paket(e) auf go
35/35Veröffentlichungsaktualität — letzte Veröffentlichung vor 8 Tagen
20/20Versionshistorie — 6 veröffentlichte Versionen
20/20Nicht veraltet — aktiv, nicht veraltet oder zurückgezogen
Verwendete Eingangsdaten
packagesgithub.com/meoyawn/pggen
ecosystemsgo
any_deprecatednein
min_days_since_publish8

Engineering-Qualität

Sind grundlegende Engineering- und Dokumentationspraktiken vorhanden?

52Mittel · 20 % des Gesamtindex
Wie die Bewertung erfolgt
24/24CI-Workflows — 2 Workflow(s)
24/24Tests vorhanden
16/16Linter-Konfiguration — .golangci.yaml
0/9.6Pre-Commit-Hooks
0/6.4.editorconfig
0/20OpenSSF Scorecard: CI-Tests — keine Daten
Verwendete Eingangsdaten
has_cija
has_testsja
has_editorconfignein
has_linter_configja
has_precommit_confignein
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): OpenSSF Scorecard: CI-Tests. Die verbleibenden Gewichte wurden renormalisiert.

Dokumentation

10Kritisch
Wie die Bewertung erfolgt
0/30README
0/25Dokumentationsverzeichnis
0/15Dokumentations-/Homepage-Site
0/10Repository-Beschreibung
0/10Topics
10/10Wiki
Verwendete Eingangsdaten
topics
has_wikija
homepage
has_readmenein
has_docs_dirnein
has_descriptionnein

Sicherheit

Sind die sichtbaren Sicherheits- und Lieferkettenpraktiken belastbar, ohne ungeklärte Exposition gegenüber Hochrisikojurisdiktionen?

25Kritisch · 16 % des Gesamtindex

Sicherheitslage

25Kritisch
Wie die Bewertung erfolgt
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — branch protection not enabled on development/release branches
0/2.5CI-Tests — keine Daten
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 0/30 approved changesets -- score normalized to 0
1.5/2.5Contributors — project has 2 contributing companies or organizations -- score normalized to 6
10/10Dangerous-Workflow — no dangerous workflow patterns detected
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5Lizenz — license file detected
0/7.5Maintained — project was created within the last 90 days. Please review its contents carefully
0/5Packaging — keine Daten
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
0/5SAST — no SAST tool detected
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — keine Daten
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
0.8/7.5Vulnerabilities — 9 existing vulnerabilities detected
Verwendete Eingangsdaten
sourceopenssf_scorecard
checks_evaluated15
scorecard_versionv5.5.0
checks_inconclusive3
scorecard_aggregate2,5
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): ci_tests, packaging, signed_releases. Die verbleibenden Gewichte wurden renormalisiert.

AI Readiness

Wie gut ist das Repository dafür ausgestattet, mit KI-Coding-Agenten entwickelt und gepflegt zu werden? Ein unabhängiges, experimentelles Badge — Gewicht 0,0, es wird eigenständig ausgewiesen und verändert den Gesamt-Gesundheitswert nicht.

57Mittel · 0 % des Gesamtindex
Wie die Bewertung erfolgt
0/45Agentenanweisungen — keine CLAUDE.md / AGENTS.md / Editor-Regeln
0/15Maschinenlesbare Doku (llms.txt)
25.1/40Lesbare Commit-Historie — 47 von 100 menschlichen Commits benennen ihre Absicht (strukturierter Betreff oder erläuternder Text)
Verwendete Eingangsdaten
has_llms_txtnein
legible_history_share0,47
agent_instruction_files
agent_instruction_max_bytes
Wie die Bewertung erfolgt
18/18Bootstrap mit einem Befehl — Taskfile.yaml
22/22Automatisierte Tests
11/11Lint-/Format-Konfiguration — .golangci.yaml
11/11Statische Typprüfung — Go (statisch typisiert)
10/10Reproduzierbare Umgebung — Dockerfile, lockfile
0/10Belegte Agentenpraxis — keine von Agenten verfassten Commits unter den letzten 100
0/8Automatisierte Wartung — keine automatisierten Abhängigkeits-Updates beobachtet
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Verwendete Eingangsdaten
has_nixnein
has_testsja
lockfilesgo.sum
has_dockerfileja
typed_languageja
bootstrap_filesTaskfile.yaml
has_devcontainernein
has_linter_configja
typecheck_configs
agent_commit_share0
toolchain_manifestsgo.mod
dependency_bot_commit_share0
Wie die Bewertung erfolgt
45/45Typprüfbarer Code — Go (statisch typisiert)
55/55Handhabbare Dateigrößen — 0/131 Quelldateien über 60 KB
Verwendete Eingangsdaten
primary_languageGo
largest_source_bytes19.008
source_files_sampled131
oversized_source_files0
Wie die Bewertung erfolgt
0/40API-Schema (OpenAPI/GraphQL/proto)
0/20MCP-Server
40/40Lauffähige Beispiele — example
Verwendete Eingangsdaten
example_dirsexample
has_mcp_signalnein
api_schema_files

Eckdaten

1GitHub-Sterne
10Mitwirkende
21Commits, letzte 12 Monate
8Tage seit letztem Push
6Releases
1Bus-Faktor
0offene Issues
GoPaket-Ökosysteme

Warnungen zur Datenerhebung

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
  • Community profile unavailable
  • GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

Weitere Details

OpenSSF Scorecard 2.5 / 10
2.5Gesamtwert

Unabhängige, werkzeugneutrale Sicherheitsbewertung durch das quelloffene OpenSSF Scorecard. Jede Prüfung honoriert eine Sicherheits-Praxis, nicht das Werkzeug eines bestimmten Anbieters. Prüfungen, die Scorecard nicht ermitteln konnte, sind mit k. A. markiert und vom Sicherheitswert ausgeschlossen (nie als null gezählt).Scorecard v5.5.0 · 2026-07-29 08:48 UTC

10Binary-Artifactsno binaries found in the repo
0Branch-Protectionbranch protection not enabled on development/release branches
k. A.CI-Testsno pull request found
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/30 approved changesets -- score normalized to 0
6Contributorsproject has 2 contributing companies or organizations -- score normalized to 6
10Dangerous-Workflowno dangerous workflow patterns detected
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
0Maintainedproject was created within the last 90 days. Please review its contents carefully
k. A.Packagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
0SASTno SAST tool detected
0Security-Policysecurity policy file not detected
k. A.Signed-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
1Vulnerabilities9 existing vulnerabilities detected
Direkte Abhängigkeiten 8
RegistryPaketVersionsvorgabeManifest
Gogithub.com/bmatcuk/doublestarv1.3.4go.mod
Gogithub.com/docker/dockerv28.5.2+incompatiblego.mod
Gogithub.com/docker/go-connectionsv0.7.0go.mod
Gogithub.com/google/go-cmpv0.7.0go.mod
Gogithub.com/jackc/pgx/v5v5.10.0go.mod
Gogithub.com/peterbourgon/ff/v3v3.4.0go.mod
Gogithub.com/stretchr/testifyv1.11.1go.mod
Gogolang.org/x/modv0.37.0go.mod
Alle Abhängigkeiten nicht erhoben

Der aufgelöste Abhängigkeitssatz konnte für diesen Bericht nicht erhoben werden: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

JSON-Rohbericht maschinenlesbar
{
  "data": {
    "repo": {
      "topics": [],
      "is_fork": true,
      "size_kb": 1214,
      "has_wiki": true,
      "homepage": null,
      "languages": {
        "Go": 369366,
        "Shell": 2304,
        "PLpgSQL": 2748
      },
      "pushed_at": "2026-07-20T13:17:00Z",
      "created_at": "2026-05-05T12:33:43Z",
      "owner_type": "User",
      "updated_at": "2026-07-20T13:16:11Z",
      "description": "Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "main",
      "license_spdx_raw": "MIT",
      "primary_language": "Go",
      "significant_languages": [
        "Go"
      ]
    },
    "owner": {
      "blog": "adelnz.com",
      "name": "Adel Nizamutdinov",
      "type": "User",
      "login": "meoyawn",
      "company": null,
      "location": null,
      "followers": 138,
      "avatar_url": "https://avatars.githubusercontent.com/u/1594148?v=4",
      "created_at": "2012-03-31T21:33:09Z",
      "is_verified": null,
      "public_repos": 57,
      "account_age_days": 5232
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": false
    },
    "activity": {
      "releases": [
        {
          "tag": "v0.2.0",
          "kind": "minor",
          "published_at": "2026-07-20T13:14:28Z"
        },
        {
          "tag": "v0.1.0",
          "kind": "minor",
          "published_at": "2026-06-19T16:22:44Z"
        },
        {
          "tag": "v0.0.4",
          "kind": "patch",
          "published_at": "2026-06-02T20:17:21Z"
        },
        {
          "tag": "v0.0.3",
          "kind": "patch",
          "published_at": "2026-06-02T19:53:55Z"
        },
        {
          "tag": "v0.0.2-pgxv5.20260507",
          "kind": "prerelease",
          "published_at": "2026-05-07T11:33:18Z"
        },
        {
          "tag": "v0.0.1-pgxv5.20260507",
          "kind": "prerelease",
          "published_at": "2026-05-07T08:25:22Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "9fc19c8979eb3592baa02c4af91db9d1fc7b0d15",
          "body": null,
          "is_bot": false,
          "headline": "Require downstream Postgres connection for generation",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-07-20T13:14:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "abf9635060a3907ca44afdbd75a034d06b75ad47",
          "body": null,
          "is_bot": false,
          "headline": "Document shared row structs and streaming queries",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-19T16:39:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "740c219d7fc11411bccb44419175645c39bbc6a0",
          "body": null,
          "is_bot": false,
          "headline": "Add domain type resolution for custom IDs",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-19T16:22:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d7606d8b1b273ef3d2dd113b6fc59c52e03b53d6",
          "body": "Fixes https://github.com/meoyawn/pggen/issues/2",
          "is_bot": false,
          "headline": "Add stream query support",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-18T14:27:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "db035d4328d65aa407725de61371298859eb3108",
          "body": "Fixes https://github.com/meoyawn/pggen/issues/1",
          "is_bot": false,
          "headline": "Add shared row annotations",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-18T13:44:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8055dbf62bce4523b5b1e6e23edbaa1c08aedcb8",
          "body": null,
          "is_bot": false,
          "headline": "gitignore",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-18T13:11:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3a56366e8057af5462bdb1c5e1d806a0ac391831",
          "body": null,
          "is_bot": false,
          "headline": "taskfile",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-18T13:08:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "29ec1980c735b718353a3a0641f0ed51bb33b510",
          "body": null,
          "is_bot": false,
          "headline": "Use pointer receivers for projection getters",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-02T20:17:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0751c2b0c689716c1822796c759250ca501e72e5",
          "body": "Closes https://github.com/jschaf/pggen/issues/44",
          "is_bot": false,
          "headline": "Add projection interfaces for query rows",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-02T19:53:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "10ab9427e3ce14fa938c2e5864d2957652463586",
          "body": null,
          "is_bot": false,
          "headline": "Upgrade Docker dependencies",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-07T11:33:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5106fe911aac7a8eabae0c3821d7806cdeaf6f7a",
          "body": null,
          "is_bot": false,
          "headline": "Make pgx v5 fork go-gettable",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-07T08:25:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a6e9a749132d9fea68f873819ef9b009c39328f5",
          "body": null,
          "is_bot": false,
          "headline": "Update README for pgx v5",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T21:42:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "adb89a8cd471ee6da0e769e05eca493f83973709",
          "body": null,
          "is_bot": false,
          "headline": "Wrap collection errors with query context",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T21:32:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "24c47e8eb95c973dd04dae0ecd17fe064c56688d",
          "body": null,
          "is_bot": false,
          "headline": "Use CollectOneRow for one queries",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T21:23:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ddc4ef26b84cecc040fb364c1317a04d583c16a0",
          "body": null,
          "is_bot": false,
          "headline": "Fix zero returns for custom scalar results",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T21:11:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "47c914855b558509371e9a1a94a4325f89ee1a37",
          "body": null,
          "is_bot": false,
          "headline": "Trim blank declarer output",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T19:33:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8b76a4d96d02afbdcd60e77f193e498bdc0965ec",
          "body": null,
          "is_bot": false,
          "headline": "Add pgx ltree array override coverage",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T19:16:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ebeee45a92af65b87a3bb2cc307454e4428216c6",
          "body": null,
          "is_bot": false,
          "headline": "Restore generated type registration test coverage",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T19:01:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "79e1b92769af8f70e18ca21b546189711a62456c",
          "body": null,
          "is_bot": false,
          "headline": "Finish pgx v5 generated query support",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T14:40:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6dfe30cb5fbf1cbe1582f8cccfcfda54f7887c49",
          "body": "# Conflicts:\n#\texample/composite/query.sql_test.go\n#\texample/custom_types/query.sql_test.go\n#\texample/device/query.sql_test.go\n#\texample/enums/query.sql_test.go\n#\texample/erp/order/customer.sql_test.go\n#\texample/inline_param_count/inline0/query.sql_test.go\n#\texample/inline_param_count/inline1/query.\n[…]\ninternal/pg/type_cache.go\n#\tinternal/pg/type_fetcher.go\n#\tinternal/pg/types.go\n#\tinternal/pgdocker/pgdocker.go\n#\tinternal/pginfer/pginfer.go\n#\tinternal/pgplan/pgplan.go\n#\tinternal/pgtest/pg_test_db.go",
          "is_bot": false,
          "headline": "Merge remote-tracking branch 'upstream/joe/pgxv5' into meoyawn/pgxv5",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T13:20:29Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "6d5a5fff2bdbd6867544dd0aa1de7d63fde65364",
          "body": null,
          "is_bot": false,
          "headline": "Run tests through dockerized Postgres wrapper",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T12:55:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "632aa8e2e34733a36dbda854dcb4aa8a9b57f884",
          "body": "- Upgrade golangci-lint. Fix a bunch of lints.",
          "is_bot": false,
          "headline": "Upgrade to go 1.24.1 (#106)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2025-03-14T05:00:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7ca7c671954af85d8e511ec15c7d2417be335e15",
          "body": null,
          "is_bot": false,
          "headline": "update template for code",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-26T18:13:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2b41dd18069be924125027b2c63c7362243ffe4a",
          "body": null,
          "is_bot": false,
          "headline": "move codecs into template",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-26T01:27:34Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1b29c21c3998c76af787ed3cd089593aaaaa4f68",
          "body": null,
          "is_bot": false,
          "headline": "fix most author example tests",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-25T07:21:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8e58ee07478620e863ba20506fb978877d24a060",
          "body": null,
          "is_bot": false,
          "headline": "Simplify codec",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-25T06:16:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "500b5c6be650536cc5b4cb45a13c45002d6d04ca",
          "body": null,
          "is_bot": false,
          "headline": "More experiments with codecs",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-06T01:45:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4bb40e2b95c380ce9d386688af28a408521121d8",
          "body": null,
          "is_bot": false,
          "headline": "experiment with codecs",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-05T23:12:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b52421341541e98ca5a8c08d8da6ed6c6033720b",
          "body": "- For pggen row structs, implement pgx.RowScanner.\n- Remove the typeResolver, since we're punting type resolution to the pgx.Conn\n  type map for now.\n\n#74",
          "is_bot": false,
          "headline": "Upgrade to pgx v5",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-05T06:24:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3259c9ab0b7ddcf7d614f05491455b57242d96b0",
          "body": "We don't need the wordy description in every generated file.",
          "is_bot": false,
          "headline": "Shorten docs for generic conn (#103)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-05T06:23:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "104c6ec88482326f2ed338d9ca29afec674d749a",
          "body": "Follow-up to #100.",
          "is_bot": false,
          "headline": "Remove reference to NewQuerierConfig (#101)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-03T23:45:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c25070dd55607b08f4f5b8bc2bc83263df8f6303",
          "body": "It was a way to override the type encoders and decoders. It wasn't documented\r\nand makes it harder to upgrade to to pgx v5. Plus, we can't really change it in\r\na way to that won't break existing users, so just remove it.e",
          "is_bot": false,
          "headline": "Remove QuerierConfig (#100)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T06:03:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d0025c1de489a975fea5cae95c82dad6421617c7",
          "body": "I never used it so I think usage is probably low. Complicates the pgx v5\r\nupgrade, so drop it.\r\n\r\nIt's easy enough to workaround by writing the prepare manually.\r\n\r\nAdditionally, it won't work well if we eventually support dynamic queries.",
          "is_bot": false,
          "headline": "Remove PrepareAllQueries (#98)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T05:26:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1018a30e40067e8e25793bc181b51a4518d742cf",
          "body": "Speeds up testing by about 25%, from 57 seconds to 42 seconds.",
          "is_bot": false,
          "headline": "Use buildjet for actions (#97)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T05:15:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8529e51c1e898929c8af8687c228bc77f9e12459",
          "body": "Prefer the standard library to limit dependencies.",
          "is_bot": false,
          "headline": "Replace multierror with stdlib errors.Join (#96)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T05:01:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fed2faa3f735537759523517f943068a3dbce208",
          "body": "Prefer the standard library to limit dependencies.",
          "is_bot": false,
          "headline": "Replace zap with slog (#95)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T04:56:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "eed46625728d1122f8d6bccfa4eccc5263fd3b34",
          "body": null,
          "is_bot": false,
          "headline": "Upgrade all go.mod deps (#94)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T04:42:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "323805032c9a4f05d6dab88b845e01505e75c535",
          "body": "PGXv5 dramatically changes how batch queries work. In v4 we use a separate\r\nbatch and scan call. In v5, we use a callback with generics for type safety.\r\n\r\nRemove batch queries for now since it complicates upgrading to pgx V5. We may\r\nthem back in later with more ergonomic API.\r\n\r\n#74",
          "is_bot": false,
          "headline": "Remove all batch queries (#93)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T04:25:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8ecc0cbb97740104749b48689c6a47515d83d16a",
          "body": "* Add JSON tags for input structs as well\r\n\r\n* Add string padding for EmitParamStruct\r\n\r\n* Update tests\r\n\r\n* Add RawName, still need to fix tests\r\n\r\n* Refactor functions for aligning spacing\r\n\r\n* Update getLongestInput to use RawName instead of UpperName\r\n\r\n* Update acceptance tests",
          "is_bot": false,
          "headline": "Add JSON tags for parameter structs (#90)",
          "author_name": "Faraz Fazli",
          "author_login": "farazfazli",
          "committed_at": "2023-10-16T23:57:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "db00fd2ab2770c45935e0c30a0648feded6ec898",
          "body": null,
          "is_bot": false,
          "headline": "Avoid deprecated goreleaser settings",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T23:11:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fe0c28d62d37d84ccd7f2cf48ff34b3a8354b1dc",
          "body": "Default to two to match previous behavior. Main use case is to always output a\r\nstruct for parameters. Useful so that structure doesn't change when adding a\r\nnew param.\r\n\r\nFixes #83.",
          "is_bot": false,
          "headline": "Add pggen --inline-param-count=2 flag (#87)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T22:53:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c57cb1e626f2ef312e71e28412f668bddf4f2daa",
          "body": null,
          "is_bot": false,
          "headline": "Sync dev/words.dic",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T21:00:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "55d8fc95461d9145d27145eeaeee188d9670912e",
          "body": "Previously, we used the higher level pgx Exec method to run a Postgres PREPARE\ncommand and then inspected the Postgres catalog.\n\nInstead, issue a prepare command directly with the lower-level pgconn which\nreturns the fields and parameter OIDs directly.",
          "is_bot": false,
          "headline": "Infer types with prepare instead of execution",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T17:12:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "85a861340f8c29c155f9201433672c3cd18ea538",
          "body": null,
          "is_bot": false,
          "headline": "Run gofmt simplify to fix docs",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T16:40:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4272ee3e6dd82b766dcdbfa8045911d6b08aaf4f",
          "body": null,
          "is_bot": false,
          "headline": "Fix IntelliJ Go lints",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T16:37:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "95dc2643202b9aeac8a9fc5ec1a8dab42ad39e95",
          "body": null,
          "is_bot": false,
          "headline": "Fix IntelliJ lints",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T16:34:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7aa983baa5ce5cf60f971d7474ecba5de73195da",
          "body": "Sync it from IntelliJ.",
          "is_bot": false,
          "headline": "Add word list dictionary",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T15:59:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "363cf19563c6f8fcc9cdc59b20b7d27fc81e2f85",
          "body": null,
          "is_bot": false,
          "headline": "Remove unused pginfer.InputParam DefaultVal",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-16T04:38:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8c1a3a3a85fea3b62844b43a437b8677f1cf37ec",
          "body": null,
          "is_bot": false,
          "headline": "allow overriding \"id\" acronym (#80)",
          "author_name": "Sergey Shumov",
          "author_login": "darkxanter",
          "committed_at": "2023-01-27T20:08:01Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "943a70caede2e68b419c59d7dec95264e279b849",
          "body": null,
          "is_bot": false,
          "headline": "handle dot paths on the output directory (#78)",
          "author_name": "Bradley Weston",
          "author_login": "bweston92",
          "committed_at": "2022-12-30T04:57:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b7cb7995a131262d794e6704a5c807606c306a73",
          "body": null,
          "is_bot": false,
          "headline": "Upgrade postgres version to 15 in test docker image",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-12-16T01:20:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ef6fa918bb8e2ae86851be77fb84fdab61409843",
          "body": null,
          "is_bot": false,
          "headline": "Add explain plan support for Postgres 14 (#76)",
          "author_name": "Amari Robinson",
          "author_login": "amari",
          "committed_at": "2022-12-16T01:15:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4e47108cde7ec44ee49efda8b670e550309e81e6",
          "body": "Previously, if a query returned a single nullable column, pggen would\r\nreturn the correct type *string, but only because we took the address\r\nof the input.\r\n\r\nBad code:\r\n\r\n\tvar item string\r\n\tif err := row.Scan(&item); err != nil {\r\n\t\treturn &item, fmt.Errorf(\"query StringAggFirstName: %w\", err)\r\n\t}\r\n\treturn &item, nil\r\n\r\nFixed code:\r\n\r\n\tvar item *string\r\n\tif err := row.Scan(&item); err != nil {\r\n\t\treturn item, fmt.Errorf(\"query StringAggFirstName: %w\", err)\r\n\t}\r\n\treturn item, nil\r\n\r\nFixes #75.",
          "is_bot": false,
          "headline": "Fix result type decl for nullable :one queries (#77)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-12-16T00:59:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f664a918378a9de8e912417ad07eeed98fc17404",
          "body": "This is an attempt to repro #75. The nullability is working as intended.\nThe OutputColumn has nullable=true. I suspect the issue occurs when\ntemplating the query for the :one case since the :many case work as\nexpected.",
          "is_bot": false,
          "headline": "Add pginfer test for aggregating a non-null column",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-12-15T23:58:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0abc8830f4dd120c5b5c5818622dd3d79bab7fde",
          "body": "Since go 1.16, `ioutil` has been deprecated. Its use triggers warnings\r\nwhen linting with `golangci-lint`.\r\n\r\nMigrate from `ioutil` to `io` and `os`, as specified at:\r\nhttps://go.dev/doc/go1.16#ioutil",
          "is_bot": false,
          "headline": "refactor: remove deprecated ioutil (#72)",
          "author_name": "Jacques Dafflon",
          "author_login": "0xjac",
          "committed_at": "2022-08-18T17:15:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "176eeb1d7651598f6ecc3e0ce157cdaa47c7b5e1",
          "body": "Adds the field names when instantiating the `compositeField` and\r\n`textPreferrer` struct in the generated code.\r\n\r\nThis allows to run the fieldalignment linter without errors on the\r\ngenerated code.",
          "is_bot": false,
          "headline": "fix: use struct field names in generated code (#71)",
          "author_name": "Jacques Dafflon",
          "author_login": "0xjac",
          "committed_at": "2022-08-18T17:12:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "92ff9121ffbadbaba2a0eef713500334a750a88f",
          "body": null,
          "is_bot": false,
          "headline": "Fix typo.",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-07-17T07:26:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4ac3aef27ef385ebad5789be41c6ac2da4e7718b",
          "body": null,
          "is_bot": false,
          "headline": "Update readme with new download instructions.",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-07-17T07:20:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "276211556f4d83708b56d281d75c63695ecfd78e",
          "body": "GitHub releaser stopped working.",
          "is_bot": false,
          "headline": "Switch to GoReleaser",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-07-17T06:59:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c97b1bd606b2503a7f9153680ca6d74f3460903a",
          "body": "Previously, we unwrapped the type before running QualifyType which meant we\nlost the import path. Run QualifyType on the original type before unwrapping.\n\nFixes #67.",
          "is_bot": false,
          "headline": "Fix custom user type declaration inside composite type.",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-07-17T05:56:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b7cb617f2b20bd644f621c30a4c249125011f5f6",
          "body": "The main trick is to SELECT FROM the function which converts the record\r\ntype into proper postgres columns.\r\n\r\nFixes #25.",
          "is_bot": false,
          "headline": "Add example for querying with function out parameters (#64)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-30T06:47:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "50da59827af5e467529487c09d7dcd8651048b28",
          "body": "Previously, we would attempt to create a newArrayInit function, but instead we\r\ncan use the pgtype array variants, like pgtype.BoolArray.",
          "is_bot": false,
          "headline": "Fix primitive array types inside a composite type (#63)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-30T06:07:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8c321e695369a01afe2a51091498355134aff23c",
          "body": null,
          "is_bot": false,
          "headline": "Add more logging to release script",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-26T05:46:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7eb2a5bb4513e1281d52e76d7f723729ff28140e",
          "body": "Fixes #45.",
          "is_bot": false,
          "headline": "Add nullability inference test for update query with returning (#62)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-22T23:25:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "133aca8dd4d9b5e96d71f030b8095abce1060a22",
          "body": "Most of the groundwork was in #60. Add a test to make sure it works. Custom type\r\nsupport is probably still dodgy. I suspect the code will compile, but you'd have\r\nto implement the pgx.ValueTranscoder interface for it to actually work.\r\n\r\nFixes #43.",
          "is_bot": false,
          "headline": "Fix imported types with slices and pointers (#61)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-22T23:22:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2489d54a806652d73f2c83bb5736a7574582092c",
          "body": "Previously, pggen struggled with types like `[]*time.Time`. Use a proper parse\r\ntree with nodes for pointers and arrays. The output should be a no-op; this\r\nis an internal change.",
          "is_bot": false,
          "headline": "Make type parsing more robust (#60)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-22T08:32:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "80ac24d15306681e36e827a3f631e065d1b5ae60",
          "body": null,
          "is_bot": false,
          "headline": "Update golangci-lint to fix error (#59)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-22T07:07:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0c474a61b820bc89bf9242b92d371a7063f5646f",
          "body": "As discussed in https://github.com/jschaf/pggen/issues/55",
          "is_bot": false,
          "headline": "Suggest a better IDE Integration (#56)",
          "author_name": "Benjamin Thomas",
          "author_login": "benjamin-thomas",
          "committed_at": "2022-04-28T18:30:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1266d15e85c54237d9b58b1a701acd5274bc2c45",
          "body": null,
          "is_bot": false,
          "headline": "Add non-nullability support for LIMIT queries",
          "author_name": "djsavvy",
          "author_login": null,
          "committed_at": "2022-02-05T22:54:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "43bad0138c31130afd69dc90f208dfc278bde484",
          "body": "Relates to #51.",
          "is_bot": false,
          "headline": "Attempt to limit release to push on main branch",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-02-05T22:40:17Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7f878880d5f9f7d25dec867850c6831e8c4402e7",
          "body": "The main trick is to specify the override on NewQuerierConfig and not on\nConnInfo.RegisterDataType. We can't easily get the data types for pgxpool.Pool\nbecause we need to get a real *Conn which then fetches a connection from the\n pool.\n\nPartially resolves #39.",
          "is_bot": false,
          "headline": "Add example of custom numeric type",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-09-07T02:29:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e7492c17d64fc11117eab2338e753b0a95b8808c",
          "body": "pggen surfaces constraint violations for a query that returns no rows but\nis marked :one or :many instead of :exec, like:\n\n    -- name: Foo :one\n    UPDATE foo SET bar = 1;\n\npggen needs at least one output column result type for :one and :many queries.\nPostgres happily provides the types even if the\n[…]\nis marked :one).\n              Use :exec if you don't need the query output.\n        ERROR: null value in column \"display_name\" of relation \"item_current\" violates not-null constraint (SQLSTATE 23502)",
          "is_bot": false,
          "headline": "Add hint for :one and :many queries with no output columns",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-08-31T18:55:52Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "43bb88da5ee99ad332801a87b5c7a654c3fd7983",
          "body": "- Handle undefined $TMPDIR.\n- Have curl show errors.\n- Fix install when cwd is ~/bin.",
          "is_bot": false,
          "headline": "Fix README install commands",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-08-23T06:55:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "df3838f1b99bed22dfc60be03a63ca0cb1b4b84a",
          "body": "I want to allow for custom implementations of batch functionality. I\nspecifically need it to allow for customizing the generated SQL. By implementing\ngenericConn, we can modify the SQL that's sent with conn.SendBatch.\n\nFor Query, QueryRow, and Exec, we can implement genericConn for similar hooks.\nBut since *pgx.Batch is a struct, we can't override it. By using an interface,\nwe can pass a custom wrapper over *pgx.Batch.",
          "is_bot": false,
          "headline": "Use genericBatch in place of *pgx.Batch",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-08-23T06:15:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bd75a04698056d56b4d8a78c830d12046931abac",
          "body": null,
          "is_bot": false,
          "headline": "Fix doc comments mentioning bibtex",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-08-23T05:41:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8d43ddabaecf1bee035c69ab062092b3ec6a0e03",
          "body": "Without the `cmd/pggen` suffix the source is downloaded, but it is not actually compiled into a binary.",
          "is_bot": false,
          "headline": "Update `go get` URL in README to actually install the command",
          "author_name": "Savvy Raghuvanshi",
          "author_login": null,
          "committed_at": "2021-06-22T01:54:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cece7af82c5f4d9505ba6393784bbdf4a41590a2",
          "body": "Fixes #30.",
          "is_bot": false,
          "headline": "Add pggen version command",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-05-17T09:13:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0a4051d6de72ef0712b69f8522864684bab608af",
          "body": "Instead of making a proper parser that understands expressions, hardcode logic\nto match \"pggen.arg (\".\n\nFixes #34.",
          "is_bot": false,
          "headline": "Allow 1 space after pggen.arg during parsing",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-05-17T08:34:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6570c99972a92ea42400767acec6349cf5d9ec38",
          "body": "Really, I'd like something akin to httptrace in the Go stdlib but settle for\nthis as a light-weight stop-gap.",
          "is_bot": false,
          "headline": "Add context value with key \"pggen_query_name\"",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-29T05:59:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f36faea3a3270b81438dc3b6ca980a76806abf50",
          "body": null,
          "is_bot": false,
          "headline": "Remove unneeded textPreferrer wrapping around composite init factory",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-27T07:22:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a5b736dcd4dfe103b03fec076be17e072a3d5853",
          "body": "The bug occurs when a file alpha.sql creates a declarer that bravo.sql doesn't\nneed. When pggen templates bravo.sql, it throws away all previous declarers.",
          "is_bot": false,
          "headline": "Fix declarers from being clobbered by later files",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-26T20:03:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "45e3a27b07b34fdb55569c27128814379f4f2aee",
          "body": null,
          "is_bot": false,
          "headline": "Remove statik from contributing instructions",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-26T17:30:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0056cfbec4a2258e1e0d14a9464613861a06e551",
          "body": "Allows overriding the ValueTranscoder used by type name with NewQuerierConfig.\nWe can't use the native RegisterDataType because Querier works with pgx.Conn,\nor pgxpool.Pool which both have query methods but don't both share ConnInfo.\n\n- Upgrade pgtype for https://github.com/jackc/pgx/issues/874.\n\nRelates to #29 in that it lays the ground work for customizing types.",
          "is_bot": false,
          "headline": "Introduce typeResolver for choosing ValueTranscoders",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-26T08:37:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ddb0c0b95aa0b46f9f9008d6d564e8285eea49c5",
          "body": null,
          "is_bot": false,
          "headline": "Update pgx to 4.11.0",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-23T22:35:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6a707032170fc6fa0e50314f228fd5aba0c13d17",
          "body": "For a type SomeTable:\n\n- newSomeTable creates an uninitialized pgtype.ValueTranscoder that can decode\n  the type.\n- newSomeTableInit creates an initialized pgtype.ValueTranscoder that can decode\n  that's initialized using the raw variants through the Set method.\n- newSomeTableRaw creates the raw form of the type so that we can pass it to the\n  pgtype.ValueTranscoder Set method.",
          "is_bot": false,
          "headline": "Rename declarers for input types to Raw and Init",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-23T22:25:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "513d781304bc110383eaa2c7a8ec98c7e802e2a7",
          "body": null,
          "is_bot": false,
          "headline": "Fix doc comment for gotype.FindKnownTypePgx",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-23T22:21:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "26426a3afd0651dbd94d93255dae0aa85eb336f9",
          "body": "The triple nesting fails with the pgx bug so skip it.\n\nRelates to #29.",
          "is_bot": false,
          "headline": "Add test for int array and triply nested params",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T23:44:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cc7780010fc7b10e07514ad6cac713fecb06aaa2",
          "body": "- Generate an assigner for every composite and array type to avoid duplicating\n  logic in the encoder and assigner methods.\n- When calling the array assigner, correctly delegate to the elem assigner if\n  necessary.\n\nRelates to #29.",
          "is_bot": false,
          "headline": "Fix params that are arrays of composite types",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T23:39:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "21dddeee1e1db65f5e40175cec14a4bb552a4792",
          "body": "When using the pgtype.Value Set method, we have to use interface{} slices all\nthe way down. Create \"assigner\" functions that create an []interface slice for\ncomposite and array types that we can use from the top level encoder functions.\n\nRelates to #29.",
          "is_bot": false,
          "headline": "Fix decoding nested composite types.",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T23:13:19Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b25f3a599cd304b30c2071b0044bcc61e195f258",
          "body": "Relates to #29.",
          "is_bot": false,
          "headline": "Add test example for composite types in query params",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T22:12:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7603c3867d2881889b97b6f89343f6c6884f468c",
          "body": "This supports using composite and array types in pggen.arg functions, i.e. as\nquery parameters.\n\nRelated to #29.",
          "is_bot": false,
          "headline": "Declare query param formatter for composite and array types",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T22:10:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8c7ce3994a542fedfcef9f390d7fac502129b2ac",
          "body": "We need the underlying gotype to choose appropriate encoders. For a composite\ntype, we'll wrap the expression in a encode<CompositeType> call.",
          "is_bot": false,
          "headline": "Add Type to TemplateParam",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T22:04:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9df1767bf2a6db97508d1dd9e8c0d4efb3c575b9",
          "body": "We generate different declaration based on whether the type is an input or\noutput param. An input param needs all output params and the textEncoder.\n\nThe purpose of this change is to avoid generating unnecessary methods.",
          "is_bot": false,
          "headline": "Split FindDeclarers to FindInputDeclarers and FindOutputDeclarers",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T22:02:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "01bb30bcb7e4395240483fe2894e15e0c3f266bc",
          "body": "We need to wrap the pgtype.ValueTranscoder so we can set the preferred param\nformat to text. We need to encode params as text because we don't have the OIDs\nof the types. The Postgres binary format requires OIDs.",
          "is_bot": false,
          "headline": "Add NewTextEncoderDeclarer",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T21:57:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "346ef9a484756bbe7844dc3ab7a2db227354762b",
          "body": null,
          "is_bot": false,
          "headline": "Fix composite decoder with array field",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T07:50:34Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "65057b212abc55f1e60259a87f26e3bbd79c4f42",
          "body": null,
          "is_bot": false,
          "headline": "Use assignTo instead of unsafe for enum arrays",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T07:02:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c36d0826361ca21d83834dd0ea387c26778cd9a3",
          "body": null,
          "is_bot": false,
          "headline": "Use declarers for result init in generated code",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T06:56:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "096602fc0d6cfa0707c8ada6d5b8bf6d2eeaac7b",
          "body": "Not used yet. We'll enable in the next few PRs.",
          "is_bot": false,
          "headline": "Add array decoder declarer",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T06:46:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e58e85d897d90cdaed35c9c15ada701146934e1f",
          "body": null,
          "is_bot": false,
          "headline": "Move enum and composite declarers to separate files",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T05:45:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "746d952234f00da2326b6d3b5deab50280b1f375",
          "body": "Once we land array decoders, we'll convert the all generated code to use these\ndecoder factories.",
          "is_bot": false,
          "headline": "Add EnumDecoderDeclarer as replacement for emitting custom decoders",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T05:37:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 6,
      "commits_last_year": 21,
      "latest_release_at": "2026-07-20T13:14:28Z",
      "latest_release_tag": "v0.2.0",
      "releases_from_tags": true,
      "days_since_last_push": 8,
      "active_weeks_last_year": 4,
      "days_since_latest_release": 8,
      "mean_days_between_releases": 14.8
    },
    "community": {
      "has_readme": false,
      "has_license": false,
      "has_description": false,
      "has_contributing": false,
      "health_percentage": null,
      "has_issue_template": false,
      "has_code_of_conduct": false,
      "has_pull_request_template": false
    },
    "ecosystem": {
      "packages": [
        {
          "name": "github.com/meoyawn/pggen",
          "exists": true,
          "license": null,
          "keywords": [],
          "ecosystem": "go",
          "matches_repo": true,
          "registry_url": "https://pkg.go.dev/github.com/meoyawn/pggen",
          "is_deprecated": false,
          "latest_version": "v0.2.0",
          "repository_url": "https://github.com/meoyawn/pggen",
          "versions_count": 6,
          "total_downloads": null,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": null,
          "first_published_at": null,
          "latest_published_at": "2026-07-20T13:14:28Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 8
        }
      ]
    },
    "popularity": {
      "forks": 0,
      "stars": 1,
      "watchers": 0,
      "fork_history": {
        "days": [],
        "complete": true,
        "collected": 0,
        "total_forks": 0
      },
      "star_history": null,
      "open_issues_and_prs": 0
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [
        "example"
      ],
      "has_llms_txt": false,
      "has_dockerfile": true,
      "has_mcp_signal": false,
      "bootstrap_files": [
        "Taskfile.yaml"
      ],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [],
      "toolchain_manifests": [
        "go.mod"
      ],
      "largest_source_bytes": 19008,
      "source_files_sampled": 131,
      "oversized_source_files": 0,
      "agent_instruction_files": [],
      "agent_instruction_max_bytes": null
    },
    "dependencies": {
      "manifests": [
        "go.mod"
      ],
      "advisories": {
        "error": null,
        "scope": null,
        "source": null,
        "findings": [],
        "collected": false,
        "malicious": [],
        "truncated": false,
        "by_severity": {},
        "advisory_count": 0,
        "affected_count": 0,
        "assessed_count": 0,
        "malicious_count": 0,
        "assessed_package": null,
        "unassessed_count": 0,
        "direct_affected_count": 0
      },
      "ecosystems": [
        "go"
      ],
      "dependencies": [
        {
          "name": "github.com/bmatcuk/doublestar",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.3.4"
        },
        {
          "name": "github.com/docker/docker",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v28.5.2+incompatible"
        },
        {
          "name": "github.com/docker/go-connections",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.7.0"
        },
        {
          "name": "github.com/google/go-cmp",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.7.0"
        },
        {
          "name": "github.com/jackc/pgx/v5",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v5.10.0"
        },
        {
          "name": "github.com/peterbourgon/ff/v3",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v3.4.0"
        },
        {
          "name": "github.com/stretchr/testify",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.11.1"
        },
        {
          "name": "golang.org/x/mod",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.37.0"
        }
      ],
      "all_dependencies": {
        "error": "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository",
        "source": null,
        "packages": [],
        "collected": false,
        "truncated": false,
        "total_count": null,
        "direct_count": null,
        "indirect_count": null
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 0,
        "merged_prs": 0,
        "open_issues": 0,
        "closed_ratio": 1,
        "closed_issues": 4,
        "closed_unmerged_prs": 0
      },
      "bus_factor": 1,
      "bot_contributors": 0,
      "top_contributors": [
        {
          "type": "User",
          "login": "jschaf",
          "commits": 494,
          "avatar_url": "https://avatars.githubusercontent.com/u/22385?v=4"
        },
        {
          "type": "User",
          "login": "meoyawn",
          "commits": 21,
          "avatar_url": "https://avatars.githubusercontent.com/u/1594148?v=4"
        },
        {
          "type": "User",
          "login": "0xjac",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/2848217?v=4"
        },
        {
          "type": "User",
          "login": "amari",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/534126?v=4"
        },
        {
          "type": "User",
          "login": "benjamin-thomas",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/1557738?v=4"
        },
        {
          "type": "User",
          "login": "bweston92",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/1764057?v=4"
        },
        {
          "type": "User",
          "login": "td0m",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/30264244?v=4"
        },
        {
          "type": "User",
          "login": "farazfazli",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/8684210?v=4"
        },
        {
          "type": "User",
          "login": "darkxanter",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/5780198?v=4"
        },
        {
          "type": "User",
          "login": "ngld",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/5465775?v=4"
        }
      ],
      "contributors_sampled": 10,
      "top_contributor_share": 0.943
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "go_lint.yaml",
        "go_test.yaml"
      ],
      "has_docs_dir": false,
      "linter_configs": [
        ".golangci.yaml"
      ],
      "has_editorconfig": false,
      "has_linter_config": true,
      "has_precommit_config": false
    },
    "security_signals": {
      "lockfiles": [
        "go.sum"
      ],
      "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": 0,
            "reason": "branch protection not enabled on development/release branches",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
          },
          {
            "name": "CI-Tests",
            "score": null,
            "reason": "no pull request found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
          },
          {
            "name": "CII-Best-Practices",
            "score": 0,
            "reason": "no effort to earn an OpenSSF best practices badge detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
          },
          {
            "name": "Code-Review",
            "score": 0,
            "reason": "Found 0/30 approved changesets -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 6,
            "reason": "project has 2 contributing companies or organizations -- score normalized to 6",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
          },
          {
            "name": "Dangerous-Workflow",
            "score": 10,
            "reason": "no dangerous workflow patterns detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
          },
          {
            "name": "Dependency-Update-Tool",
            "score": 0,
            "reason": "no update tool detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
          },
          {
            "name": "Fuzzing",
            "score": 0,
            "reason": "project is not fuzzed",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
          },
          {
            "name": "License",
            "score": 10,
            "reason": "license file detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
          },
          {
            "name": "Maintained",
            "score": 0,
            "reason": "project was created within the last 90 days. Please review its contents carefully",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
          },
          {
            "name": "Packaging",
            "score": null,
            "reason": "packaging workflow not detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
          },
          {
            "name": "Pinned-Dependencies",
            "score": 0,
            "reason": "dependency not pinned by hash detected -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
          },
          {
            "name": "SAST",
            "score": 0,
            "reason": "no SAST tool detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
          },
          {
            "name": "Security-Policy",
            "score": 0,
            "reason": "security policy file not detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
          },
          {
            "name": "Signed-Releases",
            "score": null,
            "reason": "no releases found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
          },
          {
            "name": "Token-Permissions",
            "score": 0,
            "reason": "detected GitHub workflow tokens with excessive permissions",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
          },
          {
            "name": "Vulnerabilities",
            "score": 1,
            "reason": "9 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "9fc19c8979eb3592baa02c4af91db9d1fc7b0d15",
        "ran_at": "2026-07-29T08:48:33Z",
        "aggregate_score": 2.5,
        "scorecard_version": "v5.5.0"
      },
      "has_codeql_workflow": false,
      "has_security_policy": false,
      "has_dependabot_config": false
    },
    "contribution_flow": {
      "collected": true,
      "ci_last_run_at": null,
      "oldest_open_prs": [],
      "last_merged_pr_at": null,
      "ci_last_conclusion": null,
      "oldest_open_issues": []
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/meoyawn/pggen",
    "host": "github.com",
    "name": "pggen",
    "owner": "meoyawn"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "at_risk",
      "name": "Overall health",
      "note": null,
      "notes": [],
      "value": 46,
      "inputs": {
        "security": 25,
        "vitality": 62,
        "community": 12,
        "governance": 64,
        "engineering": 52
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "moderate",
        "name": "Vitality",
        "value": 62,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "at_risk",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 44,
            "inputs": {
              "commits_last_year": 21,
              "human_commit_share": 1,
              "days_since_last_push": 8,
              "active_weeks_last_year": 4
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 8 days ago",
                "points": 28.8,
                "status": "partial",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 8
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "4/52 weeks with commits",
                "points": 2.8,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 4
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "21 commits in the last year",
                "points": 12.1,
                "status": "partial",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 21
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "project was created within the last 90 days. Please review its contents carefully",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "release_discipline",
            "band": "excellent",
            "name": "Release discipline",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 88,
            "inputs": {
              "releases_count": 6,
              "latest_release_tag": "v0.2.0",
              "releases_from_tags": true,
              "days_since_latest_release": 8,
              "mean_days_between_releases": 14.8
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "6 version tags (no GitHub releases)",
                "points": 16.2,
                "status": "partial",
                "details": [
                  {
                    "code": "version_tags_no_releases",
                    "params": {
                      "count": 6
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 8 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 8
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~14.8 days",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 14.8
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "openssf_scorecard_signed_releases",
                "name": "OpenSSF Scorecard: Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 10
              }
            ]
          },
          {
            "key": "abandonment",
            "band": "excellent",
            "name": "Abandonment",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "cap": null,
              "state": "unverified",
              "guards": [],
              "signals": [],
              "red_flag": false,
              "multiplier_pct": 100,
              "declared_reason": null,
              "unverified_reason": "repository_too_young",
              "unanswered_open_prs": null,
              "unanswered_open_issues": null,
              "days_since_last_merged_pr": null,
              "days_since_last_human_commit": null,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "maintenance record not established from the collected data",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_unverified",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Is the project alive — is code being written and are releases shipping?"
      },
      {
        "key": "community",
        "band": "critical",
        "name": "Community & Adoption",
        "value": 12,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "critical",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 1,
            "inputs": {
              "forks": 0,
              "stars": 1,
              "watchers": 0,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "1 stars",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 1
                    }
                  }
                ],
                "max_points": 60
              },
              {
                "key": "forks",
                "name": "Forks",
                "detail": "0 forks",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "forks",
                    "params": {
                      "count": 0
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "watchers",
                "name": "Watchers",
                "detail": "0 watchers",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "watchers",
                    "params": {
                      "count": 0
                    }
                  }
                ],
                "max_points": 15
              }
            ]
          },
          {
            "key": "community_health",
            "band": "critical",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 25,
            "inputs": {
              "has_readme": false,
              "has_license": false,
              "has_contributing": false,
              "has_issue_template": false,
              "has_code_of_conduct": false,
              "has_pull_request_template": false
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 22.5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "recognized license (MIT)",
                "points": 22.5,
                "status": "met",
                "details": [
                  {
                    "code": "license_standard",
                    "params": {}
                  },
                  {
                    "code": "license_spdx",
                    "params": {
                      "spdx": "MIT"
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributing_guide",
                "name": "CONTRIBUTING guide",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 18
              },
              {
                "key": "code_of_conduct",
                "name": "Code of conduct",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 13.5
              },
              {
                "key": "issue_template",
                "name": "Issue template",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.2
              },
              {
                "key": "pr_template",
                "name": "PR template",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.3
              }
            ]
          }
        ],
        "description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
      },
      {
        "key": "governance",
        "band": "moderate",
        "name": "Sustainability & Governance",
        "value": 64,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "at_risk",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 30,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 10,
              "top_contributor_share": 0.943
            },
            "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 94% of commits",
                "points": 1.3,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 94
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "10 contributors",
                "points": 13.5,
                "status": "met",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 10
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 2 contributing companies or organizations -- score normalized to 6",
                "points": 6,
                "status": "partial",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "good",
            "name": "Issue & PR responsiveness",
            "note": "Excluded from scoring (no data or not applicable): PR acceptance. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "pr_acceptance"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 76,
            "inputs": {
              "merged_prs": 0,
              "open_issues": 0,
              "closed_issues": 4,
              "issue_closed_ratio": 1,
              "closed_unmerged_prs": 0
            },
            "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": "no decided pull requests or no data",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_decided_prs_or_data",
                    "params": {}
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 0/30 approved changesets -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              }
            ]
          },
          {
            "key": "stewardship",
            "band": "moderate",
            "name": "Ownership & stewardship",
            "note": "Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "verified_domain"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 63,
            "inputs": {
              "followers": 138,
              "owner_type": "User",
              "is_verified": null,
              "owner_login": "meoyawn",
              "public_repos": 57,
              "account_age_days": 5232
            },
            "components": [
              {
                "key": "ownership_backing",
                "name": "Ownership backing",
                "detail": "personal (user) account",
                "points": 10,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_personal",
                    "params": {}
                  }
                ],
                "max_points": 30
              },
              {
                "key": "verified_domain",
                "name": "Verified domain",
                "detail": "not applicable to user accounts",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "not_applicable_to_user_accounts",
                    "params": {}
                  }
                ],
                "max_points": 20
              },
              {
                "key": "owner_reach",
                "name": "Owner reach",
                "detail": "138 followers of meoyawn",
                "points": 15.4,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 138,
                      "login": "meoyawn"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "57 public repos, account ~14 yr old",
                "points": 24.8,
                "status": "partial",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 57
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 14
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "excellent",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "packages": [
                "github.com/meoyawn/pggen"
              ],
              "ecosystems": "go",
              "any_deprecated": false,
              "min_days_since_publish": 8
            },
            "components": [
              {
                "key": "published_resolvable",
                "name": "Published & resolvable",
                "detail": "1 package(s) on go",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "packages_published",
                    "params": {
                      "count": 1,
                      "ecosystems": "go"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "publish_recency",
                "name": "Publish recency",
                "detail": "latest publish 8 days ago",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 8
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "6 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 6
                    }
                  }
                ],
                "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": "moderate",
        "name": "Engineering Quality",
        "value": 52,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "good",
            "name": "Engineering practices",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: CI-Tests. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_ci_tests"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 80,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": true,
              "has_precommit_config": false
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "2 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 2
                    }
                  }
                ],
                "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": ".golangci.yaml",
                "points": 16,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".golangci.yaml"
                    }
                  }
                ],
                "max_points": 16
              },
              {
                "key": "pre_commit_hooks",
                "name": "Pre-commit hooks",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 9.6
              },
              {
                "key": "editorconfig",
                "name": ".editorconfig",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.4
              },
              {
                "key": "openssf_scorecard_ci_tests",
                "name": "OpenSSF Scorecard: CI-Tests",
                "detail": "no pull request found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "critical",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 10,
            "inputs": {
              "topics": [],
              "has_wiki": true,
              "homepage": null,
              "has_readme": false,
              "has_docs_dir": false,
              "has_description": false
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 30
              },
              {
                "key": "documentation_directory",
                "name": "Documentation directory",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 25
              },
              {
                "key": "documentation_homepage_site",
                "name": "Documentation / homepage site",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              },
              {
                "key": "repository_description",
                "name": "Repository description",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              },
              {
                "key": "topics",
                "name": "Topics",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              },
              {
                "key": "wiki",
                "name": "Wiki",
                "detail": null,
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          }
        ],
        "description": "Are baseline engineering and documentation practices in place?"
      },
      {
        "key": "security",
        "band": "critical",
        "name": "Security",
        "value": 25,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "critical",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): CI-Tests, Packaging, Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "ci_tests",
                    "packaging",
                    "signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 25,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 15,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 3,
              "scorecard_aggregate": 2.5
            },
            "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 not enabled on development/release branches",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "ci_tests",
                "name": "CI-Tests",
                "detail": "no pull request found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 2.5
              },
              {
                "key": "cii_best_practices",
                "name": "CII-Best-Practices",
                "detail": "no effort to earn an OpenSSF best practices badge detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "code_review",
                "name": "Code-Review",
                "detail": "Found 0/30 approved changesets -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 2 contributing companies or organizations -- score normalized to 6",
                "points": 1.5,
                "status": "partial",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "dangerous_workflow",
                "name": "Dangerous-Workflow",
                "detail": "no dangerous workflow patterns detected",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "dependency_update_tool",
                "name": "Dependency-Update-Tool",
                "detail": "no update tool detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "fuzzing",
                "name": "Fuzzing",
                "detail": "project is not fuzzed",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "license file detected",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "maintained",
                "name": "Maintained",
                "detail": "project was created within the last 90 days. Please review its contents carefully",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "packaging",
                "name": "Packaging",
                "detail": "packaging workflow not detected",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 5
              },
              {
                "key": "pinned_dependencies",
                "name": "Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "sast",
                "name": "SAST",
                "detail": "no SAST tool detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "security_policy",
                "name": "Security-Policy",
                "detail": "security policy file not detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "signed_releases",
                "name": "Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 7.5
              },
              {
                "key": "token_permissions",
                "name": "Token-Permissions",
                "detail": "detected GitHub workflow tokens with excessive permissions",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "vulnerabilities",
                "name": "Vulnerabilities",
                "detail": "9 existing vulnerabilities detected",
                "points": 0.8,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              }
            ]
          },
          {
            "key": "high_risk_jurisdiction_exposure",
            "band": "excellent",
            "name": "High-Risk Jurisdiction Exposure",
            "note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
            "notes": [
              {
                "code": "jurisdiction_evidence_limits",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "meaning": "self-published location evidence; not nationality or citizenship",
              "red_flag": false,
              "exposures": [],
              "policy_countries": [
                "Russia",
                "Iran",
                "North Korea"
              ],
              "review_only_matches": 0,
              "assessed_self_published_locations": 7
            },
            "components": [
              {
                "key": "policy_exposure_multiplier",
                "name": "Policy exposure multiplier",
                "detail": "no confirmed policy-scope location match",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "jurisdiction_no_match",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
      },
      {
        "key": "ai_readiness",
        "band": "moderate",
        "name": "AI Readiness",
        "value": 57,
        "weight": 0,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "critical",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 25,
            "inputs": {
              "has_llms_txt": false,
              "legible_history_share": 0.47,
              "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": "47 of 100 human commits state their intent (structured subject or explanatory body)",
                "points": 25.1,
                "status": "partial",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 47,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "good",
            "name": "Verify loop (build / test / typecheck)",
            "note": null,
            "notes": [],
            "value": 72,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [
                "go.sum"
              ],
              "has_dockerfile": true,
              "typed_language": true,
              "bootstrap_files": [
                "Taskfile.yaml"
              ],
              "has_devcontainer": false,
              "has_linter_config": true,
              "typecheck_configs": [],
              "agent_commit_share": 0,
              "toolchain_manifests": [
                "go.mod"
              ],
              "dependency_bot_commit_share": 0
            },
            "components": [
              {
                "key": "one_command_bootstrap",
                "name": "One-command bootstrap",
                "detail": "Taskfile.yaml",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "Taskfile.yaml"
                    }
                  }
                ],
                "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": ".golangci.yaml",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".golangci.yaml"
                    }
                  }
                ],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": "Go (statically typed)",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "statically_typed_language",
                    "params": {
                      "language": "Go"
                    }
                  }
                ],
                "max_points": 11
              },
              {
                "key": "reproducible_environment",
                "name": "Reproducible environment",
                "detail": "Dockerfile, lockfile",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "Dockerfile, lockfile"
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "demonstrated_agent_practice",
                "name": "Demonstrated agent practice",
                "detail": "no 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": "no automated dependency updates observed",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_dependency_automation",
                    "params": {}
                  }
                ],
                "max_points": 8
              },
              {
                "key": "openssf_scorecard_pinned_dependencies",
                "name": "OpenSSF Scorecard: Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "ai_code_legibility",
            "band": "excellent",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "primary_language": "Go",
              "largest_source_bytes": 19008,
              "source_files_sampled": 131,
              "oversized_source_files": 0
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "Go (statically typed)",
                "points": 45,
                "status": "met",
                "details": [
                  {
                    "code": "statically_typed_language",
                    "params": {
                      "language": "Go"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "0/131 source files over 60KB",
                "points": 55,
                "status": "met",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 131,
                      "oversized": 0
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          },
          {
            "key": "ai_interfaces",
            "band": "at_risk",
            "name": "Machine-readable interfaces",
            "note": null,
            "notes": [],
            "value": 40,
            "inputs": {
              "example_dirs": [
                "example"
              ],
              "has_mcp_signal": false,
              "api_schema_files": []
            },
            "components": [
              {
                "key": "api_schema_openapi_graphql_proto",
                "name": "API schema (OpenAPI/GraphQL/proto)",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 40
              },
              {
                "key": "mcp_server",
                "name": "MCP server",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 20
              },
              {
                "key": "runnable_examples",
                "name": "Runnable examples",
                "detail": "example",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "example"
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          }
        ],
        "description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
      }
    ],
    "metrics_version": "1.13.0"
  },
  "warnings": [
    "Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
    "Community profile unavailable",
    "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository"
  ],
  "report_type": "repository",
  "generated_at": "2026-07-29T08:48:42.168782Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/m/meoyawn/pggen.svg",
  "full_name": "meoyawn/pggen",
  "license_state": "standard",
  "license_spdx": "MIT"
}

Bewertungen sind Signale, keine Garantien. Sie spiegeln öffentlich sichtbare Praxis auf GitHub wider — kein Code-Audit und keine Sicherheitsgarantie.

Fehlende Daten werden ausgeschlossen und die Gewichte neu normiert, nie als null bewertet. Die Methodik ist versioniert und offen: Metriken v1.13.0, Schema v0.27.0 — vollständige Methodik · Metriken-Wiki.

Wie ein einzelnes Ergebnis im Gesamtregister steht: aggregierte StatistikenGo.