Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-10-02 02:36 UTC

tconbeer / harlequin

The SQL IDE for Your Terminal. Now with hsql, your agent's favorite sql client.

PythonMIT★ 6,444 stars⑂ 180 forkssince May 2023View on GitHub ↗
KindCommand-line toolPluginTerminal interfaceLibraryhow this is determined

tconbeer/harlequin holds a health index of 89 out of 100, placing it in the Excellent band. It scores highest on Engineering Quality (92/100) and lowest on Security (52/100). It was last updated today. A single contributor accounts for most of its recent work.

89
overall / 100
Excellent

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.

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

Ownership

Ted ConbeerPersonal account
212 followers46 public repossince Apr 2011Shandy Data LLC

This repository is owned by a personal account. A single-owner project carries more continuity risk than an organization-backed one.

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publishTags
PyPIharlequin2.16.143,2271060 days agoharlequinidesqltextualtui

Metrics by category

Vitality

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

85Excellent · 21% of overall
How it's scored
36/36Push recency — last push 0 days ago
16.6/36Commit cadence — 24/52 weeks with commits
18/18Commit volume — 195 commits in the last year
10/10OpenSSF Scorecard: Maintained — 30 commit(s) and 19 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year195
human_commit_share0.85
days_since_last_push0
active_weeks_last_year24
How it's scored
27/27Ships releases — 100 releases published
36/36Release recency — latest release 0 days ago
27/27Release cadence — a release every ~4.2 days
0/10OpenSSF Scorecard: Signed-Releases — Project has not signed or included provenance with any releases.
Inputs used
releases_count100
latest_release_tagv2.16.1
releases_from_tagsno
days_since_latest_release0
mean_days_between_releases4.2

Community & Adoption

Does the project have users, downloads, attention, and a welcoming setup for contributors?

81Excellent · 17% of overall
How it's scored
60/60Stars — 6,444 stars
18.8/25Forks — 180 forks
7.5/15Watchers — 23 watchers
Inputs used
forks180
stars6,444
watchers23
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (MIT)
18/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
6.3/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges3
has_contributingyes
has_issue_templateno
has_code_of_conductno
readme_badge_servicesshields.io
has_pull_request_templateyes
How it's scored
61.8/80Monthly downloads — 43,227 downloads/month across pypi
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagesharlequin
dependents—
ecosystemspypi
total_downloads—
monthly_downloads43,227
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?

61Moderate · 23% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
1.7/22.5Commit distribution — top contributor authored 92% of commits
13.5/13.5Contributor breadth — 22 contributors
3/10OpenSSF Scorecard: Contributors — project has 1 contributing companies or organizations -- score normalized to 3
Inputs used
bus_factor1
contributors_sampled22
top_contributor_share0.923
How it's scored
39.6/42Issue resolution — 94% of issues closed
22.3/30PR acceptance — 558/749 decided PRs merged
5.2/13Newcomer PR acceptance — 2/5 first-time contributors' PRs merged in 30d
0/15OpenSSF Scorecard: Code-Review — Found 2/26 approved changesets -- score normalized to 0
Inputs used
merged_prs558
open_issues17
closed_issues287
prs_merged_7d6
prs_decided_7d7
prs_merged_30d41
prs_decided_30d45
issue_closed_ratio0.944
closed_unmerged_prs191
first_time_authors_30d4
first_time_prs_merged_30d2
first_time_prs_decided_30d5
How it's scored
10/30Ownership backing — personal (user) account
0/20Verified domain — not applicable to user accounts
16.7/25Owner reach — 212 followers of tconbeer
24.2/25Track record — 46 public repos, account ~15 yr old
Inputs used
followers212
owner_typeUser
is_verified—
owner_logintconbeer
public_repos46
account_age_days5,661
Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.

Package maintenance

100Exceptional
How it's scored
25/25Published & resolvable — 1 package(s) on pypi
35/35Publish recency — latest publish 0 days ago
20/20Version history — 106 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagesharlequin
ecosystemspypi
any_deprecatedno
min_days_since_publish0

Engineering Quality

Are baseline engineering and documentation practices in place?

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

Documentation

