Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-10-19 05:38 UTC

iqmo-org / magic_duckdb

Jupyter Cell / Line Magics for DuckDB

Python · Jupyter NotebookBSD-3-Clause★ 58 stars⑂ 2 forkssince Mar 2023View on GitHub ↗
KindLibraryhow this is determined

iqmo-org/magic_duckdb holds a health index of 51 out of 100, placing it in the Moderate band. It scores highest on Engineering Quality (70/100) and lowest on Vitality (39/100). It was last updated 191 days ago. A single contributor accounts for most of its recent work.

51
overall / 100
Moderate

Software 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.

51
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)
VitalityCommunity &AdoptionSustainability &GovernanceEngineeringQualitySecurityAI Readiness

Score profile

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

The weighted overall 51 is calibrated to 51 on the published index scale (record calibration 2026-08-02).

Ownership

iqmo-orgOrganization
3 followers13 public repossince Apr 2022

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publish
PyPImagic_duckdb0.2.454735280 days ago

Metrics by category

Vitality

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

39Weak · 21% of overall

Development activity

13Critical
How it's scored
3.6/36Push recency — last push 191 days ago
2.8/36Commit cadence — 4/52 weeks with commits
7/18Commit volume — 5 commits in the last year
0/10OpenSSF Scorecard: Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
Inputs used
commits_last_year5
human_commit_share0.96
days_since_last_push191
active_weeks_last_year4

Release discipline

78Good
How it's scored
27/27Ships releases — 27 releases published
16.2/36Release recency — latest release 280 days ago
27/27Release cadence — a release every ~38.8 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count27
latest_release_tagv0.2.4
releases_from_tagsno
days_since_latest_release280
mean_days_between_releases38.8
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?

40Weak · 17% of overall

Popularity & adoption

28At Risk
How it's scored
28.5/60Stars — 58 stars
0/25Forks — 2 forks
0/15Watchers — 1 watchers
Inputs used
forks2
stars58
watchers1
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

50Moderate
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (BSD-3-Clause)
0/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges0
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_services—
has_pull_request_templateno

Ecosystem adoption (downloads)

46Weak
How it's scored
36.5/80Monthly downloads — 547 downloads/month across pypi
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagesmagic_duckdb
dependents—
ecosystemspypi
total_downloads—
monthly_downloads547
unverified_packages_excluded—
Excluded from scoring (no data or not applicable): Registry dependents. Remaining weights renormalized.

Sustainability & Governance

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

52Moderate · 23% of overall

Maintainer resilience (bus factor)

10Critical
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
0/22.5Commit distribution — top contributor authored 100% of commits
1.4/13.5Contributor breadth — 1 contributors
0/10OpenSSF Scorecard: Contributors — project has 0 contributing companies or organizations -- score normalized to 0
Inputs used
bus_factor1
contributors_sampled1
top_contributor_share1

Issue & PR responsiveness

71Good
How it's scored
40.6/42Issue resolution — 97% of issues closed
20.8/30PR acceptance — 27/39 decided PRs merged
0/13Newcomer PR acceptance — no first-time contributor's PR decided in 30d
0/15OpenSSF Scorecard: Code-Review — Found 0/16 approved changesets -- score normalized to 0
Inputs used
merged_prs27
open_issues1
closed_issues28
prs_merged_7d0
prs_decided_7d0
prs_merged_30d0
prs_decided_30d0
issue_closed_ratio0.966
closed_unmerged_prs12
first_time_authors_30d0
first_time_prs_merged_30d0
first_time_prs_decided_30d0
Excluded from scoring (no data or not applicable): Newcomer PR acceptance. Remaining weights renormalized.

Ownership & stewardship

52Moderate
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
4.3/25Owner reach — 3 followers of iqmo-org
17.3/25Track record — 13 public repos, account ~4 yr old
Inputs used
followers3
owner_typeOrganization
is_verifiedno
owner_loginiqmo-org
public_repos13
account_age_days1,635

