Public record
Software health reportschema 0.34.0 · metrics 2.10.0 · 2026-09-18 04:59 UTC

SeaQL / sea-query

🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite

RustCustom license★ 1,762 stars⑂ 275 forkssince Dec 2020View on GitHub ↗

SeaQL/sea-query holds a health index of 89 out of 100, placing it in the Excellent band. It scores highest on Vitality (88/100) and lowest on Security (48/100). It was last updated 1 day ago. 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

SeaQLOrganization
468 followers22 public repossince Oct 2020

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publishTags
crates.iosea-query1.0.21,669,20316536 days agodatabasemysqlpostgressqlsqlite
crates.iosea-query-sqlx0.9.1336,64712110 days agodatabasemysqlpostgressqlsqlite
crates.iosea-query-derive1.0.01,288,86717112 days agodatabasemysqlpostgressqlsqlite
crates.iosea-query-diesel0.3.04986112 days agodatabasedieselsql
crates.iosea-query-rbatis0.2.096112 days agodatabasemysqlpostgresrbatissqlite
crates.iosea-query-postgres0.6.115,1811436 days agodatabasepostgressql
crates.iosea-query-rusqlite0.8.052,36925112 days agodatabasesqlsqlite
crates.iosea-query-postgres-types0.1.12,5442271 days agodatabasemysqlpostgressqlsqlite

Metrics by category

Vitality

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

88Excellent · 21% of overall
How it's scored
36/36Push recency — last push 1 days ago
22.8/36Commit cadence — 33/52 weeks with commits
18/18Commit volume — 173 commits in the last year
9/10OpenSSF Scorecard: Maintained — 7 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 9
Inputs used
commits_last_year173
human_commit_share1
days_since_last_push1
active_weeks_last_year33
How it's scored
27/27Ships releases — 100 releases published
36/36Release recency — latest release 36 days ago
19.8/27Release cadence — a release every ~53.6 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count100
latest_release_tag1.0.2
releases_from_tagsno
days_since_latest_release36
mean_days_between_releases53.6
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?

87Excellent · 17% of overall
How it's scored
52.6/60Stars — 1,762 stars
20.3/25Forks — 275 forks
5.8/15Watchers — 12 watchers
Inputs used
forks275
stars1,762
watchers12
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

86Excellent
How it's scored
22.5/22.5README
16.9/22.5License — license file present, not a recognized license
18/18CONTRIBUTING guide
13.5/13.5Code of conduct
0/7.2Issue template
6.3/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
readme_badges5
has_contributingyes
has_issue_templateno
has_code_of_conductyes
readme_badge_servicesgithub.com, opencollective.com, shields.io
has_pull_request_templateyes
How it's scored
80/80Monthly downloads — 3,365,318 downloads/month across crates
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagessea-query, sea-query-sqlx, sea-query-derive, sea-query-diesel, sea-query-rbatis, sea-query-postgres, sea-query-rusqlite, sea-query-postgres-types
dependents—
ecosystemscrates
total_downloads56,118,200
monthly_downloads3,365,318
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?

68Good · 23% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
10.6/22.5Commit distribution — top contributor authored 53% of commits
13.5/13.5Contributor breadth — 100 contributors
10/10OpenSSF Scorecard: Contributors — project has 18 contributing companies or organizations
Inputs used
bus_factor1
contributors_sampled100
top_contributor_share0.531
How it's scored
34.1/42Issue resolution — 81% of issues closed
25.1/30PR acceptance — 507/607 decided PRs merged
6.5/13Newcomer PR acceptance — 1/2 first-time contributors' PRs merged in 30d
4.5/15OpenSSF Scorecard: Code-Review — Found 9/28 approved changesets -- score normalized to 3
Inputs used
merged_prs507
open_issues64
closed_issues276
prs_merged_7d1
prs_decided_7d1
prs_merged_30d1
prs_decided_30d2
issue_closed_ratio0.812
closed_unmerged_prs100
first_time_authors_30d2
first_time_prs_merged_30d1
first_time_prs_decided_30d2
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
19.2/25Owner reach — 468 followers of SeaQL
21.7/25Track record — 22 public repos, account ~5 yr old
Inputs used
followers468
owner_typeOrganization
is_verifiedno
owner_loginSeaQL
public_repos22
account_age_days2,157

