Öffentliches Register
Software-GesundheitsberichtSchema 0.27.0 · Metriken 2.3.1 · 2026-07-31 09:06 UTC

leonardovida / duckdb-sqlalchemy

Production-ready SQLAlchemy dialect for DuckDB and MotherDuck with operational defaults and migration support from duckdb_engine.

PythonMIT★ 16 Sterne⑂ 0 Forksseit Dez. 2025ForkAuf GitHub ansehen ↗

leonardovida/duckdb-sqlalchemy erreicht einen Gesundheitsindex von 71 von 100 und liegt damit im Bereich Gut. Am stärksten schneidet es bei Vitality (90/100) ab, am schwächsten bei Community & Adoption (22/100). Zuletzt heute aktualisiert. Ein einzelner Mitwirkender trägt den Großteil der jüngsten Arbeit.

71
gesamt / 100
Gut

Software-Gesundheitsindex

Metriken werden auf einer standardisierten Skala von 1–100 in gewichtete Kategorien gruppiert. Der Gesamtwert beginnt als ihr gewichtetes Mittel, kalibriert auf die Verteilung des öffentlichen Registers, sodass die Stufen Perzentilbedeutung tragen; sobald öffentliche Evidenz die Richtlinie für Hochrisikojurisdiktionen auslöst, wird die Bewertung angepasst und erhält die Obergrenze Gefährdet von 34.

71
Außergewöhnlich93-100Die Spitzengruppe des Registers (≈ obere 5 %); erfüllt im Wesentlichen alle geprüften Kriterien
Exzellent80-92Durchgehend stark; geringfügige Lücken
Gut65-79Gesund; Lücken sind begrenzt und beherrschbar
Mittel50-64Akzeptabel mit deutlichen Lücken; Überprüfung empfohlen
Schwach35-49Wesentliche Schwächen in mehreren Bereichen
Gefährdet20-34Erhebliche Schwächen; eine Übernahme erfordert Vorsicht
Kritisch1-19Schwerwiegende 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.

Der gewichtete Gesamtwert 63 wird auf der veröffentlichten Indexskala auf 71 kalibriert (Register-Kalibrierung 2026-08-02).

Eigentümerschaft

Leonardo VidaPersönliches Konto
39 Follower40 öffentliche Reposseit Okt. 2012@motherduckdb

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öffentlichtTags
PyPIduckdb-sqlalchemy1.5.4.7-27vor 0 Tagenanalyticsdatabasedialectduckdbmotherduckolapsqlalchemy

Metriken nach Kategorie

Vitalität

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

90Exzellent · 21 % des Gesamtindex
Wie die Bewertung erfolgt
36/36Push-Aktualität — letzter Push vor 0 Tagen
20.1/36Commit-Rhythmus — 29/52 Wochen mit Commits
18/18Commit-Volumen — 218 Commits im letzten Jahr
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
Verwendete Eingangsdaten
commits_last_year218
human_commit_share1
days_since_last_push0
active_weeks_last_year29

Release-Disziplin

100Außergewöhnlich
Wie die Bewertung erfolgt
27/27Liefert Releases aus — 27 Releases veröffentlicht
36/36Release-Aktualität — letztes Release vor 0 Tagen
27/27Release-Rhythmus — ein Release etwa alle 9 Tage
0/10OpenSSF Scorecard: Signed-Releases — keine Daten
Verwendete Eingangsdaten
releases_count27
latest_release_tagv1.5.4.7
releases_from_tagsnein
days_since_latest_release0
mean_days_between_releases9
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?

22Gefährdet · 17 % des Gesamtindex
Wie die Bewertung erfolgt
19.1/60Stars — 16 Stars
0/25Forks — 0 Forks
0/15Watcher — 0 Watcher
Verwendete Eingangsdaten
forks0
stars16
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
readme_badges
has_contributingnein
has_issue_templatenein
has_code_of_conductnein
readme_badge_services
has_pull_request_templatenein

Nachhaltigkeit & Governance

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

63Mittel · 23 % des Gesamtindex
Wie die Bewertung erfolgt
9/54Bus-Faktor — 1 Beitragende decken die Hälfte aller Commits ab
3.2/22.5Commit-Verteilung — wichtigste beitragende Person verfasste 86 % der Commits
13.5/13.5Breite der Beitragenden — 25 Beitragende
10/10OpenSSF Scorecard: Contributors — project has 10 contributing companies or organizations
Verwendete Eingangsdaten
bus_factor1
contributors_sampled25
top_contributor_share0,856
Wie die Bewertung erfolgt
33.6/42Issue-Lösungsquote — 80 % der Issues geschlossen
29.1/30PR-Annahme — 137/141 entschiedene PRs gemergt
0/13Newcomer PR acceptance — kein PR eines Erstbeitragenden in 30 Tagen entschieden
0/15OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0
Verwendete Eingangsdaten
merged_prs137
open_issues1
closed_issues4
prs_merged_7d
prs_decided_7d
prs_merged_30d
prs_decided_30d
issue_closed_ratio0,8
closed_unmerged_prs4
first_time_authors_30d
first_time_prs_merged_30d
first_time_prs_decided_30d
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): newcomer_pr_acceptance. 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
11.5/25Reichweite des Inhabers — 39 Follower von leonardovida
23.7/25Kontohistorie — 40 öffentliche Repos, Kontoalter ca. 13 Jahre
Verwendete Eingangsdaten
followers39
owner_typeUser
is_verified
owner_loginleonardovida
public_repos40
account_age_days5.033
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): Verifizierte Domain. Die verbleibenden Gewichte wurden renormalisiert.

Paketpflege

100Außergewöhnlich
Wie die Bewertung erfolgt
25/25Veröffentlicht & auflösbar — 1 Paket(e) auf pypi
35/35Veröffentlichungsaktualität — letzte Veröffentlichung vor 0 Tagen
20/20Versionshistorie — 27 veröffentlichte Versionen
20/20Nicht veraltet — aktiv, nicht veraltet oder zurückgezogen
Verwendete Eingangsdaten
packagesduckdb-sqlalchemy
ecosystemspypi
any_deprecatednein
min_days_since_publish0

Engineering-Qualität

Sind grundlegende Engineering- und Dokumentationspraktiken vorhanden?

79Gut · 19 % des Gesamtindex
Wie die Bewertung erfolgt
24/24CI-Workflows — 4 Workflow(s)
24/24Tests vorhanden
16/16Linter-Konfiguration
9.6/9.6Pre-Commit-Hooks
0/6.4.editorconfig
18/20OpenSSF Scorecard: CI-Tests — 29 out of 30 merged PRs checked by a CI test -- score normalized to 9
Verwendete Eingangsdaten
has_cija
has_testsja
has_editorconfignein
has_linter_configja
has_precommit_configja
Wie die Bewertung erfolgt
0/30README
25/25Dokumentationsverzeichnis
15/15Dokumentations-/Homepage-Site — https://leonardovida.github.io/duckdb-sqlalchemy/
0/10Repository-Beschreibung
10/10Topics — 11 Topics
10/10Wiki
Verwendete Eingangsdaten
topicsanalytics, database, dialect, duckdb, motherduck, olap, python, sqlalchemy, alembic, data-engineering, duckdb-engine-migration
has_wikija
homepagehttps://leonardovida.github.io/duckdb-sqlalchemy/
has_readmenein
has_docs_dirja
has_descriptionnein

Sicherheit

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

