Public recordGood
Software health reportschema 0.27.0 · metrics 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.
leonardovida/duckdb-sqlalchemy holds a health index of 71 out of 100, placing it in the Good band. It scores highest on Vitality (90/100) and lowest on Community & Adoption (22/100). It was last updated today. A single contributor accounts for most of its recent work.
71
overall / 100Software health index
Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean, calibrated against the distribution of the public record so bands carry percentile meaning; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At Risk ceiling of 34.
71
Exceptional93-100The record's top tier (≈ top 5%); essentially all checked criteria met
Excellent80-92Strong across the board; minor gaps
Good65-79Healthy; gaps are limited and manageable
Moderate50-64Acceptable with notable gaps; review recommended
Weak35-49Material weaknesses across several areas
At Risk20-34Significant weaknesses; adoption warrants caution
Critical1-19Severe problems (abandoned, single-maintainer, no hygiene)
Score profile
Each axis is a category. The shape matters more than the average — a healthy subject fills the whole shape, while a spike-and-crater profile means strength in one dimension is masking risk in another.
The weighted overall 63 is calibrated to 71 on the published index scale (record calibration 2026-08-02).
Ownership
Leonardo VidaPersonal account
39 followers40 public repossince Oct 2012@motherduckdb
This repository is owned by a personal account. A single-owner project carries more continuity risk than an organization-backed one.
Package ecosystems
| Registry | Package | Version | Downloads / mo | Versions | Last publish | Tags |
|---|---|---|---|---|---|---|
| PyPI | duckdb-sqlalchemy | 1.5.4.7 | - | 27 | 0 days ago | analyticsdatabasedialectduckdbmotherduckolapsqlalchemy |
Metrics by category
Vitality
Is the project alive — is code being written and are releases shipping?
90
Development activity
84Excellent
How it's scored
| 36/36 | Push recency — last push 0 days ago |
| 20.1/36 | Commit cadence — 29/52 weeks with commits |
| 18/18 | Commit volume — 218 commits in the last year |
| 10/10 | OpenSSF Scorecard: Maintained — 30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10 |
Inputs used
| commits_last_year | 218 |
| human_commit_share | 1 |
| days_since_last_push | 0 |
| active_weeks_last_year | 29 |
Release discipline
100Exceptional
How it's scored
| 27/27 | Ships releases — 27 releases published |
| 36/36 | Release recency — latest release 0 days ago |
| 27/27 | Release cadence — a release every ~9 days |
| 0/10 | OpenSSF Scorecard: Signed-Releases — no data |
Inputs used
| releases_count | 27 |
| latest_release_tag | v1.5.4.7 |
| releases_from_tags | no |
| days_since_latest_release | 0 |
| mean_days_between_releases | 9 |
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.
Community & Adoption
Does the project have users, downloads, attention, and a welcoming setup for contributors?
22
Popularity & adoption
19Critical
How it's scored
| 19.1/60 | Stars — 16 stars |
| 0/25 | Forks — 0 forks |
| 0/15 | Watchers — 0 watchers |
Inputs used
| forks | 0 |
| stars | 16 |
| watchers | 0 |
| growth_state | unverified |
| growth_factor_pct | 100 |
| growth_unverified_reason | no_history |
Community health
25At Risk
How it's scored
| 0/22.5 | README |
| 22.5/22.5 | License — recognized license (MIT) |
| 0/18 | CONTRIBUTING guide |
| 0/13.5 | Code of conduct |
| 0/7.2 | Issue template |
| 0/6.3 | PR template |
Inputs used
| has_readme | no |
| has_license | no |
| readme_badges | — |
| has_contributing | no |
| has_issue_template | no |
| has_code_of_conduct | no |
| readme_badge_services | — |
| has_pull_request_template | no |
Sustainability & Governance
Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?
63
How it's scored
| 9/54 | Bus factor — 1 contributor(s) cover half of all commits |
| 3.2/22.5 | Commit distribution — top contributor authored 86% of commits |
| 13.5/13.5 | Contributor breadth — 25 contributors |
| 10/10 | OpenSSF Scorecard: Contributors — project has 10 contributing companies or organizations |
Inputs used
| bus_factor | 1 |
| contributors_sampled | 25 |
| top_contributor_share | 0.856 |
How it's scored
| 33.6/42 | Issue resolution — 80% of issues closed |
| 29.1/30 | PR acceptance — 137/141 decided PRs merged |
| 0/13 | Newcomer PR acceptance — no first-time contributor's PR decided in 30d |
| 0/15 | OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
Inputs used
| merged_prs | 137 |
| open_issues | 1 |
| closed_issues | 4 |
| prs_merged_7d | — |
| prs_decided_7d | — |
| prs_merged_30d | — |
| prs_decided_30d | — |
| issue_closed_ratio | 0.8 |
| closed_unmerged_prs | 4 |
| first_time_authors_30d | — |
| first_time_prs_merged_30d | — |
| first_time_prs_decided_30d | — |
Excluded from scoring (no data or not applicable): newcomer_pr_acceptance. Remaining weights renormalized.
Ownership & stewardship
56Moderate
How it's scored
| 10/30 | Ownership backing — personal (user) account |
| 0/20 | Verified domain — not applicable to user accounts |
| 11.5/25 | Owner reach — 39 followers of leonardovida |
| 23.7/25 | Track record — 40 public repos, account ~13 yr old |
Inputs used
| followers | 39 |
| owner_type | User |
| is_verified | — |
| owner_login | leonardovida |
| public_repos | 40 |
| account_age_days | 5,033 |
Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.
Package maintenance
100Exceptional
How it's scored
| 25/25 | Published & resolvable — 1 package(s) on pypi |
| 35/35 | Publish recency — latest publish 0 days ago |
| 20/20 | Version history — 27 published versions |
| 20/20 | Not deprecated — active, not deprecated or yanked |
Inputs used
| packages | duckdb-sqlalchemy |
| ecosystems | pypi |
| any_deprecated | no |
| min_days_since_publish | 0 |
Engineering Quality
Are baseline engineering and documentation practices in place?
79
Engineering practices
92Excellent
How it's scored
| 24/24 | CI workflows — 4 workflow(s) |
| 24/24 | Tests present |
| 16/16 | Linter config |
| 9.6/9.6 | Pre-commit hooks |
| 0/6.4 | .editorconfig |
| 18/20 | OpenSSF Scorecard: CI-Tests — 29 out of 30 merged PRs checked by a CI test -- score normalized to 9 |
Inputs used
| has_ci | yes |
| has_tests | yes |
| has_editorconfig | no |
| has_linter_config | yes |
| has_precommit_config | yes |
Documentation
60Moderate
How it's scored
| 0/30 | README |
| 25/25 | Documentation directory |
| 15/15 | Documentation / homepage site — https://leonardovida.github.io/duckdb-sqlalchemy/ |
| 0/10 | Repository description |
| 10/10 | Topics — 11 topics |
| 10/10 | Wiki |
Inputs used
| topics | analytics, database, dialect, duckdb, motherduck, olap, python, sqlalchemy, alembic, data-engineering, duckdb-engine-migration |
| has_wiki | yes |
| homepage | https://leonardovida.github.io/duckdb-sqlalchemy/ |
| has_readme | no |
| has_docs_dir | yes |
| has_description | no |
Security
Are visible security and supply-chain practices strong, without unresolved high-risk jurisdiction exposure?
51
Security posture
51Moderate
How it's scored
| 7.5/7.5 | Binary-Artifacts — no binaries found in the repo |
| 2.2/7.5 | Branch-Protection — branch protection is not maximal on development and all release branches |
| 2.2/2.5 | CI-Tests — 29 out of 30 merged PRs checked by a CI test -- score normalized to 9 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 0/7.5 | Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
| 2.5/2.5 | Contributors — project has 10 contributing companies or organizations |
| 10/10 | Dangerous-Workflow — no dangerous workflow patterns detected |
| 7.5/7.5 | Dependency-Update-Tool — update tool detected |
| 0/5 | Fuzzing — project is not fuzzed |
| 2.5/2.5 | License — license file detected |
| 7.5/7.5 | Maintained — 30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10 |
| 5/5 | Packaging — packaging workflow detected |
| 0/5 | Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
| 0/5 | SAST — SAST tool is not run on all commits -- score normalized to 0 |
| 0/5 | Security-Policy — security policy file not detected |
| 0/7.5 | Signed-Releases — no data |
| 0/7.5 | Token-Permissions — detected GitHub workflow tokens with excessive permissions |
| 3/7.5 | Vulnerabilities — 6 existing vulnerabilities detected |
Inputs used
| source | openssf_scorecard |
| checks_evaluated | 17 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 1 |
| scorecard_aggregate | 5.1 |
Excluded from scoring (no data or not applicable): signed_releases. Remaining weights renormalized.
AI Readiness
How well is the repo equipped to be developed and maintained with AI coding agents? Carries a deliberately small weight (4%): agent tooling is a real maintenance signal, but a repository with none can still reach 100/100.
79
Agent context & guidance
100Exceptional
How it's scored
| 45/45 | Agent instructions — AGENTS.md, CLAUDE.md |
| 15/15 | Machine-readable docs (llms.txt) — llms.txt present |
| 40/40 | Legible commit history — 84 of 100 human commits state their intent (structured subject or explanatory body) |
Inputs used
| has_llms_txt | yes |
| legible_history_share | 0.84 |
| agent_instruction_files | AGENTS.md, CLAUDE.md |
| agent_instruction_max_bytes | 2,595 |
How it's scored
| 18/18 | One-command bootstrap — noxfile.py |
| 22/22 | Automated tests |
| 11/11 | Lint / format config |
| 11/11 | Static type checking — duckdb_sqlalchemy/py.typed |
| 10/10 | Reproducible environment — lockfile |
| 0/10 | Demonstrated agent practice — no agent-authored commits among the last 100 |
| 5/8 | Automated maintenance — dependency automation configured, none observed in the sampled commits |
| 0/10 | OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0 |
Inputs used
| has_nix | no |
| has_tests | yes |
| lockfiles | uv.lock |
| has_dockerfile | no |
| typed_language | no |
| bootstrap_files | noxfile.py |
| has_devcontainer | no |
| has_linter_config | yes |
| typecheck_configs | duckdb_sqlalchemy/py.typed |
| agent_commit_share | 0 |
| toolchain_manifests | — |
| dependency_bot_commit_share | 0 |
How it's scored
| 27/45 | Type-checkable code — Python with type-check config (duckdb_sqlalchemy/py.typed) |
| 52.1/55 | Manageable file sizes — 2/38 source files over 60KB |
Inputs used
| primary_language | Python |
| largest_source_bytes | 75,234 |
| source_files_sampled | 38 |
| oversized_source_files | 2 |
How it's scored
| 0/40 | API schema (OpenAPI/GraphQL/proto) |
| 0/20 | MCP server |
| 40/40 | Runnable examples — examples |
Inputs used
| example_dirs | examples |
| has_mcp_signal | no |
| api_schema_files | — |
Key facts
16GitHub stars
25contributors
218commits, last 12 months
0days since last push
27releases
1bus factor
1open issues
PyPIpackage ecosystems
Data collection 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
More detail
OpenSSF Scorecard 5.1 / 10
5.1aggregate
Independent, tool-agnostic security assessment from the open-source OpenSSF Scorecard. Each check rewards a security practice, not a specific vendor's tool. Checks Scorecard could not determine are marked n/a and excluded from the security score (never counted as zero).
| 10 | Binary-Artifacts | no binaries found in the repo |
| 3 | Branch-Protection | branch protection is not maximal on development and all release branches |
| 9 | CI-Tests | 29 out of 30 merged PRs checked by a CI test -- score normalized to 9 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 0 | Code-Review | Found 0/30 approved changesets -- score normalized to 0 |
| 10 | Contributors | project has 10 contributing companies or organizations |
| 10 | Dangerous-Workflow | no dangerous workflow patterns detected |
| 10 | Dependency-Update-Tool | update tool detected |
| 0 | Fuzzing | project is not fuzzed |
| 10 | License | license file detected |
| 10 | Maintained | 30 commit(s) and 2 issue activity found in the last 90 days -- score normalized to 10 |
| 10 | Packaging | packaging workflow detected |
| 0 | Pinned-Dependencies | dependency not pinned by hash detected -- score normalized to 0 |
| 0 | SAST | SAST tool is not run on all commits -- score normalized to 0 |
| 0 | Security-Policy | security policy file not detected |
| n/a | Signed-Releases | no releases found |
| 0 | Token-Permissions | detected GitHub workflow tokens with excessive permissions |
| 4 | Vulnerabilities | 6 existing vulnerabilities detected |
Direct dependencies 4
| Registry | Package | Version constraint | Manifest |
|---|---|---|---|
| PyPI | duckdb | >=0.5.0 | pyproject.toml |
| PyPI | sqlalchemy | >=2.0.0 | pyproject.toml |
| PyPI | sqlalchemy | >=2.0.45 | pyproject.toml |
| PyPI | packaging | >=21 | pyproject.toml |
All dependencies not collected
The resolved dependency set could not be collected for this report: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository
Raw JSON report machine-readable
{
"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"
}Scores are signals, not warranties. They reflect publicly visible practices on GitHub — not a code audit, and not a security guarantee.
Missing data is excluded and weights renormalized, never scored as zero. Methodology is versioned and open: metrics v2.3.1, schema v0.27.0 — full methodology · metrics wiki.
How one result sits in the wider record: aggregate statistics — PyPI.