Public recordModerate
Software health reportschema 0.26.0 · metrics 1.13.0 · 2026-07-22 17:44 UTC
iamcal / SQLParser
Parse MySQL schemas in PHP, fast
iamcal/SQLParser holds a health index of 50 out of 100, placing it in the Moderate band. It scores highest on Sustainability & Governance (68/100) and lowest on Security (30/100). It was last updated 174 days ago. A single contributor accounts for most of its recent work.
50
overall / 100Software health index
Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At risk ceiling of 49. AI Readiness sits outside the overall score.
50
Excellent85-100Exemplary; meets essentially all checked criteria
Good70-84Healthy; minor gaps
Moderate50-69Acceptable with notable gaps; review recommended
At risk30-49Significant weaknesses; adoption warrants caution
Critical1-29Severe problems (abandoned, single-maintainer, no hygiene)
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.
Ownership
Cal HendersonPersonal account
1,025 followers193 public repossince Dec 2009Slack
This repository is owned by a personal account. A single-owner project carries more continuity risk than an organization-backed one.
Package ecosystems
| Registry | Package | Version | Downloads / mo | Versions | Last publish |
|---|---|---|---|---|---|
| Packagist | iamcal/sql-parser | v0.7 | 4,742,890 | 7 | 174 days ago |
Metrics by category
Vitality
Is the project alive — is code being written and are releases shipping?
37
Development activity
18Critical
How it's scored
| 9.9/36 | Push recency — last push 174 days ago |
| 0.7/36 | Commit cadence — 1/52 weeks with commits |
| 7.6/18 | Commit volume — 6 commits in the last year |
| 0/10 | OpenSSF Scorecard: Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0 |
Inputs used
| commits_last_year | 6 |
| human_commit_share | 1 |
| days_since_last_push | 174 |
| active_weeks_last_year | 1 |
Release discipline
66Moderate
How it's scored
| 27/27 | Ships releases — 2 releases published |
| 27/36 | Release recency — latest release 174 days ago |
| 5.4/27 | Release cadence — a release every ~3,062.7 days |
| 0/10 | OpenSSF Scorecard: Signed-Releases — no data |
Inputs used
| releases_count | 2 |
| latest_release_tag | v0.7 |
| releases_from_tags | no |
| days_since_latest_release | 174 |
| mean_days_between_releases | 3,062.7 |
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?
56
Popularity & adoption
43At risk
How it's scored
| 30.5/60 | Stars — 77 stars |
| 10.7/25 | Forks — 20 forks |
| 1.7/15 | Watchers — 3 watchers |
Inputs used
| forks | 20 |
| stars | 77 |
| watchers | 3 |
| growth_state | unverified |
| growth_factor_pct | 100 |
| growth_unverified_reason | no_history |
Community health
50Moderate
How it's scored
| 22.5/22.5 | README |
| 22.5/22.5 | License — recognized license (MIT) |
| 0/18 | CONTRIBUTING guide |
| 0/13.5 | Code of conduct |
| 0/7.2 | Issue template |
| 0/6.3 | PR template |
Inputs used
| has_readme | yes |
| has_license | yes |
| has_contributing | no |
| has_issue_template | no |
| has_code_of_conduct | no |
| has_pull_request_template | no |
Ecosystem adoption (downloads)
87Excellent
How it's scored
| 80/80 | Monthly downloads — 4,742,890 downloads/month across packagist |
| 6.9/20 | Registry dependents — 10 packages depend on it |
Inputs used
| packages | iamcal/sql-parser |
| dependents | 10 |
| ecosystems | packagist |
| total_downloads | 38,486,535 |
| monthly_downloads | 4,742,890 |
Sustainability & Governance
Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?
68
Maintainer resilience (bus factor)
29Critical
How it's scored
| 9/54 | Bus factor — 1 contributor(s) cover half of all commits |
| 2.9/22.5 | Commit distribution — top contributor authored 87% of commits |
| 10.8/13.5 | Contributor breadth — 8 contributors |
| 6/10 | OpenSSF Scorecard: Contributors — project has 2 contributing companies or organizations -- score normalized to 6 |
Inputs used
| bus_factor | 1 |
| contributors_sampled | 8 |
| top_contributor_share | 0.872 |
Issue & PR responsiveness
86Excellent
How it's scored
| 46.8/46.8 | Issue resolution — 100% of issues closed |
| 34.9/38.3 | PR acceptance — 21/23 decided PRs merged |
| 4.5/15 | OpenSSF Scorecard: Code-Review — Found 8/22 approved changesets -- score normalized to 3 |
Inputs used
| merged_prs | 21 |
| open_issues | 0 |
| closed_issues | 8 |
| issue_closed_ratio | 1 |
| closed_unmerged_prs | 2 |
Ownership & stewardship
71Good
How it's scored
| 10/30 | Ownership backing — personal (user) account |
| 0/20 | Verified domain — not applicable to user accounts |
| 21.6/25 | Owner reach — 1,025 followers of iamcal |
| 25/25 | Track record — 193 public repos, account ~16 yr old |
Inputs used
| followers | 1,025 |
| owner_type | User |
| is_verified | — |
| owner_login | iamcal |
| public_repos | 193 |
| account_age_days | 6,048 |
Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.
Package maintenance
100Excellent
How it's scored
| 25/25 | Published & resolvable — 1 package(s) on packagist |
| 35/35 | Publish recency — latest publish 174 days ago |
| 20/20 | Version history — 7 published versions |
| 20/20 | Not deprecated — active, not deprecated or yanked |
Inputs used
| packages | iamcal/sql-parser |
| ecosystems | packagist |
| any_deprecated | no |
| min_days_since_publish | 174 |
Engineering Quality
Are baseline engineering and documentation practices in place?
53
Engineering practices
48At risk
How it's scored
| 24/24 | CI workflows — 1 workflow(s) |
| 24/24 | Tests present |
| 0/16 | Linter config |
| 0/9.6 | Pre-commit hooks |
| 0/6.4 | .editorconfig |
| 0/20 | OpenSSF Scorecard: CI-Tests — 1 out of 16 merged PRs checked by a CI test -- score normalized to 0 |
Inputs used
| has_ci | yes |
| has_tests | yes |
| has_editorconfig | no |
| has_linter_config | no |
| has_precommit_config | no |
Documentation
60Moderate
How it's scored
| 30/30 | README |
| 0/25 | Documentation directory |
| 0/15 | Documentation / homepage site |
| 10/10 | Repository description |
| 10/10 | Topics — 6 topics |
| 10/10 | Wiki |
Inputs used
| topics | php, sql-parser, lex, composer, database, autoloader |
| has_wiki | yes |
| homepage | — |
| has_readme | yes |
| has_docs_dir | no |
| has_description | yes |
Security
Are visible security and supply-chain practices strong, without unresolved high-risk jurisdiction exposure?
30
Security posture
30At risk
How it's scored
| 7.5/7.5 | Binary-Artifacts — no binaries found in the repo |
| 0/7.5 | Branch-Protection — branch protection not enabled on development/release branches |
| 0/2.5 | CI-Tests — 1 out of 16 merged PRs checked by a CI test -- score normalized to 0 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 2.2/7.5 | Code-Review — Found 8/22 approved changesets -- score normalized to 3 |
| 1.5/2.5 | Contributors — project has 2 contributing companies or organizations -- score normalized to 6 |
| 0/10 | Dangerous-Workflow — no data |
| 0/7.5 | Dependency-Update-Tool — no update tool detected |
| 0/5 | Fuzzing — project is not fuzzed |
| 2.5/2.5 | License — license file detected |
| 0/7.5 | Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0 |
| 0/5 | Packaging — no data |
| 0/5 | Pinned-Dependencies — no data |
| 0/5 | SAST — SAST tool is not run on all commits -- score normalized to 0 |
| 0/5 | Security-Policy — security policy file not detected |
| 0/7.5 | Signed-Releases — no data |
| 0/7.5 | Token-Permissions — no data |
| 7.5/7.5 | Vulnerabilities — 0 existing vulnerabilities detected |
Inputs used
| source | openssf_scorecard |
| checks_evaluated | 13 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 5 |
| scorecard_aggregate | 3 |
Excluded from scoring (no data or not applicable): dangerous_workflow, packaging, pinned_dependencies, signed_releases, token_permissions. Remaining weights renormalized.
AI Readiness
How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score.
33
Agent context & guidance
6Critical
How it's scored
| 0/45 | Agent instructions — no CLAUDE.md / AGENTS.md / editor rules |
| 0/15 | Machine-readable docs (llms.txt) |
| 6.4/40 | Legible commit history — 12 of 100 human commits state their intent (structured subject or explanatory body) |
Inputs used
| has_llms_txt | no |
| legible_history_share | 0.12 |
| agent_instruction_files | — |
| agent_instruction_max_bytes | — |
How it's scored
| 18/18 | One-command bootstrap — Makefile |
| 22/22 | Automated tests |
| 0/11 | Lint / format config |
| 0/11 | Static type checking |
| 0/10 | Reproducible environment |
| 0/10 | Demonstrated agent practice — no agent-authored commits among the last 100 |
| 0/8 | Automated maintenance — no automated dependency updates observed |
| 0/10 | OpenSSF Scorecard: Pinned-Dependencies — no data |
Inputs used
| has_nix | no |
| has_tests | yes |
| lockfiles | — |
| has_dockerfile | no |
| typed_language | no |
| bootstrap_files | Makefile |
| has_devcontainer | no |
| has_linter_config | no |
| typecheck_configs | — |
| agent_commit_share | 0 |
| toolchain_manifests | — |
| dependency_bot_commit_share | 0 |
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Pinned-Dependencies. Remaining weights renormalized.
Code legibility for models
55Moderate
How it's scored
| 0/45 | Type-checkable code — PHP without a type-check config |
| 55/55 | Manageable file sizes — 0/12 source files over 60KB |
Inputs used
| primary_language | PHP |
| largest_source_bytes | 27,313 |
| source_files_sampled | 12 |
| oversized_source_files | 0 |
Key facts
77GitHub stars
8contributors
6commits, last 12 months
174days since last push
2releases
1bus factor
0open issues
Packagistpackage 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 ★ / 20 ⇿
0Stars
20Forks
1Releases
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.
Major 0Minor 0Patch 0
Each point covers 9 days.
OpenSSF Scorecard 3.0 / 10
3.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).
| 10 | Binary-Artifacts | no binaries found in the repo |
| 0 | Branch-Protection | branch protection not enabled on development/release branches |
| 0 | CI-Tests | 1 out of 16 merged PRs checked by a CI test -- score normalized to 0 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 3 | Code-Review | Found 8/22 approved changesets -- score normalized to 3 |
| 6 | Contributors | project has 2 contributing companies or organizations -- score normalized to 6 |
| n/a | Dangerous-Workflow | no workflows found |
| 0 | Dependency-Update-Tool | no update tool detected |
| 0 | Fuzzing | project is not fuzzed |
| 10 | License | license file detected |
| 0 | Maintained | 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0 |
| n/a | Packaging | packaging workflow not detected |
| n/a | Pinned-Dependencies | no dependencies found |
| 0 | SAST | SAST tool is not run on all commits -- score normalized to 0 |
| 0 | Security-Policy | security policy file not detected |
| n/a | Signed-Releases | no releases found |
| n/a | Token-Permissions | No tokens found |
| 10 | Vulnerabilities | 0 existing vulnerabilities detected |
All dependencies 2
Full resolved dependency set from the GitHub dependency graph: 0 direct and 2 indirect (transitive) packages. The transitive closure is complete when the repository commits a lockfile.
| Registry | Package | Version | Relation |
|---|---|---|---|
| Packagist | php-coveralls/php-coveralls | — | indirect |
| Packagist | phpunit/phpunit | — | 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
{
"data": {
"repo": {
"topics": [
"php",
"sql-parser",
"lex",
"composer",
"database",
"autoloader"
],
"is_fork": false,
"size_kb": 183,
"has_wiki": true,
"homepage": null,
"languages": {
"PHP": 66319,
"Makefile": 73
},
"pushed_at": "2026-01-28T22:23:25Z",
"created_at": "2013-01-04T23:49:17Z",
"owner_type": "User",
"updated_at": "2026-05-28T19:50:24Z",
"description": "Parse MySQL schemas in PHP, fast",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "master",
"license_spdx_raw": "MIT",
"primary_language": "PHP",
"significant_languages": [
"PHP"
]
},
"owner": {
"blog": "http://www.iamcal.com/",
"name": "Cal Henderson",
"type": "User",
"login": "iamcal",
"company": "Slack",
"location": "San Francisco, CA",
"followers": 1025,
"avatar_url": "https://avatars.githubusercontent.com/u/173750?v=4",
"created_at": "2009-12-29T17:57:48Z",
"is_verified": null,
"public_repos": 193,
"account_age_days": 6048
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v0.7",
"kind": "other",
"published_at": "2026-01-28T22:23:25Z"
},
{
"tag": "0.1",
"kind": "other",
"published_at": "2017-09-10T05:04:30Z"
}
],
"recent_commits": [
{
"oid": "610392f38de49a44dab08dc1659960a29874c4b8",
"body": null,
"is_bot": false,
"headline": "Fix quote doubling decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "47edc41c929b33266e3affc151281f0361667c99",
"body": null,
"is_bot": false,
"headline": "Add tests for quote doubling decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "02f623f2f3f425d5c9bbef342a3d17db2dc1aebf",
"body": null,
"is_bot": false,
"headline": "Fix quote doubling lexing",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ec94c056723d37bfeb14316b0f29b8b67373e0a5",
"body": null,
"is_bot": false,
"headline": "Add tests for quote doubling lexing",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a8106d8925cb33792819e1ebbdfb2dbfcc4fbcee",
"body": null,
"is_bot": false,
"headline": "Fix escaped quote decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a831815c183aa572f0a9743a50e723fe869aa8cf",
"body": null,
"is_bot": false,
"headline": "Add tests for escaped quote decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "947083e2dca211a6f12fb1beb67a01e387de9b62",
"body": null,
"is_bot": false,
"headline": "feat: add `.gitattributes`",
"author_name": "Owen Voke",
"author_login": "owenvoke",
"committed_at": "2025-03-17T16:59:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0262cfb8bc1d04e91b8f927e7105037c440e4ccc",
"body": null,
"is_bot": false,
"headline": "throw exception instead of die",
"author_name": "DirtyRacer1337",
"author_login": "DirtyRacer1337",
"committed_at": "2025-03-16T16:28:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "52f3c952969148d6d25073911e6c369dbdf51cc0",
"body": null,
"is_bot": false,
"headline": "Merge branch 'zzycad-master'",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-12-13T18:47:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a670a900cae83cd9f019711aa7e8d296235fcb5a",
"body": null,
"is_bot": false,
"headline": "added tests for field comments",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-12-13T18:46:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7308b62557ffd8662f36904f8e059238d38ef1f3",
"body": "…ers too)",
"is_bot": false,
"headline": "added test for negative default values (generally tests negative numb…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-12-13T18:44:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "37f43534dbffd77281f8f876aef6e69a784c3f54",
"body": "…le field comments.",
"is_bot": false,
"headline": "Fix the bug with default negative values, and add the ability to hand…",
"author_name": "zzy",
"author_login": null,
"committed_at": "2024-12-13T09:32:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "644fd994de3b54e5d833aecf406150aa3b66ca88",
"body": "Start testing there...",
"is_bot": false,
"headline": "PHP 8.3 support",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-03-22T22:46:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a9f3f74d1d390665868b64404cbe7faaed558f8c",
"body": null,
"is_bot": false,
"headline": "supports [5.6,...,8.2]",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1fe57fa39d6de91fc7a2988a7d0c205becbcf341",
"body": null,
"is_bot": false,
"headline": "removed dynamic property",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3356bcd528aa98b8a8c3e655c17baadcdf1c9dcf",
"body": null,
"is_bot": false,
"headline": "add code blocks",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9b56b6b42006e167a8f37c2cc84cbbb08515dae7",
"body": null,
"is_bot": false,
"headline": "ignore cache, vendor, build",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2c5eb8b229d4937a16a1bd17c5e2b137ce3b4597",
"body": "* detect when we've reached the end of input when lexing an unterminated string\r\n* added a mode where we throw exceptions for invalid syntax\r\n* added tests for invalid syntax, in both default and exception mode\r\n* documented `$parser->throw_on_bad_syntax`\r\n* get tests running again on php 8.1 (broken by https://github.com/sebastianbergmann/phpunit/issues/4740)",
"is_bot": false,
"headline": "Throw on bad syntax (#23)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2022-03-05T00:19:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4080544b2df11132eecdb57fbe91c07dbbe5bc41",
"body": null,
"is_bot": false,
"headline": "added an alernatives section to the readme",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2022-03-04T23:44:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5ae12b79b0192d84b8ebc29541c55703104064e6",
"body": null,
"is_bot": false,
"headline": "how to publish changes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2022-03-04T23:40:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3ceec1bdb7c0cfe0c10afdd1493889a0f2a484d9",
"body": "* name the build sensibly\r\n* updated the badge images",
"is_bot": false,
"headline": "Show a build bade for Github Actions (#21)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:39:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4f897e91f98cf0be4602822b2fd08197e47ffa40",
"body": "* JSON is a type with no params\r\n* spatial types are all param-less too\r\n* added some missing field type aliases\r\n* added boolean type (plus alias)\r\n* updated the list of \"unsupported\", to cover all the 5.7 field types i've found\r\n* normalize whitespace",
"is_bot": false,
"headline": "Full support for 5.7 field types (#16)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:34:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "de2497155b098a23ae58a56aba2fe0867885b40a",
"body": null,
"is_bot": false,
"headline": "Upgrade to Ubuntu 20 for all CI (#20)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:31:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aebd40a35c51bd08a2e4e09a5b8bf3cdcfb68e91",
"body": null,
"is_bot": false,
"headline": "add php 8.1 to build matrix (#19)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:25:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0da94942aecc15fbda275dffd6e420726ac00f8c",
"body": "* added PHP 5.3 to the build matrix\r\n* php 5.3 compat in code and tests: `[] -> array()`",
"is_bot": false,
"headline": "Support for PHP 5.3",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:19:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0f853a6f0ff736bf5836589cafabe9636e87ad6f",
"body": "Switch from Travis to Github Actions as our test runner",
"is_bot": false,
"headline": "Using github actions (#17)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T18:33:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9bf1bfdf69655c69bc5e5368a2bc034dcc632fe8",
"body": null,
"is_bot": false,
"headline": "JSON case",
"author_name": "William Peter Falci",
"author_login": "WilliamFalci",
"committed_at": "2020-12-29T00:00:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e2d6e9e186c347cc3f00733bf6c7799ec4b3c624",
"body": null,
"is_bot": false,
"headline": "Fix undefined offset exception",
"author_name": "richardudovich",
"author_login": "richardudovich",
"committed_at": "2019-03-01T17:16:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a3a40469722f28506c0c000e8b42c6854d0e11bd",
"body": null,
"is_bot": false,
"headline": "support database",
"author_name": "Alexey Solodkiy",
"author_login": null,
"committed_at": "2019-03-01T01:31:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f3fa038fd07ca30c0b3be4726f7693ecafe45c8b",
"body": null,
"is_bot": false,
"headline": "the commits will continue until morale improves",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T01:26:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "02351ce150b86007c3bc6268bd1aeae9687906fd",
"body": null,
"is_bot": false,
"headline": "try this?",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T01:20:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ce4625d0cf9036f28c37a69648decc9536b7499a",
"body": "peg to 7.4 which was the last one that worked",
"is_bot": false,
"headline": "nightly is now 8.0, which wont work (dependencies broken)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T00:45:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8bfd265f24d29b898353f75c218be24d5436bb29",
"body": "no longer test nightly - composer is not supported",
"is_bot": false,
"headline": "pin version of hhvm we're testing",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T00:33:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a0aed3b89fe0c3a4e4edca6b6489db4f4619b869",
"body": null,
"is_bot": false,
"headline": "this version worked, i swear",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-01-25T21:37:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8fbb5e6fbfa1ca98fdf1f202ac084eddfc9c2d5e",
"body": null,
"is_bot": false,
"headline": "phpunit 6.5 is the last one to work with hhvm",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-01-25T21:27:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dcb614bae8151ed9db79f56cb2cf369b9749f21b",
"body": null,
"is_bot": false,
"headline": "Set `null` to `true` for fields that default to `NULL`",
"author_name": "Michael Hahn",
"author_login": null,
"committed_at": "2018-01-09T21:19:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c5412e7563bd41783e10d31584eef7e653117f4d",
"body": "when lexing, set the source SQL as a prop",
"is_bot": false,
"headline": "document the public API.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:30:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "404c1ecdd3e8b8cbacb54f16a7591ba8acf3c223",
"body": null,
"is_bot": false,
"headline": "split general table tests into their own file",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:08:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a0b565e7ff20847dab18d5e665471eeffd9006e5",
"body": null,
"is_bot": false,
"headline": "some more TODOs",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:04:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f7ae33a0df581771a70db5a5e00bd8df10aa8ba1",
"body": "better field test helper\nimplemented binary flag parser\nadded binary support for CHAR/VARCHAR (new in MySQL 5.7)\ndecode charset and collation entities",
"is_bot": false,
"headline": "tests for BIT, CHAR/VARCHAR/etc fields",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:02:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d5cfb1dfe8e9f4b95f4a115fc0de68919df8a44e",
"body": null,
"is_bot": false,
"headline": "supprot and tests for fractional seconds precision on time types",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T04:48:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e8db894cbff6c7c7d0cc5f5aafbc3dff05c0e906",
"body": null,
"is_bot": false,
"headline": "added tests for float and numeric types",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T04:45:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c86b77ef50d78da3a18cb0d0562282a2dca0cffb",
"body": null,
"is_bot": false,
"headline": "test foreign key with a name",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T04:35:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3e087f05c6afb234fcda2ad6eb3e9507936e6136",
"body": null,
"is_bot": false,
"headline": "better explain what the library is for. history moved down lower",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-15T21:05:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "926d452469606624305f8e0a7bdd16162dd92519",
"body": "avoid some out of band reads",
"is_bot": false,
"headline": "full support for CHECK and FORIEGN KEY index conditions.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-15T20:56:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "482601cde261f6957b8e8bb1cb5da40a20e96a4b",
"body": null,
"is_bot": false,
"headline": "added a test for find_single_table mode",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:54:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "adf87288c6d6ea0d21bae8bb4f6fadfb52fc2dad",
"body": null,
"is_bot": false,
"headline": "started to write tests for field types",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:51:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b510bc3b2fa7ef68dfea0f41c0ed9e0d31b79d05",
"body": "added tests for constraints",
"is_bot": false,
"headline": "actually include constraint information in the index (duh).",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:31:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "103ef2b6856087587c3bf5f5141f1a868a9f5c71",
"body": null,
"is_bot": false,
"headline": "support for multiple index options, with tests",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:21:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "df86dc72b9e99cb33e454a8e081589c3be2e2ea2",
"body": "…of index.\n\nadded support for index comments (mysql 5.7)\nadded tests for all idnex options",
"is_bot": false,
"headline": "fixed index mode parser to not overflow for btree mode as last token …",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:17:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "30501a9d5ca0941f9197b53934c924b4f287921c",
"body": "change index.col.direction to upper case to match everything else",
"is_bot": false,
"headline": "added tests for index columns.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:10:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8cde164fa0813ddfb670e1a6a053b774cabd19da",
"body": null,
"is_bot": false,
"headline": "tests for indexes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T19:57:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2d64c0840481f2c3eef33fe1364f9dd44382f8f5",
"body": "… bar`",
"is_bot": false,
"headline": "tests for `CREATE TABLE IF NOT EXISTS foo` and `CREATE TABLE foo LIKE…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T19:57:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "713011e67b634f442f972451b497a2b7d8a4a0d1",
"body": "return mode in upper case, to match .type",
"is_bot": false,
"headline": "since the returned prop is called mode, call the function that too.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T19:57:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dc2997b9a23c13cb7d72961faec3196f89c88dcc",
"body": null,
"is_bot": false,
"headline": "don't mess with any globals",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:38:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7b23d247fae3e4d8eafd0bd8601fa54b7dbbd249",
"body": null,
"is_bot": false,
"headline": "test some simple table props end-to-end",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:31:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9dde6404b5efebd76bb3c617e821aeea8beb2912",
"body": "renamed temporary table prop to `temporary`",
"is_bot": false,
"headline": "fixed two bounds error cases.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:30:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "924e51c850a5c40836b9baf4fa2a8c6cc40c7b4c",
"body": null,
"is_bot": false,
"headline": "added lexer tests for multiline comments that don't end",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:11:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fa00ac7d0aa71734f0b180a70fa579ff580b2954",
"body": "added composer installation instructions",
"is_bot": false,
"headline": "added travis and coveralls badges",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:09:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "11343214b7fb95d70f0d789db8ff3be1c4477564",
"body": null,
"is_bot": false,
"headline": "more lexer tests",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:54:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2595b267396abff0a842db0da36b38a1842ce106",
"body": null,
"is_bot": false,
"headline": "towards coverage logs",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:34:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "03cabc08dd07a394562d4e6152927b138ca2558e",
"body": null,
"is_bot": false,
"headline": "get travis running the phpunit tests",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:20:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f7f2e2fdc151fdec7bc91d6ee10d3bd31aae1aa3",
"body": null,
"is_bot": false,
"headline": "moved the example files over to the new layout/naming",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:01:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2fc077ef4613a1fe5f90926c7bbe87b8bb0e4c07",
"body": null,
"is_bot": false,
"headline": "moving to phpunit",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:59:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b37968357e8bb6dde09b3c1c670a04a3e3b756e4",
"body": null,
"is_bot": false,
"headline": "what an adventure",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:36:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5510c4e2fe4b31e7bdc7728c612c478d66cfba65",
"body": null,
"is_bot": false,
"headline": "composer documentation and tooling is *really* bad",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:35:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "341410239e24f75b4d045b08f237134cfad8223d",
"body": null,
"is_bot": false,
"headline": "packagist package names have to be lowercase",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:34:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "872e481fc0b1f842b70639eb4758558af6970adb",
"body": null,
"is_bot": false,
"headline": "updated tests for path and namespace changes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:33:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a924287adefd4862370f9488b6327e2cca8938ea",
"body": "moved src into a subdir in the composer style",
"is_bot": false,
"headline": "added composer json",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:33:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "be254456c8faa5f5f7fadac2fe922fc16c187686",
"body": "still needs some more work",
"is_bot": false,
"headline": "replace some/most of the array shifting with a cursor instead.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-09T20:49:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "841e09a6c4694a6666a46d8e19abc8bf148b5224",
"body": "fixed a typo in function call name",
"is_bot": false,
"headline": "added some more checks to avoid php warnings.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-09T20:49:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c2a258a8d2657e69977124d5810de2a66b7e4b79",
"body": null,
"is_bot": false,
"headline": "silence all php warnings/notices",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-09T20:49:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9084e471a12478ff9c637beb3bf3cb9b24f2a141",
"body": null,
"is_bot": false,
"headline": "Create LICENSE",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-06-09T20:48:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0902af528efe28245c9278a120fac2f9d99d0f32",
"body": "In order to have the original CREATE TABLE text from the schema\navailable when using the parsed structure, rework the lexer so that\ninstead of extracting the substring tokens, it extracts tuples of\n[position, length] and maintains these associations when collapsing\nthe token sequences.\n\nThis means we can include the original source text in a `sql` field\nof the resulting parsed structure.",
"is_bot": false,
"headline": "rework the lexer to keep track of source locations for each token",
"author_name": "Michael Demmer",
"author_login": "demmer",
"committed_at": "2017-02-16T22:01:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b944a2a63f86e2f3ee26f0b929454885e4dc5247",
"body": null,
"is_bot": false,
"headline": "support LONGBLOB types",
"author_name": "Michael Demmer",
"author_login": "demmer",
"committed_at": "2017-02-14T04:45:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ad246f58ad2a4f3be5e9defdcbee85c0fa25a2ef",
"body": null,
"is_bot": false,
"headline": "simple test file while i add capabilities",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T18:14:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f61aa253adf37b9743b4856abcf4708dfadcebd2",
"body": null,
"is_bot": false,
"headline": "support for value lists in enum & set field defs",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:29:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "76a23accffa4c334759603411f1112e4cd48c543",
"body": null,
"is_bot": false,
"headline": "auto_increment support",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:23:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7a9f01a2d52df18120275c00be609730087cb26b",
"body": null,
"is_bot": false,
"headline": "decode identifiers for column names in indexes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:21:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "795e5c421ae06da799517a0c49478f7cbd4207ea",
"body": "decode them too",
"is_bot": false,
"headline": "actually return index names instead of discarding them.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:20:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "04117a09d5db179e23e723b07609d520bf1e8926",
"body": "added decoding for values.\nrefactored decoding for identifiers.",
"is_bot": false,
"headline": "added support for default field values.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:17:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a93a2203fa9cdcce00c9a7bc168759f11440c81b",
"body": null,
"is_bot": false,
"headline": "handle single and double quoted strings",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:06:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d2cee4caddfd01122f61d26622990254510fac1f",
"body": null,
"is_bot": false,
"headline": "correctly parse index columns, taking into account length and asc/desc",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T05:03:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2cf04353680e1f5d6a3b3b3840d3e6e269f3c6c9",
"body": null,
"is_bot": false,
"headline": "support for index options",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:53:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f4c91622bdb4556b52d8abe3bb74d6e7c601cd8c",
"body": null,
"is_bot": false,
"headline": "when an index is USING HASH, it means the index type is ... hash. duh",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:51:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "13c51b9a300bd998a75e7111d3c4db653fe57100",
"body": null,
"is_bot": false,
"headline": "only add the 'more' array is there are extra, unparsed tokens",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:39:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ca6cf8a4fda37f8e762eb37a57571c0fa95c7f9e",
"body": null,
"is_bot": false,
"headline": "parse character set and collations",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:36:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1da164c1c056ce3ec8c9ac06f7b6fd505fc8a412",
"body": "support for unsigned and zerofill field props.\nsupport for null/not-null field props.",
"is_bot": false,
"headline": "support for fields lengths.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-13T02:45:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e67dee42779d46e3c5359aaea0c2aa308288a90c",
"body": null,
"is_bot": false,
"headline": "recognize the <unsigned numeric literal> token when lexing",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-13T02:45:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f5dbb8fbea72821ca9e14d683671876e07f7d4af",
"body": null,
"is_bot": false,
"headline": "renamed test files to .php to avoid confusion",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:47:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b32f1387cf88adcad2bef45b6bf772f3ecf65bec",
"body": null,
"is_bot": false,
"headline": "updated the readme to reflect what the library's purpose is now",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:45:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dc27f3a9eecc4a822a7bea52760ac7f019aa6dab",
"body": null,
"is_bot": false,
"headline": "the old glitch schema, for testing",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:39:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d58439c8699a00fe88d007eb1601d49acff8ad99",
"body": null,
"is_bot": false,
"headline": "point the tests to the new file & classname",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:38:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bf7aede91ed4757caa2207bcf963ccd37b423a95",
"body": null,
"is_bot": false,
"headline": "renamed main file and the class inside it",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:36:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e4bd20b03349a3dd38f2a32b19891e9ca056d71f",
"body": "…rser now",
"is_bot": false,
"headline": "removed the old compare script - this repo is just going to be the pa…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:05:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a32a7af0068c2de0392c33329865ff7be0890369",
"body": "stubbed out all of the supported fields types (non complete yet)",
"is_bot": false,
"headline": "changed field parsing to use a switch.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-14T18:08:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8efc1bb7c883081a833c1d8819b11a52412610b0",
"body": null,
"is_bot": false,
"headline": "the first end-to-end test",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-14T17:50:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6132eec6b8e0d46b6cce895db496ab453ecc588e",
"body": "…() method caqn be fully tested.",
"is_bot": false,
"headline": "added a global option for debugging a single table, so that the parse…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-14T17:49:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "efc92572519fca4cf0cef846e78ab2ba26091bab",
"body": "avoids having to use StrToUpper in the field parser.",
"is_bot": false,
"headline": "some more single-token keywords that need uppercasing.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-12T20:35:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fb1460b076b9296ea91251071846f9e55e49d23c",
"body": "added support for FULLTEXT and SPATIAL indexes.",
"is_bot": false,
"headline": "switch the index parser to use a switch().",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-12T20:33:40Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 2,
"commits_last_year": 6,
"latest_release_at": "2026-01-28T22:23:25Z",
"latest_release_tag": "v0.7",
"releases_from_tags": false,
"days_since_last_push": 174,
"active_weeks_last_year": 1,
"days_since_latest_release": 174,
"mean_days_between_releases": 3062.7
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": false,
"health_percentage": 42,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": [
{
"name": "iamcal/sql-parser",
"exists": true,
"license": "MIT",
"keywords": [],
"ecosystem": "packagist",
"matches_repo": true,
"registry_url": "https://packagist.org/packages/iamcal/sql-parser",
"is_deprecated": false,
"latest_version": "v0.7",
"repository_url": "https://github.com/iamcal/SQLParser",
"versions_count": 7,
"total_downloads": 38486535,
"dependents_count": 10,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": 4742890,
"first_published_at": null,
"latest_published_at": "2026-01-28T22:20:33Z",
"latest_version_yanked": null,
"days_since_latest_publish": 174
}
]
},
"popularity": {
"forks": 20,
"stars": 77,
"watchers": 3,
"fork_history": {
"days": [
{
"date": "2017-02-14",
"count": 1
},
{
"date": "2018-01-08",
"count": 1
},
{
"date": "2018-08-29",
"count": 1
},
{
"date": "2018-11-29",
"count": 1
},
{
"date": "2019-02-06",
"count": 1
},
{
"date": "2019-06-10",
"count": 1
},
{
"date": "2019-06-20",
"count": 1
},
{
"date": "2019-08-13",
"count": 1
},
{
"date": "2019-08-16",
"count": 1
},
{
"date": "2019-09-22",
"count": 1
},
{
"date": "2020-04-30",
"count": 1
},
{
"date": "2020-12-16",
"count": 1
},
{
"date": "2021-09-21",
"count": 1
},
{
"date": "2021-10-14",
"count": 1
},
{
"date": "2022-03-03",
"count": 1
},
{
"date": "2022-04-24",
"count": 1
},
{
"date": "2022-05-25",
"count": 1
},
{
"date": "2024-01-12",
"count": 1
},
{
"date": "2024-12-13",
"count": 1
},
{
"date": "2026-01-24",
"count": 1
}
],
"complete": true,
"collected": 20,
"total_forks": 20
},
"star_history": null,
"open_issues_and_prs": 1
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": false,
"has_mcp_signal": false,
"bootstrap_files": [
"Makefile"
],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [],
"largest_source_bytes": 27313,
"source_files_sampled": 12,
"oversized_source_files": 0,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"dependencies": {
"manifests": [
"composer.json"
],
"advisories": {
"error": "No resolved dependencies carried a version and a supported ecosystem",
"scope": "repository_graph",
"source": null,
"findings": [],
"collected": false,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 0,
"malicious_count": 0,
"assessed_package": null,
"unassessed_count": 2,
"direct_affected_count": 0
},
"ecosystems": [
"packagist"
],
"dependencies": [],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "php-coveralls/php-coveralls",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "phpunit/phpunit",
"direct": false,
"version": null,
"ecosystem": "packagist"
}
],
"collected": true,
"truncated": false,
"total_count": 2,
"direct_count": 0,
"indirect_count": 2
}
},
"maintainership": {
"issues": {
"open_prs": 1,
"merged_prs": 21,
"open_issues": 0,
"closed_ratio": 1,
"closed_issues": 8,
"closed_unmerged_prs": 2
},
"bus_factor": 1,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "iamcal",
"commits": 109,
"avatar_url": "https://avatars.githubusercontent.com/u/173750?v=4"
},
{
"type": "User",
"login": "ngmy",
"commits": 6,
"avatar_url": "https://avatars.githubusercontent.com/u/864041?v=4"
},
{
"type": "User",
"login": "rodber",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/20590102?v=4"
},
{
"type": "User",
"login": "demmer",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/3308504?v=4"
},
{
"type": "User",
"login": "DirtyRacer1337",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/17379553?v=4"
},
{
"type": "User",
"login": "owenvoke",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/1899334?v=4"
},
{
"type": "User",
"login": "WilliamFalci",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/36926081?v=4"
},
{
"type": "User",
"login": "richardudovich",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/828730?v=4"
}
],
"contributors_sampled": 8,
"top_contributor_share": 0.872
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"php.yml"
],
"has_docs_dir": false,
"linter_configs": [],
"has_editorconfig": false,
"has_linter_config": false,
"has_precommit_config": false
},
"security_signals": {
"lockfiles": [],
"scorecard": {
"checks": [
{
"name": "Binary-Artifacts",
"score": 10,
"reason": "no binaries found in the repo",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
},
{
"name": "Branch-Protection",
"score": 0,
"reason": "branch protection not enabled on development/release branches",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 0,
"reason": "1 out of 16 merged PRs checked by a CI test -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
},
{
"name": "CII-Best-Practices",
"score": 0,
"reason": "no effort to earn an OpenSSF best practices badge detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
},
{
"name": "Code-Review",
"score": 3,
"reason": "Found 8/22 approved changesets -- score normalized to 3",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 6,
"reason": "project has 2 contributing companies or organizations -- score normalized to 6",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": null,
"reason": "no workflows found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 0,
"reason": "no update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 0,
"reason": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
},
{
"name": "Packaging",
"score": null,
"reason": "packaging workflow not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
},
{
"name": "Pinned-Dependencies",
"score": null,
"reason": "no dependencies found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
},
{
"name": "SAST",
"score": 0,
"reason": "SAST tool is not run on all commits -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
},
{
"name": "Security-Policy",
"score": 0,
"reason": "security policy file not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
},
{
"name": "Signed-Releases",
"score": null,
"reason": "no releases found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
},
{
"name": "Token-Permissions",
"score": null,
"reason": "No tokens found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
},
{
"name": "Vulnerabilities",
"score": 10,
"reason": "0 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "610392f38de49a44dab08dc1659960a29874c4b8",
"ran_at": "2026-07-22T17:43:47Z",
"aggregate_score": 3,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": false,
"has_dependabot_config": false
},
"contribution_flow": {
"collected": true,
"ci_last_run_at": "2026-04-19T06:21:28Z",
"oldest_open_prs": [
{
"number": 5,
"created_at": "2017-09-10T05:34:31Z",
"last_comment_at": "2017-09-10T05:39:04Z",
"last_comment_author": "coveralls"
}
],
"last_merged_pr_at": "2026-01-28T22:20:33Z",
"ci_last_conclusion": "FAILURE",
"oldest_open_issues": []
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/iamcal/SQLParser",
"host": "github.com",
"name": "SQLParser",
"owner": "iamcal"
},
"metrics": {
"overall": {
"key": "overall",
"band": "moderate",
"name": "Overall health",
"note": null,
"notes": [],
"value": 50,
"inputs": {
"security": 30,
"vitality": 37,
"community": 56,
"governance": 68,
"engineering": 53
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "at_risk",
"name": "Vitality",
"value": 37,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "critical",
"name": "Development activity",
"note": null,
"notes": [],
"value": 18,
"inputs": {
"commits_last_year": 6,
"human_commit_share": 1,
"days_since_last_push": 174,
"active_weeks_last_year": 1
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 174 days ago",
"points": 9.9,
"status": "partial",
"details": [
{
"code": "push_recency",
"params": {
"days": 174
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "1/52 weeks with commits",
"points": 0.7,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 1
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "6 commits in the last year",
"points": 7.6,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 6
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "moderate",
"name": "Release discipline",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 66,
"inputs": {
"releases_count": 2,
"latest_release_tag": "v0.7",
"releases_from_tags": false,
"days_since_latest_release": 174,
"mean_days_between_releases": 3062.7
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "2 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 2
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 174 days ago",
"points": 27,
"status": "partial",
"details": [
{
"code": "release_recency",
"params": {
"days": 174
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~3062.7 days",
"points": 5.4,
"status": "partial",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 3062.7
}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "abandonment",
"band": "excellent",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"cap": null,
"state": "maintained",
"guards": [],
"signals": [],
"red_flag": false,
"multiplier_pct": 100,
"declared_reason": null,
"unverified_reason": null,
"unanswered_open_prs": null,
"unanswered_open_issues": null,
"days_since_last_merged_pr": null,
"days_since_last_human_commit": 174,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 174 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 174
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "moderate",
"name": "Community & Adoption",
"value": 56,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "at_risk",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 43,
"inputs": {
"forks": 20,
"stars": 77,
"watchers": 3,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "77 stars",
"points": 30.5,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 77
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "20 forks",
"points": 10.7,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 20
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "3 watchers",
"points": 1.7,
"status": "partial",
"details": [
{
"code": "watchers",
"params": {
"count": 3
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "moderate",
"name": "Community health",
"note": null,
"notes": [],
"value": 50,
"inputs": {
"has_readme": true,
"has_license": true,
"has_contributing": false,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 22.5,
"status": "met",
"details": [],
"max_points": 22.5
},
{
"key": "license",
"name": "License",
"detail": "recognized license (MIT)",
"points": 22.5,
"status": "met",
"details": [
{
"code": "license_standard",
"params": {}
},
{
"code": "license_spdx",
"params": {
"spdx": "MIT"
}
}
],
"max_points": 22.5
},
{
"key": "contributing_guide",
"name": "CONTRIBUTING guide",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 18
},
{
"key": "code_of_conduct",
"name": "Code of conduct",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 13.5
},
{
"key": "issue_template",
"name": "Issue template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.2
},
{
"key": "pr_template",
"name": "PR template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.3
}
]
},
{
"key": "ecosystem_adoption",
"band": "excellent",
"name": "Ecosystem adoption (downloads)",
"note": null,
"notes": [],
"value": 87,
"inputs": {
"packages": [
"iamcal/sql-parser"
],
"dependents": 10,
"ecosystems": "packagist",
"total_downloads": 38486535,
"monthly_downloads": 4742890
},
"components": [
{
"key": "monthly_downloads",
"name": "Monthly downloads",
"detail": "4,742,890 downloads/month across packagist",
"points": 80,
"status": "met",
"details": [
{
"code": "downloads_monthly",
"params": {
"count": 4742890,
"ecosystems": "packagist"
}
}
],
"max_points": 80
},
{
"key": "registry_dependents",
"name": "Registry dependents",
"detail": "10 packages depend on it",
"points": 6.9,
"status": "partial",
"details": [
{
"code": "registry_dependents",
"params": {
"count": 10
}
}
],
"max_points": 20
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "moderate",
"name": "Sustainability & Governance",
"value": 68,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "critical",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 29,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 8,
"top_contributor_share": 0.872
},
"components": [
{
"key": "bus_factor",
"name": "Bus factor",
"detail": "1 contributor(s) cover half of all commits",
"points": 9,
"status": "partial",
"details": [
{
"code": "bus_factor",
"params": {
"count": 1
}
}
],
"max_points": 54
},
{
"key": "commit_distribution",
"name": "Commit distribution",
"detail": "top contributor authored 87% of commits",
"points": 2.9,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 87
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "8 contributors",
"points": 10.8,
"status": "partial",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 8
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 2 contributing companies or organizations -- score normalized to 6",
"points": 6,
"status": "partial",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "excellent",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 86,
"inputs": {
"merged_prs": 21,
"open_issues": 0,
"closed_issues": 8,
"issue_closed_ratio": 1,
"closed_unmerged_prs": 2
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "100% of issues closed",
"points": 46.8,
"status": "met",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 100
}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "21/23 decided PRs merged",
"points": 34.9,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 21,
"decided": 23
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 8/22 approved changesets -- score normalized to 3",
"points": 4.5,
"status": "partial",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "good",
"name": "Ownership & stewardship",
"note": "Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"verified_domain"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 71,
"inputs": {
"followers": 1025,
"owner_type": "User",
"is_verified": null,
"owner_login": "iamcal",
"public_repos": 193,
"account_age_days": 6048
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "personal (user) account",
"points": 10,
"status": "partial",
"details": [
{
"code": "owner_personal",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": "not applicable to user accounts",
"points": 0,
"status": "excluded",
"details": [
{
"code": "not_applicable_to_user_accounts",
"params": {}
}
],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "1,025 followers of iamcal",
"points": 21.6,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 1025,
"login": "iamcal"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "193 public repos, account ~16 yr old",
"points": 25,
"status": "met",
"details": [
{
"code": "public_repos",
"params": {
"count": 193
}
},
{
"code": "account_age_years",
"params": {
"years": 16
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "excellent",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"iamcal/sql-parser"
],
"ecosystems": "packagist",
"any_deprecated": false,
"min_days_since_publish": 174
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "1 package(s) on packagist",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 1,
"ecosystems": "packagist"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 174 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 174
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "7 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 7
}
}
],
"max_points": 20
},
{
"key": "not_deprecated",
"name": "Not deprecated",
"detail": "active, not deprecated or yanked",
"points": 20,
"status": "met",
"details": [
{
"code": "package_not_deprecated",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "moderate",
"name": "Engineering Quality",
"value": 53,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "at_risk",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 48,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": false,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "1 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 1
}
}
],
"max_points": 24
},
{
"key": "tests_present",
"name": "Tests present",
"detail": null,
"points": 24,
"status": "met",
"details": [],
"max_points": 24
},
{
"key": "linter_config",
"name": "Linter config",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 9.6
},
{
"key": "editorconfig",
"name": ".editorconfig",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "1 out of 16 merged PRs checked by a CI test -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "moderate",
"name": "Documentation",
"note": null,
"notes": [],
"value": 60,
"inputs": {
"topics": [
"php",
"sql-parser",
"lex",
"composer",
"database",
"autoloader"
],
"has_wiki": true,
"homepage": null,
"has_readme": true,
"has_docs_dir": false,
"has_description": true
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 30,
"status": "met",
"details": [],
"max_points": 30
},
{
"key": "documentation_directory",
"name": "Documentation directory",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "repository_description",
"name": "Repository description",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "topics",
"name": "Topics",
"detail": "6 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 6
}
}
],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "at_risk",
"name": "Security",
"value": 30,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "at_risk",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Dangerous-Workflow, Packaging, Pinned-Dependencies, Signed-Releases, Token-Permissions. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"dangerous_workflow",
"packaging",
"pinned_dependencies",
"signed_releases",
"token_permissions"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 30,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 13,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 5,
"scorecard_aggregate": 3
},
"components": [
{
"key": "binary_artifacts",
"name": "Binary-Artifacts",
"detail": "no binaries found in the repo",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "branch_protection",
"name": "Branch-Protection",
"detail": "branch protection not enabled on development/release branches",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "1 out of 16 merged PRs checked by a CI test -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "cii_best_practices",
"name": "CII-Best-Practices",
"detail": "no effort to earn an OpenSSF best practices badge detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "code_review",
"name": "Code-Review",
"detail": "Found 8/22 approved changesets -- score normalized to 3",
"points": 2.2,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 2 contributing companies or organizations -- score normalized to 6",
"points": 1.5,
"status": "partial",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no workflows found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
},
{
"key": "dependency_update_tool",
"name": "Dependency-Update-Tool",
"detail": "no update tool detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow not detected",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "pinned_dependencies",
"name": "Pinned-Dependencies",
"detail": "no dependencies found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is not run on all commits -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "security_policy",
"name": "Security-Policy",
"detail": "security policy file not detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "signed_releases",
"name": "Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "token_permissions",
"name": "Token-Permissions",
"detail": "No tokens found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "0 existing vulnerabilities detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "excellent",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"review_only_matches": 0,
"assessed_self_published_locations": 9
},
"components": [
{
"key": "policy_exposure_multiplier",
"name": "Policy exposure multiplier",
"detail": "no confirmed policy-scope location match",
"points": 100,
"status": "met",
"details": [
{
"code": "jurisdiction_no_match",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "at_risk",
"name": "AI Readiness",
"value": 33,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "critical",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 6,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.12,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "no CLAUDE.md / AGENTS.md / editor rules",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_instructions",
"params": {}
}
],
"max_points": 45
},
{
"key": "machine_readable_docs_llms_txt",
"name": "Machine-readable docs (llms.txt)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "legible_commit_history",
"name": "Legible commit history",
"detail": "12 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 6.4,
"status": "partial",
"details": [
{
"code": "legible_history",
"params": {
"legible": 12,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "at_risk",
"name": "Verify loop (build / test / typecheck)",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Pinned-Dependencies. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_pinned_dependencies"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 44,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": false,
"typed_language": false,
"bootstrap_files": [
"Makefile"
],
"has_devcontainer": false,
"has_linter_config": false,
"typecheck_configs": [],
"agent_commit_share": 0,
"toolchain_manifests": [],
"dependency_bot_commit_share": 0
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": "Makefile",
"points": 18,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Makefile"
}
}
],
"max_points": 18
},
{
"key": "automated_tests",
"name": "Automated tests",
"detail": null,
"points": 22,
"status": "met",
"details": [],
"max_points": 22
},
{
"key": "lint_format_config",
"name": "Lint / format config",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "no agent-authored commits among the last 100",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_authored_commits",
"params": {
"sampled": 100
}
}
],
"max_points": 10
},
{
"key": "automated_maintenance",
"name": "Automated maintenance",
"detail": "no automated dependency updates observed",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_dependency_automation",
"params": {}
}
],
"max_points": 8
},
{
"key": "openssf_scorecard_pinned_dependencies",
"name": "OpenSSF Scorecard: Pinned-Dependencies",
"detail": "no dependencies found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "moderate",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 55,
"inputs": {
"primary_language": "PHP",
"largest_source_bytes": 27313,
"source_files_sampled": 12,
"oversized_source_files": 0
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "PHP without a type-check config",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_typecheck_config_language",
"params": {
"language": "PHP"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "0/12 source files over 60KB",
"points": 55,
"status": "met",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 12,
"oversized": 0
}
}
],
"max_points": 55
}
]
}
],
"description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
}
],
"metrics_version": "1.13.0"
},
"warnings": [
"Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
"No resolved dependencies carried a version and a supported ecosystem"
],
"report_type": "repository",
"generated_at": "2026-07-22T17:44:03.883045Z",
"schema_version": "0.26.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/i/iamcal/SQLParser.svg",
"full_name": "iamcal/SQLParser",
"license_state": "standard",
"license_spdx": "MIT"
}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 v1.13.0, schema v0.26.0 — full methodology · metrics wiki.
How one result sits in the wider record: aggregate statistics — Packagist.