Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-09-17 19:42 UTC

explorerhq / sql-explorer

SQL reporting that Just Works. Fast, simple, and confusion-free. Write and share queries in a delightful SQL editor, with AI assistance.

Python · JavaScript · HTMLCustom license★ 2,874 stars⑂ 373 forkssince Dec 2013View on GitHub ↗

explorerhq/sql-explorer holds a health index of 34 out of 100, placing it in the At Risk band. It scores highest on Engineering Quality (88/100) and lowest on Vitality (28/100). It was last updated 512 days ago. A single contributor accounts for most of its recent work.

34
overall / 100
At Risk

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.

34
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 58 is calibrated to 62 on the published index scale (record calibration 2026-08-02).

Ownership

SQL Explorer, IncOrganization
10 followers2 public repossince May 2024

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publishTags
PyPIdjango-sql-explorer5.3233,96968722 days agodjangosqlexplorerreportsreportingcsvjsondatabasequery

Metrics by category

Vitality

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

28At Risk · 21% of overall
How it's scored
0/36Push recency — last push 512 days ago
0/36Commit cadence — 0/52 weeks with commits
0/18Commit volume — 0 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_year0
human_commit_share0.96
days_since_last_push512
active_weeks_last_year0
How it's scored
27/27Ships releases — 42 releases published
7.2/36Release recency — latest release 722 days ago
27/27Release cadence — a release every ~10.1 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count42
latest_release_tag5.3.0
releases_from_tagsno
days_since_latest_release722
mean_days_between_releases10.1
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?

72Good · 17% of overall
How it's scored
56.1/60Stars — 2,874 stars
21.4/25Forks — 373 forks
9.9/15Watchers — 62 watchers
Inputs used
forks373
stars2,874
watchers62
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
How it's scored
22.5/22.5README
16.9/22.5License — license file present, not a recognized license
0/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges4
has_contributingno
has_issue_templateno
has_code_of_conductno
readme_badge_servicesreadthedocs.org, shields.io
has_pull_request_templateno
How it's scored
71.6/80Monthly downloads — 233,969 downloads/month across pypi
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagesdjango-sql-explorer
dependents—
ecosystemspypi
total_downloads—
monthly_downloads233,969
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?

57Moderate · 23% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
6.3/22.5Commit distribution — top contributor authored 72% of commits
13.5/13.5Contributor breadth — 88 contributors
10/10OpenSSF Scorecard: Contributors — project has 20 contributing companies or organizations
Inputs used
bus_factor1
contributors_sampled88
top_contributor_share0.719
How it's scored
37.3/42Issue resolution — 89% of issues closed
24.8/30PR acceptance — 304/368 decided PRs merged
0/13Newcomer PR acceptance — no first-time contributor's PR decided in 30d
1.5/15OpenSSF Scorecard: Code-Review — Found 3/28 approved changesets -- score normalized to 1
Inputs used
merged_prs304
open_issues37
closed_issues292
prs_merged_7d0
prs_decided_7d0
prs_merged_30d0
prs_decided_30d0
issue_closed_ratio0.888
closed_unmerged_prs64
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.
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
7.5/25Owner reach — 10 followers of explorerhq
8.1/25Track record — 2 public repos, account ~2 yr old
Inputs used
followers10
owner_typeOrganization
is_verifiedno
owner_loginexplorerhq
public_repos2
account_age_days848
How it's scored
25/25Published & resolvable — 1 package(s) on pypi
14/35Publish recency — latest publish 722 days ago
20/20Version history — 68 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagesdjango-sql-explorer
ecosystemspypi
any_deprecatedno
min_days_since_publish722

Engineering Quality

Are baseline engineering and documentation practices in place?

88Excellent · 19% of overall
How it's scored
24/24CI workflows — 6 workflow(s)
24/24Tests present
16/16Linter config — ruff.toml, setup.cfg ([flake8], [isort]), tox.ini
9.6/9.6Pre-commit hooks
6.4/6.4.editorconfig
0/20OpenSSF Scorecard: CI-Tests — 0 out of 22 merged PRs checked by a CI test -- score normalized to 0
Inputs used
has_ciyes
has_testsyes
has_editorconfigyes
has_linter_configyes
has_precommit_configyes