Package maintenance

91Excellent
How it's scored
25/25Published & resolvable — 1 package(s) on pypi
26/35Publish recency — latest publish 280 days ago
20/20Version history — 35 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagesmagic_duckdb
ecosystemspypi
any_deprecatedno
min_days_since_publish280

Engineering Quality

Are baseline engineering and documentation practices in place?

70Good · 19% of overall

Engineering practices

80Excellent
How it's scored
24/24CI workflows — 2 workflow(s)
24/24Tests present
16/16Linter config — pyproject.toml ([tool.ruff], [tool.pylint])
9.6/9.6Pre-commit hooks
0/6.4.editorconfig
6/20OpenSSF Scorecard: CI-Tests — 7 out of 19 merged PRs checked by a CI test -- score normalized to 3
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configyes
has_precommit_configyes

Documentation

55Moderate
How it's scored
30/30README
0/25Documentation directory
15/15Documentation / homepage site — https://pypi.org/project/magic-duckdb/
10/10Repository description
0/10Topics
0/10Wiki
Inputs used
topics—
has_wikino
homepagehttps://pypi.org/project/magic-duckdb/
docs_sitehttps://pypi.org/project/magic-duckdb/
has_readmeyes
has_docs_dirno
has_descriptionyes

Security

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

57Moderate · 16% of overall

Security posture

46Weak
How it's scored
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
0.8/2.5CI-Tests — 7 out of 19 merged PRs checked by a CI test -- score normalized to 3
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 0/16 approved changesets -- score normalized to 0
0/2.5Contributors — project has 0 contributing companies or organizations -- score normalized to 0
10/10Dangerous-Workflow — no dangerous workflow patterns detected
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
0/7.5Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
5/5Packaging — packaging workflow detected
1/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 2
1/5SAST — SAST tool is not run on all commits -- score normalized to 2
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — no data
7.5/7.5Token-Permissions — GitHub workflow tokens follow principle of least privilege
0/7.5Vulnerabilities — 22 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate4.6
Excluded from scoring (no data or not applicable): Signed-Releases. Remaining weights renormalized.

Dependency advisories

100Exceptional
How it's scored
35/35Direct dependencies free of known advisories — no direct dependency carries a known advisory
25/25Indirect dependencies free of known advisories — no indirect dependency carries a known advisory
0/40No advisories left outstanding — no advisory carries a publication date
Inputs used
sourceosv
advisories0
affected_packages0
assessed_packages22
unassessed_packages0
affected_by_severitynone
direct_affected_packages0
Excluded from scoring (no data or not applicable): No advisories left outstanding. Remaining weights renormalized. Matched the pypi:magic_duckdb@0.2.4 runtime dependency closure — what installing the published package pulls in — 22 packages. Reachability is not analyzed.

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.

50Moderate · 4% of overall

Agent context & guidance

18Critical
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
17.8/40Legible commit history — 32 of 96 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
llms_txt_url—
legible_history_share0.333
agent_instruction_files—
agent_instruction_max_bytes—

Verify loop (build / test / typecheck)

53Moderate
How it's scored
0/18One-command bootstrap
22/22Automated tests
11/11Lint / format config — pyproject.toml ([tool.ruff], [tool.pylint])
0/11Static type checking
10/10Reproducible environment — lockfile
0/10Demonstrated agent practice — no agent-authored commits among the last 100
8/8Automated maintenance — 4 of the last 100 commits are automated dependency updates
2/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 2
Inputs used
has_nixno
has_testsyes
lockfilesuv.lock
has_dockerfileno
typed_languageno
bootstrap_files—
has_devcontainerno
has_linter_configyes
typecheck_configs—
agent_commit_share0
toolchain_manifests—
dependency_bot_commit_share0.04

Code legibility for models

55Moderate
How it's scored
0/45Type-checkable code — Python without a type-check config
55/55Manageable file sizes — 0/22 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes8,945
source_files_sampled22
oversized_source_files0

