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.

For dataease/SQLBot, the reply time has too small a sample to measure (0 pull requests counted; 10 needed). 1% of 148 outside pull requests got no reply within 14 days (20 April to 17 October 2026). It ranks 1,087 of 3,219 overall. For first-time contributors it ranks 844 of 1,525 (the bottom 45%).

Key facts
Rank1,087 of 3,219
Score54.55
TierC
Median first reply—
14-day no-reply share1%
First-timer rank844 of 1,525
EcosystemJavaScript
Window20 April to 17 October 2026

Composite

Rank
1,087 of 3,219
Score
54.55
Tier
C
Coverage
69% · Ceiling B
Quadrant
Nursery

Coordinates: leverage 46.9 (coverage 68%), friction 34.9 (coverage 75%)

Five pillars

Score out of 100, and how much of the pillar was measured
PillarScoreCoverage
Responsiveness91.670%
Criticality47.635%
Governance50.5100%
Rigor43.4100%
Accessibility21.050%

The measured parameters

Responsiveness

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

Criticality

ParameterValueScoreCountWindowSource
DependentsPackages in the registry that depend on this project, counted once each.Not shown: Third-party data unavailable
Monthly DownloadsDownloads from the package registry in a month.Not shown: Third-party data unavailable
OpenSSF CriticalityOpenSSF criticality score from 0 to 1, computed from the project's public activity signals.0.475847.6——proxy:no_dependents_signalraw/github_meta/dataease__SQLBot.json

Governance

ParameterValueScoreCountWindowSource
Elephant FactorThe fewest organisations that account for half of the last year's commits.125.0847—primaryraw/commits_365d/dataease__SQLBot.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/dataease__SQLBot.json
Promotion LadderHow openly a contributor can become a maintainer, from closed to verified.No written path to becoming a maintainer40.0——primaryraw/governance/dataease__SQLBot.json

Rigor

ParameterValueScoreCountWindowSource
AI Policy PostureWhether the project has a written policy on AI-assisted contributions.Written AI policy95.0——primaryraw/governance/dataease__SQLBot.json
Pipeline DefensesHow well the project's build and review pipeline defends against bad changes, 0 to 100.37.333337.3184—proxy:review_ciraw/pr_window/dataease__SQLBot.json
Substantive Review RateShare of decided pull requests that received a substantive review.0.0%0.015519 April to 16 October 2026primaryraw/pr_window/dataease__SQLBot.json

Accessibility

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

Persona view

PersonaRankScoreTierStatus
Balanced1,087 of 3,21954.55CRated
First-timer844 of 1,52555.02B (capped)Rated
Career capitalThis repository's production-criticality signal is not yet high enough for career-capital ranking.
Senior systemsFewer than 3 organizations account for most commits (not multi-vendor).
AI-assisted1,504 of 3,69652.71CRated

Integrity

Snapshot
2026-10-17
Raw hash
4cc554fe64bf323370f99c472baa68643704ba9676e4a99229b4b5ae9dac20fe

No suspicion flags on this repository.

The full record is in data/2026-10-17/repos/b8.json, under the key dataease/SQLBot.

How every number is measured: Porchlamp methodology.

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

Porchlamp (2026). dataease/SQLBot. Snapshot 2026-10-17. https://porchlamp.org/projects/dataease/sqlbot/. CC BY 4.0.

Similar projects

The ranked projects nearest this one in the same ecosystem.