Documentation

100Exceptional
How it's scored
30/30README
25/25Documentation directory
15/15Documentation / homepage site — https://www.sqlexplorer.io
10/10Repository description
10/10Topics — 5 topics
10/10Wiki
Inputs used
topicssql, analytics, ai, django-application, reporting
has_wikiyes
homepagehttps://www.sqlexplorer.io
docs_sitehttps://www.sqlexplorer.io
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

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

52Moderate · 16% of overall
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — no data
0/2.5CI-Tests — 0 out of 22 merged PRs checked by a CI test -- score normalized to 0
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0.8/7.5Code-Review — Found 3/28 approved changesets -- score normalized to 1
2.5/2.5Contributors — project has 20 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.2/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
0/5Packaging — no data
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
3.5/5SAST — SAST tool detected but not run on all commits
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — no data
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
0/7.5Vulnerabilities — 52 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated15
scorecard_versionv5.5.0
checks_inconclusive3
scorecard_aggregate4
Excluded from scoring (no data or not applicable): Branch-Protection, Packaging, 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_packages13
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:django-sql-explorer@5.3 runtime dependency closure — what installing the published package pulls in — 13 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.

53Moderate · 4% of overall
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
31.1/40Legible commit history — 56 of 96 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
llms_txt_url—
legible_history_share0.583
agent_instruction_files—
agent_instruction_max_bytes—
How it's scored
18/18One-command bootstrap — docs/Makefile
22/22Automated tests
11/11Lint / format config — ruff.toml, setup.cfg ([flake8], [isort]), tox.ini
0/11Static type checking
10/10Reproducible environment — Dockerfile, 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
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfilespackage-lock.json
has_dockerfileyes
typed_languageno
bootstrap_filesdocs/Makefile
has_devcontainerno
has_linter_configyes
typecheck_configs—
agent_commit_share0
toolchain_manifests—
dependency_bot_commit_share0.04
How it's scored
0/45Type-checkable code — Python without a type-check config
54.5/55Manageable file sizes — 1/121 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes77,235
source_files_sampled121
oversized_source_files1

Key facts

2,874GitHub stars
88contributors
0commits, last 12 months
512days since last push
42releases
1bus factor
37open issues
npm, PyPIpackage ecosystems

Data collection warnings

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
  • Could not fetch npm package 'django-sql-explorer' from its registry

More detail

Star and fork history 0 ★ / 373 ⇿
0Stars
373Forks
42Releases

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.

0125250375355162014-012020-052026-08
Major 1Minor 10Patch 10

Each point covers 12 days.

OpenSSF Scorecard 4.0 / 10
4.0aggregate

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-09-17 19:41 UTC

10Binary-Artifactsno binaries found in the repo
n/aBranch-Protectioninternal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md
0CI-Tests0 out of 22 merged PRs checked by a CI test -- score normalized to 0
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
1Code-ReviewFound 3/28 approved changesets -- score normalized to 1
10Contributorsproject has 20 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
9Licenselicense file detected
0Maintained0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
n/aPackagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
7SASTSAST tool detected but not run on all commits
0Security-Policysecurity policy file not detected
n/aSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
0Vulnerabilities52 existing vulnerabilities detected
Direct dependencies 12
RegistryPackageVersion constraintManifest
npm@codemirror/lang-sql^6.5.4package.json
npm@codemirror/language-data^6.3.1package.json
npmbootstrap^5.0.1package.json
npmbootstrap-icons^1.11.2package.json
npmchoices.js^10.2.0package.json
npmcodemirror^6.0.1package.json
npmcookiejs^2.1.3package.json
npmdompurify^3.1.3package.json
npmjquery^3.7.1package.json
npmlist.js^2.3.1package.json
npmmarked^11.1.1package.json
npmsortablejs^1.15.2package.json
All dependencies 162

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

