Registro público
Informe de salud del softwareesquema 0.27.0 · métricas 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 estrellas⑂ 0 forksdesde dic 2025forkVer en GitHub ↗
TipoBibliotecacómo se determina

leonardovida/duckdb-sqlalchemy tiene un índice de salud de 71 sobre 100, lo que lo sitúa en la banda Bueno. Su puntuación más alta es Vitality (90/100) y la más baja, Community & Adoption (22/100). Se actualizó por última vez hoy. Una sola persona concentra la mayor parte del trabajo reciente.

71
global / 100
Bueno

Índice de salud del software

Las métricas se agrupan en categorías ponderadas sobre una escala estandarizada de 1 a 100. El resultado global parte de su media ponderada, calibrada contra la distribución del registro público para que las bandas tengan significado percentil; cuando la evidencia pública activa la Política de Jurisdicciones de Alto Riesgo, la calificación se ajusta y recibe un límite «En riesgo» de 34.

71
Excepcional93-100El nivel más alto del registro (≈ el 5% superior); cumple prácticamente todos los criterios evaluados
Excelente80-92Sólido en todos los frentes; carencias menores
Bueno65-79Saludable; carencias limitadas y manejables
Moderado50-64Aceptable con carencias notables; se recomienda revisión
Débil35-49Debilidades sustanciales en varias áreas
En riesgo20-34Debilidades significativas; su adopción exige cautela
Crítico1-19Problemas graves (proyecto abandonado, un solo mantenedor, sin higiene)
VitalidadComunidad yAdopciónSostenibilidady GobernanzaCalidad deIngenieríaSeguridadPreparaciónpara IA

Perfil de puntuación

Cada eje es una categoría. La forma importa más que la media: un proyecto sano llena toda la figura, mientras que un perfil de picos y cráteres indica que la fortaleza en una dimensión enmascara el riesgo en otra.

El resultado global ponderado 63 se calibra a 71 en la escala publicada del índice (calibración del registro 2026-08-02).

Titularidad

Leonardo VidaCuenta personal
39 seguidores40 repositorios públicosdesde oct 2012@motherduckdb

Este repositorio pertenece a una cuenta personal. Un proyecto con un único propietario conlleva más riesgo de continuidad que uno respaldado por una organización.

Ecosistemas de paquetes

RegistroPaqueteVersiónDescargas / mesVersionesÚltima publicaciónEtiquetas
PyPIduckdb-sqlalchemy1.5.4.7-27hace 0 díasanalyticsdatabasedialectduckdbmotherduckolapsqlalchemy

Métricas por categoría

Vitalidad

¿Está vivo el proyecto: se escribe código y se publican versiones?

90Excelente · 21% del índice global
Cómo se puntúa
36/36Recencia de push — último push hace 0 días
20.1/36Cadencia de commits — 29/52 semanas con commits
18/18Volumen de commits — 218 commits en el último año
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10
Datos de entrada utilizados
commits_last_year218
human_commit_share1
days_since_last_push0
active_weeks_last_year29
Cómo se puntúa
27/27Publica versiones — 27 versiones publicadas
36/36Recencia de las versiones — última versión hace 0 días
27/27Cadencia de publicación — una versión cada ~9 días
0/10OpenSSF Scorecard: Signed-Releases — sin datos
Datos de entrada utilizados
releases_count27
latest_release_tagv1.5.4.7
releases_from_tagsno
days_since_latest_release0
mean_days_between_releases9
Excluidos de la puntuación (sin datos o no aplicable): OpenSSF Scorecard: Signed-Releases. Los pesos restantes se han renormalizado.

Comunidad y Adopción

¿Tiene el proyecto usuarios, descargas, atención y unas condiciones acogedoras para quienes contribuyen?

22En riesgo · 17% del índice global
Cómo se puntúa
19.1/60Estrellas — 16 estrellas
0/25Forks — 0 forks
0/15Observadores — 0 observadores
Datos de entrada utilizados
forks0
stars16
watchers0
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
Cómo se puntúa
0/22.5README
22.5/22.5Licencia — licencia reconocida (MIT)
0/18Guía CONTRIBUTING
0/13.5Código de conducta
0/7.2Plantilla de issues
0/6.3Plantilla de PR
Datos de entrada utilizados
has_readmeno
has_licenseno
readme_badges
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_services
has_pull_request_templateno