Package maintenance

100Exceptional
How it's scored
25/25Published & resolvable — 8 package(s) on crates
35/35Publish recency — latest publish 36 days ago
20/20Version history — 165 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagessea-query, sea-query-sqlx, sea-query-derive, sea-query-diesel, sea-query-rbatis, sea-query-postgres, sea-query-rusqlite, sea-query-postgres-types
ecosystemscrates
any_deprecatedno
min_days_since_publish36

Engineering Quality

Are baseline engineering and documentation practices in place?

84Excellent · 19% of overall
How it's scored
24/24CI workflows — 3 workflow(s)
24/24Tests present
16/16Linter config — rustfmt.toml
0/9.6Pre-commit hooks
0/6.4.editorconfig
16/20OpenSSF Scorecard: CI-Tests — 9 out of 11 merged PRs checked by a CI test -- score normalized to 8
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configyes
has_precommit_configno

Documentation

90Excellent
How it's scored
30/30README
25/25Documentation directory
15/15Documentation / homepage site — https://www.sea-ql.org
10/10Repository description
10/10Topics — 12 topics
0/10Wiki
Inputs used
topicsrust, query-builder, mysql, postgresql, sqlite, sql, database, mariadb, postgres, sqlx, rusqlite, hacktoberfest
has_wikino
homepagehttps://www.sea-ql.org
docs_sitehttps://www.sea-ql.org
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

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

48Weak · 16% of overall
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — no data
2/2.5CI-Tests — 9 out of 11 merged PRs checked by a CI test -- score normalized to 8
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
2.2/7.5Code-Review — Found 9/28 approved changesets -- score normalized to 3
2.5/2.5Contributors — project has 18 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.2/2.5License — license file detected
6.8/7.5Maintained — 7 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 9
0/5Packaging — no data
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 — no data
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
7.5/7.5Vulnerabilities — 0 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated15
scorecard_versionv5.5.0
checks_inconclusive3
scorecard_aggregate4.8
Excluded from scoring (no data or not applicable): Branch-Protection, Packaging, Signed-Releases. Remaining weights renormalized.

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.