RegistryPackageVersionRelation
npm@codemirror/lang-sql6.5.4direct
npm@codemirror/language-data6.3.1direct
npmbootstrap5.3.2direct
npmbootstrap-icons1.11.2direct
npmchoices.js10.2.0direct
npmcodemirror6.0.1direct
npmcookiejs2.1.3direct
npmdompurify3.1.3direct
npmjquery3.7.1direct
npmlist.js2.3.1direct
npmmarked11.1.1direct
npmsortablejs1.15.2direct
npm@babel/runtime7.25.0indirect
npm@codemirror/autocomplete6.11.1indirect
npm@codemirror/commands6.3.2indirect
npm@codemirror/lang-angular0.1.2indirect
npm@codemirror/lang-cpp6.0.2indirect
npm@codemirror/lang-css6.2.1indirect
npm@codemirror/lang-html6.4.7indirect
npm@codemirror/lang-java6.0.1indirect
npm@codemirror/lang-javascript6.2.1indirect
npm@codemirror/lang-json6.0.1indirect
npm@codemirror/lang-less6.0.1indirect
npm@codemirror/lang-markdown6.2.3indirect
npm@codemirror/lang-php6.0.1indirect
npm@codemirror/lang-python6.1.3indirect
npm@codemirror/lang-rust6.0.1indirect
npm@codemirror/lang-sass6.0.2indirect
npm@codemirror/lang-vue0.1.2indirect
npm@codemirror/lang-wast6.0.1indirect
npm@codemirror/lang-xml6.0.2indirect
npm@codemirror/language6.9.3indirect
npm@codemirror/legacy-modes6.3.3indirect
npm@codemirror/lint6.4.2indirect
npm@codemirror/search6.5.5indirect
npm@codemirror/state6.3.3indirect
npm@codemirror/view6.22.3indirect
npm@esbuild/aix-ppc640.21.5indirect
npm@esbuild/android-arm0.21.5indirect
npm@esbuild/android-arm640.21.5indirect
npm@esbuild/android-x640.21.5indirect
npm@esbuild/darwin-arm640.21.5indirect
npm@esbuild/darwin-x640.21.5indirect
npm@esbuild/freebsd-arm640.21.5indirect
npm@esbuild/freebsd-x640.21.5indirect
npm@esbuild/linux-arm0.21.5indirect
npm@esbuild/linux-arm640.21.5indirect
npm@esbuild/linux-ia320.21.5indirect
npm@esbuild/linux-loong640.21.5indirect
npm@esbuild/linux-mips64el0.21.5indirect
npm@esbuild/linux-ppc640.21.5indirect
npm@esbuild/linux-riscv640.21.5indirect
npm@esbuild/linux-s390x0.21.5indirect
npm@esbuild/linux-x640.21.5indirect
npm@esbuild/netbsd-x640.21.5indirect
npm@esbuild/openbsd-x640.21.5indirect
npm@esbuild/sunos-x640.21.5indirect
npm@esbuild/win32-arm640.21.5indirect
npm@esbuild/win32-ia320.21.5indirect
npm@esbuild/win32-x640.21.5indirect
npm@lezer/common1.1.2indirect
npm@lezer/cpp1.1.1indirect
npm@lezer/css1.1.4indirect
npm@lezer/highlight1.2.0indirect
npm@lezer/html1.3.7indirect
npm@lezer/java1.1.0indirect
npm@lezer/javascript1.4.11indirect
npm@lezer/json1.0.1indirect
npm@lezer/lr1.3.14indirect
npm@lezer/markdown1.2.0indirect
npm@lezer/php1.0.1indirect
npm@lezer/python1.1.9indirect
npm@lezer/rust1.0.1indirect
npm@lezer/sass1.0.3indirect
npm@lezer/xml1.0.3indirect
npm@nodelib/fs.scandir2.1.5indirect
npm@nodelib/fs.stat2.0.5indirect
npm@nodelib/fs.walk1.2.8indirect
npm@popperjs/core2.11.8indirect
npm@rollup/rollup-android-arm-eabi4.21.3indirect
npm@rollup/rollup-android-arm644.21.3indirect
npm@rollup/rollup-darwin-arm644.21.3indirect
npm@rollup/rollup-darwin-x644.21.3indirect
npm@rollup/rollup-linux-arm-gnueabihf4.21.3indirect
npm@rollup/rollup-linux-arm-musleabihf4.21.3indirect
npm@rollup/rollup-linux-arm64-gnu4.21.3indirect
npm@rollup/rollup-linux-arm64-musl4.21.3indirect
npm@rollup/rollup-linux-powerpc64le-gnu4.21.3indirect
npm@rollup/rollup-linux-riscv64-gnu4.21.3indirect
npm@rollup/rollup-linux-s390x-gnu4.21.3indirect
npm@rollup/rollup-linux-x64-gnu4.21.3indirect
npm@rollup/rollup-linux-x64-musl4.21.3indirect
npm@rollup/rollup-win32-arm64-msvc4.21.3indirect
npm@rollup/rollup-win32-ia32-msvc4.21.3indirect
npm@rollup/rollup-win32-x64-msvc4.21.3indirect
npm@types/estree1.0.5indirect
npmanymatch3.1.3indirect
npmbinary-extensions2.2.0indirect
npmbraces3.0.3indirect
npmchokidar3.5.3indirect
npmcrelt1.0.6indirect
npmdeepmerge4.3.1indirect
npmesbuild0.21.5indirect
npmfast-glob3.3.2indirect
npmfastq1.17.1indirect
npmfill-range7.1.1indirect
npmfs-extra11.2.0indirect
npmfsevents2.3.3indirect
npmfuse.js6.6.2indirect
npmglob-parent5.1.2indirect
npmgraceful-fs4.2.11indirect
npmimmutable4.3.4indirect
npmis-binary-path2.1.0indirect
npmis-extglob2.1.1indirect
npmis-glob4.0.3indirect
npmis-number7.0.0indirect
npmjsonfile6.1.0indirect
npmmerge21.4.1indirect
npmmicromatch4.0.7indirect
npmnanoid3.3.7indirect
npmnormalize-path3.0.0indirect
npmpicocolors1.1.0indirect
npmpicomatch2.3.1indirect
npmpostcss8.4.47indirect
npmqueue-microtask1.2.3indirect
npmreaddirp3.6.0indirect
npmredux4.2.1indirect
npmregenerator-runtime0.14.1indirect
npmreusify1.0.4indirect
npmrollup4.21.3indirect
npmrun-parallel1.2.0indirect
npmsass1.69.5indirect
npmsource-map-js1.2.1indirect
npmstring-natural-compare2.0.3indirect
npmstyle-mod4.1.0indirect
npmto-regex-range5.0.1indirect
npmuniversalify2.0.1indirect
npmvite5.4.6indirect
npmvite-plugin-copy0.1.6indirect
npmvite-plugin-static-copy1.0.5indirect
npmw3c-keyname2.2.8indirect
PyPIboto3—indirect
PyPIcelery—indirect
PyPIcoverage—indirect
PyPIcryptography—indirect
PyPIdjango—indirect
PyPIdjango-cryptography-django52.2indirect
PyPIdjango-sql-explorer—indirect
PyPIfactory-boy—indirect
PyPIfuro—indirect
PyPIimportlib-metadata—indirect
PyPImatplotlib—indirect
PyPIopenai—indirect
PyPIpandas—indirect
PyPIpython-dateutil—indirect
PyPIredis—indirect
PyPIrequests—indirect
PyPIsphinx—indirect
PyPIsphinx-copybutton—indirect
PyPIsphinxext-opengraph—indirect
PyPIsqlparse—indirect
PyPIxlsxwriter—indirect
Dependency advisories 0

Installing pypi:django-sql-explorer@5.3 pulls in 13 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.

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.