Sostenibilidad y Gobernanza

¿Sobrevivirá el proyecto a sus personas: factor bus, capacidad de respuesta, quién lo respalda y mantenimiento del paquete?

63Moderado · 23% del índice global
Cómo se puntúa
9/54Factor bus — la mitad de los commits recae en 1 contribuyente(s)
3.2/22.5Distribución de commits — el principal contribuyente firma el 86% de los commits
13.5/13.5Amplitud de contribuyentes — 25 contribuyentes
10/10OpenSSF Scorecard: Contributors — project has 10 contributing companies or organizations
Datos de entrada utilizados
bus_factor1
contributors_sampled25
top_contributor_share0,856
Cómo se puntúa
33.6/42Resolución de issues — 80% de issues cerradas
29.1/30Aceptación de PR — 137/141 PR decididos fusionados
0/13Newcomer PR acceptance — ningún PR de un contribuyente primerizo decidido en 30 d
0/15OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0
Datos de entrada utilizados
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
Excluidos de la puntuación (sin datos o no aplicable): newcomer_pr_acceptance. Los pesos restantes se han renormalizado.
Cómo se puntúa
10/30Respaldo de la propiedad — cuenta personal (usuario)
0/20Dominio verificado — no aplicable a cuentas de usuario
11.5/25Alcance del propietario — 39 seguidores de leonardovida
23.7/25Trayectoria — 40 repos públicos, cuenta de ~13 años
Datos de entrada utilizados
followers39
owner_typeUser
is_verified
owner_loginleonardovida
public_repos40
account_age_days5033
Excluidos de la puntuación (sin datos o no aplicable): Dominio verificado. Los pesos restantes se han renormalizado.
Cómo se puntúa
25/25Publicado y resoluble — 1 paquete(s) en pypi
35/35Recencia de publicación — última publicación hace 0 días
20/20Historial de versiones — 27 versiones en el registro
20/20No obsoleto — activo, ni obsoleto ni retirado
Datos de entrada utilizados
packagesduckdb-sqlalchemy
ecosystemspypi
any_deprecatedno
min_days_since_publish0

Calidad de Ingeniería

¿Existen unas prácticas mínimas de ingeniería y documentación?

79Bueno · 19% del índice global
Cómo se puntúa
24/24Flujos de trabajo de CI — 4 flujo(s) de trabajo
24/24Pruebas presentes
16/16Configuración de linter
9.6/9.6Hooks de pre-commit
0/6.4.editorconfig
18/20OpenSSF Scorecard: CI-Tests — 29 out of 30 merged PRs checked by a CI test -- score normalized to 9
Datos de entrada utilizados
has_ci
has_tests
has_editorconfigno
has_linter_config
has_precommit_config

Documentación

60Moderado
Cómo se puntúa
0/30README
25/25Directorio de documentación
15/15Sitio de documentación / página del proyecto — https://leonardovida.github.io/duckdb-sqlalchemy/
0/10Descripción del repositorio
10/10Topics — 11 topics
10/10Wiki
Datos de entrada utilizados
topicsanalytics, database, dialect, duckdb, motherduck, olap, python, sqlalchemy, alembic, data-engineering, duckdb-engine-migration
has_wiki
homepagehttps://leonardovida.github.io/duckdb-sqlalchemy/
has_readmeno
has_docs_dir
has_descriptionno

Seguridad

¿Son sólidas las prácticas visibles de seguridad y de cadena de suministro, sin exposición jurisdiccional de alto riesgo sin resolver?

51Moderado · 16% del índice global
Cómo se puntúa
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.5Licencia — 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 — sin datos
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
3/7.5Vulnerabilities — 6 existing vulnerabilities detected
Datos de entrada utilizados
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate5,1
Excluidos de la puntuación (sin datos o no aplicable): signed_releases. Los pesos restantes se han renormalizado.

