PorchlampFind the projects that leave the light on.2026-10-17

What happens to a stranger's pull request here, in the Porchlamp snapshot of 17 October 2026.

Outside pull requests to sqlalchemy/alembic got a first human reply in a median of under 0.1 hours (23 pull requests, 19 April to 16 October 2026); 38% got none within 14 days. It ranks 1,398 of 3,219 overall. It is not ranked for first-time contributors: this repository does not show a low enough barrier for a first-time contributor.

Key facts
Rank1,398 of 3,219
Score52.12
TierC
Median first replyunder 0.1 hours
14-day no-reply share38%
First-timer rankThis repository does not show a low enough barrier for a first-time contributor.
EcosystemPython
Window19 April to 16 October 2026

Composite

Rank
1,398 of 3,219
Score
52.12
Tier
C
Coverage
89% · Ceiling A
Quadrant
Crucible

Coordinates: leverage 62.3 (coverage 100%), friction 54.9 (coverage 80%)

Five pillars

Score out of 100, and how much of the pillar was measured
PillarScoreCoverage
Responsiveness51.965%
Criticality76.9100%
Governance50.5100%
Rigor45.7100%
Accessibility19.885%

The measured parameters

Responsiveness

ParameterValueScoreCountWindowSource
Decision Rate (90d)Share of outside pull requests that were merged or closed within 90 days.Not shown: Insufficient sample size
PR Ghost Rate (14d)Share of outside pull requests with no maintainer response, merge or close within 14 days.37.5%25.02420 April to 17 October 2026primaryraw/pr_window/sqlalchemy__alembic.json
First-timer Merge RateShare of first-time outside authors' decided pull requests that were merged.0.0%0.013—primaryraw/author_history/sqlalchemy__alembic.json
Time to First ResponseMedian hours from an outside pull request opening to its first substantive human reply.0.0 hours (0 days)100.02319 April to 16 October 2026primaryraw/pr_window/sqlalchemy__alembic.json
Time to Merge (p90)Hours within which 90% of merged outside pull requests were merged.Not shown: Insufficient sample size

Criticality

ParameterValueScoreCountWindowSource
DependentsPackages in the registry that depend on this project, counted once each.62089.6——primaryraw/dependents/sqlalchemy__alembic.json
Monthly DownloadsDownloads from the package registry in a month.179.1 million downloads a month95.7——primaryraw/downloads/pypi__alembic.json
OpenSSF CriticalityOpenSSF criticality score from 0 to 1, computed from the project's public activity signals.0.488748.9——primaryraw/github_meta/sqlalchemy__alembic.json

Governance

ParameterValueScoreCountWindowSource
Elephant FactorThe fewest organisations that account for half of the last year's commits.125.0118—primaryraw/commits_365d/sqlalchemy__alembic.json
Legal IP RegimeThe contributor licence regime: DCO, none, a foundation CLA or a corporate CLA.No CLA or sign-off found85.0——primaryraw/governance/sqlalchemy__alembic.json
Promotion LadderHow openly a contributor can become a maintainer, from closed to verified.No written path to becoming a maintainer40.0——primaryraw/governance/sqlalchemy__alembic.json

Rigor

ParameterValueScoreCountWindowSource
AI Policy PostureWhether the project has a written policy on AI-assisted contributions.No written AI policy40.0——primaryraw/governance/sqlalchemy__alembic.json
Pipeline DefensesHow well the project's build and review pipeline defends against bad changes, 0 to 100.47.547.5——primaryraw/scorecard/sqlalchemy__alembic.json
Substantive Review RateShare of decided pull requests that received a substantive review.39.3%49.12819 April to 16 October 2026primaryraw/pr_window/sqlalchemy__alembic.json

Accessibility

ParameterValueScoreCountWindowSource
Developer ExperienceDeveloper experience, 0 to 100: half CI run time, half setup signals.5050.030—primaryraw/actions_runs/sqlalchemy__alembic.json
Newcomer ConversionShare of first-time authors whose first pull request merged within 180 days.13.3%26.715—primaryraw/author_history/sqlalchemy__alembic.json
Newcomer Issue SupplyOpen, unassigned, up-to-date issues marked for newcomers.00.0——primaryraw/gfi/sqlalchemy__alembic.json
Newcomer Return RateShare of those merged first-time authors who sent a second pull request within 90 days.Not shown: Insufficient sample size

Persona view

PersonaRankScoreTierStatus
Balanced1,398 of 3,21952.12CRated
First-timerThis repository does not show a low enough barrier for a first-time contributor.
Career capital566 of 79853.39CRated
Senior systemsFewer than 3 organizations account for most commits (not multi-vendor).
AI-assisted1,677 of 3,69651.32CRated

Integrity

Snapshot
2026-10-17
Raw hash
4dc9e5f772b849cb255317724a99b53d192f943c2f6f8b4ecf2919d7ceebdfa6

No suspicion flags on this repository.

The full record is in data/2026-10-17/repos/7f.json, under the key sqlalchemy/alembic.

How every number is measured: Porchlamp methodology.

Open an issue about this record and say what looks wrong.

Porchlamp (2026). sqlalchemy/alembic. Snapshot 2026-10-17. https://porchlamp.org/projects/sqlalchemy/alembic/. CC BY 4.0.

Similar projects

The ranked projects nearest this one in the same ecosystem.