# constructive-io/constructive — health index 56/100 (Moderate)

> Inspection of the public repository constructive-io/constructive by inspect.software. It holds a health index of 56 out of 100, placing it in the Moderate band. The index is a signal derived from publicly visible practice, not a warranty, a security audit, or an endorsement, and it is independent of payment.

- Repository: https://github.com/constructive-io/constructive
- Report page: https://inspect.software/software/constructive-io/constructive
- Full JSON report: https://inspect.software/api/repositories/constructive-io/constructive/report
- Badge: https://raw.githubusercontent.com/inspect-software/badges/main/v1/c/constructive-io/constructive.svg
- Inspected: 2026-07-15
- Methodology: metrics 1.13.0, report schema 0.11.0 (https://inspect.software/methodology.md)

## Category summary

| Category | Weight | Index | Band |
|---|---|---|---|
| Vitality | 22% | 60/100 | Moderate |
| Community & Adoption | 18% | 41/100 | At risk |
| Sustainability & Governance | 24% | 47/100 | At risk |
| Engineering Quality | 20% | 82/100 | Good |
| Security | 16% | 46/100 | At risk |
| AI Readiness | not counted | 85/100 | Excellent |

## Repository facts

| Field | Value |
|---|---|
| Description | Secure, Modular Postgres for Teams |
| Homepage | https://constructive.io |
| Primary language | TypeScript |
| License | MIT |
| Stars | 49 |
| Forks | 7 |
| Created | 2024-12-28 |
| Last push | 2026-07-15 |
| Commits (last year) | 4,085 |
| Bus factor | 1 |

## Vitality — 60/100 (Moderate)

Is the project alive — is code being written and are releases shipping? Weight: 22% of the overall index.

### Development activity — 100/100 (Excellent)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Push recency | met | 36 / 36 | last push 0 days ago |
| Commit cadence | met | 36 / 36 | 52/52 weeks with commits |
| Commit volume | met | 18 / 18 | 4085 commits in the last year |
| OpenSSF Scorecard: Maintained | met | 10 / 10 | 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10 |

### Release discipline — 1/100 (Critical)

Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Ships releases | not met | 0 / 27 | no releases published |
| Release recency | not met | 0 / 36 | no releases |
| Release cadence | not met | 0 / 27 | no releases |
| OpenSSF Scorecard: Signed-Releases | excluded | 0 / 10 | no releases found |

### Abandonment — 100/100 (Excellent)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Project is still maintained | met | 100 / 100 | maintenance record not established from the collected data |

## Community & Adoption — 41/100 (At risk)

Does the project have users, downloads, attention, and a welcoming setup for contributors? Weight: 18% of the overall index.

### Popularity & adoption — 34/100 (At risk)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Stars | partial | 27.3 / 60 | 49 stars |
| Forks | partial | 6.5 / 25 | 7 forks |
| Watchers | not met | 0 / 15 | 2 watchers |

### Community health — 50/100 (Moderate)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| README | met | 22.5 / 22.5 | — |
| License | met | 22.5 / 22.5 | recognized license (MIT) |
| CONTRIBUTING guide | not met | 0 / 18 | — |
| Code of conduct | not met | 0 / 13.5 | — |
| Issue template | not met | 0 / 7.2 | — |
| PR template | not met | 0 / 6.3 | — |

## Sustainability & Governance — 47/100 (At risk)

Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep? Weight: 24% of the overall index.

### Maintainer resilience (bus factor) — 39/100 (At risk)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Bus factor | partial | 9 / 54 | 1 contributor(s) cover half of all commits |
| Commit distribution | partial | 6.1 / 22.5 | top contributor authored 73% of commits |
| Contributor breadth | met | 13.5 / 13.5 | 50 contributors |
| OpenSSF Scorecard: Contributors | met | 10 / 10 | project has 23 contributing companies or organizations |

### Issue & PR responsiveness — 52/100 (Moderate)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Issue resolution | partial | 23.7 / 46.8 | 51% of issues closed |
| PR acceptance | partial | 28.3 / 38.2 | 922/1246 decided PRs merged |
| OpenSSF Scorecard: Code-Review | not met | 0 / 15 | Found 1/13 approved changesets -- score normalized to 0 |

### Ownership & stewardship — 52/100 (Moderate)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Ownership backing | met | 30 / 30 | organization-owned |
| Verified domain | not met | 0 / 20 | — |
| Owner reach | partial | 7.5 / 25 | 10 followers of constructive-io |
| Track record | partial | 14.3 / 25 | 70 public repos, account ~0 yr old |

## Engineering Quality — 82/100 (Good)

Are baseline engineering and documentation practices in place? Weight: 20% of the overall index.

### Engineering practices — 84/100 (Good)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| CI workflows | met | 24 / 24 | 5 workflow(s) |
| Tests present | met | 24 / 24 | — |
| Linter config | met | 16 / 16 | .eslintrc.json |
| Pre-commit hooks | not met | 0 / 9.6 | — |
| .editorconfig | not met | 0 / 6.4 | — |
| OpenSSF Scorecard: CI-Tests | met | 20 / 20 | 8 out of 8 merged PRs checked by a CI test -- score normalized to 10 |

### Documentation — 80/100 (Good)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| README | met | 30 / 30 | — |
| Documentation directory | met | 25 / 25 | — |
| Documentation / homepage site | met | 15 / 15 | https://constructive.io |
| Repository description | met | 10 / 10 | — |
| Topics | not met | 0 / 10 | — |
| Wiki | not met | 0 / 10 | — |

## Security — 46/100 (At risk)

Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure? Weight: 16% of the overall index.

### Security posture — 46/100 (At risk)

Excluded from scoring (no data or not applicable): Signed-Releases. Remaining weights renormalized.

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Binary-Artifacts | met | 7.5 / 7.5 | no binaries found in the repo |
| Branch-Protection | not met | 0 / 7.5 | branch protection not enabled on development/release branches |
| CI-Tests | met | 2.5 / 2.5 | 8 out of 8 merged PRs checked by a CI test -- score normalized to 10 |
| CII-Best-Practices | not met | 0 / 2.5 | no effort to earn an OpenSSF best practices badge detected |
| Code-Review | not met | 0 / 7.5 | Found 1/13 approved changesets -- score normalized to 0 |
| Contributors | met | 2.5 / 2.5 | project has 23 contributing companies or organizations |
| Dangerous-Workflow | met | 10 / 10 | no dangerous workflow patterns detected |
| Dependency-Update-Tool | met | 7.5 / 7.5 | update tool detected |
| Fuzzing | not met | 0 / 5 | project is not fuzzed |
| License | met | 2.5 / 2.5 | license file detected |
| Maintained | met | 7.5 / 7.5 | 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10 |
| Packaging | met | 5 / 5 | packaging workflow detected |
| Pinned-Dependencies | not met | 0 / 5 | dependency not pinned by hash detected -- score normalized to 0 |
| SAST | not met | 0 / 5 | SAST tool is not run on all commits -- score normalized to 0 |
| Security-Policy | not met | 0 / 5 | security policy file not detected |
| Signed-Releases | excluded | 0 / 7.5 | no releases found |
| Token-Permissions | not met | 0 / 7.5 | detected GitHub workflow tokens with excessive permissions |
| Vulnerabilities | not met | 0 / 7.5 | 88 existing vulnerabilities detected |

### High-Risk Jurisdiction Exposure — 100/100 (Excellent)

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.

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Policy exposure multiplier | met | 100 / 100 | no confirmed policy-scope location match |

## AI Readiness — 85/100 (Excellent)

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.

### Agent context & guidance — 75/100 (Good)

Excluded from scoring (no data or not applicable): Legible commit history. Remaining weights renormalized.

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Agent instructions | met | 45 / 45 | .agents/skills/cli-agent/references/agent.md, .agents/skills/hooks-agent/references/agent.md, .agents/skills/orm-agent/references/agent.md, AGENTS.md, CLAUDE.md, graphql/codegen/AGENTS.md, packages/cli/AGENTS.md, pgpm/core/AGENTS.md, postgres/pgsql-test/AGENTS.md |
| Machine-readable docs (llms.txt) | not met | 0 / 15 | — |
| Legible commit history | excluded | 0 / 40 | no data |

### Verify loop (build / test / typecheck) — 88/100 (Excellent)

Excluded from scoring (no data or not applicable): Demonstrated agent practice, Automated maintenance. Remaining weights renormalized.

| Criterion | Status | Points | Detail |
|---|---|---|---|
| One-command bootstrap | met | 18 / 18 | Makefile, __fixtures__/sqitch/broken/packages/secrets/Makefile, __fixtures__/sqitch/constructive/packages/secrets/Makefile, __fixtures__/sqitch/constructive/packages/totp/Makefile, __fixtures__/sqitch/constructive/packages/utilities/Makefile, __fixtures__/sqitch/constructive/packages/utils/Makefile, __fixtures__/sqitch/constructive/packages/verify/Makefile, __fixtures__/sqitch/publish/packages/another/Makefile, __fixtures__/sqitch/publish/packages/secrets/Makefile, __fixtures__/sqitch/publish/packages/totp/Makefile, __fixtures__/sqitch/simple-w-exts/extensions/@pgpm/base32/Makefile, __fixtures__/sqitch/simple-w-exts/extensions/@pgpm/types/Makefile, __fixtures__/sqitch/simple-w-exts/extensions/@pgpm/uuid/Makefile, __fixtures__/sqitch/simple-w-exts/extensions/@pgpm/verify/Makefile, __fixtures__/sqitch/simple-w-exts/packages/sample-unique-names/Makefile, __fixtures__/sqitch/simple-w-tags/packages/my-first/Makefile, __fixtures__/sqitch/simple-w-tags/packages/my-second/Makefile, __fixtures__/sqitch/simple-w-tags/packages/my-third/Makefile, __fixtures__/sqitch/simple/packages/my-first/Makefile, __fixtures__/sqitch/simple/packages/my-second/Makefile, __fixtures__/sqitch/simple/packages/my-third/Makefile, docker/Makefile |
| Automated tests | met | 22 / 22 | — |
| Lint / format config | met | 11 / 11 | .eslintrc.json |
| Static type checking | met | 11 / 11 | agentic/agent/tsconfig.json, agentic/agentic-kit/tsconfig.json, agentic/agentic-server/tsconfig.json, agentic/anthropic/tsconfig.json, agentic/ollama/tsconfig.json, agentic/openai/tsconfig.json, agentic/protocol/tsconfig.json, agentic/react/tsconfig.json, examples/codegen-integration/tsconfig.json, examples/pglite-socket/tsconfig.json, functions/send-email/tsconfig.json, functions/send-verification-link/tsconfig.json, graphile/graphile-bucket-provisioner-plugin/tsconfig.json, graphile/graphile-bulk-mutations/tsconfig.json, graphile/graphile-cache/tsconfig.json, graphile/graphile-connection-filter/tsconfig.json, graphile/graphile-function-bindings/tsconfig.json, graphile/graphile-i18n/tsconfig.json, graphile/graphile-llm/tsconfig.json, graphile/graphile-ltree/tsconfig.json, graphile/graphile-pg-aggregates/tsconfig.json, graphile/graphile-plugin-utils/tsconfig.json, graphile/graphile-postgis/tsconfig.json, graphile/graphile-presigned-url-plugin/tsconfig.json, graphile/graphile-query/tsconfig.json, graphile/graphile-realtime-subscriptions/tsconfig.json, graphile/graphile-realtime-test/tsconfig.json, graphile/graphile-schema/tsconfig.json, graphile/graphile-search/tsconfig.json, graphile/graphile-settings/tsconfig.json, graphile/graphile-sql-expression-validator/tsconfig.json, graphile/graphile-test/tsconfig.json, graphile/graphile-upload-plugin/tsconfig.json, graphql/codegen/tsconfig.json, graphql/env/tsconfig.json, graphql/explorer/tsconfig.json, graphql/gql-ast/tsconfig.json, graphql/orm-test/tsconfig.json, graphql/playwright-test/tsconfig.json, graphql/query/tsconfig.json, graphql/react/tsconfig.json, graphql/realtime-test/tsconfig.json, graphql/server-test/tsconfig.json, graphql/server/tsconfig.json, graphql/test-app/tsconfig.json, graphql/test/tsconfig.json, graphql/types/tsconfig.json, jobs/job-pg/tsconfig.json, jobs/job-scheduler/tsconfig.json, jobs/job-utils/tsconfig.json, jobs/job-worker/tsconfig.json, jobs/knative-job-example/tsconfig.json, jobs/knative-job-fn/tsconfig.json, jobs/knative-job-server/tsconfig.json, jobs/knative-job-service/tsconfig.json, jobs/knative-job-worker/tsconfig.json, packages/12factor-env/tsconfig.json, packages/bucket-provisioner/tsconfig.json, packages/cli/tsconfig.json, packages/client/tsconfig.json, packages/csrf/tsconfig.json, packages/csv-to-pg/tsconfig.json, packages/express-context/tsconfig.json, packages/llm-env/tsconfig.json, packages/node-type-registry/tsconfig.json, packages/oauth/tsconfig.json, packages/orm/tsconfig.json, packages/postmaster/tsconfig.json, packages/safegres/tsconfig.json, packages/server-utils/tsconfig.json, packages/smtppostmaster/tsconfig.json, packages/upload-client/tsconfig.json, packages/url-domains/tsconfig.json, pgpm/cli/tsconfig.json, pgpm/core/tsconfig.json, pgpm/env/tsconfig.json, pgpm/export/tsconfig.json, pgpm/logger/tsconfig.json, pgpm/types/tsconfig.json, postgres/constructive-test/tsconfig.json, postgres/drizzle-orm-test/tsconfig.json, postgres/insforge-test/tsconfig.json, postgres/introspectron/tsconfig.json, postgres/pg-ast/tsconfig.json, postgres/pg-cache/tsconfig.json, postgres/pg-codegen/tsconfig.json, postgres/pg-env/tsconfig.json, postgres/pg-query-context/tsconfig.json, postgres/pg-seed/tsconfig.json, postgres/pglite-adapter/tsconfig.json, postgres/pglite-test/tsconfig.json, postgres/pgsql-client/tsconfig.json, postgres/pgsql-seed/tsconfig.json, postgres/pgsql-test/tsconfig.json, postgres/query-builder/tsconfig.json, postgres/supabase-test/tsconfig.json, sdk/constructive-cli/tsconfig.json, sdk/constructive-react/tsconfig.json, sdk/constructive-sdk/tsconfig.json, sdk/migrate-client/tsconfig.json, tsconfig.json, uploads/content-type-stream/tsconfig.json, uploads/etag-hash/tsconfig.json, uploads/etag-stream/tsconfig.json, uploads/mime-bytes/tsconfig.json, uploads/s3-streamer/tsconfig.json, uploads/s3-utils/tsconfig.json, uploads/stream-to-etag/tsconfig.json, uploads/upload-names/tsconfig.json, uploads/uuid-hash/tsconfig.json, uploads/uuid-stream/tsconfig.json |
| Reproducible environment | met | 10 / 10 | Dockerfile, lockfile |
| Demonstrated agent practice | excluded | 0 / 10 | no data |
| Automated maintenance | excluded | 0 / 8 | no data |
| OpenSSF Scorecard: Pinned-Dependencies | not met | 0 / 10 | dependency not pinned by hash detected -- score normalized to 0 |

### Code legibility for models — 100/100 (Excellent)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| Type-checkable code | met | 45 / 45 | TypeScript (statically typed) |
| Manageable file sizes | partial | 54.5 / 55 | 42/4255 source files over 60KB |

### Machine-readable interfaces — 80/100 (Good)

| Criterion | Status | Points | Detail |
|---|---|---|---|
| API schema (OpenAPI/GraphQL/proto) | met | 40 / 40 | graphql/codegen/examples/example.schema.graphql, graphql/test-app/schema.graphql, postgres/pg-ast/pg_query.proto, sdk/constructive-sdk/schemas/admin.graphql, sdk/constructive-sdk/schemas/agent.graphql, sdk/constructive-sdk/schemas/api.graphql, sdk/constructive-sdk/schemas/auth.graphql, sdk/constructive-sdk/schemas/compute.graphql, sdk/constructive-sdk/schemas/config.graphql, sdk/constructive-sdk/schemas/infra.graphql, sdk/constructive-sdk/schemas/modules.graphql, sdk/constructive-sdk/schemas/objects.graphql, sdk/constructive-sdk/schemas/usage.graphql, sdk/migrate-client/schemas/migrate.graphql |
| MCP server | not met | 0 / 20 | — |
| Runnable examples | met | 40 / 40 | examples |

## What this report is

inspect.software measures public repositories against a single published, versioned methodology and reports the result as a 1–100 health index. Findings are signals derived from what is visible in public repository data — they are not a security audit, a warranty, or an endorsement, and no result depends on payment.

- Methodology, formulas and weights: https://inspect.software/methodology.md
- What a result does and does not claim: https://inspect.software/wiki/signals-not-warranties.md
- Rating bands: https://inspect.software/wiki/scoring-bands.md
- Corrections: https://inspect.software/contact.md
- Index of all documents: https://inspect.software/llms.txt