Public recordModerate
Software health reportschema 0.27.0 · metrics 1.13.0 · 2026-07-23 11:55 UTC
flow-php / postgresql
flow-php/postgresql holds a health index of 53 out of 100, placing it in the Moderate band. It scores highest on Vitality (83/100) and lowest on AI Readiness (36/100). It was last updated today. A single contributor accounts for most of its recent work.
53
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.
53
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
Flow PHPOrganization
146 followers64 public repossince Oct 2020
This repository is backed by an organization — shared, accountable stewardship that can outlive any single maintainer.
Package ecosystems
| Registry | Package | Version | Downloads / mo | Versions | Last publish | Tags |
|---|---|---|---|---|---|---|
| Packagist | flow-php/postgresql | 0.41.1 | 2,731 | 18 | 22 days ago | phpsqlparserpostgresqlqueryast |
Metrics by category
Vitality
Is the project alive — is code being written and are releases shipping?
83
Development activity
79Good
How it's scored
| 36/36 | Push recency — last push 0 days ago |
| 15.9/36 | Commit cadence — 23/52 weeks with commits |
| 16.7/18 | Commit volume — 71 commits in the last year |
| 10/10 | OpenSSF Scorecard: Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10 |
Inputs used
| commits_last_year | 71 |
| human_commit_share | 1 |
| days_since_last_push | 0 |
| active_weeks_last_year | 23 |
Release discipline
88Excellent
How it's scored
| 16.2/27 | Ships releases — 18 version tags (no GitHub releases) |
| 36/36 | Release recency — latest release 22 days ago |
| 27/27 | Release cadence — a release every ~10.5 days |
| 0/10 | OpenSSF Scorecard: Signed-Releases — no data |
Inputs used
| releases_count | 18 |
| latest_release_tag | 0.41.1 |
| releases_from_tags | yes |
| days_since_latest_release | 22 |
| mean_days_between_releases | 10.5 |
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?
38
Popularity & adoption
1Critical
How it's scored
| 0/60 | Stars — 0 stars |
| 0/25 | Forks — 0 forks |
| 0/15 | Watchers — 0 watchers |
Inputs used
| forks | 0 |
| stars | 0 |
| watchers | 0 |
| growth_state | unverified |
| growth_factor_pct | 100 |
| growth_unverified_reason | no_history |
Community health
70Good
How it's scored
| 22.5/22.5 | README |
| 22.5/22.5 | License — recognized license (MIT) |
| 18/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 | yes |
| has_issue_template | no |
| has_code_of_conduct | no |
| has_pull_request_template | no |
Ecosystem adoption (downloads)
52Moderate
How it's scored
| 45.8/80 | Monthly downloads — 2,731 downloads/month across packagist |
| 6.4/20 | Registry dependents — 8 packages depend on it |
Inputs used
| packages | flow-php/postgresql |
| dependents | 8 |
| ecosystems | packagist |
| total_downloads | 26,851 |
| monthly_downloads | 2,731 |
Sustainability & Governance
Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?
44
Maintainer resilience (bus factor)
20Critical
How it's scored
| 9/54 | Bus factor — 1 contributor(s) cover half of all commits |
| 0/22.5 | Commit distribution — top contributor authored 100% of commits |
| 1.4/13.5 | Contributor breadth — 1 contributors |
| 10/10 | OpenSSF Scorecard: Contributors — project has 6 contributing companies or organizations |
Inputs used
| bus_factor | 1 |
| contributors_sampled | 1 |
| top_contributor_share | 1 |
Issue & PR responsiveness
1Critical
How it's scored
| 0/46.8 | Issue resolution — no issues or no data |
| 0/38.3 | PR acceptance — no decided pull requests or no data |
| 0/15 | OpenSSF Scorecard: Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
Inputs used
| merged_prs | 0 |
| open_issues | 0 |
| closed_issues | 0 |
| issue_closed_ratio | — |
| closed_unmerged_prs | 0 |
Excluded from scoring (no data or not applicable): Issue resolution, PR acceptance. Remaining weights renormalized.
Ownership & stewardship
70Good
How it's scored
| 30/30 | Ownership backing — organization-owned |
| 0/20 | Verified domain |
| 15.6/25 | Owner reach — 146 followers of flow-php |
| 24.5/25 | Track record — 64 public repos, account ~5 yr old |
Inputs used
| followers | 146 |
| owner_type | Organization |
| is_verified | — |
| owner_login | flow-php |
| public_repos | 64 |
| account_age_days | 2,095 |
Package maintenance
100Excellent
How it's scored
| 25/25 | Published & resolvable — 1 package(s) on packagist |
| 35/35 | Publish recency — latest publish 22 days ago |
| 20/20 | Version history — 18 published versions |
| 20/20 | Not deprecated — active, not deprecated or yanked |
Inputs used
| packages | flow-php/postgresql |
| ecosystems | packagist |
| any_deprecated | no |
| min_days_since_publish | 22 |
Engineering Quality
Are baseline engineering and documentation practices in place?
52
Engineering practices
60Moderate
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 — no data |
Inputs used
| has_ci | yes |
| has_tests | yes |
| has_editorconfig | no |
| has_linter_config | no |
| has_precommit_config | no |
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: CI-Tests. Remaining weights renormalized.
Documentation
40At risk
How it's scored
| 30/30 | README |
| 0/25 | Documentation directory |
| 0/15 | Documentation / homepage site |
| 0/10 | Repository description |
| 0/10 | Topics |
| 10/10 | Wiki |
Inputs used
| topics | — |
| has_wiki | yes |
| homepage | — |
| has_readme | yes |
| has_docs_dir | no |
| has_description | no |
Security
Are visible security and supply-chain practices strong, without unresolved high-risk jurisdiction exposure?
41
Security posture
41At 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 — no data |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 0/7.5 | Code-Review — Found 0/30 approved changesets -- score normalized to 0 |
| 2.5/2.5 | Contributors — project has 6 contributing companies or organizations |
| 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 |
| 7.5/7.5 | Maintained — 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10 |
| 0/5 | Packaging — no data |
| 0/5 | Pinned-Dependencies — no data |
| 0/5 | SAST — no SAST tool detected |
| 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 | 12 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 6 |
| scorecard_aggregate | 4.1 |
Excluded from scoring (no data or not applicable): ci_tests, 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.
36
Agent context & guidance
40At risk
How it's scored
| 0/45 | Agent instructions — no CLAUDE.md / AGENTS.md / editor rules |
| 0/15 | Machine-readable docs (llms.txt) |
| 40/40 | Legible commit history — 72 of 72 human commits state their intent (structured subject or explanatory body) |
Inputs used
| has_llms_txt | no |
| legible_history_share | 1 |
| agent_instruction_files | — |
| agent_instruction_max_bytes | — |
Verify loop (build / test / typecheck)
24Critical
How it's scored
| 0/18 | One-command bootstrap |
| 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 72 |
| 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 | — |
| 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 |
| 54.8/55 | Manageable file sizes — 5/1,475 source files over 60KB |
Inputs used
| primary_language | PHP |
| largest_source_bytes | 233,470 |
| source_files_sampled | 1,475 |
| oversized_source_files | 5 |
Machine-readable interfaces
40At risk
How it's scored
| 40/40 | API schema (OpenAPI/GraphQL/proto) — resources/proto/pg_query.proto |
| 0/20 | MCP server |
| 0/40 | Runnable examples |
Inputs used
| example_dirs | — |
| has_mcp_signal | no |
| api_schema_files | resources/proto/pg_query.proto |
Key facts
0GitHub stars
1contributors
71commits, last 12 months
0days since last push
18releases
1bus factor
0open issues
Packagistpackage ecosystems
Data collection warnings
- No resolved dependencies carried a version and a supported ecosystem
More detail
OpenSSF Scorecard 4.1 / 10
4.1aggregate
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 |
| n/a | CI-Tests | no pull request found |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 0 | Code-Review | Found 0/30 approved changesets -- score normalized to 0 |
| 10 | Contributors | project has 6 contributing companies or organizations |
| 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 |
| 10 | Maintained | 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10 |
| n/a | Packaging | packaging workflow not detected |
| n/a | Pinned-Dependencies | no dependencies found |
| 0 | SAST | no SAST tool detected |
| 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 |
Direct dependencies 4
| Registry | Package | Version constraint | Manifest |
|---|---|---|---|
| Packagist | flow-php/telemetry | self.version | composer.json |
| Packagist | flow-php/types | self.version | composer.json |
| Packagist | google/protobuf | ^4.0 || ^5.0 | composer.json |
| Packagist | psr/clock | ^1.0 | composer.json |
All dependencies 7
Full resolved dependency set from the GitHub dependency graph: 4 direct and 3 indirect (transitive) packages. The transitive closure is complete when the repository commits a lockfile.
| Registry | Package | Version | Relation |
|---|---|---|---|
| Packagist | flow-php/telemetry | — | direct |
| Packagist | flow-php/types | — | direct |
| Packagist | google/protobuf | — | direct |
| Packagist | psr/clock | — | direct |
| Packagist | ext-pg_query | — | indirect |
| Packagist | ext-pgsql | — | indirect |
| Packagist | php | — | 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": [],
"is_fork": false,
"size_kb": 2498,
"has_wiki": true,
"homepage": null,
"languages": {
"PHP": 4089040
},
"pushed_at": "2026-07-23T11:46:46Z",
"created_at": "2025-12-09T09:58:24Z",
"owner_type": "Organization",
"updated_at": "2026-07-23T11:46:50Z",
"description": null,
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "1.x",
"license_spdx_raw": "MIT",
"primary_language": "PHP",
"significant_languages": [
"PHP"
]
},
"owner": {
"blog": "http://flow-php.com",
"name": "Flow PHP",
"type": "Organization",
"login": "flow-php",
"company": null,
"location": null,
"followers": 146,
"avatar_url": "https://avatars.githubusercontent.com/u/73495297?v=4",
"created_at": "2020-10-26T18:40:27Z",
"is_verified": null,
"public_repos": 64,
"account_age_days": 2095
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "0.41.1",
"kind": "patch",
"published_at": "2026-06-30T13:41:22Z"
},
{
"tag": "0.41.0",
"kind": "minor",
"published_at": "2026-06-29T07:25:45Z"
},
{
"tag": "0.40.0",
"kind": "minor",
"published_at": "2026-06-16T12:58:25Z"
},
{
"tag": "0.39.0",
"kind": "minor",
"published_at": "2026-06-04T18:30:35Z"
},
{
"tag": "0.38.0",
"kind": "minor",
"published_at": "2026-05-22T11:28:43Z"
},
{
"tag": "0.37.0",
"kind": "minor",
"published_at": "2026-05-08T15:52:07Z"
},
{
"tag": "0.36.0",
"kind": "minor",
"published_at": "2026-04-19T17:24:46Z"
},
{
"tag": "0.35.1",
"kind": "patch",
"published_at": "2026-04-07T09:15:00Z"
},
{
"tag": "0.35.0",
"kind": "minor",
"published_at": "2026-04-07T09:15:00Z"
},
{
"tag": "0.34.3",
"kind": "patch",
"published_at": "2026-03-27T20:28:19Z"
},
{
"tag": "0.34.2",
"kind": "patch",
"published_at": "2026-03-27T20:28:19Z"
},
{
"tag": "0.34.1",
"kind": "patch",
"published_at": "2026-03-27T20:28:19Z"
},
{
"tag": "0.34.0",
"kind": "minor",
"published_at": "2026-03-04T21:47:24Z"
},
{
"tag": "0.33.0",
"kind": "minor",
"published_at": "2026-03-04T21:47:24Z"
},
{
"tag": "0.32.0",
"kind": "minor",
"published_at": "2026-02-23T17:41:24Z"
},
{
"tag": "0.31.0",
"kind": "minor",
"published_at": "2026-01-08T18:01:25Z"
},
{
"tag": "0.30.0",
"kind": "minor",
"published_at": "2026-01-02T11:54:54Z"
},
{
"tag": "0.29.0",
"kind": "minor",
"published_at": "2025-12-17T10:27:31Z"
}
],
"recent_commits": [
{
"oid": "079786f7b21ca3df6cf6cf04feb7348b9b9db2d6",
"body": "…544)",
"is_bot": false,
"headline": "feat(landing): performance optimizations blog post + blog RSS fee (#2…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-07-23T11:46:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ad9a47e37e73751e279376014fa8747e71cd978f",
"body": "…ntions",
"is_bot": false,
"headline": "refactor: align telemetry signals with the latest OTel semantic conve…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-07-03T11:11:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "64dcc23218eb54b8af2629ff9c817961432bd73b",
"body": "…etric",
"is_bot": false,
"headline": "feat(telemetry): standardize emitted metric names and add messenger m…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-30T13:41:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "84557bd8a67403cac5b09813b829d30fe2f5598c",
"body": null,
"is_bot": false,
"headline": "chore: update dependencies and fix mago lint/analyze finding",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-29T07:25:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "40fdc5ea2862882259d7e8409fbcedff82a7c6b7",
"body": null,
"is_bot": false,
"headline": "Symfony telemetry sub requests (#2489)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-29T07:06:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2f0010441ff040616c9e96a37b66844bba25e372",
"body": "…e linking (#2486)",
"is_bot": false,
"headline": "fix(flow-php/pg-query-ext): verify libpg_query PostgreSQL major befor…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-25T06:11:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "327aee7412902599b8e2bc41b1281d3fe1076a2e",
"body": null,
"is_bot": false,
"headline": "Chores - bug fixes (#2480)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-23T10:59:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b4c1f16e0fe4b463dbef64d74bdf90ea5859a203",
"body": "…r panel (#2475)",
"is_bot": false,
"headline": "feat(flow-php/symfony-postgresql-bundle): add Flow Migrations profile…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-22T12:27:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "995926bfeebf936747d500c1693c465119fb3a46",
"body": "…et to ON CONFLICT DO NOTHING (#2452)",
"is_bot": false,
"headline": "fix(flow-php/postgresql): lower BulkInsert upsert with empty update s…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-16T12:58:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bedd21693bd95daf256cd542ec5f70108e3c53d3",
"body": "…ndles (#2448)",
"is_bot": false,
"headline": "feature: add Web Profiler integration for telemetry and postgresql bu…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-13T18:42:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f3ea4e087f9501b5233a2c07a632e3518c434f91",
"body": "…fault comparison (#2446)",
"is_bot": false,
"headline": "fix(flow-php/postgresql): detect stale-cast drift in column/domain de…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-12T17:55:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8b8314f6a82678453563e0de8cc71e6c38f8bb0a",
"body": "… (#2439)",
"is_bot": false,
"headline": "feat(flow-php/postgresql): default DateTimeInterface to UTC timestamp…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-10T09:36:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "52d474869b35ea45046ccfa71c26b6d34514e9b4",
"body": "…s during AST traversal (#2431)",
"is_bot": false,
"headline": "fix(flow-php/postgresql): count ParamRef nodes inside List expression…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-06T16:08:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ae08f691fcbc1cb392d95d48bd0312b9103ee4f3",
"body": "…ies (#2430)",
"is_bot": false,
"headline": "fix(flow-php/postgresql): raise parser nesting ceiling for large quer…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-06T08:20:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bc5cf1f08b83b7896648bdd2b617a35d30a9579a",
"body": "… part in BulkInsert (#2428)",
"is_bot": false,
"headline": "fix(flow-php/postgresql): quote schema-qualified table per identifier…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-04T18:30:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "44b31bdf31104d620aa45d197c9295e661a99619",
"body": null,
"is_bot": false,
"headline": "chore: update project dependencies",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-04T17:28:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9e586aa4fd87036ffac217c3c71e46b5a1bf9119",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2427 from flow-php/migrations-context-attributes",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-04T16:54:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "350ed29d30c5121417ba873ea4b81f15ef42ad7f",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2426 from flow-php/fix-gha",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-04T15:15:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "372ffad7a39c2fe837f81ea0db8adbcebefcb670",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2424 from flow-php/postgresql-table-options",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-04T14:42:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ec939df8b3ab2ac2b987e283ce202a46b3a5eb97",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2420 from flow-php/postgresql-bugs",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-04T10:21:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "40e708ebe689986104c24b63a4711d78562e2d2d",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2414 from flow-php/migrations-drop-if-exists",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-03T10:21:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "33df6cd7e475c13bf5f6fce7adbb29ff56cf1fe1",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2415 from flow-php/bug-custom-migrations-schema",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-03T10:07:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "62d0658396818e1705a2e383c1581fb528a880cd",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2412 from flow-php/postgresql-db-suffix",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-01T18:12:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "eca7f8d7d346c3dcf63e3a1bc825e8ed92723a61",
"body": "…iews",
"is_bot": false,
"headline": "Merge pull request #2410 from flow-php/postgresql-schema-comparator-v…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-06-01T10:49:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c7f1f92496a5cbb5ae5177f8c6da3fe6d44ecb01",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2407 from flow-php/migrations-exclusion-policy",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-31T12:35:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "900de887c92bb561bc323fc0b8ce32839f7b2172",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2404 from flow-php/flow-to-postgresql-schema",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-30T15:39:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "25731b0a8a31f0704d463d222e8e1bfe30a4f1f1",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2402 from flow-php/postgresql-default-values",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-30T12:07:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5fb71c138d98c27cdcd9417f191d813c0de9b45f",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2397 from flow-php/mago-adapters",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-29T07:16:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d4e727a9f5450e80c56d1a983ae99e7f909b8e8a",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2391 from flow-php/mago-bridges",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-27T08:36:09Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9c7cb27cc559d5f487089a6b0ff9e40b1193de53",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2372 from flow-php/data-frame-mago",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-22T11:28:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "203a62235d7949ce46f6687d148b66e7005ecb23",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2378 from stloyd/feature/ci-close-pr-gha",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-22T09:44:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6aafeda1101fa09aff88cc8c900d3a981a315b36",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2368 from flow-php/mago-static-analyze",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-19T10:02:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "251f1e93d6c39ed60af8a28d663285ff66834815",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2361 from flow-php/feature-mago-formatter",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-11T20:03:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e23092d270dd860cf4489d1bb321c5278187ad19",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2352 from flow-php/flow-telemetry-improvements",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-08T15:52:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f03e13890e719311bdbd8c3e5a4706b635beac1e",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2345 from flow-php/bug/bytea-converter",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-04T10:12:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e77c82075d1691f9141cdafa74d5584ff4ad80a1",
"body": null,
"is_bot": false,
"headline": "Merge pull request #2344 from flow-php/postgresql-positional-parameters",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-02T13:13:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ce0f266653d2d8dfb5c616beb8264894e232a962",
"body": null,
"is_bot": false,
"headline": "Static factory mapper (#2341)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-05-01T09:54:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f7d57c2f5dd9b3951b3d96c975c8020c4c639e27",
"body": null,
"is_bot": false,
"headline": "Postgresql mapping context (#2313)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-04-19T17:24:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "24dd06d06f7168ed586a2f9d52cf64e62dba94b1",
"body": null,
"is_bot": false,
"headline": "Postgresql mappers (#2306)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-04-15T21:15:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b7cb846202dad3ef56fdc3fd1d8798f7e285dec8",
"body": null,
"is_bot": false,
"headline": "Migrations bug (#2305)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-04-15T13:00:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d7ec84514206bf716adcb757852f8f67f303ef0e",
"body": null,
"is_bot": false,
"headline": "fix: added validation to IN statement to avoid segfaults (#2301)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-04-13T20:02:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a727356c5634a83d06666ef42b642135423bbc10",
"body": null,
"is_bot": false,
"headline": "chore: added support for protobuf ^4 | ^5 (#2300)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-04-12T17:55:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d208ad9f4c9ce1b8f95e8333ee7456d881ba001b",
"body": null,
"is_bot": false,
"headline": "feature: postgresql symfony messenger bridge (#2298)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-04-12T10:43:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "89e16b9b6049ba354745f0e2acad7b3b62362fcf",
"body": null,
"is_bot": false,
"headline": "flow-php/postgresql-migrations (#2290)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-04-07T09:15:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9a80bd7b59bdb57c7d265ab95d6a909b30a27143",
"body": "…#2277)",
"is_bot": false,
"headline": "chore: create standalone installation instructions for each package (…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-03-27T20:28:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3883fd3dc70d11a1a5a3756f210361d550438885",
"body": null,
"is_bot": false,
"headline": "chore: include flow-php/arrow-ext in Dockerfile (#2274)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-03-26T17:25:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9dac96df477dc28271453d396f088f5a81f85e7d",
"body": "…rs (#2245)",
"is_bot": false,
"headline": "fix: support for explicit schemas in update/merge/delete query builde…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-03-04T21:47:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "08e97532e97b77792fa6f27fd674426c6a984858",
"body": null,
"is_bot": false,
"headline": "Refactor telemtry signals (#2225)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-02-23T17:41:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "393bc75424b2b0cd8d7d1fcdc93a70c862c1121d",
"body": null,
"is_bot": false,
"headline": "update: dependencies",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-02-03T17:28:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "43973417d2fb70dd61695e337fb40e69ec5856ec",
"body": "…y-extension",
"is_bot": false,
"headline": "fix: added missingstup for pg_query_is_utility_stmt method of pg-quer…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-01-22T17:55:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dcff9edc655d4e1becf53061c3f94f1b25d0cc87",
"body": null,
"is_bot": false,
"headline": "refactor: optimized pgsql cursor extractor (#2136)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-01-08T18:01:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7b69b8abaa4e3a6e5e215f8500fa64dabaee21e3",
"body": null,
"is_bot": false,
"headline": "refactor: postgresql explain config (#2134)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-01-07T16:22:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5aa83c4444e2c1dc5c080c8f911663d63e2c14cd",
"body": null,
"is_bot": false,
"headline": "feature: postgresql plan summary (#2133)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-01-07T12:37:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e63ff6e3bff4730f6d25a720769df49ee85445fc",
"body": "…fset extractors (#2121)",
"is_bot": false,
"headline": "feature: allow to pass custom parameters to postgresql keyset/limitof…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-01-02T11:54:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "09af1a57766c2d5d90cd78fac18a0f1dea1055d3",
"body": null,
"is_bot": false,
"headline": "feature: postgresql - support modification connection parameters (#2120)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-01-01T22:33:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3340979a0136555ef6f04146b12d5e9a86871de9",
"body": "…119)",
"is_bot": false,
"headline": "feature: expose tables through from statement of select statement (#2…",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2026-01-01T15:13:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4f1d07240656f95f8e92f378e3fc9b6c9582aef0",
"body": null,
"is_bot": false,
"headline": "feature: postgresql - condition builder (#2113)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-30T19:05:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6be1d2a92670ae1fb239db1cd96941168e91a40d",
"body": null,
"is_bot": false,
"headline": "chore: split query and result exception in postgresql client (#2111)",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-29T18:15:09Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d600a9cf74dbf4f4a8dd618645dc6029cb0295a0",
"body": null,
"is_bot": false,
"headline": "feature: cursor based postgresql adapter",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-24T08:50:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4e87f977e517392dec7acea302af4c688e198de7",
"body": null,
"is_bot": false,
"headline": "fix: missing dsl definitions",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-22T14:59:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aa535e9a3c56e0723dfe5e7cf296deb89c370504",
"body": null,
"is_bot": false,
"headline": "fix: added missing pgsql extension on github actions",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-22T09:40:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "58246702687a496b02cd3f27b7be8363b269ff4e",
"body": null,
"is_bot": false,
"headline": "fix: static analysis, failing tests",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-20T17:45:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "733748df7442f8b23d804e1c22c554571ae8f942",
"body": null,
"is_bot": false,
"headline": "fix: handling query json result in postgresql/client",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-18T14:14:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cf232e81a33af4d82e7efc86d45e58c9ad567b0b",
"body": null,
"is_bot": false,
"headline": "feature: add explain method to postgresql client",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-18T13:28:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "27afd921abc0e0433cc9013305906ba65df9f683",
"body": null,
"is_bot": false,
"headline": "feature: query depth extractor",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-17T22:30:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8da20212437f3bb9157facf17f6dfaa52e520faf",
"body": null,
"is_bot": false,
"headline": "task: expose helper methods on SelectStatement",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-17T19:23:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "305ef3f0eb1229ecdf470024b7f67e1ffb7a9827",
"body": null,
"is_bot": false,
"headline": "fix: coding standards",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-17T17:37:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e2bfb3c0c790b6b889dceb9def55f645a749ffc8",
"body": null,
"is_bot": false,
"headline": "fix: added missing flow-php/types dependency to postgresql",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-17T10:27:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5d44b31421dd8f9cc76d7f432bd4bd30ec5e44e6",
"body": null,
"is_bot": false,
"headline": "fix: regenerated dsl definitions",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-16T18:10:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b73957edd988b9edc1d53851874641fb69bb00d0",
"body": null,
"is_bot": false,
"headline": "feature: update documentation",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-16T15:45:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "70de1ff90db8a785cdc6b86b57e25d2c9f7a00bf",
"body": null,
"is_bot": false,
"headline": "fix: missing 8.5 in ci/cd",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-12T10:57:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3f0f0a5686672a457dab0ee9963f371519964b77",
"body": null,
"is_bot": false,
"headline": "fix: missign packages required to install pg-query-ext through pie",
"author_name": "norberttech",
"author_login": "norberttech",
"committed_at": "2025-12-11T20:16:30Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 18,
"commits_last_year": 71,
"latest_release_at": "2026-06-30T13:41:22Z",
"latest_release_tag": "0.41.1",
"releases_from_tags": true,
"days_since_last_push": 0,
"active_weeks_last_year": 23,
"days_since_latest_release": 22,
"mean_days_between_releases": 10.5
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": false,
"has_contributing": true,
"health_percentage": 50,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": [
{
"name": "flow-php/postgresql",
"exists": true,
"license": "MIT",
"keywords": [
"php",
"sql",
"parser",
"postgresql",
"query",
"ast"
],
"ecosystem": "packagist",
"matches_repo": true,
"registry_url": "https://packagist.org/packages/flow-php/postgresql",
"is_deprecated": false,
"latest_version": "0.41.1",
"repository_url": "https://github.com/flow-php/postgresql",
"versions_count": 18,
"total_downloads": 26851,
"dependents_count": 8,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": 2731,
"first_published_at": null,
"latest_published_at": "2026-06-30T13:41:22Z",
"latest_version_yanked": null,
"days_since_latest_publish": 22
}
]
},
"popularity": {
"forks": 0,
"stars": 0,
"watchers": 0,
"fork_history": {
"days": [],
"complete": true,
"collected": 0,
"total_forks": 0
},
"star_history": {
"days": [],
"complete": true,
"collected": 0,
"total_stars": 0,
"collected_at": null
},
"open_issues_and_prs": 0
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": false,
"has_mcp_signal": false,
"bootstrap_files": [],
"api_schema_files": [
"resources/proto/pg_query.proto"
],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [],
"largest_source_bytes": 233470,
"source_files_sampled": 1475,
"oversized_source_files": 5,
"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": 7,
"direct_affected_count": 0
},
"ecosystems": [
"packagist"
],
"dependencies": [
{
"name": "flow-php/telemetry",
"manifest": "composer.json",
"ecosystem": "packagist",
"version_constraint": "self.version"
},
{
"name": "flow-php/types",
"manifest": "composer.json",
"ecosystem": "packagist",
"version_constraint": "self.version"
},
{
"name": "google/protobuf",
"manifest": "composer.json",
"ecosystem": "packagist",
"version_constraint": "^4.0 || ^5.0"
},
{
"name": "psr/clock",
"manifest": "composer.json",
"ecosystem": "packagist",
"version_constraint": "^1.0"
}
],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "flow-php/telemetry",
"direct": true,
"version": null,
"ecosystem": "packagist"
},
{
"name": "flow-php/types",
"direct": true,
"version": null,
"ecosystem": "packagist"
},
{
"name": "google/protobuf",
"direct": true,
"version": null,
"ecosystem": "packagist"
},
{
"name": "psr/clock",
"direct": true,
"version": null,
"ecosystem": "packagist"
},
{
"name": "ext-pg_query",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "ext-pgsql",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "php",
"direct": false,
"version": null,
"ecosystem": "packagist"
}
],
"collected": true,
"truncated": false,
"total_count": 7,
"direct_count": 4,
"indirect_count": 3
}
},
"maintainership": {
"issues": {
"open_prs": 0,
"merged_prs": 0,
"open_issues": 0,
"closed_ratio": null,
"closed_issues": 0,
"closed_unmerged_prs": 0
},
"bus_factor": 1,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "norberttech",
"commits": 72,
"avatar_url": "https://avatars.githubusercontent.com/u/1921950?v=4"
}
],
"contributors_sampled": 1,
"top_contributor_share": 1
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"readonly.yaml"
],
"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": null,
"reason": "no pull request found",
"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": 0,
"reason": "Found 0/30 approved changesets -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 10,
"reason": "project has 6 contributing companies or organizations",
"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": 10,
"reason": "30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10",
"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": "no SAST tool detected",
"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": "079786f7b21ca3df6cf6cf04feb7348b9b9db2d6",
"ran_at": "2026-07-23T11:55:03Z",
"aggregate_score": 4.1,
"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-07-23T11:46:47Z",
"oldest_open_prs": [],
"last_merged_pr_at": null,
"ci_last_conclusion": null,
"oldest_open_issues": []
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/flow-php/postgresql",
"host": "github.com",
"name": "postgresql",
"owner": "flow-php"
},
"metrics": {
"overall": {
"key": "overall",
"band": "moderate",
"name": "Overall health",
"note": null,
"notes": [],
"value": 53,
"inputs": {
"security": 41,
"vitality": 83,
"community": 38,
"governance": 44,
"engineering": 52
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "good",
"name": "Vitality",
"value": 83,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "good",
"name": "Development activity",
"note": null,
"notes": [],
"value": 79,
"inputs": {
"commits_last_year": 71,
"human_commit_share": 1,
"days_since_last_push": 0,
"active_weeks_last_year": 23
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 0 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "push_recency",
"params": {
"days": 0
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "23/52 weeks with commits",
"points": 15.9,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 23
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "71 commits in the last year",
"points": 16.7,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 71
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "excellent",
"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": 88,
"inputs": {
"releases_count": 18,
"latest_release_tag": "0.41.1",
"releases_from_tags": true,
"days_since_latest_release": 22,
"mean_days_between_releases": 10.5
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "18 version tags (no GitHub releases)",
"points": 16.2,
"status": "partial",
"details": [
{
"code": "version_tags_no_releases",
"params": {
"count": 18
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 22 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "release_recency",
"params": {
"days": 22
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~10.5 days",
"points": 27,
"status": "met",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 10.5
}
}
],
"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": 0,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 0 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 0
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "at_risk",
"name": "Community & Adoption",
"value": 38,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "critical",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 1,
"inputs": {
"forks": 0,
"stars": 0,
"watchers": 0,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "0 stars",
"points": 0,
"status": "missed",
"details": [
{
"code": "stars",
"params": {
"count": 0
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "0 forks",
"points": 0,
"status": "missed",
"details": [
{
"code": "forks",
"params": {
"count": 0
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "0 watchers",
"points": 0,
"status": "missed",
"details": [
{
"code": "watchers",
"params": {
"count": 0
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "good",
"name": "Community health",
"note": null,
"notes": [],
"value": 70,
"inputs": {
"has_readme": true,
"has_license": true,
"has_contributing": true,
"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": 18,
"status": "met",
"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": "moderate",
"name": "Ecosystem adoption (downloads)",
"note": null,
"notes": [],
"value": 52,
"inputs": {
"packages": [
"flow-php/postgresql"
],
"dependents": 8,
"ecosystems": "packagist",
"total_downloads": 26851,
"monthly_downloads": 2731
},
"components": [
{
"key": "monthly_downloads",
"name": "Monthly downloads",
"detail": "2,731 downloads/month across packagist",
"points": 45.8,
"status": "partial",
"details": [
{
"code": "downloads_monthly",
"params": {
"count": 2731,
"ecosystems": "packagist"
}
}
],
"max_points": 80
},
{
"key": "registry_dependents",
"name": "Registry dependents",
"detail": "8 packages depend on it",
"points": 6.4,
"status": "partial",
"details": [
{
"code": "registry_dependents",
"params": {
"count": 8
}
}
],
"max_points": 20
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "at_risk",
"name": "Sustainability & Governance",
"value": 44,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "critical",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 20,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 1,
"top_contributor_share": 1
},
"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 100% of commits",
"points": 0,
"status": "missed",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 100
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "1 contributors",
"points": 1.4,
"status": "partial",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 1
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 6 contributing companies or organizations",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "critical",
"name": "Issue & PR responsiveness",
"note": "Excluded from scoring (no data or not applicable): Issue resolution, PR acceptance. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"issue_resolution",
"pr_acceptance"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 1,
"inputs": {
"merged_prs": 0,
"open_issues": 0,
"closed_issues": 0,
"issue_closed_ratio": null,
"closed_unmerged_prs": 0
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "no issues or no data",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_issues_or_data",
"params": {}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "no decided pull requests or no data",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_decided_prs_or_data",
"params": {}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 0/30 approved changesets -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "good",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 70,
"inputs": {
"followers": 146,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "flow-php",
"public_repos": 64,
"account_age_days": 2095
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "organization-owned",
"points": 30,
"status": "met",
"details": [
{
"code": "owner_organization",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "146 followers of flow-php",
"points": 15.6,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 146,
"login": "flow-php"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "64 public repos, account ~5 yr old",
"points": 24.5,
"status": "partial",
"details": [
{
"code": "public_repos",
"params": {
"count": 64
}
},
{
"code": "account_age_years",
"params": {
"years": 5
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "excellent",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"flow-php/postgresql"
],
"ecosystems": "packagist",
"any_deprecated": false,
"min_days_since_publish": 22
},
"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 22 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 22
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "18 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 18
}
}
],
"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": 52,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "moderate",
"name": "Engineering practices",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: CI-Tests. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_ci_tests"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 60,
"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": "no pull request found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "at_risk",
"name": "Documentation",
"note": null,
"notes": [],
"value": 40,
"inputs": {
"topics": [],
"has_wiki": true,
"homepage": null,
"has_readme": true,
"has_docs_dir": false,
"has_description": false
},
"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": 0,
"status": "missed",
"details": [],
"max_points": 10
},
{
"key": "topics",
"name": "Topics",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"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": 41,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "at_risk",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): CI-Tests, Dangerous-Workflow, Packaging, Pinned-Dependencies, Signed-Releases, Token-Permissions. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"ci_tests",
"dangerous_workflow",
"packaging",
"pinned_dependencies",
"signed_releases",
"token_permissions"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 41,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 12,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 6,
"scorecard_aggregate": 4.1
},
"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": "no pull request found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"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 0/30 approved changesets -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 6 contributing companies or organizations",
"points": 2.5,
"status": "met",
"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": "30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10",
"points": 7.5,
"status": "met",
"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": "no SAST tool detected",
"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": 1
},
"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": 36,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "at_risk",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 40,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 1,
"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": "72 of 72 human commits state their intent (structured subject or explanatory body)",
"points": 40,
"status": "met",
"details": [
{
"code": "legible_history",
"params": {
"legible": 72,
"sampled": 72
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "critical",
"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": 24,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": false,
"typed_language": false,
"bootstrap_files": [],
"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": null,
"points": 0,
"status": "missed",
"details": [],
"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 72",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_authored_commits",
"params": {
"sampled": 72
}
}
],
"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": 233470,
"source_files_sampled": 1475,
"oversized_source_files": 5
},
"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": "5/1475 source files over 60KB",
"points": 54.8,
"status": "partial",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 1475,
"oversized": 5
}
}
],
"max_points": 55
}
]
},
{
"key": "ai_interfaces",
"band": "at_risk",
"name": "Machine-readable interfaces",
"note": null,
"notes": [],
"value": 40,
"inputs": {
"example_dirs": [],
"has_mcp_signal": false,
"api_schema_files": [
"resources/proto/pg_query.proto"
]
},
"components": [
{
"key": "api_schema_openapi_graphql_proto",
"name": "API schema (OpenAPI/GraphQL/proto)",
"detail": "resources/proto/pg_query.proto",
"points": 40,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "resources/proto/pg_query.proto"
}
}
],
"max_points": 40
},
{
"key": "mcp_server",
"name": "MCP server",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "runnable_examples",
"name": "Runnable examples",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 40
}
]
}
],
"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": [
"No resolved dependencies carried a version and a supported ecosystem"
],
"report_type": "repository",
"generated_at": "2026-07-23T11:55:08.678284Z",
"schema_version": "0.27.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/f/flow-php/postgresql.svg",
"full_name": "flow-php/postgresql",
"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.27.0 — full methodology · metrics wiki.
How one result sits in the wider record: aggregate statistics — Packagist.