Preparación para IA

¿Hasta qué punto está el repositorio preparado para desarrollarse y mantenerse con agentes de codificación de IA? Tiene un peso deliberadamente pequeño (4%): las herramientas para agentes son una señal real de mantenimiento, pero un repositorio sin ninguna puede alcanzar igualmente 100/100.

79Bueno · 4% del índice global
Cómo se puntúa
45/45Instrucciones para agentes — AGENTS.md, CLAUDE.md
15/15Documentación legible por máquinas (llms.txt) — llms.txt presente
40/40Historial de commits legible — 84 de 100 commits humanos declaran su intención (asunto estructurado o cuerpo explicativo)
Datos de entrada utilizados
has_llms_txt
legible_history_share0,84
agent_instruction_filesAGENTS.md, CLAUDE.md
agent_instruction_max_bytes2595
Cómo se puntúa
18/18Arranque con un solo comando — noxfile.py
22/22Pruebas automatizadas
11/11Configuración de lint / formato
11/11Verificación estática de tipos — duckdb_sqlalchemy/py.typed
10/10Entorno reproducible — lockfile
0/10Práctica demostrada con agentes — ningún commit con autoría de agente entre los últimos 100
5/8Mantenimiento automatizado — automatización de dependencias configurada, no observada en los commits muestreados
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Datos de entrada utilizados
has_nixno
has_tests
lockfilesuv.lock
has_dockerfileno
typed_languageno
bootstrap_filesnoxfile.py
has_devcontainerno
has_linter_config
typecheck_configsduckdb_sqlalchemy/py.typed
agent_commit_share0
toolchain_manifests
dependency_bot_commit_share0
Cómo se puntúa
27/45Código verificable por tipos — Python con configuración de verificación de tipos (duckdb_sqlalchemy/py.typed)
52.1/55Tamaños de archivo manejables — 2/38 archivos fuente de más de 60 KB
Datos de entrada utilizados
primary_languagePython
largest_source_bytes75.234
source_files_sampled38
oversized_source_files2
Cómo se puntúa
0/40Esquema de API (OpenAPI/GraphQL/proto)
0/20Servidor MCP
40/40Ejemplos ejecutables — examples
Datos de entrada utilizados
example_dirsexamples
has_mcp_signalno
api_schema_files

Datos clave

16estrellas de GitHub
25contribuidores
218commits en los últimos 12 meses
0días desde el último push
27versiones publicadas
1factor bus
1issues abiertas
PyPIecosistemas de paquetes

Advertencias de recopilación de datos

  • 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

Más detalle

OpenSSF Scorecard 5.1 / 10
5.1agregado

Evaluación de seguridad independiente y agnóstica en cuanto a herramientas, procedente del proyecto de código abierto OpenSSF Scorecard. Cada comprobación premia una práctica de seguridad, no la herramienta de un proveedor concreto. Las comprobaciones que Scorecard no pudo determinar se marcan como n/d y se excluyen de la puntuación de seguridad (nunca se cuentan como cero).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
n/dSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
4Vulnerabilities6 existing vulnerabilities detected
Dependencias directas 4
RegistroPaqueteRestricción de versiónManifiesto
PyPIduckdb>=0.5.0pyproject.toml
PyPIsqlalchemy>=2.0.0pyproject.toml
PyPIsqlalchemy>=2.0.45pyproject.toml
PyPIpackaging>=21pyproject.toml
Todas las dependencias no recopilado

No fue posible recopilar el conjunto de dependencias resuelto para este informe: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

Informe JSON sin procesar legible por máquina
{
  "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"
}

Las puntuaciones son señales, no garantías. Reflejan prácticas públicamente visibles en GitHub; no son una auditoría de código ni una garantía de seguridad.

Los datos ausentes se excluyen y los pesos se renormalizan; nunca se puntúan como cero. La metodología es versionada y abierta: métricas v2.3.1, esquema v0.27.0 — metodología completa · wiki de métricas.

Cómo se sitúa un resultado dentro del registro general: estadísticas agregadasPyPI.