90Excellent
How it's scored
30/30README
25/25Documentation directory
15/15Documentation / homepage site — https://harlequin.sh
10/10Repository description
10/10Topics — 20 topics
0/10Wiki
Inputs used
topicsagent, db-cli, db-client, duckdb, mariadb, mssql, mysql, odbc, postgres, redshift, snowflake, sql, sqlite, textual, tui, cli, client, database, python, db
has_wikino
homepagehttps://harlequin.sh
docs_sitehttps://harlequin.sh
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
3/7.5Binary-Artifacts — binaries present in source code
0/7.5Branch-Protection — no data
2.5/2.5CI-Tests — 30 out of 30 merged PRs checked by a CI test -- score normalized to 10
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 2/26 approved changesets -- score normalized to 0
0.8/2.5Contributors — project has 1 contributing companies or organizations -- score normalized to 3
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
7.5/7.5Maintained — 30 commit(s) and 19 issue activity found in the last 90 days -- score normalized to 10
5/5Packaging — packaging workflow detected
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
0/5SAST — SAST tool is not run on all commits -- score normalized to 0
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — Project has not signed or included provenance with any releases.
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
0/7.5Vulnerabilities — 23 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate4
Excluded from scoring (no data or not applicable): Branch-Protection. Remaining weights renormalized.

Dependency advisories

100Exceptional
How it's scored
35/35Direct dependencies free of known advisories — no direct dependency carries a known advisory
0/25Indirect dependencies free of known advisories — transitive set not separable from development and test dependencies in this scope
0/40No advisories left outstanding — no advisory carries a publication date
Inputs used
sourceosv
advisories46
affected_packages5
assessed_packages176
unassessed_packages0
affected_by_severitycritical 1, high 3, moderate 1
direct_affected_packages0
Excluded from scoring (no data or not applicable): Indirect dependencies free of known advisories, No advisories left outstanding. Remaining weights renormalized. Matched 176 resolved dependencies against OSV. This repository publishes no package the index resolves, so the repository dependency graph was assessed instead. That graph mixes development and test pins with shipped dependencies, so only the declared runtime dependencies are scored; transitive findings are reported as context and excluded from the score. 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.

87Excellent · 4% of overall
How it's scored
45/45Agent instructions — AGENTS.md, CLAUDE.md
0/15Machine-readable docs (llms.txt)
40/40Legible commit history — 81 of 85 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
llms_txt_url—
legible_history_share0.953
agent_instruction_filesAGENTS.md, CLAUDE.md
agent_instruction_max_bytes34,546
How it's scored
18/18One-command bootstrap — Makefile
22/22Automated tests
11/11Lint / format config — pyproject.toml ([tool.ruff])
11/11Static type checking — src/harlequin/py.typed, src/harlequin_duckdb/py.typed, src/harlequin_sqlite/py.typed
10/10Reproducible environment — lockfile
10/10Demonstrated agent practice — 51 of the last 100 commits agent-authored or agent-credited
8/8Automated maintenance — 5 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
lockfilesuv.lock
has_dockerfileno
typed_languageno
bootstrap_filesMakefile
has_devcontainerno
has_linter_configyes
typecheck_configssrc/harlequin/py.typed, src/harlequin_duckdb/py.typed, src/harlequin_sqlite/py.typed
agent_commit_share0.51
toolchain_manifests—
dependency_bot_commit_share0.05
How it's scored
27/45Type-checkable code — Python with type-check config (src/harlequin/py.typed, src/harlequin_duckdb/py.typed, src/harlequin_sqlite/py.typed)
53.7/55Manageable file sizes — 4/171 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes191,268
source_files_sampled171
oversized_source_files4

Key facts

6,444GitHub stars
22contributors
195commits, last 12 months
0days since last push
100releases
1bus factor
17open issues
PyPIpackage ecosystems

Data collection warnings

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
  • deps.dev does not index pypi:harlequin@2.16.1; advisories assessed against the repository dependency graph instead

More detail

Star and fork history 0 ★ / 180 ⇿
0Stars
180Forks
98Releases

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.

0408012016020017962023-052025-012026-09
Major 2Minor 40Patch 55

Each point covers 4 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-10-02 02:36 UTC

4Binary-Artifactsbinaries present in source code
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
10CI-Tests30 out of 30 merged PRs checked by a CI test -- score normalized to 10
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 2/26 approved changesets -- score normalized to 0
3Contributorsproject has 1 contributing companies or organizations -- score normalized to 3
10Dangerous-Workflowno dangerous workflow patterns detected
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
10Maintained30 commit(s) and 19 issue activity found in the last 90 days -- score normalized to 10
10Packagingpackaging workflow detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
0SASTSAST tool is not run on all commits -- score normalized to 0
0Security-Policysecurity policy file not detected
0Signed-ReleasesProject has not signed or included provenance with any releases.
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
0Vulnerabilities23 existing vulnerabilities detected
Direct dependencies 17
RegistryPackageVersion constraintManifest
PyPItextual==8.2.8pyproject.toml
PyPItextual-fastdatatable==0.19.3pyproject.toml
PyPItextual-textarea==0.18.5pyproject.toml
PyPIclick==8.5.0pyproject.toml
PyPIrich-click==1.9.9pyproject.toml
PyPItree-sitter>=0.25,<0.27pyproject.toml
PyPItree-sitter-sql>=0.3.11,<0.4pyproject.toml
PyPIwcwidth>=0.9.1,<0.10pyproject.toml
PyPIduckdb>=1.1.1pyproject.toml
PyPIduckdb>=1.4.2pyproject.toml
PyPIshandy-sqlfmt>=0.28.2pyproject.toml
PyPIpyperclip>=1.9,<2pyproject.toml
PyPIplatformdirs>=3.10,<5.0pyproject.toml
PyPItomli>=2.0.1pyproject.toml
PyPItomlkit>=0.15.1,<0.16.0pyproject.toml
PyPImsgspec>=0.19,<1pyproject.toml
PyPIquestionary==2.1.1pyproject.toml
All dependencies 176

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