51Mittel · 16 % des Gesamtindex
Wie die Bewertung erfolgt
7.5/7.5Binary-Artifacts — no binaries found in the repo
2.2/7.5Branch-Protection — branch protection is not maximal on development and all release branches
2.2/2.5CI-Tests — 29 out of 30 merged PRs checked by a CI test -- score normalized to 9
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
2.5/2.5Contributors — project has 10 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5Lizenz — license file detected
7.5/7.5Maintained — 30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
5/5Packaging — packaging workflow detected
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
0/5SAST — SAST tool is not run on all commits -- score normalized to 0
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
3/7.5Vulnerabilities — 6 existing vulnerabilities detected
Verwendete Eingangsdaten
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate5,1
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): 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? Trägt ein bewusst kleines Gewicht (4 %): Agenten-Tooling ist ein echtes Pflegesignal, doch ein Repository ohne jedes Signal kann weiterhin 100/100 erreichen.

79Gut · 4 % des Gesamtindex

AI-Agentenkontext & Leitlinien

100Außergewöhnlich
Wie die Bewertung erfolgt
45/45Agentenanweisungen — AGENTS.md, CLAUDE.md
15/15Maschinenlesbare Doku (llms.txt) — llms.txt vorhanden
40/40Lesbare Commit-Historie — 84 von 100 menschlichen Commits benennen ihre Absicht (strukturierter Betreff oder erläuternder Text)
Verwendete Eingangsdaten
has_llms_txtja
legible_history_share0,84
agent_instruction_filesAGENTS.md, CLAUDE.md
agent_instruction_max_bytes2.595
Wie die Bewertung erfolgt
18/18Bootstrap mit einem Befehl — noxfile.py
22/22Automatisierte Tests
11/11Lint-/Format-Konfiguration
11/11Statische Typprüfung — duckdb_sqlalchemy/py.typed
10/10Reproduzierbare Umgebung — lockfile
0/10Belegte Agentenpraxis — keine von Agenten verfassten Commits unter den letzten 100
5/8Automatisierte Wartung — Abhängigkeits-Automatisierung konfiguriert, in den erfassten Commits nicht beobachtet
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Verwendete Eingangsdaten
has_nixnein
has_testsja
lockfilesuv.lock
has_dockerfilenein
typed_languagenein
bootstrap_filesnoxfile.py
has_devcontainernein
has_linter_configja
typecheck_configsduckdb_sqlalchemy/py.typed
agent_commit_share0
toolchain_manifests
dependency_bot_commit_share0
Wie die Bewertung erfolgt
27/45Typprüfbarer Code — Python mit Typprüfungs-Konfiguration (duckdb_sqlalchemy/py.typed)
52.1/55Handhabbare Dateigrößen — 2/38 Quelldateien über 60 KB
Verwendete Eingangsdaten
primary_languagePython
largest_source_bytes75.234
source_files_sampled38
oversized_source_files2
Wie die Bewertung erfolgt
0/40API-Schema (OpenAPI/GraphQL/proto)
0/20MCP-Server
40/40Lauffähige Beispiele — examples
Verwendete Eingangsdaten
example_dirsexamples
has_mcp_signalnein
api_schema_files

Eckdaten

16GitHub-Sterne
25Mitwirkende
218Commits, letzte 12 Monate
0Tage seit letztem Push
27Releases
1Bus-Faktor
1offene Issues
PyPIPaket-Ö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
  • deps.dev does not index pypi:duckdb-sqlalchemy@1.5.4.7; advisories assessed against the repository dependency graph instead

Weitere Details

OpenSSF Scorecard 5.1 / 10
5.1Gesamtwert

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-31 09:06 UTC