Machine-readable interfaces

100Exceptional
How it's scored
0/40API schema (OpenAPI/GraphQL/proto) — not applicable to this kind of software
0/20MCP server — not applicable to this kind of software
40/40Runnable examples — notebooks
Inputs used
example_dirsnotebooks
has_mcp_signalno
api_schema_files—
interfaces_expected_of—
Excluded from scoring (no data or not applicable): API schema (OpenAPI/GraphQL/proto), MCP server. Remaining weights renormalized.

Key facts

58GitHub stars
1contributors
5commits, last 12 months
191days 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

More detail

Star and fork history 0 ★ / 2 ⇿
0Stars
2Forks
20Releases

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

111222212023-042024-052025-05
Major 0Minor 0Patch 8

Each point covers 2 days.

OpenSSF Scorecard 4.6 / 10
4.6aggregate

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

10Binary-Artifactsno binaries found in the repo
3Branch-Protectionbranch protection is not maximal on development and all release branches
3CI-Tests7 out of 19 merged PRs checked by a CI test -- score normalized to 3
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 0/16 approved changesets -- score normalized to 0
0Contributorsproject has 0 contributing companies or organizations -- score normalized to 0
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
0Maintained0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
10Packagingpackaging workflow detected
2Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 2
2SASTSAST tool is not run on all commits -- score normalized to 2
0Security-Policysecurity policy file not detected
n/aSigned-Releasesno releases found
10Token-PermissionsGitHub workflow tokens follow principle of least privilege
0Vulnerabilities22 existing vulnerabilities detected
Direct dependencies 3
RegistryPackageVersion constraintManifest
PyPIpandas>=2.1.2pyproject.toml
PyPIipython>=8.0.0pyproject.toml
PyPIjinja2>=3.1.2pyproject.toml
All dependencies 100

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