RegistryPackageVersionRelation
PyPIclick8.5.0direct
PyPIduckdb1.5.5direct
PyPImsgspec0.21.1direct
PyPIplatformdirs4.11.0direct
PyPIpyperclip1.11.0direct
PyPIquestionary2.1.1direct
PyPIrich-click1.9.9direct
PyPIshandy-sqlfmt0.31.0direct
PyPItextual8.2.8direct
PyPItextual-fastdatatable0.19.3direct
PyPItextual-textarea0.18.5direct
PyPItomli2.4.1direct
PyPItomlkit0.15.1direct
PyPItree-sitter0.26.0direct
PyPItree-sitter-sql0.3.11direct
PyPIwcwidth0.9.1direct
PyPIadbc-driver-manager1.12.0indirect
PyPIaiohappyeyeballs2.7.1indirect
PyPIaiohttp3.14.3indirect
PyPIaiohttp-jinja21.6indirect
PyPIaiosignal1.4.0indirect
PyPIanyio4.14.2indirect
PyPIast-serialize0.6.0indirect
PyPIasync-timeout5.0.1indirect
PyPIattrs26.1.0indirect
PyPIbackports-asyncio-runner1.2.0indirect
PyPIboto31.43.103indirect
PyPIboto3-stubs1.43.63indirect
PyPIbotocore1.43.103indirect
PyPIbotocore-stubs1.43.14indirect
PyPIcassandra-driver3.30.1indirect
PyPIcertifi2026.7.22indirect
PyPIcffi2.1.0indirect
PyPIcfgv3.5.0indirect
PyPIcharset-normalizer3.4.9indirect
PyPIchdb4.4.0indirect
PyPIchdb-core26.7.3indirect
PyPIcolorama0.4.6indirect
PyPIcryptography50.0.0indirect
PyPIdatabricks-sql-connector4.4.0indirect
PyPIdeprecated1.3.1indirect
PyPIdistlib0.4.3indirect
PyPIet-xmlfile2.0.0indirect
PyPIexceptiongroup1.3.1indirect
PyPIexecnet2.1.2indirect
PyPIfilelock3.32.2indirect
PyPIflaky3.8.1indirect
PyPIfrozenlist1.8.0indirect
PyPIfuture1.0.0indirect
PyPIgeomet1.1.0indirect
PyPIgoogle-api-core2.33.0indirect
PyPIgoogle-auth2.56.2indirect
PyPIgoogle-cloud-bigquery3.42.3indirect
PyPIgoogle-cloud-bigquery-storage2.39.0indirect
PyPIgoogle-cloud-core2.6.0indirect
PyPIgoogle-crc32c1.8.0indirect
PyPIgoogle-resumable-media2.10.0indirect
PyPIgoogleapis-common-protos1.75.0indirect
PyPIgrimp3.15indirect
PyPIgrpcio1.83.0indirect
PyPIgrpcio-status1.83.0indirect
PyPIh110.16.0indirect
PyPIh24.4.1indirect
PyPIharlequin2.16.1indirect
PyPIharlequin-adbc0.1.2indirect
PyPIharlequin-bigquery1.0.3indirect
PyPIharlequin-cassandra0.1.4indirect
PyPIharlequin-chdb0.1.0indirect
PyPIharlequin-databricks0.6.4indirect
PyPIharlequin-mysql1.3.0indirect
PyPIharlequin-nebulagraph0.4.1indirect
PyPIharlequin-odbc0.4.0indirect
PyPIharlequin-postgres1.3.1indirect
PyPIharlequin-trino0.1.6indirect
PyPIhpack4.2.0indirect
PyPIhttpcore1.0.9indirect
PyPIhttplib20.32.0indirect
PyPIhttpx0.28.1indirect
PyPIhyperframe6.1.0indirect
PyPIidentify2.6.19indirect
PyPIidna3.18indirect
PyPIimport-linter2.13indirect
PyPIiniconfig2.3.0indirect
PyPIjinja23.1.6indirect
PyPIjmespath1.1.0indirect
PyPIjsonschema4.26.0indirect
PyPIjsonschema-specifications2025.9.1indirect
PyPIlibrt0.13.0indirect
PyPIlinkify-it-py2.1.0indirect
PyPIlz44.4.5indirect
PyPImarkdown-it-py4.2.0indirect
PyPImarkupsafe3.0.3indirect
PyPImdit-py-plugins0.6.1indirect
PyPImdurl0.1.2indirect
PyPImsgpack1.2.1indirect
PyPImultidict6.7.1indirect
PyPImypy2.3.1indirect
PyPImypy-extensions1.1.0indirect
PyPImysql-connector-python9.7.0indirect
PyPInebula3-python3.8.3indirect
PyPInodeenv1.10.0indirect
PyPInumpy2.2.6indirect
PyPInumpy2.5.1indirect
PyPIoauthlib3.3.1indirect
PyPIopenpyxl3.1.5indirect
PyPIpackaging26.2indirect
PyPIpandas2.3.3indirect
PyPIpathspec1.1.1indirect
PyPIpluggy1.6.0indirect
PyPIpre-commit4.6.1indirect
PyPIprompt-toolkit3.0.36indirect
PyPIpropcache0.5.2indirect
PyPIproto-plus1.28.2indirect
PyPIprotobuf7.35.1indirect
PyPIpsycopg3.3.4indirect
PyPIpsycopg-binary3.3.4indirect
PyPIpsycopg-pool3.3.1indirect
PyPIpyarrow21.0.0indirect
PyPIpyarrow25.0.0indirect
PyPIpyasn10.6.4indirect
PyPIpyasn1-modules0.4.2indirect
PyPIpybreaker1.4.1indirect
PyPIpycparser3.0indirect
PyPIpygments2.20.0indirect
PyPIpyinstrument5.1.3indirect
PyPIpyjwt2.13.0indirect
PyPIpyodbc5.3.0indirect
PyPIpyparsing3.3.2indirect
PyPIpytest9.1.1indirect
PyPIpytest-asyncio1.4.0indirect
PyPIpytest-textual-snapshot1.2.1indirect
PyPIpytest-xdist3.8.0indirect
PyPIpython-dateutil2.9.0.post0indirect
PyPIpython-discovery1.5.1indirect
PyPIpytz2026.3.post1indirect
PyPIpyyaml6.0.3indirect
PyPIreferencing0.37.0indirect
PyPIrequests2.34.2indirect
PyPIrich15.0.0indirect
PyPIrpds-py0.30.0indirect
PyPIrpds-py2026.6.3indirect
PyPIruff0.16.1indirect
PyPIs3transfer0.19.2indirect
PyPIsix1.17.0indirect
PyPIsyrupy5.5.3indirect
PyPItextual-dev1.8.0indirect
PyPItextual-serve1.1.3indirect
PyPIthrift0.24.0indirect
PyPItqdm4.70.0indirect
PyPItree-sitter-bash0.25.1indirect
PyPItree-sitter-css0.25.0indirect
PyPItree-sitter-go0.25.0indirect
PyPItree-sitter-html0.23.2indirect
PyPItree-sitter-java0.23.5indirect
PyPItree-sitter-javascript0.25.0indirect
PyPItree-sitter-json0.24.8indirect
PyPItree-sitter-markdown0.5.1indirect
PyPItree-sitter-python0.25.0indirect
PyPItree-sitter-regex0.25.0indirect
PyPItree-sitter-rust0.24.2indirect
PyPItree-sitter-toml0.7.0indirect
PyPItree-sitter-xml0.7.0indirect
PyPItree-sitter-yaml0.7.2indirect
PyPItrino0.327.0indirect
PyPItypes-awscrt0.34.1indirect
PyPItypes-jsonschema4.26.0.20260518indirect
PyPItypes-pyyaml6.0.12.20260815indirect
PyPItypes-s3transfer0.16.0indirect
PyPItyping-extensions4.16.0indirect
PyPItzdata2026.3indirect
PyPItzlocal5.4.4indirect
PyPIuc-micro-py2.0.0indirect
PyPIurllib32.7.0indirect
PyPIvirtualenv21.7.1indirect
PyPIwrapt2.3.0indirect
PyPIyarl1.24.5indirect
Dependency advisories 5

This repository publishes no package the index resolves, so its own dependency graph was assessed — 176 packages, which also include development and test pins that never ship: 5 carry known advisories, of which 0 are direct.

PackageVersionRelationSeverityAdvisoriesFixed in
pyjwt2.13.0indirectcritical262.15.0
pyarrow21.0.0indirecthigh223.0.1
urllib32.7.0indirecthigh62.8.0
virtualenv21.7.1indirecthigh821.7.13
oauthlib3.3.1indirectmoderate44.0.0

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.