10Binary-Artifactsno binaries found in the repo
3Branch-Protectionbranch protection is not maximal on development and all release branches
9CI-Tests29 out of 30 merged PRs checked by a CI test -- score normalized to 9
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/30 approved changesets -- score normalized to 0
10Contributorsproject has 10 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
10Maintained30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
10Packagingpackaging workflow detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
0SASTSAST tool is not run on all commits -- score normalized to 0
0Security-Policysecurity policy file not detected
k. A.Signed-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
4Vulnerabilities6 existing vulnerabilities detected
Direkte Abhängigkeiten 4
RegistryPaketVersionsvorgabeManifest
PyPIduckdb>=0.5.0pyproject.toml
PyPIsqlalchemy>=2.0.0pyproject.toml
PyPIsqlalchemy>=2.0.45pyproject.toml
PyPIpackaging>=21pyproject.toml
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": [
        "analytics",
        "database",
        "dialect",
        "duckdb",
        "motherduck",
        "olap",
        "python",
        "sqlalchemy",
        "alembic",
        "data-engineering",
        "duckdb-engine-migration"
      ],
      "is_fork": true,
      "size_kb": 3871,
      "has_wiki": true,
      "homepage": "https://leonardovida.github.io/duckdb-sqlalchemy/",
      "languages": {
        "Python": 270900
      },
      "pushed_at": "2026-07-31T09:04:17Z",
      "created_at": "2025-12-11T22:45:33Z",
      "owner_type": "User",
      "updated_at": "2026-07-31T09:05:50Z",
      "description": "Production-ready SQLAlchemy dialect for DuckDB and MotherDuck with operational defaults and migration support from duckdb_engine.",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "main",
      "license_spdx_raw": "MIT",
      "primary_language": "Python",
      "significant_languages": [
        "Python"
      ]
    },
    "owner": {
      "blog": null,
      "name": "Leonardo Vida",
      "type": "User",
      "login": "leonardovida",
      "company": "@motherduckdb",
      "location": "Amsterdam",
      "followers": 39,
      "avatar_url": "https://avatars.githubusercontent.com/u/2588282?v=4",
      "created_at": "2012-10-18T10:09:34Z",
      "is_verified": null,
      "public_repos": 40,
      "account_age_days": 5033
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": false
    },
    "activity": {
      "releases": [
        {
          "tag": "v1.5.4.7",
          "kind": "other",
          "published_at": "2026-07-31T09:04:18Z"
        },
        {
          "tag": "v1.5.4.6",
          "kind": "other",
          "published_at": "2026-07-30T15:54:27Z"
        },
        {
          "tag": "v1.5.4.5",
          "kind": "other",
          "published_at": "2026-07-24T10:08:14Z"
        },
        {
          "tag": "v1.5.4.4",
          "kind": "other",
          "published_at": "2026-07-17T08:22:09Z"
        },
        {
          "tag": "v1.5.4.3",
          "kind": "other",
          "published_at": "2026-07-10T08:15:10Z"
        },
        {
          "tag": "v1.5.4.2",
          "kind": "other",
          "published_at": "2026-07-03T08:43:45Z"
        },
        {
          "tag": "v1.5.4.1",
          "kind": "other",
          "published_at": "2026-07-01T21:02:13Z"
        },
        {
          "tag": "v1.5.4",
          "kind": "patch",
          "published_at": "2026-06-26T09:00:28Z"
        },
        {
          "tag": "v1.5.3",
          "kind": "patch",
          "published_at": "2026-06-02T08:25:10Z"
        },
        {
          "tag": "v1.5.2.2",
          "kind": "other",
          "published_at": "2026-05-11T12:19:52Z"
        },
        {
          "tag": "v1.5.2.1",
          "kind": "other",
          "published_at": "2026-04-25T08:12:03Z"
        },
        {
          "tag": "v1.5.2",
          "kind": "patch",
          "published_at": "2026-04-17T09:16:10Z"
        },
        {
          "tag": "v1.5.1.4",
          "kind": "other",
          "published_at": "2026-04-10T16:58:32Z"
        },
        {
          "tag": "v1.5.1",
          "kind": "patch",
          "published_at": "2026-03-26T09:45:36Z"
        },
        {
          "tag": "v1.4.4.8",
          "kind": "other",
          "published_at": "2026-03-24T15:44:44Z"
        },
        {
          "tag": "v1.4.4.7",
          "kind": "other",
          "published_at": "2026-03-22T17:20:05Z"
        },
        {
          "tag": "v1.4.4.6",
          "kind": "other",
          "published_at": "2026-03-22T16:56:09Z"
        },
        {
          "tag": "v1.4.4.5",
          "kind": "other",
          "published_at": "2026-03-22T16:26:10Z"
        },
        {
          "tag": "v1.4.4.3",
          "kind": "other",
          "published_at": "2026-02-21T10:10:02Z"
        },
        {
          "tag": "v1.4.4.2",
          "kind": "other",
          "published_at": "2026-02-05T21:53:47Z"
        },
        {
          "tag": "v1.4.4.1",
          "kind": "other",
          "published_at": "2026-02-05T13:03:47Z"
        },
        {
          "tag": "v1.4.4",
          "kind": "patch",
          "published_at": "2026-02-03T10:06:38Z"
        },
        {
          "tag": "v1.4.3",
          "kind": "patch",
          "published_at": "2026-01-15T11:19:40Z"
        },
        {
          "tag": "v0.19.3",
          "kind": "patch",
          "published_at": "2025-12-28T11:16:45Z"
        },
        {
          "tag": "v0.19.2",
          "kind": "patch",
          "published_at": "2025-12-28T10:44:09Z"
        },
        {
          "tag": "v0.19.1",
          "kind": "patch",
          "published_at": "2025-12-26T22:24:54Z"
        },
        {
          "tag": "v0.19.0",
          "kind": "minor",
          "published_at": "2025-12-24T17:01:11Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "66f42bedbcfab7977a1c13bc6c1d636f7faee9c1",
          "body": null,
          "is_bot": false,
          "headline": "fix: reflect dotted schema names (#146)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-31T09:03:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a9759ddc2524953bc670b0aef428a50df130bc70",
          "body": null,
          "is_bot": false,
          "headline": "fix concurrent reserved word loading (#145)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-30T15:52:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7e8442274104dfc55ff8d6b277d9064a30d7e62f",
          "body": null,
          "is_bot": false,
          "headline": "refactor(olap): reuse legacy job mappings (#144)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-27T12:17:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7cf3b7c92685123afe68354701a31b716a1b3bdb",
          "body": null,
          "is_bot": false,
          "headline": "fix: support SQLAlchemy 2.1 (#143)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-24T10:07:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "da31175f3c622837f6c2db2c5da49584d58b3b2c",
          "body": null,
          "is_bot": false,
          "headline": "refactor: centralize implicit sequence ddl (#141)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-19T08:57:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2466081ec2786b80d87cb3c735b37ef37cec8cec",
          "body": null,
          "is_bot": false,
          "headline": "fix pooled connection invalidation (#140)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-17T08:20:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b6f2edb634773155e77855e8cb75b84abde9abd0",
          "body": null,
          "is_bot": false,
          "headline": "chore: align dependency checkers (#139)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-14T15:21:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "80cd74b2580fadd0f6e0d0a2ae63732a28d6fd41",
          "body": null,
          "is_bot": false,
          "headline": "fix MotherDuck Flight helper names (#138)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-10T08:14:19Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b3fb8aced59042a3763636cd8cf9c4be146dc3ea",
          "body": null,
          "is_bot": false,
          "headline": "refresh compatibility tools (#137)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-07T08:52:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d31163ddfa63e325752e971da8333d455f428a0a",
          "body": null,
          "is_bot": false,
          "headline": "add Dive status helper",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-06T15:12:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c126dc2ee096eef1facb1117c5767134aafcf988",
          "body": "Fix copy_from_rows header-mode row loss and prepare 1.5.4.2.",
          "is_bot": false,
          "headline": "fix copy_from_rows header mode",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-03T08:33:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1ed498439be9c7853f1ba54637375cb83136e3e1",
          "body": null,
          "is_bot": false,
          "headline": "refactor: centralize reflection result defaults (#133)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-02T20:56:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b03cb9b0b400fb7408209a0670825ac709bc7f44",
          "body": null,
          "is_bot": false,
          "headline": "refresh dive status metadata (#132)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-02T17:18:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1e9b9a00ea0b2d6f257da044b1771b27e44288fa",
          "body": null,
          "is_bot": false,
          "headline": "release 1.5.4.1 (#131)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-01T21:01:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "598ea0574d7aea130d15408a8089e8b941619561",
          "body": "…28) (#130)",
          "is_bot": false,
          "headline": "render implicit sequences instead of SERIAL for autoincrement PKs (#1…",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-07-01T20:58:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9d54f6d2aef35cbb58428e75aa0e2eff64105b85",
          "body": null,
          "is_bot": false,
          "headline": "refactor bulk row shaping (#129)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-28T15:34:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ac8d816568a2c5cd3eff294d0cdffa2bba3cd954",
          "body": null,
          "is_bot": false,
          "headline": "release 1.5.4",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-26T08:59:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8b1f7077fa1133ec2ca679bd5b0a7b98207a71bc",
          "body": null,
          "is_bot": false,
          "headline": "update duckdb 1.5.4 compatibility (#126)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-26T08:24:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d5a809c867fccbd578ad6ed5c2ee4cde018a70f6",
          "body": "Centralize DuckDB STRUCT/UNION field rendering and cover direct compiler use.",
          "is_bot": false,
          "headline": "refactor type field rendering",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-21T08:24:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7d4c175a6f89ae3c9a52dff45110b4363a499125",
          "body": null,
          "is_bot": false,
          "headline": "validate Flight config maps (#124)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-19T13:38:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d1746d38de8a7da762130642078b88016f225771",
          "body": null,
          "is_bot": false,
          "headline": "simplify execute retry wrapper",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-19T13:20:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a83e8bf293354f2264dd446845b16bbf19ac8a37",
          "body": null,
          "is_bot": false,
          "headline": "extract connect config prep (#122)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-16T13:02:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fade278209e9b391a861a0d63b6d301e90bbe20b",
          "body": null,
          "is_bot": false,
          "headline": "validate flight config keys (#121)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-16T11:09:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5230d01679150a8e77807b4adc3b5814bde3200d",
          "body": null,
          "is_bot": false,
          "headline": "update MotherDuck metadata helpers (#120)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-11T02:34:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "928d1cc3f510616da687cfcaee78033ecd2639fe",
          "body": null,
          "is_bot": false,
          "headline": "extract arrow result wrapper (#119)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-10T23:15:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9d2521587a1a35a2c1a60feb96f3c768ef3bb3d1",
          "body": "* centralize MotherDuck path query handling\n\n* use pypi codecov cli in ci",
          "is_bot": false,
          "headline": "[codex] centralize MotherDuck path query handling (#118)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-07T11:39:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a32b301c64eac43ccb057eccaba385aa2c145567",
          "body": "Refresh ty/Ruff development checker pins and lockfile after validation.",
          "is_bot": false,
          "headline": "refresh dev checker pins",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-05T12:51:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1858af375ebac47365f52868f00cb11b988aa886",
          "body": null,
          "is_bot": false,
          "headline": "add MotherDuck flight helpers (#116)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-05T08:13:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2e9c3412830fc7d245974cefef1dab214db74627",
          "body": null,
          "is_bot": false,
          "headline": "handle application names and refresh ty (#115)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-02T18:57:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "201c62426ab702b6c3236543259dece61c04f9a1",
          "body": null,
          "is_bot": false,
          "headline": "align release ty pin",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-02T08:23:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1440c8c1d803ee3ca174de34bb9bff916bfe3841",
          "body": null,
          "is_bot": false,
          "headline": "release 1.5.3",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-02T08:21:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b0e809ec61f3487ed8eb0f09ad9d2be8291f8cc4",
          "body": null,
          "is_bot": false,
          "headline": "add storage info helper (#112)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-06-02T07:55:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "efa2b6e59d36b4f45c2a5400dc810306231cc81a",
          "body": "Refresh ty to 0.0.38 after local and CI validation.",
          "is_bot": false,
          "headline": "refresh ty to 0.0.38",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-22T13:27:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cd84a58cfa813203e0b8a02c16b0c1b43295df10",
          "body": null,
          "is_bot": false,
          "headline": "refresh duckdb matrix and dev lock (#110)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-22T08:10:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "47d6f67ed5c468f5c56a6311b491e7e4a5979b64",
          "body": null,
          "is_bot": false,
          "headline": "test quack query helper runtime",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-21T14:24:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7fbb8bad458306a19db77ca01f4ff42ab03138c4",
          "body": null,
          "is_bot": false,
          "headline": "add duckdb 1.5.3 support",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-21T14:18:19Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "00fad1b6434e4e3ebe14786f2a9f10d3e7e6e486",
          "body": null,
          "is_bot": false,
          "headline": "centralize bulk insert row shape (#107)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-19T08:53:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "69169eb9727dbe33180644b2beb2b631a0ae78b6",
          "body": "Add MotherDuck Dives-as-code table-function helpers and refresh the validated ty dev pin.",
          "is_bot": false,
          "headline": "add motherduck dive helpers",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-19T08:50:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ff85ed12e3a5bcb16f71c028ff03f094565339d7",
          "body": null,
          "is_bot": false,
          "headline": "extract statement classification helpers (#105)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-17T20:58:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "43c7180f5cad83ca76cb464b2a7265f0b98c46a0",
          "body": null,
          "is_bot": false,
          "headline": "add motherduck job helpers",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-15T14:23:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8583484bd46ccdf089a1327ddc628e7c4b0d23bd",
          "body": null,
          "is_bot": false,
          "headline": "refactor olap metadata helpers (#103)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-15T14:19:01Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b1aa01ce116e3a0bcec8870bb75db5eaf7d80b0d",
          "body": null,
          "is_bot": false,
          "headline": "add motherduck table function helpers (#102)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-12T18:43:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8da837b8d22e74fa6f8758558a75f06464fa01ac",
          "body": "Release 1.5.2.2.",
          "is_bot": false,
          "headline": "chore: release 1.5.2.2",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-11T12:17:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e2a8c276ff790fda4a2e193cad4fea4a4ff079df",
          "body": null,
          "is_bot": false,
          "headline": "deduplicate reflection fallback wrappers",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-10T20:02:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e624a0c5eafaebd675a07f2bd37b48f4edb803ab",
          "body": "Refresh ty to 0.0.34 and update the locked development dependency set after local and CI validation.",
          "is_bot": false,
          "headline": "refresh dev tooling",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-07T07:44:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "73ca8144a646a7ac04078343a15ca59b68f20eff",
          "body": null,
          "is_bot": false,
          "headline": "handle postgres session compatibility (#98)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-03T19:56:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ba9f9b6f99c28d8494229ec19bc395f7ef56fc7c",
          "body": null,
          "is_bot": false,
          "headline": "validate motherduck database names (#97)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-05-01T08:08:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d54cf40abdb39be801010a1553fcf39ee783f8e2",
          "body": "Rollback PR #95 behavior and dependency updates while keeping formatting-only conftest cleanup.",
          "is_bot": false,
          "headline": "Revert pgcompat config aliases (#96)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-30T15:05:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "21ca5987c0de84a4d025d2e27b7e41c5b1bbbfbd",
          "body": null,
          "is_bot": false,
          "headline": "add pgcompat config aliases (#95)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-30T08:16:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f0f8a20e128b9f6af02b91e01de1a1c9dc2b69cc",
          "body": "Refresh maintenance dependency pins and lockfile; CI passed.",
          "is_bot": false,
          "headline": "refresh maintenance dependencies",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-29T10:17:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "836133bff43f1756398ac58deba68a6fc96cc62d",
          "body": null,
          "is_bot": false,
          "headline": "fix motherduck token env precedence (#93)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-26T17:08:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "69df613b45e21bfe4f9b35f4450029cf730b5959",
          "body": null,
          "is_bot": false,
          "headline": "extract bulk insert builders (#92)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-26T10:42:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "60ec8ef992e87a2273ef1158efb1a10becd653b6",
          "body": null,
          "is_bot": false,
          "headline": "add motherduck user info helper",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-25T08:55:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9e2b1b38590760e121f2d0a2c414c55cb596a2bb",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.5.2.1 (#90)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-25T08:11:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4daaec569223a3de26727c520d1e40f4fda4e06a",
          "body": null,
          "is_bot": false,
          "headline": "restore motherduck legacy transport aliases (#89)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-24T09:14:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9a2389d6b986f5261a0e157f65164e09c44526fa",
          "body": "* refactor validation helpers\n\n* restore uv lockfile",
          "is_bot": false,
          "headline": "[codex] refactor validation helpers (#88)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-24T08:32:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "19668b8523721dc7bee2fecd6248d905891cfa34",
          "body": null,
          "is_bot": false,
          "headline": "maintenance review: fix motherduck routing (#87)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-24T08:16:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d570b8d8bffe861418ea89c222ce2f30a6364f9a",
          "body": null,
          "is_bot": false,
          "headline": "fix motherduck startup options (#86)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-21T11:06:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "515ff0e663810968b90f827ce553650772466789",
          "body": null,
          "is_bot": false,
          "headline": "refactor bulk row normalization (#85)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-19T10:17:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f2319a728ccd54976fa80ed0a76ef70fc25979f3",
          "body": null,
          "is_bot": false,
          "headline": "refactor reflection fallbacks (#84)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-18T11:50:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d524ac9d921061f90d8346bc7a3666f9611a32c2",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.5.2",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-17T09:15:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cca001e5b15574000186eb7d5061b1d7492225f4",
          "body": null,
          "is_bot": false,
          "headline": "refactor reflection fallback (#82)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-17T08:38:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b129a5f72e34b6c83106e057690a78d095617a71",
          "body": "Support DuckDB 1.5.2 GEOMETRY reflection, prefer MotherDuck session_name while preserving session_hint aliases, and refresh validated development tooling pins.",
          "is_bot": false,
          "headline": "support duckdb 1.5.2 compatibility",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-17T08:12:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8cbf8c13cd6a2b2dd8354095e80f342a099dcc4f",
          "body": null,
          "is_bot": false,
          "headline": "refactor duckdb reflection statements (#80)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-16T11:07:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "59baaa8bafc4010a0a68208181b4c8d8b6ac6c1a",
          "body": null,
          "is_bot": false,
          "headline": "support duckdb 1.5.2 motherduck session names (#79)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-16T08:29:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ec65504ef758ccca0e1b440edda29ee280eab5da",
          "body": null,
          "is_bot": false,
          "headline": "refactor duckdb reflection filters (#78)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-12T09:36:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1537c5a10d11c663ad210acd1a2cdbcfb8fc273f",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.5.1.4 (#77)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-10T16:57:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "90a84a95f1bbb69e6ec0e3502197bcc4de01b0b1",
          "body": null,
          "is_bot": false,
          "headline": "fix motherduck oauth token config (#75)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-10T08:15:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d42d487643a23d03ace6d303802d3339a9e80c78",
          "body": null,
          "is_bot": false,
          "headline": "fix motherduck alias routing (#74)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-08T16:06:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0326c92f2055f84f6c2a0e8da7c1c7b7719e111c",
          "body": null,
          "is_bot": false,
          "headline": "fix memory url query handling (#73)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-07T12:33:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "92e8827ec1f4dfaf7db449cfb9ee2017d78adb69",
          "body": null,
          "is_bot": false,
          "headline": "consolidate motherduck ttl alias normalization (#72)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-07T12:29:17Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e6732e2c2f876486259b7eac130f44202dca308a",
          "body": "* fix retry handling and refresh tooling\n\n* fix datatypes ty regression",
          "is_bot": false,
          "headline": "[codex] fix retry handling and refresh tooling",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-03T12:40:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1ff8b468f3b5b4f648c6753e3a1760c6c42e1106",
          "body": null,
          "is_bot": false,
          "headline": "share struct union field cache logic (#70)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-03T12:34:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "29dd7084499cdc99d640c9f33ed570a1adc1b0ad",
          "body": null,
          "is_bot": false,
          "headline": "maintenance review: fix nox devtools setup (#69)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-02T15:33:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "41bcb9dc282d761ada39d25cd7bc24d87566e0c7",
          "body": null,
          "is_bot": false,
          "headline": "refactor pool selection (#68)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-02T15:28:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6adfaac122f371186d70142e75585f1df9b4af8a",
          "body": null,
          "is_bot": false,
          "headline": "refresh dev lockfile and bump ty (#67)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-01T08:11:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1d7a435de1e70a07512984b91e5ee1106195ba8d",
          "body": null,
          "is_bot": false,
          "headline": "extract index reflection helpers (#66)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-04-01T08:09:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d1844f7c214735db0203f34579b6928bc6804f22",
          "body": null,
          "is_bot": false,
          "headline": "maintenance review and ty upgrade (#65)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-31T08:14:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b7d559d6b8dc1034fdc84be47b21c077ff963ec5",
          "body": null,
          "is_bot": false,
          "headline": "refactor connect arg copying (#64)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-31T08:06:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ccb16cd1869a55c8673870056208e42b5cad0bcd",
          "body": null,
          "is_bot": false,
          "headline": "maintenance review: deprecate insert alias and bump ty (#63)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-30T08:13:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7b2a801be822d4a2c1ce4a2c318aedf855b25bde",
          "body": null,
          "is_bot": false,
          "headline": "refactor MotherDuck TTL alias normalization (#62)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-30T08:09:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8ac0a5cd23873fe9afa0ee9ebf621eafe9261030",
          "body": "* widen dependency caps and cache reserved words\n\n* add pytz for pandas 3 environments",
          "is_bot": false,
          "headline": "[codex] widen dependency caps and cache reserved words (#61)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-29T20:05:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b67ca47cd916b3e5cd39892ac15c690aa807c25c",
          "body": null,
          "is_bot": false,
          "headline": "extract bulk helpers (#60)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-29T19:55:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3f28dd56339cd05537eaf9b66ba0b01fbc44477d",
          "body": null,
          "is_bot": false,
          "headline": "maintenance review: deprecate ttl alias and refresh dev tools (#59)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-27T10:46:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2b11235f75ac26d6d01fa1e78a8d8b43972ebd2f",
          "body": null,
          "is_bot": false,
          "headline": "avoid empty bulk copy chunks (#58)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-27T10:39:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "67dceb82afba1e28deb728f34b0d7c5a07d0d14f",
          "body": null,
          "is_bot": false,
          "headline": "fix: align sqlalchemy floor and local pool defaults (#57)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-26T22:05:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b61146d35b1263adc25de15cca2a7a8e049d1f56",
          "body": null,
          "is_bot": false,
          "headline": "feat: add DuckDB 1.5.1 support (#56)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-26T09:45:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "091a829e706fdc4da8509bc964af045c2aad29c8",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.4.4.8 (#55)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-24T15:44:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b2deffbbedc09d7670bdab0a9febda5985f54998",
          "body": null,
          "is_bot": false,
          "headline": "feat: add explicit checkpoint helper (#54)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-24T15:18:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "856edaf8bada7084c37b64595869826214470000",
          "body": null,
          "is_bot": false,
          "headline": "fix: stop probing isolation level on connect (#53)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-24T15:06:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "18027d1439b35ff05fda0a932f627d9eadcade54",
          "body": null,
          "is_bot": false,
          "headline": "fix: restore pool defaults for named memory urls (#52)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-24T15:04:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "dab204cf33d6674106453fa4e86a3ba2e0557b16",
          "body": null,
          "is_bot": false,
          "headline": "ci: update github actions (#50)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T18:32:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "eb2676b6f77e7325d397e78f1aac5c1c5cc5cd0b",
          "body": null,
          "is_bot": false,
          "headline": "fix: repair reflection metadata (#48)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T17:19:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "72e6cf50dcc303b4a4c470228d2527a350ef08b7",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.4.4.6 (#47)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T16:55:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6f30c67f196855da119bf9abc169a4b3258e7e0a",
          "body": null,
          "is_bot": false,
          "headline": "fix: reflect float8 as double (#46)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T16:51:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7b4ca3e4e9798ccc11dd6324f2992156359c6411",
          "body": null,
          "is_bot": false,
          "headline": "chore: release 1.4.4.5 (#45)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T16:25:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b865a9b172ab048af6ad6ff9f48107f3b0c7c2be",
          "body": null,
          "is_bot": false,
          "headline": "extract bulk insert data helper (#44)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T14:42:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "82b7273e558a20396d25bb35f0caaf11293eaba6",
          "body": "* bulk-loader cleanup and deps\n\n* trigger pr ci",
          "is_bot": false,
          "headline": "[codex] bulk-loader cleanup and deps (#43)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-22T13:04:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "35baffc98934f7092b8396b0c343ef2b080a4b3a",
          "body": null,
          "is_bot": false,
          "headline": "refactor MotherDuck TTL normalization (#42)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-21T15:22:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c9260f7c384906b45905638e9aedcafbf414a145",
          "body": null,
          "is_bot": false,
          "headline": "maintenance: bulk cleanup and deps (#41)",
          "author_name": "Leonardo Vida",
          "author_login": "leonardovida",
          "committed_at": "2026-03-21T12:55:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 27,
      "commits_last_year": 218,
      "latest_release_at": "2026-07-31T09:04:18Z",
      "latest_release_tag": "v1.5.4.7",
      "releases_from_tags": false,
      "days_since_last_push": 0,
      "active_weeks_last_year": 29,
      "days_since_latest_release": 0,
      "mean_days_between_releases": 9
    },
    "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": "duckdb-sqlalchemy",
          "exists": true,
          "license": "MIT",
          "keywords": [
            "analytics",
            "database",
            "dialect",
            "duckdb",
            "motherduck",
            "olap",
            "sqlalchemy",
            "Development Status :: 5 - Production/Stable",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3 :: Only",
            "Programming Language :: Python :: 3.10",
            "Programming Language :: Python :: 3.11",
            "Programming Language :: Python :: 3.12",
            "Programming Language :: Python :: 3.13",
            "Programming Language :: Python :: 3.14",
            "Programming Language :: Python :: 3.9",
            "Topic :: Database",
            "Topic :: Database :: Front-Ends"
          ],
          "ecosystem": "pypi",
          "matches_repo": true,
          "registry_url": "https://pypi.org/project/duckdb-sqlalchemy/",
          "is_deprecated": false,
          "latest_version": "1.5.4.7",
          "repository_url": "https://github.com/leonardovida/duckdb-sqlalchemy",
          "versions_count": 27,
          "total_downloads": null,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": null,
          "first_published_at": "2025-12-26T22:14:51.171896Z",
          "latest_published_at": "2026-07-31T09:05:06.600094Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 0
        }
      ]
    },
    "popularity": {
      "forks": 0,
      "stars": 16,
      "watchers": 0,
      "fork_history": {
        "days": [],
        "complete": true,
        "collected": 0,
        "total_forks": 0
      },
      "star_history": null,
      "open_issues_and_prs": 1
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [
        "examples"
      ],
      "has_llms_txt": true,
      "has_dockerfile": false,
      "has_mcp_signal": false,
      "bootstrap_files": [
        "noxfile.py"
      ],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [
        "duckdb_sqlalchemy/py.typed"
      ],
      "toolchain_manifests": [],
      "largest_source_bytes": 75234,
      "source_files_sampled": 38,
      "oversized_source_files": 2,
      "agent_instruction_files": [
        "AGENTS.md",
        "CLAUDE.md"
      ],
      "agent_instruction_max_bytes": 2595
    },
    "dependencies": {
      "manifests": [
        "pyproject.toml"
      ],
      "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": [
        "pypi"
      ],
      "dependencies": [
        {
          "name": "duckdb",
          "manifest": "pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=0.5.0"
        },
        {
          "name": "sqlalchemy",
          "manifest": "pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=2.0.0"
        },
        {
          "name": "sqlalchemy",
          "manifest": "pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=2.0.45"
        },
        {
          "name": "packaging",
          "manifest": "pyproject.toml",
          "ecosystem": "pypi",
          "version_constraint": ">=21"
        }
      ],
      "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": 137,
        "open_issues": 1,
        "closed_ratio": 0.8,
        "closed_issues": 4,
        "closed_unmerged_prs": 4
      },
      "bus_factor": 1,
      "bot_contributors": 6,
      "top_contributors": [
        {
          "type": "User",
          "login": "Mause",
          "commits": 1424,
          "avatar_url": "https://avatars.githubusercontent.com/u/1405026?v=4"
        },
        {
          "type": "User",
          "login": "leonardovida",
          "commits": 168,
          "avatar_url": "https://avatars.githubusercontent.com/u/2588282?v=4"
        },
        {
          "type": "User",
          "login": "renovate-bot",
          "commits": 16,
          "avatar_url": "https://avatars.githubusercontent.com/u/25180681?v=4"
        },
        {
          "type": "User",
          "login": "Aarya2004",
          "commits": 9,
          "avatar_url": "https://avatars.githubusercontent.com/u/54771759?v=4"
        },
        {
          "type": "User",
          "login": "matteomorlack",
          "commits": 7,
          "avatar_url": "https://avatars.githubusercontent.com/u/28672237?v=4"
        },
        {
          "type": "User",
          "login": "elefeint",
          "commits": 7,
          "avatar_url": "https://avatars.githubusercontent.com/u/41136058?v=4"
        },
        {
          "type": "User",
          "login": "NickCrews",
          "commits": 5,
          "avatar_url": "https://avatars.githubusercontent.com/u/10820686?v=4"
        },
        {
          "type": "User",
          "login": "gforsyth",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/3596999?v=4"
        },
        {
          "type": "User",
          "login": "jorisvandenbossche",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/1020496?v=4"
        },
        {
          "type": "User",
          "login": "Alex-Monahan",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/52226177?v=4"
        }
      ],
      "contributors_sampled": 25,
      "top_contributor_share": 0.856
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "lint.yml",
        "pages.yml",
        "publish.yaml",
        "pythonapp.yaml"
      ],
      "has_docs_dir": true,
      "linter_configs": [],
      "has_editorconfig": false,
      "has_linter_config": true,
      "has_precommit_config": true
    },
    "security_signals": {
      "lockfiles": [
        "uv.lock"
      ],
      "scorecard": {
        "checks": [
          {
            "name": "Binary-Artifacts",
            "score": 10,
            "reason": "no binaries found in the repo",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
          },
          {
            "name": "Branch-Protection",
            "score": 3,
            "reason": "branch protection is not maximal on development and all release branches",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
          },
          {
            "name": "CI-Tests",
            "score": 9,
            "reason": "29 out of 30 merged PRs checked by a CI test -- score normalized to 9",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
          },
          {
            "name": "CII-Best-Practices",
            "score": 0,
            "reason": "no effort to earn an OpenSSF best practices badge detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
          },
          {
            "name": "Code-Review",
            "score": 0,
            "reason": "Found 0/30 approved changesets -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 10,
            "reason": "project has 10 contributing companies or organizations",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
          },
          {
            "name": "Dangerous-Workflow",
            "score": 10,
            "reason": "no dangerous workflow patterns detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
          },
          {
            "name": "Dependency-Update-Tool",
            "score": 10,
            "reason": "update tool detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
          },
          {
            "name": "Fuzzing",
            "score": 0,
            "reason": "project is not fuzzed",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
          },
          {
            "name": "License",
            "score": 10,
            "reason": "license file detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
          },
          {
            "name": "Maintained",
            "score": 10,
            "reason": "30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
          },
          {
            "name": "Packaging",
            "score": 10,
            "reason": "packaging workflow detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
          },
          {
            "name": "Pinned-Dependencies",
            "score": 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": "SAST tool is not run on all commits -- score normalized to 0",
            "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": 4,
            "reason": "6 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "66f42bedbcfab7977a1c13bc6c1d636f7faee9c1",
        "ran_at": "2026-07-31T09:06:02Z",
        "aggregate_score": 5.1,
        "scorecard_version": "v5.5.0"
      },
      "has_codeql_workflow": false,
      "has_security_policy": false,
      "has_dependabot_config": true
    },
    "contribution_flow": {
      "collected": true,
      "ci_last_run_at": "2026-07-31T09:05:09Z",
      "oldest_open_prs": [],
      "last_merged_pr_at": "2026-07-31T09:03:30Z",
      "ci_last_conclusion": "SUCCESS",
      "oldest_open_issues": [
        {
          "number": 135,
          "created_at": "2026-07-06T11:37:20Z",
          "last_comment_at": "2026-07-09T17:52:32Z",
          "last_comment_author": "ml31415"
        }
      ]
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/leonardovida/duckdb-sqlalchemy",
    "host": "github.com",
    "name": "duckdb-sqlalchemy",
    "owner": "leonardovida"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "good",
      "name": "Overall health",
      "note": "The weighted overall 63 is calibrated to 71 on the published index scale (record calibration 2026-08-02).",
      "notes": [
        {
          "code": "overall_calibration",
          "params": {
            "raw": 63,
            "calibrated": 71,
            "calibration": "2026-08-02"
          }
        }
      ],
      "value": 71,
      "inputs": {
        "security": 51,
        "vitality": 90,
        "community": 22,
        "governance": 63,
        "calibration": "2026-08-02",
        "engineering": 79,
        "ai_readiness": 79,
        "weighted_overall_raw": 63
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "excellent",
        "name": "Vitality",
        "value": 90,
        "weight": 0.21,
        "metrics": [
          {
            "key": "development_activity",
            "band": "excellent",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 84,
            "inputs": {
              "commits_last_year": 218,
              "human_commit_share": 1,
              "days_since_last_push": 0,
              "active_weeks_last_year": 29
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 0 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "29/52 weeks with commits",
                "points": 20.1,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 29
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "218 commits in the last year",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 218
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "release_discipline",
            "band": "exceptional",
            "name": "Release discipline",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "releases_count": 27,
              "latest_release_tag": "v1.5.4.7",
              "releases_from_tags": false,
              "days_since_latest_release": 0,
              "mean_days_between_releases": 9
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "27 releases published",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "releases_published",
                    "params": {
                      "count": 27
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 0 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~9 days",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 9
                    }
                  }
                ],
                "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": "exceptional",
            "name": "Abandonment",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "cap": null,
              "state": "maintained",
              "guards": [],
              "signals": [],
              "red_flag": false,
              "multiplier_pct": 100,
              "declared_reason": null,
              "unverified_reason": null,
              "unanswered_open_prs": null,
              "unanswered_open_issues": null,
              "days_since_last_merged_pr": null,
              "days_since_last_human_commit": 2,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "last human commit 2 days ago",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_maintained",
                    "params": {
                      "days": 2
                    }
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Is the project alive — is code being written and are releases shipping?"
      },
      {
        "key": "community",
        "band": "at_risk",
        "name": "Community & Adoption",
        "value": 22,
        "weight": 0.17,
        "metrics": [
          {
            "key": "popularity",
            "band": "critical",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 19,
            "inputs": {
              "forks": 0,
              "stars": 16,
              "watchers": 0,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "16 stars",
                "points": 19.1,
                "status": "partial",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 16
                    }
                  }
                ],
                "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": "at_risk",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 25,
            "inputs": {
              "has_readme": false,
              "has_license": false,
              "readme_badges": null,
              "has_contributing": false,
              "has_issue_template": false,
              "has_code_of_conduct": false,
              "readme_badge_services": [],
              "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": 63,
        "weight": 0.23,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "weak",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 36,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 25,
              "top_contributor_share": 0.856
            },
            "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 86% of commits",
                "points": 3.2,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 86
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "25 contributors",
                "points": 13.5,
                "status": "met",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 25
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 10 contributing companies or organizations",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "good",
            "name": "Issue & PR responsiveness",
            "note": "Excluded from scoring (no data or not applicable): Newcomer PR acceptance. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "newcomer_pr_acceptance"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 72,
            "inputs": {
              "merged_prs": 137,
              "open_issues": 1,
              "closed_issues": 4,
              "prs_merged_7d": null,
              "prs_decided_7d": null,
              "prs_merged_30d": null,
              "prs_decided_30d": null,
              "issue_closed_ratio": 0.8,
              "closed_unmerged_prs": 4,
              "first_time_authors_30d": null,
              "first_time_prs_merged_30d": null,
              "first_time_prs_decided_30d": null
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "80% of issues closed",
                "points": 33.6,
                "status": "partial",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 80
                    }
                  }
                ],
                "max_points": 42
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "137/141 decided PRs merged",
                "points": 29.1,
                "status": "partial",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 137,
                      "decided": 141
                    }
                  }
                ],
                "max_points": 30
              },
              {
                "key": "newcomer_pr_acceptance",
                "name": "Newcomer PR acceptance",
                "detail": "no first-time contributor's PR decided in 30d",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_newcomer_prs",
                    "params": {
                      "days": 30
                    }
                  }
                ],
                "max_points": 13
              },
              {
                "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": 56,
            "inputs": {
              "followers": 39,
              "owner_type": "User",
              "is_verified": null,
              "owner_login": "leonardovida",
              "public_repos": 40,
              "account_age_days": 5033
            },
            "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": "39 followers of leonardovida",
                "points": 11.5,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 39,
                      "login": "leonardovida"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "40 public repos, account ~13 yr old",
                "points": 23.7,
                "status": "partial",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 40
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 13
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "exceptional",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "packages": [
                "duckdb-sqlalchemy"
              ],
              "ecosystems": "pypi",
              "any_deprecated": false,
              "min_days_since_publish": 0
            },
            "components": [
              {
                "key": "published_resolvable",
                "name": "Published & resolvable",
                "detail": "1 package(s) on pypi",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "packages_published",
                    "params": {
                      "count": 1,
                      "ecosystems": "pypi"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "publish_recency",
                "name": "Publish recency",
                "detail": "latest publish 0 days ago",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "27 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 27
                    }
                  }
                ],
                "max_points": 20
              },
              {
                "key": "not_deprecated",
                "name": "Not deprecated",
                "detail": "active, not deprecated or yanked",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "package_not_deprecated",
                    "params": {}
                  }
                ],
                "max_points": 20
              }
            ]
          }
        ],
        "description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
      },
      {
        "key": "engineering",
        "band": "good",
        "name": "Engineering Quality",
        "value": 79,
        "weight": 0.19,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "excellent",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 92,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": true,
              "has_precommit_config": true
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "4 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 4
                    }
                  }
                ],
                "max_points": 24
              },
              {
                "key": "tests_present",
                "name": "Tests present",
                "detail": null,
                "points": 24,
                "status": "met",
                "details": [],
                "max_points": 24
              },
              {
                "key": "linter_config",
                "name": "Linter config",
                "detail": null,
                "points": 16,
                "status": "met",
                "details": [],
                "max_points": 16
              },
              {
                "key": "pre_commit_hooks",
                "name": "Pre-commit hooks",
                "detail": null,
                "points": 9.6,
                "status": "met",
                "details": [],
                "max_points": 9.6
              },
              {
                "key": "editorconfig",
                "name": ".editorconfig",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.4
              },
              {
                "key": "openssf_scorecard_ci_tests",
                "name": "OpenSSF Scorecard: CI-Tests",
                "detail": "29 out of 30 merged PRs checked by a CI test -- score normalized to 9",
                "points": 18,
                "status": "partial",
                "details": [],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "moderate",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 60,
            "inputs": {
              "topics": [
                "analytics",
                "database",
                "dialect",
                "duckdb",
                "motherduck",
                "olap",
                "python",
                "sqlalchemy",
                "alembic",
                "data-engineering",
                "duckdb-engine-migration"
              ],
              "has_wiki": true,
              "homepage": "https://leonardovida.github.io/duckdb-sqlalchemy/",
              "has_readme": false,
              "has_docs_dir": true,
              "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": 25,
                "status": "met",
                "details": [],
                "max_points": 25
              },
              {
                "key": "documentation_homepage_site",
                "name": "Documentation / homepage site",
                "detail": "https://leonardovida.github.io/duckdb-sqlalchemy/",
                "points": 15,
                "status": "met",
                "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": "11 topics",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "topics_count",
                    "params": {
                      "count": 11
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "wiki",
                "name": "Wiki",
                "detail": null,
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          }
        ],
        "description": "Are baseline engineering and documentation practices in place?"
      },
      {
        "key": "security",
        "band": "moderate",
        "name": "Security",
        "value": 51,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "moderate",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 51,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 17,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 1,
              "scorecard_aggregate": 5.1
            },
            "components": [
              {
                "key": "binary_artifacts",
                "name": "Binary-Artifacts",
                "detail": "no binaries found in the repo",
                "points": 7.5,
                "status": "met",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "branch_protection",
                "name": "Branch-Protection",
                "detail": "branch protection is not maximal on development and all release branches",
                "points": 2.2,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "ci_tests",
                "name": "CI-Tests",
                "detail": "29 out of 30 merged PRs checked by a CI test -- score normalized to 9",
                "points": 2.2,
                "status": "partial",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "cii_best_practices",
                "name": "CII-Best-Practices",
                "detail": "no effort to earn an OpenSSF best practices badge detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "code_review",
                "name": "Code-Review",
                "detail": "Found 0/30 approved changesets -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 10 contributing companies or organizations",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "dangerous_workflow",
                "name": "Dangerous-Workflow",
                "detail": "no dangerous workflow patterns detected",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "dependency_update_tool",
                "name": "Dependency-Update-Tool",
                "detail": "update tool detected",
                "points": 7.5,
                "status": "met",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "fuzzing",
                "name": "Fuzzing",
                "detail": "project is not fuzzed",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "license file detected",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "maintained",
                "name": "Maintained",
                "detail": "30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10",
                "points": 7.5,
                "status": "met",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "packaging",
                "name": "Packaging",
                "detail": "packaging workflow detected",
                "points": 5,
                "status": "met",
                "details": [],
                "max_points": 5
              },
              {
                "key": "pinned_dependencies",
                "name": "Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "sast",
                "name": "SAST",
                "detail": "SAST tool is not run on all commits -- score normalized to 0",
                "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": "6 existing vulnerabilities detected",
                "points": 3,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              }
            ]
          },
          {
            "key": "high_risk_jurisdiction_exposure",
            "band": "exceptional",
            "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"
              ],
              "commit_weight_rule": {
                "min_commits": 50,
                "min_commit_share": 0.1
              },
              "review_only_matches": 0,
              "below_threshold_exposures": [],
              "assessed_self_published_locations": 14
            },
            "components": [
              {
                "key": "policy_exposure_multiplier",
                "name": "Policy exposure multiplier",
                "detail": "no confirmed policy-scope location match",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "jurisdiction_no_match",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
      },
      {
        "key": "ai_readiness",
        "band": "good",
        "name": "AI Readiness",
        "value": 79,
        "weight": 0.04,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "exceptional",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "has_llms_txt": true,
              "legible_history_share": 0.84,
              "agent_instruction_files": [
                "AGENTS.md",
                "CLAUDE.md"
              ],
              "agent_instruction_max_bytes": 2595
            },
            "components": [
              {
                "key": "agent_instructions",
                "name": "Agent instructions",
                "detail": "AGENTS.md, CLAUDE.md",
                "points": 45,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "AGENTS.md, CLAUDE.md"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "machine_readable_docs_llms_txt",
                "name": "Machine-readable docs (llms.txt)",
                "detail": "llms.txt present",
                "points": 15,
                "status": "met",
                "details": [
                  {
                    "code": "llms_txt_present",
                    "params": {}
                  }
                ],
                "max_points": 15
              },
              {
                "key": "legible_commit_history",
                "name": "Legible commit history",
                "detail": "84 of 100 human commits state their intent (structured subject or explanatory body)",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 84,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "good",
            "name": "Verify loop (build / test / typecheck)",
            "note": null,
            "notes": [],
            "value": 77,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [
                "uv.lock"
              ],
              "has_dockerfile": false,
              "typed_language": false,
              "bootstrap_files": [
                "noxfile.py"
              ],
              "has_devcontainer": false,
              "has_linter_config": true,
              "typecheck_configs": [
                "duckdb_sqlalchemy/py.typed"
              ],
              "agent_commit_share": 0,
              "toolchain_manifests": [],
              "dependency_bot_commit_share": 0
            },
            "components": [
              {
                "key": "one_command_bootstrap",
                "name": "One-command bootstrap",
                "detail": "noxfile.py",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "noxfile.py"
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "automated_tests",
                "name": "Automated tests",
                "detail": null,
                "points": 22,
                "status": "met",
                "details": [],
                "max_points": 22
              },
              {
                "key": "lint_format_config",
                "name": "Lint / format config",
                "detail": null,
                "points": 11,
                "status": "met",
                "details": [],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": "duckdb_sqlalchemy/py.typed",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "duckdb_sqlalchemy/py.typed"
                    }
                  }
                ],
                "max_points": 11
              },
              {
                "key": "reproducible_environment",
                "name": "Reproducible environment",
                "detail": "lockfile",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "lockfile"
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "demonstrated_agent_practice",
                "name": "Demonstrated agent practice",
                "detail": "no agent-authored commits among the last 100",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_agent_authored_commits",
                    "params": {
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "automated_maintenance",
                "name": "Automated maintenance",
                "detail": "dependency automation configured, none observed in the sampled commits",
                "points": 5,
                "status": "partial",
                "details": [
                  {
                    "code": "dependency_bot_config_only",
                    "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": "good",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 79,
            "inputs": {
              "primary_language": "Python",
              "largest_source_bytes": 75234,
              "source_files_sampled": 38,
              "oversized_source_files": 2
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "Python with type-check config (duckdb_sqlalchemy/py.typed)",
                "points": 27,
                "status": "partial",
                "details": [
                  {
                    "code": "typecheck_config_language",
                    "params": {
                      "files": "duckdb_sqlalchemy/py.typed",
                      "language": "Python"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "2/38 source files over 60KB",
                "points": 52.1,
                "status": "partial",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 38,
                      "oversized": 2
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          },
          {
            "key": "ai_interfaces",
            "band": "weak",
            "name": "Machine-readable interfaces",
            "note": null,
            "notes": [],
            "value": 40,
            "inputs": {
              "example_dirs": [
                "examples"
              ],
              "has_mcp_signal": false,
              "api_schema_files": []
            },
            "components": [
              {
                "key": "api_schema_openapi_graphql_proto",
                "name": "API schema (OpenAPI/GraphQL/proto)",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 40
              },
              {
                "key": "mcp_server",
                "name": "MCP server",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 20
              },
              {
                "key": "runnable_examples",
                "name": "Runnable examples",
                "detail": "examples",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "examples"
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          }
        ],
        "description": "How well is the repo equipped to be developed and maintained with AI coding agents? Carries a deliberately small weight: agent tooling is a real maintenance signal, but its absence must never gate the top of the scale (calibration saturates at raw 91, so 100/100 remains reachable with AI Readiness at zero)."
      }
    ],
    "classification": {
      "labels": [
        "library"
      ],
      "scores": {
        "library": 6
      },
      "primary": "library",
      "evidence": [
        {
          "tier": "distribution",
          "label": "library",
          "source": "registry:pypi",
          "weight": 6
        }
      ],
      "artifacts": [],
      "confidence": "medium",
      "host_extension": false,
      "runs_as_process": false,
      "consumed_by_code": true
    },
    "metrics_version": "2.3.1"
  },
  "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",
    "deps.dev does not index pypi:duckdb-sqlalchemy@1.5.4.7; advisories assessed against the repository dependency graph instead"
  ],
  "report_type": "repository",
  "generated_at": "2026-07-31T09:06:30.630424Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/l/leonardovida/duckdb-sqlalchemy.svg",
  "full_name": "leonardovida/duckdb-sqlalchemy",
  "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 v2.3.1, Schema v0.27.0 — vollständige Methodik · Metriken-Wiki.

Wie ein einzelnes Ergebnis im Gesamtregister steht: aggregierte StatistikenPyPI.