RegistryPackageVersionRelation
PyPIipython8.38.0direct
PyPIipython9.9.0direct
PyPIjinja23.1.6direct
PyPIpandas2.3.3direct
PyPIannotated-types0.7.0indirect
PyPIanyio4.12.1indirect
PyPIappnope0.1.4indirect
PyPIastroid4.0.3indirect
PyPIasttokens3.0.1indirect
PyPIattrs25.4.0indirect
PyPIbackports-asyncio-runner1.2.0indirect
PyPIcertifi2026.1.4indirect
PyPIcffi2.0.0indirect
PyPIcfgv3.5.0indirect
PyPIcolorama0.4.6indirect
PyPIcomm0.2.3indirect
PyPIcoverage7.13.1indirect
PyPIdebugpy1.8.19indirect
PyPIdecorator5.2.1indirect
PyPIdill0.4.0indirect
PyPIdistlib0.4.0indirect
PyPIdistro1.9.0indirect
PyPIduckdb1.4.3indirect
PyPIexceptiongroup1.3.1indirect
PyPIexecnet2.1.2indirect
PyPIexecuting2.2.1indirect
PyPIfastjsonschema2.21.2indirect
PyPIfilelock3.20.3indirect
PyPIgraphviz0.21indirect
PyPIh110.16.0indirect
PyPIhttpcore1.0.9indirect
PyPIhttpx0.28.1indirect
PyPIidentify2.6.15indirect
PyPIidna3.11indirect
PyPIiniconfig2.3.0indirect
PyPIipykernel7.1.0indirect
PyPIipython-pygments-lexers1.1.1indirect
PyPIisort7.0.0indirect
PyPIjedi0.19.2indirect
PyPIjiter0.12.0indirect
PyPIjsonschema4.26.0indirect
PyPIjsonschema-specifications2025.9.1indirect
PyPIjupyter-client8.8.0indirect
PyPIjupyter-core5.9.1indirect
PyPImarkupsafe3.0.3indirect
PyPImatplotlib-inline0.2.1indirect
PyPImccabe0.7.0indirect
PyPInbclient0.10.4indirect
PyPInbformat5.10.4indirect
PyPInest-asyncio1.6.0indirect
PyPInodeenv1.10.0indirect
PyPInumpy2.2.6indirect
PyPInumpy2.4.1indirect
PyPIopenai2.15.0indirect
PyPIpackaging25.0indirect
PyPIparso0.8.5indirect
PyPIpexpect4.9.0indirect
PyPIplatformdirs4.5.1indirect
PyPIpluggy1.6.0indirect
PyPIpolars1.37.0indirect
PyPIpolars-runtime-321.37.0indirect
PyPIpre-commit4.5.1indirect
PyPIpre-commit-uv4.2.1indirect
PyPIprompt-toolkit3.0.52indirect
PyPIpsutil7.2.1indirect
PyPIptyprocess0.7.0indirect
PyPIpure-eval0.2.3indirect
PyPIpyarrow22.0.0indirect
PyPIpycparser2.23indirect
PyPIpydantic2.12.5indirect
PyPIpydantic-core2.41.5indirect
PyPIpygments2.19.2indirect
PyPIpylint4.0.4indirect
PyPIpytest9.0.2indirect
PyPIpytest-asyncio1.3.0indirect
PyPIpytest-cov7.0.0indirect
PyPIpytest-randomly4.0.1indirect
PyPIpytest-xdist3.8.0indirect
PyPIpython-dateutil2.9.0.post0indirect
PyPIpytz2025.2indirect
PyPIpyyaml6.0.3indirect
PyPIpyzmq27.1.0indirect
PyPIreferencing0.37.0indirect
PyPIrpds-py0.30.0indirect
PyPIruff0.15.7indirect
PyPIsix1.17.0indirect
PyPIsniffio1.3.1indirect
PyPIstack-data0.6.3indirect
PyPItabulate0.9.0indirect
PyPItomli2.4.0indirect
PyPItomlkit0.13.3indirect
PyPItornado6.5.5indirect
PyPItqdm4.67.1indirect
PyPItraitlets5.14.3indirect
PyPItyping-extensions4.15.0indirect
PyPItyping-inspection0.4.2indirect
PyPItzdata2025.3indirect
PyPIuv0.9.24indirect
PyPIvirtualenv20.36.1indirect
PyPIwcwidth0.2.14indirect
Dependency advisories 0

Installing pypi:magic_duckdb@0.2.4 pulls in 22 packages, direct and transitive: 0 carry known advisories, of which 0 are direct dependencies.

No known advisories affect the assessed dependencies.

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

Raw JSON report machine-readable

Feedback

Spotted something off in this report, or have thoughts to share? Wrong measurements, missed tooling, ideas, questions — anything is welcome. Every message is read and gets a response.

The message is kept through sign-in.

Related records

Inspected repositories sharing catalogue tags or ecosystems with iqmo-org/magic_duckdb. Read them side by side →

100onnx/onnxOpen standard for machine learning interoperabilityExceptional100deepset-ai/haystackOpen-source AI orchestration framework for building context-engineered, production-ready LLM applications. Design modular pipelines and agent workflows with explicit control over retrieval, routing, memory, and generation. Built for scalable agents, RAG, multimodal applications, semantic search, and conversational systems.Exceptional100go-gitea/giteaGit with a cup of tea! Painless self-hosted all-in-one software development service, including Git hosting, code review, team collaboration, package registry and CI/CDExceptional100matplotlib/matplotlibmatplotlib: plotting with PythonExceptional100apache/airflowApache Airflow - A platform to programmatically author, schedule, and monitor workflowsExceptional100microsoft/onnxruntimeONNX Runtime: cross-platform, high performance ML inferencing and training acceleratorExceptional

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.10.0, schema v0.34.0 — full methodology · metrics wiki.

How one result sits in the wider record: aggregate statistics — PyPI.