64Moderate · 4% of overall
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
15/15Machine-readable docs (llms.txt) — llms.txt served by the project website (https://www.sea-ql.org/llms.txt)
20.3/40Legible commit history — 38 of 100 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtyes
llms_txt_urlhttps://www.sea-ql.org/llms.txt
legible_history_share0.38
agent_instruction_files—
agent_instruction_max_bytes—
How it's scored
12.6/18One-command bootstrap — Cargo.toml, examples/diesel_mysql/Cargo.toml, examples/diesel_postgres/Cargo.toml (toolchain convention, no task runner)
22/22Automated tests
11/11Lint / format config — rustfmt.toml
11/11Static type checking — Rust (statically typed)
0/10Reproducible environment
2/10Demonstrated agent practice — 1 of the last 100 commits agent-authored or agent-credited
0/8Automated maintenance — no automated dependency updates observed
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfiles—
has_dockerfileno
typed_languageyes
bootstrap_files—
has_devcontainerno
has_linter_configyes
typecheck_configs—
agent_commit_share0.01
toolchain_manifestsCargo.toml, examples/diesel_mysql/Cargo.toml, examples/diesel_postgres/Cargo.toml, examples/diesel_sqlite/Cargo.toml, examples/postgres/Cargo.toml, examples/rusqlite/Cargo.toml, examples/sqlx_mysql/Cargo.toml, examples/sqlx_postgres/Cargo.toml, examples/sqlx_sqlite/Cargo.toml, sea-query-derive/Cargo.toml, sea-query-diesel/Cargo.toml, sea-query-postgres-types/Cargo.toml, sea-query-postgres/Cargo.toml, sea-query-rbatis/Cargo.toml, sea-query-rusqlite/Cargo.toml, sea-query-sqlx/Cargo.toml
dependency_bot_commit_share0
How it's scored
45/45Type-checkable code — Rust (statically typed)
54.3/55Manageable file sizes — 3/229 source files over 60KB
Inputs used
primary_languageRust
largest_source_bytes98,963
source_files_sampled229
oversized_source_files3
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 — examples
Inputs used
example_dirsexamples
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

1,762GitHub stars
100contributors
173commits, last 12 months
1days since last push
100releases
1bus factor
64open issues
crates.iopackage ecosystems

Data collection warnings

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
  • No resolved dependencies carried a version and a supported ecosystem

More detail

Star and fork history 0 ★ / 275 ⇿
0Stars
275Forks
100Releases

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.

05010015020025030027142020-122023-112026-09
Major 1Minor 19Patch 68

Each point covers 6 days.

OpenSSF Scorecard 4.8 / 10
4.8aggregate

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-18 04:58 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
8CI-Tests9 out of 11 merged PRs checked by a CI test -- score normalized to 8
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
3Code-ReviewFound 9/28 approved changesets -- score normalized to 3
10Contributorsproject has 18 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
9Licenselicense file detected
9Maintained7 commit(s) and 4 issue activity found in the last 90 days -- score normalized to 9
n/aPackagingpackaging workflow not 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
n/aSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
10Vulnerabilities0 existing vulnerabilities detected
Direct dependencies 66
RegistryPackageVersion constraintManifest
crates.iosea-query-derive1.0.0Cargo.toml
crates.iosea-query-postgres-types0.1.1Cargo.toml
crates.ioserde1Cargo.toml
crates.ioserde_json1Cargo.toml
crates.iochrono0.4.40Cargo.toml
crates.iopgvector0.4Cargo.toml
crates.iorust_decimal1Cargo.toml
crates.iobigdecimal0.4Cargo.toml
crates.iouuid1Cargo.toml
crates.iotime0.3.47Cargo.toml
crates.iojiff0.2.15Cargo.toml
crates.ioipnetwork0.21.1Cargo.toml
crates.iomac_address1.1Cargo.toml
crates.ioordered-float4.6Cargo.toml
crates.ioitoa1.0.15Cargo.toml
crates.iosyn2sea-query-derive/Cargo.toml
crates.ioquote1sea-query-derive/Cargo.toml
crates.ioheck0.4sea-query-derive/Cargo.toml
crates.iodarling0.20sea-query-derive/Cargo.toml
crates.ioproc-macro21sea-query-derive/Cargo.toml
crates.iothiserror2sea-query-derive/Cargo.toml
crates.iosea-query1.0.0sea-query-diesel/Cargo.toml
crates.iodiesel2.1.1sea-query-diesel/Cargo.toml
crates.iobigdecimal0.4sea-query-diesel/Cargo.toml
crates.iorust_decimal1sea-query-diesel/Cargo.toml
crates.iochrono0.4sea-query-diesel/Cargo.toml
crates.iotime0.3.36sea-query-diesel/Cargo.toml
crates.iouuid1sea-query-diesel/Cargo.toml
crates.ioserde_json1sea-query-diesel/Cargo.toml
crates.ioipnetwork0.21.1sea-query-diesel/Cargo.toml
crates.iomac_address1.1sea-query-diesel/Cargo.toml
crates.iopgvector~0.4sea-query-diesel/Cargo.toml
crates.iobytes1sea-query-postgres-types/Cargo.toml
crates.iopostgres-protocol0.6sea-query-postgres-types/Cargo.toml
crates.iopostgres-types0.2sea-query-postgres-types/Cargo.toml
crates.ioordered-float4.6sea-query-postgres-types/Cargo.toml
crates.ioserde1sea-query-postgres-types/Cargo.toml
crates.iosea-query1.0.0sea-query-postgres/Cargo.toml
crates.iosea-query-postgres-types0.1.1sea-query-postgres/Cargo.toml
crates.iopostgres-types0.2sea-query-postgres/Cargo.toml
crates.iopgvector~0.4sea-query-postgres/Cargo.toml
crates.iobytes1sea-query-postgres/Cargo.toml
crates.iorust_decimal1sea-query-postgres/Cargo.toml
crates.iobigdecimal0.4sea-query-postgres/Cargo.toml
crates.ioipnetwork0.21.1sea-query-postgres/Cargo.toml
crates.iomac_address1.1sea-query-postgres/Cargo.toml
crates.ioeui481sea-query-postgres/Cargo.toml
crates.iocidr0.2sea-query-postgres/Cargo.toml
crates.iosea-query1.0.0sea-query-rbatis/Cargo.toml
crates.iorbs4.3.1sea-query-rbatis/Cargo.toml
crates.ioserde_json1sea-query-rbatis/Cargo.toml
crates.iochrono0.4sea-query-rbatis/Cargo.toml
crates.iorust_decimal1sea-query-rbatis/Cargo.toml
crates.iobigdecimal0.4sea-query-rbatis/Cargo.toml
crates.iouuid1sea-query-rbatis/Cargo.toml
crates.iotime0.3.36sea-query-rbatis/Cargo.toml
crates.ioipnetwork0.21.1sea-query-rbatis/Cargo.toml
crates.iomac_address1.1sea-query-rbatis/Cargo.toml
crates.iosea-query1.0.0sea-query-rusqlite/Cargo.toml
crates.iorusqlite0.38sea-query-rusqlite/Cargo.toml
crates.iosea-query1.0.0sea-query-sqlx/Cargo.toml
crates.iosqlx0.9sea-query-sqlx/Cargo.toml
crates.ioipnetwork0.21.1sea-query-sqlx/Cargo.toml
crates.iopgvector0.4.2sea-query-sqlx/Cargo.toml
crates.iojiff0.2.15sea-query-sqlx/Cargo.toml
crates.iojiff-sqlx0.1sea-query-sqlx/Cargo.toml
All dependencies 38

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

RegistryPackageVersionRelation
crates.iobigdecimal—direct
crates.iobytes—direct
crates.iochrono—direct
crates.iocidr—direct
crates.iodarling—direct
crates.iodiesel—direct
crates.ioeui48—direct
crates.ioheck—direct
crates.ioipnetwork—direct
crates.ioitoa—direct
crates.iojiff—direct
crates.iojiff-sqlx—direct
crates.iomac_address—direct
crates.ioordered-float—direct
crates.iopgvector—direct
crates.iopostgres-protocol—direct
crates.iopostgres-types—direct
crates.ioproc-macro2—direct
crates.ioquote—direct
crates.iorbs—direct
crates.iorusqlite—direct
crates.iorust_decimal—direct
crates.iosea-query—direct
crates.iosea-query-derive—direct
crates.iosea-query-postgres-types—direct
crates.ioserde—direct
crates.ioserde_json—direct
crates.iosqlx—direct
crates.iosyn—direct
crates.iothiserror—direct
crates.iotime—direct
crates.iouuid—direct
crates.ioasync-std—indirect
crates.iocriterion—indirect
crates.iopostgres—indirect
crates.iopretty_assertions—indirect
crates.iostrum—indirect
crates.iotrybuild—indirect
Dependency advisories not assessed

Advisory matching could not run for this report: No resolved dependencies carried a version and a supported ecosystem

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 — crates.io.